VbzCart/tables/shop log - Revision history

Woozle: New page: ==About== * '''Status''': design is under construction * '''Purpose''': logs customer movement through the store, for analysis of usage patterns and looking for problems ==SQL==

2009-03-08T19:12:41Z

New page: ==About== * '''Status''': design is under construction * '''Purpose''': logs customer movement through the store, for analysis of usage patterns and looking for problems ==SQL== <section b...

New page
==About==
* '''Status''': design is under construction
* '''Purpose''': logs customer movement through the store, for analysis of usage patterns and looking for problems
==SQL==
<section begin=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>
<section end=sql />