| age |
author |
description |
| 4 months ago |
jbe |
Fixed mistake in last-level tie-breakingdefault tip |
| 2021-02-05 |
jbe |
Added code to suppress compiler warning (writing one byte into region of size 0) |
| 2021-02-05 |
jbe |
Added tag v4.2.2 for changeset 5b7c4082d7b3 |
| 2021-02-05 |
jbe |
Version 4.2.2 with geoindices uninstalled by defaultv4.2.2 |
| 2020-12-05 |
jbe |
Added tag v4.2.1 for changeset e0b8175fda29 |
| 2020-12-05 |
jbe |
Added TODO notice regarding indices on "posting"v4.2.1 |
| 2020-12-05 |
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 |
| 2020-11-27 |
jbe |
Added missing referential integrity constraint on "posting" table |
| 2020-10-05 |
jbe |
Bugfix in function "featured_initiative" regarding reference to "issue_privilege" instead of "privilege" |
| 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" |
| 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 |
| 2015-04-03 |
jbe |
Code cleanup: write single occurrence of "if" in upper case ("IF") |
| 2014-07-23 |
jbe |
Added tag v3.0.4 for changeset f5c78b0590c6 |
| 2014-07-23 |
jbe |
Delete authority_* information from members in functions "delete_member" and "delete_private_data"v3.0.4 |
| 2014-07-22 |
jbe |
Added data structures to support externally managed accounts (e.g. LDAP) |
| 2014-07-16 |
jbe |
Added tag v3.0.3 for changeset 785ea3c0fd18 |
| 2014-07-16 |
jbe |
Removed old notice in update/core-update.v3.0.2-v3.0.3.sqlv3.0.3 |
| 2014-07-16 |
jbe |
Improved previous fix of "close_voting" function |
| 2014-07-16 |
jbe |
2 bugfixes: Error in core-update.v2.2.6-v3.0.1.sql fixed; Always set "initiative"."first_preference_votes" (also if no votes are found) |
| 2014-07-11 |
jbe |
Added missing information on "lf_update_issue_order" to README file |
| 2014-07-10 |
jbe |
Added tag v3.0.2 for changeset 603f6e4bbedf |
| 2014-06-11 |
jbe |
Bugfix in "close_voting" function that only affected PostgreSQL versions prior 9.1v3.0.2 |
| 2014-05-22 |
jbe |
Updated update script to include previous bugfix |
| 2014-05-22 |
jbe |
Bugfix in tie-breaking: Type for worst possible link strength must be "link_strength", not "INT8" |
| 2014-05-22 |
jbe |
Update script to v3.0.2 added |
| 2014-05-22 |
jbe |
Re-added experimental "no_reverse_beat_path" feature for next minor version (provides backward compatibility) |
| 2014-05-22 |
jbe |
Code cleanup regarding new tie-breaking |
| 2014-05-22 |
jbe |
Implemented tie-breaking according to chapter 5 of schulze1.pdf (draft, 2 July 2012) |
| 2014-05-21 |
jbe |
Use a composite type of two INT8's to describe the strength of a link for the Schulze method (necessary for tie-breaking of the links); Removed "no_reverse_beat_path" option |
| 2014-04-14 |
jbe |
Generalized comment on "defeat_strength" function |
| 2014-04-14 |
jbe |
Separate configuration options for "defeat_strength" and "tie_breaking" |
| 2014-04-10 |
jbe |
Work on configuration of complexity of counting of the votes (extent of tie-breaking): |
| 2014-04-05 |
jbe |
Added tag v3.0.1 for changeset 044a2b65c707 |
| 2014-04-05 |
jbe |
Added tag v2.2.6 for changeset eaba9174d117 |
| 2014-04-05 |
jbe |
Merged from v2.2.6: Marked "no_reverse_beat_path" and "no_multistage_majority" as experimental; Disabled "no_reverse_beat_path" by defaultv3.0.1 |
| 2014-04-05 |
jbe |
Marked "no_reverse_beat_path" and "no_multistage_majority" as experimental; Disabled "no_reverse_beat_path" by defaultv2.2.6 |
| 2014-03-26 |
jbe |
Bugfix for battle data reconstruction in update script |
| 2014-03-26 |
jbe |
Reconstruct battle data in update script to avoid future data loss when executing "clean_issue" to delete voting data |
| 2014-03-26 |
jbe |
Added update script to introduce "first_preference_votes" |
| 2014-03-26 |
jbe |
When marking first preferences, use JOIN via "initiative" table due to missing index on "vote"."issue_id" |
| 2014-03-26 |
jbe |
Calculation of "first_preference" votes |
| 2014-01-31 |
jbe |
Added tag v3.0.0 for changeset 399dc1a86398 |
| 2014-01-31 |
jbe |
Marked version as v3.0.0v3.0.0 |
| 2013-12-23 |
jbe |
"schulze_rank" includes tie-breaking by "id" |
| 2013-10-14 |
jbe |
Proportional Runoff for issues both based on single areas and single units |
| 2013-10-14 |
jbe |
Secondary sorting key for issues in admission phase |
| 2013-10-14 |
jbe |
core.sql: Removed "order_in_open_states" |
| 2013-10-14 |
jbe |
lf_update_issue_order.c: Replaced occurences of "suggestion" with "issue" |
| 2013-10-14 |
jbe |
Removed algorithm to calculate "order_in_open_states" |
| 2013-10-14 |
jbe |
Added TODO regarding a bug in lf_update_issue_order.c |
| 2013-10-13 |
jbe |
lf_update_issue_order.c: Insert "issue_order" rows for all issues in the area |
| 2013-10-13 |
jbe |
Fixed syntax error in SQL command in lf_update_issue_order.c |
| 2013-10-12 |
jbe |
Improved comments/debug output in lf_update_issue_order.c |
| 2013-10-12 |
jbe |
lf_update_issue_order deletes stale entries in "issue_order" that may arise due to missing referential integrity |
| 2013-10-12 |
jbe |
Remove referential integrity from "issue_order" table to avoid performance/locking issues |
| 2013-10-11 |
jbe |
Algorithm to write "issue_order"."order_in_open_states" |
| 2013-10-11 |
jbe |
New table "issue_order" for ordering fields to avoid a bottleneck with locking |
| 2013-10-11 |
jbe |
Added helper view "open_issues_ordered_with_minimum_position" for lf_update_issue_order.c |
| 2013-10-11 |
jbe |
Update script to v2.2.6 |
| 2013-10-11 |
jbe |
Always delete ordering ranks of issues (lf_update_issue_order.c) |
| 2013-10-11 |
jbe |
Calculation of "order_in_admission_state" |
| 2013-10-10 |
jbe |
Adjusted indentation of "issue" field comments in source code |
| 2013-10-10 |
jbe |
Work on new issue sorting algorithm |
| 2013-08-12 |
jbe |
Added tag v2.2.5 for changeset 992ec266356d |
| 2013-08-11 |
jbe |
Added notice regarding PostgreSQL 9.1 requirement to update scriptv2.2.5 |
| 2013-08-11 |
jbe |
Added column "admin_notice" to "issue" table, and value 'canceled_by_admin' to "issue_state" type |
| 2013-07-14 |
jbe |
Added tag v2.2.4 for changeset ae69cf82c05f |
| 2013-04-20 |
jbe |
Added support for delegation checks and login recovery; Removed unnecessary join in event viewsv2.2.4 |
| 2013-03-23 |
jbe |
Added tag v2.2.3 for changeset e474e9e1240a |
| 2013-03-23 |
jbe |
Code cleanup regarding temporary storage of session/transaction data to disable protection triggersv2.2.3 |
| 2013-03-22 |
jbe |
Added tag v2.2.2 for changeset 1c991490f075 |
| 2013-03-22 |
jbe |
Fixed an error, which occurred when deleting votes from voters, which lost their voting right during voting phasev2.2.2 |
| 2013-03-18 |
jbe |
Removed excessive space characters in lf_update_suggestion_order.c |
| 2013-03-18 |
jbe |
Added tag v2.2.1 for changeset 0f5841ef67c6 |
| 2013-03-18 |
jbe |
Updated README file to include information on lf_update_suggestion_orderv2.2.1 |
| 2013-03-18 |
jbe |
Enable compiler optimization flags in Makefile |
| 2013-03-18 |
jbe |
Bugfix regarding "proportional_order" of suggestions: |
| 2013-03-18 |
jbe |
Improved log output of lf_update_suggestion_order |
| 2013-03-18 |
jbe |
More verbose logging in lf_update_suggestion_order.c |
| 2013-03-17 |
jbe |
Added colon in comment in lf_update.c and lf_update_suggestion_order.c |
| 2013-03-17 |
jbe |
Optional logging in "lf_update_suggestion_order" |
| 2013-03-17 |
jbe |
Fixed bug in while loop of "loser" function of lf_update_suggestion_order.c, that has been introduced in last commit |
| 2013-03-17 |
jbe |
Added comments to lf_update_suggestion_order.c |
| 2013-03-17 |
jbe |
For suggestions without individual rankings, set "proportional_order" to zero instead of NULL |
| 2013-03-17 |
jbe |
Bugfix in "lf_update_suggestion_order" related to floating point error workaround |
| 2013-03-17 |
jbe |
Bugfix: Numerical ordering of suggestion_id in "lf_update_suggestion_order" |
| 2013-03-17 |
jbe |
In "lf_update_suggestion_order" take ballot weight into account |
| 2013-03-17 |
jbe |
Bugfix in "lf_update_suggestion_order": Set candidate_count to zero, also in cases where no tuples are returned |
| 2013-03-17 |
jbe |
Fixed errors in function "process_initiative" of "lf_update_suggestion_order", which caused memory access errors |
| 2013-03-17 |
jbe |
Bugfix in function "process_initiative" of "lf_update_suggestion_order": Reset old_member_id to NULL |
| 2013-03-17 |
jbe |
Added "lf_update_suggestion_order" to clean taget of makefile |
| 2013-03-17 |
jbe |
Removed unused variable in "lf_update_suggestion_order" |
| 2013-03-17 |
jbe |
Help output of "lf_update" and "lf_update_suggestion_order" either to stdout or stderr, depending on invocation |
| 2013-03-17 |
jbe |
Include "final" flag in debug output of "lf_update_suggestion_order" |
| 2013-03-17 |
jbe |
Update script to v2.2.1 |
| 2013-03-17 |
jbe |
Write "final_suggestion_order_calculated" flag in "lf_update_suggestion_order" |
| 2013-03-17 |
jbe |
Write ranks to database in "lf_update_suggestion_order" |
| 2013-03-17 |
jbe |
Handle out-of-memory errors in "lf_update" when escaping string literals |
| 2013-03-17 |
jbe |
Calculation of ranks in "lf_update_suggestion_order" |
| 2013-03-16 |
jbe |
Code cleanup in "lf_update_suggestion_order" (own block for preparation of the ballot data) |
| 2013-03-16 |
jbe |
Free memory for candidate and ballot structure in "lf_update_suggestion_order" |
| 2013-03-16 |
jbe |
Extended "lf_update_suggestion_order" to create a candidate structure |
| 2013-03-16 |
jbe |
Support for proportional ordering of suggestions in core.sql; Begin of work on "lf_update_suggestion_order" (a second background job for sorting suggestions based on a proportional preferential voting system) |
| 2013-03-10 |
jbe |
Added tag v2.2.0 for changeset 49c25dbc27bc |
| 2013-03-10 |
jbe |
Added reminder to make backups before installing updatesv2.2.0 |
| 2013-03-09 |
jbe |
Bugfix for calculation of harmonic_weight, when there are initiatives without supporters |
| 2013-03-09 |
jbe |
Updated LICENSE file |
| 2013-02-21 |
jbe |
Execute update script from v2.1.0 to v2.2.0 in isolation level REPEATABLE READ |
| 2013-02-21 |
jbe |
Set harmonic_weight for all issues in update script to v2.2.0 |
| 2013-02-21 |
jbe |
Compatibility for PostgreSQL 8.4 in lf_update.c |
| 2013-02-21 |
jbe |
Added comments for functions "require_transaction_isolation"() and "dont_require_transaction_isolation"() |
| 2013-02-21 |
jbe |
Changed indentation in "check_issue" function code |
| 2013-02-21 |
jbe |
Removed unnecessary code, because multiple phase changes at once are no longer possible |
| 2013-02-21 |
jbe |
Write "NOW()" as "now()" |
| 2013-02-21 |
jbe |
Code formatting of constraint "valid_state" in table "issue" |
| 2013-02-21 |
jbe |
Update script to v2.2.0 |
| 2013-02-21 |
jbe |
Removed setting of "ranks_available" column in function "clean_issue" |
| 2013-02-20 |
jbe |
Removed deprecated timeline views |
| 2013-02-20 |
jbe |
Cleanup of new code for allowing "lf_update" to run without extensive locking |
| 2013-02-19 |
jbe |
Removed debug code in lf_update.c |
| 2013-02-19 |
jbe |
Use different transaction isolation levels in "lf_update" program |
| 2013-02-15 |
jbe |
Completely removed table locking in favor of transaction isolation requirements |
| 2013-02-15 |
jbe |
Bugfixes for new system to allow the background job (lf_update) run without intensive locking |
| 2013-02-14 |
jbe |
Work on new system to allow the background job (lf_update) run without intensive locking (incomplete yet) |
| 2013-02-11 |
jbe |
Removed locking system |
| 2013-02-10 |
jbe |
Added comment in "clean_issue" function |
| 2013-02-10 |
jbe |
Stub (no implementation yet) for "phase_finished" field, allowing calculations to take more time without database locking |
| 2013-02-10 |
jbe |
Correct index usage when calculating "harmonic_weight" |
| 2013-02-10 |
jbe |
merge |
| 2013-02-10 |
jbe |
Bugfix regarding index usage (speeds up lf_update) |
| 2013-02-10 |
jbe |
Removed update script to v2.1.1 due to upcoming major changes |
| 2013-02-09 |
jbe |
Removed "harmonic_weight" for suggestions, because another proportional ranking algorithm is needed there |
| 2013-02-08 |
jbe |
Calculate "harmonc_weight" after all other calculations in an issue (as calculation depends on the "admitted" flag now) |
| 2013-02-08 |
jbe |
Require "satisfied" support for "admitted" initiatives when calculating "harmonic_weight" |
| 2013-02-08 |
jbe |
Calculate "harmonic_weight" to be used as a secondary sorting key, while the "admitted" flag shall be used as the primary sorting key for initiatives |
| 2013-02-02 |
jbe |
Bugfix in view "remaining_harmonic_suggestion_weight_summands" |
| 2013-02-02 |
jbe |
Bugfix in view "remaining_harmonic_opinion_weight" |
| 2013-02-02 |
jbe |
Count non-fulfilled suggestions with positive opinion and fulfilled suggestions with negative opinion for "harmonic_weight" of suggestions |
| 2013-02-02 |
jbe |
Set "harmonic_weight" to zero instead of null, where there are no supporters |
| 2013-02-01 |
jbe |
Update script for "harmonic_weight" feature |
| 2013-02-01 |
jbe |
Minor fix in comment |
| 2013-02-01 |
jbe |
Changed rounding behaviour for "harmonic_weight" |
| 2013-02-01 |
jbe |
Added "harmonic_weight" for suggestions; Bugfix in function "set_harmonic_initiative_weights" (clear weights prior calculation) |
| 2013-02-01 |
jbe |
Removed debug notice in function "set_harmonic_initiative_weights" |
| 2013-02-01 |
jbe |
"harmonic_weight" for initiatives |
| 2012-10-15 |
jbe |
Added tag v2.1.0 for changeset 5c98265b39a0 |
| 2012-10-06 |
jbe |
Added missing DROP FUNCTION "vote_ratio" in update scriptsv2.1.0 |
| 2012-10-05 |
jbe |
Merged fix from v2.0.12: Removed unwanted (and broken) tie-breaking by approval rate |
| 2012-10-05 |
jbe |
Added tag v2.0.12 for changeset a839e7efde9f |
| 2012-10-05 |
jbe |
Removed unwanted (and broken) tie-breaking by approval ratev2.0.12 |
| 2012-09-30 |
jbe |
Removed broken tie-breaking implementation |
| 2012-09-30 |
jbe |
Added TODO for broken implementation of tie-breaking |
| 2012-09-29 |
jbe |
Better tie-breaking |
| 2012-09-25 |
jbe |
merge: Switched order of row-level and table-level member locking |
| 2012-09-25 |
jbe |
Switched order of row-level and table-level member locking |
| 2012-09-25 |
jbe |
merge: In function "lock_issue"("issue"."id"): Instead of accquiring a table-level EXCLUSIVE lock, use a table-level SHARE lock in combination with row-level SHARE locks |
| 2012-09-25 |
jbe |
In function "lock_issue"("issue"."id"): Instead of accquiring a table-level EXCLUSIVE lock, use a table-level SHARE lock in combination with row-level share locks |
| 2012-09-25 |
jbe |
Different locking levels and different locking order in function "lock_issue"("issue"."id") to avoid deadlocks |
| 2012-09-24 |
jbe |
Use SHARE MODE table locks in function "lock_issue"("issue"."id") for tables neither referenced nor changed |
| 2012-09-13 |
jbe |
Use EXCLUSIVE MODE table locks in function "lock_issue"("issue"."id") |
| 2012-08-26 |
jbe |
Correctly transform existing "contingent" entries when updating to v2.1.0 |
| 2012-08-25 |
jbe |
Split contingent into polling and non-polling contingent |
| 2012-08-20 |
jbe |
No "issue_quorum" for polling policies |
| 2012-08-20 |
jbe |
Issues may have an admission_time set to NULL |
| 2012-08-19 |
jbe |
Modified function "forbid_changes_on_closed_issue_trigger" to allow voting comments to be changed after voting has finished |
| 2012-08-19 |
jbe |
Updated comments for polling mode in core.sql and core-update.v2.0.11-v2.1.0.sql |
| 2012-08-19 |
jbe |
Changed order of "close_voting" and "clean_issue" functions in update/core-update.v2.0.11-v2.1.0.sql |
| 2012-08-19 |
jbe |
Commented update/core-update.v2.0.11-v2.1.0.sql |
| 2012-08-19 |
jbe |
Deprecated old API tables in update script update/core-update.v2.0.11-v2.1.0.sql |
| 2012-08-19 |
jbe |
Moved voting comment to table "direct_voter" |
| 2012-08-19 |
jbe |
"non_voter" deletes "direct_voter" and vice versa |
| 2012-08-19 |
jbe |
Included changed comment on function "delete_private_data"() in core-update.v2.0.11-v2.1.0.sql |
| 2012-08-19 |
jbe |
Removed preliminary API tables for upcoming release (will be included later) |
| 2012-08-15 |
jbe |
URL for registered (web) API clients |
| 2012-08-15 |
jbe |
Unique "client_identifier" for "registered_client", No foreign key in table "authorized_client" |
| 2012-08-15 |
jbe |
Work on tables for OAuth2 |
| 2012-08-10 |
jbe |
Included old API tables maked as "deprecated" to allow testing with alpha api and preliminary authorization interface after core update to v2.1 |
| 2012-08-10 |
jbe |
Marked API tables as preliminary |
| 2012-08-10 |
jbe |
Added field "code_grant_multiple" to "api_client" |
| 2012-08-09 |
jbe |
Renamed "token_grant" to "implicit_grant" and fixed comments |
| 2012-08-09 |
jbe |
Notice in README file about "delete_private_data"() function |
| 2012-08-09 |
jbe |
Hint in function "delete_private_data" for cases where different data shall be deleted |
| 2012-08-09 |
jbe |
Changed comments in table "api_client" to specify that certain values are maximum values |
| 2012-08-09 |
jbe |
Work on OAuth2 |
| 2012-08-08 |
jbe |
Removed "parallel_access" flag from API tables; Copy access_level and validity_period to table "api_access" |
| 2012-08-08 |
jbe |
Added "parallel_access" and "old_refresh_token" to API tables |
| 2012-08-08 |
jbe |
API client name not unique; Use OAuth2 client identifier as redirection endpoint |
| 2012-08-08 |
jbe |
Work on OAuth 2.0 authorization support |
| 2012-08-08 |
jbe |
API system clients and redundancy in API access table |
| 2012-08-08 |
jbe |
Draft for OAuth 2.0 authorization support |
| 2012-08-07 |
jbe |
Changed Makefile: Placed argument for the linked library after the source file that uses its symbols |
| 2012-07-15 |
jbe |
For "polling" policies "admission_time" is always NULL |
| 2012-07-15 |
jbe |
Added update/core-update.v2.0.11-v2.1.0.sql |
| 2012-07-15 |
jbe |
Polling mode |
| 2012-07-15 |
jbe |
Policies with "free_timing" |
| 2012-07-15 |
jbe |
Removed "issue_comment" |
| 2012-06-20 |
jbe |
Updated LICENSE file |
| 2012-06-20 |
jbe |
Added tag v2.0.11 for changeset e818f83e133b |
| 2012-06-20 |
jbe |
Added update script from v2.0.10 to v2.0.11v2.0.11 |
| 2012-06-20 |
jbe |
Simulation of default delegation in functions "delegation_chain" and "delegation_info" |
| 2012-06-15 |
jbe |
Added tag v2.0.10 for changeset 389200fd973d |
| 2012-05-20 |
jbe |
Added field "participating_member_id" to result of "delegation_info" functionv2.0.10 |
| 2012-05-15 |
jbe |
Added tag v2.0.9 for changeset 5ee7eed2f5b0 |
| 2012-05-15 |
jbe |
Updated README file, noting that data import after updating has to be done as database superuserv2.0.9 |
| 2012-05-15 |
jbe |
Allow "calculate_ranks" to work properly, even if there was a previous counting of votes (due to manual reset of issue state) |
| 2012-05-14 |
jbe |
Bugfix in core-update.v1.4.0-v2.0.0.sql: Explicitly drop NOT NULL constraint of columns winning/losing_initiative_id |
| 2012-05-12 |
jbe |
Bugfix in view "unit_member_count" |
| 2012-05-11 |
jbe |
Function "delegation_info": Do not set "other_trustee_id" when overriden by previous participation |
| 2012-05-10 |
jbe |
Backported fix of future version to update script to v2.0.0 to be able to include unused invite codes in member table |
| 2012-05-10 |
jbe |
Fixed update script from v1.4.0 to v2.0.0: Keep unused invite codes |
| 2012-05-10 |
jbe |
Update script to v2.0.9 |
| 2012-05-10 |
jbe |
Comments on delegation information functions |
| 2012-05-10 |
jbe |
Support closed issues in "delegation_chain" function; Work on "delegation_info" function |
| 2012-05-10 |
jbe |
Function "delegation_chain" returns unknown participation for other members during voting |
| 2012-05-10 |
jbe |
New function "delegation_info" |
| 2012-03-15 |
jbe |
Added tag v2.0.8 for changeset fefc15eb747b |
| 2012-03-15 |
jbe |
Bugfix: Delete member fields "lang", "notify_level" and "formatting_engine" in function "delete_private_data"; Update script to v2.0.8v2.0.8 |
| 2012-03-13 |
jbe |
Added tag v2.0.7 for changeset 4346d48b1780 |
| 2012-03-13 |
jbe |
Update script to v2.0.7v2.0.7 |
| 2012-03-13 |
jbe |
Delete sessions: |
| 2012-03-11 |
jbe |
Added tag v2.0.6 for changeset f022016f6748 |
| 2012-03-11 |
jbe |
Update script to v2.0.6v2.0.6 |
| 2012-03-10 |
jbe |
Added column "invite_code_expiry" to table "member" |
| 2012-03-10 |
jbe |
Bugfix in function "write_event_initiative_revoked_trigger": Set "draft_id" in "event" table |
| 2012-03-05 |
jbe |
Bugfix: Do not write history entries for non-activated members |
| 2012-03-05 |
jbe |
Added tag v2.0.5 for changeset 6e273a6ed235 |
| 2012-03-05 |
jbe |
Delete "admin_comment" in function "delete_private_data"; Update script for v2.0.5v2.0.5 |
| 2012-03-01 |
jbe |
Added tag v2.0.4 for changeset 10a231cfd585 |
| 2012-02-28 |
jbe |
Delete non-activated members in function "delete_private_data"v2.0.4 |
| 2012-02-28 |
jbe |
No generic NOT NULL constraints on columns "name" and "notify_level" in table "member" |
| 2012-02-25 |
jbe |
Update script for v2.0.4 |
| 2012-02-25 |
jbe |
Added index on "event"."occurrence" |
| 2012-02-25 |
jbe |
Changes in event system: |
| 2012-02-25 |
jbe |
Added column "lang" to table "member" |
| 2012-02-25 |
jbe |
Re-added "session" table to the core |
| 2012-02-22 |
jbe |
Added tag v2.0.3 for changeset 2571bb3bdf56 |
| 2012-02-22 |
jbe |
Update script to v2.0.3v2.0.3 |
| 2012-02-22 |
jbe |
Change in "rank" order of admitted initiatives: |
| 2012-02-22 |
jbe |
Bugfix: Set "eligible" to FALSE for all non-eligible admitted initiatives |
| 2012-02-17 |
jbe |
Added tag v2.0.2 for changeset 919d16c8e8e3 |
| 2012-02-17 |
jbe |
Added new column "authentication to table "member"; Added update script to v2.0.2v2.0.2 |
| 2012-01-29 |
jbe |
Added tag v2.0.1 for changeset c23b288fd771 |
| 2012-01-28 |
jbe |
Fixed comment on column "unit"."active"; Cleanup and documentation of update script from v2.0.0 to v2.0.1v2.0.1 |
| 2012-01-21 |
jbe |
Update script from v2.0.0 to v2.0.1 |
| 2011-12-27 |
jbe |
Minor fixes in initiative comments |
| 2011-11-14 |
jbe |
merge |
| 2011-10-23 |
Lars Winterfeld |
fix init.sql |
| 2011-11-14 |
jbe |
Clarified comments, added warnings in comments about correct usage of indicies |
| 2011-11-14 |
jbe |
Use "invite_code" column instead of "invite_code" table in function "delete_private_data" |
| 2011-10-24 |
jbe |
Bugfix in old update scripts from v1.3.1 to v1.4.0: Set default of "issue"."state" to 'admission' |
| 2011-10-08 |
jbe |
Added column "draft_id" to table "direct_supporter_snapshot" |
| 2011-10-08 |
jbe |
Added table "unit_setting" |
| 2011-10-06 |
jbe |
Changed README file to explicitly explain that lf_update needs to be called via cron or similar |
| 2011-09-11 |
jbe |
merged retagging of v1.4.0 |
| 2011-09-11 |
jbe |
Added tag v1.4.0 for changeset 859d82b14c38 |
| 2011-09-11 |
jbe |
Added missing core-update.v1.4.0_rc4-v1.4.0.sql file for v1.4.0v1.4.0 |
| 2011-09-11 |
jbe |
Added tag v2.0.0 for changeset e8c6035b03f3 |
| 2011-09-10 |
jbe |
mergev2.0.0 |
| 2011-09-10 |
jbe |
Added tag v1.4.0 for changeset d53e276f32ba |
| 2011-09-10 |
jbe |
Changed version 1.4.0_rc4 to 1.4.0 in core.sql |
| 2011-09-10 |
jbe |
v1.4.0_rc4 gets v1.4.0 |
| 2011-09-10 |
jbe |
Renamed v1.5.0 to v2.0.0 |
| 2011-09-04 |
jbe |
Created new demo.sql with basic settings and units and areas for an imaginary "Solar System" installation |
| 2011-09-04 |
jbe |
Renamed demo.sql to test.sql |
| 2011-07-30 |
jbe |
UNIQUE constraint for "member_application"."key" |
| 2011-07-30 |
jbe |
Added missing function "calculate_member_counts" to core-update.v1.4.0_rc4-v1.5.0_rc1.sql |
| 2011-07-30 |
jbe |
Renamed core-update.v1.4.0-v1.5.0.sql to core-update.v1.4.0_rc4-v1.5.0_rc1.sql; Set version info to v1.5.0_rc1 |
| 2011-07-30 |
jbe |
Added update script from v1.3.1 to v1.4.0_rc4 |
| 2011-07-30 |
jbe |
Bugfixes in core-update.v1.4.0-v1.5.0.sql |
| 2011-07-29 |
jbe |
New table "member_application" for API |
| 2011-07-29 |
jbe |
Member deactivation based on last_activity instead of last_login |
| 2011-07-29 |
jbe |
Dropped session table (it is up to frontends to have their own session store) |
| 2011-07-29 |
jbe |
Removed trigger "set_activated_timestamp"; Updated update script |
| 2011-07-06 |
jbe |
Removed table "invite_code" (invite codes are now stored in "member" table) |
| 2011-06-08 |
jbe |
Update script to v1.5.0: Drop contraints on table "initiative" before changing columns |
| 2011-06-08 |
jbe |
Update script to v1.5.0: Drop "battle_view" before modifying "initiative" table |
| 2011-06-08 |
jbe |
Set voting results for finished issues in update script to v1.5.0 |
| 2011-06-08 |
jbe |
First version of update script from v1.4.0 to v1.5.0 |
| 2011-06-08 |
jbe |
Added constraint "eligible_at_first_rank_is_winner" to "initiative" table |
| 2011-06-07 |
jbe |
Added constraints on table "initiative"; Added comment for column "initiative"."rank" |
| 2011-06-07 |
jbe |
Ordering for final rank: 1st winner, 2nd initiatives fultilling direct AND indirect majority, rest ordered by schulze_rank and id |
| 2011-06-07 |
jbe |
Added final "rank" column to table "initiative", which contains a unique order of all admitted initiatives |
| 2011-06-07 |
jbe |
Bugfix: Set winner to FALSE for all non-winning admitted initiatives |
| 2011-06-07 |
jbe |
Simplify one UPDATE in function "calculate_ranks" |
| 2011-06-07 |
jbe |
Save Schulze rank of status quo in "issue" table |
| 2011-06-07 |
jbe |
Complete removal of autoreject feature |
| 2011-06-07 |
jbe |
Fixed comment on column "issue"."half_frozen" |
| 2011-06-05 |
jbe |
Allow to require BOTH direct AND indirect (super)majorities in combination |
| 2011-06-05 |
jbe |
merge |
| 2011-06-05 |
jbe |
Added tag v1.4.0_rc4 for changeset 1be788313b84 |
| 2011-06-05 |
jbe |
Added update scripts from v1.4.0_rc2 to _rc3 and from _rc3 to _rc4v1.4.0_rc4 |
| 2011-06-05 |
jbe |
Backported fixes in "clean_issue" (deleting "issue_comment" and "voting_comment" entries) to v1.4.0_rcX |
| 2011-06-04 |
jbe |
Delete entries from "issue_comment" and "voting_comment" tables in function "clean_issue" |
| 2011-06-04 |
jbe |
Delete entries from "issue_autoreject" table in function "clean_issue" |
| 2011-06-04 |
jbe |
Added reference from "suggestion" to "draft_id"; Changed reference from "supporter" to "draft_id" to DELETE NO ACTION |
| 2011-06-04 |
jbe |
Wiki formatting for member statements and suggestions |
| 2011-06-04 |
jbe |
Changed comments on some columns |
| 2011-06-04 |
jbe |
Do not ignore the "policy"."no_multistage_majority" flag: It does not affect the winner but affects the "initiative"."eligible" flag |
| 2011-06-03 |
jbe |
Ignore "policy"."no_multistage_majority", if "policy"."majority_indirect" is set |
| 2011-06-03 |
jbe |
Added configuration option to allow indirect supermajority requirements |
| 2011-06-03 |
jbe |
Configurable supermajority requirements related to "disqualification" of initiatives for stability reasons |
| 2011-06-02 |
jbe |
merge |
| 2011-06-02 |
jbe |
Backported bugfixes in functions "close_voting" and "clean_issue" to v1.4.0_rcX |
| 2011-06-02 |
jbe |
Bugfix in function "clean_issue": Temporarily update "issue"."state" to avoid constraint violation |
| 2011-06-02 |
jbe |
Bugfix in "close_voting": Only add autoreject votes for admitted issues |
| 2011-06-02 |
jbe |
Dropped backwards compatiblity functions "array_init_string" and "square_matrix_init_string" |
| 2011-06-02 |
jbe |
Placed issue based autoreject feature inside own relation "issue_autoreject" to allow autoreject without interest |
| 2011-06-02 |
jbe |
Merged bugfix in function "close_voting": Create autoreject ballots only for members with "voting_right" in the unit |
| 2011-06-02 |
jbe |
Added tag v1.4.0_rc3 for changeset 0fa3c4739ca7 |
| 2011-06-02 |
jbe |
Bugfix in function "close_voting": Create autoreject ballots only for members with "voting_right" in the unitv1.4.0_rc3 |
| 2011-06-02 |
jbe |
Removed vote_now/vote_later feature |
| 2011-06-01 |
jbe |
Added columns "majority_positive" and "majority_non_negative" to table "policy", |
| 2011-06-01 |
jbe |
Use an improved definition for "disqualified" initiatives |
| 2011-05-29 |
jbe |
Removed unneccessary JOIN in function "calculate_ranks" |
| 2011-05-29 |
jbe |
Bugfix in function "calculate_ranks": Use simple majorities for disqualification |
| 2011-05-29 |
jbe |
Always ensure stable voting results by disqualifying certain initiatives, and bugfix related to setting "issue_state" in "calculate_ranks" |
| 2011-05-28 |
jbe |
Fixed syntax error |
| 2011-05-28 |
jbe |
Added column "majority_indirect" to table "policy" and changed function "close_voting" to respect indirect (super)majorities when configured in policy |
| 2011-05-28 |
jbe |
Minor code-cleanup in calculation of "promising" attribute in function "close_voting" |
| 2011-05-25 |
jbe |
Changed definition/behaviour of "promising" attribute |
| 2011-05-24 |
jbe |
Added new column "promising" to table "initiative"; Simplified tie-breaking |
| 2011-05-24 |
jbe |
Backed out changeset 3d5e38ea2fab due to incomplete commit message |
| 2011-05-24 |
jbe |
Added new column "promising" to table "initiative" |
| 2011-05-24 |
jbe |
Merged bugfix in function "close_voting" |
| 2011-05-24 |
jbe |
Added tag v1.4.0_rc2 for changeset 07cfc7c1ce3f |
| 2011-05-24 |
jbe |
Bugfix in function "close_voting" related to selection of "area_id" and "unit_id"v1.4.0_rc2 |
| 2011-05-24 |
jbe |
Set "rank" for all "admitted" initiatives after voting is finished; Additional columns in "initiative" table store voting result information |
| 2011-05-24 |
jbe |
Bugfix in calculation of minimal rank of initiatives having a majority in function "calculate_ranks" |
| 2011-05-24 |
jbe |
Implementation of Schulze's Supermajority Requirements |
| 2011-03-13 |
jbe |
Added tag v1.4.0_rc1 for changeset 0144b703b261 |
| 2011-03-13 |
jbe |
Modified update script to v1.4.0_rc1: Relate all invite codes and all members to default unit with id=1v1.4.0_rc1 |
| 2011-03-10 |
jbe |
Bugfix in function "delegation_chain" (with 4 args) |
| 2011-03-07 |
jbe |
Changed comments in update script to v1.4.0_rc1 |
| 2011-03-07 |
jbe |
Bugfix in function "freeze_after_snapshot"; Simplified function "close_voting" |
| 2011-03-07 |
jbe |
Included update instructions in README file |
| 2011-03-07 |
jbe |
Removed update scripts to old beta versions |
| 2011-03-07 |
jbe |
Reconstructing old events in v1.4.0_rc1 update script |
| 2011-03-07 |
jbe |
Code cleanup in update script: Include INSERT into "invite_code_unit" in transaction, Grouped UPDATE "issue" statements |
| 2011-03-07 |
jbe |
Fixed file name of SQL update script (v1.3.1(!) to v1.4.0_rc1) |
| 2011-03-07 |
jbe |
Added SQL update script from v1.3.0 to v1.4.0_rc1 |
| 2011-03-07 |
jbe |
Added comments for columns of "event" table |
| 2011-03-05 |
jbe |
Work on event and notification system; Added more "issue_state"s; Replaced "ignored_issue" table; Removal of sessions in "delete_member" function |
| 2011-03-04 |
jbe |
Column "revoked_by_member_id"; Implemented event system |
| 2011-03-03 |
jbe |
Work on new features; Slight change of behaviour regarding revocation of initiatives |
| 2011-02-07 |
jbe |
Merged v1.3.1 with unit extension |
| 2011-02-05 |
jbe |
Added tag v1.3.1 for changeset ea4928ccc8eb |
| 2011-02-05 |
jbe |
Updated LICENSE filev1.3.1 |
| 2011-02-05 |
jbe |
Update file: Included last two changes, initialize "locked" using "active" field |
| 2011-02-05 |
jbe |
Race condition fixed in "check_last_login"() |
| 2011-02-05 |
jbe |
Exceptional updating of "last_login_public" in case of account reactivation |
| 2011-01-24 |
jbe |
Introduced "system_setting" table with "member_ttl" setting |
| 2011-01-22 |
jbe |
Introduced "last_login_public" field, which is only updated after each day and does only contain date but not time for privacy reasons |
| 2011-01-04 |
jbe |
Update script added |
| 2011-01-04 |
jbe |
Calling function "delete_member" now sets "locked" field to TRUE |
| 2011-01-04 |
jbe |
Merged addition of new field "locked" into branch containing (organizational) units |
| 2011-01-04 |
jbe |
Added new field "locked" to member, redefined meaning of "active" flag |
| 2010-12-24 |
jbe |
Added comment in line where ISNULL is applied to a row record |
| 2010-12-07 |
jbe |
Introduced (organizational) units |
| 2010-12-06 |
jbe |
Removed unneccessary JOIN in "create_interest_snapshot"(...) |
| 2010-11-08 |
jbe |
Added tag v1.3.0 for changeset fb9688f31740 |
| 2010-10-31 |
jbe |
Corrected "delete_member" and "delete_private_data" functions to refer to "ignored_issue" table instead of non-existing "ignored_voting" table; Delete "ignored_issue" entries in "clean_issue" function as wellv1.3.0 |
| 2010-10-31 |
jbe |
Adjusted file update/core-update.v1.2.9-v1.3.0.sql to match changes in core.sql |
| 2010-10-31 |
jbe |
Removed CREATE LANGUAGE statement at the beginning of core.sql for PostgreSQL 9.0 and higher |
| 2010-10-31 |
jbe |
Comments for columns of table "ignored_issue" changed |
| 2010-10-31 |
jbe |
Removed "auto_support" stub |
| 2010-10-29 |
jbe |
Merged planned changes for version 1.3.0 with latest bugfix for version 1.2.9 |
| 2010-10-26 |
jbe |
Added tag v1.2.9 for changeset e588fdf1676e |
| 2010-10-26 |
jbe |
Bugfix: "autoreject" only taken into account, when member is "active"v1.2.9 |
| 2010-10-18 |
jbe |
Allow to disable delegations (trustee_id = NULL) and to ignore issues |
| 2010-10-17 |
jbe |
Added comment on "supporter"."auto_support" also in update file |
| 2010-10-16 |
jbe |
Backed out changesets dfa8e6a1f1e7, ca13b2614d10, and partly 0758a2e02620 |
| 2010-10-16 |
jbe |
Changed version number to 1.2.9 in core.sql |
| 2010-10-09 |
Daniel Poelzleithner |
don't cause nan values in demo policies |
| 2010-10-08 |
Daniel Poelzleithner |
add usefull index |
| 2010-10-08 |
Daniel Poelzleithner |
better be safe :-) |
| 2010-10-07 |
Daniel Poelzleithner |
implement auto_support and delegation checks |
| 2010-10-04 |
Daniel Poelzleithner |
add test policies |
| 2010-09-19 |
Daniel Poelzleithner |
fix default password. |
| 2010-09-07 |
jbe |
Added tag v1.2.8 for changeset f77c0f3d443c |
| 2010-09-07 |
jbe |
Renamed "delegation_global_truster_id_trustee_id_unique_idx" to "delegation_global_truster_id_unique_idx" in core.sql and update scriptv1.2.8 |
| 2010-09-07 |
jbe |
Fixed unique constraints in table "delegation"; Update script to v1.2.8 |
| 2010-08-30 |
jbe |
Added tag v1.2.7 for changeset dcaa1525c388 |
| 2010-08-30 |
jbe |
Removed unintentionally inserted extra columns in view "global_delegation" in previous commit; Update script from v1.2.5 to v1.2.6 also works with PostgreSQL 8.3 now; Update script from v1.2.6 to v1.2.7 addedv1.2.7 |
| 2010-08-30 |
jbe |
Added tag v1.2.6 for changeset 5745db0b1a34 |
| 2010-08-30 |
jbe |
Removed subqueries which are unneccessary since last bugfix; Update scriptv1.2.6 |
| 2010-08-30 |
jbe |
Important bugfix, affecting correct counting of supporters/votes |
| 2010-08-16 |
jbe |
Added tag v1.2.5 for changeset 72e5356b5454 |
| 2010-08-16 |
jbe |
Improved locking to avoid unneccessary delays and possible deadlocksv1.2.5 |
| 2010-08-15 |
jbe |
Added tag v1.2.4 for changeset bdccc56fb705 |
| 2010-08-15 |
jbe |
lf_update continues on error (but still reports errors)v1.2.4 |
| 2010-07-24 |
jbe |
Added tag v1.2.3 for changeset 1af482e378a1 |
| 2010-07-24 |
jbe |
Added "rendered_draft" table for cachingv1.2.3 |
| 2010-07-20 |
jbe |
Added tag v1.2.2 for changeset 598af132a6f9 |
| 2010-07-20 |
jbe |
Save battle data from calls of "clean_issue"("issue"."id")v1.2.2 |
| 2010-07-19 |
jbe |
Added tag v1.2.1 for changeset fdd1729d7e2a |
| 2010-07-19 |
jbe |
New function clean_issue(issue.id), which deletes all discussion data and votes of an issuev1.2.1 |
| 2010-07-14 |
jbe |
Added tag v1.2.0 for changeset a7ad50614d82 |
| 2010-07-14 |
jbe |
Removed "login" name history; Deletion functions delete more datav1.2.0 |
| 2010-07-08 |
jbe |
Added tag v1.1.0 for changeset b63515611a60 |
| 2010-07-08 |
jbe |
Added column "notify_email_lock_expiry"; Corrected "manual_freeze" commentv1.1.0 |
| 2010-06-28 |
jbe |
Removed column "interest_exists" from table "direct_population_snapshot"; Replaced function "delete_member_data" by function "delete_member" |
| 2010-06-17 |
jbe |
Added tag v1.0.3 for changeset 3fbf9e18ee52 |
| 2010-06-17 |
jbe |
Bugfix: Corrected table for index "delegating_voter_member_id_idx"v1.0.3 |
| 2010-04-21 |
jbe |
Added tag v1.0.2 for changeset c45df7907da6 |
| 2010-04-21 |
jbe |
Bugfix in "delete_private_data"(); Extended "delete_member_data"(...)v1.0.2 |
| 2010-04-20 |
jbe |
Added tag v1.0.1 for changeset 74c985baf082 |
| 2010-04-20 |
jbe |
Function "delete_member_data"(...) deletes outgoing delegationsv1.0.1 |
| 2010-04-15 |
jbe |
Added tag v1.0.0 for changeset 67a2e236fea4 |
| 2010-04-15 |
jbe |
"No operation" update script from beta24 to beta25v1.0.0 |
| 2010-04-15 |
jbe |
New function "delete_member_data"(...); Added missing index for "member_history"; References fixed to restrict updates |
| 2010-03-26 |
jbe |
Added tag beta26 for changeset 1779e2303c08 |
| 2010-03-25 |
jbe |
Fixed wrong version number in update/prepare-beta25-beta26.sqlbeta26 |
| 2010-03-25 |
jbe |
Save timestamps of last login and member deactivation; Deletion of suggestions with attached opinions now possible (on delete cascade) |
| 2010-03-08 |
jbe |
Added tag beta25 for changeset 2b03946cb0c2 |
| 2010-03-08 |
jbe |
lf_export: Use pg_dump and psql instead of createdb to copy databasebeta25 |
| 2010-03-08 |
jbe |
Added tag beta24 for changeset c78ab22c4870 |
| 2010-03-08 |
jbe |
Added missing DELETEs in function "delete_private_data"(); Fixed wrong COMMENT statement for table "member_relation_setting"beta24 |
| 2010-03-04 |
jbe |
Added tag beta23 for changeset c3b72b644cc8 |
| 2010-03-04 |
jbe |
Critical bugfix in function "create_snapshot": Fixed incorrect calculation of opinion count for suggestionsbeta23 |
| 2010-02-21 |
jbe |
Added tag beta22 for changeset 9970f73c1140 |
| 2010-02-21 |
jbe |
Bugfix: Added missing states in "valid_state" constraint of table "issue"beta22 |
| 2010-02-21 |
jbe |
Added tag beta21 for changeset 3ccab7349f28 |
| 2010-02-21 |
jbe |
Bug in "forbid_changes_on_closed_issue_trigger"() fixed, which caused errors when closing issues under certain circumstancesbeta21 |
| 2010-02-20 |
jbe |
Added tag beta20 for changeset d386cd067983 |
| 2010-02-20 |
jbe |
Better handling of ties (changes in computation of rankings and final winner in certain cases)beta20 |
| 2010-02-09 |
jbe |
Added tag beta19 for changeset a73ccca7557a |
| 2010-02-09 |
jbe |
View "liquid_feedback_version" returns version "beta19"beta19 |
| 2010-02-06 |
jbe |
SQL update script from beta18: Changed destination version from v1.0.0 to beta19 |
| 2010-02-06 |
jbe |
Added preparation script for update from beta18 |
| 2010-02-06 |
jbe |
Moved core-update files to update directory; Added BEGIN and COMMIT to core-update.beta16-beta17.sql |
| 2010-02-06 |
jbe |
Close issues when verification time elapsed after revoking last initiative |
| 2010-02-06 |
jbe |
Added tables allowing frontends to store member-relation, area, issue and suggestion settings |
| 2010-02-06 |
jbe |
Copy admission_, discussion_, verification_ and voting_time values into issue |
| 2010-02-06 |
jbe |
New snapshot event 'half_freeze' and renamed 'start_of_voting' to 'full_freeze' |
| 2010-02-06 |
jbe |
Triggers ensuring that votes can't be modified by a broken frontend after issues have been frozen |
| 2010-02-06 |
jbe |
Changed version to "beta19-dev"; Changed year in LICENSE to "2009-2010" |
| 2010-01-30 |
jbe |
Tags for beta1 to beta18 added |
| 2010-01-23 |
jbe |
Version beta18beta18 |
| 2010-01-22 |
jbe |
Version beta17beta17 |
| 2010-01-13 |
jbe |
Version beta16beta16 |
| 2010-01-10 |
jbe |
Version beta15beta15 |
| 2010-01-04 |
jbe |
Version beta14beta14 |
| 2010-01-02 |
jbe |
Version beta13beta13 |
| 2010-01-02 |
jbe |
Version beta12beta12 |
| 2009-12-25 |
jbe |
Version beta11beta11 |
| 2009-12-10 |
jbe |
Version beta10beta10 |
| 2009-11-30 |
jbe |
Version beta9beta9 |
| 2009-11-23 |
jbe |
Version beta8beta8 |
| 2009-11-18 |
jbe |
Version beta7beta7 |
| 2009-11-17 |
jbe |
Version beta6beta6 |
| 2009-11-15 |
jbe |
Version beta5beta5 |
| 2009-11-15 |
jbe |
Version beta4beta4 |
| 2009-11-07 |
jbe |
Version beta3beta3 |
| 2009-11-03 |
jbe |
Version beta2beta2 |
| 2009-10-27 |
jbe |
Version beta1beta1 |