Marostegui added a comment.
[email protected][wikidatawiki]> CREATE INDEX
/*i*/wb_changes_change_revision_id ON /*_*/wb_changes (change_revision_id);
Query OK, 0 rows affected (10.702 sec)
Records: 0 Duplicates: 0 Warnings: 0
[email protected][wikidatawiki]>
[email protected][wikidatawiki]> show create table wb_changes;
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| Table | Create Table
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
| wb_changes | CREATE TABLE `wb_changes` (
`change_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`change_type` varbinary(25) NOT NULL,
`change_time` varbinary(14) NOT NULL,
`change_object_id` varbinary(14) NOT NULL,
`change_revision_id` int(10) unsigned NOT NULL,
`change_user_id` int(10) unsigned NOT NULL,
`change_info` mediumblob NOT NULL,
PRIMARY KEY (`change_id`),
KEY `wb_changes_change_time` (`change_time`),
KEY `wb_changes_change_revision_id` (`change_revision_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1274893656 DEFAULT CHARSET=binary
ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8 |
+------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
1 row in set (0.032 sec)
TASK DETAIL
https://phabricator.wikimedia.org/T262856
EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/
To: Marostegui
Cc: Kormat, Marostegui, Lucas_Werkmeister_WMDE, Addshore, Aklapper, Ladsgroup,
LSobanski, Akuckartz, Iflorez, darthmon_wmde, Nandana, Lahi, Gq86,
GoranSMilovanovic, QZanden, LawExplorer, Minhnv-2809, _jensen, rosalieper,
Scott_WUaS, Jonas, Wikidata-bugs, aude, Lydia_Pintscher, Mbch331, Jay8g, Krenair
_______________________________________________
Wikidata-bugs mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs
