Woozle: Created page with "==About== * '''Purpose''': not well understood; seems to be time values ==SQL== ===Definition=== CREATE TABLE `smw_fpt_mdat` ( `s_id` int(8) uns..."

2018-01-26T19:08:54Z

Created page with "==About== * '''Purpose''': not well understood; seems to be time values ==SQL== ===Definition=== <syntaxhighlight lang=mysql> CREATE TABLE `smw_fpt_mdat` ( `s_id` int(8) uns..."

New page

==About==
* '''Purpose''': not well understood; seems to be time values
==SQL==
===Definition===
<syntaxhighlight lang=mysql>
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;
</syntaxhighlight>
===Example===
I'm not sure if this is a meaningful query or not, but it's what the field names suggest:
<syntaxhighlight lang=mysql>
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)
</syntaxhighlight>

Semantic MediaWiki/data/smw fpt mdat - Revision history

Woozle: Created page with "==About== * '''Purpose''': not well understood; seems to be time values ==SQL== ===Definition=== CREATE TABLE `smw_fpt_mdat` ( `s_id` int(8) uns..."