Ferreteria/sql/tf leaf: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(clarification) |
mNo edit summary |
||
| Line 7: | Line 7: | ||
* '''2017-08-03''' Started, because the need became apparent. | * '''2017-08-03''' Started, because the need became apparent. | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `tf_leaf` ( | <syntaxhighlight lang=mysql>CREATE TABLE `tf_leaf` ( | ||
`ID` INT(4) NOT NULL AUTO_INCREMENT, | `ID` INT(4) NOT NULL AUTO_INCREMENT, | ||
`ID_Node` INT(4) NOT NULL COMMENT "ID of node to which this value belongs", | `ID_Node` INT(4) NOT NULL COMMENT "ID of node to which this value belongs", | ||
| Line 14: | Line 14: | ||
PRIMARY KEY(`ID`), | PRIMARY KEY(`ID`), | ||
UNIQUE KEY(`ID_Node`,`Name`) | UNIQUE KEY(`ID_Node`,`Name`) | ||
) ENGINE=InnoDB;</ | ) ENGINE=InnoDB;</syntaxhighlight> | ||
Revision as of 15:28, 5 August 2018
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
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;