Difference between revisions of "VbzCart/tables/ord event"
Jump to navigation
Jump to search
(+WhatCode) |
(→SQL: WhenDone and Machine should always be filled in) |
||
| Line 9: | Line 9: | ||
`ID` INT NOT NULL AUTO_INCREMENT, | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`ID_Ord` INT NOT NULL COMMENT "core_orders.ID", | `ID_Ord` INT NOT NULL COMMENT "core_orders.ID", | ||
| − | `WhenDone` DATETIME | + | `WhenDone` DATETIME NOT NULL COMMENT "when the event happened", |
`WhatCode` VARCHAR(7) NOT NULL COMMENT "informal event type code", | `WhatCode` VARCHAR(7) NOT NULL COMMENT "informal event type code", | ||
`VbzUser` VARCHAR(127) COMMENT "VbzCart username of whoever initiated the event, if available", | `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", | `SysUser` VARCHAR(127) COMMENT "who logged into the operating system, if available", | ||
| − | `Machine` VARCHAR(63) | + | `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", | `Descr` VARCHAR(255) DEFAULT NULL COMMENT "human-readable description of what happened", | ||
`Notes` VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes, if needed", | `Notes` VARCHAR(255) DEFAULT NULL COMMENT "human-entered notes, if needed", | ||
Revision as of 19:05, 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 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>