liquid_feedback_core
changeset 451:b9eafa16c91d
Shortened constraint names to be less than 64 characters long
author | jbe |
---|---|
date | Thu Dec 03 19:32:59 2015 +0100 (2015-12-03) |
parents | 4434b4d69def |
children | 8182c297783f |
files | core.sql |
line diff
1.1 --- a/core.sql Tue Dec 01 17:12:52 2015 +0100 1.2 +++ b/core.sql Thu Dec 03 19:32:59 2015 +0100 1.3 @@ -1201,7 +1201,7 @@ 1.4 FOREIGN KEY ("initiative_id", "suggestion_id") 1.5 REFERENCES "suggestion" ("initiative_id", "id") 1.6 ON DELETE CASCADE ON UPDATE CASCADE, 1.7 - CONSTRAINT "null_constraints_for_issue_state_changed" CHECK ( 1.8 + CONSTRAINT "null_constr_for_issue_state_changed" CHECK ( 1.9 "event" != 'issue_state_changed' OR ( 1.10 "member_id" ISNULL AND 1.11 "issue_id" NOTNULL AND 1.12 @@ -1209,7 +1209,7 @@ 1.13 "initiative_id" ISNULL AND 1.14 "draft_id" ISNULL AND 1.15 "suggestion_id" ISNULL )), 1.16 - CONSTRAINT "null_constraints_for_initiative_creation_or_revocation_or_new_draft" CHECK ( 1.17 + CONSTRAINT "null_constr_for_initiative_creation_or_revocation_or_new_draft" CHECK ( 1.18 "event" NOT IN ( 1.19 'initiative_created_in_new_issue', 1.20 'initiative_created_in_existing_issue', 1.21 @@ -1222,7 +1222,7 @@ 1.22 "initiative_id" NOTNULL AND 1.23 "draft_id" NOTNULL AND 1.24 "suggestion_id" ISNULL )), 1.25 - CONSTRAINT "null_constraints_for_suggestion_creation" CHECK ( 1.26 + CONSTRAINT "null_constr_for_suggestion_creation" CHECK ( 1.27 "event" != 'suggestion_created' OR ( 1.28 "member_id" NOTNULL AND 1.29 "issue_id" NOTNULL AND