liquid_feedback_core
changeset 263:30465830ad9c
For "polling" policies "admission_time" is always NULL
author | jbe |
---|---|
date | Sun Jul 15 22:03:30 2012 +0200 (2012-07-15) |
parents | e02b8c492e26 |
children | c8cd87b87708 |
files | core.sql update/core-update.v2.0.11-v2.1.0.sql |
line diff
1.1 --- a/core.sql Sun Jul 15 21:57:13 2012 +0200 1.2 +++ b/core.sql Sun Jul 15 22:03:30 2012 +0200 1.3 @@ -354,7 +354,7 @@ 1.4 "admission_time" NOTNULL AND "discussion_time" NOTNULL AND 1.5 "verification_time" NOTNULL AND "voting_time" NOTNULL ) OR 1.6 ( "polling" = TRUE AND 1.7 - "admission_time" NOTNULL AND "discussion_time" NOTNULL AND 1.8 + "admission_time" ISNULL AND "discussion_time" NOTNULL AND 1.9 "verification_time" NOTNULL AND "voting_time" NOTNULL ) OR 1.10 ( "polling" = TRUE AND 1.11 "admission_time" ISNULL AND "discussion_time" ISNULL AND 1.12 @@ -365,7 +365,7 @@ 1.13 1.14 COMMENT ON COLUMN "policy"."index" IS 'Determines the order in listings'; 1.15 COMMENT ON COLUMN "policy"."active" IS 'TRUE = policy can be used for new issues'; 1.16 -COMMENT ON COLUMN "policy"."polling" IS 'TRUE = special policy for non-user-generated issues, i.e. polls (time values may be set to NULL, allowing individual timing for issues)'; 1.17 +COMMENT ON COLUMN "policy"."polling" IS 'TRUE = special policy for non-user-generated issues, i.e. polls ("admission_time" MUST be set to NULL, the other timings may be set to NULL altogether, allowing individual timing for issues)'; 1.18 COMMENT ON COLUMN "policy"."admission_time" IS 'Maximum duration of issue state ''admission''; Maximum time an issue stays open without being "accepted"'; 1.19 COMMENT ON COLUMN "policy"."discussion_time" IS 'Duration of issue state ''discussion''; Regular time until an issue is "half_frozen" after being "accepted"'; 1.20 COMMENT ON COLUMN "policy"."verification_time" IS 'Duration of issue state ''verification''; Regular time until an issue is "fully_frozen" (e.g. entering issue state ''voting'') after being "half_frozen"';
2.1 --- a/update/core-update.v2.0.11-v2.1.0.sql Sun Jul 15 21:57:13 2012 +0200 2.2 +++ b/update/core-update.v2.0.11-v2.1.0.sql Sun Jul 15 22:03:30 2012 +0200 2.3 @@ -14,12 +14,12 @@ 2.4 "admission_time" NOTNULL AND "discussion_time" NOTNULL AND 2.5 "verification_time" NOTNULL AND "voting_time" NOTNULL ) OR 2.6 ( "polling" = TRUE AND 2.7 - "admission_time" NOTNULL AND "discussion_time" NOTNULL AND 2.8 + "admission_time" ISNULL AND "discussion_time" NOTNULL AND 2.9 "verification_time" NOTNULL AND "voting_time" NOTNULL ) OR 2.10 ( "polling" = TRUE AND 2.11 "admission_time" ISNULL AND "discussion_time" ISNULL AND 2.12 "verification_time" ISNULL AND "voting_time" ISNULL ) ); 2.13 -COMMENT ON COLUMN "policy"."polling" IS 'TRUE = special policy for non-user-generated issues, i.e. polls (time values may be set to NULL, allowing individual timing for issues)'; 2.14 +COMMENT ON COLUMN "policy"."polling" IS 'TRUE = special policy for non-user-generated issues, i.e. polls ("admission_time" MUST be set to NULL, the other timings may be set to NULL altogether, allowing individual timing for issues)'; 2.15 2.16 ALTER TABLE "initiative" ADD COLUMN "polling" BOOLEAN NOT NULL DEFAULT FALSE; 2.17 COMMENT ON COLUMN "initiative"."polling" IS 'Initiative is an option for a poll (see "policy"."polling"), and does not need to pass the initiative quorum';