CMS-CSE/maj/sql/maj.sql

CREATE TABLE `jwt` (
    `id_user` int NOT NULL,
    `md5` varchar(32) NOT NULL,
    `jwt` text NOT NULL,
    `creer` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

ALTER TABLE `jwt`
    ADD KEY `user_jwt` (`id_user`);

ALTER TABLE `jwt`
    ADD CONSTRAINT `user_jwt` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`);

INSERT INTO `type_access` (`id`, `id_type`, `id_access`, `exception`) VALUES ('7#16', '7', '16');
INSERT INTO `type_access` (`id`, `id_type`, `id_access`, `exception`) VALUES ('6#17', '6', '17', 'salaire');
INSERT INTO `type_access` (`id`, `id_type`, `id_access`, `exception`) VALUES ('5#17', '5', '17', 'salaire');
INSERT INTO `type_access` (`id`, `id_type`, `id_access`, `exception`) VALUES ('4#17', '4', '17', 'salaire');