Semantic MediaWiki/data/smw ids - Revision history

Woozle at 20:43, 9 July 2020

2020-07-09T20:43:11Z

← Older revision		Revision as of 20:43, 9 July 2020
Line 19:		Line 19:
	KEY `smw_title_2` (`smw_title`,`smw_namespace`,`smw_iw`,`smw_subobject`)		KEY `smw_title_2` (`smw_title`,`smw_namespace`,`smw_iw`,`smw_subobject`)
	) ENGINE=InnoDB AUTO_INCREMENT=10805 DEFAULT CHARSET=binary;</source>		) ENGINE=InnoDB AUTO_INCREMENT=10805 DEFAULT CHARSET=binary;</source>
			==Queries==
			This shows the values hidden in the binary blobs:
			<source lang=mysql>SELECT
			smw_id,
			smw_namespace,
			CAST(smw_title AS CHAR) AS title,
			CAST(smw_iw AS CHAR) iw,
			CAST(smw_subobject AS CHAR) AS subobj,
			CAST(smw_sortkey AS CHAR) AS sortkey
			FROM
			pcrit_mw.smw_ids;</source>

Woozle: markup update

2020-07-09T20:38:36Z

markup update

← Older revision		Revision as of 20:38, 9 July 2020
Line 7:		Line 7:
	** '''smw_title''': title (without namespace) that the corresponding page would have in MediaWiki		** '''smw_title''': title (without namespace) that the corresponding page would have in MediaWiki
	==SQL==		==SQL==
	<mysql>CREATE TABLE `smw_ids` (		<source lang=mysql>CREATE TABLE `smw_ids` (
	`smw_id` int(8) unsigned NOT NULL AUTO_INCREMENT,		`smw_id` int(8) unsigned NOT NULL AUTO_INCREMENT,
	`smw_namespace` int(11) NOT NULL,		`smw_namespace` int(11) NOT NULL,
Line 18:		Line 18:
	KEY `smw_sortkey` (`smw_sortkey`),		KEY `smw_sortkey` (`smw_sortkey`),
	KEY `smw_title_2` (`smw_title`,`smw_namespace`,`smw_iw`,`smw_subobject`)		KEY `smw_title_2` (`smw_title`,`smw_namespace`,`smw_iw`,`smw_subobject`)
	) ENGINE=InnoDB AUTO_INCREMENT=10805 DEFAULT CHARSET=binary;</~~mysql~~>		) ENGINE=InnoDB AUTO_INCREMENT=10805 DEFAULT CHARSET=binary;</source>

Woozle: reconstructing the documentation

2012-12-17T15:27:37Z

reconstructing the documentation

← Older revision		Revision as of 15:27, 17 December 2012
Line 1:		Line 1:
	==About==		==About==
	* '''Version''': 1.7		* '''Version''': 1.7
			* '''Documentation status''': unofficial; confirmed by testing only
			* '''Purpose''': assigns SMW-specific IDs to all SMW property-names and property-values, whether or not there is a corresponding MW page.
			* '''Fields''':
			** '''smw_namespace''': namespace that the corresponding page would have in MediaWiki
			** '''smw_title''': title (without namespace) that the corresponding page would have in MediaWiki
	==SQL==		==SQL==
	<mysql>CREATE TABLE `smw_ids` (		<mysql>CREATE TABLE `smw_ids` (

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

2012-01-22T20:50:10Z

moved smw ids to Semantic MediaWiki/data/smw ids: 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_ids` ( `smw_id` int(8) unsigned NOT NULL AUTO_INCREMENT, `smw_namespace` int(11) NOT NULL, `smw_title` va..."

2012-01-22T19:40:06Z

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..."

New page

==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>