VbzCart/tables/shop cart data: Difference between revisions
from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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... |
m VbzCart/tables/shop cust data moved to VbzCart/tables/shop cart data: this is essentially an auxiliary table for shop_cart |
(No difference)
| |
Revision as of 12:30, 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.
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 />
