Remove usersids and listsids tables.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index c799ceeef8f620ad08bb0fedf523be2b2fb45547..a03920ec33ac11f54e49ede622a6855c2859a108 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 '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,
@@ -17,9 +18,9 @@ create table users
        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,
+       home_phone      VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,
        office_addr     VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
-       office_phone    VARCHAR(12)     DEFAULT CHR(0)  NOT NULL,
+       office_phone    VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,
        department      VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        affiliation     VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        fmodtime        DATE            DEFAULT SYSDATE 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,
@@ -35,15 +37,20 @@ create table users
        xdept           VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        xtitle          VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        xaddress        VARCHAR(82)     DEFAULT CHR(0)  NOT NULL,
-       xphone1         VARCHAR(12)     DEFAULT CHR(0)  NOT NULL,
-       xphone2         VARCHAR(12)     DEFAULT CHR(0)  NOT NULL,
+       xphone1         VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,
+       xphone2         VARCHAR(24)     DEFAULT CHR(0)  NOT NULL,
        xmodtime        DATE            DEFAULT SYSDATE NOT NULL,
        sigdate         INTEGER         DEFAULT 0       NOT NULL,
        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
@@ -60,7 +67,9 @@ 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,
+       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,
        statuschange    DATE            DEFAULT SYSDATE NOT NULL,
@@ -90,6 +99,9 @@ create table subnet
        name            VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        snet_id         INTEGER         DEFAULT 0       NOT NULL,
        description     VARCHAR(48)     DEFAULT CHR(0)  NOT NULL,
+       status          INTEGER         DEFAULT 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,
        low             INTEGER         DEFAULT 0       NOT NULL,
@@ -123,7 +135,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
@@ -136,9 +148,14 @@ 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,       
+       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,
+       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
@@ -226,8 +243,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,
@@ -259,6 +276,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
@@ -373,3 +392,32 @@ create table incremental
        table_name      VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        service         VARCHAR(16)     DEFAULT CHR(0)  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,
+       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
+);
+
+create table mcntmap
+(
+       mach_id         INTEGER         DEFAULT 0       NOT NULL,
+       cnt_id          INTEGER         DEFAULT 0       NOT NULL
+);
+
+create table accountnumbers
+(
+       account_number  VARCHAR(10)     DEFAULT CHR(0)  NOT NULL
+);