VbzCart/docs/tables/ord pull: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(added user/machine fields)
m (Woozle moved page VbzCart/VbzCart/tables/ord pull to VbzCart/docs/tables/ord pull without leaving a redirect: part 4/5)
 
(8 intermediate revisions by one other user not shown)
Line 1: Line 1:
-==About==-
{{hdr/status/obsolete|The {{l/vbzcart/table|ord_pull}} table is being replaced by {{l/vbzcart/table|event_vc_ord_change}}. See {{l/sub|migration}} for details.}}
==About==
* '''Purpose''': Log of order pulls/releases
* '''Purpose''': Log of order pulls/releases
* '''Notes''': this should probably be expanded into an order-related event log
* '''Notes''': this will eventually be replaced by {{vbzcart|table|ord_change}}
* '''Relates to''': {{vbzcart|table|core_orders}}, {{vbzcart|table|ord_pull_type}}
* '''Relates to''': {{vbzcart|table|core_orders}}, {{vbzcart|table|ord_pull_type}}
* '''Fields''':
* '''Fields''':
** '''WhenFreed''' (was '''WhenReleased'''): when the pull was cancelled/revoked; NOT NULL means this pull is inactive
** '''WhenFreed''' (was '''WhenReleased'''): when the pull was cancelled/revoked; if it is set, this pull is inactive
** '''Notes''' may include quite lengthy explanations of what happened (similar to {{vbzcart|table|ord_msg}})
** '''Notes*''' may include quite lengthy explanations of what happened (similar to {{vbzcart|table|ord_msg}})
* '''History''':
* '''History''':
** '''2009-07-09''' Adapted from MS Access
** '''2009-07-09''' Adapted from MS Access
** '''2009-07-10''' Expanded "Notes" from VARCHAR(255) to MEDIUMTEXT
** '''2009-07-10''' Expanded "Notes" from VARCHAR(255) to MEDIUMTEXT
** '''2009-10-27''' Added user/machine fields
** '''2009-10-27''' Added user/machine fields; Notes -> NotesPull, added NotesFree
*** This should ease the transition to using the {{vbzcart|table|ord_change}} table
** '''2017-06-02''' Migrating to {{l/vbzcart/table|event_vc_ord_hold}}; documenting {{l/sub|migration}} process.
==SQL==
==SQL==
<section begin=sql /><mysql>CREATE TABLE `ord_pull` (
<source lang=mysql>CREATE TABLE `ord_pull` (
   `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",
Line 21: Line 24:
   `SysUser`    VARCHAR(127)            COMMENT "operating system 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",
   `Machine`    VARCHAR(63)    NOT NULL COMMENT "network name or IP address of client",
   `Notes`     MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes",
   `NotesPull` MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes about the pull",
  `NotesFree`  MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes about the release",
   PRIMARY KEY(`ID`)
   PRIMARY KEY(`ID`)
)
)
ENGINE = MYISAM;</mysql>
ENGINE = MYISAM;</source>
<section end=sql />

Latest revision as of 01:57, 25 February 2024

This documentation is obsolete, and is being kept solely for archival purposes.
The Template:L/vbzcart/table table is being replaced by Template:L/vbzcart/table. See migration for details.

About

  • Purpose: Log of order pulls/releases
  • Notes: this will eventually be replaced by Template:Vbzcart
  • Relates to: Template:Vbzcart, Template:Vbzcart
  • Fields:
    • WhenFreed (was WhenReleased): when the pull was cancelled/revoked; if it is set, this pull is inactive
    • Notes* may include quite lengthy explanations of what happened (similar to Template:Vbzcart)
  • 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; Notes -> NotesPull, added NotesFree
    • 2017-06-02 Migrating to Template:L/vbzcart/table; documenting migration process.

SQL

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",
  `NotesPull`  MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes about the pull",
  `NotesFree`  MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes about the release",
  PRIMARY KEY(`ID`)
)
ENGINE = MYISAM;
Retrieved from "https://wooz.dev/mw/index.php?title=VbzCart/docs/tables/ord_pull&oldid=6929"