VbzCart/docs/tables/ctg upd1

About

• Purpose: intermediate calculations for updating Template:Vbzcart from catalog-source tables
  • Replaces Template:Vbzcart which never worked entirely properly.
• Source: Template:Vbzcart/query (essential fields only)
• History:
  • 2010-12-29 Added ID_Supp field because Template:Vbzcart now has that field too
  • 2011-01-02 Added TitleName to fill in new Descr field in Template:Vbzcart
  • 2014-08-17 Removed ID_CTG_Title to match output of Template:Vbzcart/query.

SQL

<mysql>CREATE TABLE `ctg_upd1` (

 CatSfx            VARCHAR(31),
 isCloseOut        BOOL,
 ID_CTG_Item       INT,
 ID_Supp           INT,
 ID_Title          INT,
 ID_ItTyp          INT,
 ID_ItOpt          INT,
 ID_ShipCost       INT,
 PriceBuy          DECIMAL(9,2),
 PriceSell         DECIMAL(9,2),
 PriceList         DECIMAL(9,2),
 ItOpt_Descr_part  VARCHAR(63),
 NameSng           VARCHAR(63),
 TitleName         VARCHAR(127),
 GrpItmDescr       VARCHAR(63),
 TitleGroupDescr   VARCHAR(63),
 OptionDescr       VARCHAR(63),
 ItOpt_Sort        VARCHAR(31),
 GrpCode           VARCHAR(15),
 GrpDescr          VARCHAR(31),
 GrpSort           VARCHAR(31),
 IDS_Item          VARCHAR(31),
 CatNum            VARCHAR(31),
 ItOpt_Descr       VARCHAR(63),
 PRIMARY KEY(`IDS_Item`)

) ENGINE = MYISAM;</mysql>