jbe@444: BEGIN;
jbe@444: 
jbe@444: CREATE OR REPLACE VIEW "liquid_feedback_version" AS
jbe@444:   SELECT * FROM (VALUES ('3.0.5', 3, 0, 5))
jbe@444:   AS "subquery"("string", "major", "minor", "revision");
jbe@444: 
jbe@444: ALTER TABLE "unit" ADD COLUMN "external_reference" TEXT;
jbe@444: COMMENT ON COLUMN "unit"."external_reference" IS 'Opaque data field to store an external reference';
jbe@444: 
jbe@444: ALTER TABLE "area" ADD COLUMN "external_reference" TEXT;
jbe@444: COMMENT ON COLUMN "area"."external_reference" IS 'Opaque data field to store an external reference';
jbe@444: 
jbe@444: ALTER TABLE "issue" ADD COLUMN "external_reference" TEXT;
jbe@444: COMMENT ON COLUMN "issue"."external_reference" IS 'Opaque data field to store an external reference';
jbe@444: 
jbe@444: ALTER TABLE "initiative" ADD COLUMN "external_reference" TEXT;
jbe@444: COMMENT ON COLUMN "initiative"."external_reference" IS 'Opaque data field to store an external reference';
jbe@444: 
jbe@444: ALTER TABLE "draft" ADD COLUMN "external_reference" TEXT;
jbe@444: COMMENT ON COLUMN "draft"."external_reference" IS 'Opaque data field to store an external reference';
jbe@444: 
jbe@444: ALTER TABLE "suggestion" ADD COLUMN "external_reference" TEXT;
jbe@444: COMMENT ON COLUMN "suggestion"."external_reference" IS 'Opaque data field to store an external reference';
jbe@444: 
jbe@444: COMMIT;