VbzCart/docs/tables/cat topic: Difference between revisions
Jump to navigation
Jump to search
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...) |
imported>Woozle (status update; possible fields to add later) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Status''': | * '''Status''': Coding in progress | ||
* '''History''': | |||
** '''2010-10-13''' Coding (store and admin) in progress; noted 3 possible fields to add | |||
* '''Notes''': | |||
** This should probably be renamed cat_topic | |||
** Fields I'm considering adding here: | |||
*** a flag to indicate that thumbnails of other items in the same category should be shown | |||
*** a prefix to be added to NameFull for all child nodes (and maybe a flag to override it) | |||
*** a way of creating "virtual" nodes to cross-link to related topics in other branches | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>DROP TABLE IF EXISTS `brs_topics`; | <section begin=sql /><mysql>DROP TABLE IF EXISTS `brs_topics`; | ||
Revision as of 09:40, 13 October 2010
About
- Status: Coding in progress
- History:
- 2010-10-13 Coding (store and admin) in progress; noted 3 possible fields to add
- Notes:
- This should probably be renamed cat_topic
- Fields I'm considering adding here:
- a flag to indicate that thumbnails of other items in the same category should be shown
- a prefix to be added to NameFull for all child nodes (and maybe a flag to override it)
- a way of creating "virtual" nodes to cross-link to related topics in other branches
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 />