VbzCart/tables/ dept ittyps

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | tables
Revision as of 17:02, 2 February 2011 by Woozle (talk | contribs) (+ID_Supp)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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 (
  1. REDIRECT Template:l/vc/query) was temporarily in use.

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>