liquid_feedback_core: core.sql history

liquid_feedback_core

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