Difference between revisions of "VbzCart/tables/ dept ittyps"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(created in db; a little doc)
(+ID_Supp)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
 
==About==
 
==About==
 
* '''Purpose''': cache table for catalog display
 
* '''Purpose''': cache table for catalog display
* '''Used by''': department pages
+
* '''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 ({{vbzcart/query|qryItTypsDepts_ItTyps}}) was temporarily in use.
 +
* '''Sources''': {{vbzcart|proc|Upd_DeptIttyps_fr_TitleIttyps}}, {{vbzcart|proc|Upd_DeptIttyps_fr_CatIttyps}}
 +
* '''Used by''': {{vbzcart|proc|Upd_Depts_fr_DeptIttyps}}
 
* '''History''':
 
* '''History''':
 
** '''2010-11-12''' (re)created in database -- apparently was not ported from L48 to Rizzo
 
** '''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==
 
==SQL==
 
<section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`;
 
<section begin=sql /><mysql> DROP TABLE IF EXISTS `_dept_ittyps`;
 
  CREATE TABLE `_dept_ittyps` (
 
  CREATE TABLE `_dept_ittyps` (
   `ID_ItTyp` int unsigned NOT NULL,
+
   `ID_ItTyp`   INT UNSIGNED NOT NULL,
   `ID_Dept` int unsigned NOT NULL,
+
   `ID_Dept`   INT UNSIGNED NOT NULL,
   `cntForSale` int unsigned NOT NULL,
+
  `ID_Supp`    INT UNSIGNED NOT NULL,
   `cntInPrint` int unsigned NOT NULL,
+
   `cntForSale` INT UNSIGNED NOT NULL,
   `qtyInStock` int unsigned NOT NULL,
+
   `cntInPrint` INT UNSIGNED NOT NULL,
   `ItTypNameSng` varchar(64) DEFAULT NULL COMMENT 'cat_ittyps.NameSng',
+
   `qtyInStock` INT UNSIGNED NOT NULL,
   `ItTypNamePlr` varchar(64) DEFAULT NULL COMMENT 'cat_ittyps.NamePlr; default to ItTypNameSng',
+
   `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`)
 
   PRIMARY KEY (`ID_ItTyp`,`ID_Dept`)
 
  ) ENGINE=MyISAM;</mysql>
 
  ) ENGINE=MyISAM;</mysql>
 
<section end=sql />
 
<section end=sql />

Latest revision as of 17:02, 2 February 2011

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>