make department and xdept 50-characters long to match the Data

Warehouse. (We had previously been getting abbreviated names like
"Elec Eng & Comp Sci", but the Warehouse has names like "Electrical
Engineering & Computer Science, Dept Of", which we don't want to just
truncate)

diff --git a/db/schema.sql b/db/schema.sql
index 7246141c19101ee5479bb1e237ce4daef67ca606..59590ed52c67a7690ae3250f9a85154dd71cdd03 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -20,7 +20,7 @@ create table users
        home_phone      VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        office_addr     VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        office_phone    VARCHAR(12)     DEFAULT CHR(0)  NOT NULL,
-       department      VARCHAR(20)     DEFAULT CHR(0)  NOT NULL,
+       department      VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        affiliation     VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        fmodtime        DATE            DEFAULT SYSDATE NOT NULL,
        fmodby          INTEGER         DEFAULT 0       NOT NULL,
@@ -32,7 +32,7 @@ create table users
        pmodby          INTEGER         DEFAULT 0       NOT NULL,
        pmodwith        VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
        xname           VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
-       xdept           VARCHAR(20)     DEFAULT CHR(0)  NOT NULL,
+       xdept           VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        xtitle          VARCHAR(50)     DEFAULT CHR(0)  NOT NULL,
        xaddress        VARCHAR(82)     DEFAULT CHR(0)  NOT NULL,
        xphone1         VARCHAR(12)     DEFAULT CHR(0)  NOT NULL,