TYPE=TRIGGERS
triggers='CREATE DEFINER=`root`@`localhost` TRIGGER `sdd_inspecciones_resoluciones_after_ins_tr` AFTER INSERT ON `sdd_inspecciones_resoluciones`\n  FOR EACH ROW\nBEGIN\n     IF NEW.c8_estado = \'CERRADO\' THEN\n          UPDATE sdm_inspecciones SET i2_estado_inspeccion_id = "4" WHERE i8_inspeccion_id = NEW.i8_inspeccion_id;\n          UPDATE sdd_inspecciones_observaciones SET c8_estado = "CERRADO" WHERE i8_inspeccion_id = NEW.i8_inspeccion_id;\n\n     END IF;\nEND'
sql_modes=1344274432
definers='root@localhost'
client_cs_names='latin1'
connection_cl_names='latin1_swedish_ci'
db_cl_names='utf8_general_ci'
created=152366985733
