| age |
author |
description |
| 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 |
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 |
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-07-15 |
jbe |
For "polling" policies "admission_time" is always NULL |
| 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 |
Simulation of default delegation in functions "delegation_chain" and "delegation_info" |
| 2012-05-20 |
jbe |
Added field "participating_member_id" to result of "delegation_info" functionv2.0.10 |
| 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-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 |
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 |
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 |
Delete sessions: |
| 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 |
Delete "admin_comment" in function "delete_private_data"; Update script for v2.0.5v2.0.5 |
| 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 |
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 new column "authentication to table "member"; Added update script to v2.0.2v2.0.2 |
| 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 |
| 2011-12-27 |
jbe |
Minor fixes in initiative comments |
| 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-08 |
jbe |
Added column "draft_id" to table "direct_supporter_snapshot" |
| 2011-10-08 |
jbe |
Added table "unit_setting" |
| 2011-09-10 |
jbe |
mergev2.0.0 |
| 2011-09-10 |
jbe |
Changed version 1.4.0_rc4 to 1.4.0 in core.sql |
| 2011-09-10 |
jbe |
Renamed v1.5.0 to v2.0.0 |
| 2011-07-30 |
jbe |
UNIQUE constraint for "member_application"."key" |
| 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-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 |
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 |
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 |
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 |
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-10 |
jbe |
Bugfix in function "delegation_chain" (with 4 args) |
| 2011-03-07 |
jbe |
Bugfix in function "freeze_after_snapshot"; Simplified function "close_voting" |
| 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 |