Difference between revisions of "VbzCart/tables/shop cart data"
Jump to navigation
Jump to search
m (VbzCart/tables/shop cust data moved to VbzCart/tables/shop cart data: this is essentially an auxiliary table for shop_cart) |
(7/24 changes (updated SQL to match new name; changed field name & comment)) |
||
| 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 ` | + | <section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_data`; |
| − | CREATE TABLE ` | + | 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", | ||
| − | ` | + | `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 /> | ||
Revision as of 12:32, 24 July 2009
About
- 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
<mysql>DROP TABLE IF EXISTS `shop_cart_data`; CREATE TABLE `shop_cart_data` (
`ID` INT NOT NULL AUTO_INCREMENT, `ID_Cart` INT NOT NULL COMMENT "shop_carts.ID", `Type` INT NOT NULL COMMENT "data type - defined in code", `Val` VARCHAR(255) NOT NULL COMMENT "Value of data item", PRIMARY KEY(`ID`) ) ENGINE = MYISAM;</mysql>