*************************** 1. row ***************************
           TRIGGER_CATALOG: NULL
            TRIGGER_SCHEMA: NMS
              TRIGGER_NAME: after_insert_graph_to_servers
        EVENT_MANIPULATION: INSERT
      EVENT_OBJECT_CATALOG: NULL
       EVENT_OBJECT_SCHEMA: NMS
        EVENT_OBJECT_TABLE: graph_to_servers
              ACTION_ORDER: 0
          ACTION_CONDITION: NULL
          ACTION_STATEMENT: BEGIN
  UPDATE `graph` SET resource_ids=CONCAT((SELECT GROUP_CONCAT(outID SEPARATOR ':') FROM NMS.server, NMS.switch_port, NMS.resource, NMS.graph_to_servers, my
natnet.servers WHERE resource.rID=server.rID AND monitor>0 AND server.rID=switch_port.sID AND server.name LIKE servers.name AND servers.asset_id=graph_to_s
ervers.server_id AND graph_to_servers.graph_id=NEW.graph_id ORDER BY inID), ' ', (SELECT GROUP_CONCAT(inID SEPARATOR ':') FROM NMS.server, NMS.switch_port,
 NMS.resource, NMS.graph_to_servers, mynatnet.servers WHERE resource.rID=server.rID AND monitor>0 AND server.rID=switch_port.sID AND server.name LIKE serve
rs.name AND servers.asset_id=graph_to_servers.server_id AND graph_to_servers.graph_id=NEW.graph_id ORDER BY inID)), encoding=MD5(resource_ids) WHERE graph_
id=NEW.graph_id;
END
        ACTION_ORIENTATION: ROW
             ACTION_TIMING: AFTER
ACTION_REFERENCE_OLD_TABLE: NULL
ACTION_REFERENCE_NEW_TABLE: NULL
  ACTION_REFERENCE_OLD_ROW: OLD
  ACTION_REFERENCE_NEW_ROW: NEW
                   CREATED: NULL
                  SQL_MODE:
                   DEFINER: sysadmin@localhost
*************************** 2. row ***************************
           TRIGGER_CATALOG: NULL
            TRIGGER_SCHEMA: NMS
              TRIGGER_NAME: after_delete_graph_to_servers
        EVENT_MANIPULATION: DELETE
      EVENT_OBJECT_CATALOG: NULL
       EVENT_OBJECT_SCHEMA: NMS
        EVENT_OBJECT_TABLE: graph_to_servers
              ACTION_ORDER: 0
          ACTION_CONDITION: NULL
          ACTION_STATEMENT: BEGIN
  UPDATE `graph` SET resource_ids=CONCAT((SELECT GROUP_CONCAT(outID SEPARATOR ':') FROM NMS.server, NMS.switch_port, NMS.resource, NMS.graph_to_servers, my
natnet.servers WHERE resource.rID=server.rID AND monitor>0 AND server.rID=switch_port.sID AND server.name LIKE servers.name AND servers.asset_id=graph_to_s
ervers.server_id AND graph_to_servers.graph_id=OLD.graph_id ORDER BY inID), ' ', (SELECT GROUP_CONCAT(inID SEPARATOR ':') FROM NMS.server, NMS.switch_port,
 NMS.resource, NMS.graph_to_servers, mynatnet.servers WHERE resource.rID=server.rID AND monitor>0 AND server.rID=switch_port.sID AND server.name LIKE serve
rs.name AND servers.asset_id=graph_to_servers.server_id AND graph_to_servers.graph_id=OLD.graph_id ORDER BY inID)), encoding=MD5(resource_ids) WHERE graph_
id=OLD.graph_id;
END
        ACTION_ORIENTATION: ROW
             ACTION_TIMING: AFTER
ACTION_REFERENCE_OLD_TABLE: N  ACTION_REFERENCE_OLD_ROW: OLD
  ACTION_REFERENCE_NEW_ROW: NEW
                   CREATED: NULL
                  SQL_MODE:
                   DEFINER: sysadmin@localhost
2 rows in set (0.09 sec)