TYPE=TRIGGERS
triggers='CREATE DEFINER=`admin`@`localhost` TRIGGER `smsfacility` AFTER INSERT ON `headvoucher` FOR EACH ROW BEGIN DECLARE trigger_active TINYINT; SELECT is_enabled INTO trigger_active FROM trigger_control WHERE trigger_name = \'smsfacility\'; IF trigger_active = 1 THEN 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 IN (\'14101\', \'14108\', \'14201\', \'14209\', \'14802\', \'14208\', \'14801\')) AND h.no = NEW.no; END IF; END'
sql_modes=1073741824
definers='admin@localhost'
client_cs_names='utf8mb4'
connection_cl_names='utf8mb4_general_ci'
db_cl_names='latin1_swedish_ci'
