liquid_feedback_core

log

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

Impressum / About Us