AudioFerret/v2/topics: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< AudioFerret | v2
m Woozle moved page AudioFerret/v2/topic to AudioFerret/v2/topics without leaving a redirect: using plural where it sounds right |
m using plural |
||
| Line 4: | Line 4: | ||
** '''2012-12-24''' adapted from [[VbzCart/tables/cat topic]] | ** '''2012-12-24''' adapted from [[VbzCart/tables/cat topic]] | ||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE ` | <mysql>CREATE TABLE `topics` ( | ||
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`ID_Parent` INT DEFAULT NULL COMMENT "topic.ID of parent topic", | `ID_Parent` INT DEFAULT NULL COMMENT "topic.ID of parent topic", | ||
Revision as of 15:21, 24 December 2012
About
- Notes: My thinking is that any additional details can go on a wiki page whose name will be built from NameTree.
- History:
- 2012-12-24 adapted from VbzCart/tables/cat topic
SQL
<mysql>CREATE TABLE `topics` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_Parent` INT DEFAULT NULL COMMENT "topic.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)", `NameMeta` VARCHAR(144) DEFAULT NULL COMMENT "plain text for HTML META description tag", `Usage` VARCHAR(255) DEFAULT NULL COMMENT "usage instructions for this topic - show when editing topic", `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>
