-- Table structure for table `sym_node_group_channel_wnd`
--

CREATE TABLE `sym_node_group_channel_wnd` (
  `node_group_id` varchar(50) NOT NULL,
  `channel_id` varchar(128) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `enabled` smallint(6) NOT NULL DEFAULT '0',
  PRIMARY KEY (`node_group_id`,`channel_id`,`start_time`,`end_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_node_group_channel_wnd`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_I_FOR_SYM_ND_GRP_CHNNL_WND_C4RG after insert on `c4rg0airv2`.`sym_node_group_channel_wnd`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_node_group_channel_wnd',                                                                                                                                            
                                      'I',                                                                                                                                                             
                                      17,                                                                                                                                             
                                      concat(
          cast(if(new.`node_group_id` is null,'',concat('"',replace(replace(new.`node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`channel_id` is null,'',concat('"',replace(replace(new.`channel_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`start_time` is null,'',concat('"',cast(new.`start_time` as char),'"')),',',
          if(new.`end_time` is null,'',concat('"',cast(new.`end_time` as char),'"')),',',
          if(new.`enabled` is null,'',concat('"',cast(new.`enabled` as char),'"'))                                                                                                                                                
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_U_FOR_SYM_ND_GRP_CHNNL_WND_C4RG after update on `c4rg0airv2`.`sym_node_group_channel_wnd`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                  DECLARE var_row_data mediumtext character set utf8;                                                                                                                                      
                                  DECLARE var_old_data mediumtext character set utf8;                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                   set var_row_data = concat(
          cast(if(new.`node_group_id` is null,'',concat('"',replace(replace(new.`node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`channel_id` is null,'',concat('"',replace(replace(new.`channel_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`start_time` is null,'',concat('"',cast(new.`start_time` as char),'"')),',',
          if(new.`end_time` is null,'',concat('"',cast(new.`end_time` as char),'"')),',',
          if(new.`enabled` is null,'',concat('"',cast(new.`enabled` as char),'"')));                                                                                                                              
                                   set var_old_data = concat(null);                                                                                                                           
                                   if 1=1 then                                                                                                                                  
                                        insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                        values(                                                                                                                                                           
                                          'sym_node_group_channel_wnd',                                                                                                                                           
                                          'U',                                                                                                                                                            
                                          17,                                                                                                                                            
                                          concat(
          cast(if(old.`node_group_id` is null,'',concat('"',replace(replace(old.`node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`channel_id` is null,'',concat('"',replace(replace(old.`channel_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(old.`start_time` is null,'',concat('"',cast(old.`start_time` as char),'"')),',',
          if(old.`end_time` is null,'',concat('"',cast(old.`end_time` as char),'"'))                                                                                                                                               
                                           ),                                                                                                                                                             
                                          var_row_data,                                                                                                                                                   
                                          var_old_data,                                                                                                                                                   
                                          'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                       
                                          null,                                                                                                                                              
                                          CURRENT_TIMESTAMP                                                                                                                                               
                                        );                                                                                                                                                                
                                    end if;                                                                                                                                                               
                                  end if;                                                                                                                                                                
                                                                                                                                                                                    
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_D_FOR_SYM_ND_GRP_CHNNL_WND_C4RG after delete on `c4rg0airv2`.`sym_node_group_channel_wnd`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_node_group_channel_wnd',                                                                                                                                            
                                      'D',                                                                                                                                                             
                                      17,                                                                                                                                             
                                      concat(
          cast(if(old.`node_group_id` is null,'',concat('"',replace(replace(old.`node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`channel_id` is null,'',concat('"',replace(replace(old.`channel_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(old.`start_time` is null,'',concat('"',cast(old.`start_time` as char),'"')),',',
          if(old.`end_time` is null,'',concat('"',cast(old.`end_time` as char),'"'))                                                                                                                                                
                                       ),                                                                                                                                                              
                                       concat(null                                                                                                                                            
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;

--
-- Table structure for table `sym_node_group_link`
--

CREATE TABLE `sym_node_group_link` (
  `source_node_group_id` varchar(50) NOT NULL,
  `target_node_group_id` varchar(50) NOT NULL,
  `data_event_action` char(1) NOT NULL DEFAULT 'W',
  `sync_config_enabled` smallint(6) NOT NULL DEFAULT '1',
  `is_reversible` smallint(6) NOT NULL DEFAULT '0',
  `create_time` datetime DEFAULT NULL,
  `last_update_by` varchar(50) DEFAULT NULL,
  `last_update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`source_node_group_id`,`target_node_group_id`),
  KEY `sym_fk_lnk_2_grp_tgt` (`target_node_group_id`),
  CONSTRAINT `sym_fk_lnk_2_grp_src` FOREIGN KEY (`source_node_group_id`) REFERENCES `sym_node_group` (`node_group_id`),
  CONSTRAINT `sym_fk_lnk_2_grp_tgt` FOREIGN KEY (`target_node_group_id`) REFERENCES `sym_node_group` (`node_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_node_group_link`
--

INSERT INTO `sym_node_group_link` VALUES ('beta','c4rgo','P',1,0,NULL,NULL,NULL),('c4rgo','beta','W',1,0,NULL,NULL,NULL);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_I_FOR_SYM_ND_GRP_LNK_C4RG after insert on `c4rg0airv2`.`sym_node_group_link`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_node_group_link',                                                                                                                                            
                                      'I',                                                                                                                                                             
                                      19,                                                                                                                                             
                                      concat(
          cast(if(new.`source_node_group_id` is null,'',concat('"',replace(replace(new.`source_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_node_group_id` is null,'',concat('"',replace(replace(new.`target_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`data_event_action` is null,'',concat('"',replace(replace(new.`data_event_action`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`sync_config_enabled` is null,'',concat('"',cast(new.`sync_config_enabled` as char),'"')),',',
          if(new.`is_reversible` is null,'',concat('"',cast(new.`is_reversible` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"'))                                                                                                                                                
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_U_FOR_SYM_ND_GRP_LNK_C4RG after update on `c4rg0airv2`.`sym_node_group_link`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                  DECLARE var_row_data mediumtext character set utf8;                                                                                                                                      
                                  DECLARE var_old_data mediumtext character set utf8;                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                   set var_row_data = concat(
          cast(if(new.`source_node_group_id` is null,'',concat('"',replace(replace(new.`source_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_node_group_id` is null,'',concat('"',replace(replace(new.`target_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`data_event_action` is null,'',concat('"',replace(replace(new.`data_event_action`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`sync_config_enabled` is null,'',concat('"',cast(new.`sync_config_enabled` as char),'"')),',',
          if(new.`is_reversible` is null,'',concat('"',cast(new.`is_reversible` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')));                                                                                                                              
                                   set var_old_data = concat(null);                                                                                                                           
                                   if 1=1 then                                                                                                                                  
                                        insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                        values(                                                                                                                                                           
                                          'sym_node_group_link',                                                                                                                                           
                                          'U',                                                                                                                                                            
                                          19,                                                                                                                                            
                                          concat(
          cast(if(old.`source_node_group_id` is null,'',concat('"',replace(replace(old.`source_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`target_node_group_id` is null,'',concat('"',replace(replace(old.`target_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                               
                                           ),                                                                                                                                                             
                                          var_row_data,                                                                                                                                                   
                                          var_old_data,                                                                                                                                                   
                                          'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                       
                                          null,                                                                                                                                              
                                          CURRENT_TIMESTAMP                                                                                                                                               
                                        );                                                                                                                                                                
                                    end if;                                                                                                                                                               
                                  end if;                                                                                                                                                                
                                                                                                                                                                                    
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_D_FOR_SYM_ND_GRP_LNK_C4RG after delete on `c4rg0airv2`.`sym_node_group_link`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_node_group_link',                                                                                                                                            
                                      'D',                                                                                                                                                             
                                      19,                                                                                                                                             
                                      concat(
          cast(if(old.`source_node_group_id` is null,'',concat('"',replace(replace(old.`source_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`target_node_group_id` is null,'',concat('"',replace(replace(old.`target_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                       concat(null                                                                                                                                            
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;

--
-- Table structure for table `sym_node_host`
--

CREATE TABLE `sym_node_host` (
  `node_id` varchar(50) NOT NULL,
  `host_name` varchar(60) NOT NULL,
  `instance_id` varchar(60) DEFAULT NULL,
  `ip_address` varchar(50) DEFAULT NULL,
  `os_user` varchar(50) DEFAULT NULL,
  `os_name` varchar(50) DEFAULT NULL,
  `os_arch` varchar(50) DEFAULT NULL,
  `os_version` varchar(50) DEFAULT NULL,
  `available_processors` int(11) DEFAULT '0',
  `free_memory_bytes` bigint(20) DEFAULT '0',
  `total_memory_bytes` bigint(20) DEFAULT '0',
  `max_memory_bytes` bigint(20) DEFAULT '0',
  `java_version` varchar(50) DEFAULT NULL,
  `java_vendor` varchar(255) DEFAULT NULL,
  `jdbc_version` varchar(255) DEFAULT NULL,
  `symmetric_version` varchar(50) DEFAULT NULL,
  `timezone_offset` varchar(6) DEFAULT NULL,
  `heartbeat_time` datetime DEFAULT NULL,
  `last_restart_time` datetime NOT NULL,
  `create_time` datetime NOT NULL,
  PRIMARY KEY (`node_id`,`host_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_node_host`
--

INSERT INTO `sym_node_host` VALUES ('000','vps806731','vps806731-b0a85d78-4774-49a2-afde-57b1ec6483c6','217.182.66.168','root','Linux','amd64','4.15.0-101-generic',4,153622200,265289728,954728448,'1.8.0_265','Private Build','mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )','3.12.4','+01:00','2020-11-09 20:24:48','2020-10-09 03:04:57','2020-10-09 01:46:34'),('001','DESKTOP-8SVEEPF','DESKTOP-8SVEEPF-e685a8bc-d71f-4e3b-a371-88cec8569ec5','192.168.0.50','HYSTOU','Windows 10','amd64','10.0',4,32317912,123207680,1888485376,'1.8.0_231','Oracle Corporation','mysql-connector-java-5.1.45 ( Revision: 9131eefa398531c7dc98776e8a3fe839e544c5b2 )','3.12.4','+01:00','2020-11-09 20:33:04','2020-11-05 18:29:50','2020-10-09 01:47:21');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_I_FOR_SYM_ND_HST_C4RG after insert on `c4rg0airv2`.`sym_node_host`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_node_host',                                                                                                                                            
                                      'I',                                                                                                                                                             
                                      29,                                                                                                                                             
                                      concat(
          cast(if(new.`node_id` is null,'',concat('"',replace(replace(new.`node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`host_name` is null,'',concat('"',replace(replace(new.`host_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`instance_id` is null,'',concat('"',replace(replace(new.`instance_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`ip_address` is null,'',concat('"',replace(replace(new.`ip_address`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`os_user` is null,'',concat('"',replace(replace(new.`os_user`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`os_name` is null,'',concat('"',replace(replace(new.`os_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`os_arch` is null,'',concat('"',replace(replace(new.`os_arch`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`os_version` is null,'',concat('"',replace(replace(new.`os_version`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`available_processors` is null,'',concat('"',cast(new.`available_processors` as char),'"')),',',
          if(new.`free_memory_bytes` is null,'',concat('"',cast(new.`free_memory_bytes` as char),'"')),',',
          if(new.`total_memory_bytes` is null,'',concat('"',cast(new.`total_memory_bytes` as char),'"')),',',
          if(new.`max_memory_bytes` is null,'',concat('"',cast(new.`max_memory_bytes` as char),'"')),',',
          cast(if(new.`java_version` is null,'',concat('"',replace(replace(new.`java_version`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`java_vendor` is null,'',concat('"',replace(replace(new.`java_vendor`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`jdbc_version` is null,'',concat('"',replace(replace(new.`jdbc_version`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`symmetric_version` is null,'',concat('"',replace(replace(new.`symmetric_version`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`timezone_offset` is null,'',concat('"',replace(replace(new.`timezone_offset`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`heartbeat_time` is null,'',concat('"',cast(new.`heartbeat_time` as char),'"')),',',
          if(new.`last_restart_time` is null,'',concat('"',cast(new.`last_restart_time` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"'))                                                                                                                                                
                                       ),                                                                                                                                                              
                                      'heartbeat', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_U_FOR_SYM_ND_HST_C4RG after update on `c4rg0airv2`.`sym_node_host`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                  DECLARE var_row_data mediumtext character set utf8;                                                                                                                                      
                                  DECLARE var_old_data mediumtext character set utf8;                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                   set var_row_data = concat(
          cast(if(new.`node_id` is null,'',concat('"',replace(replace(new.`node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`host_name` is null,'',concat('"',replace(replace(new.`host_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`instance_id` is null,'',concat('"',replace(replace(new.`instance_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`ip_address` is null,'',concat('"',replace(replace(new.`ip_address`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`os_user` is null,'',concat('"',replace(replace(new.`os_user`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`os_name` is null,'',concat('"',replace(replace(new.`os_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`os_arch` is null,'',concat('"',replace(replace(new.`os_arch`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`os_version` is null,'',concat('"',replace(replace(new.`os_version`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`available_processors` is null,'',concat('"',cast(new.`available_processors` as char),'"')),',',
          if(new.`free_memory_bytes` is null,'',concat('"',cast(new.`free_memory_bytes` as char),'"')),',',
          if(new.`total_memory_bytes` is null,'',concat('"',cast(new.`total_memory_bytes` as char),'"')),',',
          if(new.`max_memory_bytes` is null,'',concat('"',cast(new.`max_memory_bytes` as char),'"')),',',
          cast(if(new.`java_version` is null,'',concat('"',replace(replace(new.`java_version`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`java_vendor` is null,'',concat('"',replace(replace(new.`java_vendor`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`jdbc_version` is null,'',concat('"',replace(replace(new.`jdbc_version`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`symmetric_version` is null,'',concat('"',replace(replace(new.`symmetric_version`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`timezone_offset` is null,'',concat('"',replace(replace(new.`timezone_offset`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`heartbeat_time` is null,'',concat('"',cast(new.`heartbeat_time` as char),'"')),',',
          if(new.`last_restart_time` is null,'',concat('"',cast(new.`last_restart_time` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')));                                                                                                                              
                                   set var_old_data = concat(null);                                                                                                                           
                                   if 1=1 then                                                                                                                                  
                                        insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                        values(                                                                                                                                                           
                                          'sym_node_host',                                                                                                                                           
                                          'U',                                                                                                                                                            
                                          29,                                                                                                                                            
                                          concat(
          cast(if(old.`node_id` is null,'',concat('"',replace(replace(old.`node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`host_name` is null,'',concat('"',replace(replace(old.`host_name`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                               
                                           ),                                                                                                                                                             
                                          var_row_data,                                                                                                                                                   
                                          var_old_data,                                                                                                                                                   
                                          'heartbeat', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                       
                                          null,                                                                                                                                              
                                          CURRENT_TIMESTAMP                                                                                                                                               
                                        );                                                                                                                                                                
                                    end if;                                                                                                                                                               
                                  end if;                                                                                                                                                                
                                                                                                                                                                                    
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_D_FOR_SYM_ND_HST_C4RG after delete on `c4rg0airv2`.`sym_node_host`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_node_host',                                                                                                                                            
                                      'D',                                                                                                                                                             
                                      29,                                                                                                                                             
                                      concat(
          cast(if(old.`node_id` is null,'',concat('"',replace(replace(old.`node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`host_name` is null,'',concat('"',replace(replace(old.`host_name`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                       concat(null                                                                                                                                            
                                       ),                                                                                                                                                              
                                      'heartbeat', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;

--
-- Table structure for table `sym_node_host_channel_stats`
--

CREATE TABLE `sym_node_host_channel_stats` (
  `node_id` varchar(50) NOT NULL,
  `host_name` varchar(60) NOT NULL,
  `channel_id` varchar(128) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `data_routed` bigint(20) DEFAULT '0',
  `data_unrouted` bigint(20) DEFAULT '0',
  `data_event_inserted` bigint(20) DEFAULT '0',
  `data_extracted` bigint(20) DEFAULT '0',
  `data_bytes_extracted` bigint(20) DEFAULT '0',
  `data_extracted_errors` bigint(20) DEFAULT '0',
  `data_bytes_sent` bigint(20) DEFAULT '0',
  `data_sent` bigint(20) DEFAULT '0',
  `data_sent_errors` bigint(20) DEFAULT '0',
  `data_loaded` bigint(20) DEFAULT '0',
  `data_bytes_loaded` bigint(20) DEFAULT '0',
  `data_loaded_errors` bigint(20) DEFAULT '0',
  `data_loaded_outgoing` bigint(20) DEFAULT '0',
  `data_bytes_loaded_outgoing` bigint(20) DEFAULT '0',
  `data_loaded_outgoing_errors` bigint(20) DEFAULT '0',
  PRIMARY KEY (`node_id`,`host_name`,`channel_id`,`start_time`,`end_time`),
  KEY `sym_idx_nd_hst_chnl_sts` (`node_id`,`start_time`,`end_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_node_host_channel_stats`
--


--
-- Table structure for table `sym_node_host_job_stats`
--

CREATE TABLE `sym_node_host_job_stats` (
  `node_id` varchar(50) NOT NULL,
  `host_name` varchar(60) NOT NULL,
  `job_name` varchar(50) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `processed_count` bigint(20) DEFAULT '0',
  `target_node_id` varchar(50) DEFAULT NULL,
  `target_node_count` int(11) DEFAULT '0',
  PRIMARY KEY (`node_id`,`host_name`,`job_name`,`start_time`,`end_time`),
  KEY `sym_idx_nd_hst_job` (`node_id`,`start_time`,`end_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_node_host_job_stats`
--


--
-- Table structure for table `sym_node_host_stats`
--

CREATE TABLE `sym_node_host_stats` (
  `node_id` varchar(50) NOT NULL,
  `host_name` varchar(60) NOT NULL,
  `start_time` datetime NOT NULL,
  `end_time` datetime NOT NULL,
  `restarted` bigint(20) NOT NULL DEFAULT '0',
  `nodes_pulled` bigint(20) DEFAULT '0',
  `total_nodes_pull_time` bigint(20) DEFAULT '0',
  `nodes_pushed` bigint(20) DEFAULT '0',
  `total_nodes_push_time` bigint(20) DEFAULT '0',
  `nodes_rejected` bigint(20) DEFAULT '0',
  `nodes_registered` bigint(20) DEFAULT '0',
  `nodes_loaded` bigint(20) DEFAULT '0',
  `nodes_disabled` bigint(20) DEFAULT '0',
  `purged_data_rows` bigint(20) DEFAULT '0',
  `purged_data_event_rows` bigint(20) DEFAULT '0',
  `purged_batch_outgoing_rows` bigint(20) DEFAULT '0',
  `purged_batch_incoming_rows` bigint(20) DEFAULT '0',
  `triggers_created_count` bigint(20) DEFAULT NULL,
  `triggers_rebuilt_count` bigint(20) DEFAULT NULL,
  `triggers_removed_count` bigint(20) DEFAULT NULL,
  PRIMARY KEY (`node_id`,`host_name`,`start_time`,`end_time`),
  KEY `sym_idx_nd_hst_sts` (`node_id`,`start_time`,`end_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_node_host_stats`
--


--
-- Table structure for table `sym_node_identity`
--

CREATE TABLE `sym_node_identity` (
  `node_id` varchar(50) NOT NULL,
  PRIMARY KEY (`node_id`),
  CONSTRAINT `sym_fk_ident_2_node` FOREIGN KEY (`node_id`) REFERENCES `sym_node` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_node_identity`
--

INSERT INTO `sym_node_identity` VALUES ('000');

--
-- Table structure for table `sym_node_security`
--

CREATE TABLE `sym_node_security` (
  `node_id` varchar(50) NOT NULL,
  `node_password` varchar(50) NOT NULL,
  `registration_enabled` smallint(6) DEFAULT '0',
  `registration_time` datetime DEFAULT NULL,
  `initial_load_enabled` smallint(6) DEFAULT '0',
  `initial_load_time` datetime DEFAULT NULL,
  `initial_load_id` bigint(20) DEFAULT NULL,
  `initial_load_create_by` varchar(255) DEFAULT NULL,
  `rev_initial_load_enabled` smallint(6) DEFAULT '0',
  `rev_initial_load_time` datetime DEFAULT NULL,
  `rev_initial_load_id` bigint(20) DEFAULT NULL,
  `rev_initial_load_create_by` varchar(255) DEFAULT NULL,
  `failed_logins` smallint(6) DEFAULT '0',
  `created_at_node_id` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`node_id`),
  CONSTRAINT `sym_fk_sec_2_node` FOREIGN KEY (`node_id`) REFERENCES `sym_node` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_node_security`
--

INSERT INTO `sym_node_security` VALUES ('000','kYlxrMu6MVZCl0DCHSaE1xsaxlHPCz',0,'2020-10-09 00:30:22',0,'2020-10-09 00:30:22',0,NULL,0,NULL,0,NULL,0,NULL),('001','XhvC7h83Rhppln0rGES1Si72hHN7Mk',0,'2020-10-09 01:47:30',0,NULL,NULL,NULL,0,NULL,NULL,NULL,0,'000');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_I_FOR_SYM_ND_SCRTY_C4RG after insert on `c4rg0airv2`.`sym_node_security`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_node_security',                                                                                                                                            
                                      'I',                                                                                                                                                             
                                      21,                                                                                                                                             
                                      concat(
          cast(if(new.`node_id` is null,'',concat('"',replace(replace(new.`node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`node_password` is null,'',concat('"',replace(replace(new.`node_password`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`registration_enabled` is null,'',concat('"',cast(new.`registration_enabled` as char),'"')),',',
          if(new.`registration_time` is null,'',concat('"',cast(new.`registration_time` as char),'"')),',',
          if(new.`initial_load_enabled` is null,'',concat('"',cast(new.`initial_load_enabled` as char),'"')),',',
          if(new.`initial_load_time` is null,'',concat('"',cast(new.`initial_load_time` as char),'"')),',',
          if(new.`initial_load_id` is null,'',concat('"',cast(new.`initial_load_id` as char),'"')),',',
          cast(if(new.`initial_load_create_by` is null,'',concat('"',replace(replace(new.`initial_load_create_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`rev_initial_load_enabled` is null,'',concat('"',cast(new.`rev_initial_load_enabled` as char),'"')),',',
          if(new.`rev_initial_load_time` is null,'',concat('"',cast(new.`rev_initial_load_time` as char),'"')),',',
          if(new.`rev_initial_load_id` is null,'',concat('"',cast(new.`rev_initial_load_id` as char),'"')),',',
          cast(if(new.`rev_initial_load_create_by` is null,'',concat('"',replace(replace(new.`rev_initial_load_create_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`failed_logins` is null,'',concat('"',cast(new.`failed_logins` as char),'"')),',',
          cast(if(new.`created_at_node_id` is null,'',concat('"',replace(replace(new.`created_at_node_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_U_FOR_SYM_ND_SCRTY_C4RG after update on `c4rg0airv2`.`sym_node_security`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                  DECLARE var_row_data mediumtext character set utf8;                                                                                                                                      
                                  DECLARE var_old_data mediumtext character set utf8;                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                   set var_row_data = concat(
          cast(if(new.`node_id` is null,'',concat('"',replace(replace(new.`node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`node_password` is null,'',concat('"',replace(replace(new.`node_password`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`registration_enabled` is null,'',concat('"',cast(new.`registration_enabled` as char),'"')),',',
          if(new.`registration_time` is null,'',concat('"',cast(new.`registration_time` as char),'"')),',',
          if(new.`initial_load_enabled` is null,'',concat('"',cast(new.`initial_load_enabled` as char),'"')),',',
          if(new.`initial_load_time` is null,'',concat('"',cast(new.`initial_load_time` as char),'"')),',',
          if(new.`initial_load_id` is null,'',concat('"',cast(new.`initial_load_id` as char),'"')),',',
          cast(if(new.`initial_load_create_by` is null,'',concat('"',replace(replace(new.`initial_load_create_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`rev_initial_load_enabled` is null,'',concat('"',cast(new.`rev_initial_load_enabled` as char),'"')),',',
          if(new.`rev_initial_load_time` is null,'',concat('"',cast(new.`rev_initial_load_time` as char),'"')),',',
          if(new.`rev_initial_load_id` is null,'',concat('"',cast(new.`rev_initial_load_id` as char),'"')),',',
          cast(if(new.`rev_initial_load_create_by` is null,'',concat('"',replace(replace(new.`rev_initial_load_create_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`failed_logins` is null,'',concat('"',cast(new.`failed_logins` as char),'"')),',',
          cast(if(new.`created_at_node_id` is null,'',concat('"',replace(replace(new.`created_at_node_id`,'\\','\\\\'),'"','\\"'),'"')) as char));                                                                                                                              
                                   set var_old_data = concat(null);                                                                                                                           
                                   if 1=1 then                                                                                                                                  
                                        insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                        values(                                                                                                                                                           
                                          'sym_node_security',                                                                                                                                           
                                          'U',                                                                                                                                                            
                                          21,                                                                                                                                            
                                          concat(
          cast(if(old.`node_id` is null,'',concat('"',replace(replace(old.`node_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                               
                                           ),                                                                                                                                                             
                                          var_row_data,                                                                                                                                                   
                                          var_old_data,                                                                                                                                                   
                                          'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                       
                                          null,                                                                                                                                              
                                          CURRENT_TIMESTAMP                                                                                                                                               
                                        );                                                                                                                                                                
                                    end if;                                                                                                                                                               
                                  end if;                                                                                                                                                                
                                                                                                                                                                                    
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_D_FOR_SYM_ND_SCRTY_C4RG after delete on `c4rg0airv2`.`sym_node_security`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_node_security',                                                                                                                                            
                                      'D',                                                                                                                                                             
                                      21,                                                                                                                                             
                                      concat(
          cast(if(old.`node_id` is null,'',concat('"',replace(replace(old.`node_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                       concat(null                                                                                                                                            
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;

--
-- Table structure for table `sym_notification`
--

CREATE TABLE `sym_notification` (
  `notification_id` varchar(128) NOT NULL,
  `node_group_id` varchar(50) NOT NULL DEFAULT 'ALL',
  `external_id` varchar(255) NOT NULL DEFAULT 'ALL',
  `severity_level` int(11) NOT NULL DEFAULT '0',
  `type` varchar(50) NOT NULL,
  `expression` mediumtext,
  `enabled` smallint(6) NOT NULL DEFAULT '0',
  `create_time` datetime DEFAULT NULL,
  `last_update_by` varchar(50) DEFAULT NULL,
  `last_update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`notification_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_notification`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_I_FOR_SYM_NTFCTN_C4RG after insert on `c4rg0airv2`.`sym_notification`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_notification',                                                                                                                                            
                                      'I',                                                                                                                                                             
                                      18,                                                                                                                                             
                                      concat(
          cast(if(new.`notification_id` is null,'',concat('"',replace(replace(new.`notification_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`node_group_id` is null,'',concat('"',replace(replace(new.`node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`external_id` is null,'',concat('"',replace(replace(new.`external_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`severity_level` is null,'',concat('"',cast(new.`severity_level` as char),'"')),',',
          cast(if(new.`type` is null,'',concat('"',replace(replace(new.`type`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`expression` is null,'',concat('"',replace(replace(new.`expression`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`enabled` is null,'',concat('"',cast(new.`enabled` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"'))                                                                                                                                                
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_U_FOR_SYM_NTFCTN_C4RG after update on `c4rg0airv2`.`sym_notification`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                  DECLARE var_row_data mediumtext character set utf8;                                                                                                                                      
                                  DECLARE var_old_data mediumtext character set utf8;                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                   set var_row_data = concat(
          cast(if(new.`notification_id` is null,'',concat('"',replace(replace(new.`notification_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`node_group_id` is null,'',concat('"',replace(replace(new.`node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`external_id` is null,'',concat('"',replace(replace(new.`external_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`severity_level` is null,'',concat('"',cast(new.`severity_level` as char),'"')),',',
          cast(if(new.`type` is null,'',concat('"',replace(replace(new.`type`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`expression` is null,'',concat('"',replace(replace(new.`expression`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`enabled` is null,'',concat('"',cast(new.`enabled` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')));                                                                                                                              
                                   set var_old_data = concat(null);                                                                                                                           
                                   if 1=1 then                                                                                                                                  
                                        insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                        values(                                                                                                                                                           
                                          'sym_notification',                                                                                                                                           
                                          'U',                                                                                                                                                            
                                          18,                                                                                                                                            
                                          concat(
          cast(if(old.`notification_id` is null,'',concat('"',replace(replace(old.`notification_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                               
                                           ),                                                                                                                                                             
                                          var_row_data,                                                                                                                                                   
                                          var_old_data,                                                                                                                                                   
                                          'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                       
                                          null,                                                                                                                                              
                                          CURRENT_TIMESTAMP                                                                                                                                               
                                        );                                                                                                                                                                
                                    end if;                                                                                                                                                               
                                  end if;                                                                                                                                                                
                                                                                                                                                                                    
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_D_FOR_SYM_NTFCTN_C4RG after delete on `c4rg0airv2`.`sym_notification`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_notification',                                                                                                                                            
                                      'D',                                                                                                                                                             
                                      18,                                                                                                                                             
                                      concat(
          cast(if(old.`notification_id` is null,'',concat('"',replace(replace(old.`notification_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                       concat(null                                                                                                                                            
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;

--
-- Table structure for table `sym_outgoing_batch`
--

CREATE TABLE `sym_outgoing_batch` (
  `batch_id` bigint(20) NOT NULL,
  `node_id` varchar(50) NOT NULL,
  `channel_id` varchar(128) DEFAULT NULL,
  `status` char(2) DEFAULT NULL,
  `error_flag` smallint(6) DEFAULT '0',
  `sql_state` varchar(10) DEFAULT NULL,
  `sql_code` int(11) NOT NULL DEFAULT '0',
  `sql_message` mediumtext,
  `last_update_hostname` varchar(255) DEFAULT NULL,
  `last_update_time` datetime DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `summary` varchar(255) DEFAULT NULL,
  `ignore_count` int(11) NOT NULL DEFAULT '0',
  `byte_count` bigint(20) NOT NULL DEFAULT '0',
  `load_flag` smallint(6) DEFAULT '0',
  `extract_count` int(11) NOT NULL DEFAULT '0',
  `sent_count` int(11) NOT NULL DEFAULT '0',
  `load_count` int(11) NOT NULL DEFAULT '0',
  `reload_row_count` int(11) NOT NULL DEFAULT '0',
  `other_row_count` int(11) NOT NULL DEFAULT '0',
  `data_row_count` int(11) NOT NULL DEFAULT '0',
  `extract_row_count` int(11) NOT NULL DEFAULT '0',
  `load_row_count` int(11) NOT NULL DEFAULT '0',
  `data_insert_row_count` int(11) NOT NULL DEFAULT '0',
  `data_update_row_count` int(11) NOT NULL DEFAULT '0',
  `data_delete_row_count` int(11) NOT NULL DEFAULT '0',
  `extract_insert_row_count` int(11) NOT NULL DEFAULT '0',
  `extract_update_row_count` int(11) NOT NULL DEFAULT '0',
  `extract_delete_row_count` int(11) NOT NULL DEFAULT '0',
  `load_insert_row_count` int(11) NOT NULL DEFAULT '0',
  `load_update_row_count` int(11) NOT NULL DEFAULT '0',
  `load_delete_row_count` int(11) NOT NULL DEFAULT '0',
  `network_millis` int(11) NOT NULL DEFAULT '0',
  `filter_millis` int(11) NOT NULL DEFAULT '0',
  `load_millis` int(11) NOT NULL DEFAULT '0',
  `router_millis` int(11) NOT NULL DEFAULT '0',
  `extract_millis` int(11) NOT NULL DEFAULT '0',
  `transform_extract_millis` int(11) NOT NULL DEFAULT '0',
  `transform_load_millis` int(11) NOT NULL DEFAULT '0',
  `load_id` bigint(20) DEFAULT NULL,
  `common_flag` smallint(6) DEFAULT '0',
  `fallback_insert_count` int(11) NOT NULL DEFAULT '0',
  `fallback_update_count` int(11) NOT NULL DEFAULT '0',
  `ignore_row_count` int(11) NOT NULL DEFAULT '0',
  `missing_delete_count` int(11) NOT NULL DEFAULT '0',
  `skip_count` int(11) NOT NULL DEFAULT '0',
  `total_extract_millis` int(11) NOT NULL DEFAULT '0',
  `total_load_millis` int(11) NOT NULL DEFAULT '0',
  `extract_job_flag` smallint(6) DEFAULT '0',
  `extract_start_time` datetime DEFAULT NULL,
  `transfer_start_time` datetime DEFAULT NULL,
  `load_start_time` datetime DEFAULT NULL,
  `failed_data_id` bigint(20) NOT NULL DEFAULT '0',
  `failed_line_number` bigint(20) NOT NULL DEFAULT '0',
  `create_by` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`batch_id`,`node_id`),
  KEY `sym_idx_ob_node_status` (`node_id`,`status`),
  KEY `sym_idx_ob_status` (`status`),
  KEY `sym_idx_ob_in_error` (`error_flag`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_outgoing_batch`
--

INSERT INTO `sym_outgoing_batch` VALUES (4635,'-1','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 18:03:06','2020-11-09 18:03:06','sym_node_host',0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,14,0,0,0,-1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,0,0,NULL),(4636,'001','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 18:09:53','2020-11-09 18:09:51','sym_node_host',0,812,0,1,1,1,0,0,1,1,1,0,1,0,0,1,0,0,1,0,0,0,16,6,21,0,0,-1,0,0,0,0,0,0,0,0,0,'2020-11-09 18:09:53','2020-11-09 18:09:53','2020-11-09 18:09:54',0,0,NULL),(4637,'-1','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 18:18:07','2020-11-09 18:18:07','sym_node_host',0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,7,0,0,0,-1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,0,0,NULL),(4638,'001','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 18:24:54','2020-11-09 18:24:52','sym_node_host',0,812,0,1,1,1,0,0,1,1,1,0,1,0,0,1,0,0,1,0,0,0,15,190,24,0,0,-1,0,0,0,0,0,0,0,0,0,'2020-11-09 18:24:54','2020-11-09 18:24:54','2020-11-09 18:24:55',0,0,NULL),(4639,'-1','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 18:33:08','2020-11-09 18:33:08','sym_node_host',0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,6,0,0,0,-1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,0,0,NULL),(4640,'001','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 18:39:55','2020-11-09 18:39:48','sym_node_host',0,812,0,1,1,1,0,0,1,1,1,0,1,0,0,1,0,0,1,0,0,0,0,9,25,0,0,-1,0,0,0,0,0,0,0,0,0,'2020-11-09 18:39:55','2020-11-09 18:39:55','2020-11-09 18:39:57',0,0,NULL),(4641,'-1','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 18:48:09','2020-11-09 18:48:09','sym_node_host',0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,149,0,0,0,-1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,0,0,NULL),(4642,'001','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 18:54:56','2020-11-09 18:54:50','sym_node_host',0,812,0,1,1,1,0,0,1,1,1,0,1,0,0,1,0,0,1,0,0,0,16,303,29,0,0,-1,0,0,0,0,0,0,0,0,0,'2020-11-09 18:54:56','2020-11-09 18:54:56','2020-11-09 18:54:58',0,0,NULL),(4643,'-1','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 19:03:00','2020-11-09 19:03:00','sym_node_host',0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,33,0,0,0,-1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,0,0,NULL),(4644,'001','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 19:09:57','2020-11-09 19:09:51','sym_node_host',0,812,0,1,1,1,0,0,1,1,1,0,1,0,0,1,0,0,1,0,0,0,0,296,26,0,0,-1,0,0,0,0,0,0,0,0,0,'2020-11-09 19:09:58','2020-11-09 19:09:58','2020-11-09 19:09:58',0,0,NULL),(4645,'-1','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 19:18:02','2020-11-09 19:18:01','sym_node_host',0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,143,0,0,0,-1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,0,0,NULL),(4646,'001','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 19:24:58','2020-11-09 19:24:52','sym_node_host',0,812,0,1,1,1,0,0,1,1,1,0,1,0,0,1,0,0,1,0,0,0,0,6,23,0,0,-1,0,0,0,0,0,0,0,0,0,'2020-11-09 19:24:59','2020-11-09 19:24:59','2020-11-09 19:24:59',0,0,NULL),(4647,'-1','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 19:33:03','2020-11-09 19:33:03','sym_node_host',0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,37,0,0,0,-1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,0,0,NULL),(4648,'001','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 19:39:49','2020-11-09 19:39:48','sym_node_host',0,812,0,1,1,1,0,0,1,1,1,0,1,0,0,1,0,0,1,0,0,0,16,6,25,0,0,-1,0,0,0,0,0,0,0,0,0,'2020-11-09 19:39:50','2020-11-09 19:39:50','2020-11-09 19:39:50',0,0,NULL),(4649,'-1','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 19:48:04','2020-11-09 19:48:04','sym_node_host',0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,165,0,0,0,-1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,0,0,NULL),(4650,'001','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 19:54:50','2020-11-09 19:54:49','sym_node_host',0,812,0,1,1,1,0,0,1,1,1,0,1,0,0,1,0,0,1,0,0,0,0,7,30,0,0,-1,0,0,0,0,0,0,0,0,0,'2020-11-09 19:54:50','2020-11-09 19:54:50','2020-11-09 19:54:51',0,0,NULL),(4651,'-1','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 20:03:05','2020-11-09 20:03:05','sym_node_host',0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,6,0,0,0,-1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,0,0,NULL),(4652,'001','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 20:09:51','2020-11-09 20:09:50','sym_node_host',0,812,0,1,1,1,0,0,1,1,1,0,1,0,0,1,0,0,1,0,0,0,15,14,25,0,0,-1,0,0,0,0,0,0,0,0,0,'2020-11-09 20:09:51','2020-11-09 20:09:51','2020-11-09 20:09:52',0,0,NULL),(4653,'-1','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 20:18:06','2020-11-09 20:18:06','sym_node_host',0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,133,0,0,0,-1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,0,0,NULL),(4654,'001','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 20:24:53','2020-11-09 20:24:51','sym_node_host',0,812,0,1,1,1,0,0,1,1,1,0,1,0,0,1,0,0,1,0,0,0,0,12,25,0,0,-1,0,0,0,0,0,0,0,0,0,'2020-11-09 20:24:53','2020-11-09 20:24:53','2020-11-09 20:24:53',0,0,NULL),(4655,'-1','heartbeat','OK',0,NULL,0,NULL,'vps806731','2020-11-09 20:33:07','2020-11-09 20:33:07','sym_node_host',0,0,0,0,0,0,0,0,1,0,0,0,1,0,0,0,0,0,0,0,0,0,0,25,0,0,0,-1,0,0,0,0,0,0,0,0,0,NULL,NULL,NULL,0,0,NULL);

--
-- Table structure for table `sym_parameter`
--

CREATE TABLE `sym_parameter` (
  `external_id` varchar(255) NOT NULL,
  `node_group_id` varchar(50) NOT NULL,
  `param_key` varchar(80) NOT NULL,
  `param_value` mediumtext,
  `create_time` datetime DEFAULT NULL,
  `last_update_by` varchar(50) DEFAULT NULL,
  `last_update_time` datetime DEFAULT NULL,
  PRIMARY KEY (`external_id`,`node_group_id`,`param_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_parameter`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_I_FOR_SYM_PRMTR_C4RG after insert on `c4rg0airv2`.`sym_parameter`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_parameter',                                                                                                                                            
                                      'I',                                                                                                                                                             
                                      5,                                                                                                                                             
                                      concat(
          cast(if(new.`external_id` is null,'',concat('"',replace(replace(new.`external_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`node_group_id` is null,'',concat('"',replace(replace(new.`node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`param_key` is null,'',concat('"',replace(replace(new.`param_key`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`param_value` is null,'',concat('"',replace(replace(new.`param_value`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"'))                                                                                                                                                
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_U_FOR_SYM_PRMTR_C4RG after update on `c4rg0airv2`.`sym_parameter`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                  DECLARE var_row_data mediumtext character set utf8;                                                                                                                                      
                                  DECLARE var_old_data mediumtext character set utf8;                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                   set var_row_data = concat(
          cast(if(new.`external_id` is null,'',concat('"',replace(replace(new.`external_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`node_group_id` is null,'',concat('"',replace(replace(new.`node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`param_key` is null,'',concat('"',replace(replace(new.`param_key`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`param_value` is null,'',concat('"',replace(replace(new.`param_value`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')));                                                                                                                              
                                   set var_old_data = concat(null);                                                                                                                           
                                   if 1=1 then                                                                                                                                  
                                        insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                        values(                                                                                                                                                           
                                          'sym_parameter',                                                                                                                                           
                                          'U',                                                                                                                                                            
                                          5,                                                                                                                                            
                                          concat(
          cast(if(old.`external_id` is null,'',concat('"',replace(replace(old.`external_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`node_group_id` is null,'',concat('"',replace(replace(old.`node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`param_key` is null,'',concat('"',replace(replace(old.`param_key`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                               
                                           ),                                                                                                                                                             
                                          var_row_data,                                                                                                                                                   
                                          var_old_data,                                                                                                                                                   
                                          'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                       
                                          null,                                                                                                                                              
                                          CURRENT_TIMESTAMP                                                                                                                                               
                                        );                                                                                                                                                                
                                    end if;                                                                                                                                                               
                                  end if;                                                                                                                                                                
                                                                                                                                                                                    
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_D_FOR_SYM_PRMTR_C4RG after delete on `c4rg0airv2`.`sym_parameter`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_parameter',                                                                                                                                            
                                      'D',                                                                                                                                                             
                                      5,                                                                                                                                             
                                      concat(
          cast(if(old.`external_id` is null,'',concat('"',replace(replace(old.`external_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`node_group_id` is null,'',concat('"',replace(replace(old.`node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`param_key` is null,'',concat('"',replace(replace(old.`param_key`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                       concat(null                                                                                                                                            
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;

--
-- Table structure for table `sym_registration_redirect`
--

CREATE TABLE `sym_registration_redirect` (
  `registrant_external_id` varchar(255) NOT NULL,
  `registration_node_id` varchar(50) NOT NULL,
  PRIMARY KEY (`registrant_external_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_registration_redirect`
--


--
-- Table structure for table `sym_registration_request`
--

CREATE TABLE `sym_registration_request` (
  `node_group_id` varchar(50) NOT NULL,
  `external_id` varchar(255) NOT NULL,
  `status` char(2) NOT NULL,
  `host_name` varchar(60) NOT NULL,
  `ip_address` varchar(50) NOT NULL,
  `attempt_count` int(11) DEFAULT '0',
  `registered_node_id` varchar(50) DEFAULT NULL,
  `error_message` mediumtext,
  `create_time` datetime NOT NULL,
  `last_update_by` varchar(50) DEFAULT NULL,
  `last_update_time` datetime NOT NULL,
  PRIMARY KEY (`node_group_id`,`external_id`,`create_time`),
  KEY `sym_idx_reg_req_1` (`node_group_id`,`external_id`,`status`,`host_name`,`ip_address`),
  KEY `sym_idx_reg_req_2` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_registration_request`
--


--
-- Table structure for table `sym_router`
--

CREATE TABLE `sym_router` (
  `router_id` varchar(50) NOT NULL,
  `target_catalog_name` varchar(255) DEFAULT NULL,
  `target_schema_name` varchar(255) DEFAULT NULL,
  `target_table_name` varchar(255) DEFAULT NULL,
  `source_node_group_id` varchar(50) NOT NULL,
  `target_node_group_id` varchar(50) NOT NULL,
  `router_type` varchar(50) NOT NULL DEFAULT 'default',
  `router_expression` mediumtext,
  `sync_on_update` smallint(6) NOT NULL DEFAULT '1',
  `sync_on_insert` smallint(6) NOT NULL DEFAULT '1',
  `sync_on_delete` smallint(6) NOT NULL DEFAULT '1',
  `use_source_catalog_schema` smallint(6) NOT NULL DEFAULT '1',
  `create_time` datetime NOT NULL,
  `last_update_by` varchar(50) DEFAULT NULL,
  `last_update_time` datetime NOT NULL,
  `description` mediumtext,
  PRIMARY KEY (`router_id`),
  KEY `sym_fk_rt_2_grp_lnk` (`source_node_group_id`,`target_node_group_id`),
  CONSTRAINT `sym_fk_rt_2_grp_lnk` FOREIGN KEY (`source_node_group_id`, `target_node_group_id`) REFERENCES `sym_node_group_link` (`source_node_group_id`, `target_node_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_router`
--

INSERT INTO `sym_router` VALUES ('beta-2-c4rgo',NULL,NULL,NULL,'beta','c4rgo','default',NULL,1,1,1,1,'2020-10-09 01:03:19',NULL,'2020-10-09 01:03:19',NULL);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_I_FOR_SYM_RTR_C4RG after insert on `c4rg0airv2`.`sym_router`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_router',                                                                                                                                            
                                      'I',                                                                                                                                                             
                                      2,                                                                                                                                             
                                      concat(
          cast(if(new.`router_id` is null,'',concat('"',replace(replace(new.`router_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_catalog_name` is null,'',concat('"',replace(replace(new.`target_catalog_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_schema_name` is null,'',concat('"',replace(replace(new.`target_schema_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_table_name` is null,'',concat('"',replace(replace(new.`target_table_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_node_group_id` is null,'',concat('"',replace(replace(new.`source_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_node_group_id` is null,'',concat('"',replace(replace(new.`target_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`router_type` is null,'',concat('"',replace(replace(new.`router_type`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`router_expression` is null,'',concat('"',replace(replace(new.`router_expression`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`sync_on_update` is null,'',concat('"',cast(new.`sync_on_update` as char),'"')),',',
          if(new.`sync_on_insert` is null,'',concat('"',cast(new.`sync_on_insert` as char),'"')),',',
          if(new.`sync_on_delete` is null,'',concat('"',cast(new.`sync_on_delete` as char),'"')),',',
          if(new.`use_source_catalog_schema` is null,'',concat('"',cast(new.`use_source_catalog_schema` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')),',',
          cast(if(new.`description` is null,'',concat('"',replace(replace(new.`description`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_U_FOR_SYM_RTR_C4RG after update on `c4rg0airv2`.`sym_router`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                  DECLARE var_row_data mediumtext character set utf8;                                                                                                                                      
                                  DECLARE var_old_data mediumtext character set utf8;                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                   set var_row_data = concat(
          cast(if(new.`router_id` is null,'',concat('"',replace(replace(new.`router_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_catalog_name` is null,'',concat('"',replace(replace(new.`target_catalog_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_schema_name` is null,'',concat('"',replace(replace(new.`target_schema_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_table_name` is null,'',concat('"',replace(replace(new.`target_table_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_node_group_id` is null,'',concat('"',replace(replace(new.`source_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_node_group_id` is null,'',concat('"',replace(replace(new.`target_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`router_type` is null,'',concat('"',replace(replace(new.`router_type`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`router_expression` is null,'',concat('"',replace(replace(new.`router_expression`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`sync_on_update` is null,'',concat('"',cast(new.`sync_on_update` as char),'"')),',',
          if(new.`sync_on_insert` is null,'',concat('"',cast(new.`sync_on_insert` as char),'"')),',',
          if(new.`sync_on_delete` is null,'',concat('"',cast(new.`sync_on_delete` as char),'"')),',',
          if(new.`use_source_catalog_schema` is null,'',concat('"',cast(new.`use_source_catalog_schema` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')),',',
          cast(if(new.`description` is null,'',concat('"',replace(replace(new.`description`,'\\','\\\\'),'"','\\"'),'"')) as char));                                                                                                                              
                                   set var_old_data = concat(null);                                                                                                                           
                                   if 1=1 then                                                                                                                                  
                                        insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                        values(                                                                                                                                                           
                                          'sym_router',                                                                                                                                           
                                          'U',                                                                                                                                                            
                                          2,                                                                                                                                            
                                          concat(
          cast(if(old.`router_id` is null,'',concat('"',replace(replace(old.`router_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                               
                                           ),                                                                                                                                                             
                                          var_row_data,                                                                                                                                                   
                                          var_old_data,                                                                                                                                                   
                                          'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                       
                                          null,                                                                                                                                              
                                          CURRENT_TIMESTAMP                                                                                                                                               
                                        );                                                                                                                                                                
                                    end if;                                                                                                                                                               
                                  end if;                                                                                                                                                                
                                                                                                                                                                                    
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_D_FOR_SYM_RTR_C4RG after delete on `c4rg0airv2`.`sym_router`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_router',                                                                                                                                            
                                      'D',                                                                                                                                                             
                                      2,                                                                                                                                             
                                      concat(
          cast(if(old.`router_id` is null,'',concat('"',replace(replace(old.`router_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                       concat(null                                                                                                                                            
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;

--
-- Table structure for table `sym_sequence`
--

CREATE TABLE `sym_sequence` (
  `sequence_name` varchar(50) NOT NULL,
  `current_value` bigint(20) NOT NULL DEFAULT '0',
  `increment_by` int(11) NOT NULL DEFAULT '1',
  `min_value` bigint(20) NOT NULL DEFAULT '1',
  `max_value` bigint(20) NOT NULL DEFAULT '9999999999',
  `cycle_flag` smallint(6) DEFAULT '0',
  `cache_size` int(11) NOT NULL DEFAULT '0',
  `create_time` datetime DEFAULT NULL,
  `last_update_by` varchar(50) DEFAULT NULL,
  `last_update_time` datetime NOT NULL,
  PRIMARY KEY (`sequence_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_sequence`
--

INSERT INTO `sym_sequence` VALUES ('extract_request',1,1,1,9999999999,0,0,'2020-10-09 00:30:21','system','2020-10-09 00:30:21'),('outgoing_batch',4661,1,1,9999999999,0,10,'2020-10-09 00:30:21','system','2020-11-09 20:09:50'),('outgoing_batch_load_id',1,1,1,9999999999,0,0,'2020-10-09 00:30:21','system','2020-10-09 00:30:21'),('trigger_hist',29,1,1,9999999999,0,0,'2020-10-09 00:30:21','system','2020-10-09 01:46:24');

--
-- Table structure for table `sym_table_reload_request`
--

CREATE TABLE `sym_table_reload_request` (
  `target_node_id` varchar(50) NOT NULL,
  `source_node_id` varchar(50) NOT NULL,
  `trigger_id` varchar(128) NOT NULL,
  `router_id` varchar(50) NOT NULL,
  `create_time` datetime NOT NULL,
  `create_table` smallint(6) NOT NULL DEFAULT '0',
  `delete_first` smallint(6) NOT NULL DEFAULT '0',
  `reload_select` mediumtext,
  `before_custom_sql` mediumtext,
  `reload_time` datetime DEFAULT NULL,
  `load_id` bigint(20) DEFAULT NULL,
  `processed` smallint(6) NOT NULL DEFAULT '0',
  `channel_id` varchar(128) DEFAULT NULL,
  `last_update_by` varchar(50) DEFAULT NULL,
  `last_update_time` datetime NOT NULL,
  PRIMARY KEY (`target_node_id`,`source_node_id`,`trigger_id`,`router_id`,`create_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_table_reload_request`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_I_FOR_SYM_TBL_RLD_RQST_C4RG after insert on `c4rg0airv2`.`sym_table_reload_request`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_table_reload_request',                                                                                                                                            
                                      'I',                                                                                                                                                             
                                      7,                                                                                                                                             
                                      concat(
          cast(if(new.`target_node_id` is null,'',concat('"',replace(replace(new.`target_node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_node_id` is null,'',concat('"',replace(replace(new.`source_node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`trigger_id` is null,'',concat('"',replace(replace(new.`trigger_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`router_id` is null,'',concat('"',replace(replace(new.`router_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          if(new.`create_table` is null,'',concat('"',cast(new.`create_table` as char),'"')),',',
          if(new.`delete_first` is null,'',concat('"',cast(new.`delete_first` as char),'"')),',',
          cast(if(new.`reload_select` is null,'',concat('"',replace(replace(new.`reload_select`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`before_custom_sql` is null,'',concat('"',replace(replace(new.`before_custom_sql`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`reload_time` is null,'',concat('"',cast(new.`reload_time` as char),'"')),',',
          if(new.`load_id` is null,'',concat('"',cast(new.`load_id` as char),'"')),',',
          if(new.`processed` is null,'',concat('"',cast(new.`processed` as char),'"')),',',
          cast(if(new.`channel_id` is null,'',concat('"',replace(replace(new.`channel_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"'))                                                                                                                                                
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_U_FOR_SYM_TBL_RLD_RQST_C4RG after update on `c4rg0airv2`.`sym_table_reload_request`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                  DECLARE var_row_data mediumtext character set utf8;                                                                                                                                      
                                  DECLARE var_old_data mediumtext character set utf8;                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                   set var_row_data = concat(
          cast(if(new.`target_node_id` is null,'',concat('"',replace(replace(new.`target_node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_node_id` is null,'',concat('"',replace(replace(new.`source_node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`trigger_id` is null,'',concat('"',replace(replace(new.`trigger_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`router_id` is null,'',concat('"',replace(replace(new.`router_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          if(new.`create_table` is null,'',concat('"',cast(new.`create_table` as char),'"')),',',
          if(new.`delete_first` is null,'',concat('"',cast(new.`delete_first` as char),'"')),',',
          cast(if(new.`reload_select` is null,'',concat('"',replace(replace(new.`reload_select`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`before_custom_sql` is null,'',concat('"',replace(replace(new.`before_custom_sql`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`reload_time` is null,'',concat('"',cast(new.`reload_time` as char),'"')),',',
          if(new.`load_id` is null,'',concat('"',cast(new.`load_id` as char),'"')),',',
          if(new.`processed` is null,'',concat('"',cast(new.`processed` as char),'"')),',',
          cast(if(new.`channel_id` is null,'',concat('"',replace(replace(new.`channel_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')));                                                                                                                              
                                   set var_old_data = concat(null);                                                                                                                           
                                   if 1=1 then                                                                                                                                  
                                        insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                        values(                                                                                                                                                           
                                          'sym_table_reload_request',                                                                                                                                           
                                          'U',                                                                                                                                                            
                                          7,                                                                                                                                            
                                          concat(
          cast(if(old.`target_node_id` is null,'',concat('"',replace(replace(old.`target_node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`source_node_id` is null,'',concat('"',replace(replace(old.`source_node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`trigger_id` is null,'',concat('"',replace(replace(old.`trigger_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`router_id` is null,'',concat('"',replace(replace(old.`router_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(old.`create_time` is null,'',concat('"',cast(old.`create_time` as char),'"'))                                                                                                                                               
                                           ),                                                                                                                                                             
                                          var_row_data,                                                                                                                                                   
                                          var_old_data,                                                                                                                                                   
                                          'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                       
                                          null,                                                                                                                                              
                                          CURRENT_TIMESTAMP                                                                                                                                               
                                        );                                                                                                                                                                
                                    end if;                                                                                                                                                               
                                  end if;                                                                                                                                                                
                                                                                                                                                                                    
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_D_FOR_SYM_TBL_RLD_RQST_C4RG after delete on `c4rg0airv2`.`sym_table_reload_request`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_table_reload_request',                                                                                                                                            
                                      'D',                                                                                                                                                             
                                      7,                                                                                                                                             
                                      concat(
          cast(if(old.`target_node_id` is null,'',concat('"',replace(replace(old.`target_node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`source_node_id` is null,'',concat('"',replace(replace(old.`source_node_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`trigger_id` is null,'',concat('"',replace(replace(old.`trigger_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`router_id` is null,'',concat('"',replace(replace(old.`router_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(old.`create_time` is null,'',concat('"',cast(old.`create_time` as char),'"'))                                                                                                                                                
                                       ),                                                                                                                                                              
                                       concat(null                                                                                                                                            
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;

--
-- Table structure for table `sym_table_reload_status`
--

CREATE TABLE `sym_table_reload_status` (
  `load_id` bigint(20) NOT NULL,
  `source_node_id` varchar(50) NOT NULL,
  `target_node_id` varchar(50) NOT NULL,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `completed` smallint(6) NOT NULL DEFAULT '0',
  `cancelled` smallint(6) NOT NULL DEFAULT '0',
  `start_data_batch_id` bigint(20) DEFAULT NULL,
  `end_data_batch_id` bigint(20) DEFAULT NULL,
  `setup_batch_count` bigint(20) NOT NULL DEFAULT '0',
  `data_batch_count` bigint(20) NOT NULL DEFAULT '0',
  `finalize_batch_count` bigint(20) NOT NULL DEFAULT '0',
  `setup_batch_loaded` bigint(20) NOT NULL DEFAULT '0',
  `data_batch_loaded` bigint(20) NOT NULL DEFAULT '0',
  `finalize_batch_loaded` bigint(20) NOT NULL DEFAULT '0',
  `table_count` bigint(20) NOT NULL DEFAULT '0',
  `rows_loaded` bigint(20) NOT NULL DEFAULT '0',
  `rows_count` bigint(20) NOT NULL DEFAULT '0',
  `error_flag` smallint(6) NOT NULL DEFAULT '0',
  `sql_state` varchar(10) DEFAULT NULL,
  `sql_code` int(11) NOT NULL DEFAULT '0',
  `sql_message` mediumtext,
  `last_update_by` varchar(50) DEFAULT NULL,
  `last_update_time` datetime NOT NULL,
  PRIMARY KEY (`load_id`,`source_node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_table_reload_status`
--


--
-- Table structure for table `sym_transform_column`
--

CREATE TABLE `sym_transform_column` (
  `transform_id` varchar(50) NOT NULL,
  `include_on` char(1) NOT NULL DEFAULT '*',
  `target_column_name` varchar(128) NOT NULL,
  `source_column_name` varchar(128) DEFAULT NULL,
  `pk` smallint(6) DEFAULT '0',
  `transform_type` varchar(50) DEFAULT 'copy',
  `transform_expression` mediumtext,
  `transform_order` int(11) NOT NULL DEFAULT '1',
  `create_time` datetime DEFAULT NULL,
  `last_update_by` varchar(50) DEFAULT NULL,
  `last_update_time` datetime DEFAULT NULL,
  `description` mediumtext,
  PRIMARY KEY (`transform_id`,`include_on`,`target_column_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_transform_column`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_I_FOR_SYM_TRNSFRM_CLMN_C4RG after insert on `c4rg0airv2`.`sym_transform_column`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_transform_column',                                                                                                                                            
                                      'I',                                                                                                                                                             
                                      13,                                                                                                                                             
                                      concat(
          cast(if(new.`transform_id` is null,'',concat('"',replace(replace(new.`transform_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`include_on` is null,'',concat('"',replace(replace(new.`include_on`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_column_name` is null,'',concat('"',replace(replace(new.`target_column_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_column_name` is null,'',concat('"',replace(replace(new.`source_column_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`pk` is null,'',concat('"',cast(new.`pk` as char),'"')),',',
          cast(if(new.`transform_type` is null,'',concat('"',replace(replace(new.`transform_type`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`transform_expression` is null,'',concat('"',replace(replace(new.`transform_expression`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`transform_order` is null,'',concat('"',cast(new.`transform_order` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')),',',
          cast(if(new.`description` is null,'',concat('"',replace(replace(new.`description`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_U_FOR_SYM_TRNSFRM_CLMN_C4RG after update on `c4rg0airv2`.`sym_transform_column`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                  DECLARE var_row_data mediumtext character set utf8;                                                                                                                                      
                                  DECLARE var_old_data mediumtext character set utf8;                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                   set var_row_data = concat(
          cast(if(new.`transform_id` is null,'',concat('"',replace(replace(new.`transform_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`include_on` is null,'',concat('"',replace(replace(new.`include_on`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_column_name` is null,'',concat('"',replace(replace(new.`target_column_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_column_name` is null,'',concat('"',replace(replace(new.`source_column_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`pk` is null,'',concat('"',cast(new.`pk` as char),'"')),',',
          cast(if(new.`transform_type` is null,'',concat('"',replace(replace(new.`transform_type`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`transform_expression` is null,'',concat('"',replace(replace(new.`transform_expression`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`transform_order` is null,'',concat('"',cast(new.`transform_order` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')),',',
          cast(if(new.`description` is null,'',concat('"',replace(replace(new.`description`,'\\','\\\\'),'"','\\"'),'"')) as char));                                                                                                                              
                                   set var_old_data = concat(null);                                                                                                                           
                                   if 1=1 then                                                                                                                                  
                                        insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                        values(                                                                                                                                                           
                                          'sym_transform_column',                                                                                                                                           
                                          'U',                                                                                                                                                            
                                          13,                                                                                                                                            
                                          concat(
          cast(if(old.`transform_id` is null,'',concat('"',replace(replace(old.`transform_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`include_on` is null,'',concat('"',replace(replace(old.`include_on`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`target_column_name` is null,'',concat('"',replace(replace(old.`target_column_name`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                               
                                           ),                                                                                                                                                             
                                          var_row_data,                                                                                                                                                   
                                          var_old_data,                                                                                                                                                   
                                          'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                       
                                          null,                                                                                                                                              
                                          CURRENT_TIMESTAMP                                                                                                                                               
                                        );                                                                                                                                                                
                                    end if;                                                                                                                                                               
                                  end if;                                                                                                                                                                
                                                                                                                                                                                    
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_D_FOR_SYM_TRNSFRM_CLMN_C4RG after delete on `c4rg0airv2`.`sym_transform_column`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_transform_column',                                                                                                                                            
                                      'D',                                                                                                                                                             
                                      13,                                                                                                                                             
                                      concat(
          cast(if(old.`transform_id` is null,'',concat('"',replace(replace(old.`transform_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`include_on` is null,'',concat('"',replace(replace(old.`include_on`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`target_column_name` is null,'',concat('"',replace(replace(old.`target_column_name`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                       concat(null                                                                                                                                            
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;

--
-- Table structure for table `sym_transform_table`
--

CREATE TABLE `sym_transform_table` (
  `transform_id` varchar(50) NOT NULL,
  `source_node_group_id` varchar(50) NOT NULL,
  `target_node_group_id` varchar(50) NOT NULL,
  `transform_point` varchar(10) NOT NULL,
  `source_catalog_name` varchar(255) DEFAULT NULL,
  `source_schema_name` varchar(255) DEFAULT NULL,
  `source_table_name` varchar(255) NOT NULL,
  `target_catalog_name` varchar(255) DEFAULT NULL,
  `target_schema_name` varchar(255) DEFAULT NULL,
  `target_table_name` varchar(255) DEFAULT NULL,
  `update_first` smallint(6) DEFAULT '0',
  `update_action` varchar(255) NOT NULL DEFAULT 'UPDATE_COL',
  `delete_action` varchar(10) NOT NULL,
  `transform_order` int(11) NOT NULL DEFAULT '1',
  `column_policy` varchar(10) NOT NULL DEFAULT 'SPECIFIED',
  `create_time` datetime DEFAULT NULL,
  `last_update_by` varchar(50) DEFAULT NULL,
  `last_update_time` datetime DEFAULT NULL,
  `description` mediumtext,
  PRIMARY KEY (`transform_id`,`source_node_group_id`,`target_node_group_id`),
  KEY `sym_fk_tt_2_grp_lnk` (`source_node_group_id`,`target_node_group_id`),
  CONSTRAINT `sym_fk_tt_2_grp_lnk` FOREIGN KEY (`source_node_group_id`, `target_node_group_id`) REFERENCES `sym_node_group_link` (`source_node_group_id`, `target_node_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_transform_table`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_I_FOR_SYM_TRNSFRM_TBL_C4RG after insert on `c4rg0airv2`.`sym_transform_table`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_transform_table',                                                                                                                                            
                                      'I',                                                                                                                                                             
                                      4,                                                                                                                                             
                                      concat(
          cast(if(new.`transform_id` is null,'',concat('"',replace(replace(new.`transform_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_node_group_id` is null,'',concat('"',replace(replace(new.`source_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_node_group_id` is null,'',concat('"',replace(replace(new.`target_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`transform_point` is null,'',concat('"',replace(replace(new.`transform_point`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_catalog_name` is null,'',concat('"',replace(replace(new.`source_catalog_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_schema_name` is null,'',concat('"',replace(replace(new.`source_schema_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_table_name` is null,'',concat('"',replace(replace(new.`source_table_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_catalog_name` is null,'',concat('"',replace(replace(new.`target_catalog_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_schema_name` is null,'',concat('"',replace(replace(new.`target_schema_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_table_name` is null,'',concat('"',replace(replace(new.`target_table_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`update_first` is null,'',concat('"',cast(new.`update_first` as char),'"')),',',
          cast(if(new.`update_action` is null,'',concat('"',replace(replace(new.`update_action`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`delete_action` is null,'',concat('"',replace(replace(new.`delete_action`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`transform_order` is null,'',concat('"',cast(new.`transform_order` as char),'"')),',',
          cast(if(new.`column_policy` is null,'',concat('"',replace(replace(new.`column_policy`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')),',',
          cast(if(new.`description` is null,'',concat('"',replace(replace(new.`description`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_U_FOR_SYM_TRNSFRM_TBL_C4RG after update on `c4rg0airv2`.`sym_transform_table`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                  DECLARE var_row_data mediumtext character set utf8;                                                                                                                                      
                                  DECLARE var_old_data mediumtext character set utf8;                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                   set var_row_data = concat(
          cast(if(new.`transform_id` is null,'',concat('"',replace(replace(new.`transform_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_node_group_id` is null,'',concat('"',replace(replace(new.`source_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_node_group_id` is null,'',concat('"',replace(replace(new.`target_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`transform_point` is null,'',concat('"',replace(replace(new.`transform_point`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_catalog_name` is null,'',concat('"',replace(replace(new.`source_catalog_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_schema_name` is null,'',concat('"',replace(replace(new.`source_schema_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_table_name` is null,'',concat('"',replace(replace(new.`source_table_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_catalog_name` is null,'',concat('"',replace(replace(new.`target_catalog_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_schema_name` is null,'',concat('"',replace(replace(new.`target_schema_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`target_table_name` is null,'',concat('"',replace(replace(new.`target_table_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`update_first` is null,'',concat('"',cast(new.`update_first` as char),'"')),',',
          cast(if(new.`update_action` is null,'',concat('"',replace(replace(new.`update_action`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`delete_action` is null,'',concat('"',replace(replace(new.`delete_action`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`transform_order` is null,'',concat('"',cast(new.`transform_order` as char),'"')),',',
          cast(if(new.`column_policy` is null,'',concat('"',replace(replace(new.`column_policy`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')),',',
          cast(if(new.`description` is null,'',concat('"',replace(replace(new.`description`,'\\','\\\\'),'"','\\"'),'"')) as char));                                                                                                                              
                                   set var_old_data = concat(null);                                                                                                                           
                                   if 1=1 then                                                                                                                                  
                                        insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                        values(                                                                                                                                                           
                                          'sym_transform_table',                                                                                                                                           
                                          'U',                                                                                                                                                            
                                          4,                                                                                                                                            
                                          concat(
          cast(if(old.`transform_id` is null,'',concat('"',replace(replace(old.`transform_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`source_node_group_id` is null,'',concat('"',replace(replace(old.`source_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`target_node_group_id` is null,'',concat('"',replace(replace(old.`target_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                               
                                           ),                                                                                                                                                             
                                          var_row_data,                                                                                                                                                   
                                          var_old_data,                                                                                                                                                   
                                          'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                       
                                          null,                                                                                                                                              
                                          CURRENT_TIMESTAMP                                                                                                                                               
                                        );                                                                                                                                                                
                                    end if;                                                                                                                                                               
                                  end if;                                                                                                                                                                
                                                                                                                                                                                    
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_D_FOR_SYM_TRNSFRM_TBL_C4RG after delete on `c4rg0airv2`.`sym_transform_table`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_transform_table',                                                                                                                                            
                                      'D',                                                                                                                                                             
                                      4,                                                                                                                                             
                                      concat(
          cast(if(old.`transform_id` is null,'',concat('"',replace(replace(old.`transform_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`source_node_group_id` is null,'',concat('"',replace(replace(old.`source_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(old.`target_node_group_id` is null,'',concat('"',replace(replace(old.`target_node_group_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                       concat(null                                                                                                                                            
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;

--
-- Table structure for table `sym_trigger`
--

CREATE TABLE `sym_trigger` (
  `trigger_id` varchar(128) NOT NULL,
  `source_catalog_name` varchar(255) DEFAULT NULL,
  `source_schema_name` varchar(255) DEFAULT NULL,
  `source_table_name` varchar(255) NOT NULL,
  `channel_id` varchar(128) NOT NULL,
  `reload_channel_id` varchar(128) NOT NULL DEFAULT 'reload',
  `sync_on_update` smallint(6) NOT NULL DEFAULT '1',
  `sync_on_insert` smallint(6) NOT NULL DEFAULT '1',
  `sync_on_delete` smallint(6) NOT NULL DEFAULT '1',
  `sync_on_incoming_batch` smallint(6) NOT NULL DEFAULT '0',
  `name_for_update_trigger` varchar(255) DEFAULT NULL,
  `name_for_insert_trigger` varchar(255) DEFAULT NULL,
  `name_for_delete_trigger` varchar(255) DEFAULT NULL,
  `sync_on_update_condition` mediumtext,
  `sync_on_insert_condition` mediumtext,
  `sync_on_delete_condition` mediumtext,
  `custom_before_update_text` mediumtext,
  `custom_before_insert_text` mediumtext,
  `custom_before_delete_text` mediumtext,
  `custom_on_update_text` mediumtext,
  `custom_on_insert_text` mediumtext,
  `custom_on_delete_text` mediumtext,
  `external_select` mediumtext,
  `tx_id_expression` mediumtext,
  `channel_expression` mediumtext,
  `excluded_column_names` mediumtext,
  `included_column_names` mediumtext,
  `sync_key_names` mediumtext,
  `use_stream_lobs` smallint(6) NOT NULL DEFAULT '0',
  `use_capture_lobs` smallint(6) NOT NULL DEFAULT '0',
  `use_capture_old_data` smallint(6) NOT NULL DEFAULT '1',
  `use_handle_key_updates` smallint(6) NOT NULL DEFAULT '1',
  `stream_row` smallint(6) NOT NULL DEFAULT '0',
  `create_time` datetime NOT NULL,
  `last_update_by` varchar(50) DEFAULT NULL,
  `last_update_time` datetime NOT NULL,
  `description` mediumtext,
  PRIMARY KEY (`trigger_id`),
  KEY `sym_fk_trg_2_chnl` (`channel_id`),
  KEY `sym_fk_trg_2_rld_chnl` (`reload_channel_id`),
  CONSTRAINT `sym_fk_trg_2_chnl` FOREIGN KEY (`channel_id`) REFERENCES `sym_channel` (`channel_id`),
  CONSTRAINT `sym_fk_trg_2_rld_chnl` FOREIGN KEY (`reload_channel_id`) REFERENCES `sym_channel` (`channel_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_trigger`
--

INSERT INTO `sym_trigger` VALUES ('address_book',NULL,NULL,'address_book','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('aero_porti',NULL,NULL,'aero_porti','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 00:00:00',NULL,'2020-10-09 00:00:00',NULL),('airline_companies',NULL,NULL,'airline_companies','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('alert',NULL,NULL,'alert','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('area',NULL,NULL,'area','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('awbexport',NULL,NULL,'awbexport','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('awbexport_storico',NULL,NULL,'awbexport_storico','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('awbimport',NULL,NULL,'awbimport','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('aziende',NULL,NULL,'aziende','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('aziende_aziende',NULL,NULL,'aziende_aziende','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('a_awbexport',NULL,NULL,'a_awbexport','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('barcode',NULL,NULL,'barcode','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('c4rgo_news',NULL,NULL,'c4rgo_news','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('coeff_peso_volumetrico',NULL,NULL,'coeff_peso_volumetrico','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('day_month',NULL,NULL,'day_month','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('device',NULL,NULL,'device','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('devices',NULL,NULL,'devices','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('dmxled_light',NULL,NULL,'dmxled_light','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('dmxled_light_channels',NULL,NULL,'dmxled_light_channels','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('email',NULL,NULL,'email','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('encoded_url',NULL,NULL,'encoded_url','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('fotografie',NULL,NULL,'fotografie','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('gruppi',NULL,NULL,'gruppi','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('log3dlab',NULL,NULL,'log3dlab','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('login_log',NULL,NULL,'login_log','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('luoghi',NULL,NULL,'luoghi','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('macchine',NULL,NULL,'macchine','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('migration_versions',NULL,NULL,'migration_versions','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('nazioni',NULL,NULL,'nazioni','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('note',NULL,NULL,'note','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('pallets',NULL,NULL,'pallets','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('pallets_aziende',NULL,NULL,'pallets_aziende','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('pallets_nazioni',NULL,NULL,'pallets_nazioni','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('pallets_vettori',NULL,NULL,'pallets_vettori','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('profili',NULL,NULL,'profili','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('queries_model',NULL,NULL,'queries_model','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('roles',NULL,NULL,'roles','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('session',NULL,NULL,'session','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('setupcheck',NULL,NULL,'setupcheck','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('setupmodel',NULL,NULL,'setupmodel','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('sped',NULL,NULL,'sped','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('target',NULL,NULL,'target','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('target_vettori',NULL,NULL,'target_vettori','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('teventi',NULL,NULL,'teventi','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('traduzioni',NULL,NULL,'traduzioni','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('um',NULL,NULL,'um','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('upload',NULL,NULL,'upload','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('user',NULL,NULL,'user','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('user_gruppi',NULL,NULL,'user_gruppi','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('vettori',NULL,NULL,'vettori','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('volume',NULL,NULL,'volume','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL),('weight',NULL,NULL,'weight','c4rgo_transaction','reload',1,1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,1,1,0,'2020-10-09 02:18:56',NULL,'2020-10-09 02:18:56',NULL);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_I_FOR_SYM_TRGGR_C4RG after insert on `c4rg0airv2`.`sym_trigger`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, row_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_trigger',                                                                                                                                            
                                      'I',                                                                                                                                                             
                                      26,                                                                                                                                             
                                      concat(
          cast(if(new.`trigger_id` is null,'',concat('"',replace(replace(new.`trigger_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_catalog_name` is null,'',concat('"',replace(replace(new.`source_catalog_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_schema_name` is null,'',concat('"',replace(replace(new.`source_schema_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_table_name` is null,'',concat('"',replace(replace(new.`source_table_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`channel_id` is null,'',concat('"',replace(replace(new.`channel_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`reload_channel_id` is null,'',concat('"',replace(replace(new.`reload_channel_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`sync_on_update` is null,'',concat('"',cast(new.`sync_on_update` as char),'"')),',',
          if(new.`sync_on_insert` is null,'',concat('"',cast(new.`sync_on_insert` as char),'"')),',',
          if(new.`sync_on_delete` is null,'',concat('"',cast(new.`sync_on_delete` as char),'"')),',',
          if(new.`sync_on_incoming_batch` is null,'',concat('"',cast(new.`sync_on_incoming_batch` as char),'"')),',',
          cast(if(new.`name_for_update_trigger` is null,'',concat('"',replace(replace(new.`name_for_update_trigger`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`name_for_insert_trigger` is null,'',concat('"',replace(replace(new.`name_for_insert_trigger`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`name_for_delete_trigger` is null,'',concat('"',replace(replace(new.`name_for_delete_trigger`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`sync_on_update_condition` is null,'',concat('"',replace(replace(new.`sync_on_update_condition`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`sync_on_insert_condition` is null,'',concat('"',replace(replace(new.`sync_on_insert_condition`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`sync_on_delete_condition` is null,'',concat('"',replace(replace(new.`sync_on_delete_condition`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_before_update_text` is null,'',concat('"',replace(replace(new.`custom_before_update_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_before_insert_text` is null,'',concat('"',replace(replace(new.`custom_before_insert_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_before_delete_text` is null,'',concat('"',replace(replace(new.`custom_before_delete_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_on_update_text` is null,'',concat('"',replace(replace(new.`custom_on_update_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_on_insert_text` is null,'',concat('"',replace(replace(new.`custom_on_insert_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_on_delete_text` is null,'',concat('"',replace(replace(new.`custom_on_delete_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`external_select` is null,'',concat('"',replace(replace(new.`external_select`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`tx_id_expression` is null,'',concat('"',replace(replace(new.`tx_id_expression`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`channel_expression` is null,'',concat('"',replace(replace(new.`channel_expression`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`excluded_column_names` is null,'',concat('"',replace(replace(new.`excluded_column_names`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`included_column_names` is null,'',concat('"',replace(replace(new.`included_column_names`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`sync_key_names` is null,'',concat('"',replace(replace(new.`sync_key_names`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`use_stream_lobs` is null,'',concat('"',cast(new.`use_stream_lobs` as char),'"')),',',
          if(new.`use_capture_lobs` is null,'',concat('"',cast(new.`use_capture_lobs` as char),'"')),',',
          if(new.`use_capture_old_data` is null,'',concat('"',cast(new.`use_capture_old_data` as char),'"')),',',
          if(new.`use_handle_key_updates` is null,'',concat('"',cast(new.`use_handle_key_updates` as char),'"')),',',
          if(new.`stream_row` is null,'',concat('"',cast(new.`stream_row` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')),',',
          cast(if(new.`description` is null,'',concat('"',replace(replace(new.`description`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_U_FOR_SYM_TRGGR_C4RG after update on `c4rg0airv2`.`sym_trigger`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                  DECLARE var_row_data mediumtext character set utf8;                                                                                                                                      
                                  DECLARE var_old_data mediumtext character set utf8;                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                   set var_row_data = concat(
          cast(if(new.`trigger_id` is null,'',concat('"',replace(replace(new.`trigger_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_catalog_name` is null,'',concat('"',replace(replace(new.`source_catalog_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_schema_name` is null,'',concat('"',replace(replace(new.`source_schema_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`source_table_name` is null,'',concat('"',replace(replace(new.`source_table_name`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`channel_id` is null,'',concat('"',replace(replace(new.`channel_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`reload_channel_id` is null,'',concat('"',replace(replace(new.`reload_channel_id`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`sync_on_update` is null,'',concat('"',cast(new.`sync_on_update` as char),'"')),',',
          if(new.`sync_on_insert` is null,'',concat('"',cast(new.`sync_on_insert` as char),'"')),',',
          if(new.`sync_on_delete` is null,'',concat('"',cast(new.`sync_on_delete` as char),'"')),',',
          if(new.`sync_on_incoming_batch` is null,'',concat('"',cast(new.`sync_on_incoming_batch` as char),'"')),',',
          cast(if(new.`name_for_update_trigger` is null,'',concat('"',replace(replace(new.`name_for_update_trigger`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`name_for_insert_trigger` is null,'',concat('"',replace(replace(new.`name_for_insert_trigger`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`name_for_delete_trigger` is null,'',concat('"',replace(replace(new.`name_for_delete_trigger`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`sync_on_update_condition` is null,'',concat('"',replace(replace(new.`sync_on_update_condition`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`sync_on_insert_condition` is null,'',concat('"',replace(replace(new.`sync_on_insert_condition`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`sync_on_delete_condition` is null,'',concat('"',replace(replace(new.`sync_on_delete_condition`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_before_update_text` is null,'',concat('"',replace(replace(new.`custom_before_update_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_before_insert_text` is null,'',concat('"',replace(replace(new.`custom_before_insert_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_before_delete_text` is null,'',concat('"',replace(replace(new.`custom_before_delete_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_on_update_text` is null,'',concat('"',replace(replace(new.`custom_on_update_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_on_insert_text` is null,'',concat('"',replace(replace(new.`custom_on_insert_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`custom_on_delete_text` is null,'',concat('"',replace(replace(new.`custom_on_delete_text`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`external_select` is null,'',concat('"',replace(replace(new.`external_select`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`tx_id_expression` is null,'',concat('"',replace(replace(new.`tx_id_expression`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`channel_expression` is null,'',concat('"',replace(replace(new.`channel_expression`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`excluded_column_names` is null,'',concat('"',replace(replace(new.`excluded_column_names`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`included_column_names` is null,'',concat('"',replace(replace(new.`included_column_names`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          cast(if(new.`sync_key_names` is null,'',concat('"',replace(replace(new.`sync_key_names`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`use_stream_lobs` is null,'',concat('"',cast(new.`use_stream_lobs` as char),'"')),',',
          if(new.`use_capture_lobs` is null,'',concat('"',cast(new.`use_capture_lobs` as char),'"')),',',
          if(new.`use_capture_old_data` is null,'',concat('"',cast(new.`use_capture_old_data` as char),'"')),',',
          if(new.`use_handle_key_updates` is null,'',concat('"',cast(new.`use_handle_key_updates` as char),'"')),',',
          if(new.`stream_row` is null,'',concat('"',cast(new.`stream_row` as char),'"')),',',
          if(new.`create_time` is null,'',concat('"',cast(new.`create_time` as char),'"')),',',
          cast(if(new.`last_update_by` is null,'',concat('"',replace(replace(new.`last_update_by`,'\\','\\\\'),'"','\\"'),'"')) as char),',',
          if(new.`last_update_time` is null,'',concat('"',cast(new.`last_update_time` as char),'"')),',',
          cast(if(new.`description` is null,'',concat('"',replace(replace(new.`description`,'\\','\\\\'),'"','\\"'),'"')) as char));                                                                                                                              
                                   set var_old_data = concat(null);                                                                                                                           
                                   if 1=1 then                                                                                                                                  
                                        insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, row_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                        values(                                                                                                                                                           
                                          'sym_trigger',                                                                                                                                           
                                          'U',                                                                                                                                                            
                                          26,                                                                                                                                            
                                          concat(
          cast(if(old.`trigger_id` is null,'',concat('"',replace(replace(old.`trigger_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                               
                                           ),                                                                                                                                                             
                                          var_row_data,                                                                                                                                                   
                                          var_old_data,                                                                                                                                                   
                                          'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                       
                                          null,                                                                                                                                              
                                          CURRENT_TIMESTAMP                                                                                                                                               
                                        );                                                                                                                                                                
                                    end if;                                                                                                                                                               
                                  end if;                                                                                                                                                                
                                                                                                                                                                                    
                                end */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`c4rgosync`@`localhost`*/ /*!50003 trigger SYM_ON_D_FOR_SYM_TRGGR_C4RG after delete on `c4rg0airv2`.`sym_trigger`                                                                                                                                
                                for each row begin                                                                                                                                                     
                                   
                                  if 1=1 and 1=1 then                                                                                                 
                                    insert into `c4rg0airv2`.sym_data (table_name, event_type, trigger_hist_id, pk_data, old_data, channel_id, transaction_id, source_node_id, external_data, create_time)
                                    values(                                                                                                                                                            
                                      'sym_trigger',                                                                                                                                            
                                      'D',                                                                                                                                                             
                                      26,                                                                                                                                             
                                      concat(
          cast(if(old.`trigger_id` is null,'',concat('"',replace(replace(old.`trigger_id`,'\\','\\\\'),'"','\\"'),'"')) as char)                                                                                                                                                
                                       ),                                                                                                                                                              
                                       concat(null                                                                                                                                            
                                       ),                                                                                                                                                              
                                      'config', `c4rg0airv2`.sym_transaction_id_post_5_7_6(), @sync_node_disabled,                                                                                                        
                                      null,                                                                                                                                               
                                      CURRENT_TIMESTAMP                                                                                                                                                
                                    );                                                                                                                                                                 
                                  end if;                                                                                                                                                              
                                                                                                                                                                                  
                                end */;;
DELIMITER ;

--
-- Table structure for table `sym_trigger_hist`
--

CREATE TABLE `sym_trigger_hist` (
  `trigger_hist_id` int(11) NOT NULL,
  `trigger_id` varchar(128) NOT NULL,
  `source_table_name` varchar(255) NOT NULL,
  `source_catalog_name` varchar(255) DEFAULT NULL,
  `source_schema_name` varchar(255) DEFAULT NULL,
  `name_for_update_trigger` varchar(255) DEFAULT NULL,
  `name_for_insert_trigger` varchar(255) DEFAULT NULL,
  `name_for_delete_trigger` varchar(255) DEFAULT NULL,
  `table_hash` bigint(20) NOT NULL DEFAULT '0',
  `trigger_row_hash` bigint(20) NOT NULL DEFAULT '0',
  `trigger_template_hash` bigint(20) NOT NULL DEFAULT '0',
  `column_names` mediumtext NOT NULL,
  `pk_column_names` mediumtext NOT NULL,
  `last_trigger_build_reason` char(1) NOT NULL,
  `error_message` mediumtext,
  `create_time` datetime NOT NULL,
  `inactive_time` datetime DEFAULT NULL,
  PRIMARY KEY (`trigger_hist_id`),
  KEY `sym_idx_trigg_hist_1` (`trigger_id`,`inactive_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `sym_trigger_hist`
--

INSERT INTO `sym_trigger_hist` VALUES (2,'sym_router','sym_router',NULL,NULL,'SYM_ON_U_FOR_SYM_RTR_C4RG','SYM_ON_I_FOR_SYM_RTR_C4RG','SYM_ON_D_FOR_SYM_RTR_C4RG',1901800562,3231278683,-2030579433,'router_id,target_catalog_name,target_schema_name,target_table_name,source_node_group_id,target_node_group_id,router_type,router_expression,sync_on_update,sync_on_insert,sync_on_delete,use_source_catalog_schema,create_time,last_update_by,last_update_time,description','router_id','N',NULL,'2020-10-09 01:46:20',NULL),(3,'sym_monitor_event','sym_monitor_event',NULL,NULL,NULL,NULL,NULL,1276764766,4051316816,-2030579433,'monitor_id,node_id,event_time,host_name,type,threshold,event_value,event_count,severity_level,is_resolved,is_notified,details,last_update_time','monitor_id,node_id,event_time','N',NULL,'2020-10-09 01:46:20',NULL),(4,'sym_transform_table','sym_transform_table',NULL,NULL,'SYM_ON_U_FOR_SYM_TRNSFRM_TBL_C4RG','SYM_ON_I_FOR_SYM_TRNSFRM_TBL_C4RG','SYM_ON_D_FOR_SYM_TRNSFRM_TBL_C4RG',1582970010,1629115999,-2030579433,'transform_id,source_node_group_id,target_node_group_id,transform_point,source_catalog_name,source_schema_name,source_table_name,target_catalog_name,target_schema_name,target_table_name,update_first,update_action,delete_action,transform_order,column_policy,create_time,last_update_by,last_update_time,description','transform_id,source_node_group_id,target_node_group_id','N',NULL,'2020-10-09 01:46:20',NULL),(5,'sym_parameter','sym_parameter',NULL,NULL,'SYM_ON_U_FOR_SYM_PRMTR_C4RG','SYM_ON_I_FOR_SYM_PRMTR_C4RG','SYM_ON_D_FOR_SYM_PRMTR_C4RG',20794562,1702573883,-2030579433,'external_id,node_group_id,param_key,param_value,create_time,last_update_by,last_update_time','external_id,node_group_id,param_key','N',NULL,'2020-10-09 01:46:20',NULL),(6,'sym_file_trigger_router','sym_file_trigger_router',NULL,NULL,'SYM_ON_U_FOR_SYM_FL_TRGGR_RTR_C4RG','SYM_ON_I_FOR_SYM_FL_TRGGR_RTR_C4RG','SYM_ON_D_FOR_SYM_FL_TRGGR_RTR_C4RG',1565898805,1397890447,-2030579433,'trigger_id,router_id,enabled,initial_load_enabled,target_base_dir,conflict_strategy,create_time,last_update_by,last_update_time,description','trigger_id,router_id','N',NULL,'2020-10-09 01:46:20',NULL),(7,'sym_table_reload_request','sym_table_reload_request',NULL,NULL,'SYM_ON_U_FOR_SYM_TBL_RLD_RQST_C4RG','SYM_ON_I_FOR_SYM_TBL_RLD_RQST_C4RG','SYM_ON_D_FOR_SYM_TBL_RLD_RQST_C4RG',-435589491,-4318721206,-2030579433,'target_node_id,source_node_id,trigger_id,router_id,create_time,create_table,delete_first,reload_select,before_custom_sql,reload_time,load_id,processed,channel_id,last_update_by,last_update_time','target_node_id,source_node_id,trigger_id,router_id,create_time','N',NULL,'2020-10-09 01:46:20',NULL),(8,'sym_node_identity','sym_node_identity',NULL,NULL,NULL,NULL,NULL,-316145662,174380036,-2030579433,'node_id','node_id','N',NULL,'2020-10-09 01:46:20',NULL),(9,'sym_grouplet_link','sym_grouplet_link',NULL,NULL,'SYM_ON_U_FOR_SYM_GRPLT_LNK_C4RG','SYM_ON_I_FOR_SYM_GRPLT_LNK_C4RG','SYM_ON_D_FOR_SYM_GRPLT_LNK_C4RG',-857162473,-1762748893,-2030579433,'grouplet_id,external_id,create_time,last_update_by,last_update_time','grouplet_id,external_id','N',NULL,'2020-10-09 01:46:20',NULL),(10,'sym_grouplet','sym_grouplet',NULL,NULL,'SYM_ON_U_FOR_SYM_GRPLT_C4RG','SYM_ON_I_FOR_SYM_GRPLT_C4RG','SYM_ON_D_FOR_SYM_GRPLT_C4RG',2068645995,-887944639,-2030579433,'grouplet_id,grouplet_link_policy,description,create_time,last_update_by,last_update_time','grouplet_id','N',NULL,'2020-10-09 01:46:21',NULL),(11,'sym_file_snapshot','sym_file_snapshot',NULL,NULL,NULL,NULL,NULL,1101630419,4211646430,-2030579433,'trigger_id,router_id,relative_dir,file_name,channel_id,reload_channel_id,last_event_type,crc32_checksum,file_size,file_modified_time,last_update_time,last_update_by,create_time','trigger_id,router_id,relative_dir,file_name','N',NULL,'2020-10-09 01:46:21',NULL),(12,'sym_file_trigger','sym_file_trigger',NULL,NULL,'SYM_ON_U_FOR_SYM_FL_TRGGR_C4RG','SYM_ON_I_FOR_SYM_FL_TRGGR_C4RG','SYM_ON_D_FOR_SYM_FL_TRGGR_C4RG',-2117755350,3323015091,-2030579433,'trigger_id,channel_id,reload_channel_id,base_dir,recurse,includes_files,excludes_files,sync_on_create,sync_on_modified,sync_on_delete,sync_on_ctl_file,delete_after_sync,before_copy_script,after_copy_script,create_time,last_update_by,last_update_time,description','trigger_id','N',NULL,'2020-10-09 01:46:21',NULL),(13,'sym_transform_column','sym_transform_column',NULL,NULL,'SYM_ON_U_FOR_SYM_TRNSFRM_CLMN_C4RG','SYM_ON_I_FOR_SYM_TRNSFRM_CLMN_C4RG','SYM_ON_D_FOR_SYM_TRNSFRM_CLMN_C4RG',-1256237366,3191583451,-2030579433,'transform_id,include_on,target_column_name,source_column_name,pk,transform_type,transform_expression,transform_order,create_time,last_update_by,last_update_time,description','transform_id,include_on,target_column_name','N',NULL,'2020-10-09 01:46:21',NULL),(14,'sym_job','sym_job',NULL,NULL,'SYM_ON_U_FOR_SYM_JB_C4RG','SYM_ON_I_FOR_SYM_JB_C4RG','SYM_ON_D_FOR_SYM_JB_C4RG',-1668680188,-4232244381,-2030579433,'job_name,job_type,requires_registration,job_expression,description,default_schedule,default_auto_start,node_group_id,create_by,create_time,last_update_by,last_update_time','job_name','N',NULL,'2020-10-09 01:46:21',NULL),(15,'sym_trigger_router','sym_trigger_router',NULL,NULL,'SYM_ON_U_FOR_SYM_TRGGR_RTR_C4RG','SYM_ON_I_FOR_SYM_TRGGR_RTR_C4RG','SYM_ON_D_FOR_SYM_TRGGR_RTR_C4RG',-1390746229,-1644689623,-2030579433,'trigger_id,router_id,enabled,initial_load_order,initial_load_select,initial_load_delete_stmt,ping_back_enabled,create_time,last_update_by,last_update_time,description','trigger_id,router_id','N',NULL,'2020-10-09 01:46:21',NULL),(16,'sym_node','sym_node',NULL,NULL,'SYM_ON_U_FOR_SYM_ND_C4RG','SYM_ON_I_FOR_SYM_ND_C4RG','SYM_ON_D_FOR_SYM_ND_C4RG',-1399520623,3539544666,-2030579433,'node_id,node_group_id,external_id,sync_enabled,sync_url,schema_version,symmetric_version,config_version,database_type,database_version,database_name,batch_to_send_count,batch_in_error_count,created_at_node_id,deployment_type,deployment_sub_type','node_id','N',NULL,'2020-10-09 01:46:21',NULL),(17,'sym_node_group_channel_wnd','sym_node_group_channel_wnd',NULL,NULL,'SYM_ON_U_FOR_SYM_ND_GRP_CHNNL_WND_C4RG','SYM_ON_I_FOR_SYM_ND_GRP_CHNNL_WND_C4RG','SYM_ON_D_FOR_SYM_ND_GRP_CHNNL_WND_C4RG',-480315337,2150344881,-2030579433,'node_group_id,channel_id,start_time,end_time,enabled','node_group_id,channel_id,start_time,end_time','N',NULL,'2020-10-09 01:46:22',NULL),(18,'sym_notification','sym_notification',NULL,NULL,'SYM_ON_U_FOR_SYM_NTFCTN_C4RG','SYM_ON_I_FOR_SYM_NTFCTN_C4RG','SYM_ON_D_FOR_SYM_NTFCTN_C4RG',768920742,-4007733857,-2030579433,'notification_id,node_group_id,external_id,severity_level,type,expression,enabled,create_time,last_update_by,last_update_time','notification_id','N',NULL,'2020-10-09 01:46:22',NULL),(19,'sym_node_group_link','sym_node_group_link',NULL,NULL,'SYM_ON_U_FOR_SYM_ND_GRP_LNK_C4RG','SYM_ON_I_FOR_SYM_ND_GRP_LNK_C4RG','SYM_ON_D_FOR_SYM_ND_GRP_LNK_C4RG',189015728,-3732898793,-2030579433,'source_node_group_id,target_node_group_id,data_event_action,sync_config_enabled,is_reversible,create_time,last_update_by,last_update_time','source_node_group_id,target_node_group_id','N',NULL,'2020-10-09 01:46:22',NULL),(20,'sym_node_group','sym_node_group',NULL,NULL,'SYM_ON_U_FOR_SYM_ND_GRP_C4RG','SYM_ON_I_FOR_SYM_ND_GRP_C4RG','SYM_ON_D_FOR_SYM_ND_GRP_C4RG',1596481068,-4310067,-2030579433,'node_group_id,description,create_time,last_update_by,last_update_time','node_group_id','N',NULL,'2020-10-09 01:46:22',NULL),(21,'sym_node_security','sym_node_security',NULL,NULL,'SYM_ON_U_FOR_SYM_ND_SCRTY_C4RG','SYM_ON_I_FOR_SYM_ND_SCRTY_C4RG','SYM_ON_D_FOR_SYM_ND_SCRTY_C4RG',-511042602,-4037796816,-2030579433,'node_id,node_password,registration_enabled,registration_time,initial_load_enabled,initial_load_time,initial_load_id,initial_load_create_by,rev_initial_load_enabled,rev_initial_load_time,rev_initial_load_id,rev_initial_load_create_by,failed_logins,created_at_node_id','node_id','N',NULL,'2020-10-09 01:46:22',NULL),(22,'sym_load_filter','sym_load_filter',NULL,NULL,'SYM_ON_U_FOR_SYM_LD_FLTR_C4RG','SYM_ON_I_FOR_SYM_LD_FLTR_C4RG','SYM_ON_D_FOR_SYM_LD_FLTR_C4RG',-1547885316,2334881227,-2030579433,'load_filter_id,load_filter_type,source_node_group_id,target_node_group_id,target_catalog_name,target_schema_name,target_table_name,filter_on_update,filter_on_insert,filter_on_delete,before_write_script,after_write_script,batch_complete_script,batch_commit_script,batch_rollback_script,handle_error_script,create_time,last_update_by,last_update_time,load_filter_order,fail_on_error','load_filter_id','N',NULL,'2020-10-09 01:46:23',NULL),(23,'sym_monitor','sym_monitor',NULL,NULL,'SYM_ON_U_FOR_SYM_MNTR_C4RG','SYM_ON_I_FOR_SYM_MNTR_C4RG','SYM_ON_D_FOR_SYM_MNTR_C4RG',-176885072,1967279773,-2030579433,'monitor_id,node_group_id,external_id,type,expression,threshold,run_period,run_count,severity_level,enabled,create_time,last_update_by,last_update_time','monitor_id','N',NULL,'2020-10-09 01:46:24',NULL),(24,'sym_extension','sym_extension',NULL,NULL,'SYM_ON_U_FOR_SYM_XTNSN_C4RG','SYM_ON_I_FOR_SYM_XTNSN_C4RG','SYM_ON_D_FOR_SYM_XTNSN_C4RG',-14740505,-3431462809,-2030579433,'extension_id,extension_type,interface_name,node_group_id,enabled,extension_order,extension_text,create_time,last_update_by,last_update_time','extension_id','N',NULL,'2020-10-09 01:46:24',NULL),(25,'sym_conflict','sym_conflict',NULL,NULL,'SYM_ON_U_FOR_SYM_CNFLCT_C4RG','SYM_ON_I_FOR_SYM_CNFLCT_C4RG','SYM_ON_D_FOR_SYM_CNFLCT_C4RG',-1241867523,-3060788371,-2030579433,'conflict_id,source_node_group_id,target_node_group_id,target_channel_id,target_catalog_name,target_schema_name,target_table_name,detect_type,detect_expression,resolve_type,ping_back,resolve_changes_only,resolve_row_only,create_time,last_update_by,last_update_time','conflict_id','N',NULL,'2020-10-09 01:46:24',NULL),(26,'sym_trigger','sym_trigger',NULL,NULL,'SYM_ON_U_FOR_SYM_TRGGR_C4RG','SYM_ON_I_FOR_SYM_TRGGR_C4RG','SYM_ON_D_FOR_SYM_TRGGR_C4RG',-1766625412,-2625142951,-2030579433,'trigger_id,source_catalog_name,source_schema_name,source_table_name,channel_id,reload_channel_id,sync_on_update,sync_on_insert,sync_on_delete,sync_on_incoming_batch,name_for_update_trigger,name_for_insert_trigger,name_for_delete_trigger,sync_on_update_condition,sync_on_insert_condition,sync_on_delete_condition,custom_before_update_text,custom_before_insert_text,custom_before_delete_text,custom_on_update_text,custom_on_insert_text,custom_on_delete_text,external_select,tx_id_expression,channel_expression,excluded_column_names,included_column_names,sync_key_names,use_stream_lobs,use_capture_lobs,use_capture_old_data,use_handle_key_updates,stream_row,create_time,last_update_by,last_update_time,description','trigger_id','N',NULL,'2020-10-09 01:46:24',NULL),(27,'sym_channel','sym_channel',NULL,NULL,'SYM_ON_U_FOR_SYM_CHNNL_C4RG','SYM_ON_I_FOR_SYM_CHNNL_C4RG','SYM_ON_D_FOR_SYM_CHNNL_C4RG',343239883,972541423,-2030579433,'channel_id,processing_order,max_batch_size,max_batch_to_send,max_data_to_route,extract_period_millis,enabled,use_old_data_to_route,use_row_data_to_route,use_pk_data_to_route,reload_flag,file_sync_flag,contains_big_lob,batch_algorithm,data_loader_type,description,queue,max_network_kbps,data_event_action,create_time,last_update_by,last_update_time','channel_id','N',NULL,'2020-10-09 01:46:24',NULL),(28,'sym_trigger_router_grouplet','sym_trigger_router_grouplet',NULL,NULL,'SYM_ON_U_FOR_SYM_TRGGR_RTR_GRPLT_C4RG','SYM_ON_I_FOR_SYM_TRGGR_RTR_GRPLT_C4RG','SYM_ON_D_FOR_SYM_TRGGR_RTR_GRPLT_C4RG',-409252687,2234511807,-2030579433,'grouplet_id,trigger_id,router_id,applies_when,create_time,last_update_by,last_update_time','grouplet_id,trigger_id,router_id,applies_when','N',NULL,'2020-10-09 01:46:24',NULL),(29,'sym_node_host','sym_node_host',NULL,NULL,'SYM_ON_U_FOR_SYM_ND_HST_C4RG','SYM_ON_I_FOR_SYM_ND_HST_C4RG','SYM_ON_D_FOR_SYM_ND_HST_C4RG',636388791,994622394,-2030579433,'node_id,host_name,instance_id,ip_address,os_user,os_name,os_arch,os_version,available_processors,free_memory_bytes,total_memory_bytes,max_memory_bytes,java_version,java_vendor,jdbc_version,symmetric_version,timezone_offset,heartbeat_time,last_restart_time,create_time','node_id,host_name','N',NULL,'2020-10-09 01:46:25',NULL);

--
