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`, bal, SUBSTRING(vch_type,1,12), `deposit_type`, \'\', `vch_no` FROM `headvoucher` h,acc_bal b WHERE   b.acc_no=h.acc_no and (`htcode` = \'14000\') 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'
