log
graph
tags
branches
changeset
browse
file
diff
annotate
file log
raw
liquid_feedback_core
log core.sql
find changesets by author, revision, files, or words in the commit message
less
more
|
(0)
-300
-100
-50
-30
tip
age
author
description
2017-04-21
jbe
Renamed table "notification_event_sent" to "event_processed"
2017-03-30
jbe
Several changes/additions for upcoming major release
2016-08-18
jbe
New PostgreSQL extension "pgLatLon" for geospatial operations and indexing in LiquidFeedback
2016-05-29
jbe
Work on new issue admission system (replacing current approach of 1st quorum); Added support for geo-tagging and spatial indexing
2016-05-06
jbe
Merged experimental work on alternative mechanism to the first (issue) quorum
2016-05-05
jbe
Require members to be "activated" in order to receive messages/notifications; New views "member_eligible_to_be_notified" and "member_to_notify"
v3.2.2
2016-05-04
jbe
Fixed functions "delete_member" and "delete_private_data" to properly handle NULL constraints of "member" table
2016-05-04
jbe
Exclude locked members as recipients in view "scheduled_notification_to_send"
2016-05-04
jbe
Allow a value of zero as "notification_sample_size" to disable featured initiatives
2016-05-03
jbe
Merged experimental work on alternative mechanism to the first (issue) quorum
2016-04-30
jbe
Fixed accidental PostgreSQL 9.5 dependency (because of UPSERT aka ON CONFLICT clause)
v3.2.1
2016-04-17
jbe
Set column "notification_hour" of "member" table by default to random number
v3.2.0
2016-04-17
jbe
Include column "published" in view "newsletter_to_send" (to make ordering easier)
2016-04-16
jbe
Added comment on function "get_initiatives_for_notification"
2016-04-16
jbe
Added missing quote
2016-04-16
jbe
Added SQL COMMENTs
2016-04-16
jbe
Renamed tables "notification_sent" to "notification_event_sent" and "initiative_notification_sent" to "notification_initiative_sent"
2016-04-05
jbe
Fixed syntax error in "get_initiatives_for_notification"
2016-04-05
jbe
New algorithm for view "scheduled_notification_to_send"; Update "notification_sent" column in "get_initiatives_for_notification" function
2016-04-05
jbe
New column "notification_sent" in "member" table; New view "scheduled_notification_to_send"
2016-04-05
jbe
Exclude revoked initiatives from updated/featured/leading initiatives in notification system
2016-04-04
jbe
Use "supporter_count" instead of "harmonic_weight" to determine leading initiative for notification system
2016-04-04
jbe
Use "recipient_id" instead of "member_id" in function "get_initiatives_for_notification"
2016-04-04
jbe
Revised notification system; Dropped tables "selected_event_seen_by_member" and "event_seen_by_member"
2016-04-03
jbe
Corrected comparison operator in view "newsletter_to_send"
2016-04-03
jbe
Added view "newsletter_to_send"
2016-04-03
jbe
New table "newsletter"
2016-04-03
jbe
Removed NOT NULL constraint for column "last_suggestion_id" in table "initiative_notification_sent" (NULL means that no suggestion existed)
2016-04-03
jbe
Another bugfix in function "get_initiatives_for_notification"
2016-04-03
jbe
Bugfix in function "get_initiatives_for_notification"
less
more
|
(0)
-300
-100
-50
-30
tip
Impressum / About Us