VbzCart/tables/shop cart event - Revision history

Woozle: updated link

2020-02-29T15:23:35Z

updated link

← Older revision		Revision as of 15:23, 29 February 2020
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/~~modules~~/~~logs~~\|Ferreteria's general events system]] ~~some time ago~~ and is no longer used.}}		{{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)		* '''Status''': OBSOLETE, no longer used; merged with system events (apparently in 2014)

Woozle: oh, right, I made a banner-template for obsolete pages

2020-02-26T15:43:50Z

oh, right, I made a banner-template for obsolete pages

← Older revision		Revision as of 15:43, 26 February 2020
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/modules/logs\|Ferreteria's general events system]] some time ago and is no longer used.}}
	==About==		==About==
	* '''Status''': OBSOLETE, no longer used; merged with system events (apparently in 2014)		* '''Status''': OBSOLETE, no longer used; merged with system events (apparently in 2014)

Woozle: for archival correctness -- the last version of this table probably did use the MyISAM engine, as originally documented here

2020-02-26T14:49:35Z

for archival correctness -- the last version of this table probably did use the MyISAM engine, as originally documented here

← Older revision		Revision as of 14:49, 26 February 2020
Line 26:		Line 26:
	`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 = ~~InnoDB~~;</source>		) ENGINE = MyISAM;</source>

Woozle at 14:45, 26 February 2020

2020-02-26T14:45:40Z

← Older revision		Revision as of 14:45, 26 February 2020
Line 6:		Line 6:
	</hide>		</hide>
	==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''':

Woozle at 14:31, 26 February 2020

2020-02-26T14:31:20Z

← Older revision		Revision as of 14:31, 26 February 2020
Line 13:		Line 13:
	** '''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 25:
	`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 = ~~MYISAM~~;</~~mysql~~>		) ENGINE = InnoDB;</source>

Woozle: made obsolete; SMW

2014-07-09T01:16:23Z

made obsolete; SMW

← Older revision		Revision as of 01:16, 9 July 2014
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 />~~

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

2009-07-18T15:54:16Z

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

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 replaced by a shop_cart_event_type ID, but it should be sufficient for now
==SQL==
<section begin=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>
<section end=sql />