1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
| -- ============================
-- Trigger `Trigger_histoSerie`
-- ============================
DROP TRIGGER IF EXISTS `Trigger_histoSerie`;
DELIMITER $$
CREATE TRIGGER Trigger_histoSerie AFTER UPDATE
ON serie FOR EACH ROW
BEGIN
DECLARE maj DATETIME;
SET maj=now();
INSERT INTO histo_Serie
( Serie, Type, Agent, SectTO, DateVerif, DatePreavis, DatePeremption, Lieux, Observation, Conformiter, dateUptdate) VALUES
(OLD.Serie, OLD.Type, OLD.Agent, OLD.SectTO, OLD.DateVerif, OLD.DatePreavis, OLD.DatePeremption, OLD.Lieux, OLD.Observation, OLD.Conformiter, maj);
END$$
DELIMITER ; |
Partager