Ferreteria/sql/tf leaf text: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(post-move: added module link) |
(about to rename) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Node ({{l/ferreteria/table|tf_node}}) | * '''Purpose''': Node ({{l/ferreteria/table|tf_node}}) leafs that are textual in nature | ||
* '''Module''': {{l/ferreteria/module|TextFerret}} | * '''Module''': {{l/ferreteria/module|TextFerret}} | ||
==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. | ||
* '''2017-07-28''' Renaming TF "values" as "leafs", so this (tf_value_text) becomes tf_leaf_text. | |||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE ` | <mysql>CREATE TABLE `tf_leaf_text` ( | ||
`ID_Node` INT(4) NOT NULL COMMENT "ID of node to which this value belongs", | `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", | `Name` VARCHAR(255) NOT NULL COMMENT "internal name of this value", | ||
Revision as of 10:07, 28 July 2017
About
- Purpose: Node (Template:L/ferreteria/table) leafs that are textual in nature
- Module: Template:L/ferreteria/module
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>