Difference between revisions of "VbzCart/tables/ dept ittyps"
Jump to navigation
Jump to search
(created in db; a little doc) |
(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: Upd_DeptIttyps_fr_TitleIttyps, Upd_DeptIttyps_fr_CatIttyps
- Used by: Upd_Depts_fr_DeptIttyps
- History:
- 2010-11-12 (re)created in database -- apparently was not ported from L48 to Rizzo
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>