MediaWikiDoc:Schema.doc

Techniques: Software: MediaWiki: Developer Documents: Schema.doc

user_id
integer, primary key, autoincrement
user_name
Usernames must be unique, must not be in the form of an IP address. _Shouldn't_ allow slashes or case conflicts. Spaces are allowed, and are _not_ converted to underscores like titles. (Conflicts?)
user_password
Hash of current password.
user_newpassword
Generated for mail-a-new-password feature
user_email
Note -- email should be restricted, not public info. Same with passwords. ;)
user_options
Newline-separated list of name=value pairs.
user_token
A pseudorandomly generated value that is stored in a cookie when the "remember password" feature is used (previously, a hash of the password was used, but this was vulnerable to cookie-stealing attacks)

cur

Wikipedia "current" articles

cur_id
integer, primary key, autoincrement
cur_namespace
integer index into list of namespaces. See the Namespace class for more details.
cur_title
Title of article (in dbkey form--see Title), without namespace. The combination of namespace,title should be unique in this table.
cur_text
Wikitext of the article.
cur_comment
The summary of the last change.
cur_user
User id who made the last change, or 0 if unknown.
cur_user_text
Name of the user above, or IP address.
cur_timestamp
Time of the last change.
cur_minor_edit
Flag: 0 or 1 is last change was a "minor" edit.
cur_restrictions
Who may or may not edit the article.
cur_counter
Number of times this page has been viewed.
cur_ind_title
Text version of title for fulltext searches.
cur_ind_text
Plaintext version of text for fulltext searches.
cur_is_redirect
1 indicates the article is a redirect.
cur_minor_edit
1 indicates this was a minor edit.
cur_is_new
1 indicates this is the first revision of a new entry.
cur_random
Random value between 0 and 1, used for Special:Randompage

old

Historical versions articles. Most fields correspond to the same fields in "cur"

old_id
old_namespace
old_title
old_text
old_comment
old_user
old_user_text
old_timestamp
old_minor_edit
old_flags
This last is currently unused.

links

Internal links to existing articles

l_from
ID of source article. (currently title, may be changed)
l_to
ID of target article.

brokenlinks

Internal links to non-existent articles

bl_from
ID of source link.
bl_to
Title of target link.

imagelinks

Internal links to images via [[Image:filename]] syntax

il_from
Title of target article.
il_to
Filename of target image.

categorylinks

Track category inclusions

cl_from
corresponds to cur_id of the linking page
cl_to
corresponds to cur_title of the category page
cl_sortkey
the title of the linking page, or an optional override
cl_timestampe
when the link was last added

linkscc

Stores (possibly gzipped) serialized objects with cache arrays to reduce database load slurping up from links and brokenlinks.

lcc_pageid
The ID of the linking page
lcc_cacheobj
A serialized LinkCache object

image

Uploaded images and other files

img_name
Filename.
img_size
File size in bytes.
img_description
Description field given during upload.
img_user
User ID who uploaded the file.
img_user_text
User name who uploaded the file.
img_timestamp
Timestamp when upload took place.

oldimage

Old versions of images stored for potential revert

oi_name
Original filename.
oi_archive_name
Filename of stored old revision; timestamp and exclaimation point prepended to oi_name
oi_size
File size in bytes.
oi_description
Description field given during upload.
oi_user
User ID who uploaded the file.
oi_user_text
User name who uploaded the file.
oi_timestamp
Timestamp when upload took place.

ipblocks

IP addresses and users blocked from editing

ipb_id
Primary key, introduced for privacy.
ipb_address
Blocked IP address in dotted-quad form or user name.
ipb_user
Blocked user ID or 0 for IP blocks.
ipb_by
User ID who made the block.
ipb_reason
Text comment made by blocker.
ipb_timestamp
Creation (or refresh) date in standard YMDHMS form. IP blocks expire automatically.
ipb_auto
Indicates that the IP address was banned because a banned user accessed a page through it. If this is 1, ipb_address will be hidden.

site_stats

Site-wide statistics

ss_row_id
Token for where clauses. There's only one row in this table. At some point we might want to use a date here so we can get stats-by-date.
ss_total_views
Number of total views of all pages.
ss_total_edits
Number of total page edits.
ss_good_articles
Number of "countable" articles.

hitcounter

Stores an ID for every time any article is visited; depending on $wgHitcounterUpdateFreq, it is periodically cleared and the cur_counter column in the cur table updated for the all articles that have been visited.

hc_id
The ID of an article, representing one hit

recentchanges

Will document further when working

watchlist

wl_user
Foreign key -> user_id
wl_namespace
Namespace -> cur_namespace

Note that these should only include even-numbered namespaces for regular pages; associated talk pages (odd numbered namespaces) are folded in.
wl_title
Page title -> cur_title

Note also that the linked page may not exist in page or talk namespace, or at all.

searchindex

Used for MySQL fulltext searching

si_page
The ID of an article
si_title
The title of an article, indexed for searching
si_text
The text of an article, indexed for searching

interwiki

Recognized interwiki link prefixes

iw_prefix
The interwiki prefix, (e.g. "Meatball", or the language prefix "de")
iw_url
The URL of the wiki, with "$1" as a placeholder for an article name
iw_local
A boolean value indicating whether the wiki is in this project (used, for example, to detect redirect loops)

Edit Log

2005-06-13 Transcribed from docs for MediaWiki version 1.4.5