Ferreteria/sql/tf node

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< Ferreteria‎ | sql
Revision as of 15:27, 5 August 2018 by Woozle (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Purpose: a thing that has values
  • Module: TextFerret
  • History:
    • 2017-03-12 started
    • 2017-04-09 decided there really should be a WhenMade timestamp; can always remove later
    • 2017-08-05 renamed Class to Type for consistency with tf_leaf: records use "types", code maps these to "classes"

Fields

  • Type: name of node type; code should know how to map these to node-handler classes

SQL

CREATE TABLE `tf_node` (
  `ID`       INT(4)       NOT NULL AUTO_INCREMENT,
  `Type`     VARCHAR(255) NOT NULL COMMENT "name of node type",
  `WhenMade` DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY(`ID`)
) ENGINE=InnoDB;