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.

Entity Relationship Diagram

MediaWiki - MariaDB

LUNA MODELER

WWW.DATENSEN.COM

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

Entity Relationship Diagram

MediaWiki - MariaDB

Name
Logo
Note

Name
LUNA MODELER
Note

LUNA MODELER

WWW.DATENSEN.COM

Name
License
Note

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.

Name
GNU GENERAL PUBLIC LICENSE
Note
GNU GENERAL PUBLIC LICENSE Version 2, June 1991 Copyright (C) 1989, 1991 Free Software Foundation, Inc. Everyone is permitted to copy and distribute verbatim copies of this license document, but changing it is not allowed. Preamble The licenses for most software are designed to take away your freedom to share and change it. By contrast, the GNU General Public License is intended to guarantee your freedom to share and change free software--to make sure the software is free for all its users. This General Public License applies to most of the Free Software Foundation's software and to any other program whose authors commit to using it. (Some other Free Software Foundation software is covered by the GNU Lesser General Public License instead.) You can apply it to your programs, too. When we speak of free software, we are referring to freedom, not price. Our General Public Licenses are designed to make sure that you have the freedom to distribute copies of free software (and charge for this service if you wish), that you receive source code or can get it if you want it, that you can change the software or use pieces of it in new free programs; and that you know you can do these things. To protect your rights, we need to make restrictions that forbid anyone to deny you these rights or to ask you to surrender the rights. These restrictions translate to certain responsibilities for you if you distribute copies of the software, or if you modify it. For example, if you distribute copies of such a program, whether gratis or for a fee, you must give the recipients all the rights that you have. You must make sure that they, too, receive or can get the source code. And you must show them these terms so they know their rights. We protect your rights with two steps: (1) copyright the software, and (2) offer you this license which gives you legal permission to copy, distribute and/or modify the software. Also, for each author's protection and ours, we want to make certain that everyone understands that there is no warranty for this free software. If the software is modified by someone else and passed on, we want its recipients to know that what they have is not the original, so that any problems introduced by others will not reflect on the original authors' reputations. Finally, any free program is threatened constantly by software patents. We wish to avoid the danger that redistributors of a free program will individually obtain patent licenses, in effect making the program proprietary. To prevent this, we have made it clear that any patent must be licensed for everyone's free use or not licensed at all. The precise terms and conditions for copying, distribution and modification follow. TERMS AND CONDITIONS FOR COPYING, DISTRIBUTION AND MODIFICATION 0. This License applies to any program or other work which contains a notice placed by the copyright holder saying it may be distributed under the terms of this General Public License. The "Program", below, refers to any such program or work, and a "work based on the Program" means either the Program or any derivative work under copyright law: that is to say, a work containing the Program or a portion of it, either verbatim or with modifications and/or translated into another language. (Hereinafter, translation is included without limitation in the term "modification".) Each licensee is addressed as "you". Activities other than copying, distribution and modification are not covered by this License; they are outside its scope. The act of running the Program is not restricted, and the output from the Program is covered only if its contents constitute a work based on the Program (independent of having been made by running the Program). Whether that is true depends on what the Program does. 1. You may copy and distribute verbatim copies of the Program's source code as you receive it, in any medium, provided that you conspicuously and appropriately publish on each copy an appropriate copyright notice and disclaimer of warranty; keep intact all the notices that refer to this License and to the absence of any warranty; and give any other recipients of the Program a copy of this License along with the Program. You may charge a fee for the physical act of transferring a copy, and you may at your option offer warranty protection in exchange for a fee. 2. You may modify your copy or copies of the Program or any portion of it, thus forming a work based on the Program, and copy and distribute such modifications or work under the terms of Section 1 above, provided that you also meet all of these conditions: a) You must cause the modified files to carry prominent notices stating that you changed the files and the date of any change. b) You must cause any work that you distribute or publish, that in whole or in part contains or is derived from the Program or any part thereof, to be licensed as a whole at no charge to all third parties under the terms of this License. c) If the modified program normally reads commands interactively when run, you must cause it, when started running for such interactive use in the most ordinary way, to print or display an announcement including an appropriate copyright notice and a notice that there is no warranty (or else, saying that you provide a warranty) and that users may redistribute the program under these conditions, and telling the user how to view a copy of this License. (Exception: if the Program itself is interactive but does not normally print such an announcement, your work based on the Program is not required to print an announcement.) These requirements apply to the modified work as a whole. If identifiable sections of that work are not derived from the Program, and can be reasonably considered independent and separate works in themselves, then this License, and its terms, do not apply to those sections when you distribute them as separate works. But when you distribute the same sections as part of a whole which is a work based on the Program, the distribution of the whole must be on the terms of this License, whose permissions for other licensees extend to the entire whole, and thus to each and every part regardless of who wrote it. Thus, it is not the intent of this section to claim rights or contest your rights to work written entirely by you; rather, the intent is to exercise the right to control the distribution of derivative or collective works based on the Program. In addition, mere aggregation of another work not based on the Program with the Program (or with a work based on the Program) on a volume of a storage or distribution medium does not bring the other work under the scope of this License. 3. You may copy and distribute the Program (or a work based on it, under Section 2) in object code or executable form under the terms of Sections 1 and 2 above provided that you also do one of the following: a) Accompany it with the complete corresponding machine-readable source code, which must be distributed under the terms of Sections 1 and 2 above on a medium customarily used for software interchange; or, b) Accompany it with a written offer, valid for at least three years, to give any third party, for a charge no more than your cost of physically performing source distribution, a complete machine-readable copy of the corresponding source code, to be distributed under the terms of Sections 1 and 2 above on a medium customarily used for software interchange; or, c) Accompany it with the information you received as to the offer to distribute corresponding source code. (This alternative is allowed only for noncommercial distribution and only if you received the program in object code or executable form with such an offer, in accord with Subsection b above.) The source code for a work means the preferred form of the work for making modifications to it. For an executable work, complete source code means all the source code for all modules it contains, plus any associated interface definition files, plus the scripts used to control compilation and installation of the executable. However, as a special exception, the source code distributed need not include anything that is normally distributed (in either source or binary form) with the major components (compiler, kernel, and so on) of the operating system on which the executable runs, unless that component itself accompanies the executable. If distribution of executable or object code is made by offering access to copy from a designated place, then offering equivalent access to copy the source code from the same place counts as distribution of the source code, even though third parties are not compelled to copy the source along with the object code. 4. You may not copy, modify, sublicense, or distribute the Program except as expressly provided under this License. Any attempt otherwise to copy, modify, sublicense or distribute the Program is void, and will automatically terminate your rights under this License. However, parties who have received copies, or rights, from you under this License will not have their licenses terminated so long as such parties remain in full compliance. 5. You are not required to accept this License, since you have not signed it. However, nothing else grants you permission to modify or distribute the Program or its derivative works. These actions are prohibited by law if you do not accept this License. Therefore, by modifying or distributing the Program (or any work based on the Program), you indicate your acceptance of this License to do so, and all its terms and conditions for copying, distributing or modifying the Program or works based on it. 6. Each time you redistribute the Program (or any work based on the Program), the recipient automatically receives a license from the original licensor to copy, distribute or modify the Program subject to these terms and conditions. You may not impose any further restrictions on the recipients' exercise of the rights granted herein. You are not responsible for enforcing compliance by third parties to this License. 7. If, as a consequence of a court judgment or allegation of patent infringement or for any other reason (not limited to patent issues), conditions are imposed on you (whether by court order, agreement or otherwise) that contradict the conditions of this License, they do not excuse you from the conditions of this License. If you cannot distribute so as to satisfy simultaneously your obligations under this License and any other pertinent obligations, then as a consequence you may not distribute the Program at all. For example, if a patent license would not permit royalty-free redistribution of the Program by all those who receive copies directly or indirectly through you, then the only way you could satisfy both it and this License would be to refrain entirely from distribution of the Program. If any portion of this section is held invalid or unenforceable under any particular circumstance, the balance of the section is intended to apply and the section as a whole is intended to apply in other circumstances. It is not the purpose of this section to induce you to infringe any patents or other property right claims or to contest validity of any such claims; this section has the sole purpose of protecting the integrity of the free software distribution system, which is implemented by public license practices. Many people have made generous contributions to the wide range of software distributed through that system in reliance on consistent application of that system; it is up to the author/donor to decide if he or she is willing to distribute software through any other system and a licensee cannot impose that choice. This section is intended to make thoroughly clear what is believed to be a consequence of the rest of this License. 8. If the distribution and/or use of the Program is restricted in certain countries either by patents or by copyrighted interfaces, the original copyright holder who places the Program under this License may add an explicit geographical distribution limitation excluding those countries, so that distribution is permitted only in or among countries not thus excluded. In such case, this License incorporates the limitation as if written in the body of this License. 9. The Free Software Foundation may publish revised and/or new versions of the General Public License from time to time. Such new versions will be similar in spirit to the present version, but may differ in detail to address new problems or concerns. Each version is given a distinguishing version number. If the Program specifies a version number of this License which applies to it and "any later version", you have the option of following the terms and conditions either of that version or of any later version published by the Free Software Foundation. If the Program does not specify a version number of this License, you may choose any version ever published by the Free Software Foundation. 10. If you wish to incorporate parts of the Program into other free programs whose distribution conditions are different, write to the author to ask for permission. For software which is copyrighted by the Free Software Foundation, write to the Free Software Foundation; we sometimes make exceptions for this. Our decision will be guided by the two goals of preserving the free status of all derivatives of our free software and of promoting the sharing and reuse of software generally. NO WARRANTY 11. BECAUSE THE PROGRAM IS LICENSED FREE OF CHARGE, THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF ALL NECESSARY SERVICING, REPAIR OR CORRECTION. 12. IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MAY MODIFY AND/OR REDISTRIBUTE THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS), EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. END OF TERMS AND CONDITIONS