age |
author |
description |
2016-03-26 |
jbe |
Changed table/column order |
2016-03-25 |
jbe |
Removed empty line |
2016-03-18 |
jbe |
Use ERRCODE and HINT when raising exceptions |
2016-03-17 |
jbe |
Added tables "subscription_time" and "advertisement" (work on notification system) |
2016-03-17 |
jbe |
Changed reference to "member_id" in two tables to INT4 (was INT8) |
2016-03-16 |
jbe |
Work on new notification system: new column "disable_notifications" in "member" table, new tables "subscription" and "ignored_area", dropped view "selected_event_seen_by_member" |
2015-12-14 |
jbe |
Added tag v3.1.0 for changeset a9c4521466e6 |
2015-12-12 |
jbe |
Absolute first supporter quorum (in addition to admission_rule/holdoff_time mechanism) |
2015-12-11 |
jbe |
Draft for an alternative mechanism to the first (issue) quorum |
2015-12-04 |
jbe |
Fixed v3.1.0 update script to properly update policies/issues with "polling" set to TRUEv3.1.0 |
2015-12-03 |
jbe |
Fixed error in update script to v3.1.0 |
2015-12-03 |
jbe |
Require "min_admission_time" to be smaller than or equal to "max_admission_time" in "policy" table |
2015-12-03 |
jbe |
Update script for v3.1.0 |
2015-12-03 |
jbe |
Added parenthesis in constraint "admission_time_not_null_unless_instantly_accepted" |
2015-12-03 |
jbe |
Shortened constraint names to be less than 64 characters long |
2015-12-01 |
jbe |
Removed "initiative"."discussion_url" |
2015-12-01 |
jbe |
Removed deprecated API tables |
2015-12-01 |
jbe |
Re-added removed deprecated API tables (already accidentally removed in previous commit) |
2015-11-27 |
jbe |
Added "min_admission_time"; Renamed "admission_time" to "max_admission_time"; Added parenthesis (trouble with operator precedence in PostgreSQL 9.5 alpha2) |
2015-07-18 |
jbe |
Added tag v3.0.5 for changeset fbb49f35b4e1 |
2015-07-18 |
jbe |
Fixed error in demo.sql file (missing "polling" column in INSERT statement for "contingent" table)v3.0.5 |
2015-07-18 |
jbe |
Added support for storing external references (opaque data field) to "unit", "area", "issue", "initiative", "draft", and "suggestion" tables |
2015-04-03 |
jbe |
Code cleanup: write single occurrence of "if" in upper case ("IF") |
2014-07-23 |
jbe |
Added tag v3.0.4 for changeset f5c78b0590c6 |
2014-07-23 |
jbe |
Delete authority_* information from members in functions "delete_member" and "delete_private_data"v3.0.4 |
2014-07-22 |
jbe |
Added data structures to support externally managed accounts (e.g. LDAP) |
2014-07-16 |
jbe |
Added tag v3.0.3 for changeset 785ea3c0fd18 |
2014-07-16 |
jbe |
Removed old notice in update/core-update.v3.0.2-v3.0.3.sqlv3.0.3 |
2014-07-16 |
jbe |
Improved previous fix of "close_voting" function |
2014-07-16 |
jbe |
2 bugfixes: Error in core-update.v2.2.6-v3.0.1.sql fixed; Always set "initiative"."first_preference_votes" (also if no votes are found) |
2014-07-11 |
jbe |
Added missing information on "lf_update_issue_order" to README file |
2014-07-10 |
jbe |
Added tag v3.0.2 for changeset 603f6e4bbedf |
2014-06-11 |
jbe |
Bugfix in "close_voting" function that only affected PostgreSQL versions prior 9.1v3.0.2 |
2014-05-22 |
jbe |
Updated update script to include previous bugfix |
2014-05-22 |
jbe |
Bugfix in tie-breaking: Type for worst possible link strength must be "link_strength", not "INT8" |
2014-05-22 |
jbe |
Update script to v3.0.2 added |
2014-05-22 |
jbe |
Re-added experimental "no_reverse_beat_path" feature for next minor version (provides backward compatibility) |
2014-05-22 |
jbe |
Code cleanup regarding new tie-breaking |
2014-05-22 |
jbe |
Implemented tie-breaking according to chapter 5 of schulze1.pdf (draft, 2 July 2012) |
2014-05-21 |
jbe |
Use a composite type of two INT8's to describe the strength of a link for the Schulze method (necessary for tie-breaking of the links); Removed "no_reverse_beat_path" option |
2014-04-14 |
jbe |
Generalized comment on "defeat_strength" function |
2014-04-14 |
jbe |
Separate configuration options for "defeat_strength" and "tie_breaking" |
2014-04-10 |
jbe |
Work on configuration of complexity of counting of the votes (extent of tie-breaking): |
2014-04-05 |
jbe |
Added tag v3.0.1 for changeset 044a2b65c707 |
2014-04-05 |
jbe |
Added tag v2.2.6 for changeset eaba9174d117 |
2014-04-05 |
jbe |
Merged from v2.2.6: Marked "no_reverse_beat_path" and "no_multistage_majority" as experimental; Disabled "no_reverse_beat_path" by defaultv3.0.1 |
2014-04-05 |
jbe |
Marked "no_reverse_beat_path" and "no_multistage_majority" as experimental; Disabled "no_reverse_beat_path" by defaultv2.2.6 |
2014-03-26 |
jbe |
Bugfix for battle data reconstruction in update script |
2014-03-26 |
jbe |
Reconstruct battle data in update script to avoid future data loss when executing "clean_issue" to delete voting data |
2014-03-26 |
jbe |
Added update script to introduce "first_preference_votes" |
2014-03-26 |
jbe |
When marking first preferences, use JOIN via "initiative" table due to missing index on "vote"."issue_id" |
2014-03-26 |
jbe |
Calculation of "first_preference" votes |
2014-01-31 |
jbe |
Added tag v3.0.0 for changeset 399dc1a86398 |
2014-01-31 |
jbe |
Marked version as v3.0.0v3.0.0 |
2013-12-23 |
jbe |
"schulze_rank" includes tie-breaking by "id" |
2013-10-14 |
jbe |
Proportional Runoff for issues both based on single areas and single units |
2013-10-14 |
jbe |
Secondary sorting key for issues in admission phase |
2013-10-14 |
jbe |
core.sql: Removed "order_in_open_states" |
2013-10-14 |
jbe |
lf_update_issue_order.c: Replaced occurences of "suggestion" with "issue" |
2013-10-14 |
jbe |
Removed algorithm to calculate "order_in_open_states" |
2013-10-14 |
jbe |
Added TODO regarding a bug in lf_update_issue_order.c |
2013-10-13 |
jbe |
lf_update_issue_order.c: Insert "issue_order" rows for all issues in the area |
2013-10-13 |
jbe |
Fixed syntax error in SQL command in lf_update_issue_order.c |
2013-10-12 |
jbe |
Improved comments/debug output in lf_update_issue_order.c |
2013-10-12 |
jbe |
lf_update_issue_order deletes stale entries in "issue_order" that may arise due to missing referential integrity |
2013-10-12 |
jbe |
Remove referential integrity from "issue_order" table to avoid performance/locking issues |
2013-10-11 |
jbe |
Algorithm to write "issue_order"."order_in_open_states" |
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-11 |
jbe |
Always delete ordering ranks of issues (lf_update_issue_order.c) |
2013-10-11 |
jbe |
Calculation of "order_in_admission_state" |
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-12 |
jbe |
Added tag v2.2.5 for changeset 992ec266356d |
2013-08-11 |
jbe |
Added notice regarding PostgreSQL 9.1 requirement to update scriptv2.2.5 |
2013-08-11 |
jbe |
Added column "admin_notice" to "issue" table, and value 'canceled_by_admin' to "issue_state" type |
2013-07-14 |
jbe |
Added tag v2.2.4 for changeset ae69cf82c05f |
2013-04-20 |
jbe |
Added support for delegation checks and login recovery; Removed unnecessary join in event viewsv2.2.4 |
2013-03-23 |
jbe |
Added tag v2.2.3 for changeset e474e9e1240a |
2013-03-23 |
jbe |
Code cleanup regarding temporary storage of session/transaction data to disable protection triggersv2.2.3 |
2013-03-22 |
jbe |
Added tag v2.2.2 for changeset 1c991490f075 |
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 |
Removed excessive space characters in lf_update_suggestion_order.c |
2013-03-18 |
jbe |
Added tag v2.2.1 for changeset 0f5841ef67c6 |
2013-03-18 |
jbe |
Updated README file to include information on lf_update_suggestion_orderv2.2.1 |
2013-03-18 |
jbe |
Enable compiler optimization flags in Makefile |
2013-03-18 |
jbe |
Bugfix regarding "proportional_order" of suggestions: |
2013-03-18 |
jbe |
Improved log output of lf_update_suggestion_order |
2013-03-18 |
jbe |
More verbose logging in lf_update_suggestion_order.c |
2013-03-17 |
jbe |
Added colon in comment in lf_update.c and lf_update_suggestion_order.c |
2013-03-17 |
jbe |
Optional logging in "lf_update_suggestion_order" |
2013-03-17 |
jbe |
Fixed bug in while loop of "loser" function of lf_update_suggestion_order.c, that has been introduced in last commit |
2013-03-17 |
jbe |
Added comments to lf_update_suggestion_order.c |
2013-03-17 |
jbe |
For suggestions without individual rankings, set "proportional_order" to zero instead of NULL |
2013-03-17 |
jbe |
Bugfix in "lf_update_suggestion_order" related to floating point error workaround |
2013-03-17 |
jbe |
Bugfix: Numerical ordering of suggestion_id in "lf_update_suggestion_order" |
2013-03-17 |
jbe |
In "lf_update_suggestion_order" take ballot weight into account |
2013-03-17 |
jbe |
Bugfix in "lf_update_suggestion_order": Set candidate_count to zero, also in cases where no tuples are returned |
2013-03-17 |
jbe |
Fixed errors in function "process_initiative" of "lf_update_suggestion_order", which caused memory access errors |
2013-03-17 |
jbe |
Bugfix in function "process_initiative" of "lf_update_suggestion_order": Reset old_member_id to NULL |
2013-03-17 |
jbe |
Added "lf_update_suggestion_order" to clean taget of makefile |
2013-03-17 |
jbe |
Removed unused variable in "lf_update_suggestion_order" |
2013-03-17 |
jbe |
Help output of "lf_update" and "lf_update_suggestion_order" either to stdout or stderr, depending on invocation |
2013-03-17 |
jbe |
Include "final" flag in debug output of "lf_update_suggestion_order" |
2013-03-17 |
jbe |
Update script to v2.2.1 |
2013-03-17 |
jbe |
Write "final_suggestion_order_calculated" flag in "lf_update_suggestion_order" |
2013-03-17 |
jbe |
Write ranks to database in "lf_update_suggestion_order" |
2013-03-17 |
jbe |
Handle out-of-memory errors in "lf_update" when escaping string literals |
2013-03-17 |
jbe |
Calculation of ranks in "lf_update_suggestion_order" |
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 |
2012-03-13 |
jbe |
Delete sessions: |
2012-03-11 |
jbe |
Added tag v2.0.6 for changeset f022016f6748 |
2012-03-11 |
jbe |
Update script to v2.0.6v2.0.6 |
2012-03-10 |
jbe |
Added column "invite_code_expiry" to table "member" |
2012-03-10 |
jbe |
Bugfix in function "write_event_initiative_revoked_trigger": Set "draft_id" in "event" table |
2012-03-05 |
jbe |
Bugfix: Do not write history entries for non-activated members |
2012-03-05 |
jbe |
Added tag v2.0.5 for changeset 6e273a6ed235 |
2012-03-05 |
jbe |
Delete "admin_comment" in function "delete_private_data"; Update script for v2.0.5v2.0.5 |
2012-03-01 |
jbe |
Added tag v2.0.4 for changeset 10a231cfd585 |
2012-02-28 |
jbe |
Delete non-activated members in function "delete_private_data"v2.0.4 |