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 d733a6331de29fff14f7f1dfba3ea9376896ec9e..c799ceeef8f620ad08bb0fedf523be2b2fb45547 100644 (file)
--- 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
 );