VbzCart/tables/ord event

About

 * Purpose: for tracking internally-generated events which (generally) do not affect the order's status
 * Status: obsolete, no longer available
 * History:
 * 2009-10-18 Created
 * 2010-09-24 Merged into and renamed so it can't be used; to be deleted
 * Fields:
 * VbzUser is the user's wiki username, and only applies to events initiated through the wiki user interface

SQL
CREATE TABLE `ord_event` ( `ID`             INT         NOT NULL AUTO_INCREMENT,  `ID_Ord`         INT         NOT NULL COMMENT "core_orders.ID",  `WhenDone`  DATETIME         NOT NULL 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",  `SysUser`   VARCHAR(127)              COMMENT "who logged into the operating system, if available",  `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",  `Notes`     VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes, if needed",  PRIMARY KEY(`ID`) ) ENGINE = MYISAM;

Merging Into event_log
Fields to copy when merging this table into :
 * event_log &larr; ord_event
 * WhenFinished &larr; WhenDone
 * ModType &larr; "ord"
 * ModIndex &larr; ID_Ord
 * EvWhere &larr; WhatCode (this is a bit of a kluge)
 * Descr &larr; Descr
 * WhoAdmin &larr; VbzUser
 * WhoSystem &larr; SysUser
 * WhoNetwork &larr; Machine
 * Notes &larr; Notes

SQL
INSERT INTO `event_log` ( WhenFinished,  ModType,  ModIndex,  EvWhere,  Descr,  WhoAdmin,  WhoSystem,  WhoNetwork,  Notes) SELECT WhenDone, "ord", ID_Ord, WhatCode, Descr, VbzUser, SysUser, Machine, Notes FROM `ord_event`;