INSERT INTO r6174.sym_node
(node_id, node_group_id, external_id, sync_enabled, sync_url, schema_version, symmetric_version, database_type, database_version, heartbeat_time, timezone_offset, batch_to_send_count, batch_in_error_count, created_at_node_id, deployment_type)
VALUES('000', 'GR_POSTGRES', '000', 1, 'http://localhost:31415/sync/ENG_POSTGRES', '?', '3.8.4', 'PostgreSQL', '9.5', TO_DATE('2016-09-26 13:00:17','YYYY-MM-DD HH24:MI:SS'), '+02:00', -1, -1, NULL, 'server');
INSERT INTO r6174.sym_node
(node_id, node_group_id, external_id, sync_enabled, sync_url, schema_version, symmetric_version, database_type, database_version, heartbeat_time, timezone_offset, batch_to_send_count, batch_in_error_count, created_at_node_id, deployment_type)
VALUES('111', 'GR_ORA', '111', 1, 'http://localhost:31415/sync/ENG_ORACLE', '?', '3.8.4', 'Oracle', '11.2', TO_DATE('2016-09-26 10:42:30','YYYY-MM-DD HH24:MI:SS'), '+02:00', -1, -1, NULL, 'server');


INSERT INTO r6174.sym_node_group
(node_group_id, description, create_time, last_update_by, last_update_time)
VALUES('GR_LOCAL', NULL, NULL, NULL, NULL);
INSERT INTO r6174.sym_node_group
(node_group_id, description, create_time, last_update_by, last_update_time)
VALUES('GR_POSTGRES', NULL, NULL, NULL, NULL);
INSERT INTO r6174.sym_node_group
(node_group_id, description, create_time, last_update_by, last_update_time)
VALUES('GR_ORA', NULL, NULL, NULL, NULL);

INSERT INTO r6174.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('GR_POSTGRES', 'GR_LOCAL', 'R', 1, TO_DATE('2016-09-29 14:50:18','YYYY-MM-DD HH24:MI:SS'), '111
', TO_DATE('2016-09-29 14:50:27','YYYY-MM-DD HH24:MI:SS'));
INSERT INTO r6174.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('GR_ORA', 'GR_POSTGRES', 'P', 1, NULL, NULL, NULL);

INSERT INTO r6174.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('AUD_EVENT', NULL, NULL, NULL, 'GR_POSTGRES', 'GR_LOCAL', 'audit', NULL, 1, 1, 1, 1, TO_DATE('2016-09-29 16:13:34','YYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2016-09-29 16:13:37','YYYY-MM-DD HH24:MI:SS'));


INSERT INTO r6174.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, queue, max_network_kbps, create_time, last_update_by, last_update_time)
VALUES('CH_AUD_CSBE', 5, 10000, 10000, 100000, 0, 1, 1, 1, 1, 1, 0, 1, 'default', 'default', NULL, 'default', 0.000, TO_DATE('2016-09-29 15:54:32','YYYY-MM-DD HH24:MI:SS'), '111', TO_DATE('2016-09-29 15:54:36','YYYY-MM-DD HH24:MI:SS'));

INSERT INTO r6174.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_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, create_time, last_update_by, last_update_time)
VALUES('TR_AU_CSBE_EVENT', NULL, NULL, 'T_CSBE_EVENT', 'CH_AUD_CSBE', '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, 0, TO_DATE('2016-09-29 16:11:44','YYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2016-09-29 16:11:47','YYYY-MM-DD HH24:MI:SS'));

INSERT INTO r6174.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('TR_AU_CSBE_EVENT', 'AUD_EVENT', 1, 100, NULL, NULL, 1, 0, TO_DATE('2016-09-29 16:15:17','YYYY-MM-DD HH24:MI:SS'), NULL, TO_DATE('2016-09-29 16:15:22','YYYY-MM-DD HH24:MI:SS'));