https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Ftables%2Fcat_ioptnsVbzCart/tables/cat ioptns - Revision history2026-06-25T18:02:00ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=VbzCart/tables/cat_ioptns&diff=10989&oldid=prevWoozle: extracted from "tables" page2008-12-06T15:31:07Z<p>extracted from "tables" page</p>
<p><b>New page</b></p><div>==About==<br />
* '''Purpose''': catalog options - these typically distinguish items within a title<br />
* '''Fields''':<br />
** '''CatKey''' (string(8)): appended to catalog number (with dash prefix)<br />
** '''Descr''' (string(64)): appended to item description (with separator of some kind)<br />
** '''Sort''' (string(8)): sorting order when options for a title appear together in a list<br />
==SQL==<br />
<section begin=sql /><mysql> CREATE TABLE `cat_ioptns` (<br />
`ID` INT NOT NULL AUTO_INCREMENT,<br />
`CatKey` varchar(7) NOT NULL COMMENT 'appended to catalog number (with dash prefix)',<br />
`Descr` varchar(127) NOT NULL COMMENT 'appended to item description (with separator of some kind)',<br />
`Sort` varchar(7) COMMENT 'sorting order when options for a title appear together in a list',<br />
PRIMARY KEY(`ID`)<br />
) ENGINE = MYISAM;</mysql><br />
<section end=sql /></div>Woozle