VbzCart/tables/ dept ittyps

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>