DROP TRIGGER IF EXISTS `insert_charac_manage_info`;
DELIMITER ;;
CREATE TRIGGER `insert_charac_manage_info` BEFORE INSERT ON `charac_stat` FOR EACH ROW insert into taiwan_cain.charac_manage_info (charac_no, max_equip_level) values (new.charac_no,85);;
DELIMITER ;
DROP TRIGGER IF EXISTS `update_charac_stat`;
DELIMITER ;;
CREATE TRIGGER `update_charac_stat` BEFORE UPDATE ON `charac_stat` FOR EACH ROW IF new.village =13 THEN