From de3d85c08a322e2546da6619d7cba842f5ba1f8f Mon Sep 17 00:00:00 2001
From: zacheiss <zacheiss>
Date: Wed, 25 Oct 2000 20:38:10 +0000
Subject: [PATCH] Add usersids and listsids tables.

---
 db/dbopt.sql    |  4 ++++
 db/schema.sql   | 14 ++++++++++++++
 db/unschema.sql |  2 ++
 3 files changed, 20 insertions(+)

diff --git a/db/dbopt.sql b/db/dbopt.sql
index 70384ac3..2e4b5732 100644
--- a/db/dbopt.sql
+++ b/db/dbopt.sql
@@ -84,3 +84,7 @@ create index i_prn_loc on printers (location);
 create index i_prn_con on printers (contact);
 
 create index i_cap_tag on capacls (tag);
+
+create index i_usersids_usid on usersids (users_id);
+
+create index i_listsids_lid on listsids (list_id);
diff --git a/db/schema.sql b/db/schema.sql
index 2b7ffaf8..7073f68f 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -380,3 +380,17 @@ create table incremental
 	table_name	VARCHAR(16)	DEFAULT CHR(0)	NOT NULL,
 	service		VARCHAR(16) 	DEFAULT CHR(0)	NOT NULL
 );
+
+create table usersids
+(
+	users_id	INTEGER		DEFAULT 0	NOT NULL,
+	sid		VARCHAR(64)	DEFAULT CHR(0)	NOT NULL,
+	created		DATE		DEFAULT SYSDATE	NOT NULL
+);
+
+create table listsids
+(
+	list_id		INTEGER		DEFAULT 0	NOT NULL,
+	sid		VARCHAR(64)	DEFAULT CHR(0)	NOT NULL,
+	created		DATE		DEFAULT SYSDATE	NOT NULL
+);
diff --git a/db/unschema.sql b/db/unschema.sql
index 65a0feb3..eb40dbeb 100644
--- a/db/unschema.sql
+++ b/db/unschema.sql
@@ -26,3 +26,5 @@ drop table alias;
 drop table numvalues;
 drop table tblstats;
 drop table incremental;
+drop table usersids;
+drop table listsids;
-- 
2.45.2