liquid_feedback_core

log

age author description
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 Updated preliminary update script for new notification system
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-04-01 jbe Repaired preliminary update script
2016-03-31 jbe Added preliminary update script
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-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

Impressum / About Us