Increase size of list name column.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 763f05d7d1725a2ccbd62d8daeeeb27225b93e62..5760d4ae6441454cb4f52aac55beb87ab8faf9c5 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -30,6 +30,7 @@ create table users
        pop_id          INTEGER         DEFAULT 0       NOT NULL,
        imap_id         INTEGER         DEFAULT 0       NOT NULL,
        box_id          INTEGER         DEFAULT 0       NOT NULL,
+       exchange_id     INTEGER         DEFAULT 0       NOT NULL,
        pmodtime        DATE            DEFAULT SYSDATE NOT NULL,
        pmodby          INTEGER         DEFAULT 0       NOT NULL,
        pmodwith        VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
@@ -50,7 +51,10 @@ create table users
        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
+       winprofiledir   VARCHAR(260)    DEFAULT '[DFS]' NOT NULL,
+       sponsor_type    VARCHAR(8)      DEFAULT 'NONE'  NOT NULL,
+       sponsor_id      INTEGER         DEFAULT 0       NOT NULL,
+       expiration      VARCHAR(24)     DEFAULT CHR(0)  NOT NULL
 );
 
 create table krbmap
@@ -140,7 +144,7 @@ create table svc
 
 create table list
 (
-       name            VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       name            VARCHAR(56)     DEFAULT CHR(0)  NOT NULL,
        list_id         INTEGER         DEFAULT 0       NOT NULL,
        active          INTEGER         DEFAULT 0       NOT NULL,
        publicflg       INTEGER         DEFAULT 0       NOT NULL,
@@ -325,7 +329,7 @@ create table printers
 (
        name            VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        type            VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
-       hwtype          VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
+       hwtype          VARCHAR(64)     DEFAULT CHR(0)  NOT NULL,
        duplexname      VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        mach_id         INTEGER         DEFAULT 0       NOT NULL,
        loghost         INTEGER         DEFAULT 0       NOT NULL,