VbzCart/tables/shop cart line - Revision history

Woozle: fixed markup tags

2019-08-07T21:20:34Z

fixed markup tags

← Older revision		Revision as of 21:20, 7 August 2019
Line 11:		Line 11:
	** '''Seq''': unique incremental sequence number for each line in the cart, for identifying the record in contexts where it is exposed to outside manipulation. This way, URL/form hacking can never affect another cart's lines.		** '''Seq''': unique incremental sequence number for each line in the cart, for identifying the record in contexts where it is exposed to outside manipulation. This way, URL/form hacking can never affect another cart's lines.
	==SQL==		==SQL==
	<mysql>DROP TABLE IF EXISTS `shop_cart_line`;		<source lang=mysql>DROP TABLE IF EXISTS `shop_cart_line`;
	CREATE TABLE `shop_cart_line` (		CREATE TABLE `shop_cart_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
Line 21:		Line 21:
	`WhenEdited` DATETIME DEFAULT NULL COMMENT "when the quantity for this item was last changed",		`WhenEdited` DATETIME DEFAULT NULL COMMENT "when the quantity for this item was last changed",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = ~~MYISAM~~;</~~mysql~~>		) ENGINE = InnoDB;</source>
	==Removed==		==Removed==
	I'm inclined to think that these don't belong here, but rather in {{vbzcart\|table\|ord_lines}}:		I'm inclined to think that these don't belong here, but rather in {{vbzcart\|table\|ord_lines}}:
	<mysql>		<source lang=mysql>
	/* The remaining fields preserve a record of how the item was presented to the customer, and should be used		/* The remaining fields preserve a record of how the item was presented to the customer, and should be used
	at shipping time -- overriding any possible changes to the item's catalog record. */		at shipping time -- overriding any possible changes to the item's catalog record. */
Line 35:		Line 35:
	`DescText` VARCHAR(255) NOT NULL COMMENT "plain-text description of item being ordered (e.g. for emails)",		`DescText` VARCHAR(255) NOT NULL COMMENT "plain-text description of item being ordered (e.g. for emails)",
	`DescHtml` VARCHAR(255) NOT NULL COMMENT "HTML description of item being ordered, for web-page display",		`DescHtml` VARCHAR(255) NOT NULL COMMENT "HTML description of item being ordered, for web-page display",
	</~~mysql~~>		</source>

Woozle: removed old markup

2014-07-05T20:53:44Z

removed old markup

← Older revision		Revision as of 20:53, 5 July 2014
Line 11:		Line 11:
	** '''Seq''': unique incremental sequence number for each line in the cart, for identifying the record in contexts where it is exposed to outside manipulation. This way, URL/form hacking can never affect another cart's lines.		** '''Seq''': unique incremental sequence number for each line in the cart, for identifying the record in contexts where it is exposed to outside manipulation. This way, URL/form hacking can never affect another cart's lines.
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>DROP TABLE IF EXISTS `shop_cart_line`;		<mysql>DROP TABLE IF EXISTS `shop_cart_line`;
	CREATE TABLE `shop_cart_line` (		CREATE TABLE `shop_cart_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
Line 22:		Line 22:
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~
	==Removed==		==Removed==
	I'm inclined to think that these don't belong here, but rather in {{vbzcart\|table\|ord_lines}}:		I'm inclined to think that these don't belong here, but rather in {{vbzcart\|table\|ord_lines}}:

Woozle: WhenEdited DEFAULT NULL

2009-09-10T22:28:07Z

WhenEdited DEFAULT NULL

← Older revision		Revision as of 22:28, 10 September 2009
Line 7:		Line 7:
	*** Tentatively removed all "item presentation" fields -- they belong in {{vbzcart\|table\|ord_lines}}		*** Tentatively removed all "item presentation" fields -- they belong in {{vbzcart\|table\|ord_lines}}
	*** Added '''Seq''' field		*** Added '''Seq''' field
			** '''2009-09-10''' No reason for WhenEdited to be NOT NULL; it should be NULL if the cart item is never changed after being added. The only change would be quantity. Changes to cart lines should be in the cart log anyway, so this field is probably an unused frill.
	* '''Fields''':		* '''Fields''':
	** '''Seq''': unique incremental sequence number for each line in the cart, for identifying the record in contexts where it is exposed to outside manipulation. This way, URL/form hacking can never affect another cart's lines.		** '''Seq''': unique incremental sequence number for each line in the cart, for identifying the record in contexts where it is exposed to outside manipulation. This way, URL/form hacking can never affect another cart's lines.
Line 18:		Line 19:
	`Qty` INT NOT NULL COMMENT "quantity ordered; 0 = removed from order",		`Qty` INT NOT NULL COMMENT "quantity ordered; 0 = removed from order",
	`WhenAdded` DATETIME NOT NULL COMMENT "when this item was first added to the order",		`WhenAdded` DATETIME NOT NULL COMMENT "when this item was first added to the order",
	`WhenEdited` DATETIME ~~NOT~~ NULL COMMENT "when the quantity for this item was last changed",		`WhenEdited` DATETIME DEFAULT NULL COMMENT "when the quantity for this item was last changed",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>

Woozle: +Seq field

2009-07-12T16:48:35Z

+Seq field

← Older revision		Revision as of 16:48, 12 July 2009
Line 4:		Line 4:
	* '''History''':		* '''History''':
	** '''2009-06-16''' Changing table name to singular		** '''2009-06-16''' Changing table name to singular
	** '''2009-07-12''' Tentatively removed all "item presentation" fields -- they belong in {{vbzcart\|table\|ord_lines}}		** '''2009-07-12'''
			*** Tentatively removed all "item presentation" fields -- they belong in {{vbzcart\|table\|ord_lines}}
			*** Added '''Seq''' field
			* '''Fields''':
			** '''Seq''': unique incremental sequence number for each line in the cart, for identifying the record in contexts where it is exposed to outside manipulation. This way, URL/form hacking can never affect another cart's lines.
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_line`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_line`;
	CREATE TABLE `shop_cart_line` (		CREATE TABLE `shop_cart_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
			`Seq` INT NOT NULL COMMENT "sequence # within cart",
	`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",		`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",
	`ID_Item` INT NOT NULL COMMENT "cat_items.ID",		`ID_Item` INT NOT NULL COMMENT "cat_items.ID",

Woozle: formatting tweaks; removing all "item presentation" fields

2009-07-12T14:12:55Z

formatting tweaks; removing all "item presentation" fields

← Older revision		Revision as of 14:12, 12 July 2009
Line 4:		Line 4:
	* '''History''':		* '''History''':
	** '''2009-06-16''' Changing table name to singular		** '''2009-06-16''' Changing table name to singular
			** '''2009-07-12''' Tentatively removed all "item presentation" fields -- they belong in {{vbzcart\|table\|ord_lines}}
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_line`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_line`;
	CREATE TABLE `shop_cart_line` (		CREATE TABLE `shop_cart_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",		`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",
	`ID_Item` INT NOT NULL COMMENT "cat_items.ID",		`ID_Item` INT NOT NULL COMMENT "cat_items.ID",
	`Qty` INT NOT NULL COMMENT "quantity ordered; 0 = removed from order",		`Qty` INT NOT NULL COMMENT "quantity ordered; 0 = removed from order",
	`WhenAdded` DATETIME NOT NULL COMMENT "when this item was first added to the order",		`WhenAdded` DATETIME NOT NULL COMMENT "when this item was first added to the order",
	`WhenEdited` DATETIME NOT NULL COMMENT "when the quantity for this item was last changed",		`WhenEdited` DATETIME NOT NULL COMMENT "when the quantity for this item was last changed",
	~~`PriceItem` DECIMAL(9,2) NOT NULL COMMENT "price of item quoted at order time",~~
	~~`PriceShItm` DECIMAL(9,2) NOT NULL COMMENT "per-item shipping quoted for this item at order time",~~
	~~`PriceShPkg` DECIMAL(9,2) NOT NULL COMMENT "per-package shipping quoted for this item at order time",~~
	~~/* These fields are redundant, and are used mainly to speed up cart display. They also preserve a record of~~
	~~how the item was presented to the customer. */~~
	~~`CatNum` VARCHAR(63) COMMENT "cat_items.CatNum of item as sold",~~
	~~`ID_Title` INT NOT NULL COMMENT "cat_titles.ID",~~
	~~`DescText` VARCHAR(255) NOT NULL COMMENT "plain-text description of item being ordered (e.g. for emails)",~~
	~~`DescHtml` VARCHAR(255) NOT NULL COMMENT "HTML description of item being ordered, for web-page display~~",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />
			==Removed==
			I'm inclined to think that these don't belong here, but rather in {{vbzcart\|table\|ord_lines}}:
			<mysql>
			/* The remaining fields preserve a record of how the item was presented to the customer, and should be used
			at shipping time -- overriding any possible changes to the item's catalog record. */

			`PriceItem` DECIMAL(9,2) NOT NULL COMMENT "price of item quoted at order time",
			`PriceShItm` DECIMAL(9,2) NOT NULL COMMENT "per-item shipping quoted for this item at order time",
			`PriceShPkg` DECIMAL(9,2) NOT NULL COMMENT "per-package shipping quoted for this item at order time",
			`CatNum` VARCHAR(63) COMMENT "cat_items.CatNum of item as sold",
			`ID_Title` INT NOT NULL COMMENT "cat_titles.ID",
			`DescText` VARCHAR(255) NOT NULL COMMENT "plain-text description of item being ordered (e.g. for emails)",
			`DescHtml` VARCHAR(255) NOT NULL COMMENT "HTML description of item being ordered, for web-page display",
			</mysql>

Woozle: changing table names to singular

2009-06-16T23:54:17Z

changing table names to singular

← Older revision		Revision as of 23:54, 16 June 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': individual items in a shopping cart~~; child table of~~ {{vbzcart\|table\|~~shop_carts~~}}		* '''Purpose''': individual items in a shopping cart
			* '''Parent''': {{vbzcart\|table\|shop_cart}}
			* '''History''':
			** '''2009-06-16''' Changing table name to singular
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `~~shop_cart_lines~~`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_line`;
	CREATE TABLE `~~shop_cart_lines~~` (		CREATE TABLE `shop_cart_line` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Cart` INT NOT NULL COMMENT "~~shop_carts~~.ID",		`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",
	`ID_Item` INT NOT NULL COMMENT "cat_items.ID",		`ID_Item` INT NOT NULL COMMENT "cat_items.ID",
	`Qty` INT NOT NULL COMMENT "quantity ordered; 0 = removed from order",		`Qty` INT NOT NULL COMMENT "quantity ordered; 0 = removed from order",

Woozle: VbzCart/tables/shop cart lines moved to VbzCart/tables/shop cart line: changing table names to singular

2009-06-16T23:52:48Z

VbzCart/tables/shop cart lines moved to VbzCart/tables/shop cart line: changing table names to singular

← Older revision	Revision as of 23:52, 16 June 2009
(No difference)

Woozle: New page: ==About== * '''Purpose''': individual items in a shopping cart; child table of {{vbzcart|table|shop_carts}} ==SQL==
DROP TABLE IF EXISTS `shop_cart_lines`; CREA...

2009-03-08T19:06:32Z

New page: ==About== * '''Purpose''': individual items in a shopping cart; child table of {{vbzcart|table|shop_carts}} ==SQL== <section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_lines`; CREA...

New page

==About==
* '''Purpose''': individual items in a shopping cart; child table of {{vbzcart|table|shop_carts}}
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_lines`;
CREATE TABLE `shop_cart_lines` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Cart` INT NOT NULL COMMENT "shop_carts.ID",
`ID_Item` INT NOT NULL COMMENT "cat_items.ID",
`Qty` INT NOT NULL COMMENT "quantity ordered; 0 = removed from order",
`WhenAdded` DATETIME NOT NULL COMMENT "when this item was first added to the order",
`WhenEdited` DATETIME NOT NULL COMMENT "when the quantity for this item was last changed",
`PriceItem` DECIMAL(9,2) NOT NULL COMMENT "price of item quoted at order time",
`PriceShItm` DECIMAL(9,2) NOT NULL COMMENT "per-item shipping quoted for this item at order time",
`PriceShPkg` DECIMAL(9,2) NOT NULL COMMENT "per-package shipping quoted for this item at order time",
/* These fields are redundant, and are used mainly to speed up cart display. They also preserve a record of
how the item was presented to the customer. */
`CatNum` VARCHAR(63) COMMENT "cat_items.CatNum of item as sold",
`ID_Title` INT NOT NULL COMMENT "cat_titles.ID",
`DescText` VARCHAR(255) NOT NULL COMMENT "plain-text description of item being ordered (e.g. for emails)",
`DescHtml` VARCHAR(255) NOT NULL COMMENT "HTML description of item being ordered, for web-page display",
PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>
<section end=sql />