Make hwtype column in printers table bigger.

[moira.git] / db / schema.sql

diff --git a/db/schema.sql b/db/schema.sql
index 27c02557201805b81801c49956ae0ed1ac5664ba..136c461a8de0b829e2970f98a4257c96140313b9 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,
@@ -52,7 +53,8 @@ create table users
        winhomedir      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
+       sponsor_id      INTEGER         DEFAULT 0       NOT NULL,
+       expiration      VARCHAR(24)     DEFAULT CHR(0)  NOT NULL
 );
 
 create table krbmap
@@ -327,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,