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,

Impressum / About Us