Semantic MediaWiki/data/smw object ids: Difference between revisions

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Newer edit →
Woozle (talk | contribs)
Bureaucrats, Interface administrators, interwiki, Administrators, trusted
20,101 edits
VisualWikitext
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; similar to {{l/same|smw_ids}} in schema version 2
* '''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>
delimiter $$
 
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$$
</mysql>
</syntaxhighlight>
===Example===
===Example===
<mysql>SELECT smw_id, smw_namespace, CAST(smw_title AS CHAR) as title FROM smw_object_ids;</mysql>
<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_hash field.

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;
Retrieved from "https://htyp.org/mw/index.php?title=Semantic_MediaWiki/data/smw_object_ids&oldid=23695"