From: zacheiss <zacheiss>
Date: Fri, 27 Jul 2001 07:29:27 +0000 (+0000)
Subject: Make all phone fields 24 characters long.
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/68d17ac6afbdfc001fff5fe521cdf12f6f912488

Make all phone fields 24 characters long.
---

diff --git a/db/schema.sql b/db/schema.sql
index 1b21ade7..e6ae9697 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -18,9 +18,9 @@ create table users
 	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 @@ create table users
 	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,