Semantic MediaWiki/data/smw inst2 - Revision history

Woozle: tentative example SQL

2012-12-17T16:08:59Z

tentative example SQL

← Older revision		Revision as of 16:08, 17 December 2012
Line 8:		Line 8:
	KEY `o_id` (`o_id`)		KEY `o_id` (`o_id`)
	) ENGINE=InnoDB DEFAULT CHARSET=binary;</mysql>		) ENGINE=InnoDB DEFAULT CHARSET=binary;</mysql>
			==Examples==
			This is ''probably'' correct, based on field names and convention found in other tables, but still not sure what it means:
			<mysql>
			SELECT s_id, o_id
			, CAST(s.smw_title AS char) AS s_title
			, CAST(o.smw_title AS char) AS o_title
			FROM
			(smw_inst2 AS i
			LEFT JOIN smw_ids AS s ON i.s_id=s.smw_id)
			LEFT JOIN smw_ids AS o ON i.o_id=o.smw_id;
			</mysql>

Woozle: moved smw inst2 to Semantic MediaWiki/data/smw inst2: forgot to prefix with /

2012-01-22T20:50:29Z

moved smw inst2 to Semantic MediaWiki/data/smw inst2: forgot to prefix with /

← Older revision	Revision as of 20:50, 22 January 2012
(No difference)

Woozle: Created page with "==About== * '''Version''': 1.7 ==SQL== CREATE TABLE `smw_inst2` ( `s_id` int(8) unsigned NOT NULL, `o_id` int(8) unsigned DEFAULT NULL, KEY `s_id` (`s_id`), KEY..."

2012-01-22T20:02:26Z

Created page with "==About== * '''Version''': 1.7 ==SQL== <mysql>CREATE TABLE `smw_inst2` ( `s_id` int(8) unsigned NOT NULL, `o_id` int(8) unsigned DEFAULT NULL, KEY `s_id` (`s_id`), KEY..."

New page

==About==
* '''Version''': 1.7
==SQL==
<mysql>CREATE TABLE `smw_inst2` (
`s_id` int(8) unsigned NOT NULL,
`o_id` int(8) unsigned DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_id` (`o_id`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;</mysql>