IMAPpy goodness. add imap_id to users and make some device and dir

in nfsphys bigger

diff --git a/db/schema.sql b/db/schema.sql
index c799ceeef8f620ad08bb0fedf523be2b2fb45547..361e7babee08e168ba4f4a20d1cce7499b177f3f 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -27,6 +27,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,
@@ -226,8 +227,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,