Difference between revisions of "VbzCart/tables/cat topic"
Jump to navigation
Jump to search
(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...) |
(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
<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>