From: danw <danw>
Date: Tue, 16 Nov 1999 04:23:49 +0000 (+0000)
Subject: add a field "reservations" to the users table, which can contain a
X-Git-Url: http://andersk.mit.edu/gitweb/moira.git/commitdiff_plain/0aa10fc18ba452630a8376f7206625f79a4d7958

add a field "reservations" to the users table, which can contain a
series of one-letter codes indicating why an account can't be purged
---

diff --git a/db/schema.sql b/db/schema.sql
index d733a633..c799ceee 100644
--- a/db/schema.sql
+++ b/db/schema.sql
@@ -42,6 +42,7 @@ create table users
 	sigwho       	INTEGER		DEFAULT 0	NOT NULL,
 	signature    	VARCHAR(68)	DEFAULT CHR(0)	NOT NULL,
 	secure       	INTEGER		DEFAULT 0	NOT NULL,       
+	reservations	VARCHAR(10)	DEFAULT CHR(0)	NOT NULL,
 	flag         	INTEGER		DEFAULT 0	NOT NULL
 );