Semantic MediaWiki/data/smw fpt mdat
< Semantic MediaWiki | data
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
About
- Purpose: not well understood; seems to be time values
SQL
Definition
CREATE TABLE `smw_fpt_mdat` (
`s_id` int(8) unsigned NOT NULL,
`o_serialized` varbinary(255) DEFAULT NULL,
`o_sortkey` double DEFAULT NULL,
KEY `s_id` (`s_id`),
KEY `o_sortkey` (`o_sortkey`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;
Example
I'm not sure if this is a meaningful query or not, but it's what the field names suggest:
SELECT
s_id,
CAST(s.smw_title AS CHAR) AS s_title,
CAST(o_serialized AS CHAR) AS value,
o_sortkey
FROM
(smw_fpt_mdat AS t
LEFT JOIN smw_object_ids AS s ON t.s_id = s.smw_id)