[1970] in Moira Commits
/svn/moira r4109 - trunk/moira/db
daemon@ATHENA.MIT.EDU (Garry Zacheiss)
Thu May 9 11:40:43 2013
Date: Thu, 9 May 2013 11:40:36 -0400
From: Garry Zacheiss <zacheiss@MIT.EDU>
Message-Id: <201305091540.r49Feakm012053@drugstore.mit.edu>
To: moira-commits@MIT.EDU
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
Author: zacheiss
Date: 2013-05-09 11:40:36 -0400 (Thu, 09 May 2013)
New Revision: 4109
Modified:
trunk/moira/db/schema.sql
Log:
Add additional affiliation columns to users table, along with last kerberos password change date. Add TTL column to machine table.
Modified: trunk/moira/db/schema.sql
===================================================================
--- trunk/moira/db/schema.sql 2013-05-09 15:39:38 UTC (rev 4108)
+++ trunk/moira/db/schema.sql 2013-05-09 15:40:36 UTC (rev 4109)
@@ -56,7 +56,10 @@
sponsor_id INTEGER DEFAULT 0 NOT NULL,
expiration VARCHAR(24) DEFAULT CHR(0) NOT NULL,
alternate_email VARCHAR(255) DEFAULT CHR(0) NOT NULL,
- alternate_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL
+ alternate_phone VARCHAR(24) DEFAULT CHR(0) NOT NULL,
+ affiliation_basic VARCHAR(10) DEFAULT 'affiliate' NOT NULL,
+ affiliation_detailed VARCHAR(40) DEFAULT 'MIT Affiliate' NOT NULL,
+ last_krb_pwd_change DATE DEFAULT SYSDATE NOT NULL
);
create table krbmap
@@ -91,7 +94,8 @@
inuse DATE DEFAULT SYSDATE NOT NULL,
modtime DATE DEFAULT SYSDATE NOT NULL,
modby INTEGER DEFAULT 0 NOT NULL,
- modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL
+ modwith VARCHAR(8) DEFAULT CHR(0) NOT NULL,
+ ttl INTEGER DEFAULT 1800 NOT NULL
);
create table hostalias
