# HG changeset patch # User jbe # Date 1345411946 -7200 # Node ID f2292b94fc589ddc5d2645f6bc4d51847b7df4f0 # Parent fb66e74d94b89b3143571e1c0b60fbd86392b9ab Updated comments for polling mode in core.sql and core-update.v2.0.11-v2.1.0.sql diff -r fb66e74d94b8 -r f2292b94fc58 core.sql --- a/core.sql Sun Aug 19 21:40:57 2012 +0200 +++ b/core.sql Sun Aug 19 23:32:26 2012 +0200 @@ -369,7 +369,7 @@ COMMENT ON COLUMN "policy"."index" IS 'Determines the order in listings'; COMMENT ON COLUMN "policy"."active" IS 'TRUE = policy can be used for new issues'; -COMMENT ON COLUMN "policy"."polling" IS 'TRUE = special policy for non-user-generated issues, i.e. polls ("admission_time" MUST be set to NULL, the other timings may be set to NULL altogether, allowing individual timing for issues)'; +COMMENT ON COLUMN "policy"."polling" IS 'TRUE = special policy for non-user-generated issues without issue quorum, where certain initiatives (those having the "polling" flag set) do not need to pass the initiative quorum; "admission_time" MUST be set to NULL, the other timings may be set to NULL altogether, allowing individual timing for those issues'; COMMENT ON COLUMN "policy"."admission_time" IS 'Maximum duration of issue state ''admission''; Maximum time an issue stays open without being "accepted"'; COMMENT ON COLUMN "policy"."discussion_time" IS 'Duration of issue state ''discussion''; Regular time until an issue is "half_frozen" after being "accepted"'; COMMENT ON COLUMN "policy"."verification_time" IS 'Duration of issue state ''verification''; Regular time until an issue is "fully_frozen" (e.g. entering issue state ''voting'') after being "half_frozen"'; @@ -650,7 +650,7 @@ 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.'; -COMMENT ON COLUMN "initiative"."polling" IS 'Initiative is an option for a poll (see "policy"."polling"), and does not need to pass the initiative quorum'; +COMMENT ON COLUMN "initiative"."polling" IS 'Initiative does not need to pass the initiative quorum (see "policy"."polling")'; COMMENT ON COLUMN "initiative"."discussion_url" IS 'URL pointing to a discussion platform for this initiative'; COMMENT ON COLUMN "initiative"."revoked" IS 'Point in time, when one initiator decided to revoke the initiative'; COMMENT ON COLUMN "initiative"."revoked_by_member_id" IS 'Member, who decided to revoke the initiative'; @@ -817,13 +817,13 @@ COMMENT ON TABLE "privilege" IS 'Members rights related to each unit'; -COMMENT ON COLUMN "privilege"."admin_manager" IS 'Grant/revoke any privileges to/from other members'; -COMMENT ON COLUMN "privilege"."unit_manager" IS 'Create and disable sub units'; -COMMENT ON COLUMN "privilege"."area_manager" IS 'Create and disable areas and set area parameters'; -COMMENT ON COLUMN "privilege"."member_manager" IS 'Adding/removing members from the unit, granting or revoking "initiative_right" and "voting_right"'; -COMMENT ON COLUMN "privilege"."initiative_right" IS 'Right to create an initiative'; -COMMENT ON COLUMN "privilege"."voting_right" IS 'Right to support initiatives, create and rate suggestions, and to vote'; -COMMENT ON COLUMN "privilege"."polling_right" IS 'Right to create polls (see "policy"."polling" and "initiative"."polling")'; +COMMENT ON COLUMN "privilege"."admin_manager" IS 'Grant/revoke any privileges to/from other members'; +COMMENT ON COLUMN "privilege"."unit_manager" IS 'Create and disable sub units'; +COMMENT ON COLUMN "privilege"."area_manager" IS 'Create and disable areas and set area parameters'; +COMMENT ON COLUMN "privilege"."member_manager" IS 'Adding/removing members from the unit, granting or revoking "initiative_right" and "voting_right"'; +COMMENT ON COLUMN "privilege"."initiative_right" IS 'Right to create an initiative'; +COMMENT ON COLUMN "privilege"."voting_right" IS 'Right to support initiatives, create and rate suggestions, and to vote'; +COMMENT ON COLUMN "privilege"."polling_right" IS 'Right to create issues with policies having the "policy"."polling" flag set, and to add initiatives having the "initiative"."polling" flag set to those issues'; CREATE TABLE "membership" ( diff -r fb66e74d94b8 -r f2292b94fc58 update/core-update.v2.0.11-v2.1.0.sql --- a/update/core-update.v2.0.11-v2.1.0.sql Sun Aug 19 21:40:57 2012 +0200 +++ b/update/core-update.v2.0.11-v2.1.0.sql Sun Aug 19 23:32:26 2012 +0200 @@ -31,10 +31,10 @@ ( "polling" = TRUE AND "admission_time" ISNULL AND "discussion_time" ISNULL AND "verification_time" ISNULL AND "voting_time" ISNULL ) ); -COMMENT ON COLUMN "policy"."polling" IS 'TRUE = special policy for non-user-generated issues, i.e. polls ("admission_time" MUST be set to NULL, the other timings may be set to NULL altogether, allowing individual timing for issues)'; +COMMENT ON COLUMN "policy"."polling" IS 'TRUE = special policy for non-user-generated issues without issue quorum, where certain initiatives (those having the "polling" flag set) do not need to pass the initiative quorum; "admission_time" MUST be set to NULL, the other timings may be set to NULL altogether, allowing individual timing for those issues'; ALTER TABLE "initiative" ADD COLUMN "polling" BOOLEAN NOT NULL DEFAULT FALSE; -COMMENT ON COLUMN "initiative"."polling" IS 'Initiative is an option for a poll (see "policy"."polling"), and does not need to pass the initiative quorum'; +COMMENT ON COLUMN "initiative"."polling" IS 'Initiative does not need to pass the initiative quorum (see "policy"."polling")'; ALTER TABLE "privilege" RENAME COLUMN "voting_right_manager" TO "member_manager"; ALTER TABLE "privilege" ADD COLUMN "initiative_right" BOOLEAN NOT NULL DEFAULT TRUE; @@ -44,7 +44,7 @@ COMMENT ON COLUMN "privilege"."member_manager" IS 'Adding/removing members from the unit, granting or revoking "initiative_right" and "voting_right"'; COMMENT ON COLUMN "privilege"."initiative_right" IS 'Right to create an initiative'; COMMENT ON COLUMN "privilege"."voting_right" IS 'Right to support initiatives, create and rate suggestions, and to vote'; -COMMENT ON COLUMN "privilege"."polling_right" IS 'Right to create polls (see "policy"."polling" and "initiative"."polling")'; +COMMENT ON COLUMN "privilege"."polling_right" IS 'Right to create issues with policies having the "policy"."polling" flag set, and to add initiatives having the "initiative"."polling" flag set to those issues'; CREATE OR REPLACE FUNCTION "freeze_after_snapshot" ( "issue_id_p" "issue"."id"%TYPE )