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" (