TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `DetBuangGdAdd` AFTER INSERT ON `tr_buanggd_d` FOR EACH ROW BEGIN\n  Update tm_stockbrg set Stockakhir =  ifnull(stockakhir,0)-new.jumlah*new.konv where kodeGd= new.KodeGDAsal and kodebrg=new.kodebrg;\nEND' 'CREATE DEFINER=`root`@`localhost` TRIGGER `DetBuangGdUpdate` AFTER UPDATE ON `tr_buanggd_d` FOR EACH ROW BEGIN\n  Update tm_stockbrg set Stockakhir =  ifnull(stockakhir,0)+old.Jumlah*old.konv where kodeGd= old.KodeGDasal and kodebrg=old.kodebrg;\n  Update tm_stockbrg set Stockakhir =  ifnull(stockakhir,0)-new.Jumlah*new.konv where kodeGd= new.KodeGDasal and kodebrg=new.kodebrg;\nEND' 'CREATE DEFINER=`root`@`localhost` TRIGGER `DetBuangGdDelete` AFTER DELETE ON `tr_buanggd_d` FOR EACH ROW BEGIN\n  Update tm_stockbrg set Stockakhir =  ifnull(stockakhir,0)+old.Jumlah*old.konv where kodeGd= old.KodeGDAsal and kodebrg=old.kodebrg;\nEND'
sql_modes=524288 524288 524288
definers='root@localhost' 'root@localhost' 'root@localhost'
