VbzCart/tables/ctg items - Revision history

Woozle: link to catalog-building doc area

2017-06-12T11:13:52Z

link to catalog-building doc area

← Older revision		Revision as of 11:13, 12 June 2017
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==
	~~<section begin=sql />~~<mysql>CREATE TABLE `ctg_items` (		<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 = ~~MYISAM~~;</mysql>		ENGINE = InnoDB;</mysql>
	~~<section end=sql /~~>

Woozle: +Sort field

2011-02-13T14:09:58Z

+Sort field

← Older revision		Revision as of 14:09, 13 February 2011
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
			* '''History''':
			** '''2011-02-13''' added '''Sort''' field
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `ctg_items` (		<section begin=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",
	ID_ItTyp INT NOT NULL COMMENT "cat_ittyps.ID -- basic item type",		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",		ID_ItOpt INT DEFAULT NULL COMMENT "cat_itopts.ID -- option for this item",
	Descr VARCHAR(63) COMMENT "name or description for this item/option",		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",		PriceBuy DECIMAL(9,2) DEFAULT NULL COMMENT "cost to us",
	PriceSell DECIMAL(9,2) DEFAULT NULL COMMENT "our price to retail customer",		PriceSell DECIMAL(9,2) DEFAULT NULL COMMENT "our price to retail customer",
	PriceList DECIMAL(9,2) DEFAULT NULL COMMENT "supplier's suggested retail price",		PriceList DECIMAL(9,2) DEFAULT NULL COMMENT "supplier's suggested retail price",
	ID_ShipCost INT DEFAULT NULL COMMENT "cat_ship_costs.ID",		ID_ShipCost INT DEFAULT NULL COMMENT "cat_ship_costs.ID",
	isActive BOOL DEFAULT FALSE COMMENT "this group/type/option is available",		isActive BOOL DEFAULT FALSE COMMENT "this group/type/option is available",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: New page: ==About== * '''Purpose''': Specifies which item varieties/prices are available in a group ==SQL==
CREATE TABLE `ctg_items` ( ID INT NOT NULL AUTO_...

2009-03-08T18:51:36Z

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_...

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_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>
<section end=sql />

VbzCart/tables/ctg items - Revision history

Woozle: link to catalog-building doc area

Woozle: +Sort field

Woozle: New page: ==About== * '''Purpose''': Specifies which item varieties/prices are available in a group ==SQL== CREATE TABLE `ctg_items` ( ID INT NOT NULL AUTO_...

Woozle: New page: ==About== * '''Purpose''': Specifies which item varieties/prices are available in a group ==SQL==
CREATE TABLE `ctg_items` ( ID INT NOT NULL AUTO_...