liquid_feedback_core

log

age author description
8 months ago jbe Added code to suppress compiler warning (writing one byte into region of size 0)default tip
8 months ago jbe Added tag v4.2.2 for changeset 5b7c4082d7b3
8 months ago jbe Version 4.2.2 with geoindices uninstalled by defaultv4.2.2
10 months ago jbe Added tag v4.2.1 for changeset e0b8175fda29
10 months ago jbe Added TODO notice regarding indices on "posting"v4.2.1
10 months ago 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
11 months ago jbe Added missing referential integrity constraint on "posting" table
12 months ago jbe Bugfix in function "featured_initiative" regarding reference to "issue_privilege" instead of "privilege"
15 months ago jbe Added JSONB column "attr" to table "unit" for extended attributes of any kind
17 months ago jbe Added update script core-update.v4.2.0-v4.2.1.sql
17 months ago jbe Fixed grammar in comment on "unit"."member_weight"
17 months ago jbe Merged fix regarding wrong version number info in core-update.v4.1.0-v4.2.0.sql
17 months ago jbe Removed wrong string "incomplete-update" and wrong revision number -1 from final update script for version 4.2.0
17 months ago jbe Fixed bug in take_snapshot function regarding issue_privilege (use issue_id_p instead of issue_id_v)
17 months ago jbe Bugfix regarding "issue_privilege"."voting_right" in "delegation_chain" function
17 months ago jbe Issue based privileges to override unit based privileges
17 months ago jbe Support for own voting weight other than 1
20 months ago jbe Added tag v4.2.0 for changeset 93e69d1e17ab
20 months ago jbe Updated years in LICENSE filev4.2.0
20 months ago jbe Included hint in README on solving apparently missing data types from extensions
20 months ago jbe Removed transaction around ALTER TYPE for compatibility with older PostgreSQL versions
20 months ago jbe Removed column "content_type" from table "draft_attachment" (Content type is stored in "file" table instead)
20 months ago jbe Added update script to version 4.2.0
20 months ago jbe Added explicit names for text search indices
20 months ago jbe Include column "content_type" of "file" table in UNIQUE index
20 months ago jbe Referential integrity for files: Delete files when last reference is removed
20 months ago 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 Added tag v4.1.0 for changeset b8f106eb5dbf
2018-11-18 jbe Fixed accidentally modified .hgtags filev4.1.0
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 Added tag v4.0.0 for changeset ed3c3d8bd16b
2017-09-29 jbe Set version number to 4.0.0v4.0.0
2017-09-29 jbe Fill new columns "issue_quorum" and "initiative_quorum" of "issue" table in update script to version 4.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 Bugfix in update script to version 4.0.0: set new "policy_id" column in "event" table
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 regarding snapshots in admission phase: use correct snapshot_id in lf_update program
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 Data migration of accepted terms of use (from "setting" table to "member_settings" table)
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 Updated LICENSE file
2017-03-30 jbe Several changes/additions for upcoming major release
2016-08-21 jbe pgLatLon is now a stand-alone extension for PostgreSQL
2016-08-21 jbe Fixed typo in documentation and comments: "indicies" -> "indices"; Marked make-doc.sh as executable
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-27 jbe Updated LICENSE file (year 2016)
2016-05-06 jbe Merged experimental work on alternative mechanism to the first (issue) quorum
2016-05-06 jbe Added tag v3.2.2 for changeset bc6d9dc60ca4
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 Set notification settings to zero/NULL/DEFAULT for deleted members
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 Added tag v3.2.1 for changeset e4f619e87664
2016-04-30 jbe Fixed accidental PostgreSQL 9.5 dependency (because of UPSERT aka ON CONFLICT clause)v3.2.1
2016-04-24 jbe Added tag v3.2.0 for changeset ab05fb3bf974
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 Drop and re-create view "expired_session" in update script to v3.2.0 (necessary to alter column type in table "session")
2016-04-16 jbe Corrected execution order in update script to v3.2.0
2016-04-16 jbe Added comment on function "get_initiatives_for_notification"
2016-04-16 jbe Updated update script to v3.2.0
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 Fixed minor error in update script (DROP VIEW instead of DROP TABLE)
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 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

Impressum / About Us