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

Impressum / About Us