Semantic MediaWiki/data/smw ids: Difference between revisions

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Newer edit →
Woozle (talk | contribs)
Bureaucrats, Interface administrators, interwiki, Administrators, trusted
20,101 edits
Created page 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` va..."
 
m moved smw ids to Semantic MediaWiki/data/smw ids: forgot to prefix with /
(No difference)

Revision as of 20:50, 22 January 2012

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>

Retrieved from "https://htyp.org/mw/index.php?title=Semantic_MediaWiki/data/smw_ids&oldid=16837"