[1931] in Moira
schema change
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Thu Feb 21 00:08:41 2002
Message-Id: <200202210508.AAA05847@brad-majors.mit.edu>
To: moiradev@MIT.EDU
Date: Thu, 21 Feb 2002 00:08:39 -0500
From: Garry Zacheiss <zacheiss@MIT.EDU>
Lastly, the trivial schema change for the users table.
Garry
Index: schema.sql
===================================================================
RCS file: /afs/athena.mit.edu/astaff/project/moiradev/repository/moira/db/schema.sql,v
retrieving revision 1.27
diff -u -r1.27 schema.sql
--- schema.sql 2001/10/17 21:32:45 1.27
+++ schema.sql 2002/02/20 02:47:45
@@ -44,6 +44,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,
reservations VARCHAR(10) DEFAULT CHR(0) NOT NULL,
flag INTEGER DEFAULT 0 NOT NULL,
created DATE DEFAULT SYSDATE NOT NULL,
