The following is a sparse list of lists. The top level is
made up of table names. The second level is made up of
column names. A column name is only included if I can't
find a specific, complete comment about it (or if I'm not
sure I understand the situation). All tables are listed,
as a check that I haven't missed anything.
I have tried to make up some comments, which are flagged
with "???", _???_, etc.
-r
archive
-- ??? ID of the namespace for the archive
ar_namespace int NOT NULL default '0',
-- ??? Title of the archive
ar_title varchar(255) binary NOT NULL default '',
-- Basic revision stuff, as documented in _???_
ar_comment tinyblob NOT NULL default '',
ar_user int(5) unsigned NOT NULL default '0',
ar_user_text varchar(255) binary NOT NULL,
ar_timestamp char(14) binary NOT NULL default '',
ar_minor_edit tinyint(1) NOT NULL default '0',
-- See ar_text note.
-- ??? - how does the note relate to ar_flag?
ar_flags tinyblob NOT NULL default '',
categorylinks
hitcounter
??? Is hc_id a foreign key for page.page_id?
mw_image
??? Is user_id a foreign key for user.user_id?
??? Is user_name a duplicate if the field in the user table?
imagelinks
??? Is il_from a foreign key for user.user_id?
interwiki
ipblocks
??? Is ipb_user a foreign key for user.user_id?
mw_logging
??? Is log_user a foreign key for user.user_id?
math
objectcache
-- ???
keyname char(255) binary NOT NULL default '',
-- ???
value mediumblob,
-- ??? Expiration time for this cache entry
exptime datetime,
oldimage
oi_name is a foreign key for image.image_name
oi_name varchar(255) binary NOT NULL default '',
??? Are oi_size .. oi_timestamp copied from a row in image?
pagelinks
??? Is pl_from a foreign key for page.page_id?
recentchanges
??? Is rc_comment a duplicate of revision.rev_comment?
??? Is rc_minor a duplicate of revision.rev_minor_edit?
??? Is rc_user a duplicate of revision.rev_user?
??? Is rc_user_text a duplicate of revision.rev_user_text?
??? Is rc_cur_id a foreign key for page.page_id?
??? Is rc_last_oldid a foreign key for revision.rev_id?
??? Is rc_this_oldid a foreign key for revision.rev_id?
searchindex
??? Is si_page a foreign key for page.page_id?
site_stats
text
??? Is old_id a foreign key? For what?
trackbacks
??? None of these are defined.
??? Is tb_page a foreign key for page.page_id?
tb_id integer AUTO_INCREMENT PRIMARY KEY,
tb_page integer REFERENCES page(page_id) ON DELETE
CASCADE,
tb_title varchar(255) NOT NULL,
tb_url varchar(255) NOT NULL,
tb_ex text,
tb_name varchar(255),
user
user_groups
??? Is ug_user a foreign key for user.user_id?
user_newtalk
??? Is user_id a foreign key for user.user_id?
validate
??? None of these are defined.
??? Is val_page a foreign key for page.page_id?
??? Is val_revision a foreign key for revision.rev_id?
??? Is val_user a foreign key for user.user_id?
val_user int(11) NOT NULL default '0',
val_page int(11) unsigned NOT NULL default '0',
val_revision int(11) unsigned NOT NULL default '0',
val_type int(11) unsigned NOT NULL default '0',
val_value int(11) default '0',
val_comment varchar(255) NOT NULL default '',
val_ip varchar(20) NOT NULL default '',
watchlist
??? Is wl_user a foreign key for user.user_id?
??? Is wl_namespace a foreign key for page.page_namespace?
??? Is wl_title a foreign key for page.page_title?
??? What other foreign keys have I missed?
--
http://www.cfcl.com/rdm Rich Morin
http://www.cfcl.com/rdm/resume rdm(a)cfcl.com
http://www.cfcl.com/rdm/weblog +1 650-873-7841
Technical editing and writing, programming, and web development