| Index: trunk/extensions/Wikidata/Database scripts/Incremental/30 - Change table engine.sql |
| — | — | @@ -1,66 +1,42 @@ |
| 2 | 2 | -- These tables can exist within each dataset.
|
| 3 | | -ALTER TABLE `archive` ENGINE = InnoDB;
|
| 4 | | -ALTER TABLE `categorylinks` ENGINE = InnoDB;
|
| 5 | | -ALTER TABLE `externallinks` ENGINE = InnoDB;
|
| 6 | | -ALTER TABLE `filearchive` ENGINE = InnoDB;
|
| 7 | | -ALTER TABLE `image` ENGINE = InnoDB;
|
| 8 | | -ALTER TABLE `imagelinks` ENGINE = InnoDB;
|
| 9 | | -ALTER TABLE `interwiki` ENGINE = InnoDB;
|
| 10 | | -ALTER TABLE `ipblocks` ENGINE = InnoDB;
|
| 11 | | -ALTER TABLE `ipblocks_old` ENGINE = InnoDB;
|
| 12 | | -ALTER TABLE `job` ENGINE = InnoDB;
|
| 13 | | -ALTER TABLE `langlinks` ENGINE = InnoDB;
|
| 14 | | -ALTER TABLE `language` ENGINE = InnoDB;
|
| 15 | | -ALTER TABLE `language_names` ENGINE = InnoDB;
|
| 16 | | -ALTER TABLE `logging` ENGINE = InnoDB;
|
| 17 | | -ALTER TABLE `math` ENGINE = InnoDB;
|
| 18 | | -ALTER TABLE `namespace` ENGINE = InnoDB;
|
| 19 | | -ALTER TABLE `namespace_names` ENGINE = InnoDB;
|
| 20 | | -ALTER TABLE `objectcache` ENGINE = InnoDB;
|
| 21 | | -ALTER TABLE `objects` ENGINE = InnoDB;
|
| 22 | | -ALTER TABLE `oldimage` ENGINE = InnoDB;
|
| 23 | | -ALTER TABLE `page` ENGINE = InnoDB;
|
| 24 | | -ALTER TABLE `page_restrictions` ENGINE = InnoDB;
|
| 25 | | -ALTER TABLE `pagelinks` ENGINE = InnoDB;
|
| 26 | | -ALTER TABLE `querycache` ENGINE = InnoDB;
|
| 27 | | -ALTER TABLE `querycache_info` ENGINE = InnoDB;
|
| 28 | | -ALTER TABLE `querycachetwo` ENGINE = InnoDB;
|
| 29 | | -ALTER TABLE `recentchanges` ENGINE = InnoDB;
|
| 30 | | -ALTER TABLE `redirect` ENGINE = InnoDB;
|
| 31 | | -ALTER TABLE `revision` ENGINE = InnoDB;
|
| 32 | | -ALTER TABLE `script_log` ENGINE = InnoDB;
|
| 33 | | -ALTER TABLE `site_stats` ENGINE = InnoDB;
|
| 34 | | -ALTER TABLE `templatelinks` ENGINE = InnoDB;
|
| 35 | | -ALTER TABLE `text` ENGINE = InnoDB;
|
| 36 | | -ALTER TABLE `trackbacks` ENGINE = InnoDB;
|
| 37 | | -ALTER TABLE `transcache` ENGINE = InnoDB;
|
| 38 | | -ALTER TABLE `user` ENGINE = InnoDB;
|
| 39 | | -ALTER TABLE `user_groups` ENGINE = InnoDB;
|
| 40 | | -ALTER TABLE `user_newtalk` ENGINE = InnoDB;
|
| 41 | | -ALTER TABLE `uw_alt_meaningtexts` ENGINE = InnoDB;
|
| 42 | | -ALTER TABLE `uw_bootstrapped_defined_meanings` ENGINE = InnoDB;
|
| 43 | | -ALTER TABLE `uw_class_attributes` ENGINE = InnoDB;
|
| 44 | | -ALTER TABLE `uw_class_membership` ENGINE = InnoDB;
|
| 45 | | -ALTER TABLE `uw_collection_contents` ENGINE = InnoDB;
|
| 46 | | -ALTER TABLE `uw_collection_language` ENGINE = InnoDB;
|
| 47 | | -ALTER TABLE `uw_collection_ns` ENGINE = InnoDB;
|
| 48 | | -ALTER TABLE `uw_defined_meaning` ENGINE = InnoDB;
|
| 49 | | -ALTER TABLE `uw_expression_ns` ENGINE = InnoDB;
|
| 50 | | -ALTER TABLE `uw_meaning_relations` ENGINE = InnoDB;
|
| 51 | | -ALTER TABLE `uw_objects` ENGINE = InnoDB;
|
| 52 | | -ALTER TABLE `uw_option_attribute_options` ENGINE = InnoDB;
|
| 53 | | -ALTER TABLE `uw_option_attribute_values` ENGINE = InnoDB;
|
| 54 | | -ALTER TABLE `uw_script_log` ENGINE = InnoDB;
|
| 55 | | -ALTER TABLE `uw_syntrans` ENGINE = InnoDB;
|
| 56 | | -ALTER TABLE `uw_syntrans_relations` ENGINE = InnoDB;
|
| 57 | | -ALTER TABLE `uw_text` ENGINE = InnoDB;
|
| 58 | | -ALTER TABLE `uw_text_attribute_values` ENGINE = InnoDB;
|
| 59 | | -ALTER TABLE `uw_transactions` ENGINE = InnoDB;
|
| 60 | | -ALTER TABLE `uw_translated_content` ENGINE = InnoDB;
|
| 61 | | -ALTER TABLE `uw_translated_content_attribute_values` ENGINE = InnoDB;
|
| 62 | | -ALTER TABLE `uw_url_attribute_values` ENGINE = InnoDB;
|
| 63 | | -ALTER TABLE `validate` ENGINE = InnoDB;
|
| 64 | | -ALTER TABLE `watchlist` ENGINE = InnoDB;
|
| 65 | | -ALTER TABLE `wikidata_sets` ENGINE = InnoDB;
|
| | 3 | +ALTER TABLE `archive` ENGINE = MyISAM;
|
| | 4 | +ALTER TABLE `categorylinks` ENGINE = MyISAM;
|
| | 5 | +ALTER TABLE `externallinks` ENGINE = MyISAM;
|
| | 6 | +ALTER TABLE `filearchive` ENGINE = MyISAM;
|
| | 7 | +ALTER TABLE `image` ENGINE = MyISAM;
|
| | 8 | +ALTER TABLE `imagelinks` ENGINE = MyISAM;
|
| | 9 | +ALTER TABLE `interwiki` ENGINE = MyISAM;
|
| | 10 | +ALTER TABLE `ipblocks` ENGINE = MyISAM;
|
| | 11 | +ALTER TABLE `job` ENGINE = MyISAM;
|
| | 12 | +ALTER TABLE `langlinks` ENGINE = MyISAM;
|
| | 13 | +ALTER TABLE `language` ENGINE = MyISAM;
|
| | 14 | +ALTER TABLE `language_names` ENGINE = MyISAM;
|
| | 15 | +ALTER TABLE `logging` ENGINE = MyISAM;
|
| | 16 | +ALTER TABLE `math` ENGINE = MyISAM;
|
| | 17 | +ALTER TABLE `namespace` ENGINE = MyISAM;
|
| | 18 | +ALTER TABLE `namespace_names` ENGINE = MyISAM;
|
| | 19 | +ALTER TABLE `objectcache` ENGINE = MyISAM;
|
| | 20 | +ALTER TABLE `objects` ENGINE = MyISAM;
|
| | 21 | +ALTER TABLE `oldimage` ENGINE = MyISAM;
|
| | 22 | +ALTER TABLE `page` ENGINE = MyISAM;
|
| | 23 | +ALTER TABLE `page_restrictions` ENGINE = MyISAM;
|
| | 24 | +ALTER TABLE `pagelinks` ENGINE = MyISAM;
|
| | 25 | +ALTER TABLE `querycache` ENGINE = MyISAM;
|
| | 26 | +ALTER TABLE `querycache_info` ENGINE = MyISAM;
|
| | 27 | +ALTER TABLE `querycachetwo` ENGINE = MyISAM;
|
| | 28 | +ALTER TABLE `recentchanges` ENGINE = MyISAM;
|
| | 29 | +ALTER TABLE `redirect` ENGINE = MyISAM;
|
| | 30 | +ALTER TABLE `revision` ENGINE = MyISAM;
|
| | 31 | +ALTER TABLE `script_log` ENGINE = MyISAM;
|
| | 32 | +ALTER TABLE `site_stats` ENGINE = MyISAM;
|
| | 33 | +ALTER TABLE `templatelinks` ENGINE = MyISAM;
|
| | 34 | +ALTER TABLE `text` ENGINE = MyISAM;
|
| | 35 | +ALTER TABLE `trackbacks` ENGINE = MyISAM;
|
| | 36 | +ALTER TABLE `transcache` ENGINE = MyISAM;
|
| | 37 | +ALTER TABLE `user` ENGINE = MyISAM;
|
| | 38 | +ALTER TABLE `user_groups` ENGINE = MyISAM;
|
| | 39 | +ALTER TABLE `user_newtalk` ENGINE = MyISAM;
|
| | 40 | +ALTER TABLE `watchlist` ENGINE = MyISAM;
|
| | 41 | +ALTER TABLE `wikidata_sets` ENGINE = MyISAM;
|
| 66 | 42 |
|
| 67 | | -INSERT INTO `script_log` (`time`, `script_name`, `comment`) VALUES (NOW(), '30 - Change table engine.sql', 'change the engine from MyISAM to INNODB for Wikidata tables '); |
| \ No newline at end of file |
| | 43 | +INSERT INTO `script_log` (`time`, `script_name`, `comment`) VALUES (NOW(), '30 - Change table engine.sql', 'change the engine from MyISAM to MyISAM for Wikidata tables '); |
| \ No newline at end of file |