Ferreteria/sql/tf node: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
m (syntax fix) |
m (Woozle moved page Ferreteria/modules/TextFerret/tf node to Ferreteria/sql/tf node without leaving a redirect: this is where all table-pages should go) |
(No difference)
|
Revision as of 09:38, 28 July 2017
About
- Purpose: a thing that has values
- History:
- 2017-03-12 started
- 2017-04-09 decided there really should be a WhenMade timestamp; can always remove later
SQL
<mysql>CREATE TABLE `tf_node` (
`ID` INT(4) NOT NULL AUTO_INCREMENT, `Class` VARCHAR(255) NOT NULL COMMENT "app-defined code to indicate what class of object to use for wrapping this node and its values", `WhenMade` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY(`ID`)
) ENGINE=InnoDB;</mysql>