From 01cae672dbd41baebfd15f004c0336fd6da70097 Mon Sep 17 00:00:00 2001 From: danw Date: Sun, 20 Dec 1998 21:26:33 +0000 Subject: [PATCH] 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) --- db/schema.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/db/schema.sql b/db/schema.sql index 7246141c..59590ed5 100644 --- 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, -- 2.45.2