File indexing completed on 2024-04-28 17:16:08
0001 DROP TRIGGER IF EXISTS `comment_update`; 0002 0003 DELIMITER $$ 0004 0005 CREATE DEFINER = CURRENT_USER TRIGGER `comment_update` 0006 BEFORE UPDATE 0007 ON `comments` 0008 FOR EACH ROW 0009 BEGIN 0010 0011 IF `NEW`.`comment_active` = 0 AND `OLD`.`comment_active` = 1 THEN 0012 0013 UPDATE `project` `p` 0014 SET `p`.`count_comments` = (`p`.`count_comments` - 1) 0015 WHERE `p`.`project_id` = `NEW`.`comment_target_id`; 0016 0017 SET `NEW`.`comment_deleted_at` = NOW(); 0018 0019 END IF; 0020 0021 IF `NEW`.`comment_active` = 1 AND `OLD`.`comment_active` = 0 THEN 0022 0023 UPDATE `project` `p` 0024 SET `p`.`count_comments` = (`p`.`count_comments` + 1) 0025 WHERE `p`.`project_id` = `NEW`.`comment_target_id`; 0026 0027 SET `NEW`.`comment_deleted_at` = NULL; 0028 0029 END IF; 0030 0031 END$$ 0032 DELIMITER ;