VbzCart/tables/ctg upd2

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: Experimental, but hopefully will replace ctg_updates which never worked entirely properly.

SQL

<mysql>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;</mysql>