Ferreteria/sql/tf leaf text: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
m (Woozle moved page Ferreteria/modules/TextFerret/tf value text to Ferreteria/sql/tf value text without leaving a redirect: this is where all table-pages should go)
(post-move: added module link)
Line 1: Line 1:
==About==
==About==
* '''Purpose''': Node values that are textual in nature
* '''Purpose''': Node ({{l/ferreteria/table|tf_node}}) values that are textual in nature
* '''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.

Revision as of 09:46, 28 July 2017

About

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>