annotate update/core-update.v3.0.4-v3.0.5.sql @ 444:d14513809147
Added support for storing external references (opaque data field) to "unit", "area", "issue", "initiative", "draft", and "suggestion" tables
| author |
jbe |
| date |
Sat Jul 18 17:12:54 2015 +0200 (2015-07-18) |
| parents |
|
| children |
|
| rev |
line source |
|
jbe@444
|
1 BEGIN;
|
|
jbe@444
|
2
|
|
jbe@444
|
3 CREATE OR REPLACE VIEW "liquid_feedback_version" AS
|
|
jbe@444
|
4 SELECT * FROM (VALUES ('3.0.5', 3, 0, 5))
|
|
jbe@444
|
5 AS "subquery"("string", "major", "minor", "revision");
|
|
jbe@444
|
6
|
|
jbe@444
|
7 ALTER TABLE "unit" ADD COLUMN "external_reference" TEXT;
|
|
jbe@444
|
8 COMMENT ON COLUMN "unit"."external_reference" IS 'Opaque data field to store an external reference';
|
|
jbe@444
|
9
|
|
jbe@444
|
10 ALTER TABLE "area" ADD COLUMN "external_reference" TEXT;
|
|
jbe@444
|
11 COMMENT ON COLUMN "area"."external_reference" IS 'Opaque data field to store an external reference';
|
|
jbe@444
|
12
|
|
jbe@444
|
13 ALTER TABLE "issue" ADD COLUMN "external_reference" TEXT;
|
|
jbe@444
|
14 COMMENT ON COLUMN "issue"."external_reference" IS 'Opaque data field to store an external reference';
|
|
jbe@444
|
15
|
|
jbe@444
|
16 ALTER TABLE "initiative" ADD COLUMN "external_reference" TEXT;
|
|
jbe@444
|
17 COMMENT ON COLUMN "initiative"."external_reference" IS 'Opaque data field to store an external reference';
|
|
jbe@444
|
18
|
|
jbe@444
|
19 ALTER TABLE "draft" ADD COLUMN "external_reference" TEXT;
|
|
jbe@444
|
20 COMMENT ON COLUMN "draft"."external_reference" IS 'Opaque data field to store an external reference';
|
|
jbe@444
|
21
|
|
jbe@444
|
22 ALTER TABLE "suggestion" ADD COLUMN "external_reference" TEXT;
|
|
jbe@444
|
23 COMMENT ON COLUMN "suggestion"."external_reference" IS 'Opaque data field to store an external reference';
|
|
jbe@444
|
24
|
|
jbe@444
|
25 COMMIT;
|