VbzCart/tables/ctg items

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | tables
Revision as of 18:51, 8 March 2009 by Woozle (talk | contribs) (New page: ==About== * '''Purpose''': Specifies which item varieties/prices are available in a group ==SQL== <section begin=sql /><mysql>CREATE TABLE `ctg_items` ( ID INT NOT NULL AUTO_...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

About

  • Purpose: Specifies which item varieties/prices are available in a group

SQL

<mysql>CREATE TABLE `ctg_items` (

 ID             INT NOT NULL AUTO_INCREMENT,
 ID_Group       INT NOT NULL COMMENT "ctg_groups.ID",
 ID_ItTyp       INT NOT NULL COMMENT "cat_ittyps.ID -- basic item type",
 ID_ItOpt       INT DEFAULT NULL COMMENT "cat_itopts.ID -- option for this item",
 Descr          VARCHAR(63) COMMENT "name or description for this item/option",
 PriceBuy       DECIMAL(9,2) DEFAULT NULL COMMENT "cost to us",
 PriceSell      DECIMAL(9,2) DEFAULT NULL COMMENT "our price to retail customer",
 PriceList      DECIMAL(9,2) DEFAULT NULL COMMENT "supplier's suggested retail price",
 ID_ShipCost    INT DEFAULT NULL COMMENT "cat_ship_costs.ID",
 isActive       BOOL DEFAULT FALSE COMMENT "this group/type/option is available",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>