TYPE=TRIGGERS
triggers='CREATE DEFINER=`admin`@`localhost` TRIGGER `headdelete` BEFORE DELETE ON `voucher`\n FOR EACH ROW DELETE hv.* FROM `headvoucher` hv,voucher v WHERE v.no=hv.no and hv.no=old.no' 'CREATE DEFINER=`admin`@`localhost` TRIGGER `headupdate` AFTER UPDATE ON `voucher`\n FOR EACH ROW update voucher v,headvoucher hv set hv.cr=v.cr,hv.dr=v.dr,hv.date=v.date,hv.shcode=v.sub_head,hv.hcode=v.head,hv.deposit_type=v.deposit_type where  v.no=hv.no and hv.no=new.no' 'CREATE DEFINER=`admin`@`localhost` TRIGGER `headvoucher` AFTER INSERT ON `voucher`\n FOR EACH ROW INSERT INTO `headvoucher`(`no`, `vch_no`, `acc_no`, `cr`, `dr`, `date`, `shcode`, `sub_head`, `hcode`, `type`, `head`, `htcode`, `head_type`, `main_head`, deperment, cash_acc, SLNO, vch_type, deposit_type,csl_no,hslno) 
\nselect v.no,v.vch_no, `v`.`Acc_no` AS `acc_no`,`v`.`cr` AS `cr`,`v`.`dr` AS `dr`,`v`.`date` AS `date`,`h`.`shcode` AS `shcode`,`h`.`sub_head` AS `sub_head`,`h`.`hcode` AS `hcode`,`h`.`type` AS `type`,`h`.`head` AS `head`,`h`.`htcode` AS `htcode`,`h`.`head_type` AS `head_type`,`h`.`main_head` AS `main_head`,v.deperment,v.cash_acc,H.SL_NO,v.vch_type,v.deposit_type,csl_no,hslno from (`voucher` `v` join `heads` `h`) where (`h`.`shcode` = `v`.`sub_head`) and v.no=new.no'
sql_modes=524288 524288 524288
definers='admin@localhost' 'admin@localhost' 'admin@localhost'
client_cs_names='utf8' 'utf8' 'utf8'
connection_cl_names='utf8_general_ci' 'utf8_general_ci' 'utf8_general_ci'
db_cl_names='latin1_swedish_ci' 'latin1_swedish_ci' 'latin1_swedish_ci'
