age |
author |
description |
2013-10-12 |
jbe |
Remove referential integrity from "issue_order" table to avoid performance/locking issues |
2013-10-11 |
jbe |
New table "issue_order" for ordering fields to avoid a bottleneck with locking |
2013-10-11 |
jbe |
Added helper view "open_issues_ordered_with_minimum_position" for lf_update_issue_order.c |
2013-10-11 |
jbe |
Update script to v2.2.6 |
2013-10-10 |
jbe |
Adjusted indentation of "issue" field comments in source code |
2013-10-10 |
jbe |
Work on new issue sorting algorithm |
2013-08-11 |
jbe |
Added column "admin_notice" to "issue" table, and value 'canceled_by_admin' to "issue_state" type |
2013-04-20 |
jbe |
Added support for delegation checks and login recovery; Removed unnecessary join in event viewsv2.2.4 |
2013-03-23 |
jbe |
Code cleanup regarding temporary storage of session/transaction data to disable protection triggersv2.2.3 |
2013-03-22 |
jbe |
Fixed an error, which occurred when deleting votes from voters, which lost their voting right during voting phasev2.2.2 |
2013-03-18 |
jbe |
Bugfix regarding "proportional_order" of suggestions: |
2013-03-17 |
jbe |
Update script to v2.2.1 |
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-09 |
jbe |
Bugfix for calculation of harmonic_weight, when there are initiatives without supporters |
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 |
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-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 |
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-05 |
jbe |
Merged fix from v2.0.12: Removed unwanted (and broken) tie-breaking by approval rate |
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-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 |