Semantic MediaWiki/data/smw ids
< Semantic MediaWiki | data
Jump to navigation
Jump to search
Revision as of 20:50, 22 January 2012 by Woozle (talk | contribs) (moved smw ids to Semantic MediaWiki/data/smw ids: forgot to prefix with /)
About
- Version: 1.7
SQL
<mysql>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;</mysql>