liquid_feedback_core

log

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

Impressum / About Us