Semantic MediaWiki/data/smw spec2

About

• Version: 1.7
• Documentation status: unofficial; confirmed only by testing
• Purpose: URLs for SWiVT definitions of built-in types
  • Currently, all URLs are like "http://semantic-mediawiki.org/swivt/1.0#_X", where X is "str", "txt", "dat", or "cod"

SQL

<mysql>CREATE TABLE `smw_spec2` (

 `s_id` int(8) unsigned NOT NULL,
 `p_id` int(8) unsigned NOT NULL,
 `value_string` varbinary(255) DEFAULT NULL,
 KEY `s_id` (`s_id`),
 KEY `p_id` (`p_id`),
 KEY `s_id_2` (`s_id`,`p_id`)

) ENGINE=InnoDB DEFAULT CHARSET=binary;</mysql>

Example

<mysql> SELECT s_id, p_id

 , CAST(s.smw_title AS char) AS s_title
 , CAST(p.smw_title AS char) AS p_title
 , CAST(value_string AS char) AS value
 FROM
   (smw_spec2 AS c
   LEFT JOIN smw_ids AS s ON c.s_id=s.smw_id)
   LEFT JOIN smw_ids AS p ON c.p_id=p.smw_id;

</mysql>