Ferreteria/sql/tf leaf text: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(simplified functionality) |
m (10 revisions imported: moving this project here) |
||
| (One intermediate revision by one other user not shown) | |||
| 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> | ||
Latest revision as of 16:42, 22 May 2022
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;