Semantic MediaWiki/data/smw ids
< Semantic MediaWiki | data
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
About
- Version: 1.7
- Documentation status: unofficial; confirmed by testing only
- Purpose: assigns SMW-specific IDs to all SMW property-names and property-values, whether or not there is a corresponding MW page.
- Fields:
- smw_namespace: namespace that the corresponding page would have in MediaWiki
- smw_title: title (without namespace) that the corresponding page would have in MediaWiki
SQL
CREATE TABLE `smw_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,
PRIMARY KEY (`smw_id`),
KEY `smw_title` (`smw_title`,`smw_namespace`,`smw_iw`),
KEY `smw_sortkey` (`smw_sortkey`),
KEY `smw_title_2` (`smw_title`,`smw_namespace`,`smw_iw`,`smw_subobject`)
) ENGINE=InnoDB AUTO_INCREMENT=10805 DEFAULT CHARSET=binary;
Queries
This shows the values hidden in the binary blobs:
SELECT
smw_id,
smw_namespace,
CAST(smw_title AS CHAR) AS title,
CAST(smw_iw AS CHAR) iw,
CAST(smw_subobject AS CHAR) AS subobj,
CAST(smw_sortkey AS CHAR) AS sortkey
FROM
pcrit_mw.smw_ids;