Semantic MediaWiki/data/smw text2: Difference between revisions

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
m moved smw text2 to Semantic MediaWiki/data/smw text2: forgot to prefix with /
fields
Line 1: Line 1:
==About==
==About==
* '''Version''': 1.7
* '''Version''': 1.7
* '''Fields''':
** '''s_id''': [[../smw_ids|SMW ID]] of ''source page'' (page where property is being set)
** '''p_id''': [[../smw_ids|SMW ID]] of ''property'' (name of property being used)
** '''value_blob''': the value to which the property has been set for this page
==SQL==
==SQL==
<mysql>CREATE TABLE `smw_text2` (
<mysql>CREATE TABLE `smw_text2` (

Revision as of 20:55, 22 January 2012

About

  • Version: 1.7
  • Fields:
    • s_id: SMW ID of source page (page where property is being set)
    • p_id: SMW ID of property (name of property being used)
    • value_blob: the value to which the property has been set for this page

SQL

<mysql>CREATE TABLE `smw_text2` (

 `s_id` int(8) unsigned NOT NULL,
 `p_id` int(8) unsigned NOT NULL,
 `value_blob` mediumblob,
 KEY `s_id` (`s_id`),
 KEY `p_id` (`p_id`)

) ENGINE=InnoDB DEFAULT CHARSET=binary;</mysql>