summaryrefslogtreecommitdiff
path: root/contrib/rserv/slave.sql.in
diff options
context:
space:
mode:
Diffstat (limited to 'contrib/rserv/slave.sql.in')
-rw-r--r--contrib/rserv/slave.sql.in22
1 files changed, 22 insertions, 0 deletions
diff --git a/contrib/rserv/slave.sql.in b/contrib/rserv/slave.sql.in
new file mode 100644
index 0000000000..93ac5caced
--- /dev/null
+++ b/contrib/rserv/slave.sql.in
@@ -0,0 +1,22 @@
+-- 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
+);