liquid_feedback_core

log

age author description
2020-07-28 jbe Added JSONB column "attr" to table "unit" for extended attributes of any kind
2020-05-17 jbe Added update script core-update.v4.2.0-v4.2.1.sql
2020-05-17 jbe Fixed grammar in comment on "unit"."member_weight"
2020-05-17 jbe Merged fix regarding wrong version number info in core-update.v4.1.0-v4.2.0.sql
2020-05-17 jbe Removed wrong string "incomplete-update" and wrong revision number -1 from final update script for version 4.2.0
2020-05-17 jbe Fixed bug in take_snapshot function regarding issue_privilege (use issue_id_p instead of issue_id_v)
2020-05-16 jbe Bugfix regarding "issue_privilege"."voting_right" in "delegation_chain" function
2020-05-16 jbe Issue based privileges to override unit based privileges
2020-05-15 jbe Support for own voting weight other than 1
2020-02-11 jbe Added tag v4.2.0 for changeset 93e69d1e17ab
2020-02-11 jbe Updated years in LICENSE filev4.2.0
2020-02-11 jbe Included hint in README on solving apparently missing data types from extensions
2020-02-11 jbe Removed transaction around ALTER TYPE for compatibility with older PostgreSQL versions
2020-02-10 jbe Removed column "content_type" from table "draft_attachment" (Content type is stored in "file" table instead)
2020-02-07 jbe Added update script to version 4.2.0
2020-02-07 jbe Added explicit names for text search indices
2020-02-06 jbe Include column "content_type" of "file" table in UNIQUE index
2020-02-06 jbe Referential integrity for files: Delete files when last reference is removed
2020-02-06 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"

Impressum / About Us