Difference between revisions of "VbzCart/tables/shop cart event"
Jump to navigation
Jump to search
(New page: ==About== * '''Purpose''': Keeps a log of everything that happens to each shopping cart * '''History''': ** '''2009-07-18''' Created * '''Fields''': ** '''WhatCode''': This might later be ...) |
(made obsolete; SMW) |
||
Line 1: | Line 1: | ||
+ | <hide> | ||
+ | [[thing type::table design]] | ||
+ | [[project::VbzCart]] | ||
+ | [[subsystem::shopping]] | ||
+ | [[status::obsolete]] | ||
+ | </hide> | ||
==About== | ==About== | ||
* '''Purpose''': Keeps a log of everything that happens to each shopping cart | * '''Purpose''': Keeps a log of everything that happens to each shopping cart | ||
* '''History''': | * '''History''': | ||
** '''2009-07-18''' Created | ** '''2009-07-18''' Created | ||
+ | ** '''2014-07-08''' Suddenly realized that this is redundant; it's just a system event with ModType of cart and ID_Cart -> ModIndex | ||
* '''Fields''': | * '''Fields''': | ||
** '''WhatCode''': This might later be replaced by a shop_cart_event_type ID, but it should be sufficient for now | ** '''WhatCode''': This might later be replaced by a shop_cart_event_type ID, but it should be sufficient for now | ||
==SQL== | ==SQL== | ||
− | + | <mysql>DROP TABLE IF EXISTS `shop_cart_event`; | |
CREATE TABLE `shop_cart_event` ( | CREATE TABLE `shop_cart_event` ( | ||
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
Line 19: | Line 26: | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE = MYISAM;</mysql> | ) ENGINE = MYISAM;</mysql> | ||
− |
Revision as of 01:16, 9 July 2014
About
- Purpose: Keeps a log of everything that happens to each shopping cart
- History:
- 2009-07-18 Created
- 2014-07-08 Suddenly realized that this is redundant; it's just a system event with ModType of cart and ID_Cart -> ModIndex
- Fields:
- WhatCode: This might later be replaced by a shop_cart_event_type ID, but it should be sufficient for now
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>