1.1 --- /dev/null	Thu Jan 01 00:00:00 1970 +0000
     1.2 +++ b/update/core-update.v3.0.4-v3.0.5.sql	Sat Jul 18 17:12:54 2015 +0200
     1.3 @@ -0,0 +1,25 @@
     1.4 +BEGIN;
     1.5 +
     1.6 +CREATE OR REPLACE VIEW "liquid_feedback_version" AS
     1.7 +  SELECT * FROM (VALUES ('3.0.5', 3, 0, 5))
     1.8 +  AS "subquery"("string", "major", "minor", "revision");
     1.9 +
    1.10 +ALTER TABLE "unit" ADD COLUMN "external_reference" TEXT;
    1.11 +COMMENT ON COLUMN "unit"."external_reference" IS 'Opaque data field to store an external reference';
    1.12 +
    1.13 +ALTER TABLE "area" ADD COLUMN "external_reference" TEXT;
    1.14 +COMMENT ON COLUMN "area"."external_reference" IS 'Opaque data field to store an external reference';
    1.15 +
    1.16 +ALTER TABLE "issue" ADD COLUMN "external_reference" TEXT;
    1.17 +COMMENT ON COLUMN "issue"."external_reference" IS 'Opaque data field to store an external reference';
    1.18 +
    1.19 +ALTER TABLE "initiative" ADD COLUMN "external_reference" TEXT;
    1.20 +COMMENT ON COLUMN "initiative"."external_reference" IS 'Opaque data field to store an external reference';
    1.21 +
    1.22 +ALTER TABLE "draft" ADD COLUMN "external_reference" TEXT;
    1.23 +COMMENT ON COLUMN "draft"."external_reference" IS 'Opaque data field to store an external reference';
    1.24 +
    1.25 +ALTER TABLE "suggestion" ADD COLUMN "external_reference" TEXT;
    1.26 +COMMENT ON COLUMN "suggestion"."external_reference" IS 'Opaque data field to store an external reference';
    1.27 +
    1.28 +COMMIT;