liquid_feedback_core

log

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 Added tag v4.1.0 for changeset b8f106eb5dbf
20 months ago jbe Fixed accidentally modified .hgtags filev4.1.0
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 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"

Impressum / About Us