| age | 
  author | 
  description | 
 
 
  | 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 |