Difference between revisions of "VbzCart/tables/ord event"

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
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                 COMMENT "when the event happened",
+
   `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)               COMMENT "network name or IP address of client",
+
   `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>