Jump to navigation Jump to search
- 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
- 2019-07-25 creating from scratch, but very similar to the (obsolete) shop_cart_data table
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;