Remove usersids and listsids tables.

diff --git a/db/dbopt.sql b/db/dbopt.sql
index 95afed67c8720aa4f9274a1474480f60b01e7113..0ae04b42cbf26b04a15c9e9427517649d348909e 100644 (file)
--- a/db/dbopt.sql
+++ b/db/dbopt.sql
@@ -86,10 +86,6 @@ 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);
-
 create unique index i_containers_cntid on containers (cnt_id);
 create unique index i_containers_cname on containers (name);
 

diff --git a/db/schema.sql b/db/schema.sql
index b36a3c42dd98358cd30be9678d8aace5b825beeb..a03920ec33ac11f54e49ede622a6855c2859a108 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -393,20 +393,6 @@ create table incremental
        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
-);
-
 create table containers
 (
        name            VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,

diff --git a/db/unschema.sql b/db/unschema.sql
index 3a7bab58a417bc1b46a75d5cde8bae1fbc133b41..5f3c71e4391e04eff7558a4947ef25fa9b6bd4c9 100644 (file)
--- a/db/unschema.sql
+++ b/db/unschema.sql
@@ -26,8 +26,6 @@ drop table alias;
 drop table numvalues;
 drop table tblstats;
 drop table incremental;
-drop table usersids;
-drop table listsids;
 drop table containers;
 drop table mcntmap;
 drop table accountnumbers;