CMS-CSE/maj/sql/maj.sql

ALTER TABLE `banque_lignes` ADD `creer` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP AFTER `md5`; 

CREATE TABLE `alertesEmails` (
  `id` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `id_user` int NOT NULL,
  `heure` tinyint NOT NULL,
  `jour` tinyint NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

ALTER TABLE `alertesEmails`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_user_alertes` (`id_user`);

ALTER TABLE `alertesEmails`
  ADD CONSTRAINT `id_user_alertes` FOREIGN KEY (`id_user`) REFERENCES `user` (`id`);
COMMIT;