liquid_feedback_core

log

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

Impressum / About Us