Woozle: removed "section" tags

2013-03-15T15:25:39Z

removed "section" tags

← Older revision		Revision as of 15:25, 15 March 2013
Line 10:		Line 10:
	** '''isType''' (flag): if TRUE, this type may be used for actual items; if not, it is a folder (type category)		** '''isType''' (flag): if TRUE, this type may be used for actual items; if not, it is a folder (type category)
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql> DROP TABLE IF EXISTS `cat_ittyps`;		<mysql> DROP TABLE IF EXISTS `cat_ittyps`;
	CREATE TABLE `cat_ittyps` (		CREATE TABLE `cat_ittyps` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
Line 21:		Line 21:
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: extracted from "tables" page

2008-12-06T15:28:14Z

extracted from "tables" page

New page

==About==
* '''Purpose''': catalog item types - every item has one, but they are often all the same
* '''Fields''':
** '''ID_Parent''' (int): {{vbzcart/table|cat_ittyps}}.ID of parent, if any
** '''NameSng''' (string): word for single item of this type (e.g. "shirt","box")
** '''NamePlr''' (string): word for multiple items of this type (e.g. "shirts","boxes")
** '''Descr''' (string): longer name, e.g. "compact disc" instead of "CD". If blank, use NameSng.
*** '''Q''': should this contain plural text? Or will we need DescrSng and DescrPlr?
** '''Sort''' (string): sorting key (optional)
** '''isType''' (flag): if TRUE, this type may be used for actual items; if not, it is a folder (type category)
==SQL==
<section begin=sql /><mysql> DROP TABLE IF EXISTS `cat_ittyps`;
CREATE TABLE `cat_ittyps` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Parent` INT COMMENT '(self).ID of parent type; mainly for organizational purposes',
`NameSng` varchar(63) NOT NULL COMMENT 'word for single item of this type (e.g. "shirt", "box")',
`NamePlr` varchar(63) COMMENT 'word for multiple items of this type (e.g. "shirts", "boxes"); NULL = use singular',
`Descr` varchar(255) COMMENT 'longer name (singular), e.g. "compact disc" instead of "CD". NULL = use singular',
`Sort` varchar(31) COMMENT "optional sorting key",
`isType` BOOL COMMENT 'FALSE = just a folder, so omit it from drop-down lists of types to choose from',
PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>
<section end=sql />

VbzCart/tables/cat ittyps - Revision history

Woozle: removed "section" tags

Woozle: extracted from "tables" page