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