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	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			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			);