Ferreteria/sql/tf leaf text

From Woozle Writes Code
< Ferreteria‎ | sql
Revision as of 10:08, 28 July 2017 by htyp>Woozle (Woozle moved page Ferreteria/sql/tf value text to Ferreteria/sql/tf leaf text without leaving a redirect: renaming TF "values" as "leafs")
Jump to navigation Jump to search

About

History

  • 2017-03-12 Started, because it's needed for multiple sub-projects.
  • 2017-07-28 Renaming TF "values" as "leafs", so this (tf_value_text) becomes tf_leaf_text.

SQL

<mysql>CREATE TABLE `tf_leaf_text` (

 `ID_Node` INT(4)        NOT NULL COMMENT "ID of node to which this value belongs",
 `Name`    VARCHAR(255)  NOT NULL COMMENT "internal name of this value",
 `Value`   TEXT      DEFAULT NULL COMMENT "the value",
 PRIMARY KEY(`ID_Node`,`Name`)

) ENGINE=InnoDB;</mysql>