Ferreteria/v0.41/sql/node leaf text: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
(Created page with "==About== * '''Purpose''': Node ({{l/version|sql|node}}) leafs that are textual in nature * '''Depends on''': {{l/version|sql|node_leaf}} ==History== * '''2017-03-12''' Starte...")
 
m (2 revisions imported: moving this project here)
 
(One intermediate revision by one other user not shown)
(No difference)

Latest revision as of 16:44, 22 May 2022

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
  • 2020-01-16 redesigning for v0.4 (copied from Ferreteria/sql/tf leaf_text)

SQL

CREATE TABLE  `node_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;