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`);

UPDATE `access` SET `access` = 'document*\r\ndocuments*', `add` = '0' WHERE `access`.`id` = 16;

INSERT INTO `access` (`id`, `label`, `show`, `add`, `access`, `noAccess`) VALUES
(17, 'Documents', 0, 1, 'add-document', '');

INSERT INTO `type_access` (`id`, `id_type`, `id_access`, `exception`) VALUES ('7#16', '7', '16', NULL);
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');