TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `TrBeliAdd` AFTER INSERT ON `tr_beli_m` FOR EACH ROW BEGIN\n  Update tm_Supplier set Hutang =  ifnull(hutang,0) + (new.nilai * new.exrate) \n  where kodesupp = new.kodesupp;\nend' 'CREATE DEFINER=`root`@`localhost` TRIGGER `TrBeliUpdate` AFTER UPDATE ON `tr_beli_m` FOR EACH ROW BEGIN\n  Update tm_Supplier set Hutang =  ifnull(hutang,0) + (new.nilai * new.exrate)\n  where kodesupp = new.kodesupp;\n  Update tm_Supplier set Hutang =  ifnull(hutang,0) - (old.nilai * old.exrate)\n  where kodesupp = old.kodesupp;\nend' 'CREATE DEFINER=`root`@`localhost` TRIGGER `TrBeliDelete` AFTER DELETE ON `tr_beli_m` FOR EACH ROW BEGIN\n  Update tm_Supplier set Hutang =  ifnull(hutang,0) - (Old.nilai * Old.exrate) \n  where kodesupp = Old.kodesupp;\nend'
sql_modes=524288 524288 524288
definers='root@localhost' 'root@localhost' 'root@localhost'
