[1926] in Moira Commits
/svn/moira r4065 - trunk/moira/db
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Tue Jan 17 11:52:37 2012
Date: Tue, 17 Jan 2012 11:52:34 -0500
From: Garry Zacheiss <zacheiss@MIT.EDU>
Message-Id: <201201171652.q0HGqYsg003119@drugstore.mit.edu>
To: moira-commits@MIT.EDU
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: zacheiss
Date: 2012-01-17 11:52:34 -0500 (Tue, 17 Jan 2012)
New Revision: 4065
Modified:
trunk/moira/db/schema.sql
Log:
Alter size of pin column.
Modified: trunk/moira/db/schema.sql
===================================================================
--- trunk/moira/db/schema.sql 2012-01-05 16:57:39 UTC (rev 4064)
+++ trunk/moira/db/schema.sql 2012-01-17 16:52:34 UTC (rev 4065)
@@ -45,7 +45,7 @@
sigwho INTEGER DEFAULT 0 NOT NULL,
signature VARCHAR(68) DEFAULT CHR(0) NOT NULL,
secure INTEGER DEFAULT 0 NOT NULL,
- pin VARCHAR(10) DEFAULT CHR(0) NOT NULL,
+ pin VARCHAR(20) DEFAULT CHR(0) NOT NULL,
reservations VARCHAR(10) DEFAULT CHR(0) NOT NULL,
flag INTEGER DEFAULT 0 NOT NULL,
created DATE DEFAULT SYSDATE NOT NULL,
@@ -81,7 +81,7 @@
statuschange DATE DEFAULT SYSDATE NOT NULL,
snet_id INTEGER DEFAULT 0 NOT NULL,
address VARCHAR(16) DEFAULT CHR(0) NOT NULL,
- hwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
+ unusedhwaddr VARCHAR(12) DEFAULT CHR(0) NOT NULL,
owner_type VARCHAR(8) DEFAULT CHR(0) NOT NULL,
owner_id INTEGER DEFAULT 0 NOT NULL,
acomment INTEGER DEFAULT 0 NOT NULL,
