# HG changeset patch
# User jbe
# Date 1459706671 -7200
# Node ID bb420abbc2faa96a2b3ba540f2eafbb611475616
# Parent  b4b660562322fb974df7aeea278d06bba1f73473
Removed NOT NULL constraint for column "last_suggestion_id" in table "initiative_notification_sent" (NULL means that no suggestion existed)

diff -r b4b660562322 -r bb420abbc2fa core.sql
--- a/core.sql	Sun Apr 03 20:00:20 2016 +0200
+++ b/core.sql	Sun Apr 03 20:04:31 2016 +0200
@@ -1275,7 +1275,7 @@
         "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
         "initiative_id"         INT4            REFERENCES "initiative" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
         "last_draft_id"         INT8            NOT NULL,
-        "last_suggestion_id"    INT8            NOT NULL );
+        "last_suggestion_id"    INT8 );
 CREATE INDEX "initiative_notification_sent_initiative_idx" ON "initiative_notification_sent" ("initiative_id");
 
 
diff -r b4b660562322 -r bb420abbc2fa update/core-update.v3.1.0-v3.2.0.sql
--- a/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:00:20 2016 +0200
+++ b/update/core-update.v3.1.0-v3.2.0.sql	Sun Apr 03 20:04:31 2016 +0200
@@ -33,7 +33,7 @@
         "member_id"             INT4            REFERENCES "member" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
         "initiative_id"         INT4            REFERENCES "initiative" ("id") ON DELETE CASCADE ON UPDATE CASCADE,
         "last_draft_id"         INT8            NOT NULL,
-        "last_suggestion_id"    INT8            NOT NULL );
+        "last_suggestion_id"    INT8 );
 CREATE INDEX "initiative_notification_sent_initiative_idx" ON "initiative_notification_sent" ("initiative_id");
 
 CREATE VIEW "updated_initiative" AS