[1991] in Moira
increase size of contact columns
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Tue Sep 24 18:34:20 2002
Message-Id: <200209242234.SAA27851@brad-majors.mit.edu>
To: moiradev@MIT.EDU
cc: jis@MIT.EDU
Date: Tue, 24 Sep 2002 18:34:18 -0400
From: Garry Zacheiss <zacheiss@MIT.EDU>
Ths increases the size of the contact and billing contact
columns in the machine table and the contact in the subnet table to 255
characters, as requested by Jeff.
Garry
Index: schema.sql
===================================================================
RCS file: /afs/athena.mit.edu/astaff/project/moiradev/repository/moira/db/schema.sql,v
retrieving revision 1.29
diff -u -r1.29 schema.sql
--- schema.sql 2002/08/02 10:30:58 1.29
+++ schema.sql 2002/09/24 22:33:02
@@ -65,8 +65,8 @@
model VARCHAR(24) DEFAULT CHR(0) NOT NULL,
os VARCHAR(16) DEFAULT CHR(0) NOT NULL,
location VARCHAR(16) DEFAULT CHR(0) NOT NULL,
- contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
- billing_contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
+ contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
+ billing_contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
use INTEGER DEFAULT 0 NOT NULL,
status INTEGER DEFAULT 0 NOT NULL,
@@ -98,7 +98,7 @@
snet_id INTEGER DEFAULT 0 NOT NULL,
description VARCHAR(48) DEFAULT CHR(0) NOT NULL,
status INTEGER DEFAULT 0 NOT NULL,
- contact VARCHAR(32) DEFAULT CHR(0) NOT NULL,
+ contact VARCHAR(255) DEFAULT CHR(0) NOT NULL,
account_number VARCHAR(10) DEFAULT CHR(0) NOT NULL,
saddr INTEGER DEFAULT 0 NOT NULL,
mask INTEGER DEFAULT 0 NOT NULL,
