TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `DetJualRakitanAdd` AFTER INSERT ON `tr_jualrakitan_d` FOR EACH ROW BEGIN\nDECLARE vtemp double;\n select stockakhir-new.jml into vtemp from tm_stockbrg where kodebrg=new.kodebrg and kodeGd= new.KodeGD;\n   Update tm_stockbrg set Stockakhir =  stockakhir-new.jml\n   where kodebrg=new.kodebrg and kodeGd= new.KodeGD;\nend' 'CREATE DEFINER=`root`@`localhost` TRIGGER `DetJualRakitanUpdate` AFTER UPDATE ON `tr_jualrakitan_d` FOR EACH ROW BEGIN\n DECLARE vtemp double;\n select stockakhir-(new.jml-old.jml) into vtemp from tm_stockbrg where kodebrg=new.kodebrg and kodeGd= new.KodeGD;\n   Update tm_stockbrg set Stockakhir =  stockakhir+old.jml\n   where kodebrg=old.kodebrg and kodeGd= old.KodeGD;\n   Update tm_stockbrg set Stockakhir =  stockakhir-new.jml\n   where kodebrg=new.kodebrg and kodeGd= new.KodeGD;\nend' 'CREATE DEFINER=`root`@`localhost` TRIGGER `DetJualRakitanDelete` AFTER DELETE ON `tr_jualrakitan_d` FOR EACH ROW BEGIN\n  Update tm_stockbrg set Stockakhir =  stockakhir+old.jml \n  where kodebrg=Old.kodebrg and kodeGd= Old.KodeGD;\nend'
sql_modes=524288 524288 524288
definers='root@localhost' 'root@localhost' 'root@localhost'
