Semantic MediaWiki/data/smw fpt type

Notes

Contents of this table in a sample production environment:

'504', NULL, 'http://semantic-mediawiki.org/swivt/1.0#_txt'
'505', NULL, 'http://semantic-mediawiki.org/swivt/1.0#_txt'
'507', NULL, 'http://semantic-mediawiki.org/swivt/1.0#_dat'
'508', NULL, 'http://semantic-mediawiki.org/swivt/1.0#_txt'
'509', NULL, 'http://semantic-mediawiki.org/swivt/1.0#_cod'
'547', NULL, 'http://semantic-mediawiki.org/swivt/1.0#_txt'
'564', NULL, 'http://semantic-mediawiki.org/swivt/1.0#_dat'
'767', NULL, 'http://semantic-mediawiki.org/swivt/1.0#_txt'
'782', NULL, 'http://semantic-mediawiki.org/swivt/1.0#_txt'

The base URL in each case appears to be an XML page.

SQL

CREATE TABLE `smw_fpt_type` (
  `s_id` int(11) unsigned NOT NULL,
  `o_blob` mediumblob,
  `o_serialized` varbinary(255) DEFAULT NULL,
  KEY `s_id` (`s_id`),
  KEY `o_serialized` (`o_serialized`)
) ENGINE=InnoDB DEFAULT CHARSET=binary;

Query

SELECT 
    s_id,
    CAST(o_blob AS CHAR) AS oblob,
    CAST(o_serialized AS CHAR) AS oser
FROM
    pcrit_mw.smw_fpt_type;