TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `loan_quick_name` AFTER INSERT ON `loan_acc` FOR EACH ROW INSERT INTO `quick_name`(`acc_no`, `name`,sbacc,lfno)
\nselect `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`,\'  \',d.name_p) AS `name`,loan_against_sv_acc,d.lf_no from (`loan_acc` `d` join `applicant` `a`) where (`d`.`app_code` = `a`.`code`) and  not EXISTS (SELECT d1.acc_no from quick_name d1 WHERE d.acc_no=d1.acc_no ) and d.no=new.no group by `d`.`acc_no`' 'CREATE DEFINER=`root`@`localhost` TRIGGER `loan_quickname_del` BEFORE DELETE ON `loan_acc` FOR EACH ROW DELETE hv.* FROM `quick_name` hv,loan_acc v WHERE v.acc_no=hv.acc_no and vch_no LIKE \'%NL%\' and v.id=old.id'
sql_modes=1073741824 1073741824
definers='root@localhost' 'root@localhost'
client_cs_names='utf8' 'utf8'
connection_cl_names='utf8_general_ci' 'utf8_general_ci'
db_cl_names='latin1_swedish_ci' 'latin1_swedish_ci'
