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