Review workflow for Gallery content

[ensonic]

While it is awesome to see the gallery content grow, it would be good to think about QA here.

As basic feature it would be good to extend the db schema to allow to flag a gallery program. Next step would be a way to review all flagged programs. During the review process they could be un-flagged or marked as hidden.

Hidden programs would not be shown in the gallery. It would be nice to give a reason for hiding, so that the user can 'fix' the programm and reshare. This would require an enum of reasons that point to our "terms of use" so that we don't need to enter untranslatable text messages during review, but can just select from the list, which terns have been violated.

Once we have such a system, we could experiment with review tools that eg. search for bad language, links to suspicious sites, etc and the tool could flag such programs, the reason could be pre-populated even.

Later one we might also add a feature in the UI to give selected users a way to 'report bad programs" in the galery, but here the challenge is to identify users that would use this responsibly (community moderators). Maybe people can apply for this role.