wb_items_per_site structure
ActivePublic
Actions

Authored by jcrespo on Mar 2 2018, 6:17 PM.

Project 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)

Event Timeline