TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `DETKOREKSIADD` AFTER INSERT ON `tr_koreksistc_d` FOR EACH ROW BEGIN\n  update TM_STOCKBRG SET STOCKAKHIR =IFNULL(NEW.JMLSESUDAH,0) WHERE KODEBRG = NEW.KODEBRG AND KODEGD = NEW.KODEGD;\nEND' 'CREATE DEFINER=`root`@`localhost` TRIGGER `DETKOREKSIUPDATE` AFTER UPDATE ON `tr_koreksistc_d` FOR EACH ROW BEGIN\n  update TM_STOCKBRG SET STOCKAKHIR =IFNULL(OLD.JMLSESUDAH,0) WHERE KODEBRG = OLD.KODEBRG AND KODEGD = OLD.KODEGD;\nEND' 'CREATE DEFINER=`root`@`localhost` TRIGGER `DETKOREKSIDELETE` AFTER DELETE ON `tr_koreksistc_d` FOR EACH ROW BEGIN\n  update TM_STOCKBRG SET STOCKAKHIR =IFNULL(OlD.JMLSebelum,0) WHERE KODEBRG = Old.KODEBRG AND KODEGD = Old.KODEGD;\nEND'
sql_modes=524288 524288 524288
definers='root@localhost' 'root@localhost' 'root@localhost'
