| Index: trunk/extensions/Wikidata/Database scripts/Convenience/Create uw_translated_content indices.sql |
| — | — | @@ -0,0 +1,8 @@ |
| | 2 | +ALTER TABLE `%dc%_translated_content`
|
| | 3 | + ADD INDEX `versioned_end_translated_content` (`remove_transaction_id`, `translated_content_id`, `language_id`, `text_id`),
|
| | 4 | + ADD INDEX `versioned_end_text` (`remove_transaction_id`, `text_id`, `translated_content_id`, `language_id`),
|
| | 5 | + ADD INDEX `versioned_start_translated_content` (`add_transaction_id`, `translated_content_id`, `language_id`, `text_id`),
|
| | 6 | + ADD INDEX `versioned_start_text` (`add_transaction_id`, `text_id`, `translated_content_id`, `language_id`);
|
| | 7 | +
|
| | 8 | +-- ADD INDEX `unversioned_translated_content` (`translated_content_id`, `language_id`, `text_id`),
|
| | 9 | +-- ADD INDEX `unversioned_text` (`text_id`, `translated_content_id`, `language_id`); |
| \ No newline at end of file |
| Index: trunk/extensions/Wikidata/Database scripts/Convenience/Create uw_transactions indices.sql |
| — | — | @@ -0,0 +1,2 @@ |
| | 2 | +ALTER TABLE `%dc%_transactions`
|
| | 3 | + ADD INDEX `user` (`user_id`, `transaction_id`);
|