On Wed, Mar 23, 2005 at 06:50:51PM +0000, David Gerard wrote:
I understand the 1.5 database schema is considerably
changed from that
of 1.4. Is it finalised? Still susceptible to minor tweaks? Still
susceptible to complete revision?
(I want to play with tools to do things with the SQL database, which
would need the schema written into them.)
There are some schema changes I'd still like to see happen. One
thing I had in mind was changing some tables who have a namespace
and title now and change it into a page_id. For instance
watchlist now has has:
wl_namespace tinyint(2) unsigned NOT NULL default '0',
wl_title varchar(255) binary NOT NULL default '',
That to could be changed to:
wl_page int(8) unsigned NOT NULL,
Same goes for archive, recentchanges, querycache, logging.
Kurt