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)