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