VbzCart/docs/tables/ctg items: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (+Sort field) |
m (Woozle moved page VbzCart/VbzCart/tables/ctg items to VbzCart/docs/tables/ctg items without leaving a redirect: part 3/5) |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Specifies which item varieties/prices are available in a group | * '''Purpose''': Specifies which item varieties/prices are available in a group | ||
* '''Part of''': {{l/vc|pieces/catalog/building}} | |||
* '''History''': | * '''History''': | ||
** '''2011-02-13''' added '''Sort''' field | ** '''2011-02-13''' added '''Sort''' field | ||
** '''2017-06-12''' changed engine from MYISAM to InnoDB | |||
==SQL== | ==SQL== | ||
<mysql>CREATE TABLE `ctg_items` ( | |||
ID INT NOT NULL AUTO_INCREMENT, | ID INT NOT NULL AUTO_INCREMENT, | ||
ID_Group INT NOT NULL COMMENT "ctg_groups.ID", | ID_Group INT NOT NULL COMMENT "ctg_groups.ID", | ||
| Line 18: | Line 20: | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = | ENGINE = InnoDB;</mysql> | ||
Latest revision as of 01:56, 25 February 2024
About
- Purpose: Specifies which item varieties/prices are available in a group
- Part of: Template:L/vc
- History:
- 2011-02-13 added Sort field
- 2017-06-12 changed engine from MYISAM to InnoDB
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", Sort VARCHAR(15) DEFAULT NULL COMMENT "sorting order for display", 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 = InnoDB;</mysql>