| age |
author |
description |
| 2016-04-01 |
jbe |
Fixed wrong calculation of "leading" column |
| 2016-04-01 |
jbe |
Removed wrong "ISNULL" in view "updated_initiative" |
| 2016-03-30 |
jbe |
New columns "supported", "new_draft", "new_suggestion_count", "featured", "leading" in view "initiative_for_notification" and associated helper views |
| 2016-03-30 |
jbe |
Function "featured_initiative" simplified |
| 2016-03-30 |
jbe |
Added missing EXIT statement in featured_initiative function |
| 2016-03-30 |
jbe |
New view "initiative_for_notification" using helper views/functions "updated_initiative", "featured_initiative", and "leading_complement_initiative" |
| 2016-03-29 |
jbe |
New view "updated_initiative" |
| 2016-03-28 |
jbe |
Removed experimental algorithm for determining issues to be included in notification mails |
| 2016-03-27 |
jbe |
Bugfix in view "new_updated_issue_for_notification" |
| 2016-03-27 |
jbe |
Work on view "new_updated_issue_for_notification" |
| 2016-03-26 |
jbe |
New view "new_issue_for_notification" (helper view for "issue_for_notification") |
| 2016-03-26 |
jbe |
Work on "issue_for_notification" table |
| 2016-03-26 |
jbe |
Stub VIEW that selects issues which are to be included in notifications |
| 2016-03-26 |
jbe |
Added TODO (regarding possibly unnecessary DISTINCT clause) |
| 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-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-03 |
jbe |
Require "min_admission_time" to be smaller than or equal to "max_admission_time" in "policy" table |
| 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 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 |
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 |
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-06-11 |
jbe |
Bugfix in "close_voting" function that only affected PostgreSQL versions prior 9.1v3.0.2 |
| 2014-05-22 |
jbe |
Bugfix in tie-breaking: Type for worst possible link strength must be "link_strength", not "INT8" |
| 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 |
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 |
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 |
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-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 |