VbzCart/tables/ dept ittyps

About

 * Purpose: cache table for catalog display
 * Used for: customer-side supplier pages (/cat/xx/)
 * Earlier note indicated it was used for customer-side department page, but I don't see evidence of this. (2011-02-02)
 * Prior to 2011-02-02, a very slow query was temporarily in use.
 * Sources: ,
 * Used by:
 * History:
 * 2010-11-12 (re)created in database -- apparently was not ported from L48 to Rizzo
 * 2011-02-02 added ID_Supp field so we can actually use this without doing another join

SQL
DROP TABLE IF EXISTS `_dept_ittyps`; CREATE TABLE `_dept_ittyps` (  `ID_ItTyp`   INT UNSIGNED NOT NULL,   `ID_Dept`    INT UNSIGNED NOT NULL,   `ID_Supp`    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;