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