VbzCart/docs/tables/shop cart data: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
m (VbzCart/tables/shop cust data moved to VbzCart/tables/shop cart data: this is essentially an auxiliary table for shop_cart)
imported>Woozle
(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 `shop_cust_data`;
<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_data`;
CREATE TABLE `shop_cust_data` (
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",
   `ID_Key`     INT NOT NULL COMMENT "shop_cust_data_types.ID of data type",
   `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

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