delete from SYM_EXTENSION;
delete from SYM_FILE_TRIGGER_ROUTER;
delete from SYM_FILE_TRIGGER;
delete from SYM_TRIGGER_ROUTER_GROUPLET;
delete from SYM_GROUPLET_LINK;
delete from SYM_GROUPLET;
delete from SYM_CONFLICT;
delete from SYM_TRANSFORM_COLUMN;
delete from SYM_LOAD_FILTER;
delete from SYM_TRANSFORM_TABLE;
delete from SYM_TRIGGER_ROUTER;
delete from SYM_ROUTER;
delete from SYM_TRIGGER;
delete from SYM_NODE_GROUP_CHANNEL_WND;
delete from SYM_CHANNEL;
delete from SYM_PARAMETER;
delete from SYM_NODE_GROUP_LINK;
delete from SYM_NODE_GROUP;
insert into SYM_NODE_GROUP (NODE_GROUP_ID, DESCRIPTION, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('regsvr','group that represents the registration server',null,null,null);
insert into SYM_NODE_GROUP (NODE_GROUP_ID, DESCRIPTION, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('target','group that represents a target data source',null,null,null);
insert into SYM_NODE_GROUP (NODE_GROUP_ID, DESCRIPTION, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source1','group that represents a data source the provides data for the target.',null,null,null);
insert into SYM_NODE_GROUP (NODE_GROUP_ID, DESCRIPTION, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source2','group that represents a data source the provides data for the target.',null,null,null);
insert into SYM_NODE_GROUP (NODE_GROUP_ID, DESCRIPTION, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source3','group that represents a data source the provides data for the target.',null,null,null);
insert into SYM_NODE_GROUP (NODE_GROUP_ID, DESCRIPTION, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source4','group that represents a data source the provides data for the target.',null,null,null);
insert into SYM_NODE_GROUP (NODE_GROUP_ID, DESCRIPTION, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source5','group that represents a data source the provides data for the target.',null,null,null);
insert into SYM_NODE_GROUP (NODE_GROUP_ID, DESCRIPTION, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source6','group that represents a data source the provides data for the target.',null,null,null);
insert into SYM_NODE_GROUP (NODE_GROUP_ID, DESCRIPTION, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source7','group that represents a data source the provides data for the target.',null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('target','regsvr','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('regsvr','target','W',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source1','regsvr','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('regsvr','source1','W',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source2','regsvr','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('regsvr','source2','W',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source3','regsvr','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('regsvr','source3','W',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source4','regsvr','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('regsvr','source4','W',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source5','regsvr','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('regsvr','source5','W',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source6','regsvr','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('regsvr','source6','W',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source7','regsvr','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('regsvr','source7','W',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source1','target','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source2','target','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source3','target','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source4','target','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source5','target','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source6','target','P',1,null,null,null);
insert into SYM_NODE_GROUP_LINK (SOURCE_NODE_GROUP_ID, TARGET_NODE_GROUP_ID, DATA_EVENT_ACTION, SYNC_CONFIG_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('source7','target','P',1,null,null,null);
insert into SYM_PARAMETER (EXTERNAL_ID, NODE_GROUP_ID, PARAM_KEY, PARAM_VALUE, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('ALL','ALL','console.auth.config.client','true',{ts '2015-08-03 09:50:19.422'},'admin',{ts '2015-08-03 09:50:19.422'});
insert into SYM_CHANNEL (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, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('config',0,2000,100,10000,0,1,1,1,1,0,0,1,'default','default',null,{ts '2015-08-03 09:40:40.461'},null,{ts '2015-08-03 09:40:40.456'});
insert into SYM_CHANNEL (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, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('reload',1,1,1,10000,0,1,1,1,1,1,0,0,'default','default',null,{ts '2015-08-03 09:40:40.464'},null,{ts '2015-08-03 09:40:40.463'});
insert into SYM_CHANNEL (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, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('heartbeat',2,100,100,10000,0,1,1,1,1,0,0,0,'default','default',null,{ts '2015-08-03 09:40:40.465'},null,{ts '2015-08-03 09:40:40.465'});
insert into SYM_CHANNEL (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, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('default',99999,1000,100,10000,0,1,1,1,1,0,0,0,'default','default',null,{ts '2015-08-03 09:40:40.466'},null,{ts '2015-08-03 09:40:40.466'});
insert into SYM_CHANNEL (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, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('dynamic',99999,1000,100,10000,0,1,1,1,1,0,0,0,'default','default',null,{ts '2015-08-03 09:40:40.468'},null,{ts '2015-08-03 09:40:40.467'});
insert into SYM_CHANNEL (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, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('filesync',3,100,100,10000,0,1,1,1,1,0,1,0,'nontransactional','default',null,{ts '2015-08-03 09:40:40.469'},null,{ts '2015-08-03 09:40:40.468'});
insert into SYM_CHANNEL (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, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('filesync_reload',1,100,100,10000,0,1,1,1,1,1,1,0,'nontransactional','default',null,{ts '2015-08-03 09:40:40.470'},null,{ts '2015-08-03 09:40:40.470'});
insert into SYM_TRIGGER (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_ON_UPDATE_TEXT, CUSTOM_ON_INSERT_TEXT, CUSTOM_ON_DELETE_TEXT, EXTERNAL_SELECT, TX_ID_EXPRESSION, CHANNEL_EXPRESSION, EXCLUDED_COLUMN_NAMES, SYNC_KEY_NAMES, USE_STREAM_LOBS, USE_CAPTURE_LOBS, USE_CAPTURE_OLD_DATA, USE_HANDLE_KEY_UPDATES, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('test',null,null,'TEST','default','reload',1,1,1,0,null,null,null,'1=1','1=1','1=1',null,null,null,null,null,null,null,null,0,0,1,0,{ts '2015-08-03 09:50:43.367'},'admin',{ts '2015-08-03 09:50:43.367'});
insert into SYM_ROUTER (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) values ('source1_to_target',null,null,null,'source1','target','default',null,1,1,1,0,{ts '2015-08-03 09:40:40.489'},'console',{ts '2015-08-03 09:40:40.489'});
insert into SYM_ROUTER (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) values ('source2_to_target',null,null,null,'source2','target','default',null,1,1,1,0,{ts '2015-08-03 09:40:40.489'},'console',{ts '2015-08-03 09:40:40.489'});
insert into SYM_ROUTER (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) values ('source3_to_target',null,null,null,'source3','target','default',null,1,1,1,0,{ts '2015-08-03 09:40:40.489'},'console',{ts '2015-08-03 09:40:40.489'});
insert into SYM_ROUTER (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) values ('source4_to_target',null,null,null,'source4','target','default',null,1,1,1,0,{ts '2015-08-03 09:40:40.489'},'console',{ts '2015-08-03 09:40:40.489'});
insert into SYM_ROUTER (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) values ('source5_to_target',null,null,null,'source5','target','default',null,1,1,1,0,{ts '2015-08-03 09:40:40.489'},'console',{ts '2015-08-03 09:40:40.489'});
insert into SYM_ROUTER (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) values ('source6_to_target',null,null,null,'source6','target','default',null,1,1,1,0,{ts '2015-08-03 09:40:40.489'},'console',{ts '2015-08-03 09:40:40.489'});
insert into SYM_ROUTER (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) values ('source7_to_target',null,null,null,'source7','target','default',null,1,1,1,0,{ts '2015-08-03 09:40:40.489'},'console',{ts '2015-08-03 09:40:40.489'});
insert into SYM_TRIGGER_ROUTER (TRIGGER_ID, ROUTER_ID, ENABLED, INITIAL_LOAD_ORDER, INITIAL_LOAD_SELECT, INITIAL_LOAD_DELETE_STMT, INITIAL_LOAD_BATCH_COUNT, PING_BACK_ENABLED, CREATE_TIME, LAST_UPDATE_BY, LAST_UPDATE_TIME) values ('test','source1_to_target',1,50,null,null,1,0,{ts '2015-08-03 09:50:43.370'},null,{ts '2015-08-03 09:50:43.370'});