VbzCart/tables/ord event
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
This documentation is obsolete, and is being kept solely for archival purposes. |
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 event_log 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
<mysql>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;</mysql>
Merging Into event_log
Fields to copy when merging this table into event_log:
- event_log ← ord_event
- WhenFinished ← WhenDone
- ModType ← "ord"
- ModIndex ← ID_Ord
- EvWhere ← WhatCode (this is a bit of a kluge)
- Descr ← Descr
- WhoAdmin ← VbzUser
- WhoSystem ← SysUser
- WhoNetwork ← Machine
- Notes ← Notes
SQL
<mysql>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`;</mysql>