https://htyp.org/mw/index.php?action=history&feed=atom&title=VbzCart%2Ftables%2Fctg_upd2VbzCart/tables/ctg upd2 - Revision history2026-06-25T21:04:13ZRevision history for this page on the wikiMediaWiki 1.45.3https://htyp.org/mw/index.php?title=VbzCart/tables/ctg_upd2&diff=11476&oldid=prevWoozle: 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...2009-03-08T18:58:06Z<p>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...</p>
<p><b>New page</b></p><div>==About==<br />
* '''Purpose''': Experimental, but hopefully will replace {{vbzcart|table|ctg_updates}} which never worked entirely properly.<br />
==SQL==<br />
<section begin=sql /><mysql>CREATE TABLE `ctg_upd2` (<br />
ID_Item INT DEFAULT NULL COMMENT "cat_items.ID",<br />
IDS_Item VARCHAR(63) NOT NULL UNIQUE COMMENT "cat_titles.ID + CatSfx",<br />
isForSale BOOL DEFAULT FALSE COMMENT "to be recalculated (assume false, then set true if available or in stock)",<br />
QtyInStock INT DEFAULT NULL COMMENT "to be recalculated",<br />
Supp_CatNum VARCHAR(32) COMMENT "preserved from cat_items",<br />
QtyMin_Stk INT DEFAULT NULL COMMENT "preserved from cat_items",<br />
cntDups INT DEFAULT 0,<br />
PRIMARY KEY(`IDS_Item`),<br />
UNIQUE KEY(`ID_Item`)<br />
)<br />
ENGINE = MYISAM;</mysql><br />
<section end=sql /></div>Woozle