liquid_feedback_core
view update/core-update.v3.0.4-v3.0.5.sql @ 504:d07e6a046d41
New column "notification_sent" in "member" table; New view "scheduled_notification_to_send"
| author | jbe |
|---|---|
| date | Tue Apr 05 00:55:31 2016 +0200 (2016-04-05) |
| parents | d14513809147 |
| children |
line source
1 BEGIN;
3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
4 SELECT * FROM (VALUES ('3.0.5', 3, 0, 5))
5 AS "subquery"("string", "major", "minor", "revision");
7 ALTER TABLE "unit" ADD COLUMN "external_reference" TEXT;
8 COMMENT ON COLUMN "unit"."external_reference" IS 'Opaque data field to store an external reference';
10 ALTER TABLE "area" ADD COLUMN "external_reference" TEXT;
11 COMMENT ON COLUMN "area"."external_reference" IS 'Opaque data field to store an external reference';
13 ALTER TABLE "issue" ADD COLUMN "external_reference" TEXT;
14 COMMENT ON COLUMN "issue"."external_reference" IS 'Opaque data field to store an external reference';
16 ALTER TABLE "initiative" ADD COLUMN "external_reference" TEXT;
17 COMMENT ON COLUMN "initiative"."external_reference" IS 'Opaque data field to store an external reference';
19 ALTER TABLE "draft" ADD COLUMN "external_reference" TEXT;
20 COMMENT ON COLUMN "draft"."external_reference" IS 'Opaque data field to store an external reference';
22 ALTER TABLE "suggestion" ADD COLUMN "external_reference" TEXT;
23 COMMENT ON COLUMN "suggestion"."external_reference" IS 'Opaque data field to store an external reference';
25 COMMIT;