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