liquid_feedback_core
changeset 232:cf8a090503c0
Added column "invite_code_expiry" to table "member"
author | jbe |
---|---|
date | Sat Mar 10 18:20:31 2012 +0100 (2012-03-10) |
parents | 61e20e161e9b |
children | f022016f6748 |
files | core.sql |
line diff
1.1 --- a/core.sql Sat Mar 10 18:04:03 2012 +0100 1.2 +++ b/core.sql Sat Mar 10 18:20:31 2012 +0100 1.3 @@ -85,6 +85,7 @@ 1.4 "id" SERIAL4 PRIMARY KEY, 1.5 "created" TIMESTAMPTZ NOT NULL DEFAULT now(), 1.6 "invite_code" TEXT UNIQUE, 1.7 + "invite_code_expiry" TIMESTAMPTZ, 1.8 "admin_comment" TEXT, 1.9 "activated" TIMESTAMPTZ, 1.10 "last_activity" DATE, 1.11 @@ -139,6 +140,7 @@ 1.12 1.13 COMMENT ON COLUMN "member"."created" IS 'Creation of member record and/or invite code'; 1.14 COMMENT ON COLUMN "member"."invite_code" IS 'Optional invite code, to allow a member to initialize his/her account the first time'; 1.15 +COMMENT ON COLUMN "member"."invite_code_expiry" IS 'Expiry data/time for "invite_code"'; 1.16 COMMENT ON COLUMN "member"."admin_comment" IS 'Hidden comment for administrative purposes'; 1.17 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'; 1.18 COMMENT ON COLUMN "member"."last_activity" IS 'Date of last activity of member; required to be set for "active" members'; 1.19 @@ -4169,6 +4171,7 @@ 1.20 DELETE FROM "member" WHERE "activated" ISNULL; 1.21 UPDATE "member" SET 1.22 "invite_code" = NULL, 1.23 + "invite_code_expiry" = NULL, 1.24 "admin_comment" = NULL, 1.25 "last_login" = NULL, 1.26 "login" = NULL,