age |
author |
description |
4 months ago |
jbe |
Fixed mistake in last-level tie-breakingdefault tip |
2021-02-05 |
jbe |
Version 4.2.2 with geoindices uninstalled by defaultv4.2.2 |
2020-12-05 |
jbe |
Added TODO notice regarding indices on "posting"v4.2.1 |
2020-12-05 |
jbe |
Removed indices for timeline retrieval (removes dependency on pgConflux); Changed update script to previous version 4.2.0 to enforce particular version of pgConflux; Added update script to skip intermediate dependency on pgConflux |
2020-11-27 |
jbe |
Added missing referential integrity constraint on "posting" table |
2020-10-05 |
jbe |
Bugfix in function "featured_initiative" regarding reference to "issue_privilege" instead of "privilege" |
2020-07-28 |
jbe |
Added JSONB column "attr" to table "unit" for extended attributes of any kind |
2020-05-17 |
jbe |
Fixed grammar in comment on "unit"."member_weight" |
2020-05-17 |
jbe |
Fixed bug in take_snapshot function regarding issue_privilege (use issue_id_p instead of issue_id_v) |
2020-05-16 |
jbe |
Bugfix regarding "issue_privilege"."voting_right" in "delegation_chain" function |
2020-05-16 |
jbe |
Issue based privileges to override unit based privileges |
2020-05-15 |
jbe |
Support for own voting weight other than 1 |
2020-02-10 |
jbe |
Removed column "content_type" from table "draft_attachment" (Content type is stored in "file" table instead) |
2020-02-07 |
jbe |
Added explicit names for text search indices |
2020-02-06 |
jbe |
Include column "content_type" of "file" table in UNIQUE index |
2020-02-06 |
jbe |
Referential integrity for files: Delete files when last reference is removed |
2020-02-06 |
jbe |
Added tables "file" and "draft_attachment" |
2019-08-26 |
jbe |
Bugfix in highlight function (use PostgreSQL's built-in "plainto_tsquery" function) |
2019-01-10 |
jbe |
Support for hashtag search |
2018-12-08 |
jbe |
Revised full text search |
2018-12-08 |
jbe |
Fixed wrong constraint "initiative_ids_not_equal" on "battle" table (due to handling of NULLs in CHECK constraints) |
2018-12-08 |
jbe |
Removed an index on table "initiative" |
2018-12-08 |
jbe |
Reduced indices on "issue" table |
2018-12-07 |
jbe |
Renamed indices on issue to match naming convention |
2018-12-07 |
jbe |
Added missing index on "member_useterms" table |
2018-12-07 |
jbe |
Removed "snapshot_retention" configuration: always delete unused snapshots immediately |
2018-12-05 |
jbe |
Added "posting" table and follower concept for members (column "following" in table "contact") |
2018-12-03 |
jbe |
Bug in check_issue function fixed, which could lead to non-accepted issues staying open after admission phase has ended |
2018-11-18 |
jbe |
Updated version number to v4.1.0; Updated years in LICENSE file |
2018-11-18 |
jbe |
Added "unsubscribe_secret" column |
2018-09-04 |
jbe |
Bugfix in function "write_event_initiative_revoked_trigger" (wrong use of SELECT, needs to be PERFORM) |
2018-03-04 |
jbe |
Introduced "accepted" flag for agents of role/member accounts |
2018-03-04 |
jbe |
Further work on role accounts (role_verification, real_member_id) |
2018-03-02 |
jbe |
Bugfix in index "ignored_area_member_id_fkey" |
2018-02-22 |
jbe |
Support for role accounts |
2018-02-22 |
jbe |
Merged experimental workaround for missing spatio-temporal index as commented-out section |
2017-10-23 |
jbe |
Removed comment on hidden applications in "system_application" table |
2017-10-23 |
jbe |
Split-up "discovery_baseurl" into "base_url" and "manifest_url" |
2017-10-02 |
jbe |
Bugfix in "expired_token" view: added missing qualifier to avoid authorization codes to be deleted when used |
2017-10-01 |
jbe |
Experimental workaround for missing spatio-temporal index when looking up recently closed initiatives (with LIMIT) inside a bounding box |
2017-09-29 |
jbe |
Set version number to 4.0.0v4.0.0 |
2017-09-29 |
jbe |
Bugfix in view "unit_member" (wrong ON clause for JOIN) |
2017-09-29 |
jbe |
New columns "issue_quorum" and "initiative_quorum" for "issue" table |
2017-09-28 |
jbe |
Removed unused function "calculate_area_quorum" (done by function "issue_admission") |
2017-09-27 |
jbe |
merge |
2017-09-27 |
jbe |
Fixed wrong comparison when considering absolute initiative quorum (greater-equal instead greater-than) |
2017-09-25 |
bsw |
Bug fix in constr_for_delegation on event table |
2017-09-25 |
jbe |
Bugfix regarding locking when logging initiative revocation (cannot combine DISTINCT with FOR SHARE) |
2017-09-25 |
jbe |
Bugfix in "take_snapshot" function when determining unit_id |
2017-09-25 |
jbe |
Added missing WHERE clause in "check_issue" function when updating snapshot IDs of issues |
2017-09-21 |
jbe |
Changes to "verification" table |
2017-09-20 |
jbe |
Bugfix in "member_useterms" table: allow multiple entries per member |
2017-09-20 |
jbe |
Set default for column "accepted" in "member_useterms" |
2017-09-18 |
jbe |
Added "verification" table to store verification requests |
2017-09-17 |
jbe |
Backed out changeset 5d098bcc631a (member-unit verification and "verified_privilege" view) |
2017-09-17 |
jbe |
Member verification through organizational units |
2017-09-16 |
jbe |
Renamed events 'member_removed' and 'suggestion_removed' to 'member_deleted' and 'suggestion_deleted' |
2017-09-16 |
jbe |
Added column "member"."deleted" as TIMESTAMPTZ |
2017-09-16 |
jbe |
Renamed "region" (for "unit" and "area") to "location" |
2017-09-12 |
jbe |
Bugfix in function "write_event_initiator_trigger" |
2017-08-05 |
jbe |
Added "discovery_baseurl" for system applications |
2017-07-18 |
jbe |
Use unit/area/policy_updated event instead of unit/area/policy_removed |
2017-07-18 |
jbe |
Fixed unit/area/policy event triggers |
2017-07-14 |
jbe |
New tables "member_settings" and "member_useterms"; Make column "profile" of "member_profile" a NOT NULL column (with DEFAULT) |
2017-07-14 |
jbe |
Updates for "delete_member" and "delete_private_data" functions |
2017-07-14 |
jbe |
Removed settings tables |
2017-07-14 |
jbe |
Indentation fixed |
2017-06-26 |
jbe |
Changed detection method for removed members in event trigger |
2017-06-26 |
jbe |
Renamed three "event_type"s |
2017-06-26 |
jbe |
Implementation of unit/area/policy event triggers |
2017-06-26 |
jbe |
Stubs for unit/area/policy event triggers |
2017-06-26 |
jbe |
Work on unit/area/policy events: added column "policy_id" to "event" table, added new "event_type"s |
2017-06-18 |
jbe |
Bugfix in write_event_support_trigger |
2017-04-21 |
jbe |
Renamed table "notification_event_sent" to "event_processed" |
2017-03-30 |
jbe |
Several changes/additions for upcoming major release |
2016-08-18 |
jbe |
New PostgreSQL extension "pgLatLon" for geospatial operations and indexing in LiquidFeedback |
2016-05-29 |
jbe |
Work on new issue admission system (replacing current approach of 1st quorum); Added support for geo-tagging and spatial indexing |
2016-05-06 |
jbe |
Merged experimental work on alternative mechanism to the first (issue) quorum |
2016-05-05 |
jbe |
Require members to be "activated" in order to receive messages/notifications; New views "member_eligible_to_be_notified" and "member_to_notify"v3.2.2 |
2016-05-04 |
jbe |
Fixed functions "delete_member" and "delete_private_data" to properly handle NULL constraints of "member" table |
2016-05-04 |
jbe |
Exclude locked members as recipients in view "scheduled_notification_to_send" |
2016-05-04 |
jbe |
Allow a value of zero as "notification_sample_size" to disable featured initiatives |
2016-05-03 |
jbe |
Merged experimental work on alternative mechanism to the first (issue) quorum |
2016-04-30 |
jbe |
Fixed accidental PostgreSQL 9.5 dependency (because of UPSERT aka ON CONFLICT clause)v3.2.1 |
2016-04-17 |
jbe |
Set column "notification_hour" of "member" table by default to random numberv3.2.0 |
2016-04-17 |
jbe |
Include column "published" in view "newsletter_to_send" (to make ordering easier) |
2016-04-16 |
jbe |
Added comment on function "get_initiatives_for_notification" |
2016-04-16 |
jbe |
Added missing quote |
2016-04-16 |
jbe |
Added SQL COMMENTs |
2016-04-16 |
jbe |
Renamed tables "notification_sent" to "notification_event_sent" and "initiative_notification_sent" to "notification_initiative_sent" |
2016-04-05 |
jbe |
Fixed syntax error in "get_initiatives_for_notification" |
2016-04-05 |
jbe |
New algorithm for view "scheduled_notification_to_send"; Update "notification_sent" column in "get_initiatives_for_notification" function |
2016-04-05 |
jbe |
New column "notification_sent" in "member" table; New view "scheduled_notification_to_send" |
2016-04-05 |
jbe |
Exclude revoked initiatives from updated/featured/leading initiatives in notification system |
2016-04-04 |
jbe |
Use "supporter_count" instead of "harmonic_weight" to determine leading initiative for notification system |
2016-04-04 |
jbe |
Use "recipient_id" instead of "member_id" in function "get_initiatives_for_notification" |
2016-04-04 |
jbe |
Revised notification system; Dropped tables "selected_event_seen_by_member" and "event_seen_by_member" |
2016-04-03 |
jbe |
Corrected comparison operator in view "newsletter_to_send" |
2016-04-03 |
jbe |
Added view "newsletter_to_send" |
2016-04-03 |
jbe |
New table "newsletter" |
2016-04-03 |
jbe |
Removed NOT NULL constraint for column "last_suggestion_id" in table "initiative_notification_sent" (NULL means that no suggestion existed) |
2016-04-03 |
jbe |
Another bugfix in function "get_initiatives_for_notification" |
2016-04-03 |
jbe |
Bugfix in function "get_initiatives_for_notification" |
2016-04-03 |
jbe |
New function "get_initiatives_for_notification" |
2016-04-03 |
jbe |
Require new drafts or new suggestion in area for view "initiative_for_notification" |
2016-04-03 |
jbe |
Fill columns "new_draft" and "new_suggestion_count" in views "updated_or_featured_initiative" and "leading_complement_initiative" |
2016-04-03 |
jbe |
Ignore suggestions with opinion also in returned column "new_suggestion_count" of view "updated_initiative" |
2016-04-03 |
jbe |
Ignore suggestions with opinion |
2016-04-02 |
jbe |
New table "initiative_notification_sent" |
2016-04-01 |
jbe |
Fixed further mistake in views "updated_initiative" and "updated_or_featured_initiative" |
2016-04-01 |
jbe |
Sort harmonic_weight of NULL after zero in updated_or_featured_initiative |
2016-04-01 |
jbe |
Fixed typo in "featured_initiative" function |
2016-04-01 |
jbe |
Bugfix in function "featured_initiative" |
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 |
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 |
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 |
Moved voting comment to table "direct_voter" |
2012-08-19 |
jbe |
"non_voter" deletes "direct_voter" and vice versa |
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 |
Hint in function "delete_private_data" for cases where different data shall be deleted |