Jeremy Dunck wrote:
On 10/15/05, Brion Vibber brion@pobox.com wrote:
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.
So, deleted revs aren't included in dumps at all?
Right.
Deletes are relatively rare (sysop) occurrences, right?
Relatively.
Also, I see through testing that when a revert is done, a new text record is created (as opposed to ref'ing the same text record as the revision being reverted to). Will this be changing?
Using the rollback button or manual reverts? I thought I'd already done this for rollback, but I could be wrong. Manual reverts would require some checking but is doable.
Note that if you're looking at a database imported from an XML dump, that's a totally different matter; at the moment the dump importers aren't smart enough to merge common text entries. (The XML dumps include plain text in order to isolate the public-consumable data from our ever-shifting implementation details.)
-- brion vibber (brion @ pobox.com)