TYPE=TRIGGERS
triggers='CREATE DEFINER=root@localhost TRIGGER `lib_quick_name` AFTER INSERT ON `libities`\n FOR EACH ROW INSERT INTO `quick_name`(`acc_no`, `name`)
\nselect `i`.`code` AS `acc_no`,if((`i`.`draw_bank` = \'\'),`s`.`sub_head`,`i`.`draw_bank`) AS `name` from (`libities` `i` join `sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'LIB%\'))  and i.no=new.no and  not EXISTS (SELECT d1.acc_no from quick_name d1 WHERE i.code=d1.acc_no )'
sql_modes=1073741824
definers='root@localhost'
client_cs_names='utf8'
connection_cl_names='utf8_general_ci'
db_cl_names='latin1_swedish_ci'
