VbzCart/tables/shop cart data

From HTYP, the free directory anyone can edit

[edit] 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
  • 2009-08-02 removed "ID" field; now using ID_Cart+Type as primary key

[edit] SQL

DROP TABLE IF EXISTS `shop_cart_data`;
CREATE TABLE `shop_cart_data` (
  `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_Cart`,`Type`)
 ) ENGINE = MYISAM;