liquid_feedback_core

diff update/core-update.v2.0.11-v2.1.0.sql @ 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 a00b58b7a510
line diff
     1.1 --- a/update/core-update.v2.0.11-v2.1.0.sql	Sun Jul 15 21:57:13 2012 +0200
     1.2 +++ b/update/core-update.v2.0.11-v2.1.0.sql	Sun Jul 15 22:03:30 2012 +0200
     1.3 @@ -14,12 +14,12 @@
     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              "verification_time" ISNULL AND "voting_time" ISNULL ) );
    1.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)';
    1.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)';
    1.15  
    1.16  ALTER TABLE "initiative" ADD COLUMN "polling" BOOLEAN NOT NULL DEFAULT FALSE;
    1.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';

Impressum / About Us