VbzCart/docs/tables/shop cart event

About

• Purpose: Keeps a log of everything that happens to each shopping cart
• History:
  • 2009-07-18 Created
• Fields:
  • WhatCode: This might later be replaced by a shop_cart_event_type ID, but it should be sufficient for now

SQL

<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_event`; CREATE TABLE `shop_cart_event` (

 `ID`        INT              NOT NULL AUTO_INCREMENT,
 `ID_Cart`   INT              NOT NULL COMMENT "shop_cart.ID",
 `WhenDone`  DATETIME         NOT NULL COMMENT "when this event occurred",
 `WhatCode`  VARCHAR(7)       NOT NULL COMMENT "event type code",
 `WhatDescr` VARCHAR(255) DEFAULT NULL COMMENT "human-readable description of event (optional)",
 `ID_Sess`   INT              NOT NULL COMMENT "shop_session.ID",
 `VbzUser`   VARCHAR(127) DEFAULT NULL COMMENT "username, if available",
 `Machine`   VARCHAR(63)      NOT NULL COMMENT "some way of identifying the user's machine -- network name or IP address",
 `Notes`     VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes, if needed",
 PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>

<section end=sql />