VbzCart/docs/tables/shop cart event: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (made obsolete; SMW) |
m (Woozle moved page VbzCart/VbzCart/tables/shop cart event to VbzCart/docs/tables/shop cart event without leaving a redirect: part 4/5) |
||
| (5 intermediate revisions by one other user not shown) | |||
| Line 5: | Line 5: | ||
[[status::obsolete]] | [[status::obsolete]] | ||
</hide> | </hide> | ||
{{hdr/status/obsolete|The {{l/vbzcart/table|shop_cart_event}} table was merged into [[Ferreteria/v2/data/event|Ferreteria's general events system version 2]] and is no longer used.}} | |||
==About== | ==About== | ||
* '''Status''': OBSOLETE, no longer used; merged with system events (apparently in 2014) | |||
* '''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''': | ||
| Line 13: | Line 15: | ||
** '''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`; | <source lang=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 25: | Line 27: | ||
`Notes` VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes, if needed", | `Notes` VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes, if needed", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) ENGINE = | ) ENGINE = MyISAM;</source> | ||
Latest revision as of 01:57, 25 February 2024
<hide> thing type::table design [[project::VbzCart]] subsystem::shopping status::obsolete </hide>
|
This documentation is obsolete, and is being kept solely for archival purposes. |
About
- Status: OBSOLETE, no longer used; merged with system events (apparently in 2014)
- 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
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;