Comment 3 for bug 719843

In terms of the db and backend implementation my immediate thought is to create a new table for deleted (due to modification) reviews so they can stay on record. The table would act pretty much like an audit history table in a normal commercial app db and the 'modified' review would just replace it in the main Reviews table.

This way, if there is any questionable content in any of the earlier reviews and an issue arises later, we still retain a record of everything the user has submitted, just in case. By moving it to a different table we would not be unnecessarily bloating the main reviews table.

A couple of other points:
a. Do we need to limit the number of times a user can modify their review?
b. If a review has been flagged and is awaiting moderation, how do we handle user trying to modify it?
c. Should there be a time limit on how long after submitting the review a user is able to modify it before it is 'locked' for modification?