| age | 
  author | 
  description | 
 
 
  | 2013-03-16 | 
  jbe | 
  Code cleanup in "lf_update_suggestion_order" (own block for preparation of the ballot data) | 
 
 
  | 2013-03-16 | 
  jbe | 
  Free memory for candidate and ballot structure in "lf_update_suggestion_order" | 
 
 
  | 2013-03-16 | 
  jbe | 
  Extended "lf_update_suggestion_order" to create a candidate structure | 
 
 
  | 2013-03-16 | 
  jbe | 
  Support for proportional ordering of suggestions in core.sql; Begin of work on "lf_update_suggestion_order" (a second background job for sorting suggestions based on a proportional preferential voting system) | 
 
 
  | 2013-03-10 | 
  jbe | 
  Added tag v2.2.0 for changeset 49c25dbc27bc | 
 
 
  | 2013-03-10 | 
  jbe | 
  Added reminder to make backups before installing updatesv2.2.0  | 
 
 
  | 2013-03-09 | 
  jbe | 
  Bugfix for calculation of harmonic_weight, when there are initiatives without supporters | 
 
 
  | 2013-03-09 | 
  jbe | 
  Updated LICENSE file | 
 
 
  | 2013-02-21 | 
  jbe | 
  Execute update script from v2.1.0 to v2.2.0 in isolation level REPEATABLE READ | 
 
 
  | 2013-02-21 | 
  jbe | 
  Set harmonic_weight for all issues in update script to v2.2.0 | 
 
 
  | 2013-02-21 | 
  jbe | 
  Compatibility for PostgreSQL 8.4 in lf_update.c | 
 
 
  | 2013-02-21 | 
  jbe | 
  Added comments for functions "require_transaction_isolation"() and "dont_require_transaction_isolation"() | 
 
 
  | 2013-02-21 | 
  jbe | 
  Changed indentation in "check_issue" function code | 
 
 
  | 2013-02-21 | 
  jbe | 
  Removed unnecessary code, because multiple phase changes at once are no longer possible | 
 
 
  | 2013-02-21 | 
  jbe | 
  Write "NOW()" as "now()" | 
 
 
  | 2013-02-21 | 
  jbe | 
  Code formatting of constraint "valid_state" in table "issue" | 
 
 
  | 2013-02-21 | 
  jbe | 
  Update script to v2.2.0 | 
 
 
  | 2013-02-21 | 
  jbe | 
  Removed setting of "ranks_available" column in function "clean_issue" | 
 
 
  | 2013-02-20 | 
  jbe | 
  Removed deprecated timeline views | 
 
 
  | 2013-02-20 | 
  jbe | 
  Cleanup of new code for allowing "lf_update" to run without extensive locking | 
 
 
  | 2013-02-19 | 
  jbe | 
  Removed debug code in lf_update.c | 
 
 
  | 2013-02-19 | 
  jbe | 
  Use different transaction isolation levels in "lf_update" program | 
 
 
  | 2013-02-15 | 
  jbe | 
  Completely removed table locking in favor of transaction isolation requirements | 
 
 
  | 2013-02-15 | 
  jbe | 
  Bugfixes for new system to allow the background job (lf_update) run without intensive locking | 
 
 
  | 2013-02-14 | 
  jbe | 
  Work on new system to allow the background job (lf_update) run without intensive locking (incomplete yet) | 
 
 
  | 2013-02-11 | 
  jbe | 
  Removed locking system | 
 
 
  | 2013-02-10 | 
  jbe | 
  Added comment in "clean_issue" function | 
 
 
  | 2013-02-10 | 
  jbe | 
  Stub (no implementation yet) for "phase_finished" field, allowing calculations to take more time without database locking | 
 
 
  | 2013-02-10 | 
  jbe | 
  Correct index usage when calculating "harmonic_weight" | 
 
 
  | 2013-02-10 | 
  jbe | 
  merge | 
 
 
  | 2013-02-10 | 
  jbe | 
  Bugfix regarding index usage (speeds up lf_update) | 
 
 
  | 2013-02-10 | 
  jbe | 
  Removed update script to v2.1.1 due to upcoming major changes | 
 
 
  | 2013-02-09 | 
  jbe | 
  Removed "harmonic_weight" for suggestions, because another proportional ranking algorithm is needed there | 
 
 
  | 2013-02-08 | 
  jbe | 
  Calculate "harmonc_weight" after all other calculations in an issue (as calculation depends on the "admitted" flag now) | 
 
 
  | 2013-02-08 | 
  jbe | 
  Require "satisfied" support for "admitted" initiatives when calculating "harmonic_weight" | 
 
 
  | 2013-02-08 | 
  jbe | 
  Calculate "harmonic_weight" to be used as a secondary sorting key, while the "admitted" flag shall be used as the primary sorting key for initiatives | 
 
 
  | 2013-02-02 | 
  jbe | 
  Bugfix in view "remaining_harmonic_suggestion_weight_summands" | 
 
 
  | 2013-02-02 | 
  jbe | 
  Bugfix in view "remaining_harmonic_opinion_weight" | 
 
 
  | 2013-02-02 | 
  jbe | 
  Count non-fulfilled suggestions with positive opinion and fulfilled suggestions with negative opinion for "harmonic_weight" of suggestions | 
 
 
  | 2013-02-02 | 
  jbe | 
  Set "harmonic_weight" to zero instead of null, where there are no supporters | 
 
 
  | 2013-02-01 | 
  jbe | 
  Update script for "harmonic_weight" feature | 
 
 
  | 2013-02-01 | 
  jbe | 
  Minor fix in comment | 
 
 
  | 2013-02-01 | 
  jbe | 
  Changed rounding behaviour for "harmonic_weight" | 
 
 
  | 2013-02-01 | 
  jbe | 
  Added "harmonic_weight" for suggestions; Bugfix in function "set_harmonic_initiative_weights" (clear weights prior calculation) | 
 
 
  | 2013-02-01 | 
  jbe | 
  Removed debug notice in function "set_harmonic_initiative_weights" | 
 
 
  | 2013-02-01 | 
  jbe | 
  "harmonic_weight" for initiatives | 
 
 
  | 2012-10-15 | 
  jbe | 
  Added tag v2.1.0 for changeset 5c98265b39a0 | 
 
 
  | 2012-10-06 | 
  jbe | 
  Added missing DROP FUNCTION "vote_ratio" in update scriptsv2.1.0  | 
 
 
  | 2012-10-05 | 
  jbe | 
  Merged fix from v2.0.12: Removed unwanted (and broken) tie-breaking by approval rate | 
 
 
  | 2012-10-05 | 
  jbe | 
  Added tag v2.0.12 for changeset a839e7efde9f | 
 
 
  | 2012-10-05 | 
  jbe | 
  Removed unwanted (and broken) tie-breaking by approval ratev2.0.12  | 
 
 
  | 2012-09-30 | 
  jbe | 
  Removed broken tie-breaking implementation | 
 
 
  | 2012-09-30 | 
  jbe | 
  Added TODO for broken implementation of tie-breaking | 
 
 
  | 2012-09-29 | 
  jbe | 
  Better tie-breaking | 
 
 
  | 2012-09-25 | 
  jbe | 
  merge: Switched order of row-level and table-level member locking | 
 
 
  | 2012-09-25 | 
  jbe | 
  Switched order of row-level and table-level member locking | 
 
 
  | 2012-09-25 | 
  jbe | 
  merge: In function "lock_issue"("issue"."id"): Instead of accquiring a table-level EXCLUSIVE lock, use a table-level SHARE lock in combination with row-level SHARE locks | 
 
 
  | 2012-09-25 | 
  jbe | 
  In function "lock_issue"("issue"."id"): Instead of accquiring a table-level EXCLUSIVE lock, use a table-level SHARE lock in combination with row-level share locks | 
 
 
  | 2012-09-25 | 
  jbe | 
  Different locking levels and different locking order in function "lock_issue"("issue"."id") to avoid deadlocks | 
 
 
  | 2012-09-24 | 
  jbe | 
  Use SHARE MODE table locks in function "lock_issue"("issue"."id") for tables neither referenced nor changed | 
 
 
  | 2012-09-13 | 
  jbe | 
  Use EXCLUSIVE MODE table locks in function "lock_issue"("issue"."id") | 
 
 
  | 2012-08-26 | 
  jbe | 
  Correctly transform existing "contingent" entries when updating to v2.1.0 | 
 
 
  | 2012-08-25 | 
  jbe | 
  Split contingent into polling and non-polling contingent | 
 
 
  | 2012-08-20 | 
  jbe | 
  No "issue_quorum" for polling policies | 
 
 
  | 2012-08-20 | 
  jbe | 
  Issues may have an admission_time set to NULL | 
 
 
  | 2012-08-19 | 
  jbe | 
  Modified function "forbid_changes_on_closed_issue_trigger" to allow voting comments to be changed after voting has finished | 
 
 
  | 2012-08-19 | 
  jbe | 
  Updated comments for polling mode in core.sql and core-update.v2.0.11-v2.1.0.sql | 
 
 
  | 2012-08-19 | 
  jbe | 
  Changed order of "close_voting" and "clean_issue" functions in update/core-update.v2.0.11-v2.1.0.sql | 
 
 
  | 2012-08-19 | 
  jbe | 
  Commented update/core-update.v2.0.11-v2.1.0.sql | 
 
 
  | 2012-08-19 | 
  jbe | 
  Deprecated old API tables in update script update/core-update.v2.0.11-v2.1.0.sql | 
 
 
  | 2012-08-19 | 
  jbe | 
  Moved voting comment to table "direct_voter" | 
 
 
  | 2012-08-19 | 
  jbe | 
  "non_voter" deletes "direct_voter" and vice versa | 
 
 
  | 2012-08-19 | 
  jbe | 
  Included changed comment on function "delete_private_data"() in core-update.v2.0.11-v2.1.0.sql | 
 
 
  | 2012-08-19 | 
  jbe | 
  Removed preliminary API tables for upcoming release (will be included later) | 
 
 
  | 2012-08-15 | 
  jbe | 
  URL for registered (web) API clients | 
 
 
  | 2012-08-15 | 
  jbe | 
  Unique "client_identifier" for "registered_client", No foreign key in table "authorized_client" | 
 
 
  | 2012-08-15 | 
  jbe | 
  Work on tables for OAuth2 | 
 
 
  | 2012-08-10 | 
  jbe | 
  Included old API tables maked as "deprecated" to allow testing with alpha api and preliminary authorization interface after core update to v2.1 | 
 
 
  | 2012-08-10 | 
  jbe | 
  Marked API tables as preliminary | 
 
 
  | 2012-08-10 | 
  jbe | 
  Added field "code_grant_multiple" to "api_client" | 
 
 
  | 2012-08-09 | 
  jbe | 
  Renamed "token_grant" to "implicit_grant" and fixed comments | 
 
 
  | 2012-08-09 | 
  jbe | 
  Notice in README file about "delete_private_data"() function | 
 
 
  | 2012-08-09 | 
  jbe | 
  Hint in function "delete_private_data" for cases where different data shall be deleted | 
 
 
  | 2012-08-09 | 
  jbe | 
  Changed comments in table "api_client" to specify that certain values are maximum values | 
 
 
  | 2012-08-09 | 
  jbe | 
  Work on OAuth2 | 
 
 
  | 2012-08-08 | 
  jbe | 
  Removed "parallel_access" flag from API tables; Copy access_level and validity_period to table "api_access" | 
 
 
  | 2012-08-08 | 
  jbe | 
  Added "parallel_access" and "old_refresh_token" to API tables | 
 
 
  | 2012-08-08 | 
  jbe | 
  API client name not unique; Use OAuth2 client identifier as redirection endpoint | 
 
 
  | 2012-08-08 | 
  jbe | 
  Work on OAuth 2.0 authorization support | 
 
 
  | 2012-08-08 | 
  jbe | 
  API system clients and redundancy in API access table | 
 
 
  | 2012-08-08 | 
  jbe | 
  Draft for OAuth 2.0 authorization support | 
 
 
  | 2012-08-07 | 
  jbe | 
  Changed Makefile: Placed argument for the linked library after the source file that uses its symbols | 
 
 
  | 2012-07-15 | 
  jbe | 
  For "polling" policies "admission_time" is always NULL | 
 
 
  | 2012-07-15 | 
  jbe | 
  Added update/core-update.v2.0.11-v2.1.0.sql | 
 
 
  | 2012-07-15 | 
  jbe | 
  Polling mode | 
 
 
  | 2012-07-15 | 
  jbe | 
  Policies with "free_timing" | 
 
 
  | 2012-07-15 | 
  jbe | 
  Removed "issue_comment" | 
 
 
  | 2012-06-20 | 
  jbe | 
  Updated LICENSE file | 
 
 
  | 2012-06-20 | 
  jbe | 
  Added tag v2.0.11 for changeset e818f83e133b | 
 
 
  | 2012-06-20 | 
  jbe | 
  Added update script from v2.0.10 to v2.0.11v2.0.11  | 
 
 
  | 2012-06-20 | 
  jbe | 
  Simulation of default delegation in functions "delegation_chain" and "delegation_info" | 
 
 
  | 2012-06-15 | 
  jbe | 
  Added tag v2.0.10 for changeset 389200fd973d | 
 
 
  | 2012-05-20 | 
  jbe | 
  Added field "participating_member_id" to result of "delegation_info" functionv2.0.10  | 
 
 
  | 2012-05-15 | 
  jbe | 
  Added tag v2.0.9 for changeset 5ee7eed2f5b0 | 
 
 
  | 2012-05-15 | 
  jbe | 
  Updated README file, noting that data import after updating has to be done as database superuserv2.0.9  | 
 
 
  | 2012-05-15 | 
  jbe | 
  Allow "calculate_ranks" to work properly, even if there was a previous counting of votes (due to manual reset of issue state) | 
 
 
  | 2012-05-14 | 
  jbe | 
  Bugfix in core-update.v1.4.0-v2.0.0.sql: Explicitly drop NOT NULL constraint of columns winning/losing_initiative_id | 
 
 
  | 2012-05-12 | 
  jbe | 
  Bugfix in view "unit_member_count" | 
 
 
  | 2012-05-11 | 
  jbe | 
  Function "delegation_info": Do not set "other_trustee_id" when overriden by previous participation | 
 
 
  | 2012-05-10 | 
  jbe | 
  Backported fix of future version to update script to v2.0.0 to be able to include unused invite codes in member table | 
 
 
  | 2012-05-10 | 
  jbe | 
  Fixed update script from v1.4.0 to v2.0.0: Keep unused invite codes | 
 
 
  | 2012-05-10 | 
  jbe | 
  Update script to v2.0.9 | 
 
 
  | 2012-05-10 | 
  jbe | 
  Comments on delegation information functions | 
 
 
  | 2012-05-10 | 
  jbe | 
  Support closed issues in "delegation_chain" function; Work on "delegation_info" function | 
 
 
  | 2012-05-10 | 
  jbe | 
  Function "delegation_chain" returns unknown participation for other members during voting | 
 
 
  | 2012-05-10 | 
  jbe | 
  New function "delegation_info" | 
 
 
  | 2012-03-15 | 
  jbe | 
  Added tag v2.0.8 for changeset fefc15eb747b | 
 
 
  | 2012-03-15 | 
  jbe | 
  Bugfix: Delete member fields "lang", "notify_level" and "formatting_engine" in function "delete_private_data"; Update script to v2.0.8v2.0.8  | 
 
 
  | 2012-03-13 | 
  jbe | 
  Added tag v2.0.7 for changeset 4346d48b1780 | 
 
 
  | 2012-03-13 | 
  jbe | 
  Update script to v2.0.7v2.0.7  |