Semantic MediaWiki/data/smw object ids

About

 * Purpose: registry of all SMW object IDs; similar to in schema version 2

SQL
delimiter $$

CREATE TABLE `smw_object_ids` ( `smw_id` int(8) unsigned NOT NULL AUTO_INCREMENT,  `smw_namespace` int(11) NOT NULL,  `smw_title` varbinary(255) NOT NULL,  `smw_iw` varbinary(32) NOT NULL,  `smw_subobject` varbinary(255) NOT NULL,  `smw_sortkey` varbinary(255) NOT NULL,  `smw_proptable_hash` mediumblob,  PRIMARY KEY (`smw_id`),  KEY `smw_id` (`smw_id`,`smw_sortkey`),  KEY `smw_title` (`smw_title`,`smw_namespace`,`smw_iw`,`smw_subobject`),  KEY `smw_sortkey` (`smw_sortkey`) ) ENGINE=InnoDB AUTO_INCREMENT=4599 DEFAULT CHARSET=binary$$

Example
SELECT smw_id, smw_namespace, CAST(smw_title AS CHAR) as title FROM smw_object_ids;