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
< VbzCart | tables
Revision as of 12:32, 24 July 2009 by Woozle (talk | contribs) (7/24 changes (updated SQL to match new name; changed field name & comment))

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

<section begin=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>

<section end=sql />

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