Difference between revisions of "VbzCart/tables/ord event"
Jump to navigation
Jump to search
(→SQL: WhenDone and Machine should always be filled in) |
(working on merging this into event_log) |
||
| Line 3: | Line 3: | ||
* '''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 | ||
* '''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 | ||
| Line 20: | Line 21: | ||
ENGINE = MYISAM;</mysql> | ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
| + | ==Merging Into event_log== | ||
| + | Fields to copy when merging this table into {{vbzcart|table|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> | ||
Revision as of 18:46, 24 September 2010
About
- Purpose: for tracking internally-generated events which (generally) do not affect the order's status
- History:
- 2009-10-18 Created
- 2010-09-24 Working on merging this into event_log and then getting rid of it
- 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>