liquid_feedback_core

changeset 55:b63515611a60 v1.1.0

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 7f772c17ec05
files core.sql update/core-update.v1.0.3-v1.1.0.sql
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  
     2.1 --- a/update/core-update.v1.0.3-v1.1.0.sql	Mon Jun 28 15:08:06 2010 +0200
     2.2 +++ b/update/core-update.v1.0.3-v1.1.0.sql	Thu Jul 08 12:45:34 2010 +0200
     2.3 @@ -4,6 +4,9 @@
     2.4    SELECT * FROM (VALUES ('1.1.0', 1, 1, 0))
     2.5    AS "subquery"("string", "major", "minor", "revision");
     2.6  
     2.7 +ALTER TABLE "member" ADD COLUMN "notify_email_lock_expiry" TIMESTAMPTZ;
     2.8 +COMMENT ON COLUMN "member"."notify_email_lock_expiry" IS 'Date/time until no further email confirmation mails may be sent (abuse protection)';
     2.9 +
    2.10  ALTER TABLE "direct_population_snapshot" DROP COLUMN "interest_exists";
    2.11  
    2.12  CREATE OR REPLACE FUNCTION "create_population_snapshot"
    2.13 @@ -60,6 +63,14 @@
    2.14      END;
    2.15    $$;
    2.16  
    2.17 +COMMENT ON FUNCTION "freeze_after_snapshot"
    2.18 +  ( "issue"."id"%TYPE )
    2.19 +  IS 'This function freezes an issue (fully) and starts voting, but must only be called when "create_snapshot" was called in the same transaction.';
    2.20 +
    2.21 +COMMENT ON FUNCTION "manual_freeze"
    2.22 +  ( "issue"."id"%TYPE )
    2.23 +  IS 'Freeze an issue manually (fully) and start voting';
    2.24 +
    2.25  DROP FUNCTION "delete_member_data"("member"."id"%TYPE);
    2.26  
    2.27  CREATE FUNCTION "delete_member"("member_id_p" "member"."id"%TYPE)

Impressum / About Us