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 ),