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