-- This file is automatically generated using maintenance/generateSchemaSql.php.
-- Source: sql/tables.json
-- Do not modify this file directly.
-- See https://www.mediawiki.org/wiki/Manual:Schema_changes
CREATE TABLE /*_*/actor (
actor_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
actor_user INT UNSIGNED DEFAULT NULL,
actor_name VARBINARY(255) NOT NULL,
UNIQUE INDEX actor_user (actor_user),
UNIQUE INDEX actor_name (actor_name),
PRIMARY KEY(actor_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/archive (
ar_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
ar_namespace INT DEFAULT 0 NOT NULL,
ar_title VARBINARY(255) DEFAULT '' NOT NULL,
ar_comment_id BIGINT UNSIGNED NOT NULL,
ar_actor BIGINT UNSIGNED NOT NULL,
ar_timestamp BINARY(14) NOT NULL,
ar_minor_edit TINYINT DEFAULT 0 NOT NULL,
ar_rev_id INT UNSIGNED NOT NULL,
ar_deleted TINYINT UNSIGNED DEFAULT 0 NOT NULL,
ar_len INT UNSIGNED DEFAULT NULL,
ar_page_id INT UNSIGNED DEFAULT NULL,
ar_parent_id INT UNSIGNED DEFAULT NULL,
INDEX ar_name_title_timestamp (
ar_namespace, ar_title, ar_timestamp
),
INDEX ar_actor_timestamp (ar_actor, ar_timestamp),
UNIQUE INDEX ar_revid_uniq (ar_rev_id),
PRIMARY KEY(ar_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/block (
bl_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
bl_target INT UNSIGNED NOT NULL,
bl_by_actor BIGINT UNSIGNED NOT NULL,
bl_reason_id BIGINT UNSIGNED NOT NULL,
bl_timestamp BINARY(14) NOT NULL,
bl_anon_only TINYINT(1) DEFAULT 0 NOT NULL,
bl_create_account TINYINT(1) DEFAULT 1 NOT NULL,
bl_enable_autoblock TINYINT(1) DEFAULT 1 NOT NULL,
bl_expiry VARBINARY(14) NOT NULL,
bl_deleted TINYINT(1) DEFAULT 0 NOT NULL,
bl_block_email TINYINT(1) DEFAULT 0 NOT NULL,
bl_allow_usertalk TINYINT(1) DEFAULT 0 NOT NULL,
bl_parent_block_id INT UNSIGNED DEFAULT NULL,
bl_sitewide TINYINT(1) DEFAULT 1 NOT NULL,
INDEX bl_timestamp (bl_timestamp),
INDEX bl_target (bl_target),
INDEX bl_expiry (bl_expiry),
INDEX bl_parent_block_id (bl_parent_block_id),
PRIMARY KEY(bl_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/block_target (
bt_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
bt_address TINYBLOB DEFAULT NULL,
bt_user INT UNSIGNED DEFAULT NULL,
bt_user_text VARBINARY(255) DEFAULT NULL,
bt_auto TINYINT(1) DEFAULT 0 NOT NULL,
bt_range_start TINYBLOB DEFAULT NULL,
bt_range_end TINYBLOB DEFAULT NULL,
bt_ip_hex TINYBLOB DEFAULT NULL,
bt_count INT DEFAULT 0 NOT NULL,
INDEX bt_address (
bt_address(42)
),
INDEX bt_ip_user_text (
bt_ip_hex(35),
bt_user_text(255)
),
INDEX bt_range (
bt_range_start(35),
bt_range_end(35)
),
INDEX bt_user (bt_user),
PRIMARY KEY(bt_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/bot_passwords (
bp_user INT UNSIGNED NOT NULL,
bp_app_id VARBINARY(32) NOT NULL,
bp_password TINYBLOB NOT NULL,
bp_token BINARY(32) DEFAULT '' NOT NULL,
bp_restrictions BLOB NOT NULL,
bp_grants BLOB NOT NULL,
PRIMARY KEY(bp_user, bp_app_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/category (
cat_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
cat_title VARBINARY(255) NOT NULL,
cat_pages INT DEFAULT 0 NOT NULL,
cat_subcats INT DEFAULT 0 NOT NULL,
cat_files INT DEFAULT 0 NOT NULL,
UNIQUE INDEX cat_title (cat_title),
INDEX cat_pages (cat_pages),
PRIMARY KEY(cat_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/categorylinks (
cl_from INT UNSIGNED DEFAULT 0 NOT NULL,
cl_target_id BIGINT UNSIGNED NOT NULL,
cl_sortkey VARBINARY(230) DEFAULT '' NOT NULL,
cl_sortkey_prefix VARBINARY(255) DEFAULT '' NOT NULL,
cl_timestamp TIMESTAMP NOT NULL,
cl_type ENUM('page', 'subcat', 'file') DEFAULT 'page' NOT NULL,
cl_collation_id SMALLINT UNSIGNED DEFAULT 0 NOT NULL,
INDEX cl_sortkey_id (
cl_target_id, cl_type, cl_sortkey,
cl_from
),
INDEX cl_timestamp_id (cl_target_id, cl_timestamp),
PRIMARY KEY(cl_from, cl_target_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/change_tag (
ct_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
ct_rc_id BIGINT UNSIGNED DEFAULT NULL,
ct_log_id INT UNSIGNED DEFAULT NULL,
ct_rev_id INT UNSIGNED DEFAULT NULL,
ct_params BLOB DEFAULT NULL,
ct_tag_id INT UNSIGNED NOT NULL,
UNIQUE INDEX ct_rc_tag_id (ct_rc_id, ct_tag_id),
UNIQUE INDEX ct_log_tag_id (ct_log_id, ct_tag_id),
UNIQUE INDEX ct_rev_tag_id (ct_rev_id, ct_tag_id),
INDEX ct_tag_id_id (
ct_tag_id, ct_rc_id, ct_rev_id, ct_log_id
),
PRIMARY KEY(ct_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/change_tag_def (
ctd_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
ctd_name VARBINARY(255) NOT NULL,
ctd_user_defined TINYINT(1) NOT NULL,
ctd_count BIGINT UNSIGNED DEFAULT 0 NOT NULL,
UNIQUE INDEX ctd_name (ctd_name),
INDEX ctd_count (ctd_count),
INDEX ctd_user_defined (ctd_user_defined),
PRIMARY KEY(ctd_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/collation (
collation_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL,
collation_name VARBINARY(64) NOT NULL,
UNIQUE INDEX collation_name (collation_name),
PRIMARY KEY(collation_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/comment (
comment_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
comment_hash INT NOT NULL,
comment_text BLOB NOT NULL,
comment_data BLOB DEFAULT NULL,
INDEX comment_hash (comment_hash),
PRIMARY KEY(comment_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/content (
content_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
content_size INT UNSIGNED NOT NULL,
content_sha1 VARBINARY(32) NOT NULL,
content_model SMALLINT UNSIGNED NOT NULL,
content_address VARBINARY(255) NOT NULL,
PRIMARY KEY(content_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/content_models (
model_id INT AUTO_INCREMENT NOT NULL,
model_name VARBINARY(64) NOT NULL,
UNIQUE INDEX model_name (model_name),
PRIMARY KEY(model_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/existencelinks (
exl_from INT UNSIGNED DEFAULT 0 NOT NULL,
exl_target_id BIGINT UNSIGNED NOT NULL,
INDEX exl_target_id (exl_target_id, exl_from),
PRIMARY KEY(exl_from, exl_target_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/externallinks (
el_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
el_from INT UNSIGNED DEFAULT 0 NOT NULL,
el_to_domain_index VARBINARY(255) DEFAULT '' NOT NULL,
el_to_path BLOB DEFAULT NULL,
INDEX el_from (el_from),
INDEX el_to_domain_index_to_path (
el_to_domain_index,
el_to_path(60)
),
PRIMARY KEY(el_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/file (
file_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
file_name VARBINARY(255) NOT NULL,
file_latest BIGINT UNSIGNED NOT NULL,
file_type SMALLINT UNSIGNED NOT NULL,
file_deleted SMALLINT UNSIGNED NOT NULL,
UNIQUE INDEX file_name (file_name),
INDEX file_latest (file_latest),
PRIMARY KEY(file_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/filearchive (
fa_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
fa_name VARBINARY(255) DEFAULT '' NOT NULL,
fa_archive_name VARBINARY(255) DEFAULT '',
fa_storage_group VARBINARY(16) DEFAULT NULL,
fa_storage_key VARBINARY(64) DEFAULT '',
fa_deleted_user INT DEFAULT NULL,
fa_deleted_timestamp BINARY(14) DEFAULT NULL,
fa_deleted_reason_id BIGINT UNSIGNED NOT NULL,
fa_size BIGINT UNSIGNED DEFAULT 0,
fa_width INT DEFAULT 0,
fa_height INT DEFAULT 0,
fa_metadata MEDIUMBLOB DEFAULT NULL,
fa_bits INT DEFAULT 0,
fa_media_type ENUM(
'UNKNOWN', 'BITMAP', 'DRAWING', 'AUDIO',
'VIDEO', 'MULTIMEDIA', 'OFFICE',
'TEXT', 'EXECUTABLE', 'ARCHIVE',
'3D'
) DEFAULT NULL,
fa_major_mime ENUM(
'unknown', 'application', 'audio',
'image', 'text', 'video', 'message',
'model', 'multipart', 'chemical'
) DEFAULT 'unknown',
fa_minor_mime VARBINARY(100) DEFAULT 'unknown',
fa_description_id BIGINT UNSIGNED NOT NULL,
fa_actor BIGINT UNSIGNED NOT NULL,
fa_timestamp BINARY(14) DEFAULT NULL,
fa_deleted TINYINT UNSIGNED DEFAULT 0 NOT NULL,
fa_sha1 VARBINARY(32) DEFAULT '' NOT NULL,
INDEX fa_name (fa_name, fa_timestamp),
INDEX fa_storage_group (
fa_storage_group, fa_storage_key
),
INDEX fa_deleted_timestamp (fa_deleted_timestamp),
INDEX fa_actor_timestamp (fa_actor, fa_timestamp),
INDEX fa_sha1 (
fa_sha1(10)
),
PRIMARY KEY(fa_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/filerevision (
fr_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
fr_file BIGINT NOT NULL,
fr_size BIGINT UNSIGNED DEFAULT 0 NOT NULL,
fr_width INT UNSIGNED DEFAULT 0 NOT NULL,
fr_height INT UNSIGNED DEFAULT 0 NOT NULL,
fr_metadata MEDIUMBLOB NOT NULL,
fr_bits INT UNSIGNED DEFAULT 0 NOT NULL,
fr_description_id BIGINT UNSIGNED NOT NULL,
fr_actor BIGINT UNSIGNED NOT NULL,
fr_timestamp BINARY(14) NOT NULL,
fr_sha1 VARBINARY(32) DEFAULT '' NOT NULL,
fr_archive_name VARBINARY(255) DEFAULT '' NOT NULL,
fr_deleted SMALLINT UNSIGNED NOT NULL,
INDEX fr_actor_timestamp (fr_actor, fr_timestamp),
INDEX fr_size (fr_size),
INDEX fr_timestamp (fr_timestamp),
INDEX fr_sha1 (
fr_sha1(10)
),
INDEX fr_file (fr_file),
PRIMARY KEY(fr_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/filetypes (
ft_id SMALLINT UNSIGNED AUTO_INCREMENT NOT NULL,
ft_media_type VARBINARY(255) NOT NULL,
ft_major_mime VARBINARY(255) NOT NULL,
ft_minor_mime VARBINARY(255) NOT NULL,
UNIQUE INDEX ft_media_mime (
ft_media_type, ft_major_mime, ft_minor_mime
),
PRIMARY KEY(ft_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/image (
img_name VARBINARY(255) DEFAULT '' NOT NULL,
img_size BIGINT UNSIGNED DEFAULT 0 NOT NULL,
img_width INT DEFAULT 0 NOT NULL,
img_height INT DEFAULT 0 NOT NULL,
img_metadata MEDIUMBLOB NOT NULL,
img_bits INT DEFAULT 0 NOT NULL,
img_media_type ENUM(
'UNKNOWN', 'BITMAP', 'DRAWING', 'AUDIO',
'VIDEO', 'MULTIMEDIA', 'OFFICE',
'TEXT', 'EXECUTABLE', 'ARCHIVE',
'3D'
) DEFAULT NULL,
img_major_mime ENUM(
'unknown', 'application', 'audio',
'image', 'text', 'video', 'message',
'model', 'multipart', 'chemical'
) DEFAULT 'unknown' NOT NULL,
img_minor_mime VARBINARY(100) DEFAULT 'unknown' NOT NULL,
img_description_id BIGINT UNSIGNED NOT NULL,
img_actor BIGINT UNSIGNED NOT NULL,
img_timestamp BINARY(14) NOT NULL,
img_sha1 VARBINARY(32) DEFAULT '' NOT NULL,
INDEX img_actor_timestamp (img_actor, img_timestamp),
INDEX img_size (img_size),
INDEX img_timestamp (img_timestamp),
INDEX img_sha1 (
img_sha1(10)
),
INDEX img_media_mime (
img_media_type, img_major_mime, img_minor_mime
),
PRIMARY KEY(img_name)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/imagelinks (
il_from INT UNSIGNED DEFAULT 0 NOT NULL,
il_target_id BIGINT UNSIGNED NOT NULL,
il_from_namespace INT DEFAULT 0 NOT NULL,
INDEX il_target_id (il_target_id, il_from),
INDEX il_backlinks_namespace_target_id (
il_from_namespace, il_target_id,
il_from
),
PRIMARY KEY(il_from, il_target_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/interwiki (
iw_prefix VARCHAR(32) NOT NULL,
iw_url BLOB NOT NULL,
iw_api BLOB NOT NULL,
iw_wikiid VARCHAR(64) NOT NULL,
iw_local TINYINT(1) NOT NULL,
iw_trans TINYINT DEFAULT 0 NOT NULL,
PRIMARY KEY(iw_prefix)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/ip_changes (
ipc_rev_id INT UNSIGNED DEFAULT 0 NOT NULL,
ipc_rev_timestamp BINARY(14) NOT NULL,
ipc_hex VARBINARY(35) DEFAULT '' NOT NULL,
INDEX ipc_rev_timestamp (ipc_rev_timestamp),
INDEX ipc_hex_time (ipc_hex, ipc_rev_timestamp),
PRIMARY KEY(ipc_rev_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/ipblocks_restrictions (
ir_ipb_id INT UNSIGNED NOT NULL,
ir_type TINYINT(4) NOT NULL,
ir_value INT UNSIGNED NOT NULL,
INDEX ir_type_value (ir_type, ir_value),
PRIMARY KEY(ir_ipb_id, ir_type, ir_value)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/iwlinks (
iwl_from INT UNSIGNED DEFAULT 0 NOT NULL,
iwl_prefix VARBINARY(32) DEFAULT '' NOT NULL,
iwl_title VARBINARY(255) DEFAULT '' NOT NULL,
INDEX iwl_prefix_title_from (iwl_prefix, iwl_title, iwl_from),
PRIMARY KEY(iwl_from, iwl_prefix, iwl_title)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/job (
job_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
job_cmd VARBINARY(60) DEFAULT '' NOT NULL,
job_namespace INT NOT NULL,
job_title VARBINARY(255) NOT NULL,
job_timestamp BINARY(14) DEFAULT NULL,
job_params MEDIUMBLOB NOT NULL,
job_random INT UNSIGNED DEFAULT 0 NOT NULL,
job_attempts INT UNSIGNED DEFAULT 0 NOT NULL,
job_token VARBINARY(32) DEFAULT '' NOT NULL,
job_token_timestamp BINARY(14) DEFAULT NULL,
job_sha1 VARBINARY(32) DEFAULT '' NOT NULL,
INDEX job_sha1 (job_sha1),
INDEX job_cmd_token (job_cmd, job_token, job_random),
INDEX job_cmd_token_id (job_cmd, job_token, job_id),
INDEX job_cmd (
job_cmd,
job_namespace,
job_title,
job_params(128)
),
INDEX job_timestamp (job_timestamp),
PRIMARY KEY(job_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/l10n_cache (
lc_lang VARBINARY(35) NOT NULL,
lc_key VARCHAR(255) NOT NULL,
lc_value MEDIUMBLOB NOT NULL,
PRIMARY KEY(lc_lang, lc_key)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/langlinks (
ll_from INT UNSIGNED DEFAULT 0 NOT NULL,
ll_lang VARBINARY(35) DEFAULT '' NOT NULL,
ll_title VARBINARY(255) DEFAULT '' NOT NULL,
INDEX ll_lang (ll_lang, ll_title),
PRIMARY KEY(ll_from, ll_lang)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/linktarget (
lt_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
lt_namespace INT NOT NULL,
lt_title VARBINARY(255) NOT NULL,
UNIQUE INDEX lt_namespace_title (lt_namespace, lt_title),
PRIMARY KEY(lt_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/log_search (
ls_field VARBINARY(32) NOT NULL,
ls_value VARCHAR(255) NOT NULL,
ls_log_id INT UNSIGNED DEFAULT 0 NOT NULL,
INDEX ls_log_id (ls_log_id),
PRIMARY KEY(ls_field, ls_value, ls_log_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/logging (
log_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
log_type VARBINARY(32) DEFAULT '' NOT NULL,
log_action VARBINARY(32) DEFAULT '' NOT NULL,
log_timestamp BINARY(14) DEFAULT '19700101000000' NOT NULL,
log_actor BIGINT UNSIGNED NOT NULL,
log_namespace INT DEFAULT 0 NOT NULL,
log_title VARBINARY(255) DEFAULT '' NOT NULL,
log_page INT UNSIGNED DEFAULT NULL,
log_comment_id BIGINT UNSIGNED NOT NULL,
log_params BLOB NOT NULL,
log_deleted TINYINT UNSIGNED DEFAULT 0 NOT NULL,
INDEX log_type_time (log_type, log_timestamp),
INDEX log_actor_time (log_actor, log_timestamp),
INDEX log_page_time (
log_namespace, log_title, log_timestamp
),
INDEX log_times (log_timestamp),
INDEX log_actor_type_time (
log_actor, log_type, log_timestamp
),
INDEX log_page_id_time (log_page, log_timestamp),
INDEX log_type_action (
log_type, log_action, log_timestamp
),
PRIMARY KEY(log_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/objectcache (
keyname VARBINARY(255) DEFAULT '' NOT NULL,
value MEDIUMBLOB DEFAULT NULL,
exptime BINARY(14) NOT NULL,
INDEX exptime (exptime),
PRIMARY KEY(keyname)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/oldimage (
oi_name VARBINARY(255) DEFAULT '' NOT NULL,
oi_archive_name VARBINARY(255) DEFAULT '' NOT NULL,
oi_size BIGINT UNSIGNED DEFAULT 0 NOT NULL,
oi_width INT DEFAULT 0 NOT NULL,
oi_height INT DEFAULT 0 NOT NULL,
oi_bits INT DEFAULT 0 NOT NULL,
oi_description_id BIGINT UNSIGNED NOT NULL,
oi_actor BIGINT UNSIGNED NOT NULL,
oi_timestamp BINARY(14) NOT NULL,
oi_metadata MEDIUMBLOB NOT NULL,
oi_media_type ENUM(
'UNKNOWN', 'BITMAP', 'DRAWING', 'AUDIO',
'VIDEO', 'MULTIMEDIA', 'OFFICE',
'TEXT', 'EXECUTABLE', 'ARCHIVE',
'3D'
) DEFAULT NULL,
oi_major_mime ENUM(
'unknown', 'application', 'audio',
'image', 'text', 'video', 'message',
'model', 'multipart', 'chemical'
) DEFAULT 'unknown' NOT NULL,
oi_minor_mime VARBINARY(100) DEFAULT 'unknown' NOT NULL,
oi_deleted TINYINT UNSIGNED DEFAULT 0 NOT NULL,
oi_sha1 VARBINARY(32) DEFAULT '' NOT NULL,
INDEX oi_actor_timestamp (oi_actor, oi_timestamp),
INDEX oi_name_timestamp (oi_name, oi_timestamp),
INDEX oi_name_archive_name (
oi_name,
oi_archive_name(14)
),
INDEX oi_sha1 (
oi_sha1(10)
),
INDEX oi_timestamp (oi_timestamp)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/page (
page_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
page_namespace INT NOT NULL,
page_title VARBINARY(255) NOT NULL,
page_is_redirect TINYINT UNSIGNED DEFAULT 0 NOT NULL,
page_is_new TINYINT UNSIGNED DEFAULT 0 NOT NULL,
page_random DOUBLE PRECISION UNSIGNED NOT NULL,
page_touched BINARY(14) NOT NULL,
page_links_updated BINARY(14) DEFAULT NULL,
page_latest INT UNSIGNED NOT NULL,
page_len INT UNSIGNED NOT NULL,
page_content_model VARBINARY(32) DEFAULT NULL,
page_lang VARBINARY(35) DEFAULT NULL,
UNIQUE INDEX page_name_title (page_namespace, page_title),
INDEX page_random (page_random),
INDEX page_len (page_len),
INDEX page_redirect_namespace_len (
page_is_redirect, page_namespace,
page_len
),
PRIMARY KEY(page_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/page_props (
pp_page INT UNSIGNED NOT NULL,
pp_propname VARBINARY(60) NOT NULL,
pp_value BLOB NOT NULL,
pp_sortkey FLOAT DEFAULT NULL,
UNIQUE INDEX pp_propname_page (pp_propname, pp_page),
UNIQUE INDEX pp_propname_sortkey_page (pp_propname, pp_sortkey, pp_page),
PRIMARY KEY(pp_page, pp_propname)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/page_restrictions (
pr_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
pr_page INT UNSIGNED NOT NULL,
pr_type VARBINARY(60) NOT NULL,
pr_level VARBINARY(60) NOT NULL,
pr_cascade TINYINT NOT NULL,
pr_expiry VARBINARY(14) DEFAULT NULL,
UNIQUE INDEX pr_pagetype (pr_page, pr_type),
INDEX pr_typelevel (pr_type, pr_level),
INDEX pr_level (pr_level),
INDEX pr_cascade (pr_cascade),
PRIMARY KEY(pr_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/pagelinks (
pl_from INT UNSIGNED DEFAULT 0 NOT NULL,
pl_target_id BIGINT UNSIGNED NOT NULL,
pl_from_namespace INT DEFAULT 0 NOT NULL,
INDEX pl_target_id (pl_target_id, pl_from),
INDEX pl_backlinks_namespace_target_id (
pl_from_namespace, pl_target_id,
pl_from
),
PRIMARY KEY(pl_from, pl_target_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/protected_titles (
pt_namespace INT NOT NULL,
pt_title VARBINARY(255) NOT NULL,
pt_user INT UNSIGNED NOT NULL,
pt_reason_id BIGINT UNSIGNED NOT NULL,
pt_timestamp BINARY(14) NOT NULL,
pt_expiry VARBINARY(14) NOT NULL,
pt_create_perm VARBINARY(60) NOT NULL,
INDEX pt_timestamp (pt_timestamp),
PRIMARY KEY(pt_namespace, pt_title)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/querycache (
qc_type VARBINARY(32) NOT NULL,
qc_value INT UNSIGNED DEFAULT 0 NOT NULL,
qc_namespace INT DEFAULT 0 NOT NULL,
qc_title VARBINARY(255) DEFAULT '' NOT NULL,
INDEX qc_type (qc_type, qc_value)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/querycache_info (
qci_type VARBINARY(32) DEFAULT '' NOT NULL,
qci_timestamp BINARY(14) DEFAULT '19700101000000' NOT NULL,
PRIMARY KEY(qci_type)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/querycachetwo (
qcc_type VARBINARY(32) NOT NULL,
qcc_value INT UNSIGNED DEFAULT 0 NOT NULL,
qcc_namespace INT DEFAULT 0 NOT NULL,
qcc_title VARBINARY(255) DEFAULT '' NOT NULL,
qcc_namespacetwo INT DEFAULT 0 NOT NULL,
qcc_titletwo VARBINARY(255) DEFAULT '' NOT NULL,
INDEX qcc_type (qcc_type, qcc_value),
INDEX qcc_title (
qcc_type, qcc_namespace, qcc_title
),
INDEX qcc_titletwo (
qcc_type, qcc_namespacetwo, qcc_titletwo
)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/recentchanges (
rc_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
rc_timestamp BINARY(14) NOT NULL,
rc_actor BIGINT UNSIGNED NOT NULL,
rc_namespace INT DEFAULT 0 NOT NULL,
rc_title VARBINARY(255) DEFAULT '' NOT NULL,
rc_comment_id BIGINT UNSIGNED NOT NULL,
rc_minor TINYINT UNSIGNED DEFAULT 0 NOT NULL,
rc_bot TINYINT UNSIGNED DEFAULT 0 NOT NULL,
rc_cur_id INT UNSIGNED DEFAULT 0 NOT NULL,
rc_this_oldid INT UNSIGNED DEFAULT 0 NOT NULL,
rc_last_oldid INT UNSIGNED DEFAULT 0 NOT NULL,
rc_source VARBINARY(16) NOT NULL,
rc_patrolled TINYINT UNSIGNED DEFAULT 0 NOT NULL,
rc_ip VARBINARY(40) DEFAULT '' NOT NULL,
rc_old_len INT DEFAULT NULL,
rc_new_len INT DEFAULT NULL,
rc_deleted TINYINT UNSIGNED DEFAULT 0 NOT NULL,
rc_logid INT UNSIGNED DEFAULT 0 NOT NULL,
rc_log_type VARBINARY(255) DEFAULT NULL,
rc_log_action VARBINARY(255) DEFAULT NULL,
rc_params BLOB DEFAULT NULL,
INDEX rc_timestamp (rc_timestamp),
INDEX rc_namespace_title_timestamp (
rc_namespace, rc_title, rc_timestamp
),
INDEX rc_cur_id (rc_cur_id),
INDEX rc_source_name_timestamp (
rc_source, rc_namespace, rc_timestamp
),
INDEX rc_ip (rc_ip),
INDEX rc_ns_actor (rc_namespace, rc_actor),
INDEX rc_actor (rc_actor, rc_timestamp),
INDEX rc_name_source_patrolled_timestamp (
rc_namespace, rc_source, rc_patrolled,
rc_timestamp
),
INDEX rc_this_oldid (rc_this_oldid),
PRIMARY KEY(rc_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/redirect (
rd_from INT UNSIGNED DEFAULT 0 NOT NULL,
rd_namespace INT DEFAULT 0 NOT NULL,
rd_title VARBINARY(255) DEFAULT '' NOT NULL,
rd_interwiki VARCHAR(32) DEFAULT NULL,
rd_fragment VARBINARY(255) DEFAULT NULL,
INDEX rd_ns_title (rd_namespace, rd_title, rd_from),
PRIMARY KEY(rd_from)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/revision (
rev_id BIGINT UNSIGNED AUTO_INCREMENT NOT NULL,
rev_page INT UNSIGNED NOT NULL,
rev_comment_id BIGINT UNSIGNED NOT NULL,
rev_actor BIGINT UNSIGNED NOT NULL,
rev_timestamp BINARY(14) NOT NULL,
rev_minor_edit TINYINT UNSIGNED DEFAULT 0 NOT NULL,
rev_deleted TINYINT UNSIGNED DEFAULT 0 NOT NULL,
rev_len INT UNSIGNED DEFAULT NULL,
rev_parent_id BIGINT UNSIGNED DEFAULT NULL,
INDEX rev_timestamp (rev_timestamp),
INDEX rev_page_timestamp (rev_page, rev_timestamp),
INDEX rev_actor_timestamp (rev_actor, rev_timestamp, rev_id),
INDEX rev_page_actor_timestamp (
rev_page, rev_actor, rev_timestamp
),
PRIMARY KEY(rev_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/searchindex (
si_page INT UNSIGNED NOT NULL,
si_title MEDIUMTEXT NOT NULL,
si_text MEDIUMTEXT NOT NULL,
FULLTEXT INDEX si_title (si_title),
FULLTEXT INDEX si_text (si_text),
PRIMARY KEY(si_page)
) ENGINE = MyISAM DEFAULT CHARSET = utf8mb4;
CREATE TABLE /*_*/site_identifiers (
si_type VARBINARY(32) NOT NULL,
si_key VARBINARY(32) NOT NULL,
si_site INT UNSIGNED NOT NULL,
INDEX si_site (si_site),
INDEX si_key (si_key),
PRIMARY KEY(si_type, si_key)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/site_stats (
ss_row_id INT UNSIGNED NOT NULL,
ss_total_edits BIGINT UNSIGNED DEFAULT NULL,
ss_good_articles BIGINT UNSIGNED DEFAULT NULL,
ss_total_pages BIGINT UNSIGNED DEFAULT NULL,
ss_users BIGINT UNSIGNED DEFAULT NULL,
ss_active_users BIGINT UNSIGNED DEFAULT NULL,
ss_images BIGINT UNSIGNED DEFAULT NULL,
PRIMARY KEY(ss_row_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/sites (
site_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
site_global_key VARBINARY(64) NOT NULL,
site_type VARBINARY(32) NOT NULL,
site_group VARBINARY(32) NOT NULL,
site_source VARBINARY(32) NOT NULL,
site_language VARBINARY(35) NOT NULL,
site_protocol VARBINARY(32) NOT NULL,
site_domain VARCHAR(255) NOT NULL,
site_data BLOB NOT NULL,
site_forward TINYINT(1) NOT NULL,
site_config BLOB NOT NULL,
UNIQUE INDEX site_global_key (site_global_key),
PRIMARY KEY(site_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/slot_roles (
role_id INT AUTO_INCREMENT NOT NULL,
role_name VARBINARY(64) NOT NULL,
UNIQUE INDEX role_name (role_name),
PRIMARY KEY(role_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/slots (
slot_revision_id BIGINT UNSIGNED NOT NULL,
slot_role_id SMALLINT UNSIGNED NOT NULL,
slot_content_id BIGINT UNSIGNED NOT NULL,
slot_origin BIGINT UNSIGNED NOT NULL,
INDEX slot_revision_origin_role (
slot_revision_id, slot_origin, slot_role_id
),
PRIMARY KEY(slot_revision_id, slot_role_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/templatelinks (
tl_from INT UNSIGNED DEFAULT 0 NOT NULL,
tl_target_id BIGINT UNSIGNED NOT NULL,
tl_from_namespace INT DEFAULT 0 NOT NULL,
INDEX tl_target_id (tl_target_id, tl_from),
INDEX tl_backlinks_namespace_target_id (
tl_from_namespace, tl_target_id,
tl_from
),
PRIMARY KEY(tl_from, tl_target_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/text (
old_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
old_text MEDIUMBLOB NOT NULL,
old_flags TINYBLOB NOT NULL,
PRIMARY KEY(old_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/updatelog (
ul_key VARCHAR(255) NOT NULL,
ul_value BLOB DEFAULT NULL,
PRIMARY KEY(ul_key)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/uploadstash (
us_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
us_user INT UNSIGNED NOT NULL,
us_key VARCHAR(255) NOT NULL,
us_orig_path VARCHAR(255) NOT NULL,
us_path VARCHAR(255) NOT NULL,
us_source_type VARCHAR(50) DEFAULT NULL,
us_timestamp BINARY(14) NOT NULL,
us_status VARCHAR(50) NOT NULL,
us_chunk_inx INT UNSIGNED DEFAULT NULL,
us_props BLOB DEFAULT NULL,
us_size BIGINT UNSIGNED NOT NULL,
us_sha1 VARCHAR(31) NOT NULL,
us_mime VARCHAR(255) DEFAULT NULL,
us_media_type ENUM(
'UNKNOWN', 'BITMAP', 'DRAWING', 'AUDIO',
'VIDEO', 'MULTIMEDIA', 'OFFICE',
'TEXT', 'EXECUTABLE', 'ARCHIVE',
'3D'
) DEFAULT NULL,
us_image_width INT UNSIGNED DEFAULT NULL,
us_image_height INT UNSIGNED DEFAULT NULL,
us_image_bits SMALLINT UNSIGNED DEFAULT NULL,
INDEX us_user (us_user),
UNIQUE INDEX us_key (us_key),
INDEX us_timestamp (us_timestamp),
PRIMARY KEY(us_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/user (
user_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
user_name VARBINARY(255) DEFAULT '' NOT NULL,
user_real_name VARBINARY(255) DEFAULT '' NOT NULL,
user_password TINYBLOB NOT NULL,
user_newpassword TINYBLOB NOT NULL,
user_newpass_time BINARY(14) DEFAULT NULL,
user_email TINYTEXT NOT NULL,
user_touched BINARY(14) NOT NULL,
user_token BINARY(32) DEFAULT '' NOT NULL,
user_email_authenticated BINARY(14) DEFAULT NULL,
user_email_token BINARY(32) DEFAULT NULL,
user_email_token_expires BINARY(14) DEFAULT NULL,
user_registration BINARY(14) DEFAULT NULL,
user_editcount INT UNSIGNED DEFAULT NULL,
user_password_expires VARBINARY(14) DEFAULT NULL,
user_is_temp TINYINT(1) DEFAULT 0 NOT NULL,
UNIQUE INDEX user_name (user_name),
INDEX user_email_token (user_email_token),
INDEX user_email (
user_email(50)
),
PRIMARY KEY(user_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/user_autocreate_serial (
uas_shard INT UNSIGNED NOT NULL,
uas_year SMALLINT UNSIGNED NOT NULL,
uas_value INT UNSIGNED NOT NULL,
PRIMARY KEY(uas_shard, uas_year)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/user_former_groups (
ufg_user INT UNSIGNED DEFAULT 0 NOT NULL,
ufg_group VARBINARY(255) DEFAULT '' NOT NULL,
PRIMARY KEY(ufg_user, ufg_group)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/user_groups (
ug_user INT UNSIGNED DEFAULT 0 NOT NULL,
ug_group VARBINARY(255) DEFAULT '' NOT NULL,
ug_expiry VARBINARY(14) DEFAULT NULL,
INDEX ug_group (ug_group),
INDEX ug_expiry (ug_expiry),
PRIMARY KEY(ug_user, ug_group)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/user_newtalk (
user_id INT UNSIGNED DEFAULT 0 NOT NULL,
user_ip VARBINARY(40) DEFAULT '' NOT NULL,
user_last_timestamp BINARY(14) DEFAULT NULL,
INDEX un_user_id (user_id),
INDEX un_user_ip (user_ip)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/user_properties (
up_user INT UNSIGNED NOT NULL,
up_property VARBINARY(255) NOT NULL,
up_value BLOB DEFAULT NULL,
INDEX up_property (up_property),
PRIMARY KEY(up_user, up_property)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/watchlist (
wl_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
wl_user INT UNSIGNED NOT NULL,
wl_namespace INT DEFAULT 0 NOT NULL,
wl_title VARBINARY(255) DEFAULT '' NOT NULL,
wl_notificationtimestamp BINARY(14) DEFAULT NULL,
UNIQUE INDEX wl_user (wl_user, wl_namespace, wl_title),
INDEX wl_namespace_title (wl_namespace, wl_title),
INDEX wl_user_notificationtimestamp (
wl_user, wl_notificationtimestamp
),
PRIMARY KEY(wl_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/watchlist_expiry (
we_item INT UNSIGNED NOT NULL,
we_expiry BINARY(14) NOT NULL,
INDEX we_expiry (we_expiry),
PRIMARY KEY(we_item)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/watchlist_label (
wll_id INT UNSIGNED AUTO_INCREMENT NOT NULL,
wll_user INT UNSIGNED NOT NULL,
wll_name VARBINARY(255) NOT NULL,
UNIQUE INDEX wll_user_name (wll_user, wll_name),
PRIMARY KEY(wll_id)
) /*$wgDBTableOptions*/;
CREATE TABLE /*_*/watchlist_label_member (
wlm_label INT UNSIGNED NOT NULL,
wlm_item INT UNSIGNED NOT NULL,
INDEX wlm_item (wlm_item),
PRIMARY KEY(wlm_label, wlm_item)
) /*$wgDBTableOptions*/;