Ferreteria/v0.41/sql/node leaf: Difference between revisions
Jump to navigation
Jump to search
(Created page with "==About== * '''Purpose''': Index to all {{l/version|sql|node}} leafs, regardless of format ==Fields== * '''Type''': name of type; caller code will maintain an index of leaf-ha...") |
m (3 revisions imported: moving this project here) |
||
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
'''versions''': {{l/ferreteria/|v0.41/sql/node_leaf|0.41}}, {{l/ferreteria/|v0.42/sql/node_leaf|0.42}}, {{l/ferreteria/|v0.5/sql/node_leaf|0.5}} | |||
==About== | ==About== | ||
* '''Purpose''': Index to all {{l/version|sql|node}} leafs, regardless of format | * '''Purpose''': Index to all {{l/version|sql|node}} leafs, regardless of format | ||
Latest revision as of 16:44, 22 May 2022
About
- Purpose: Index to all Template:L/version leafs, regardless of format
Fields
- Type: name of type; caller code will maintain an index of leaf-handler classes (
array[Type] => class_name)
History
- 2017-08-03 Started, because the need became apparent.
- 2020-01-16 redesigning for v0.4 (copied from Ferreteria/sql/tf leaf)
SQL
CREATE TABLE `node_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;