Changes from dtanner for password processing for w2k KDC, and some code

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index f29d21356dc9baaf0d7e1da6b6b111ac0058d4cf..b756465c72b72596f07367e1367ae3bef0afb6ee 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -63,6 +63,7 @@ create table machine
        os              VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        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,
        use             INTEGER         DEFAULT 0       NOT NULL,
        status          INTEGER         DEFAULT 0       NOT NULL,
        statuschange    DATE            DEFAULT SYSDATE NOT NULL,
@@ -264,7 +265,7 @@ 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 CHR(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,
@@ -380,3 +381,17 @@ create table incremental
        table_name      VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        service         VARCHAR(16)     DEFAULT CHR(0)  NOT NULL
 );
+
+create table usersids
+(
+       users_id        INTEGER         DEFAULT 0       NOT NULL,
+       sid             VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
+       created         DATE            DEFAULT SYSDATE NOT NULL
+);
+
+create table listsids
+(
+       list_id         INTEGER         DEFAULT 0       NOT NULL,
+       sid             VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
+       created         DATE            DEFAULT SYSDATE NOT NULL
+);