Schema changes for membership acls.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 571e975f561cf1fd9541e8cc0b7c27fd99ac034b..7f29c800b88f4c787b2a9dd0110d4db52c31831b 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 CHR(0)  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,
@@ -272,6 +279,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,
@@ -293,7 +311,7 @@ create table printers
 (
        name            VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        type            VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
-       hwtype          VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
+       hwtype          VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        duplexname      VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        mach_id         INTEGER         DEFAULT 0       NOT NULL,
        loghost         INTEGER         DEFAULT 0       NOT NULL,
@@ -302,6 +320,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,