Difference between revisions of "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
(TitleName)
(removed unwanted column)
 
Line 6: Line 6:
 
** '''2010-12-29''' Added '''ID_Supp''' field because {{vbzcart|table|cat_items}} now has that field too
 
** '''2010-12-29''' Added '''ID_Supp''' field because {{vbzcart|table|cat_items}} now has that field too
 
** '''2011-01-02''' Added '''TitleName''' to fill in new '''Descr''' field in {{vbzcart|table|cat_items}}
 
** '''2011-01-02''' Added '''TitleName''' to fill in new '''Descr''' field in {{vbzcart|table|cat_items}}
 +
** '''2014-08-17''' Removed '''ID_CTG_Title''' to match output of {{vbzcart/query|qryCtg_src_sub}}.
 
==SQL==
 
==SQL==
<section begin=sql /><mysql>CREATE TABLE `ctg_upd1` (
+
<mysql>CREATE TABLE `ctg_upd1` (
 
   CatSfx            VARCHAR(31),
 
   CatSfx            VARCHAR(31),
 
   isCloseOut        BOOL,
 
   isCloseOut        BOOL,
  ID_CTG_Title      INT,
 
 
   ID_CTG_Item      INT,
 
   ID_CTG_Item      INT,
 
   ID_Supp          INT,
 
   ID_Supp          INT,
Line 36: Line 36:
 
)
 
)
 
ENGINE = MYISAM;</mysql>
 
ENGINE = MYISAM;</mysql>
<section end=sql />
 

Latest revision as of 01:07, 18 August 2014

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>