engine.name=company-000

db.driver=org.firebirdsql.jdbc.FBDriver
db.url=jdbc:firebirdsql:192.168.173.1/3050:c:/bdd/replications/source/D2018.gdb

db.user=SYSDBA
db.password=masterkey

registration.url=http://192.168.173.15:8080/sync/company-000
sync.url=http://192.168.173.15:8080/sync/company-000

group.id=company
external.id=000
job.purge.period.time.ms=7200000
job.routing.period.time.ms=5000
job.push.period.time.ms=10000
job.pull.period.time.ms=10000
initial.load.create.first=true


engine.name=interm-001

db.driver=org.firebirdsql.jdbc.FBDriver
db.url=jdbc:firebirdsql:192.168.173.15/3050:c:/bdd/replications/D2018.gdb

db.user=SYSDBA
db.password=masterkey

registration.url=http://192.168.173.15:8080/sync/company-000
sync.url=http://192.168.173.15:8585/sync/interm-001

group.id=interm
external.id=001
job.purge.period.time.ms=7200000
job.routing.period.time.ms=5000
job.push.period.time.ms=10000
job.pull.period.time.ms=10000
initial.load.create.first=true

insert into sym_node_group (node_group_id, description)
values ('company', 'company server');
insert into sym_node_group (node_group_id, description)
values ('interm', 'interm server');
insert into sym_node_group (node_group_id, description)
values ('web', 'web');

insert into sym_node_group_link (source_node_group_id, target_node_group_id, data_event_action)
values ('company', 'interm', 'W');
insert into sym_node_group_link (source_node_group_id, target_node_group_id, data_event_action)
values ('interm', 'web', 'W');

insert into sym_node (node_id, node_group_id, external_id, sync_enabled)
values ('000', 'company', '000', 1);
insert into sym_node_identity values ('000');

insert into sym_channel
(channel_id, processing_order, max_batch_size, enabled, description)
values('all_tables', 1, 100000, 1, 'All the tables');

insert into sym_trigger
(trigger_id,source_table_name,channel_id,last_update_time,create_time, sync_on_incoming_batch)
values('all_tables','*','all_tables',current_timestamp,current_timestamp, 1);

insert into sym_router
(router_id,source_node_group_id,target_node_group_id,router_type,create_time,last_update_time)
values('company_2_interm', 'company', 'interm', 'default',current_timestamp, current_timestamp);
insert into sym_router
(router_id,source_node_group_id,target_node_group_id,router_type,create_time,last_update_time)
values('interm_2_web', 'interm', 'web', 'default',current_timestamp, current_timestamp);

insert into sym_trigger_router
(trigger_id,router_id,initial_load_order,last_update_time,create_time)
values('all_tables','company_2_interm', 100, current_timestamp, current_timestamp);
insert into sym_trigger_router
(trigger_id,router_id,initial_load_order,last_update_time,create_time)
values('all_tables','interm_2_web', 100, current_timestamp, current_timestamp);

"..binsym"  --engine company-000 --port 8080
"..binsym" --engine interm-001 --port 8585
"..binsymadmin" --engine company-000 open-registration interm 001

engine.name=web-002

db.driver=org.firebirdsql.jdbc.FBDriver
db.url=jdbc:firebirdsql:192.168.173.16/3050:c:/bdd/replications/D2018.gdb

db.user=SYSDBA
db.password=masterkey

registration.url=http://192.168.173.15:8585/sync/interm-001
sync.url=http://192.168.173.16:9696/sync/web-002

group.id=web
external.id=002

job.purge.period.time.ms=7200000
job.routing.period.time.ms=5000
job.push.period.time.ms=10000
job.pull.period.time.ms=10000
initial.load.create.first=true

"..binsymadmin" --engine company-000 open-registration web 002
"..binsymadmin" --engine interm 001 open-registration web 002