VbzCart/tables/ord event - Revision history

Woozle: tagging as obsolete; minor tidying

2017-06-01T10:29:23Z

tagging as obsolete; minor tidying

← Older revision		Revision as of 10:29, 1 June 2017
Line 1:		Line 1:
			{{hdr/status/obsolete}}
	==About==		==About==
	* '''Purpose''': for tracking internally-generated events which (generally) do not affect the order's status		* '''Purpose''': for tracking internally-generated events which (generally) do not affect the order's status
Line 8:		Line 9:
	** '''VbzUser''' is the user's wiki username, and only applies to events initiated through the wiki user interface		** '''VbzUser''' is the user's wiki username, and only applies to events initiated through the wiki user interface
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE TABLE `ord_event` (		<mysql>CREATE TABLE `ord_event` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Ord` INT NOT NULL COMMENT "core_orders.ID",		`ID_Ord` INT NOT NULL COMMENT "core_orders.ID",
Line 21:		Line 22:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~
	==Merging Into event_log==		==Merging Into event_log==
	Fields to copy when merging this table into {{vbzcart\|table\|event_log}}:		Fields to copy when merging this table into {{vbzcart\|table\|event_log}}:

2010-09-24T20:07:43Z

merging/renaming has been done; table officially obsolete

← Older revision		Revision as of 20:07, 24 September 2010
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': for tracking internally-generated events which (generally) do not affect the order's status		* '''Purpose''': for tracking internally-generated events which (generally) do not affect the order's status
			* '''Status''': obsolete, no longer available
	* '''History''':		* '''History''':
	** '''2009-10-18''' Created		** '''2009-10-18''' Created
	** '''2010-09-24''' ~~Working on merging this~~ into {{vbzcart\|table\|event_log}} and ~~then getting rid of~~ it		** '''2010-09-24''' Merged into {{vbzcart\|table\|event_log}} and renamed so it can't be used; to be deleted
	* '''Fields''':		* '''Fields''':
	** '''VbzUser''' is the user's wiki username, and only applies to events initiated through the wiki user interface		** '''VbzUser''' is the user's wiki username, and only applies to events initiated through the wiki user interface

2010-09-24T18:46:30Z

working on merging this into event_log

@@ Line 3: / Line 3: @@
 * '''History''':
 ** '''2009-10-18''' Created
 * '''Fields''':
 ** '''VbzUser''' is the user's wiki username, and only applies to events initiated through the wiki user interface
@@ Line 20: / Line 21: @@
 ENGINE = MYISAM;</mysql>
 <section end=sql />

2009-10-18T19:05:16Z

SQL: WhenDone and Machine should always be filled in

← Older revision		Revision as of 19:05, 18 October 2009
Line 9:		Line 9:
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Ord` INT NOT NULL COMMENT "core_orders.ID",		`ID_Ord` INT NOT NULL COMMENT "core_orders.ID",
	`WhenDone` DATETIME COMMENT "when the event happened",		`WhenDone` DATETIME NOT NULL COMMENT "when the event happened",
	`WhatCode` VARCHAR(7) NOT NULL COMMENT "informal event type code",		`WhatCode` VARCHAR(7) NOT NULL COMMENT "informal event type code",
	`VbzUser` VARCHAR(127) COMMENT "VbzCart username of whoever initiated the event, if available",		`VbzUser` VARCHAR(127) COMMENT "VbzCart username of whoever initiated the event, if available",
	`SysUser` VARCHAR(127) COMMENT "who logged into the operating system, if available",		`SysUser` VARCHAR(127) COMMENT "who logged into the operating system, if available",
	`Machine` VARCHAR(63) COMMENT "network name or IP address of client",		`Machine` VARCHAR(63) NOT NULL COMMENT "network name or IP address of client",
	`Descr` VARCHAR(255) DEFAULT NULL COMMENT "human-readable description of what happened",		`Descr` VARCHAR(255) DEFAULT NULL COMMENT "human-readable description of what happened",
	`Notes` VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes, if needed",		`Notes` VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes, if needed",

2009-10-18T19:03:14Z

+WhatCode

← Older revision		Revision as of 19:03, 18 October 2009
Line 10:		Line 10:
	`ID_Ord` INT NOT NULL COMMENT "core_orders.ID",		`ID_Ord` INT NOT NULL COMMENT "core_orders.ID",
	`WhenDone` DATETIME COMMENT "when the event happened",		`WhenDone` DATETIME COMMENT "when the event happened",
			`WhatCode` VARCHAR(7) NOT NULL COMMENT "informal event type code",
	`VbzUser` VARCHAR(127) COMMENT "VbzCart username of whoever initiated the event, if available",		`VbzUser` VARCHAR(127) COMMENT "VbzCart username of whoever initiated the event, if available",
	`SysUser` VARCHAR(127) COMMENT "who logged into the operating system, if available",		`SysUser` VARCHAR(127) COMMENT "who logged into the operating system, if available",

2009-10-18T18:55:14Z

separate table for internally-generated events

← Older revision		Revision as of 18:55, 18 October 2009
Line 1:		Line 1:
	~~#REDIRECT [[~~VbzCart/~~tables~~/~~ord change]]~~		==About==
			* '''Purpose''': for tracking internally-generated events which (generally) do not affect the order's status
			* '''History''':
			** '''2009-10-18''' Created
			* '''Fields''':
			** '''VbzUser''' is the user's wiki username, and only applies to events initiated through the wiki user interface
			==SQL==
			<section begin=sql /><mysql>CREATE TABLE `ord_event` (
			`ID` INT NOT NULL AUTO_INCREMENT,
			`ID_Ord` INT NOT NULL COMMENT "core_orders.ID",
			`WhenDone` DATETIME COMMENT "when the event happened",
			`VbzUser` VARCHAR(127) COMMENT "VbzCart username of whoever initiated the event, if available",
			`SysUser` VARCHAR(127) COMMENT "who logged into the operating system, if available",
			`Machine` VARCHAR(63) COMMENT "network name or IP address of client",
			`Descr` VARCHAR(255) DEFAULT NULL COMMENT "human-readable description of what happened",
			`Notes` VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes, if needed",
			PRIMARY KEY(`ID`)
			)
			ENGINE = MYISAM;</mysql>
			<section end=sql />

2009-10-18T17:40:09Z

moved VbzCart/tables/ord event to VbzCart/tables/ord change: designing separate tables for internal/stateless and administrative/state-changing events (this is more the latter)

New page

#REDIRECT [[VbzCart/tables/ord change]]