Difference between revisions of "Semantic MediaWiki/data/smw object ids"
< Semantic MediaWiki | data
Jump to navigation
Jump to search
(Created page with "==About== * '''Purpose''': registry of all SMW object IDs; similar to {{l/same|smw_ids}} in schema version 2 ==SQL== <mysql> delimiter $$ CREATE TABLE `smw_object_ids` ( `s...") |
(fixed syntax tag; better example) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
| − | * '''Purpose''': registry of all SMW object IDs; | + | * '''Purpose''': registry of all SMW object IDs; apparently replaces {{l/same|smw_ids}} in schema version 2 but adds <code>smw_proptable_hash</code> field. |
==SQL== | ==SQL== | ||
| − | <mysql> | + | <syntaxhighlight lang=mysql> |
| − | |||
| − | |||
CREATE TABLE `smw_object_ids` ( | CREATE TABLE `smw_object_ids` ( | ||
`smw_id` int(8) unsigned NOT NULL AUTO_INCREMENT, | `smw_id` int(8) unsigned NOT NULL AUTO_INCREMENT, | ||
| Line 18: | Line 16: | ||
KEY `smw_sortkey` (`smw_sortkey`) | KEY `smw_sortkey` (`smw_sortkey`) | ||
) ENGINE=InnoDB AUTO_INCREMENT=4599 DEFAULT CHARSET=binary$$ | ) ENGINE=InnoDB AUTO_INCREMENT=4599 DEFAULT CHARSET=binary$$ | ||
| − | </ | + | </syntaxhighlight> |
===Example=== | ===Example=== | ||
| − | <mysql>SELECT smw_id, smw_namespace, CAST(smw_title AS CHAR) | + | <syntaxhighlight lang=mysql>SELECT |
| + | smw_id, | ||
| + | smw_namespace, | ||
| + | CAST(smw_title AS CHAR) AS title, | ||
| + | CAST(smw_iw AS CHAR) AS iw, | ||
| + | CAST(smw_subobject AS CHAR) AS sub, | ||
| + | CAST(smw_sortkey AS CHAR) AS sortkey, | ||
| + | CAST(smw_proptable_hash AS CHAR) AS pthash | ||
| + | FROM | ||
| + | smw_object_ids;</syntaxhighlight> | ||
Revision as of 12:59, 26 January 2018
About
- Purpose: registry of all SMW object IDs; apparently replaces smw_ids in schema version 2 but adds
smw_proptable_hashfield.
SQL
CREATE TABLE `smw_object_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,
`smw_proptable_hash` mediumblob,
PRIMARY KEY (`smw_id`),
KEY `smw_id` (`smw_id`,`smw_sortkey`),
KEY `smw_title` (`smw_title`,`smw_namespace`,`smw_iw`,`smw_subobject`),
KEY `smw_sortkey` (`smw_sortkey`)
) ENGINE=InnoDB AUTO_INCREMENT=4599 DEFAULT CHARSET=binary$$
Example
SELECT
smw_id,
smw_namespace,
CAST(smw_title AS CHAR) AS title,
CAST(smw_iw AS CHAR) AS iw,
CAST(smw_subobject AS CHAR) AS sub,
CAST(smw_sortkey AS CHAR) AS sortkey,
CAST(smw_proptable_hash AS CHAR) AS pthash
FROM
smw_object_ids;