Schema changes for membership acls.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 7bd54dcbfb0439085ac7fe27562ec256902ec8cb..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
@@ -225,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,
@@ -314,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,