User:Polygnotus/Data/Quarry

SHOW TABLES FROM enwiki_p;

abuse_filter abuse_filter_action abuse_filter_history actor actor_archive actor_block actor_filearchive actor_image actor_ipblocks actor_logging actor_oldimage actor_recentchanges actor_revision actor_user archive archive_compat archive_userindex babel block block_target block_target_ipindex category categorylinks change_tag change_tag_def collation comment comment_block comment_filearchive comment_image comment_ipblocks comment_logging comment_oldimage comment_protected_titles comment_recentchanges comment_revision content content_models existencelinks externallinks file filearchive filearchive_compat filearchive_userindex filerevision filetypes flaggedpage_config flaggedpages flaggedrevs flaggedrevs_promote flaggedrevs_statistics flaggedrevs_tracking geo_tags global_block_whitelist image image_compat imagelinks interwiki ip_changes ipblocks_restrictions iwlinks langlinks linktarget linter logging logging_compat logging_logindex logging_userindex oldimage oldimage_compat oldimage_userindex ores_classification ores_model page page_assessments page_assessments_projects page_compat page_props page_restrictions pagelinks pagetriage_page pagetriage_page_tags pagetriage_tags protected_titles protected_titles_compat recentchanges recentchanges_compat recentchanges_userindex redirect revision revision_compat revision_userindex site_identifiers site_stats sites slot_roles slots templatelinks transcode updatelog user user_autocreate_serial user_former_groups user_groups user_properties user_properties_anon wbc_entity_usage wikilove_log

DESCRIBE page; DESCRIBE categorylinks; DESCRIBE revision;


Resultset 1 (12 rows) Search: Field Type Null Key Default Extra Field

Type

Null

Key

Default

Extra page_id int(8) unsigned NO 0 page_namespace int(11) NO 0 page_title varbinary(255) NO page_is_redirect tinyint(1) unsigned NO 0 page_is_new tinyint(1) unsigned NO 0 page_random double unsigned NO 0 page_touched binary(14) NO page_links_updated binary(14) YES page_latest int(8) unsigned NO 0 page_len int(8) unsigned NO 0 page_content_model varbinary(32) YES page_lang varbinary(35) YES Showing 1 to 12 of 12 entries Resultset 2 (9 rows) Search: Field Type Null Key Default Extra Field

Type

Null

Key

Default

Extra cl_from int(8) unsigned NO 0 cl_to varbinary(255) YES cl_sortkey varbinary(230) NO cl_timestamp timestamp NO current_timestamp() cl_sortkey_prefix varbinary(255) NO cl_collation varbinary(64) YES cl_type enum('page','subcat','file') NO page cl_collation_id smallint(5) unsigned NO 0 cl_target_id bigint(20) unsigned NO Showing 1 to 9 of 9 entries Resultset (9 rows) Search: Field Type Null Key Default Extra Field

Type

Null

Key

Default

Extra rev_id bigint(20) unsigned NO 0 rev_page int(8) unsigned NO 0 rev_comment_id bigint(20) unsigned YES rev_actor bigint(20) unsigned YES rev_timestamp binary(14) NO rev_minor_edit tinyint(1) unsigned NO 0 rev_deleted tinyint(1) unsigned NO 0 rev_len int(10) unsigned YES rev_parent_id bigint(20) unsigned YES Showing 1 to 9 of 9 entries

Content Disclaimer

Informasi ini disarikan dari Wikipedia dan disajikan kembali untuk tujuan edukasi. Konten tersedia di bawah lisensi CC BY-SA 3.0. Kami tidak bertanggung jawab atas ketidakakuratan data yang bersumber dari kontribusi publik tersebut.

  1. The information displayed on this website is sourced in part or in whole from Wikipedia and has been adapted for the purpose of restating it. We strive to provide accurate and relevant information, however:
  2. There is no guarantee of absolute accuracy. Wikipedia is an open, collaborative project that can be edited by anyone, so information is subject to change.
  3. It is not intended to constitute professional advice. The content displayed is for informational and educational purposes only. For important decisions (e.g., medical, legal, or financial), please consult a professional.
  4. Content copyright. Wikipedia is licensed under the Creative Commons Attribution-ShareAlike License (CC BY-SA). This means that content may be reused with appropriate attribution and shared under a similar license.
  5. Responsible use. Any risk arising from the use of information from this website is entirely the responsibility of the user.