TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `TrJualRakitanAdd` AFTER INSERT ON `tr_jualrakitan_m` FOR EACH ROW BEGIN\n  Update tm_Customer set Piutang =  ifnull(piutang,0) + ((new.nilai-new.bayartunai-new.bayarcard-new.bayarvoucher)*new.exrate)\n  where kodecust = new.kodecust;\nend' 'CREATE DEFINER=`root`@`localhost` TRIGGER `TrJualRakitanUpdate` AFTER UPDATE ON `tr_jualrakitan_m` FOR EACH ROW BEGIN\n  Update tm_Customer set Piutang =  ifnull(piutang,0) + ((new.nilai-new.bayartunai-new.bayarcard-new.bayarvoucher)*new.exrate)\n  where kodecust = new.kodecust;\n  Update tm_Customer set Piutang =  ifnull(piutang,0) - ((old.nilai-old.bayartunai-old.bayarcard-old.bayarvoucher)*old.exrate)\n  where kodecust = old.kodecust;\nend' 'CREATE DEFINER=`root`@`localhost` TRIGGER `TrJualRakitanDelete` AFTER DELETE ON `tr_jualrakitan_m` FOR EACH ROW BEGIN\n  Update tm_Customer set Piutang =  ifnull(piutang,0) - ((old.nilai-old.bayartunai-old.bayarcard-old.bayarvoucher) * Old.exrate) \n  where kodecust = Old.kodecust;\nend'
sql_modes=524288 524288 524288
definers='root@localhost' 'root@localhost' 'root@localhost'
