VbzCart/docs/tables/ dept ittyps: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (created in db; a little doc) |
imported>Woozle (sources, used by) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': cache table for catalog display | * '''Purpose''': cache table for catalog display | ||
* '''Used | * '''Used for''': customer-side department pages | ||
* '''Sources''': {{vbzcart|proc|Upd_DeptIttyps_fr_TitleIttyps}}, {{vbzcart|proc|Upd_DeptIttyps_fr_CatIttyps}} | |||
* '''Used by''': {{vbzcart|proc|Upd_Depts_fr_DeptIttyps}} | |||
* '''History''': | * '''History''': | ||
** '''2010-11-12''' (re)created in database -- apparently was not ported from L48 to Rizzo | ** '''2010-11-12''' (re)created in database -- apparently was not ported from L48 to Rizzo | ||
Revision as of 16:52, 14 November 2010
About
- Purpose: cache table for catalog display
- Used for: customer-side department pages
- Sources: Template:Vbzcart, Template:Vbzcart
- Used by: Template:Vbzcart
- 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 />