VbzCart/tables/shop cart data - Revision history

Woozle: obsolete

2019-07-25T15:05:44Z

obsolete

← Older revision		Revision as of 15:05, 25 July 2019
Line 1:		Line 1:
	==About==		==About==
			* '''OBSOLETE'''
	* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.		* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.
	* '''Relates to''': parent: {{l/same\|shop_cart}}		* '''Relates to''': parent: {{l/same\|shop_cart}}
Line 7:		Line 8:
	** '''2014-11-04''' renamed "Type" field to "ID_Type"		** '''2014-11-04''' renamed "Type" field to "ID_Type"
	** '''2015-01-20''' added '''WhenCrypt''' field		** '''2015-01-20''' added '''WhenCrypt''' field
			** '''2019-07-25''' this table has been obsolete/unused for months (in dev code)
	==Fields==		==Fields==
	* '''ID_Type''': numeric constants are currently defined in {{vbzcart/code\|vbz-const-ckout.php}}.		* '''ID_Type''': numeric constants are currently defined in {{l/vbzcart/code\|vbz-const-ckout.php}}.
	* '''WhenCrypt''': this is primarily a signal that '''Val''' has been encrypted. If it is NULL, then '''Val''' is plaintext. This is so we can encrypt sensitive data left in shopping carts.		* '''WhenCrypt''': this is primarily a signal that '''Val''' has been encrypted. If it is NULL, then '''Val''' is plaintext. This is so we can encrypt sensitive data left in shopping carts.
	==SQL==		==SQL==
	<mysql>DROP TABLE IF EXISTS `shop_cart_data`;		<source lang=mysql>DROP TABLE IF EXISTS `shop_cart_data`;
	CREATE TABLE `shop_cart_data` (		CREATE TABLE `shop_cart_data` (
	`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",		`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",
Line 18:		Line 20:
	`WhenCrypt` DATETIME DEFAULT NULL "when encrypted (NULL = is plaintext)",		`WhenCrypt` DATETIME DEFAULT NULL "when encrypted (NULL = is plaintext)",
	PRIMARY KEY(`ID_Cart`,`Type`)		PRIMARY KEY(`ID_Cart`,`Type`)
	) ENGINE = MYISAM;</~~mysql~~>		) ENGINE = MYISAM;</source>

Woozle: now using template for GitHub links

2015-01-23T18:50:43Z

now using template for GitHub links

← Older revision		Revision as of 18:50, 23 January 2015
Line 8:		Line 8:
	** '''2015-01-20''' added '''WhenCrypt''' field		** '''2015-01-20''' added '''WhenCrypt''' field
	==Fields==		==Fields==
	* '''ID_Type''': numeric constants are currently defined in ~~[https:~~/~~/github.com/woozalia/VbzCart/blob/master/vbz-const-ckout.php~~ vbz-const-ckout.php].		* '''ID_Type''': numeric constants are currently defined in {{vbzcart/code\|vbz-const-ckout.php}}.
	* '''WhenCrypt''': this is primarily a signal that '''Val''' has been encrypted. If it is NULL, then '''Val''' is plaintext. This is so we can encrypt sensitive data left in shopping carts.		* '''WhenCrypt''': this is primarily a signal that '''Val''' has been encrypted. If it is NULL, then '''Val''' is plaintext. This is so we can encrypt sensitive data left in shopping carts.
	==SQL==		==SQL==

Woozle: location for ID_Type constants

2015-01-23T13:10:44Z

location for ID_Type constants

← Older revision		Revision as of 13:10, 23 January 2015
Line 7:		Line 7:
	** '''2014-11-04''' renamed "Type" field to "ID_Type"		** '''2014-11-04''' renamed "Type" field to "ID_Type"
	** '''2015-01-20''' added '''WhenCrypt''' field		** '''2015-01-20''' added '''WhenCrypt''' field
	==~~Notes~~==		==Fields==
	~~The "~~WhenCrypt~~" field~~ is primarily a signal that "Val" has been encrypted. If it is NULL, then "Val" is plaintext. This is so we can encrypt sensitive data left in shopping carts.		* '''ID_Type''': numeric constants are currently defined in [https://github.com/woozalia/VbzCart/blob/master/vbz-const-ckout.php vbz-const-ckout.php].
			* '''WhenCrypt''': this is primarily a signal that '''Val''' has been encrypted. If it is NULL, then '''Val''' is plaintext. This is so we can encrypt sensitive data left in shopping carts.
	==SQL==		==SQL==
	<mysql>DROP TABLE IF EXISTS `shop_cart_data`;		<mysql>DROP TABLE IF EXISTS `shop_cart_data`;

Woozle: "WhenCrypt" field

2015-01-20T19:08:12Z

"WhenCrypt" field

← Older revision		Revision as of 19:08, 20 January 2015
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.		* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.
	* '''Relates to''': {{l/same\|shop_cart}}		* '''Relates to''': parent: {{l/same\|shop_cart}}
	* '''History''':		* '''History''':
	** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type		** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type
	** '''2009-08-02''' removed "ID" field; now using ID_Cart+Type as primary key		** '''2009-08-02''' removed "ID" field; now using ID_Cart+Type as primary key
	** '''2014-11-04''' renamed "Type" field to "ID_Type"		** '''2014-11-04''' renamed "Type" field to "ID_Type"
			** '''2015-01-20''' added '''WhenCrypt''' field
			==Notes==
			The "WhenCrypt" field is primarily a signal that "Val" has been encrypted. If it is NULL, then "Val" is plaintext. This is so we can encrypt sensitive data left in shopping carts.
	==SQL==		==SQL==
	<mysql>DROP TABLE IF EXISTS `shop_cart_data`;		<mysql>DROP TABLE IF EXISTS `shop_cart_data`;
	CREATE TABLE `shop_cart_data` (		CREATE TABLE `shop_cart_data` (
	`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",		`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",
	`ID_Type` INT NOT NULL COMMENT "data type - defined in code",		`ID_Type` INT NOT NULL COMMENT "data type - defined in code",
	`Val` VARCHAR(255) NOT NULL COMMENT "Value of data item",		`Val` VARCHAR(255) NOT NULL COMMENT "Value of data item",
			`WhenCrypt` DATETIME DEFAULT NULL "when encrypted (NULL = is plaintext)",
	PRIMARY KEY(`ID_Cart`,`Type`)		PRIMARY KEY(`ID_Cart`,`Type`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>

Woozle: Type -> ID_Type

2014-11-04T13:14:32Z

Type -> ID_Type

← Older revision		Revision as of 13:14, 4 November 2014
Line 5:		Line 5:
	** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type		** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type
	** '''2009-08-02''' removed "ID" field; now using ID_Cart+Type as primary key		** '''2009-08-02''' removed "ID" field; now using ID_Cart+Type as primary key
			** '''2014-11-04''' renamed "Type" field to "ID_Type"
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>DROP TABLE IF EXISTS `shop_cart_data`;		<mysql>DROP TABLE IF EXISTS `shop_cart_data`;
	CREATE TABLE `shop_cart_data` (		CREATE TABLE `shop_cart_data` (
	`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",		`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",
	`~~Type~~` INT NOT NULL COMMENT "data type - defined in code",		`ID_Type` INT NOT NULL COMMENT "data type - defined in code",
	`Val` VARCHAR(255) NOT NULL COMMENT "Value of data item",		`Val` VARCHAR(255) NOT NULL COMMENT "Value of data item",
	PRIMARY KEY(`ID_Cart`,`Type`)		PRIMARY KEY(`ID_Cart`,`Type`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: relationship note; minor correction

2013-02-16T20:28:13Z

relationship note; minor correction

← Older revision		Revision as of 20:28, 16 February 2013
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.		* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.
			* '''Relates to''': {{l/same\|shop_cart}}
	* '''History''':		* '''History''':
	** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type		** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type
Line 7:		Line 8:
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_data`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_data`;
	CREATE TABLE `shop_cart_data` (		CREATE TABLE `shop_cart_data` (
	`ID_Cart` INT NOT NULL COMMENT "~~shop_carts~~.ID",		`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",
	`Type` INT NOT NULL COMMENT "data type - defined in code",		`Type` INT NOT NULL COMMENT "data type - defined in code",
	`Val` VARCHAR(255) NOT NULL COMMENT "Value of data item",		`Val` VARCHAR(255) NOT NULL COMMENT "Value of data item",

Woozle: removed "ID"

2009-08-02T16:12:33Z

removed "ID"

← Older revision		Revision as of 16:12, 2 August 2009
Line 3:		Line 3:
	* '''History''':		* '''History''':
	** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type		** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type
			** '''2009-08-02''' removed "ID" field; now using ID_Cart+Type as primary key
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_data`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_data`;
	CREATE TABLE `shop_cart_data` (		CREATE TABLE `shop_cart_data` (
	~~`ID` INT NOT NULL AUTO_INCREMENT,~~
	`ID_Cart` INT NOT NULL COMMENT "shop_carts.ID",		`ID_Cart` INT NOT NULL COMMENT "shop_carts.ID",
	`Type` INT NOT NULL COMMENT "data type - defined in code",		`Type` INT NOT NULL COMMENT "data type - defined in code",
	`Val` VARCHAR(255) NOT NULL COMMENT "Value of data item",		`Val` VARCHAR(255) NOT NULL COMMENT "Value of data item",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID_Cart`,`Type`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: 7/24 changes (updated SQL to match new name; changed field name & comment)

2009-07-24T12:32:55Z

7/24 changes (updated SQL to match new name; changed field name & comment)

← Older revision		Revision as of 12:32, 24 July 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.		* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.
			* '''History''':
			** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `~~shop_cust_data~~`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_data`;
	CREATE TABLE `~~shop_cust_data~~` (		CREATE TABLE `shop_cart_data` (
	`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_carts.ID",
	`~~ID_Key~~` INT NOT NULL COMMENT "~~shop_cust_data_types.ID of~~ data type",		`Type` INT NOT NULL COMMENT "data type - defined in code",
	`Val` VARCHAR(255) NOT NULL COMMENT "Value of data item",		`Val` VARCHAR(255) NOT NULL COMMENT "Value of data item",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: VbzCart/tables/shop cust data moved to VbzCart/tables/shop cart data: this is essentially an auxiliary table for shop_cart

2009-07-24T12:30:17Z

VbzCart/tables/shop cust data moved to VbzCart/tables/shop cart data: this is essentially an auxiliary table for shop_cart

← Older revision	Revision as of 12:30, 24 July 2009
(No difference)

Woozle: New page: ==About== * '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order. ==SQL==
DROP TAB...

2009-03-08T19:07:48Z

New page: ==About== * '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order. ==SQL== <section begin=sql /><mysql>DROP TAB...

New page

==About==
* '''Purpose''': This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cust_data`;
CREATE TABLE `shop_cust_data` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Cart` INT NOT NULL COMMENT "shop_carts.ID",
`ID_Key` INT NOT NULL COMMENT "shop_cust_data_types.ID of data type",
`Val` VARCHAR(255) NOT NULL COMMENT "Value of data item",
PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>
<section end=sql />