Jeremy Dunck wrote:
On 10/15/05, Brion Vibber <brion(a)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)