TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER tbl_invoice_list_after_del_tr AFTER DELETE ON tbl_invoice_list FOR EACH ROW
\nBEGIN
\nIF (@DISABLE_TRIGGERS IS NULL) then
\nUPDATE tbl_invoice_type SET in_type_count=in_type_count-1 WHERE in_type_id=OLD.in_list_type_id;
\nEND IF;
\nEND' 'CREATE DEFINER=`root`@`localhost` TRIGGER tbl_invoice_list_after_ins_tr AFTER INSERT ON tbl_invoice_list FOR EACH ROW
\nBEGIN
\nIF (@DISABLE_TRIGGERS IS NULL) then
\nUPDATE tbl_invoice_type SET in_type_count=in_type_count+1 WHERE in_type_id=NEW.in_list_type_id;
\nEND IF;
\nEND' 'CREATE DEFINER=`root`@`localhost` TRIGGER tbl_invoice_list_before_ins_tr BEFORE INSERT ON tbl_invoice_list FOR EACH ROW
\nBEGIN
\nIF (@DISABLE_TRIGGERS IS NULL) then
\nIF ISNULL(NEW.in_list_xid) OR NEW.in_list_xid=0 THEN
\nset NEW.in_list_xid=func_get_next_id(27);
\nEND IF;
\nEND IF;
\nEND'
sql_modes=1344274434 1344274434 1344274434
definers='root@localhost' 'root@localhost' 'root@localhost'
client_cs_names='cp1256' 'cp1256' 'cp1256'
connection_cl_names='cp1256_general_ci' 'cp1256_general_ci' 'cp1256_general_ci'
db_cl_names='cp1256_general_ci' 'cp1256_general_ci' 'cp1256_general_ci'
