Semantic MediaWiki/data/smw rels2

About

 * Version: 1.7
 * Documentation status: unofficial; confirmed only by testing
 * Purpose: defines semantic relationships between property-names and property-values, where the values have an SMW ID
 * Foreign keys: .smw_id
 * Fields:
 * s_id: SMW ID of a page on which the property name-value pair is defined
 * p_id: SMW ID of the property name
 * o_id: SMW ID of the property value

SQL
CREATE TABLE `smw_rels2` ( `s_id` int(8) unsigned NOT NULL,  `p_id` int(8) unsigned NOT NULL,  `o_id` int(8) unsigned DEFAULT NULL,  KEY `s_id` (`s_id`),  KEY `p_id` (`p_id`),  KEY `o_id` (`o_id`) ) ENGINE=InnoDB DEFAULT CHARSET=binary;

Examples
SELECT s_id , s.smw_namespace AS s_namespace , CAST(s.smw_title AS char) AS s_title , CAST(p.smw_title AS char) AS p_title , CAST(o.smw_title AS char) AS o_title FROM ((smw_rels2 AS r   LEFT JOIN smw_ids AS s ON r.s_id=s.smw_id)    LEFT JOIN smw_ids AS p ON r.p_id=p.smw_id) LEFT JOIN smw_ids AS o ON r.o_id=o.smw_id;