Reset Judging Status of a Contest (Phase)

To reset every judging and screening action of a contest, or a contest phase in specific, the following database updates have to be done:

1. Delete the ratings in ProposalRating:

   DELETE FROM xcolab_manuel.xcolab_ProposalRating WHERE contestPhaseId = $id;

2. Reset all the ProposalContestPhaseAttributes:

   SELECT * FROM xcolab_ProposalContestPhaseAttribute WHERE contestPhaseId = $id;

   Then set all rows with FELLOW_ACTION, FELLOW_ACTION_COMMENT, FELLOW_ADVANCEMENT_FROZEN, JUDGE_DECISION, SELECTED_JUDGES to 0 and empty string values

3. If a proposal was advanced already, delete the PROMOTE_DONE attribute and delete the row in Proposal2Phase