CMS-CSE/maj/sql/maj.sql

UPDATE `type_access` SET `id` = '4#16' WHERE `type_access`.`id_type` = 4 AND `type_access`.`id_access` = 16; 
DELETE FROM type_access WHERE `type_access`.`id` = '6#1'
INSERT INTO `type_access` (`id`, `id_type`, `id_access`) VALUES ('6#16', '6', '16');
ALTER TABLE `type_access` ADD `exception` VARCHAR(1000) NULL AFTER `id_access`; 
UPDATE `type_access` SET `exception` = 'salaire' WHERE `type_access`.`id` = '4#16'; 
UPDATE `type_access` SET `exception` = 'salaire' WHERE `type_access`.`id` = '6#16';