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

Impressum / About Us