liquid_feedback_core

diff core.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 6b2c80028b47
children e3c9f737a096
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"';

Impressum / About Us