Ferreteria/sql/tf leaf text: Difference between revisions

From Woozle Writes Code
Jump to navigation Jump to search
m (Woozle moved page Ferreteria/modules/TextFerret/tf text to Ferreteria/modules/TextFerret/tf value text without leaving a redirect: let's try this...)
No edit summary
Line 1: Line 1:
==About==
==About==
This table stores chunks of text. A wiki page consists of one or more tf_text records.
* '''Purpose''': Node fields that are textual in nature
==History==
==History==
* '''2017-03-12''' Started, because it's needed for multiple sub-projects.
* '''2017-03-12''' Started, because it's needed for multiple sub-projects.
==SQL==
==SQL==
<mysql>CREATE TABLE  `tf_text` (
<mysql>CREATE TABLE  `tf_value_text` (
   `ID`       INT(4)           NOT NULL AUTO_INCREMENT,
   `ID_Node` INT(4)       NOT NULL COMMENT "ID of node to which this value belongs",
   `Value`     TEXT         DEFAULT NULL COMMENT "Parent project (can be client or category)",
  `Name`    VARCHAR(255)  NOT NULL COMMENT "internal name of this value",
   PRIMARY KEY(`ID`)
   `Value`   TEXT     DEFAULT NULL COMMENT "the value",
   PRIMARY KEY(`ID_Node`,`Name`)
) ENGINE=InnoDB;</mysql>
) ENGINE=InnoDB;</mysql>

Revision as of 20:21, 12 March 2017

About

  • Purpose: Node fields that are textual in nature

History

  • 2017-03-12 Started, because it's needed for multiple sub-projects.

SQL

<mysql>CREATE TABLE `tf_value_text` ( 

 `ID_Node` INT(4)        NOT NULL COMMENT "ID of node to which this value belongs",
 `Name`    VARCHAR(255)  NOT NULL COMMENT "internal name of this value",
 `Value`   TEXT      DEFAULT NULL COMMENT "the value",
 PRIMARY KEY(`ID_Node`,`Name`)

) ENGINE=InnoDB;</mysql>

Retrieved from "https://wooz.dev/mw/index.php?title=Ferreteria/sql/tf_leaf_text&oldid=1726"