Remove usersids and listsids tables.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 25b91ea39e95ed4dc7a54653292a2f8065e0088d..a03920ec33ac11f54e49ede622a6855c2859a108 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -4,7 +4,7 @@ create table users
        users_id        INTEGER         DEFAULT 0       NOT NULL,
        unix_uid        SMALLINT        DEFAULT 0       NOT NULL,
        shell           VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
-       winconsoleshell VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       winconsoleshell VARCHAR(32)     DEFAULT 'cmd'   NOT NULL,
        last            VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
        first           VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
        middle          VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
@@ -44,8 +44,13 @@ create table users
        sigwho          INTEGER         DEFAULT 0       NOT NULL,
        signature       VARCHAR(68)     DEFAULT CHR(0)  NOT NULL,
        secure          INTEGER         DEFAULT 0       NOT NULL,       
+       pin             VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,
        reservations    VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,
-       flag            INTEGER         DEFAULT 0       NOT NULL
+       flag            INTEGER         DEFAULT 0       NOT NULL,
+       created         DATE            DEFAULT SYSDATE NOT NULL,
+       creator         INTEGER         DEFAULT 0       NOT NULL,
+       winhomedir      VARCHAR(260)    DEFAULT '[DFS]' NOT NULL,
+       winprofiledir   VARCHAR(260)    DEFAULT '[DFS]' NOT NULL
 );
 
 create table krbmap
@@ -62,8 +67,8 @@ create table machine
        model           VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,
        os              VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        location        VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
-       contact         VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
-       billing_contact VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       contact         VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
+       billing_contact VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
        account_number  VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,       
        use             INTEGER         DEFAULT 0       NOT NULL,
        status          INTEGER         DEFAULT 0       NOT NULL,
@@ -95,7 +100,7 @@ create table subnet
        snet_id         INTEGER         DEFAULT 0       NOT NULL,
        description     VARCHAR(48)     DEFAULT CHR(0)  NOT NULL,
        status          INTEGER         DEFAULT 0       NOT NULL,
-       contact         VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       contact         VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
        account_number  VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,
        saddr           INTEGER         DEFAULT 0       NOT NULL,
        mask            INTEGER         DEFAULT 0       NOT NULL,
@@ -144,6 +149,8 @@ create table list
        grouplist       INTEGER         DEFAULT 0       NOT NULL,
        gid             SMALLINT        DEFAULT 0       NOT NULL,
        nfsgroup        INTEGER         DEFAULT 0       NOT NULL,       
+       mailman         INTEGER         DEFAULT 0       NOT NULL,
+       mailman_id      INTEGER         DEFAULT 0       NOT NULL,
        description     VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
        acl_type        VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
        acl_id          INTEGER         DEFAULT 0       NOT NULL,
@@ -386,24 +393,12 @@ 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,
        cnt_id          INTEGER         DEFAULT 0       NOT NULL,
+       list_id         INTEGER         DEFAULT 0       NOT NULL,
+       publicflg       INTEGER         DEFAULT 0       NOT NULL,
        description     VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
        location        VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
        contact         VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,