Ferreteria/sql/tf node

About

• Purpose: a thing that has values
• Module: Template:L/ferreteria/module
• 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>