liquid_feedback_core

changeset 340:29163d72fe9a

Code formatting of constraint "valid_state" in table "issue"
author jbe
date Thu Feb 21 12:38:17 2013 +0100 (2013-02-21)
parents aecc4f182602
children 607e8f5d66eb
files core.sql
line diff
     1.1 --- a/core.sql	Thu Feb 21 01:27:47 2013 +0100
     1.2 +++ b/core.sql	Thu Feb 21 12:38:17 2013 +0100
     1.3 @@ -520,22 +520,24 @@
     1.4          "status_quo_schulze_rank" INT4,
     1.5          CONSTRAINT "admission_time_not_null_unless_instantly_accepted" CHECK (
     1.6            "admission_time" NOTNULL OR ("accepted" NOTNULL AND "accepted" = "created") ),
     1.7 -        CONSTRAINT "valid_state" CHECK ((
     1.8 -          ("accepted" ISNULL  AND "half_frozen" ISNULL  AND "fully_frozen" ISNULL ) OR
     1.9 -          ("accepted" NOTNULL AND "half_frozen" ISNULL  AND "fully_frozen" ISNULL ) OR
    1.10 -          ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" ISNULL ) OR
    1.11 -          ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" NOTNULL)) AND (
    1.12 -          ("state" = 'admission'    AND "closed" ISNULL AND "accepted" ISNULL) OR
    1.13 -          ("state" = 'discussion'   AND "closed" ISNULL AND "accepted" NOTNULL AND "half_frozen" ISNULL) OR
    1.14 -          ("state" = 'verification' AND "closed" ISNULL AND "half_frozen" NOTNULL AND "fully_frozen" ISNULL) OR
    1.15 -          ("state" = 'voting'       AND "closed" ISNULL AND "fully_frozen" NOTNULL) OR
    1.16 -          ("state" = 'canceled_revoked_before_accepted'              AND "closed" NOTNULL AND "accepted" ISNULL) OR
    1.17 -          ("state" = 'canceled_issue_not_accepted'                   AND "closed" NOTNULL AND "accepted" ISNULL) OR
    1.18 -          ("state" = 'canceled_after_revocation_during_discussion'   AND "closed" NOTNULL AND "half_frozen"  ISNULL) OR
    1.19 -          ("state" = 'canceled_after_revocation_during_verification' AND "closed" NOTNULL AND "fully_frozen" ISNULL) OR
    1.20 -          ("state" = 'canceled_no_initiative_admitted' AND "closed" NOTNULL AND "fully_frozen" NOTNULL AND "closed" = "fully_frozen") OR
    1.21 -          ("state" = 'finished_without_winner'         AND "closed" NOTNULL AND "fully_frozen" NOTNULL AND "closed" != "fully_frozen") OR
    1.22 -          ("state" = 'finished_with_winner'            AND "closed" NOTNULL AND "fully_frozen" NOTNULL AND "closed" != "fully_frozen")
    1.23 +        CONSTRAINT "valid_state" CHECK (
    1.24 +          (
    1.25 +            ("accepted" ISNULL  AND "half_frozen" ISNULL  AND "fully_frozen" ISNULL ) OR
    1.26 +            ("accepted" NOTNULL AND "half_frozen" ISNULL  AND "fully_frozen" ISNULL ) OR
    1.27 +            ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" ISNULL ) OR
    1.28 +            ("accepted" NOTNULL AND "half_frozen" NOTNULL AND "fully_frozen" NOTNULL)
    1.29 +          ) AND (
    1.30 +            ("state" = 'admission'    AND "closed" ISNULL AND "accepted" ISNULL) OR
    1.31 +            ("state" = 'discussion'   AND "closed" ISNULL AND "accepted" NOTNULL AND "half_frozen" ISNULL) OR
    1.32 +            ("state" = 'verification' AND "closed" ISNULL AND "half_frozen" NOTNULL AND "fully_frozen" ISNULL) OR
    1.33 +            ("state" = 'voting'       AND "closed" ISNULL AND "fully_frozen" NOTNULL) OR
    1.34 +            ("state" = 'canceled_revoked_before_accepted'              AND "closed" NOTNULL AND "accepted" ISNULL) OR
    1.35 +            ("state" = 'canceled_issue_not_accepted'                   AND "closed" NOTNULL AND "accepted" ISNULL) OR
    1.36 +            ("state" = 'canceled_after_revocation_during_discussion'   AND "closed" NOTNULL AND "half_frozen"  ISNULL) OR
    1.37 +            ("state" = 'canceled_after_revocation_during_verification' AND "closed" NOTNULL AND "fully_frozen" ISNULL) OR
    1.38 +            ("state" = 'canceled_no_initiative_admitted' AND "closed" NOTNULL AND "fully_frozen" NOTNULL AND "closed" = "fully_frozen") OR
    1.39 +            ("state" = 'finished_without_winner'         AND "closed" NOTNULL AND "fully_frozen" NOTNULL AND "closed" != "fully_frozen") OR
    1.40 +            ("state" = 'finished_with_winner'            AND "closed" NOTNULL AND "fully_frozen" NOTNULL AND "closed" != "fully_frozen")
    1.41            )),
    1.42          CONSTRAINT "phase_finished_only_when_not_closed" CHECK (
    1.43            "phase_finished" ISNULL OR "closed" ISNULL ),

Impressum / About Us