Ferreteria/sql/tf node: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(WhenCreated) |
m (syntax fix) |
||
Line 8: | Line 8: | ||
`ID` INT(4) NOT NULL AUTO_INCREMENT, | `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", | `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 | `WhenMade` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE=InnoDB;</mysql> | ) ENGINE=InnoDB;</mysql> |
Revision as of 23:26, 9 April 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>