Skip to content

remove bananes when user gets deleted

chandi requested to merge 337-banana-removes into master

Closes https://gitlab.com/foodsharing-dev/issues0/issues/337

This query should get executed once to remove all the existing bananes given by already deleted users

DELETE FROM fs_rating WHERE (SELECT f.deleted_at FROM fs_foodsaver AS f WHERE f.id=rater_id) IS NOT NULL
Edited by Chris Oelmueller

Merge request reports