Remove usersids and listsids tables.

[moira.git] / db / schema.sql

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,