File indexing completed on 2024-04-21 06:00:37 

0001 DELIMITER $$
0002 DROP TRIGGER IF EXISTS `trg_project_major_updated_at`$$
0003 CREATE DEFINER ='root' TRIGGER `trg_project_major_updated_at`
0004     BEFORE UPDATE
0005     ON `project`
0006     FOR EACH ROW
0007 BEGIN
0008     IF `NEW`.`changed_at` <> `OLD`.`changed_at` AND DATEDIFF(`NEW`.`changed_at`, `OLD`.`major_updated_at`) > 6 THEN
0009         SET `NEW`.`major_updated_at` = `NEW`.`changed_at`;
0010     END IF;
0011 END$$
0012 DELIMITER ;