[1826] in Moira
phone number schema changes
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Tue Jul 24 22:13:37 2001
Message-Id: <200107250213.WAA19081@brad-majors.mit.edu>
To: moiradev@MIT.EDU
Date: Tue, 24 Jul 2001 22:13:35 -0400
From: Garry Zacheiss <zacheiss@MIT.EDU>
This patch makes all the phone number fields in the db 24
characters. Why not.
Garry
Index: schema.sql
===================================================================
RCS file: /afs/athena.mit.edu/astaff/project/moiradev/repository/moira/db/schema.sql,v
retrieving revision 1.22
diff -u -r1.22 schema.sql
--- schema.sql 2001/04/26 21:24:18 1.22
+++ schema.sql 2001/07/25 02:07:45
@@ -18,9 +18,9 @@
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,
+ home_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL,
office_addr VARCHAR(16) DEFAULT CHR(0) NOT NULL,
- office_phone VARCHAR(12) DEFAULT CHR(0) NOT NULL,
+ office_phone VARCHAR(24) 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,
@@ -37,8 +37,8 @@
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,
- xphone2 VARCHAR(12) DEFAULT CHR(0) NOT NULL,
+ xphone1 VARCHAR(24) DEFAULT CHR(0) NOT NULL,
+ xphone2 VARCHAR(24) DEFAULT CHR(0) NOT NULL,
xmodtime DATE DEFAULT SYSDATE NOT NULL,
sigdate INTEGER DEFAULT 0 NOT NULL,
sigwho INTEGER DEFAULT 0 NOT NULL,
