liquid_feedback_core

log core.sql

age author description
19 months ago jbe Removed an index on table "initiative"
19 months ago jbe Reduced indices on "issue" table
19 months ago jbe Renamed indices on issue to match naming convention
19 months ago jbe Added missing index on "member_useterms" table
19 months ago jbe Removed "snapshot_retention" configuration: always delete unused snapshots immediately
19 months ago jbe Added "posting" table and follower concept for members (column "following" in table "contact")
19 months ago jbe Bug in check_issue function fixed, which could lead to non-accepted issues staying open after admission phase has ended
20 months ago jbe Updated version number to v4.1.0; Updated years in LICENSE file
20 months ago jbe Added "unsubscribe_secret" column
22 months ago 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"

Impressum / About Us