Ferreteria/sql/tf leaf text: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
No edit summary |
mNo edit summary |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Node | * '''Purpose''': Node values that are textual in nature | ||
==History== | ==History== | ||
* '''2017-03-12''' Started, because it's needed for multiple sub-projects. | * '''2017-03-12''' Started, because it's needed for multiple sub-projects. | ||
Revision as of 23:55, 12 March 2017
About
- Purpose: Node values that are textual in nature
History
- 2017-03-12 Started, because it's needed for multiple sub-projects.
SQL
<mysql>CREATE TABLE `tf_value_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>