liquid_feedback_core

diff update/core-update.v3.1.0-v3.2.0.sql @ 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
line diff
     1.1 --- a/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:00:20 2016 +0200
     1.2 +++ b/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:04:31 2016 +0200
     1.3 @@ -33,7 +33,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  CREATE VIEW "updated_initiative" AS

Impressum / About Us