r47329 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r47328‎ | r47329 | r47330 >
Date:18:17, 16 February 2009
Author:malafaya
Status:deferred
Tags:
Comment:
handy "analyze table *" script for OW database
Modified paths:
  • /trunk/extensions/Wikidata/Database+scripts/Convenience/analyzeTables.sql (added) (history)

Diff [purge]

Index: trunk/extensions/Wikidata/Database scripts/Convenience/analyzeTables.sql
@@ -0,0 +1,104 @@
 2+analyze table archive;
 3+analyze table categorylinks;
 4+analyze table externallinks;
 5+analyze table filearchive;
 6+analyze table hitcounter;
 7+analyze table image;
 8+analyze table imagelinks;
 9+analyze table interwiki;
 10+analyze table ipblocks;
 11+analyze table ipblocks_old;
 12+analyze table job;
 13+analyze table langlinks;
 14+analyze table language;
 15+analyze table language_names;
 16+analyze table logging;
 17+analyze table math;
 18+analyze table namespace;
 19+analyze table namespace_names;
 20+analyze table objectcache;
 21+analyze table oldimage;
 22+analyze table page;
 23+analyze table page_backup_jul_07;
 24+analyze table page_restrictions;
 25+analyze table pagelinks;
 26+analyze table querycache;
 27+analyze table querycache_info;
 28+analyze table querycachetwo;
 29+analyze table recentchanges;
 30+analyze table redirect;
 31+analyze table revision;
 32+analyze table script_log;
 33+analyze table searchindex;
 34+analyze table site_stats;
 35+analyze table sp_alt_meaningtexts;
 36+analyze table sp_bootstrapped_defined_meanings;
 37+analyze table sp_class_attributes;
 38+analyze table sp_class_membership;
 39+analyze table sp_collection;
 40+analyze table sp_collection_contents;
 41+analyze table sp_collection_language;
 42+analyze table sp_defined_meaning;
 43+analyze table sp_expression;
 44+analyze table sp_meaning_relations;
 45+analyze table sp_objects;
 46+analyze table sp_option_attribute_options;
 47+analyze table sp_option_attribute_values;
 48+analyze table sp_script_log;
 49+analyze table sp_syntrans;
 50+analyze table sp_text;
 51+analyze table sp_text_attribute_values;
 52+analyze table sp_transactions;
 53+analyze table sp_translated_content;
 54+analyze table sp_translated_content_attribute_values;
 55+analyze table sp_url_attribute_values;
 56+analyze table templatelinks;
 57+analyze table text;
 58+analyze table trackbacks;
 59+analyze table transcache;
 60+analyze table umls_alt_meaningtexts;
 61+analyze table umls_bootstrapped_defined_meanings;
 62+analyze table umls_class_attributes;
 63+analyze table umls_class_membership;
 64+analyze table umls_collection;
 65+analyze table umls_collection_contents;
 66+analyze table umls_collection_language;
 67+analyze table umls_defined_meaning;
 68+analyze table umls_expression;
 69+analyze table umls_meaning_relations;
 70+analyze table umls_objects;
 71+analyze table umls_option_attribute_options;
 72+analyze table umls_option_attribute_values;
 73+analyze table umls_script_log;
 74+analyze table umls_syntrans;
 75+analyze table umls_text;
 76+analyze table umls_text_attribute_values;
 77+analyze table umls_transactions;
 78+analyze table umls_translated_content;
 79+analyze table umls_translated_content_attribute_values;
 80+analyze table umls_url_attribute_values;
 81+analyze table user;
 82+analyze table user_groups;
 83+analyze table user_newtalk;
 84+analyze table uw_alt_meaningtexts;
 85+analyze table uw_bootstrapped_defined_meanings;
 86+analyze table uw_class_attributes;
 87+analyze table uw_class_membership;
 88+analyze table uw_collection;
 89+analyze table uw_collection_contents;
 90+analyze table uw_collection_language;
 91+analyze table uw_defined_meaning;
 92+analyze table uw_expression;
 93+analyze table uw_meaning_relations;
 94+analyze table uw_objects;
 95+analyze table uw_option_attribute_options;
 96+analyze table uw_option_attribute_values;
 97+analyze table uw_syntrans;
 98+analyze table uw_text;
 99+analyze table uw_text_attribute_values;
 100+analyze table uw_transactions;
 101+analyze table uw_translated_content;
 102+analyze table uw_translated_content_attribute_values;
 103+analyze table uw_url_attribute_values;
 104+analyze table watchlist;
 105+analyze table wikidata_sets;
Property changes on: trunk/extensions/Wikidata/Database scripts/Convenience/analyzeTables.sql
___________________________________________________________________
Name: svn:eol-style
1106 + native

Status & tagging log