VbzCart/docs/tables/ dept ittyps

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 />