VbzCart/tables/shop log

From HTYP, the free directory anyone can edit

[edit] About

• Status: design is under construction
• Purpose: logs customer movement through the store, for analysis of usage patterns and looking for problems

[edit] SQL

DROP TABLE IF EXISTS `shop_log`;
CREATE TABLE `shop_log` (
  `ID`         INT      NOT NULL AUTO_INCREMENT,
  `ID_Client`  INT      NOT NULL COMMENT "shop_clients.ID",
  `EvWhen`     DATETIME NOT NULL COMMENT "When this event occurred",
  `Code`       INT      NOT NULL COMMENT "type of event",
  `Descr`      VARCHAR(255) DEFAULT NULL COMMENT "Any details specific to this occurrence",
  `Notes`      VARCHAR(255) DEFAULT NULL COMMENT "Human-entered notes",
  PRIMARY KEY(`ID`)
 ) ENGINE = MYISAM;