Schema changes for membership acls.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 35d523953558fd8e75ee6d24004999ab6e89cc2c..7f29c800b88f4c787b2a9dd0110d4db52c31831b 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -4,6 +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,
        last            VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
        first           VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
        middle          VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
@@ -137,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