Jeremy Dunck wrote:
I've got a dump of simple loaded.
When revision.rev_delete = 1, is there a way to tell both when the rev was created and when the rev was deleted?
rev_deleted is not yet used, so the only time this will come up is if you manually set the field to 1. :)
Deleted revisions are removed from the revision table and copied to the archive table. The only record of deletion time is in the logging table, and that won't tell you which revision was deleted when.
-- brion vibber (brion @ pobox.com)