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,