INSERT INTO sym_channel (channel_id, processing_order, max_batch_size, enabled, description) VALUES('channel_initial_load', 1, 100000, 1, 'Channel for initial load');

INSERT INTO sym_node_group (node_group_id, description) VALUES ('server', 'Server Node Group');
INSERT INTO sym_node_group (node_group_id, description) VALUES ('client', 'Client Node Group');

INSERT INTO sym_node_group_link (source_node_group_id, target_node_group_id, data_event_action) VALUES ('client', 'server', 'P');
INSERT INTO sym_node_group_link (source_node_group_id, target_node_group_id, data_event_action) VALUES ('server', 'client', 'W');

INSERT INTO sym_router (router_id, source_node_group_id, target_node_group_id, create_time, last_update_time) VALUES ('server-2-client','server', 'client', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
INSERT INTO sym_router (router_id, source_node_group_id, target_node_group_id, create_time, last_update_time) VALUES ('client-2-server','client', 'server', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

INSERT INTO sym_trigger (trigger_id,source_table_name,channel_id,last_update_time,create_time) VALUES('trigger_doctos_pv','doctos_pv','channel_initial_load',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
INSERT INTO sym_trigger (trigger_id,source_table_name,channel_id,last_update_time,create_time) VALUES('trigger_almacenes','almacenes','channel_initial_load',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);
INSERT INTO sym_trigger (trigger_id,source_table_name,channel_id,last_update_time,create_time) VALUES('trigger_cajas','cajas','channel_initial_load',CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);

-- Triggers with capture disabled, so they are used for initial load only
INSERT INTO sym_trigger (trigger_id,source_table_name,channel_id, sync_on_insert, sync_on_update, sync_on_delete,last_update_time,create_time) VALUES ('trigger_doctos_pv_initial_load','doctos_pv','channel_initial_load',0,0,0,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);

INSERT INTO sym_trigger (trigger_id,source_table_name,channel_id, sync_on_insert, sync_on_update, sync_on_delete,last_update_time,create_time) VALUES ('trigger_almacenes_initial_load','almacenes','channel_initial_load',0,0,0,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);

INSERT INTO sym_trigger (trigger_id,source_table_name,channel_id, sync_on_insert, sync_on_update, sync_on_delete,last_update_time,create_time) VALUES ('trigger_cajas_initial_load','cajas','channel_initial_load',0,0,0,CURRENT_TIMESTAMP,CURRENT_TIMESTAMP);

-- Enviar primero la carga inicial
INSERT INTO sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) VALUES ('trigger_doctos_pv_initial_load','server-2-client', 100, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

INSERT INTO sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) VALUES ('trigger_cajas_initial_load','server-2-client', 100, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

-- Send all items to all stores
INSERT INTO sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) VALUES('trigger_doctos_pv','server-2-client', 200, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

INSERT INTO sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) VALUES('trigger_cajas','server-2-client', 200, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
-- Enviar primero la carga inicial
INSERT INTO sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) VALUES ('trigger_almacenes_initial_load','server-2-client', 100, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);

-- Send all items to all stores
INSERT INTO sym_trigger_router (trigger_id,router_id,initial_load_order,last_update_time,create_time) VALUES('trigger_almacenes','server-2-client', 200, CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);