| Index: trunk/extensions/Wikidata/Database scripts/Convenience/wikidataSourceTables.sql |
| — | — | @@ -16,7 +16,7 @@ |
| 17 | 17 | `name` varchar(255) NOT NULL, |
| 18 | 18 | `defined_meaning_id` int(11) NOT NULL, |
| 19 | 19 | KEY `unversioned_meaning` (`defined_meaning_id`), |
| 20 | | - KEY `unversioned_name` (`name`,`defined_meaning_id`) |
| | 20 | + KEY `unversioned_name` (`name` (255),`defined_meaning_id`) |
| 21 | 21 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| 22 | 22 | |
| 23 | 23 | -- object_id - key for the attribute, used elsewhere as a foreign key |
| — | — | @@ -83,10 +83,10 @@ |
| 84 | 84 | `remove_transaction_id` int(11) default NULL, |
| 85 | 85 | KEY `versioned_end_collection` (`remove_transaction_id`,`collection_id`,`collection_mid`), |
| 86 | 86 | KEY `versioned_end_collection_meaning` (`remove_transaction_id`,`collection_mid`,`collection_id`), |
| 87 | | - KEY `versioned_end_collection_type` (`remove_transaction_id`,`collection_type`,`collection_id`,`collection_mid`), |
| | 87 | + KEY `versioned_end_collection_type` (`remove_transaction_id`,`collection_type` (4),`collection_id`,`collection_mid`), |
| 88 | 88 | KEY `versioned_start_collection` (`add_transaction_id`,`collection_id`,`collection_mid`), |
| 89 | 89 | KEY `versioned_start_collection_meaning` (`add_transaction_id`,`collection_mid`,`collection_id`), |
| 90 | | - KEY `versioned_start_collection_type` (`add_transaction_id`,`collection_type`,`collection_id`,`collection_mid`) |
| | 90 | + KEY `versioned_start_collection_type` (`add_transaction_id`,`collection_type` (4),`collection_id`,`collection_mid`) |
| 91 | 91 | ) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
| 92 | 92 | |
| 93 | 93 | CREATE TABLE /*$wgWDprefix*/defined_meaning ( |
| — | — | @@ -111,7 +111,7 @@ |
| 112 | 112 | `remove_transaction_id` int(11) default NULL, |
| 113 | 113 | KEY `versioned_end_expression` (`remove_transaction_id`,`expression_id`,`language_id`), |
| 114 | 114 | KEY `versioned_end_language` (`remove_transaction_id`,`language_id`,`expression_id`), |
| 115 | | - KEY `versioned_end_spelling` (`remove_transaction_id`,`spelling`,`expression_id`,`language_id`), |
| | 115 | + KEY `versioned_end_spelling` (`remove_transaction_id`,`spelling`(255),`expression_id`,`language_id`), |
| 116 | 116 | KEY `versioned_start_expression` (`add_transaction_id`,`expression_id`,`language_id`), |
| 117 | 117 | KEY `versioned_start_language` (`add_transaction_id`,`language_id`,`expression_id`), |
| 118 | 118 | KEY `versioned_start_spelling` (`add_transaction_id`,`spelling`,`expression_id`,`language_id`) |