Ferreteria/sql/tf leaf text: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(simplified functionality) |
mNo edit summary |
||
| Line 8: | Line 8: | ||
* '''2017-08-03''' Decided all leaf-values should be tied to a leaf-index record which also stores the name | * '''2017-08-03''' Decided all leaf-values should be tied to a leaf-index record which also stores the name | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `tf_leaf_text` ( | <syntaxhighlight lang=mysql>CREATE TABLE `tf_leaf_text` ( | ||
`ID_Leaf` INT(4) NOT NULL COMMENT "ID of leaf to which this value belongs", | `ID_Leaf` INT(4) NOT NULL COMMENT "ID of leaf to which this value belongs", | ||
`Value` TEXT DEFAULT NULL COMMENT "the value", | `Value` TEXT DEFAULT NULL COMMENT "the value", | ||
PRIMARY KEY(`ID_Leaf`) | PRIMARY KEY(`ID_Leaf`) | ||
) ENGINE=InnoDB;</ | ) ENGINE=InnoDB;</syntaxhighlight> | ||
Revision as of 15:29, 5 August 2018
About
- Purpose: Node (Template:L/ferreteria/table) leafs that are textual in nature
- Module: Template:L/ferreteria/module
- Depends on: Template:L/ferreteria/table
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.
- 2017-08-03 Decided all leaf-values should be tied to a leaf-index record which also stores the name
SQL
CREATE TABLE `tf_leaf_text` (
`ID_Leaf` INT(4) NOT NULL COMMENT "ID of leaf to which this value belongs",
`Value` TEXT DEFAULT NULL COMMENT "the value",
PRIMARY KEY(`ID_Leaf`)
) ENGINE=InnoDB;