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