liquid_feedback_core

log core.sql

age author description
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 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 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-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 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 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-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-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-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 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 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 Improved locking to avoid unneccessary delays and possible deadlocksv1.2.5
2010-08-15 jbe lf_update continues on error (but still reports errors)v1.2.4
2010-07-24 jbe Added "rendered_draft" table for cachingv1.2.3
2010-07-20 jbe Save battle data from calls of "clean_issue"("issue"."id")v1.2.2
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 Removed "login" name history; Deletion functions delete more datav1.2.0
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 Bugfix: Corrected table for index "delegating_voter_member_id_idx"v1.0.3
2010-04-21 jbe Bugfix in "delete_private_data"(); Extended "delete_member_data"(...)v1.0.2
2010-04-20 jbe Function "delete_member_data"(...) deletes outgoing delegationsv1.0.1
2010-04-15 jbe New function "delete_member_data"(...); Added missing index for "member_history"; References fixed to restrict updates
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 missing DELETEs in function "delete_private_data"(); Fixed wrong COMMENT statement for table "member_relation_setting"beta24
2010-03-04 jbe Critical bugfix in function "create_snapshot": Fixed incorrect calculation of opinion count for suggestionsbeta23
2010-02-21 jbe Bugfix: Added missing states in "valid_state" constraint of table "issue"beta22
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 Better handling of ties (changes in computation of rankings and final winner in certain cases)beta20
2010-02-09 jbe View "liquid_feedback_version" returns version "beta19"beta19
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-23 jbe Version beta18beta18
2010-01-22 jbe Version beta17beta17
2010-01-13 jbe Version beta16beta16
2010-01-10 jbe Version beta15beta15

Impressum / About Us