# HG changeset patch
# User jbe
# Date 1331400031 -3600
# Node ID cf8a090503c04003ff8aa58213697f2a3f18464c
# Parent  61e20e161e9b5c4bd6aadbea30468b59e83f5bdd
Added column "invite_code_expiry" to table "member"

diff -r 61e20e161e9b -r cf8a090503c0 core.sql
--- a/core.sql	Sat Mar 10 18:04:03 2012 +0100
+++ b/core.sql	Sat Mar 10 18:20:31 2012 +0100
@@ -85,6 +85,7 @@
         "id"                    SERIAL4         PRIMARY KEY,
         "created"               TIMESTAMPTZ     NOT NULL DEFAULT now(),
         "invite_code"           TEXT            UNIQUE,
+        "invite_code_expiry"    TIMESTAMPTZ,
         "admin_comment"         TEXT,
         "activated"             TIMESTAMPTZ,
         "last_activity"         DATE,
@@ -139,6 +140,7 @@
 
 COMMENT ON COLUMN "member"."created"              IS 'Creation of member record and/or invite code';
 COMMENT ON COLUMN "member"."invite_code"          IS 'Optional invite code, to allow a member to initialize his/her account the first time';
+COMMENT ON COLUMN "member"."invite_code_expiry"   IS 'Expiry data/time for "invite_code"';
 COMMENT ON COLUMN "member"."admin_comment"        IS 'Hidden comment for administrative purposes';
 COMMENT ON COLUMN "member"."activated"            IS 'Timestamp of first activation of account (i.e. usage of "invite_code"); required to be set for "active" members';
 COMMENT ON COLUMN "member"."last_activity"        IS 'Date of last activity of member; required to be set for "active" members';
@@ -4169,6 +4171,7 @@
       DELETE FROM "member" WHERE "activated" ISNULL;
       UPDATE "member" SET
         "invite_code"                  = NULL,
+        "invite_code_expiry"           = NULL,
         "admin_comment"                = NULL,
         "last_login"                   = NULL,
         "login"                        = NULL,