VbzCart/docs/tables/cat topic

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Revision as of 19:17, 8 March 2009 by imported>Woozle (New page: ==About== * '''Status''': Under development. May end up not being used. ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `brs_topics`; CREATE TABLE `brs_topics` ( `ID` INT...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Status: Under development. May end up not being used.

SQL

<section begin=sql /><mysql>DROP TABLE IF EXISTS `brs_topics`; CREATE TABLE `brs_topics` (

 `ID`        INT          NOT NULL AUTO_INCREMENT,
 `ID_Parent` INT          DEFAULT NULL COMMENT "brs_topics.ID of parent topic",
 `Name`      varchar(128) NOT NULL     COMMENT "generic name (context-free, but as short as possible)",
 `NameTree`  varchar(64)  DEFAULT NULL COMMENT "name within context of parent; defaults to Name",
 `NameFull`  varchar(255) DEFAULT NULL COMMENT "descriptive standalone name (context free, can be long)",
 `Sort`      varchar(15)  DEFAULT NULL COMMENT "optional sorting key",
 `Variants`  varchar(255) DEFAULT NULL COMMENT "synonyms and other keywords which should find this topic",
 `Mispeled`  varchar(255) DEFAULT NULL COMMENT "same as Variants, but these are WRONG spellings; avoid displaying",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql> <section end=sql />