Ferreteria/sql/tf leaf

From Woozle Writes Code
< Ferreteria‎ | sql
Revision as of 11:29, 3 August 2017 by htyp>Woozle (Created page with "==About== * '''Purpose''': Index to all node ({{l/ferreteria/table|tf_node}}) leafs, regardless of format * '''Module''': {{l/ferreteria/module|TextFerret}} ==Fields== * '''Ty...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

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 type",
 PRIMARY KEY(`ID`),
 UNIQUE KEY(`ID_Node`,`Name`)

) ENGINE=InnoDB;</mysql>