Difference between revisions of "VbzCart/tables/ord event"
Jump to navigation
Jump to search
(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)) |
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
<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>