VbzCart/tables/shop log

About

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

SQL

<mysql>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;</mysql>