Ferreteria/sql/tf leaf text

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

<mysql>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;</mysql>