Semantic MediaWiki/data/smw object ids

About

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

SQL

<mysql> 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$$ </mysql>

Example

<mysql>SELECT smw_id, smw_namespace, CAST(smw_title AS CHAR) as title FROM smw_object_ids;</mysql>