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