Punt on the "NONE" stuff; the TNS folks decided they liked empty fields more.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index e6ae9697ee97aeac1467f8f46b762a281e7f704e..5ff0509c2dff2eb135b68fe77e08e5c9c8374b66 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -4,7 +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,
+       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,
@@ -45,7 +45,9 @@ create table users
        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
+       flag            INTEGER         DEFAULT 0       NOT NULL,
+       created         DATE            DEFAULT SYSDATE NOT NULL,
+       creator         INTEGER         DEFAULT 0       NOT NULL
 );
 
 create table krbmap
@@ -64,6 +66,7 @@ create table machine
        location        VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        contact         VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
        billing_contact VARCHAR(32)     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,
@@ -93,6 +96,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(32)     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,
@@ -398,7 +404,7 @@ create table listsids
 
 create table containers
 (
-       name            VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
+       name            VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
        cnt_id          INTEGER         DEFAULT 0       NOT NULL,
        description     VARCHAR(255)    DEFAULT CHR(0)  NOT NULL,
        location        VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
@@ -417,3 +423,8 @@ 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
+);