Woozle: Created page with "==About== * '''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..."

2019-07-25T15:03:59Z

Created page with "==About== * '''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..."

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.
* '''Relates to''': parent: {{l/same|shop_cart}}
* '''History''':
** '''2019-07-25''' creating from scratch, but very similar to the (obsolete) {{l/same|shop_cart_data}} table
==SQL==
<source lang=mysql>DROP TABLE IF EXISTS `cart_data`;
CREATE TABLE `cart_data` (
`ID_Cart` INT NOT NULL COMMENT "shop_cart.ID",
`name` VARCHAR(63) NOT NULL COMMENT "field name - defined in code",
`value` VARCHAR(255) NOT NULL COMMENT "Value of data item",
PRIMARY KEY(`ID_Cart`,`name`)
) ENGINE = InnoDB;</source>

VbzCart/tables/cart data - Revision history

Woozle: Created page with "==About== * '''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..."