liquid_feedback_core

changeset 495:bb420abbc2fa

Removed NOT NULL constraint for column "last_suggestion_id" in table "initiative_notification_sent" (NULL means that no suggestion existed)
author jbe
date Sun Apr 03 20:04:31 2016 +0200 (2016-04-03)
parents b4b660562322
children 044af1eec28b
files core.sql update/core-update.v3.1.0-v3.2.0.sql
line diff
     1.1 --- a/core.sql	Sun Apr 03 20:00:20 2016 +0200
     1.2 +++ b/core.sql	Sun Apr 03 20:04:31 2016 +0200
     1.3 @@ -1275,7 +1275,7 @@
     1.4          "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     1.5          "initiative_id"         INT4            REFERENCES "initiative" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     1.6          "last_draft_id"         INT8            NOT NULL,
     1.7 -        "last_suggestion_id"    INT8            NOT NULL );
     1.8 +        "last_suggestion_id"    INT8 );
     1.9  CREATE INDEX "initiative_notification_sent_initiative_idx" ON "initiative_notification_sent" ("initiative_id");
    1.10  
    1.11  
     2.1 --- a/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:00:20 2016 +0200
     2.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:04:31 2016 +0200
     2.3 @@ -33,7 +33,7 @@
     2.4          "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     2.5          "initiative_id"         INT4            REFERENCES "initiative" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
     2.6          "last_draft_id"         INT8            NOT NULL,
     2.7 -        "last_suggestion_id"    INT8            NOT NULL );
     2.8 +        "last_suggestion_id"    INT8 );
     2.9  CREATE INDEX "initiative_notification_sent_initiative_idx" ON "initiative_notification_sent" ("initiative_id");
    2.10  
    2.11  CREATE VIEW "updated_initiative" AS

Impressum / About Us