Database info
Version 1.1
|
commonswiki_p
|
enwiki_p
|
u_alexz_p
|
u_dispenser_p
|
u_lvova_golem_p
|
u_mashiah_golem_p
|
u_mzmcbride_climax_p
|
u_vvv_golem_svwiki_p
|
| abuse_filter | |
|---|---|
| af_id | bigint(20) unsigned not null default '0' |
| af_pattern | blob not null |
| af_user | bigint(20) unsigned not null default '0' |
| af_user_text | varbinary(255) not null |
| af_timestamp | varbinary(14) not null |
| af_enabled | tinyint(1) not null default '1' |
| af_comments | blob |
| af_public_comments | tinyblob |
| af_hidden | tinyint(1) not null default '0' |
| af_hit_count | bigint(20) not null default '0' |
| af_throttled | tinyint(1) not null default '0' |
| af_deleted | tinyint(1) not null default '0' |
| af_actions | varbinary(255) not null |
| af_global | tinyint(1) not null default '0' |
| abuse_filter_history | |
|---|---|
| afh_id | bigint(20) unsigned not null default '0' |
| afh_filter | bigint(20) unsigned not null default '0' |
| afh_user | bigint(20) unsigned not null default '0' |
| afh_user_text | varbinary(255) not null |
| afh_timestamp | varbinary(14) not null |
| afh_pattern | blob not null |
| afh_comments | blob not null |
| afh_flags | tinyblob not null |
| afh_public_comments | tinyblob |
| afh_actions | blob |
| afh_deleted | tinyint(1) not null default '0' |
| afh_changed_fields | varbinary(255) not null |
| abuse_filter_log | |
|---|---|
| afl_id | bigint(20) unsigned not null default '0' |
| afl_filter | varbinary(64) not null |
| afl_user | bigint(20) unsigned not null default '0' |
| afl_user_text | varbinary(255) not null |
| afl_action | varbinary(255) not null |
| afl_actions | varbinary(255) not null |
| afl_var_dump | blob not null |
| afl_timestamp | varbinary(14) not null |
| afl_namespace | tinyint(4) not null default '0' |
| afl_title | varbinary(255) not null |
| archive | |
|---|---|
| ar_namespace | int(11) not null default '0' |
| ar_title | varbinary(255) not null |
| ar_user | int(5) unsigned not null default '0' |
| ar_user_text | varbinary(255) not null |
| ar_timestamp | varbinary(14) not null |
| ar_minor_edit | tinyint(1) not null default '0' |
| ar_flags | tinyblob not null |
| ar_rev_id | int(8) unsigned |
| ar_len | int(8) unsigned |
| ar_page_id | int(10) unsigned |
| ar_parent_id | int(10) unsigned |
| category | |
|---|---|
| cat_id | int(10) unsigned not null default '0' |
| cat_title | varbinary(255) not null |
| cat_pages | int(11) not null default '0' |
| cat_subcats | int(11) not null default '0' |
| cat_files | int(11) not null default '0' |
| cat_hidden | tinyint(1) unsigned not null default '0' |
| categorylinks | |
|---|---|
| cl_from | int(8) unsigned not null default '0' |
| cl_to | varbinary(255) not null |
| cl_sortkey | varbinary(86) not null |
| cl_timestamp | timestamp not null default '0000-00-00 00:00:00' |
| change_tag | |
|---|---|
| ct_rc_id | int(11) |
| ct_log_id | int(11) |
| ct_rev_id | int(11) |
| ct_tag | varbinary(255) not null |
| ct_params | blob |
| click_tracking | |
|---|---|
| action_time | varbinary(14) not null |
| is_logged_in | tinyint(4) not null default '0' |
| user_total_contribs_log | double(17,0) |
| user_contribs_span1_log | double(17,0) |
| user_contribs_span2_log | double(17,0) |
| user_contribs_span3_log | double(17,0) |
| namespace | int(11) not null default '0' |
| event_id | int(11) not null default '0' |
| click_tracking_events | |
|---|---|
| event_name | varbinary(255) |
| id | int(11) not null default '0' |
| cur | |
|---|---|
| cur_id | int(8) unsigned not null default '0' |
| cur_namespace | tinyint(2) unsigned not null default '0' |
| cur_title | varbinary(255) not null |
| cur_text | mediumblob not null |
| cur_comment | tinyblob not null |
| cur_user | int(5) unsigned not null default '0' |
| cur_user_text | varbinary(255) not null |
| cur_timestamp | varbinary(14) not null |
| cur_restrictions | tinyblob not null |
| cur_counter | bigint(20) unsigned not null default '0' |
| cur_is_redirect | tinyint(1) unsigned not null default '0' |
| cur_minor_edit | tinyint(1) unsigned not null default '0' |
| cur_is_new | tinyint(1) unsigned not null default '0' |
| cur_random | double unsigned not null default '0' |
| inverse_timestamp | varbinary(14) not null |
| cur_touched | varbinary(14) not null |
| externallinks | |
|---|---|
| el_from | int(8) unsigned not null default '0' |
| el_to | blob not null |
| el_index | blob not null |
| filearchive | |
|---|---|
| fa_id | int(11) not null default '0' |
| fa_name | varbinary(255) not null |
| fa_archive_name | varbinary(255) |
| fa_storage_group | varbinary(16) |
| fa_storage_key | varbinary(64) |
| fa_deleted_user | int(11) |
| fa_deleted_timestamp | varbinary(14) |
| fa_deleted_reason | blob |
| fa_size | int(8) unsigned default '0' |
| fa_width | int(5) default '0' |
| fa_height | int(5) default '0' |
| fa_metadata | mediumblob |
| fa_bits | int(3) default '0' |
| fa_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') |
| fa_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') default 'unknown' |
| fa_minor_mime | varbinary(32) default 'unknown' |
| fa_user | int(5) unsigned default '0' |
| fa_user_text | varbinary(255) |
| fa_timestamp | varbinary(14) |
| fa_deleted | tinyint(1) unsigned not null default '0' |
| hitcounter | |
|---|---|
| hc_id | int(10) unsigned not null default '0' |
| image | |
|---|---|
| img_name | varbinary(255) not null |
| img_size | int(8) unsigned not null default '0' |
| img_width | int(5) not null default '0' |
| img_height | int(5) not null default '0' |
| img_metadata | mediumblob not null |
| img_bits | int(3) not null default '0' |
| img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') |
| img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') not null default 'unknown' |
| img_minor_mime | varbinary(32) not null default 'unknown' |
| img_description | tinyblob not null |
| img_user | int(5) unsigned not null default '0' |
| img_user_text | varbinary(255) not null |
| img_timestamp | varbinary(14) not null |
| img_sha1 | varbinary(32) not null |
| imagelinks | |
|---|---|
| il_from | int(8) unsigned not null default '0' |
| il_to | varbinary(255) not null |
| interwiki | |
|---|---|
| iw_prefix | varbinary(32) not null |
| iw_url | varbinary(127) not null |
| iw_local | tinyint(1) not null default '0' |
| iw_trans | tinyint(1) not null default '0' |
| ipblocks | |
|---|---|
| ipb_id | int(8) not null default '0' |
| ipb_address | varbinary(255) not null |
| ipb_user | int(8) unsigned not null default '0' |
| ipb_by | int(8) unsigned not null default '0' |
| ipb_reason | tinyblob not null |
| ipb_timestamp | varbinary(14) not null |
| ipb_auto | tinyint(1) not null default '0' |
| ipb_anon_only | tinyint(1) not null default '0' |
| ipb_create_account | tinyint(1) not null default '1' |
| ipb_expiry | varbinary(14) not null |
| ipb_range_start | varbinary(255) not null |
| ipb_range_end | varbinary(255) not null |
| ipb_enable_autoblock | tinyint(1) not null default '1' |
| ipb_deleted | tinyint(1) not null default '0' |
| ipb_block_email | tinyint(1) not null default '0' |
| ipb_by_text | varbinary(255) not null |
| langlinks | |
|---|---|
| ll_from | int(8) unsigned not null default '0' |
| ll_lang | varbinary(10) not null |
| ll_title | varbinary(255) not null |
| logging | |
|---|---|
| log_id | int(10) unsigned not null default '0' |
| log_type | varbinary(32) not null |
| log_action | varbinary(32) not null |
| log_timestamp | varbinary(14) not null default '19700101000000' |
| log_user | int(10) unsigned not null default '0' |
| log_namespace | int(11) not null default '0' |
| log_deleted | tinyint(3) unsigned not null default '0' |
| log_title | varbinary(255) not null |
| log_comment | varbinary(255) not null |
| log_params | longblob not null |
| logging_ts_alternative | |
|---|---|
| log_id | int(10) unsigned not null default '0' |
| log_type | varbinary(32) not null |
| log_action | varbinary(32) not null |
| log_timestamp | varbinary(14) not null default '19700101000000' |
| log_user | int(10) unsigned not null default '0' |
| log_namespace | int(11) not null default '0' |
| log_title | varbinary(255) not null |
| log_comment | varbinary(255) not null |
| log_params | blob not null |
| log_deleted | tinyint(3) unsigned not null default '0' |
| log_user_text | varbinary(255) not null |
| log_page | int(10) unsigned |
| math | |
|---|---|
| math_inputhash | varbinary(16) not null |
| math_outputhash | varbinary(16) not null |
| math_html_conservativeness | tinyint(1) not null default '0' |
| math_html | blob |
| math_mathml | blob |
| oldimage | |
|---|---|
| oi_name | varbinary(255) not null |
| oi_archive_name | varbinary(255) not null |
| oi_size | int(8) unsigned not null default '0' |
| oi_width | int(5) not null default '0' |
| oi_height | int(5) not null default '0' |
| oi_bits | int(3) not null default '0' |
| oi_description | tinyblob not null |
| oi_user | int(5) unsigned not null default '0' |
| oi_user_text | varbinary(255) not null |
| oi_timestamp | varbinary(14) not null |
| oi_metadata | mediumblob not null |
| oi_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') |
| oi_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') not null default 'unknown' |
| oi_minor_mime | varbinary(32) not null default 'unknown' |
| oi_deleted | tinyint(3) unsigned not null default '0' |
| oi_sha1 | varbinary(32) not null |
| page | |
|---|---|
| page_id | int(8) unsigned not null default '0' |
| page_namespace | int(11) not null default '0' |
| page_title | varbinary(255) not null |
| page_restrictions | tinyblob not null |
| page_counter | bigint(20) unsigned not null default '0' |
| page_is_redirect | tinyint(1) unsigned not null default '0' |
| page_is_new | tinyint(1) unsigned not null default '0' |
| page_random | double unsigned not null default '0' |
| page_touched | varbinary(14) not null |
| page_latest | int(8) unsigned not null default '0' |
| page_len | int(8) unsigned not null default '0' |
| page_props | |
|---|---|
| pp_page | int(11) not null default '0' |
| pp_propname | varbinary(60) not null |
| pp_value | blob not null |
| page_restrictions | |
|---|---|
| pr_page | int(8) not null default '0' |
| pr_type | varbinary(255) not null |
| pr_level | varbinary(255) not null |
| pr_cascade | tinyint(4) not null default '0' |
| pr_user | int(8) |
| pr_expiry | varbinary(14) |
| pr_id | int(10) unsigned not null default '0' |
| pagelinks | |
|---|---|
| pl_from | int(8) unsigned not null default '0' |
| pl_namespace | int(11) not null default '0' |
| pl_title | varbinary(255) not null |
| prefstats | |
|---|---|
| ts_ps_user_saltenhash | char(50) |
| ps_pref | varbinary(32) not null |
| ps_value | blob not null |
| ps_start | varbinary(14) not null |
| ps_end | varbinary(14) |
| ps_duration | int(10) unsigned |
| protected_titles | |
|---|---|
| pt_namespace | int(11) not null default '0' |
| pt_title | varbinary(255) not null |
| pt_user | int(10) unsigned not null default '0' |
| pt_reason | tinyblob |
| pt_timestamp | varbinary(14) not null |
| pt_expiry | varbinary(14) not null |
| pt_create_perm | varbinary(60) not null |
| recentchanges | |
|---|---|
| rc_id | int(8) not null default '0' |
| rc_timestamp | varbinary(14) not null |
| rc_cur_time | varbinary(14) not null |
| rc_user | int(10) unsigned not null default '0' |
| rc_user_text | varbinary(255) not null |
| rc_namespace | int(11) not null default '0' |
| rc_title | varbinary(255) not null |
| rc_comment | varbinary(255) not null |
| rc_minor | tinyint(3) unsigned not null default '0' |
| rc_bot | tinyint(3) unsigned not null default '0' |
| rc_new | tinyint(3) unsigned not null default '0' |
| rc_cur_id | int(10) unsigned not null default '0' |
| rc_this_oldid | int(10) unsigned not null default '0' |
| rc_last_oldid | int(10) unsigned not null default '0' |
| rc_type | tinyint(3) unsigned not null default '0' |
| rc_moved_to_ns | tinyint(3) unsigned not null default '0' |
| rc_moved_to_title | varbinary(255) not null |
| rc_patrolled | tinyint(3) unsigned not null default '0' |
| rc_old_len | int(10) |
| rc_new_len | int(10) |
| rc_deleted | tinyint(1) unsigned not null default '0' |
| rc_logid | int(10) unsigned not null default '0' |
| rc_log_type | varbinary(255) |
| rc_log_action | varbinary(255) |
| rc_ip | char(0) not null |
| rc_params | blob not null |
| redirect | |
|---|---|
| rd_from | int(8) unsigned not null default '0' |
| rd_namespace | int(11) not null default '0' |
| rd_title | varbinary(255) not null |
| revision | |
|---|---|
| rev_id | int(8) unsigned not null default '0' |
| rev_page | int(8) unsigned not null default '0' |
| rev_text_id | int(8) unsigned not null default '0' |
| rev_comment | varbinary(255) |
| rev_user | int(5) unsigned not null default '0' |
| rev_user_text | varbinary(255) not null |
| rev_timestamp | varbinary(14) not null |
| rev_minor_edit | tinyint(1) unsigned not null default '0' |
| rev_deleted | tinyint(1) unsigned not null default '0' |
| rev_len | int(8) unsigned |
| rev_parent_id | int(8) unsigned |
| securepoll_elections | |
|---|---|
| el_entity | int(11) not null default '0' |
| el_title | varbinary(255) not null |
| el_ballot | varbinary(32) not null |
| el_tally | varbinary(32) not null |
| el_primary_lang | varbinary(32) not null |
| el_start_date | varbinary(14) |
| el_end_date | varbinary(14) |
| el_auth_type | varbinary(32) not null |
| securepoll_entity | |
|---|---|
| en_id | int(11) not null default '0' |
| en_type | varbinary(32) not null |
| securepoll_msgs | |
|---|---|
| msg_entity | int(11) not null default '0' |
| msg_lang | varbinary(32) not null |
| msg_key | varbinary(32) not null |
| msg_text | mediumblob not null |
| securepoll_options | |
|---|---|
| op_entity | int(11) not null default '0' |
| op_election | int(11) not null default '0' |
| op_question | int(11) not null default '0' |
| securepoll_properties | |
|---|---|
| pr_entity | int(11) not null default '0' |
| pr_key | varbinary(32) not null |
| pr_value | mediumblob not null |
| securepoll_questions | |
|---|---|
| qu_entity | int(11) not null default '0' |
| qu_election | int(11) not null default '0' |
| qu_index | int(11) not null default '0' |
| securepoll_votes | |
|---|---|
| vote_id | int(11) not null default '0' |
| vote_election | int(11) not null default '0' |
| vote_voter_domain | varbinary(32) not null |
| vote_struck | tinyint(4) not null default '0' |
| vote_timestamp | varbinary(14) not null |
| site_stats | |
|---|---|
| ss_row_id | int(8) unsigned not null default '0' |
| ss_total_views | bigint(20) unsigned default '0' |
| ss_total_edits | bigint(20) unsigned default '0' |
| ss_good_articles | bigint(20) unsigned default '0' |
| ss_total_pages | bigint(20) default '-1' |
| ss_users | bigint(20) default '-1' |
| ss_admins | int(10) default '-1' |
| ss_images | int(10) default '0' |
| ss_active_users | bigint(20) default '-1' |
| spoofuser | |
|---|---|
| su_name | varbinary(255) not null |
| su_normalized | varbinary(255) |
| su_legal | tinyint(1) |
| su_error | blob |
| tag_summary | |
|---|---|
| ts_rc_id | int(11) |
| ts_log_id | int(11) |
| ts_rev_id | int(11) |
| ts_tags | blob not null |
| templatelinks | |
|---|---|
| tl_from | int(8) unsigned not null default '0' |
| tl_namespace | int(11) not null default '0' |
| tl_title | varbinary(255) not null |
| text | |
|---|---|
| old_id | int(8) unsigned not null default '0' |
| old_text | mediumblob not null |
| old_flags | tinyblob not null |
| updates | |
|---|---|
| up_page | int(10) unsigned not null default '0' |
| up_action | enum('modify','create','delete') not null default 'modify' |
| up_timestamp | binary(14) not null default ' ' |
| up_sequence | int(10) unsigned not null default '0' |
| user | |
|---|---|
| user_id | int(5) unsigned not null default '0' |
| user_name | varbinary(255) not null |
| user_registration | varbinary(14) |
| user_editcount | int(11) |
| user_daily_contribs | |
|---|---|
| user_id | int(11) not null default '0' |
| day | date not null default '0000-00-00' |
| contribs | int(11) not null default '0' |
| user_groups | |
|---|---|
| ug_user | int(5) unsigned not null default '0' |
| ug_group | varbinary(16) not null |
| user_ids | |
|---|---|
| user_name | varbinary(255) not null |
| user_id | int(5) unsigned not null default '0' |
| valid_tag | |
|---|---|
| vt_tag | varbinary(255) not null |
| watchlist | |
|---|---|
| wl_namespace | int(11) not null default '0' |
| wl_title | varbinary(255) not null |