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
(relationship note; minor correction)
(Type -> ID_Type)
Line 5: Line 5:
 
** '''2009-07-24''' renamed: shop_cust_data -> shop_cart_data; changed ID_Key -> Type
 
** '''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
 
** '''2009-08-02''' removed "ID" field; now using ID_Cart+Type as primary key
 +
** '''2014-11-04''' renamed "Type" field to "ID_Type"
 
==SQL==
 
==SQL==
−
<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_data`;
+
<mysql>DROP TABLE IF EXISTS `shop_cart_data`;
 
CREATE TABLE `shop_cart_data` (
 
CREATE TABLE `shop_cart_data` (
 
   `ID_Cart`    INT NOT NULL COMMENT "shop_cart.ID",
 
   `ID_Cart`    INT NOT NULL COMMENT "shop_cart.ID",
−
   `Type`      INT NOT NULL COMMENT "data type - defined in code",
+
   `ID_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_Cart`,`Type`)
 
   PRIMARY KEY(`ID_Cart`,`Type`)
 
  ) ENGINE = MYISAM;</mysql>
 
  ) ENGINE = MYISAM;</mysql>
−
<section end=sql />
 

Revision as of 13:14, 4 November 2014

About

  • Purpose: This is a simple table for retaining customer data entered at check-out time before converting the cart to an order.
  • Relates to: shop_cart
  • 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
    • 2014-11-04 renamed "Type" field to "ID_Type"

SQL

<mysql>DROP TABLE IF EXISTS `shop_cart_data`; CREATE TABLE `shop_cart_data` ( 

 `ID_Cart`    INT NOT NULL COMMENT "shop_cart.ID",
 `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;</mysql>
Retrieved from "https://htyp.org/mw/index.php?title=VbzCart/tables/shop_cart_data&oldid=20209"