1 BEGIN;

2

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");

6

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';

9

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';

12

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';

15

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';

18

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';

21

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';

24

25 COMMIT;