VbzCart/tables/ctg upd1

From HTYP, the free directory anyone can edit

[edit] About

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

[edit] SQL

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;