liquid_feedback_core
changeset 450:4434b4d69def
Removed "initiative"."discussion_url"
author | jbe |
---|---|
date | Tue Dec 01 17:12:52 2015 +0100 (2015-12-01) |
parents | 6cef981cdcdf |
children | b9eafa16c91d |
files | core.sql |
line diff
1.1 --- a/core.sql Tue Dec 01 17:03:13 2015 +0100 1.2 +++ b/core.sql Tue Dec 01 17:12:52 2015 +0100 1.3 @@ -7,7 +7,7 @@ 1.4 BEGIN; 1.5 1.6 CREATE VIEW "liquid_feedback_version" AS 1.7 - SELECT * FROM (VALUES ('3.0.5', 3, 0, 5)) 1.8 + SELECT * FROM (VALUES ('3.1.0', 3, 1, 0)) 1.9 AS "subquery"("string", "major", "minor", "revision"); 1.10 1.11 1.12 @@ -664,7 +664,6 @@ 1.13 "id" SERIAL4 PRIMARY KEY, 1.14 "name" TEXT NOT NULL, 1.15 "polling" BOOLEAN NOT NULL DEFAULT FALSE, 1.16 - "discussion_url" TEXT, 1.17 "created" TIMESTAMPTZ NOT NULL DEFAULT now(), 1.18 "revoked" TIMESTAMPTZ, 1.19 "revoked_by_member_id" INT4 REFERENCES "member" ("id") ON DELETE RESTRICT ON UPDATE CASCADE, 1.20 @@ -720,13 +719,11 @@ 1.21 CREATE TRIGGER "update_text_search_data" 1.22 BEFORE INSERT OR UPDATE ON "initiative" 1.23 FOR EACH ROW EXECUTE PROCEDURE 1.24 - tsvector_update_trigger('text_search_data', 'pg_catalog.simple', 1.25 - "name", "discussion_url"); 1.26 + tsvector_update_trigger('text_search_data', 'pg_catalog.simple', "name"); 1.27 1.28 COMMENT ON TABLE "initiative" IS 'Group of members publishing drafts for resolutions to be passed; Frontends must ensure that initiatives of half_frozen issues are not revoked, and that initiatives of fully_frozen or closed issues are neither revoked nor created.'; 1.29 1.30 COMMENT ON COLUMN "initiative"."polling" IS 'Initiative does not need to pass the initiative quorum (see "policy"."polling")'; 1.31 -COMMENT ON COLUMN "initiative"."discussion_url" IS 'URL pointing to a discussion platform for this initiative'; 1.32 COMMENT ON COLUMN "initiative"."revoked" IS 'Point in time, when one initiator decided to revoke the initiative'; 1.33 COMMENT ON COLUMN "initiative"."revoked_by_member_id" IS 'Member, who decided to revoke the initiative'; 1.34 COMMENT ON COLUMN "initiative"."external_reference" IS 'Opaque data field to store an external reference';