VbzCart/docs/tables/ctg upd2: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==About== * '''Purpose''': Experimental, but hopefully will replace {{vbzcart|table|ctg_updates}} which never worked entirely properly. ==SQL== <section begin=sql /><mysql>CREATE TABLE `ct...) |
m (Woozle moved page VbzCart/VbzCart/tables/ctg upd2 to VbzCart/docs/tables/ctg upd2 without leaving a redirect: part 3/5) |
(No difference)
| |
Latest revision as of 01:56, 25 February 2024
About
- Purpose: Experimental, but hopefully will replace Template:Vbzcart which never worked entirely properly.
SQL
<section begin=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> <section end=sql />