# HG changeset patch # User jbe # Date 1460829384 -7200 # Node ID 48761b189274d18769e6a2a79f3b6db8f318a9b4 # Parent fd330c887a8354e2749090413b1c839d6b944c35 Added comment on function "get_initiatives_for_notification" diff -r fd330c887a83 -r 48761b189274 core.sql --- a/core.sql Sat Apr 16 19:52:19 2016 +0200 +++ b/core.sql Sat Apr 16 19:56:24 2016 +0200 @@ -3288,6 +3288,10 @@ END; $$; +COMMENT ON FUNCTION "get_initiatives_for_notification" + ( "member"."id"%TYPE ) + IS 'Returns rows from view "initiative_for_notification" for a given recipient while updating table "notification_initiative_sent" and columns "notification_counter" and "notification_sent" of "member" table'; + ------------------------------------------------------------------------ diff -r fd330c887a83 -r 48761b189274 update/core-update.v3.1.0-v3.2.0.sql --- a/update/core-update.v3.1.0-v3.2.0.sql Sat Apr 16 19:52:19 2016 +0200 +++ b/update/core-update.v3.1.0-v3.2.0.sql Sat Apr 16 19:56:24 2016 +0200 @@ -636,7 +636,9 @@ END; $$; --- TODO: comment missing +COMMENT ON FUNCTION "get_initiatives_for_notification" + ( "member"."id"%TYPE ) + IS 'Returns rows from view "initiative_for_notification" for a given recipient while updating table "notification_initiative_sent" and columns "notification_counter" and "notification_sent" of "member" table'; CREATE OR REPLACE FUNCTION "delete_member"("member_id_p" "member"."id"%TYPE) RETURNS VOID