VbzCart/docs/tables/shop cart event: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(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 ...)
 
imported>Woozle
(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==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `shop_cart_event`;
<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>
<section end=sql />

Revision as of 01:16, 9 July 2014

<hide> thing type::table design [[project::VbzCart]] subsystem::shopping status::obsolete </hide>

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>
Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/shop_cart_event&oldid=6125"