VbzCart/docs/tables/ctg upd2

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search

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

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/ctg_upd2&oldid=6891"