Implement revision system for new revisions
Bob and Forbes have lists of revisions needing to be made. I have written some code that will digest and archive this simple list. Due to connectivity issues, it may be easier for Forbes to push the "GO" button.
#2 Updated by Michael Lee over 13 years ago
Revision system now works on the new archive database. There are 3 tables of interest:
1) revision - this is from the VegBank model which stores the old (and now also the new) values involved in the revision, also tablename, attributename, and primary key value.
2) revisionProject - I'm not sure this is needed, but it groups revisions together in a package of revisions.
3) revisionsQueue - this is a place where pending revisions can be stored (even before the plots are in the database) and then implemented, based on the revision project number. It's possible to include the old value in the field, or you can leave that blank and update the value without worrying about it.