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