VbzCart/tables/ord pull

About

• Purpose: Log of order pulls/releases
• Notes: this should probably be expanded into an order-related event log
• Relates to: core_orders, ord_pull_type
• Fields:
  • WhenFreed (was WhenReleased): when the pull was cancelled/revoked; NOT NULL means this pull is inactive
  • Notes may include quite lengthy explanations of what happened (similar to ord_msg)
• History:
  • 2009-07-09 Adapted from MS Access
  • 2009-07-10 Expanded "Notes" from VARCHAR(255) to MEDIUMTEXT
  • 2009-10-27 Added user/machine fields

SQL

<mysql>CREATE TABLE `ord_pull` (

 `ID`         INT            NOT NULL AUTO_INCREMENT,
 `ID_Ord`     INT            NOT NULL COMMENT "core_orders.ID",
 `ID_Type`    INT            NOT NULL COMMENT "ord_pull_type.ID",
 `WhenPulled` DATETIME       NOT NULL COMMENT "when this pull occurred",
 `WhenFreed`  DATETIME   DEFAULT NULL COMMENT "when this pull was dropped",

/* fields relating to who pulled the order */

 `VbzUser`    VARCHAR(127)            COMMENT "VbzCart username, if available",
 `SysUser`    VARCHAR(127)            COMMENT "operating system username, if available",
 `Machine`    VARCHAR(63)    NOT NULL COMMENT "network name or IP address of client",
 `Notes`      MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>