content_models
PK
model_id
INT(11)
NN
AK
model_name
VARBINARY(64)
NN
KEY
PRIMARY
KEY
model_name
l10n_cache
PK
lc_lang
VARBINARY(35)
NN
PK
lc_key
VARBINARY(255)
NN
lc_value
MEDIUMBLOB
NN
KEY
PRIMARY
recentchanges
PK
rc_id
INT(10)
NN
rc_timestamp
BINARY(14)
NN
rc_actor
BIGINT(20)
NN
rc_namespace
INT(11)
NN
rc_title
VARBINARY(255)
NN
rc_comment_id
BIGINT(20)
NN
rc_minor
TINYINT(3)
NN
rc_bot
TINYINT(3)
NN
rc_new
TINYINT(3)
NN
rc_cur_id
INT(10)
NN
rc_this_oldid
INT(10)
NN
rc_last_oldid
INT(10)
NN
rc_type
TINYINT(3)
NN
rc_source
VARBINARY(16)
NN
rc_patrolled
TINYINT(3)
NN
rc_ip
VARBINARY(40)
NN
rc_old_len
INT(11)
rc_new_len
INT(11)
rc_deleted
TINYINT(3)
NN
rc_logid
INT(10)
NN
rc_log_type
VARBINARY(255)
rc_log_action
VARBINARY(255)
rc_params
BLOB
KEY
PRIMARY
IX
rc_timestamp
IX
rc_namespace_title_timestamp
IX
rc_cur_id
IX
rc_new_name_timestamp
IX
rc_ip
IX
rc_ns_actor
IX
rc_actor
IX
rc_name_type_patrolled_timestamp
IX
rc_this_oldid
iwlinks
PK
iwl_from
INT(10)
NN
PK
iwl_prefix
VARBINARY(32)
NN
PK
iwl_title
VARBINARY(255)
NN
KEY
PRIMARY
IX
iwl_prefix_title_from
IX
iwl_prefix_from_title
ipblocks
PK
ipb_id
INT(10)
NN
AK
ipb_address
TINYBLOB
NN
AK
ipb_user
INT(10)
NN
ipb_by_actor
BIGINT(20)
NN
ipb_reason_id
BIGINT(20)
NN
ipb_timestamp
BINARY(14)
NN
AK
ipb_auto
TINYINT(1)
NN
ipb_anon_only
TINYINT(1)
NN
ipb_create_account
TINYINT(1)
NN
ipb_enable_autoblock
TINYINT(1)
NN
ipb_expiry
VARBINARY(14)
NN
ipb_range_start
TINYBLOB
NN
ipb_range_end
TINYBLOB
NN
ipb_deleted
TINYINT(1)
NN
ipb_block_email
TINYINT(1)
NN
ipb_allow_usertalk
TINYINT(1)
NN
ipb_parent_block_id
INT(10)
ipb_sitewide
TINYINT(1)
NN
KEY
PRIMARY
KEY
ipb_address_unique
IX
ipb_user
IX
ipb_range
IX
ipb_timestamp
IX
ipb_expiry
IX
ipb_parent_block_id
querycache_info
PK
qci_type
VARBINARY(32)
NN
qci_timestamp
BINARY(14)
NN
KEY
PRIMARY
site_stats
PK
ss_row_id
INT(10)
NN
ss_total_edits
BIGINT(20)
ss_good_articles
BIGINT(20)
ss_total_pages
BIGINT(20)
ss_users
BIGINT(20)
ss_active_users
BIGINT(20)
ss_images
BIGINT(20)
KEY
PRIMARY
log_search
PK
ls_field
VARBINARY(32)
NN
PK
ls_value
VARBINARY(255)
NN
PK
ls_log_id
INT(10)
NN
KEY
PRIMARY
IX
ls_log_id
oldimage
oi_name
VARBINARY(255)
NN
oi_archive_name
VARBINARY(255)
NN
oi_size
INT(10)
NN
oi_width
INT(11)
NN
oi_height
INT(11)
NN
oi_bits
INT(11)
NN
oi_description_id
BIGINT(20)
NN
oi_actor
BIGINT(20)
NN
oi_timestamp
BINARY(14)
NN
oi_metadata
MEDIUMBLOB
NN
oi_media_type
ENUM
oi_major_mime
ENUM
NN
oi_minor_mime
VARBINARY(100)
NN
oi_deleted
TINYINT(3)
NN
oi_sha1
VARBINARY(32)
NN
KEY
Primary key
IX
oi_actor_timestamp
IX
oi_name_timestamp
IX
oi_name_archive_name
IX
oi_sha1
IX
oi_timestamp
ip_changes
PK
ipc_rev_id
INT(10)
NN
ipc_rev_timestamp
BINARY(14)
NN
ipc_hex
VARBINARY(35)
NN
KEY
PRIMARY
IX
ipc_rev_timestamp
IX
ipc_hex_time
watchlist_expiry
PK
we_item
INT(10)
NN
we_expiry
BINARY(14)
NN
KEY
PRIMARY
IX
we_expiry
uploadstash
PK
us_id
INT(10)
NN
us_user
INT(10)
NN
AK
us_key
VARBINARY(255)
NN
us_orig_path
VARBINARY(255)
NN
us_path
VARBINARY(255)
NN
us_source_type
VARBINARY(50)
us_timestamp
BINARY(14)
NN
us_status
VARBINARY(50)
NN
us_chunk_inx
INT(10)
us_props
BLOB
us_size
INT(10)
NN
us_sha1
VARBINARY(31)
NN
us_mime
VARBINARY(255)
us_media_type
ENUM
us_image_width
INT(10)
us_image_height
INT(10)
us_image_bits
SMALLINT(5)
KEY
PRIMARY
KEY
us_key
IX
us_user
IX
us_timestamp
bot_passwords
PK
bp_user
INT(10)
NN
PK
bp_app_id
VARBINARY(32)
NN
bp_password
TINYBLOB
NN
bp_token
BINARY(32)
NN
bp_restrictions
BLOB
NN
bp_grants
BLOB
NN
KEY
PRIMARY
page
PK
page_id
INT(10)
NN
AK
page_namespace
INT(11)
NN
AK
page_title
VARBINARY(255)
NN
page_is_redirect
TINYINT(3)
NN
page_is_new
TINYINT(3)
NN
page_random
DOUBLE
NN
page_touched
BINARY(14)
NN
page_links_updated
VARBINARY(14)
page_latest
INT(10)
NN
page_len
INT(10)
NN
page_content_model
VARBINARY(32)
page_lang
VARBINARY(35)
KEY
PRIMARY
KEY
page_name_title
IX
page_random
IX
page_len
IX
page_redirect_namespace_len
redirect
PK
rd_from
INT(10)
NN
rd_namespace
INT(11)
NN
rd_title
VARBINARY(255)
NN
rd_interwiki
VARBINARY(32)
rd_fragment
VARBINARY(255)
KEY
PRIMARY
IX
rd_ns_title
searchindex
AK
si_page
INT(10)
NN
si_title
VARCHAR(255)
NN
si_text
MEDIUMTEXT
NN
KEY
si_page
KEY
Primary key
IX
si_title
IX
si_text
user_newtalk
user_id
INT(10)
NN
user_ip
VARBINARY(40)
NN
user_last_timestamp
BINARY(14)
KEY
Primary key
IX
un_user_id
IX
un_user_ip
interwiki
PK
iw_prefix
VARBINARY(32)
NN
iw_url
BLOB
NN
iw_api
BLOB
NN
iw_wikiid
VARBINARY(64)
NN
iw_local
TINYINT(1)
NN
iw_trans
TINYINT(4)
NN
KEY
PRIMARY
categorylinks
PK
cl_from
INT(10)
NN
PK
cl_to
VARBINARY(255)
NN
cl_sortkey
VARBINARY(230)
NN
cl_sortkey_prefix
VARBINARY(255)
NN
cl_timestamp
TIMESTAMP
NN
cl_collation
VARBINARY(32)
NN
cl_type
ENUM
NN
KEY
PRIMARY
IX
cl_sortkey
IX
cl_timestamp
IX
cl_collation_ext
templatelinks
PK
tl_from
INT(10)
NN
PK
tl_target_id
BIGINT(20)
NN
tl_from_namespace
INT(11)
NN
KEY
PRIMARY
IX
tl_target_id
IX
tl_backlinks_namespace_target_id
archive
PK
ar_id
INT(10)
NN
ar_namespace
INT(11)
NN
ar_title
VARBINARY(255)
NN
ar_comment_id
BIGINT(20)
NN
ar_actor
BIGINT(20)
NN
ar_timestamp
BINARY(14)
NN
ar_minor_edit
TINYINT(4)
NN
AK
ar_rev_id
INT(10)
NN
ar_deleted
TINYINT(3)
NN
ar_len
INT(10)
ar_page_id
INT(10)
ar_parent_id
INT(10)
ar_sha1
VARBINARY(32)
NN
KEY
PRIMARY
KEY
ar_revid_uniq
IX
ar_name_title_timestamp
IX
ar_actor_timestamp
langlinks
PK
ll_from
INT(10)
NN
PK
ll_lang
VARBINARY(35)
NN
ll_title
VARBINARY(255)
NN
KEY
PRIMARY
IX
ll_lang
protected_titles
PK
pt_namespace
INT(11)
NN
PK
pt_title
VARBINARY(255)
NN
pt_user
INT(10)
NN
pt_reason_id
BIGINT(20)
NN
pt_timestamp
BINARY(14)
NN
pt_expiry
VARBINARY(14)
NN
pt_create_perm
VARBINARY(60)
NN
KEY
PRIMARY
IX
pt_timestamp
objectcache
PK
keyname
VARBINARY(255)
NN
value
MEDIUMBLOB
exptime
BINARY(14)
NN
modtoken
VARBINARY(17)
NN
flags
INT(10)
KEY
PRIMARY
IX
exptime
job
PK
job_id
INT(10)
NN
job_cmd
VARBINARY(60)
NN
job_namespace
INT(11)
NN
job_title
VARBINARY(255)
NN
job_timestamp
BINARY(14)
job_params
MEDIUMBLOB
NN
job_random
INT(10)
NN
job_attempts
INT(10)
NN
job_token
VARBINARY(32)
NN
job_token_timestamp
BINARY(14)
job_sha1
VARBINARY(32)
NN
KEY
PRIMARY
IX
job_sha1
IX
job_cmd_token
IX
job_cmd_token_id
IX
job_cmd
IX
job_timestamp
site_identifiers
PK
si_type
VARBINARY(32)
NN
PK
si_key
VARBINARY(32)
NN
si_site
INT(10)
NN
KEY
PRIMARY
IX
si_site
IX
si_key
change_tag_def
PK
ctd_id
INT(10)
NN
AK
ctd_name
VARBINARY(255)
NN
ctd_user_defined
TINYINT(1)
NN
ctd_count
BIGINT(20)
NN
KEY
PRIMARY
KEY
ctd_name
IX
ctd_count
IX
ctd_user_defined
imagelinks
PK
il_from
INT(10)
NN
PK
il_to
VARBINARY(255)
NN
il_from_namespace
INT(11)
NN
KEY
PRIMARY
IX
il_to
IX
il_backlinks_namespace
user_properties
PK
up_user
INT(10)
NN
PK
up_property
VARBINARY(255)
NN
up_value
BLOB
KEY
PRIMARY
IX
up_property
sites
PK
site_id
INT(10)
NN
AK
site_global_key
VARBINARY(64)
NN
site_type
VARBINARY(32)
NN
site_group
VARBINARY(32)
NN
site_source
VARBINARY(32)
NN
site_language
VARBINARY(35)
NN
site_protocol
VARBINARY(32)
NN
site_domain
VARBINARY(255)
NN
site_data
BLOB
NN
site_forward
TINYINT(1)
NN
site_config
BLOB
NN
KEY
PRIMARY
KEY
site_global_key
IX
site_type
IX
site_group
IX
site_source
IX
site_language
IX
site_protocol
IX
site_domain
IX
site_forward
revision
PK
rev_id
INT(10)
NN
rev_page
INT(10)
NN
rev_comment_id
BIGINT(20)
NN
rev_actor
BIGINT(20)
NN
rev_timestamp
BINARY(14)
NN
rev_minor_edit
TINYINT(3)
NN
rev_deleted
TINYINT(3)
NN
rev_len
INT(10)
rev_parent_id
INT(10)
rev_sha1
VARBINARY(32)
NN
KEY
PRIMARY
IX
rev_timestamp
IX
rev_page_timestamp
IX
rev_actor_timestamp
IX
rev_page_actor_timestamp
module_deps
PK
md_module
VARBINARY(255)
NN
PK
md_skin
VARBINARY(32)
NN
md_deps
MEDIUMBLOB
NN
KEY
PRIMARY
change_tag
PK
ct_id
INT(10)
NN
AK
ct_rc_id
INT(10)
AK
ct_log_id
INT(10)
AK
ct_rev_id
INT(10)
ct_params
BLOB
AK
ct_tag_id
INT(10)
NN
KEY
PRIMARY
KEY
ct_rc_tag_id
KEY
ct_log_tag_id
KEY
ct_rev_tag_id
IX
ct_tag_id_id
user
PK
user_id
INT(10)
NN
AK
user_name
VARBINARY(255)
NN
user_real_name
VARBINARY(255)
NN
user_password
TINYBLOB
NN
user_newpassword
TINYBLOB
NN
user_newpass_time
BINARY(14)
user_email
TINYBLOB
NN
user_touched
BINARY(14)
NN
user_token
BINARY(32)
NN
user_email_authenticated
BINARY(14)
user_email_token
BINARY(32)
user_email_token_expires
BINARY(14)
user_registration
BINARY(14)
user_editcount
INT(10)
user_password_expires
VARBINARY(14)
KEY
PRIMARY
KEY
user_name
IX
user_email_token
IX
user_email
updatelog
PK
ul_key
VARBINARY(255)
NN
ul_value
BLOB
KEY
PRIMARY
user_autocreate_serial
PK
uas_shard
INT(10)
NN
uas_value
INT(10)
NN
KEY
PRIMARY
image
PK
img_name
VARBINARY(255)
NN
img_size
INT(10)
NN
img_width
INT(11)
NN
img_height
INT(11)
NN
img_metadata
MEDIUMBLOB
NN
img_bits
INT(11)
NN
img_media_type
ENUM
img_major_mime
ENUM
NN
img_minor_mime
VARBINARY(100)
NN
img_description_id
BIGINT(20)
NN
img_actor
BIGINT(20)
NN
img_timestamp
BINARY(14)
NN
img_sha1
VARBINARY(32)
NN
KEY
PRIMARY
IX
img_actor_timestamp
IX
img_size
IX
img_timestamp
IX
img_sha1
IX
img_media_mime
page_props
PK
pp_page
INT(10)
NN
PK
pp_propname
VARBINARY(60)
NN
pp_value
BLOB
NN
AK
pp_sortkey
FLOAT
KEY
PRIMARY
KEY
pp_propname_page
KEY
pp_propname_sortkey_page
querycachetwo
qcc_type
VARBINARY(32)
NN
qcc_value
INT(10)
NN
qcc_namespace
INT(11)
NN
qcc_title
VARBINARY(255)
NN
qcc_namespacetwo
INT(11)
NN
qcc_titletwo
VARBINARY(255)
NN
KEY
Primary key
IX
qcc_type
IX
qcc_title
IX
qcc_titletwo
pagelinks
PK
pl_from
INT(10)
NN
PK
pl_namespace
INT(11)
NN
PK
pl_title
VARBINARY(255)
NN
pl_from_namespace
INT(11)
NN
KEY
PRIMARY
IX
pl_namespace
IX
pl_backlinks_namespace
text
PK
old_id
INT(10)
NN
old_text
MEDIUMBLOB
NN
old_flags
TINYBLOB
NN
KEY
PRIMARY
user_groups
PK
ug_user
INT(10)
NN
PK
ug_group
VARBINARY(255)
NN
ug_expiry
VARBINARY(14)
KEY
PRIMARY
IX
ug_group
IX
ug_expiry
watchlist
PK
wl_id
INT(10)
NN
AK
wl_user
INT(10)
NN
AK
wl_namespace
INT(11)
NN
AK
wl_title
VARBINARY(255)
NN
wl_notificationtimestamp
BINARY(14)
KEY
PRIMARY
KEY
wl_user
IX
wl_namespace_title
IX
wl_user_notificationtimestamp
externallinks
PK
el_id
INT(10)
NN
el_from
INT(10)
NN
el_to
BLOB
NN
el_index
BLOB
NN
el_index_60
VARBINARY(60)
NN
KEY
PRIMARY
IX
el_from
IX
el_to
IX
el_index
IX
el_index_60
IX
el_from_index_60
content
PK
content_id
BIGINT(20)
NN
content_size
INT(10)
NN
content_sha1
VARBINARY(32)
NN
content_model
SMALLINT(5)
NN
content_address
VARBINARY(255)
NN
KEY
PRIMARY
page_restrictions
PK
pr_id
INT(10)
NN
AK
pr_page
INT(10)
NN
AK
pr_type
VARBINARY(60)
NN
pr_level
VARBINARY(60)
NN
pr_cascade
TINYINT(4)
NN
pr_expiry
VARBINARY(14)
KEY
PRIMARY
KEY
pr_pagetype
IX
pr_typelevel
IX
pr_level
IX
pr_cascade
slots
PK
slot_revision_id
BIGINT(20)
NN
PK
slot_role_id
SMALLINT(5)
NN
slot_content_id
BIGINT(20)
NN
slot_origin
BIGINT(20)
NN
KEY
PRIMARY
IX
slot_revision_origin_role
comment
PK
comment_id
BIGINT(20)
NN
comment_hash
INT(11)
NN
comment_text
BLOB
NN
comment_data
BLOB
KEY
PRIMARY
IX
comment_hash
user_former_groups
PK
ufg_user
INT(10)
NN
PK
ufg_group
VARBINARY(255)
NN
KEY
PRIMARY
logging
PK
log_id
INT(10)
NN
log_type
VARBINARY(32)
NN
log_action
VARBINARY(32)
NN
log_timestamp
BINARY(14)
NN
log_actor
BIGINT(20)
NN
log_namespace
INT(11)
NN
log_title
VARBINARY(255)
NN
log_page
INT(10)
log_comment_id
BIGINT(20)
NN
log_params
BLOB
NN
log_deleted
TINYINT(3)
NN
KEY
PRIMARY
IX
log_type_time
IX
log_actor_time
IX
log_page_time
IX
log_times
IX
log_actor_type_time
IX
log_page_id_time
IX
log_type_action
actor
PK
actor_id
BIGINT(20)
NN
AK
actor_user
INT(10)
AK
actor_name
VARBINARY(255)
NN
KEY
PRIMARY
KEY
actor_name
KEY
actor_user
category
PK
cat_id
INT(10)
NN
AK
cat_title
VARBINARY(255)
NN
cat_pages
INT(11)
NN
cat_subcats
INT(11)
NN
cat_files
INT(11)
NN
KEY
PRIMARY
KEY
cat_title
IX
cat_pages
querycache
qc_type
VARBINARY(32)
NN
qc_value
INT(10)
NN
qc_namespace
INT(11)
NN
qc_title
VARBINARY(255)
NN
KEY
Primary key
IX
qc_type
ipblocks_restrictions
PK
ir_ipb_id
INT(10)
NN
PK
ir_type
TINYINT(4)
NN
PK
ir_value
INT(10)
NN
KEY
PRIMARY
IX
ir_type_value
filearchive
PK
fa_id
INT(10)
NN
fa_name
VARBINARY(255)
NN
fa_archive_name
VARBINARY(255)
fa_storage_group
VARBINARY(16)
fa_storage_key
VARBINARY(64)
fa_deleted_user
INT(11)
fa_deleted_timestamp
BINARY(14)
fa_deleted_reason_id
BIGINT(20)
NN
fa_size
INT(10)
fa_width
INT(11)
fa_height
INT(11)
fa_metadata
MEDIUMBLOB
fa_bits
INT(11)
fa_media_type
ENUM
fa_major_mime
ENUM
fa_minor_mime
VARBINARY(100)
fa_description_id
BIGINT(20)
NN
fa_actor
BIGINT(20)
NN
fa_timestamp
BINARY(14)
fa_deleted
TINYINT(3)
NN
fa_sha1
VARBINARY(32)
NN
KEY
PRIMARY
IX
fa_name
IX
fa_storage_group
IX
fa_deleted_timestamp
IX
fa_actor_timestamp
IX
fa_sha1
linktarget
PK
lt_id
BIGINT(20)
NN
AK
lt_namespace
INT(11)
NN
AK
lt_title
VARBINARY(255)
NN
KEY
PRIMARY
KEY
lt_namespace_title
revision_comment_temp
PK
revcomment_rev
INT(10)
NN
PK
revcomment_comment_id
BIGINT(20)
NN
KEY
PRIMARY
KEY
revcomment_rev
slot_roles
PK
role_id
INT(11)
NN
AK
role_name
VARBINARY(64)
NN
KEY
PRIMARY
KEY
role_name
License
MediaWiki is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.