Difference between revisions of "VbzCart/tables/shop cart data"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
Jump to navigation Jump to search
(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

<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>

Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/tables/shop_cart_data&oldid=12034"