liquid_feedback_core
annotate update/core-update.v3.0.4-v3.0.5.sql @ 532:5855ff9e5c8f
Several changes/additions for upcoming major release
- OAuth 2.0 support
- storing profiles as JSON document
- removed subject area membership
- revised snapshot system
- additional issue limiter (dynamic quorum in subject area)
- extended event logging in "event" table
- OAuth 2.0 support
- storing profiles as JSON document
- removed subject area membership
- revised snapshot system
- additional issue limiter (dynamic quorum in subject area)
- extended event logging in "event" table
| author | jbe |
|---|---|
| date | Thu Mar 30 19:42:38 2017 +0200 (2017-03-30) |
| parents | d14513809147 |
| 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; |