liquid_feedback_core
changeset 289:f2292b94fc58
Updated comments for polling mode in core.sql and core-update.v2.0.11-v2.1.0.sql
author | jbe |
---|---|
date | Sun Aug 19 23:32:26 2012 +0200 (2012-08-19) |
parents | fb66e74d94b8 |
children | 2301a1f2acfa |
files | core.sql update/core-update.v2.0.11-v2.1.0.sql |
line diff
1.1 --- a/core.sql Sun Aug 19 21:40:57 2012 +0200 1.2 +++ b/core.sql Sun Aug 19 23:32:26 2012 +0200 1.3 @@ -369,7 +369,7 @@ 1.4 1.5 COMMENT ON COLUMN "policy"."index" IS 'Determines the order in listings'; 1.6 COMMENT ON COLUMN "policy"."active" IS 'TRUE = policy can be used for new issues'; 1.7 -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)'; 1.8 +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'; 1.9 COMMENT ON COLUMN "policy"."admission_time" IS 'Maximum duration of issue state ''admission''; Maximum time an issue stays open without being "accepted"'; 1.10 COMMENT ON COLUMN "policy"."discussion_time" IS 'Duration of issue state ''discussion''; Regular time until an issue is "half_frozen" after being "accepted"'; 1.11 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"'; 1.12 @@ -650,7 +650,7 @@ 1.13 1.14 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.15 1.16 -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'; 1.17 +COMMENT ON COLUMN "initiative"."polling" IS 'Initiative does not need to pass the initiative quorum (see "policy"."polling")'; 1.18 COMMENT ON COLUMN "initiative"."discussion_url" IS 'URL pointing to a discussion platform for this initiative'; 1.19 COMMENT ON COLUMN "initiative"."revoked" IS 'Point in time, when one initiator decided to revoke the initiative'; 1.20 COMMENT ON COLUMN "initiative"."revoked_by_member_id" IS 'Member, who decided to revoke the initiative'; 1.21 @@ -817,13 +817,13 @@ 1.22 1.23 COMMENT ON TABLE "privilege" IS 'Members rights related to each unit'; 1.24 1.25 -COMMENT ON COLUMN "privilege"."admin_manager" IS 'Grant/revoke any privileges to/from other members'; 1.26 -COMMENT ON COLUMN "privilege"."unit_manager" IS 'Create and disable sub units'; 1.27 -COMMENT ON COLUMN "privilege"."area_manager" IS 'Create and disable areas and set area parameters'; 1.28 -COMMENT ON COLUMN "privilege"."member_manager" IS 'Adding/removing members from the unit, granting or revoking "initiative_right" and "voting_right"'; 1.29 -COMMENT ON COLUMN "privilege"."initiative_right" IS 'Right to create an initiative'; 1.30 -COMMENT ON COLUMN "privilege"."voting_right" IS 'Right to support initiatives, create and rate suggestions, and to vote'; 1.31 -COMMENT ON COLUMN "privilege"."polling_right" IS 'Right to create polls (see "policy"."polling" and "initiative"."polling")'; 1.32 +COMMENT ON COLUMN "privilege"."admin_manager" IS 'Grant/revoke any privileges to/from other members'; 1.33 +COMMENT ON COLUMN "privilege"."unit_manager" IS 'Create and disable sub units'; 1.34 +COMMENT ON COLUMN "privilege"."area_manager" IS 'Create and disable areas and set area parameters'; 1.35 +COMMENT ON COLUMN "privilege"."member_manager" IS 'Adding/removing members from the unit, granting or revoking "initiative_right" and "voting_right"'; 1.36 +COMMENT ON COLUMN "privilege"."initiative_right" IS 'Right to create an initiative'; 1.37 +COMMENT ON COLUMN "privilege"."voting_right" IS 'Right to support initiatives, create and rate suggestions, and to vote'; 1.38 +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'; 1.39 1.40 1.41 CREATE TABLE "membership" (
2.1 --- a/update/core-update.v2.0.11-v2.1.0.sql Sun Aug 19 21:40:57 2012 +0200 2.2 +++ b/update/core-update.v2.0.11-v2.1.0.sql Sun Aug 19 23:32:26 2012 +0200 2.3 @@ -31,10 +31,10 @@ 2.4 ( "polling" = TRUE AND 2.5 "admission_time" ISNULL AND "discussion_time" ISNULL AND 2.6 "verification_time" ISNULL AND "voting_time" ISNULL ) ); 2.7 -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)'; 2.8 +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'; 2.9 2.10 ALTER TABLE "initiative" ADD COLUMN "polling" BOOLEAN NOT NULL DEFAULT FALSE; 2.11 -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'; 2.12 +COMMENT ON COLUMN "initiative"."polling" IS 'Initiative does not need to pass the initiative quorum (see "policy"."polling")'; 2.13 2.14 ALTER TABLE "privilege" RENAME COLUMN "voting_right_manager" TO "member_manager"; 2.15 ALTER TABLE "privilege" ADD COLUMN "initiative_right" BOOLEAN NOT NULL DEFAULT TRUE; 2.16 @@ -44,7 +44,7 @@ 2.17 COMMENT ON COLUMN "privilege"."member_manager" IS 'Adding/removing members from the unit, granting or revoking "initiative_right" and "voting_right"'; 2.18 COMMENT ON COLUMN "privilege"."initiative_right" IS 'Right to create an initiative'; 2.19 COMMENT ON COLUMN "privilege"."voting_right" IS 'Right to support initiatives, create and rate suggestions, and to vote'; 2.20 -COMMENT ON COLUMN "privilege"."polling_right" IS 'Right to create polls (see "policy"."polling" and "initiative"."polling")'; 2.21 +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'; 2.22 2.23 CREATE OR REPLACE FUNCTION "freeze_after_snapshot" 2.24 ( "issue_id_p" "issue"."id"%TYPE )