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