Add usersids and listsids tables.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 9f1a215cb2f38754e9c7d45ef296e1403a252980..7073f68faafbc0ba603c6564eea9c3c8ae78b59a 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -4,9 +4,10 @@ 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,
-       last            VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
-       first           VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
-       middle          VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
+       winconsoleshell VARCHAR(32)     DEFAULT CHR(0)  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,
        status          SMALLINT        DEFAULT 0       NOT NULL,
        clearid         VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        type            VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
@@ -14,7 +15,7 @@ create table users
        modtime         DATE            DEFAULT SYSDATE NOT NULL,
        modby           INTEGER         DEFAULT 0       NOT NULL,
        modwith         VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
-       fullname        VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       fullname        VARCHAR(92)     DEFAULT CHR(0)  NOT NULL,
        nickname        VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        home_addr       VARCHAR(82)     DEFAULT CHR(0)  NOT NULL,
        home_phone      VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
@@ -27,6 +28,7 @@ create table users
        fmodwith        VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
        potype          VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
        pop_id          INTEGER         DEFAULT 0       NOT NULL,
+       imap_id         INTEGER         DEFAULT 0       NOT NULL,
        box_id          INTEGER         DEFAULT 0       NOT NULL,
        pmodtime        DATE            DEFAULT SYSDATE NOT NULL,
        pmodby          INTEGER         DEFAULT 0       NOT NULL,
@@ -42,6 +44,7 @@ create table users
        sigwho          INTEGER         DEFAULT 0       NOT NULL,
        signature       VARCHAR(68)     DEFAULT CHR(0)  NOT NULL,
        secure          INTEGER         DEFAULT 0       NOT NULL,       
+       reservations    VARCHAR(10)     DEFAULT CHR(0)  NOT NULL,
        flag            INTEGER         DEFAULT 0       NOT NULL
 );
 
@@ -122,7 +125,7 @@ create table svc
 (
        clu_id          INTEGER         DEFAULT 0       NOT NULL,
        serv_label      VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
-       serv_cluster    VARCHAR(32)     DEFAULT CHR(0)  NOT NULL
+       serv_cluster    VARCHAR(128)    DEFAULT CHR(0)  NOT NULL
 );
 
 create table list
@@ -135,9 +138,12 @@ create table list
        maillist        INTEGER         DEFAULT 0       NOT NULL,
        grouplist       INTEGER         DEFAULT 0       NOT NULL,
        gid             SMALLINT        DEFAULT 0       NOT NULL,
+       nfsgroup        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,
+       memacl_type     VARCHAR(8)      DEFAULT 'NONE'  NOT NULL,
+       memacl_id       INTEGER         DEFAULT 0       NOT NULL,
        modtime         DATE            DEFAULT SYSDATE NOT NULL,
        modby           INTEGER         DEFAULT 0       NOT NULL,
        modwith         VARCHAR(8)      DEFAULT CHR(0)  NOT NULL
@@ -148,6 +154,7 @@ create table imembers
        list_id         INTEGER         DEFAULT 0       NOT NULL,
        member_type     VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
        member_id       INTEGER         DEFAULT 0       NOT NULL,
+       tag             INTEGER         DEFAULT 0       NOT NULL,
        ref_count       SMALLINT        DEFAULT 0       NOT NULL,
        direct          SMALLINT        DEFAULT 0       NOT NULL
 );
@@ -224,8 +231,8 @@ create table nfsphys
 (
        nfsphys_id      INTEGER         DEFAULT 0       NOT NULL,
        mach_id         INTEGER         DEFAULT 0       NOT NULL,
-       device          VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
-       dir             VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
+       device          VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       dir             VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
        status          SMALLINT        DEFAULT 0       NOT NULL,
        allocated       INTEGER         DEFAULT 0       NOT NULL,
        partsize        INTEGER         DEFAULT 0       NOT NULL,
@@ -257,6 +264,8 @@ create table zephyr
        iws_id          INTEGER         DEFAULT 0       NOT NULL,
        iui_type        VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
        iui_id          INTEGER         DEFAULT 0       NOT NULL,
+       owner_type      VARCHAR(8)      DEFAULT 'NONE'  NOT NULL,
+       owner_id        INTEGER         DEFAULT 0       NOT NULL,
        modtime         DATE            DEFAULT SYSDATE NOT NULL,
        modby           INTEGER         DEFAULT 0       NOT NULL,
        modwith         VARCHAR(8)      DEFAULT CHR(0)  NOT NULL
@@ -272,6 +281,17 @@ create table hostaccess
        modwith         VARCHAR(8)      DEFAULT CHR(0)  NOT NULL
 );
 
+create table acl
+(
+       mach_id         INTEGER         DEFAULT 0       NOT NULL,
+       target          VARCHAR(128)    DEFAULT CHR(0)  NOT NULL,
+       kind            VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
+       list_id         INTEGER         DEFAULT 0       NOT NULL,
+       modtime         DATE            DEFAULT SYSDATE NOT NULL,
+       modby           INTEGER         DEFAULT 0       NOT NULL,
+       modwith         VARCHAR(8)      DEFAULT CHR(0)  NOT NULL
+);
+
 create table strings 
 (
        string_id       INTEGER         DEFAULT 0       NOT NULL,
@@ -302,6 +322,7 @@ create table printers
        rq              INTEGER         DEFAULT 0       NOT NULL,
        ka              SMALLINT        DEFAULT 0       NOT NULL,
        pc              SMALLINT        DEFAULT 0       NOT NULL,
+       mc              SMALLINT        DEFAULT 0       NOT NULL,
        ac              INTEGER         DEFAULT 0       NOT NULL,
        lpc_acl         INTEGER         DEFAULT 0       NOT NULL,
        banner          INTEGER         DEFAULT 0       NOT NULL,
@@ -359,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
+);