Ferreteria/sql/tf node: Difference between revisions
< Ferreteria | sql
Jump to navigation
Jump to search
(Created page with "==About== * '''Purpose''': a thing that has values * '''History''': ** '''2017-03-12''' started ==SQL== <mysql>CREATE TABLE `tf_node` ( `ID` INT(4) NOT NULL AU...") |
(WhenCreated) |
||
Line 3: | Line 3: | ||
* '''History''': | * '''History''': | ||
** '''2017-03-12''' started | ** '''2017-03-12''' started | ||
** '''2017-04-09''' decided there really should be a WhenMade timestamp; can always remove later | |||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `tf_node` ( | <mysql>CREATE TABLE `tf_node` ( | ||
`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 | |||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE=InnoDB;</mysql> | ) ENGINE=InnoDB;</mysql> |
Revision as of 23:24, 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>