Smart Updates

[dylan-k]

if the user marks a submission as "accepted" or "published" then mark the published work as published, accordingly, note the venue and date of publication, and remove the work from circulation so that it isn't available to be submitted again.

This will need to be accomplished with a series of SQLite Triggers, a tiny few of which are already in place. Next step would be to list out all the triggers to create, to build them and then to test them.