VbzCart/tables/ctg upd2
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>