expand users.first, middle, and last from 16 to 30 characters to match

what the Registrar's Office is currently doing, and expand
users.fullname from 32 to 92 characters so that code doesn't have to
worry about whether or not the concatenated first, middle, and last
names are too long to fit in it.

diff --git a/db/schema.sql b/db/schema.sql
index 7bd54dcbfb0439085ac7fe27562ec256902ec8cb..c3e3637fbc9eb612dd36a4a2adc39d27b4b8dfe9 100644 (file)
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -4,9 +4,9 @@ create table users
        users_id        INTEGER         DEFAULT 0       NOT NULL,
        unix_uid        SMALLINT        DEFAULT 0       NOT NULL,
        shell           VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
-       last            VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
-       first           VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
-       middle          VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
+       last            VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
+       first           VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
+       middle          VARCHAR(30)     DEFAULT CHR(0)  NOT NULL,
        status          SMALLINT        DEFAULT 0       NOT NULL,
        clearid         VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        type            VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
@@ -14,7 +14,7 @@ create table users
        modtime         DATE            DEFAULT SYSDATE NOT NULL,
        modby           INTEGER         DEFAULT 0       NOT NULL,
        modwith         VARCHAR(8)      DEFAULT CHR(0)  NOT NULL,
-       fullname        VARCHAR(32)     DEFAULT CHR(0)  NOT NULL,
+       fullname        VARCHAR(92)     DEFAULT CHR(0)  NOT NULL,
        nickname        VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,
        home_addr       VARCHAR(82)     DEFAULT CHR(0)  NOT NULL,
        home_phone      VARCHAR(16)     DEFAULT CHR(0)  NOT NULL,