USE taiwan_cain;
DROP TRIGGER IF EXISTS `update_charac_tower_despair`;
DELIMITER //
CREATE TRIGGER `update_charac_tower_despair` BEFORE UPDATE ON `charac_tower_despair`
FOR EACH ROW
BEGIN
IF NEW.today_enter_count = 1 THEN
SET NEW.today_enter_count = -99;
END IF;
END //
DELIMITER ;
DROP TRIGGER IF EXISTS `update_charac_tower_despair`;
DELIMITER //
CREATE TRIGGER `update_charac_tower_despair` BEFORE UPDATE ON `charac_tower_despair`
FOR EACH ROW
BEGIN
IF NEW.today_enter_count = 1 THEN
SET NEW.today_enter_count = -99;
END IF;
END //
DELIMITER ;