1.1 --- a/update/core-update.v1.0.3-v1.1.0.sql	Mon Jun 28 15:08:06 2010 +0200
     1.2 +++ b/update/core-update.v1.0.3-v1.1.0.sql	Thu Jul 08 12:45:34 2010 +0200
     1.3 @@ -4,6 +4,9 @@
     1.4    SELECT * FROM (VALUES ('1.1.0', 1, 1, 0))
     1.5    AS "subquery"("string", "major", "minor", "revision");
     1.6  
     1.7 +ALTER TABLE "member" ADD COLUMN "notify_email_lock_expiry" TIMESTAMPTZ;
     1.8 +COMMENT ON COLUMN "member"."notify_email_lock_expiry" IS 'Date/time until no further email confirmation mails may be sent (abuse protection)';
     1.9 +
    1.10  ALTER TABLE "direct_population_snapshot" DROP COLUMN "interest_exists";
    1.11  
    1.12  CREATE OR REPLACE FUNCTION "create_population_snapshot"
    1.13 @@ -60,6 +63,14 @@
    1.14      END;
    1.15    $$;
    1.16  
    1.17 +COMMENT ON FUNCTION "freeze_after_snapshot"
    1.18 +  ( "issue"."id"%TYPE )
    1.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.';
    1.20 +
    1.21 +COMMENT ON FUNCTION "manual_freeze"
    1.22 +  ( "issue"."id"%TYPE )
    1.23 +  IS 'Freeze an issue manually (fully) and start voting';
    1.24 +
    1.25  DROP FUNCTION "delete_member_data"("member"."id"%TYPE);
    1.26  
    1.27  CREATE FUNCTION "delete_member"("member_id_p" "member"."id"%TYPE)