liquid_feedback_core

changeset 93:20be30c73831

Adjusted file update/core-update.v1.2.9-v1.3.0.sql to match changes in core.sql
author jbe
date Sun Oct 31 02:14:18 2010 +0200 (2010-10-31)
parents 425bb591bff8
children fb9688f31740
files update/core-update.v1.2.9-v1.3.0.sql
line diff
     1.1 --- a/update/core-update.v1.2.9-v1.3.0.sql	Sun Oct 31 01:52:50 2010 +0200
     1.2 +++ b/update/core-update.v1.2.9-v1.3.0.sql	Sun Oct 31 02:14:18 2010 +0200
     1.3 @@ -4,11 +4,6 @@
     1.4    SELECT * FROM (VALUES ('1.3.0', 1, 3, 0))
     1.5    AS "subquery"("string", "major", "minor", "revision");
     1.6  
     1.7 -ALTER TABLE "supporter" ADD COLUMN
     1.8 -  "auto_support" BOOLEAN NOT NULL DEFAULT FALSE;
     1.9 -
    1.10 -COMMENT ON COLUMN "supporter"."auto_support" IS 'Supporting member does not want to confirm new drafts of the initiative';
    1.11 -
    1.12  
    1.13  -- update comment for column "fully_frozen" of table "issue"
    1.14  
    1.15 @@ -40,10 +35,10 @@
    1.16  
    1.17  COMMENT ON TABLE "ignored_issue" IS 'Table to store member specific options to ignore issues in selected states';
    1.18  
    1.19 -COMMENT ON COLUMN "ignored_issue"."new"          IS 'Selects issues which are neither closed nor accepted';
    1.20 -COMMENT ON COLUMN "ignored_issue"."accepted"     IS 'Selects issues which are accepted but not (half_)frozen or closed';
    1.21 -COMMENT ON COLUMN "ignored_issue"."half_frozen"  IS 'Selects issues which are half_frozen but not fully_frozen or closed';
    1.22 -COMMENT ON COLUMN "ignored_issue"."fully_frozen" IS 'Selects issues which are fully_frozen (in voting) and not closed';
    1.23 +COMMENT ON COLUMN "ignored_issue"."new"          IS 'Apply when issue is neither closed nor accepted';
    1.24 +COMMENT ON COLUMN "ignored_issue"."accepted"     IS 'Apply when issue is accepted but not (half_)frozen or closed';
    1.25 +COMMENT ON COLUMN "ignored_issue"."half_frozen"  IS 'Apply when issue is half_frozen but not fully_frozen or closed';
    1.26 +COMMENT ON COLUMN "ignored_issue"."fully_frozen" IS 'Apply when issue is fully_frozen (in voting) and not closed';
    1.27  
    1.28  
    1.29  -- allow area and issue delegations with trustee_id set to NULL
    1.30 @@ -70,7 +65,7 @@
    1.31  COMMENT ON VIEW "issue_delegation" IS 'Resulting issue delegations from active members; can include rows with trustee_id set to NULL';
    1.32  
    1.33  
    1.34 ---
    1.35 +-- support for explicitly disabled delegations in "delegation_chain" functions
    1.36  
    1.37  DROP FUNCTION "delegation_chain"
    1.38    ( "member"."id"%TYPE,

Impressum / About Us