Ferreteria/sql/tf leaf text: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(Created page with "==About== This table stores chunks of text. A wiki page consists of one or more tf_text records. ==History== * '''2017-03-12''' Started, because it's needed for multiple sub-p...") |
m (10 revisions imported: moving this project here) |
||
| (9 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Node ({{l/ferreteria/table|tf_node}}) leafs that are textual in nature | |||
* '''Module''': {{l/ferreteria/module|TextFerret}} | |||
* '''Depends on''': {{l/ferreteria/table|tf_leaf}} | |||
==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. | |||
* '''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 ` | <syntaxhighlight lang=mysql>CREATE TABLE `tf_leaf_text` ( | ||
` | `ID_Leaf` INT(4) NOT NULL COMMENT "ID of leaf to which this value belongs", | ||
`Value` | `Value` TEXT DEFAULT NULL COMMENT "the value", | ||
PRIMARY KEY(` | 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;