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,    -- table name
        cname  name,    -- column name
        reloid  oid,    -- table oid
        key             int4    -- key attnum 
);

drop table _RSERV_SLAVE_SYNC_;

create table _RSERV_SLAVE_SYNC_
(
        syncid          int4,
        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, -- table name
11	cname name, -- column name
12	reloid oid, -- table oid
13	key int4 -- key attnum
14	);
15
16	drop table _RSERV_SLAVE_SYNC_;
17
18	create table _RSERV_SLAVE_SYNC_
19	(
20	syncid int4,
21	synctime timestamp
22	);