| Index: trunk/extensions/Wikidata/Database scripts/Convenience/Create uw_collection_ns indices.sql |
| — | — | @@ -1,11 +0,0 @@ |
| 2 | | -ALTER TABLE `%dc%_collection` |
| 3 | | - ADD INDEX `versioned_end_collection` (`remove_transaction_id`, `collection_id`, `collection_mid`), |
| 4 | | - ADD INDEX `versioned_end_collection_meaning` (`remove_transaction_id`, `collection_mid`, `collection_id`), |
| 5 | | - ADD INDEX `versioned_end_collection_type` (`remove_transaction_id`, `collection_type` (4), `collection_id`, `collection_mid`), |
| 6 | | - ADD INDEX `versioned_start_collection` (`add_transaction_id`, `collection_id`, `collection_mid`), |
| 7 | | - ADD INDEX `versioned_start_collection_meaning` (`add_transaction_id`, `collection_mid`, `collection_id`), |
| 8 | | - ADD INDEX `versioned_start_collection_type` (`add_transaction_id`, `collection_type` (4), `collection_id`, `collection_mid`); |
| 9 | | - |
| \ No newline at end of file |
| Index: trunk/extensions/Wikidata/Database scripts/Convenience/Create uw_expression_ns indices.sql |
| — | — | @@ -1,15 +0,0 @@ |
| 2 | | -ALTER TABLE `%dc%_expression` |
| 3 | | - ADD INDEX `versioned_end_expression` (`remove_transaction_id`, `expression_id`, `language_id`), |
| 4 | | - ADD INDEX `versioned_end_language` (`remove_transaction_id`, `language_id`, `expression_id`), |
| 5 | | - ADD INDEX `versioned_end_spelling` (`remove_transaction_id`, `spelling` (255), `expression_id`, `language_id`), |
| 6 | | - ADD INDEX `versioned_start_expression` (`add_transaction_id`, `expression_id`, `language_id`), |
| 7 | | - ADD INDEX `versioned_start_language` (`add_transaction_id`, `language_id`, `expression_id`), |
| 8 | | - ADD INDEX `versioned_start_spelling` (`add_transaction_id`, `spelling` (255), `expression_id`, `language_id`), |
| 9 | | - ADD INDEX `expressions_unique_idx` (`expression_id`,`language_id`), |
| 10 | | - ADD INDEX `expressions_idx` (`expression_id`), |
| 11 | | - ADD INDEX `language_idx` (`language_id`) |
| 12 | | - ; |
| 13 | | - |
| Index: trunk/extensions/Wikidata/Database scripts/Convenience/Create uw_collection indices.sql |
| — | — | @@ -0,0 +1,11 @@ |
| | 2 | +ALTER TABLE `%dc%_collection` |
| | 3 | + ADD INDEX `versioned_end_collection` (`remove_transaction_id`, `collection_id`, `collection_mid`), |
| | 4 | + ADD INDEX `versioned_end_collection_meaning` (`remove_transaction_id`, `collection_mid`, `collection_id`), |
| | 5 | + ADD INDEX `versioned_end_collection_type` (`remove_transaction_id`, `collection_type` (4), `collection_id`, `collection_mid`), |
| | 6 | + ADD INDEX `versioned_start_collection` (`add_transaction_id`, `collection_id`, `collection_mid`), |
| | 7 | + ADD INDEX `versioned_start_collection_meaning` (`add_transaction_id`, `collection_mid`, `collection_id`), |
| | 8 | + ADD INDEX `versioned_start_collection_type` (`add_transaction_id`, `collection_type` (4), `collection_id`, `collection_mid`); |
| | 9 | + |
| | 10 | +-- ADD INDEX `unversioned_collection` (`collection_id`, `collection_mid`), |
| | 11 | +-- ADD INDEX `unversioned_collection_meaning` (`collection_mid`, `collection_id`), |
| | 12 | +-- ADD INDEX `unversioned_collection_type` (`collection_type` (4), `collection_id`, `collection_mid`); |
| \ No newline at end of file |
| Property changes on: trunk/extensions/Wikidata/Database scripts/Convenience/Create uw_collection indices.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 13 | + native |
| Index: trunk/extensions/Wikidata/Database scripts/Convenience/Create uw_expression indices.sql |
| — | — | @@ -0,0 +1,15 @@ |
| | 2 | +ALTER TABLE `%dc%_expression` |
| | 3 | + ADD INDEX `versioned_end_expression` (`remove_transaction_id`, `expression_id`, `language_id`), |
| | 4 | + ADD INDEX `versioned_end_language` (`remove_transaction_id`, `language_id`, `expression_id`), |
| | 5 | + ADD INDEX `versioned_end_spelling` (`remove_transaction_id`, `spelling` (255), `expression_id`, `language_id`), |
| | 6 | + ADD INDEX `versioned_start_expression` (`add_transaction_id`, `expression_id`, `language_id`), |
| | 7 | + ADD INDEX `versioned_start_language` (`add_transaction_id`, `language_id`, `expression_id`), |
| | 8 | + ADD INDEX `versioned_start_spelling` (`add_transaction_id`, `spelling` (255), `expression_id`, `language_id`), |
| | 9 | + ADD INDEX `expressions_unique_idx` (`expression_id`,`language_id`), |
| | 10 | + ADD INDEX `expressions_idx` (`expression_id`), |
| | 11 | + ADD INDEX `language_idx` (`language_id`) |
| | 12 | + ; |
| | 13 | +-- ADD INDEX `unversioned_spelling` (`spelling` (255), `expression_id`, `language_id`), |
| | 14 | +-- ADD INDEX `unversioned_expression` (`expression_id`, `language_id`), |
| | 15 | +-- ADD INDEX `unversioned_language` (`language_id`, `expression_id`); |
| | 16 | + |
| Property changes on: trunk/extensions/Wikidata/Database scripts/Convenience/Create uw_expression indices.sql |
| ___________________________________________________________________ |
| Added: svn:eol-style |
| 1 | 17 | + native |
| Index: trunk/extensions/Wikidata/Database scripts/Convenience/Recreate indexes for all tables.php |
| — | — | @@ -63,25 +63,25 @@ |
| 64 | 64 | $wgCommandLineMode = true; |
| 65 | 65 | $dc = "uw"; |
| 66 | 66 | |
| 67 | | -$tables = array( |
| 68 | | - "bootstrapped_defined_meanings", |
| 69 | | - "transactions", |
| 70 | | - "translated_content", |
| 71 | | - "alt_meaningtexts", |
| 72 | | - "class_attributes", |
| 73 | | - "class_membership", |
| 74 | | - "collection_contents", |
| 75 | | - "collection_ns", |
| 76 | | - "defined_meaning", |
| 77 | | - "expression_ns", |
| 78 | | - "meaning_relations", |
| 79 | | - "option_attribute_options", |
| 80 | | - "option_attribute_values", |
| 81 | | - "syntrans", |
| 82 | | - "text_attribute_values", |
| 83 | | - "translated_content_attribute_values", |
| 84 | | - "url_attribute_values" |
| 85 | | - ); |
| | 67 | +$tables = array( |
| | 68 | + "bootstrapped_defined_meanings", |
| | 69 | + "transactions", |
| | 70 | + "translated_content", |
| | 71 | + "alt_meaningtexts", |
| | 72 | + "class_attributes", |
| | 73 | + "class_membership", |
| | 74 | + "collection_contents", |
| | 75 | + "collection", |
| | 76 | + "defined_meaning", |
| | 77 | + "expression", |
| | 78 | + "meaning_relations", |
| | 79 | + "option_attribute_options", |
| | 80 | + "option_attribute_values", |
| | 81 | + "syntrans", |
| | 82 | + "text_attribute_values", |
| | 83 | + "translated_content_attribute_values", |
| | 84 | + "url_attribute_values" |
| | 85 | +); |
| 86 | 86 | |
| 87 | 87 | $prefixes = retrieve_datasets(); |
| 88 | 88 | |