Ferreteria/sql/tf leaf text: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
m (Woozle moved page Ferreteria/sql/tf value text to Ferreteria/sql/tf leaf text without leaving a redirect: renaming TF "values" as "leafs")
(simplified functionality)
Line 2: Line 2:
* '''Purpose''': Node ({{l/ferreteria/table|tf_node}}) leafs that are textual in nature
* '''Purpose''': Node ({{l/ferreteria/table|tf_node}}) leafs that are textual in nature
* '''Module''': {{l/ferreteria/module|TextFerret}}
* '''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-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  `tf_leaf_text` (
<mysql>CREATE TABLE  `tf_leaf_text` (
   `ID_Node` INT(4)        NOT NULL COMMENT "ID of node to which this value belongs",
   `ID_Leaf` INT(4)        NOT NULL COMMENT "ID of leaf to which this value belongs",
  `Name`    VARCHAR(255)  NOT NULL COMMENT "internal name of this value",
   `Value`  TEXT      DEFAULT NULL COMMENT "the value",
   `Value`  TEXT      DEFAULT NULL COMMENT "the value",
   PRIMARY KEY(`ID_Node`,`Name`)
   PRIMARY KEY(`ID_Leaf`)
) ENGINE=InnoDB;</mysql>
) ENGINE=InnoDB;</mysql>

Revision as of 11:33, 3 August 2017

About

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>

Retrieved from "https://wooz.dev/mw/index.php?title=Ferreteria/sql/tf_leaf_text&oldid=1732"