TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `app_quick_name` AFTER INSERT ON `deposit_acc`\n FOR EACH ROW INSERT INTO `quick_name`(`acc_no`, `name`,sbacc,lfno)
\nselect `d`.`acc_no` AS `acc_no`,( concat(`a`.`fname`,\' \',`a`.`mname`,\' \',`a`.`lname`,if(operation_type=\'Either or Survier\' OR operation_type=\'Joint A/C\',IF(sub_head=\'14201\',\'\',\' & OTHERS\'),\'\'))  ) AS `name`,fd_sv_acc_no,d.lf_no from (`deposit_acc` `d` join `applicant` `a`) where (`d`.`acc_no` = `a`.`Acc_No`) and a.fname<>\'\' and d.id=new.id group by `a`.`Acc_No`' 'CREATE DEFINER=`root`@`localhost` TRIGGER `deposit_quickname_del` BEFORE DELETE ON `deposit_acc`\n FOR EACH ROW DELETE hv.* FROM `quick_name` hv,deposit_acc v WHERE v.acc_no=hv.acc_no and hv.acc_no=old.acc_no'
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'
