Difference between revisions of "VbzCart/tables/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, search
(Created page with "==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''': parent: {{l...")
 
(No difference)

Latest revision as of 15:03, 25 July 2019

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: parent: shop_cart
  • History:
    • 2019-07-25 creating from scratch, but very similar to the (obsolete) shop_cart_data table

SQL

DROP TABLE IF EXISTS `cart_data`;
CREATE TABLE `cart_data` (
  `ID_Cart`    INT NOT NULL COMMENT "shop_cart.ID",
  `name`       VARCHAR(63)  NOT NULL COMMENT "field name - defined in code",
  `value`      VARCHAR(255) NOT NULL COMMENT "Value of data item",
  PRIMARY KEY(`ID_Cart`,`name`)
 ) ENGINE = InnoDB;