Add usersids and listsids tables.

diff --git a/db/dbopt.sql b/db/dbopt.sql
index 70384ac3cc216203ff2d936a93427143c152769f..2e4b573275c75d2c7a311bea98c74c73f9ff9191 100644 (file)
--- 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 2b7ffaf8d4a5dcd3ac4e524dd31c4d9d1576a9a0..7073f68faafbc0ba603c6564eea9c3c8ae78b59a 100644 (file)
--- 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 65a0feb3f7991adf0419c66566362275d6c747c6..eb40dbeba7b77af820fcb852c94c57541dfafcd6 100644 (file)
--- 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;