TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER tbl_item_class_after_upd_tr AFTER UPDATE ON tbl_item_class FOR EACH ROW
\nBEGIN
\nIF (@DISABLE_TRIGGERS IS NULL) then
\nUPDATE `tbl_item` SET
\n`tbl_item`.`it_cl_code`=NEW.cl_code,
\n`tbl_item`.`it_cl_name`=NEW.cl_name
\nWHERE `tbl_item`.`it_id_class`=NEW.cl_id;
\nEND IF;
\nEND' 'CREATE DEFINER=`root`@`localhost` TRIGGER tbl_item_class_before_ins_tr BEFORE INSERT ON tbl_item_class FOR EACH ROW
\nBEGIN
\nIF (@DISABLE_TRIGGERS IS NULL) then
\nIF ISNULL(NEW.cl_uuid) THEN
\nSET NEW.cl_uuid := UPPER(UUID());
\nEND IF;
\nEND IF;
\nEND'
sql_modes=1344274434 1344274434
definers='root@localhost' 'root@localhost'
client_cs_names='cp1256' 'cp1256'
connection_cl_names='cp1256_general_ci' 'cp1256_general_ci'
db_cl_names='cp1256_general_ci' 'cp1256_general_ci'
