VbzCart/docs/tables/ord event: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (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)) |
imported>Woozle m (separate table for internally-generated events) |
||
| Line 1: | Line 1: | ||
==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 /> | |||
Revision as of 18:55, 18 October 2009
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 />