VbzCart/tables/ctg upd1

About

• Purpose: Experimental, but hopefully will replace ctg_updates which never worked entirely properly. This table contains only the essential fields from

1. REDIRECT Template:l/vc/query.

SQL

<mysql>CREATE TABLE `ctg_upd1` (

 CatSfx            VARCHAR(31),
 isCloseOut        BOOL,
 ID_CTG_Title      INT,
 ID_CTG_Item       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),
 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>