jcrespo added a comment.
Please confirm the change is correct, then resolve:
MariaDB [wikidatawiki]> SHOW CREATE TABLE wb_terms\G
*************************** 1. row ***************************
Table: wb_terms
Create Table: CREATE TABLE `wb_terms` (
`term_row_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`term_entity_id` int(10) unsigned NOT NULL,
`term_entity_type` varbinary(32) NOT NULL,
`term_language` varbinary(32) NOT NULL,
`term_type` varbinary(32) NOT NULL,
`term_text` varbinary(255) NOT NULL,
`term_search_key` varbinary(255) NOT NULL,
`term_weight` float unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`term_row_id`),
KEY `wb_terms_entity_id` (`term_entity_id`),
KEY `wb_terms_entity_type` (`term_entity_type`),
KEY `wb_terms_language` (`term_language`),
KEY `wb_terms_type` (`term_type`),
KEY `wb_terms_text` (`term_text`),
KEY `wb_terms_search_key` (`term_search_key`),
KEY `tmp1`
(`term_language`,`term_type`,`term_entity_type`,`term_search_key`)
) ENGINE=InnoDB AUTO_INCREMENT=602140225 DEFAULT CHARSET=binary
1 row in set (0.00 sec)
MariaDB [wikidatawiki]> SHOW CREATE TABLE wb_items_per_site\G
*************************** 1. row ***************************
Table: wb_items_per_site
Create Table: CREATE TABLE `wb_items_per_site` (
`ips_row_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`ips_item_id` int(10) unsigned NOT NULL,
`ips_site_id` varbinary(32) NOT NULL,
`ips_site_page` varbinary(310) NOT NULL,
PRIMARY KEY (`ips_row_id`),
UNIQUE KEY `wb_ips_item_site_page` (`ips_site_id`,`ips_site_page`),
KEY `wb_ips_site_page` (`ips_site_page`),
KEY `wb_ips_item_id` (`ips_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=558579131 DEFAULT CHARSET=binary
1 row in set (0.00 sec)
TASK DETAIL
https://phabricator.wikimedia.org/T62539
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: jcrespo
Cc: Stashbot, hoo, Krenair, Aklapper, jcrespo, greg, aude, Springle, MZMcBride,
01tonythomas, Izno, Wikidata-bugs, Mbch331
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
