# HG changeset patch # User jbe # Date 1288484058 -7200 # Node ID 20be30c73831235fac65b59c3aafe49d63f4325d # Parent 425bb591bff828835c7616a4b7742b81bac9f4cc Adjusted file update/core-update.v1.2.9-v1.3.0.sql to match changes in core.sql diff -r 425bb591bff8 -r 20be30c73831 update/core-update.v1.2.9-v1.3.0.sql --- a/update/core-update.v1.2.9-v1.3.0.sql Sun Oct 31 01:52:50 2010 +0200 +++ b/update/core-update.v1.2.9-v1.3.0.sql Sun Oct 31 02:14:18 2010 +0200 @@ -4,11 +4,6 @@ SELECT * FROM (VALUES ('1.3.0', 1, 3, 0)) AS "subquery"("string", "major", "minor", "revision"); -ALTER TABLE "supporter" ADD COLUMN - "auto_support" BOOLEAN NOT NULL DEFAULT FALSE; - -COMMENT ON COLUMN "supporter"."auto_support" IS 'Supporting member does not want to confirm new drafts of the initiative'; - -- update comment for column "fully_frozen" of table "issue" @@ -40,10 +35,10 @@ COMMENT ON TABLE "ignored_issue" IS 'Table to store member specific options to ignore issues in selected states'; -COMMENT ON COLUMN "ignored_issue"."new" IS 'Selects issues which are neither closed nor accepted'; -COMMENT ON COLUMN "ignored_issue"."accepted" IS 'Selects issues which are accepted but not (half_)frozen or closed'; -COMMENT ON COLUMN "ignored_issue"."half_frozen" IS 'Selects issues which are half_frozen but not fully_frozen or closed'; -COMMENT ON COLUMN "ignored_issue"."fully_frozen" IS 'Selects issues which are fully_frozen (in voting) and not closed'; +COMMENT ON COLUMN "ignored_issue"."new" IS 'Apply when issue is neither closed nor accepted'; +COMMENT ON COLUMN "ignored_issue"."accepted" IS 'Apply when issue is accepted but not (half_)frozen or closed'; +COMMENT ON COLUMN "ignored_issue"."half_frozen" IS 'Apply when issue is half_frozen but not fully_frozen or closed'; +COMMENT ON COLUMN "ignored_issue"."fully_frozen" IS 'Apply when issue is fully_frozen (in voting) and not closed'; -- allow area and issue delegations with trustee_id set to NULL @@ -70,7 +65,7 @@ COMMENT ON VIEW "issue_delegation" IS 'Resulting issue delegations from active members; can include rows with trustee_id set to NULL'; --- +-- support for explicitly disabled delegations in "delegation_chain" functions DROP FUNCTION "delegation_chain" ( "member"."id"%TYPE,