VbzCart/tables/ctg upd2

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: Experimental, but hopefully will replace ctg_updates which never worked entirely properly.

[edit] SQL

CREATE TABLE `ctg_upd2` (
  ID_Item        INT DEFAULT NULL            COMMENT "cat_items.ID",
  IDS_Item       VARCHAR(63) NOT NULL UNIQUE COMMENT "cat_titles.ID + CatSfx",
  isForSale      BOOL DEFAULT FALSE          COMMENT "to be recalculated (assume false, then set true if available or in stock)",
  QtyInStock     INT DEFAULT NULL            COMMENT "to be recalculated",
  Supp_CatNum    VARCHAR(32)                 COMMENT "preserved from cat_items",
  QtyMin_Stk     INT DEFAULT NULL            COMMENT "preserved from cat_items",
  cntDups        INT DEFAULT 0,
  PRIMARY KEY(`IDS_Item`),
  UNIQUE KEY(`ID_Item`)
)
ENGINE = MYISAM;