root@labsdb1009[wikidatawiki_p]> SHOW CREATE VIEW wikidatawiki_p.wb_items_per_site\G
*************************** 1. row ***************************
                View: wb_items_per_site
         Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `wb_items_per_site` AS select `wikidatawiki`.`wb_items_per_site`.`ips_row_id` AS `ips_row_id`,`wikidatawiki`.`wb_items_per_site`.`ips_item_id` AS `ips_item_id`,`wikidatawiki`.`wb_items_per_site`.`ips_site_id` AS `ips_site_id`,`wikidatawiki`.`wb_items_per_site`.`ips_site_page` AS `ips_site_page` from `wikidatawiki`.`wb_items_per_site`
character_set_client: utf8
collation_connection: utf8_general_ci
1 row in set (0.00 sec)

root@labsdb1009[wikidatawiki_p]> SHOW CREATE TABLE wikidatawiki.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_item_id` (`ips_item_id`)
) ENGINE=InnoDB AUTO_INCREMENT=576929351 DEFAULT CHARSET=binary ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=8
1 row in set (0.00 sec)