Semantic MediaWiki/data/smw fpt mdat

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to: navigation, search

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)