liquid_feedback_core

log

age author description
3 months ago jbe Added code to suppress compiler warning (writing one byte into region of size 0)default tip
3 months ago jbe Added tag v4.2.2 for changeset 5b7c4082d7b3
3 months ago jbe Version 4.2.2 with geoindices uninstalled by defaultv4.2.2
5 months ago jbe Added tag v4.2.1 for changeset e0b8175fda29
5 months ago jbe Added TODO notice regarding indices on "posting"v4.2.1
5 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
5 months ago jbe Added missing referential integrity constraint on "posting" table
7 months ago jbe Bugfix in function "featured_initiative" regarding reference to "issue_privilege" instead of "privilege"
9 months ago jbe Added JSONB column "attr" to table "unit" for extended attributes of any kind
12 months ago jbe Added update script core-update.v4.2.0-v4.2.1.sql
12 months ago jbe Fixed grammar in comment on "unit"."member_weight"
12 months ago jbe Merged fix regarding wrong version number info in core-update.v4.1.0-v4.2.0.sql
12 months ago jbe Removed wrong string "incomplete-update" and wrong revision number -1 from final update script for version 4.2.0
12 months ago jbe Fixed bug in take_snapshot function regarding issue_privilege (use issue_id_p instead of issue_id_v)
12 months ago jbe Bugfix regarding "issue_privilege"."voting_right" in "delegation_chain" function
12 months ago jbe Issue based privileges to override unit based privileges
12 months ago jbe Support for own voting weight other than 1
15 months ago jbe Added tag v4.2.0 for changeset 93e69d1e17ab
15 months ago jbe Updated years in LICENSE filev4.2.0
15 months ago jbe Included hint in README on solving apparently missing data types from extensions
15 months ago jbe Removed transaction around ALTER TYPE for compatibility with older PostgreSQL versions
15 months ago jbe Removed column "content_type" from table "draft_attachment" (Content type is stored in "file" table instead)
15 months ago jbe Added update script to version 4.2.0
15 months ago jbe Added explicit names for text search indices
15 months ago jbe Include column "content_type" of "file" table in UNIQUE index
15 months ago jbe Referential integrity for files: Delete files when last reference is removed
15 months ago jbe Added tables "file" and "draft_attachment"
20 months ago 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

Impressum / About Us