Difference between revisions of "VbzCart/tables/ dept ittyps"
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''': | + | * '''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` | + | `ID_ItTyp` INT UNSIGNED NOT NULL, |
| − | `ID_Dept` | + | `ID_Dept` INT UNSIGNED NOT NULL, |
| − | `cntForSale` | + | `ID_Supp` INT UNSIGNED NOT NULL, |
| − | `cntInPrint` | + | `cntForSale` INT UNSIGNED NOT NULL, |
| − | `qtyInStock` | + | `cntInPrint` INT UNSIGNED NOT NULL, |
| − | `ItTypNameSng` | + | `qtyInStock` INT UNSIGNED NOT NULL, |
| − | `ItTypNamePlr` | + | `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 (
- REDIRECT Template:l/vc/query) 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
<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>