Ferreteria/sql/tf leaf

About

• Purpose: Index to all node (Template:L/ferreteria/table) leafs, regardless of format
• Module: Template:L/ferreteria/module

Fields

• Type: name of type; in code, this should refer to an index of leaf-handler-classes

History

• 2017-08-03 Started, because the need became apparent.

SQL

<mysql>CREATE TABLE `tf_leaf` (

 `ID`      INT(4)        NOT NULL AUTO_INCREMENT,
 `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",
 `Type`    VARCHAR(255)  NOT NULL COMMENT "name of leaf (field) type",
 PRIMARY KEY(`ID`),
 UNIQUE KEY(`ID_Node`,`Name`)

) ENGINE=InnoDB;</mysql>