liquid_feedback_core

diff core.sql @ 55:b63515611a60

Added column "notify_email_lock_expiry"; Corrected "manual_freeze" comment
author jbe
date Thu Jul 08 12:45:34 2010 +0200 (2010-07-08)
parents 964cab0880ce
children a7ad50614d82
line diff
     1.1 --- a/core.sql	Mon Jun 28 15:08:06 2010 +0200
     1.2 +++ b/core.sql	Thu Jul 08 12:45:34 2010 +0200
     1.3 @@ -65,6 +65,7 @@
     1.4          "notify_email_unconfirmed"     TEXT,
     1.5          "notify_email_secret"          TEXT     UNIQUE,
     1.6          "notify_email_secret_expiry"   TIMESTAMPTZ,
     1.7 +        "notify_email_lock_expiry"     TIMESTAMPTZ,
     1.8          "password_reset_secret"        TEXT     UNIQUE,
     1.9          "password_reset_secret_expiry" TIMESTAMPTZ,
    1.10          "name"                  TEXT            NOT NULL UNIQUE,
    1.11 @@ -103,6 +104,7 @@
    1.12  COMMENT ON COLUMN "member"."notify_email_unconfirmed"   IS 'Unconfirmed email address provided by the member to be copied into "notify_email" field after verification';
    1.13  COMMENT ON COLUMN "member"."notify_email_secret"        IS 'Secret sent to the address in "notify_email_unconformed"';
    1.14  COMMENT ON COLUMN "member"."notify_email_secret_expiry" IS 'Expiry date/time for "notify_email_secret"';
    1.15 +COMMENT ON COLUMN "member"."notify_email_lock_expiry"   IS 'Date/time until no further email confirmation mails may be sent (abuse protection)';
    1.16  COMMENT ON COLUMN "member"."name"                 IS 'Distinct name of the member';
    1.17  COMMENT ON COLUMN "member"."identification"       IS 'Optional identification number or code of the member';
    1.18  COMMENT ON COLUMN "member"."organizational_unit"  IS 'Branch or division of the organization the member belongs to';
    1.19 @@ -2534,7 +2536,7 @@
    1.20      END;
    1.21    $$;
    1.22  
    1.23 -COMMENT ON FUNCTION "freeze_after_snapshot"
    1.24 +COMMENT ON FUNCTION "manual_freeze"
    1.25    ( "issue"."id"%TYPE )
    1.26    IS 'Freeze an issue manually (fully) and start voting';
    1.27  

Impressum / About Us