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.)
- d.
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
Kurt Roeckx wrote:
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.
None of these can use page_id as they may refer to pages that don't exist.
-- brion vibber (brion @ pobox.com)
wikitech-l@lists.wikimedia.org