VbzCart/docs/tables/ord pull: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle m (removed unintended characters) |
imported>Woozle (Notes -> NotesPull/NotesFree) |
||
| Line 1: | Line 1: | ||
==About== | ==About== | ||
* '''Purpose''': Log of order pulls/releases | * '''Purpose''': Log of order pulls/releases | ||
* '''Notes''': this | * '''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; | ** '''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 | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE `ord_pull` ( | <section begin=sql /><mysql>CREATE TABLE `ord_pull` ( | ||
| Line 21: | Line 22: | ||
`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", | ||
` | `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;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 22:32, 27 October 2009
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
- This should ease the transition to using the Template:Vbzcart table
SQL
<section begin=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", `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;</mysql> <section end=sql />