Page MenuHomePhabricator
Paste P6782

wb_items_per_site structure
ActivePublic

Authored by jcrespo on Mar 2 2018, 6:17 PM.
Tags
None
Referenced Files
F14313669: wb_items_per_site structure
Mar 2 2018, 6:17 PM
Subscribers
None
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)