--
-- Déclencheurs `VOL`
--
DROP TRIGGER IF EXISTS `chkTime`;

DELIMITER //
CREATE TRIGGER `chkTime` BEFORE INSERT ON `VOL`
 FOR EACH ROW begin
	if new.HEURE_ARR <= new.HEURE_DEP
	then
		set new.HEURE_ARR = new.HEURE_DEP + interval 1 HOUR;
	end if ;
end
//
DELIMITER ;

