# HG changeset patch
# User jbe
# Date 1278585934 -7200
# Node ID b63515611a60f3961bf7c935e8e2bad7974a4b7a
# Parent  964cab0880ce897d6c726b8388f5c3c2fff004f6
Added column "notify_email_lock_expiry"; Corrected "manual_freeze" comment

diff -r 964cab0880ce -r b63515611a60 core.sql
--- a/core.sql	Mon Jun 28 15:08:06 2010 +0200
+++ b/core.sql	Thu Jul 08 12:45:34 2010 +0200
@@ -65,6 +65,7 @@
         "notify_email_unconfirmed"     TEXT,
         "notify_email_secret"          TEXT     UNIQUE,
         "notify_email_secret_expiry"   TIMESTAMPTZ,
+        "notify_email_lock_expiry"     TIMESTAMPTZ,
         "password_reset_secret"        TEXT     UNIQUE,
         "password_reset_secret_expiry" TIMESTAMPTZ,
         "name"                  TEXT            NOT NULL UNIQUE,
@@ -103,6 +104,7 @@
 COMMENT ON COLUMN "member"."notify_email_unconfirmed"   IS 'Unconfirmed email address provided by the member to be copied into "notify_email" field after verification';
 COMMENT ON COLUMN "member"."notify_email_secret"        IS 'Secret sent to the address in "notify_email_unconformed"';
 COMMENT ON COLUMN "member"."notify_email_secret_expiry" IS 'Expiry date/time for "notify_email_secret"';
+COMMENT ON COLUMN "member"."notify_email_lock_expiry"   IS 'Date/time until no further email confirmation mails may be sent (abuse protection)';
 COMMENT ON COLUMN "member"."name"                 IS 'Distinct name of the member';
 COMMENT ON COLUMN "member"."identification"       IS 'Optional identification number or code of the member';
 COMMENT ON COLUMN "member"."organizational_unit"  IS 'Branch or division of the organization the member belongs to';
@@ -2534,7 +2536,7 @@
     END;
   $$;
 
-COMMENT ON FUNCTION "freeze_after_snapshot"
+COMMENT ON FUNCTION "manual_freeze"
   ( "issue"."id"%TYPE )
   IS 'Freeze an issue manually (fully) and start voting';
 
diff -r 964cab0880ce -r b63515611a60 update/core-update.v1.0.3-v1.1.0.sql
--- a/update/core-update.v1.0.3-v1.1.0.sql	Mon Jun 28 15:08:06 2010 +0200
+++ b/update/core-update.v1.0.3-v1.1.0.sql	Thu Jul 08 12:45:34 2010 +0200
@@ -4,6 +4,9 @@
   SELECT * FROM (VALUES ('1.1.0', 1, 1, 0))
   AS "subquery"("string", "major", "minor", "revision");
 
+ALTER TABLE "member" ADD COLUMN "notify_email_lock_expiry" TIMESTAMPTZ;
+COMMENT ON COLUMN "member"."notify_email_lock_expiry" IS 'Date/time until no further email confirmation mails may be sent (abuse protection)';
+
 ALTER TABLE "direct_population_snapshot" DROP COLUMN "interest_exists";
 
 CREATE OR REPLACE FUNCTION "create_population_snapshot"
@@ -60,6 +63,14 @@
     END;
   $$;
 
+COMMENT ON FUNCTION "freeze_after_snapshot"
+  ( "issue"."id"%TYPE )
+  IS 'This function freezes an issue (fully) and starts voting, but must only be called when "create_snapshot" was called in the same transaction.';
+
+COMMENT ON FUNCTION "manual_freeze"
+  ( "issue"."id"%TYPE )
+  IS 'Freeze an issue manually (fully) and start voting';
+
 DROP FUNCTION "delete_member_data"("member"."id"%TYPE);
 
 CREATE FUNCTION "delete_member"("member_id_p" "member"."id"%TYPE)