/*
MAZI ME TO MirrorSetup.sql
*/
SET autocommit TO 'on';

CREATE TABLE dbmirror_ExplicitRepTables(
tblname varchar(100) PRIMARY KEY,
siteidkeyname varchar(20)
);

CREATE TABLE dbmirror_accounting(
tblname varchar(100) not null,
pkxpress varchar(100) not null,
slaveid int4 not null,
cnt int4 not null DEFAULT 1,
PRIMARY KEY(tblname,pkxpress,slaveid)
);

CREATE INDEX dbmirror_accounting_tblname_pkxpress on dbmirror_accounting(tblname,pkxpress);