Gregory Szorc wrote:
I have a few quick questions about the 1.5 database
schema...
What exactly is the role of the recentchanges table? If I had to take a
stab at it, I would say that it is basically rehash of data already in
the revision and logging tables and it exists purely for performance
improvement reasons.
Pretty much.
Second, I did a fresh install of 1.5.2 this weekend
and chose the
experimental MySQL 5 layout. For curiosity sake, I did a structure
compare to an existing installation (1.5.2 upgraded from 1.4.x). I was
surprised to see that the text table in the fresh install only has 3
fields (old_id, old_text, old_flags) as opposed to the 11 or so that the
existing install has. Is it safe to delete these non-existent fields
from the old database?
Other fields are left over from an upgrade from 1.4 (the 'old' table gets
repurposed for text storage) and are no longer used.
I'm sorry to bother everyone on this list with
this question, but the
database documentation on meta is horribly out of date.
See maintenance/tables.sql for documentation on the schema.
-- brion vibber (brion @
pobox.com)