VbzCart/tables/ctg upd1

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

About

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

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>