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 (qryItTypsDepts_ItTyps) was temporarily in use.
• 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
  • 2011-02-02 added ID_Supp field so we can actually use this without doing another join

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,
  `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;</mysql>

<section end=sql />