From 9281a4c36d3fa78acbe7538d44269166fdce1f20 Mon Sep 17 00:00:00 2001 From: danw Date: Thu, 29 Jul 1999 00:20:32 +0000 Subject: [PATCH] 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. --- db/schema.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/db/schema.sql b/db/schema.sql index 7bd54dcb..c3e3637f 100644 --- 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, -- 2.45.2