Ferreteria/sql/tf node: Difference between revisions

From Woozle Writes Code
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>