TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `mbankacc_quickname_del` BEFORE DELETE ON `mstr_bnk_acc`
\n FOR EACH ROW DELETE hv.* FROM `quick_name` hv,mstr_bnk_acc v WHERE v.acc_no=hv.acc_no and hv.acc_no=old.acc_no' 'CREATE DEFINER=`root`@`localhost` TRIGGER `mth_quick_name` AFTER INSERT ON `mstr_bnk_acc` FOR EACH ROW INSERT INTO `quick_name`(`acc_no`, `name`,sbacc)
\nselect `d`.`acc_no` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name`,d.fd_sv_acc_no from (`mstr_bnk_acc` `d` join `applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) and d.id=new.id group by `a`.`Acc_No`'
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'
