VbzCart/docs/tables/ dept ittyps: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==SQL== <section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`; CREATE TABLE `_dept_ittyps` ( `ID_ItTyp` int unsigned NOT NULL, `ID_Dept` int unsigned NOT NULL, `cntFor...) |
imported>Woozle (created in db; a little doc) |
||
| Line 1: | Line 1: | ||
==About== | |||
* '''Purpose''': cache table for catalog display | |||
* '''Used by''': department pages | |||
* '''History''': | |||
** '''2010-11-12''' (re)created in database -- apparently was not ported from L48 to Rizzo | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`; | <section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`; | ||
| Line 10: | Line 15: | ||
`ItTypNamePlr` varchar(64) DEFAULT NULL COMMENT 'cat_ittyps.NamePlr; default to ItTypNameSng', | `ItTypNamePlr` varchar(64) DEFAULT NULL COMMENT 'cat_ittyps.NamePlr; default to ItTypNameSng', | ||
PRIMARY KEY (`ID_ItTyp`,`ID_Dept`) | PRIMARY KEY (`ID_ItTyp`,`ID_Dept`) | ||
) ENGINE=MyISAM | ) ENGINE=MyISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 02:51, 13 November 2010
About
- Purpose: cache table for catalog display
- Used by: department pages
- History:
- 2010-11-12 (re)created in database -- apparently was not ported from L48 to Rizzo
SQL
<section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`;
CREATE TABLE `_dept_ittyps` ( `ID_ItTyp` int unsigned NOT NULL, `ID_Dept` int unsigned NOT NULL, `cntForSale` int unsigned NOT NULL, `cntInPrint` int unsigned NOT NULL, `qtyInStock` int unsigned NOT NULL, `ItTypNameSng` varchar(64) DEFAULT NULL COMMENT 'cat_ittyps.NameSng', `ItTypNamePlr` varchar(64) DEFAULT NULL COMMENT 'cat_ittyps.NamePlr; default to ItTypNameSng', PRIMARY KEY (`ID_ItTyp`,`ID_Dept`) ) ENGINE=MyISAM;</mysql>
<section end=sql />