TYPE=TRIGGERS
triggers='CREATE DEFINER=root@localhost TRIGGER `pur_quick_name` AFTER INSERT ON `purchase_e`\n FOR EACH ROW INSERT INTO `quick_name`(`acc_no`, `name`)
\nselect `i`.`code` AS `acc_no`,if((`i`.`Exp_details` = \'\'),`s`.`sub_head`,`i`.`Exp_details`) AS `name` from (`purchase_e` `i` join `sub_head` `s`) where ((`s`.`code` = `i`.`sub_head`) and (`i`.`code` like \'PUR%\')) 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'
