TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `inc_quick_name` AFTER INSERT ON `income`\n FOR EACH ROW INSERT INTO `quick_name`(`acc_no`, `name`)
\nselect `l`.`code` AS `acc_no`,concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`) AS `name` from (`income` `l` join `applicant` `a`) where ((`a`.`Acc_No` = `l`.`code`) and (`l`.`shlip_no` like \'SV-D%\')) and l.no=new.no and not EXISTS (SELECT d1.acc_no from quick_name d1 WHERE l.code=d1.acc_no ) group by `l`.`code`
\nunion all select `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`income` `i` join `sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'INC%\'))and i.no=new.no'
sql_modes=524288
definers='root@localhost'
client_cs_names='utf8'
connection_cl_names='utf8_general_ci'
db_cl_names='latin1_swedish_ci'
