VbzCart/docs/tables/ord event: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(→‎SQL: WhenDone and Machine should always be filled in)
imported>Woozle
(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''' &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===
<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 Template:Vbzcart 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

<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         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> <section end=sql />

Merging Into event_log

Fields to copy when merging this table into Template:Vbzcart:

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

Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/ord_event&oldid=5917"