rserv/misc/slave.sql

-- erServer
-- Slave server setup for erServer demonstration implementation
-- (c) 2000 Vadim Mikheev, PostgreSQL Inc.
--

drop table _RSERV_SLAVE_TABLES_;

create table _RSERV_SLAVE_TABLES_
(
        tname   name not null,  -- table name
        cname   name not null,  -- column name
        reloid  oid primary key, -- table oid
        key     int4 not null   -- key attnum 
);

drop table _RSERV_SLAVE_SYNC_;

create table _RSERV_SLAVE_SYNC_
(
        syncid          int4 not null,
        synctime        timestamp
);
1	-- erServer
2	-- Slave server setup for erServer demonstration implementation
3	-- (c) 2000 Vadim Mikheev, PostgreSQL Inc.
4	--
5
6	drop table _RSERV_SLAVE_TABLES_;
7
8	create table _RSERV_SLAVE_TABLES_
9	(
10	tname name not null, -- table name
11	cname name not null, -- column name
12	reloid oid primary key, -- table oid
13	key int4 not null -- key attnum
14	);
15
16	drop table _RSERV_SLAVE_SYNC_;
17
18	create table _RSERV_SLAVE_SYNC_
19	(
20	syncid int4 not null,
21	synctime timestamp
22	);