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	dpavlin	1.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	dpavlin	1.2	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	dpavlin	1.1	);
15
16			drop table _RSERV_SLAVE_SYNC_;
17
18			create table _RSERV_SLAVE_SYNC_
19			(
20	dpavlin	1.2	syncid int4 not null,
21	dpavlin	1.1	synctime timestamp
22			);