CMS-CSE/maj/sql/maj.sql

CREATE TABLE `clients` (
    `id` int NOT NULL,
    `label` tinytext COLLATE utf8mb4_general_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

ALTER TABLE `clients` CHANGE `id` `id` INT NOT NULL AUTO_INCREMENT, add PRIMARY KEY (`id`); 
ALTER TABLE `documents` ADD `id_client` INT NULL AFTER `montant`; 
ALTER TABLE `documents` ADD CONSTRAINT `id_client` FOREIGN KEY (`id_client`) REFERENCES `clients`(`id`) ON DELETE NO ACTION ON UPDATE NO ACTION; 

UPDATE `type_document` SET `label` = 'Facture' WHERE `type_document`.`id` = 1; 
UPDATE `access` SET `access` = 'parametre*\r\nparametres\r\nadd-user\r\nmaj\r\ntag*\r\nclient*' WHERE `access`.`id` = 3;