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 )

Impressum / About Us