TYPE=TRIGGERS
triggers='CREATE DEFINER=`admin`@`localhost` TRIGGER `smsfacility` AFTER INSERT ON `headvoucher` FOR EACH ROW INSERT INTO `smsfacility`( `date`, `acc_no`, `cr`, `dr`, `cls_bal`, `purpush`, `trantype`, `phone`, vch_no)  SELECT  `date`, h.`acc_no`, `cr`, `dr`,round(acc_bal(h.acc_no),2) as bal, `vch_type`, `deposit_type`, \'\', `vch_no` FROM `headvoucher` h WHERE (shcode=\'14101\' or shcode=\'14108\' or shcode=\'14201\' or shcode=\'14209\' or shcode=\'14802\' or shcode=\'14208\' or shcode=\'14801\')  and h.no=new.no'
sql_modes=1073741824
definers='admin@localhost'
client_cs_names='utf8'
connection_cl_names='utf8_general_ci'
db_cl_names='latin1_swedish_ci'
