VbzCart/tables/brs topics

From HTYP, the free directory anyone can edit

[edit] About

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

[edit] SQL

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;