VbzCart/docs/tables/ord pull: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (New page: ==About== * '''Purpose''': Log of order pulls/releases * '''Notes''': this should probably be expanded into an order-related event log * '''Relates to''': {{vbzcart|table|core_orders}}, {{...) |
imported>Woozle (expanded "Notes" field) |
||
| Line 5: | Line 5: | ||
* '''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; NOT NULL means this pull is inactive | ||
** '''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 | |||
==SQL== | ==SQL== | ||
<section begin=sql /><mysql>CREATE TABLE `ord_pull` ( | <section begin=sql /><mysql>CREATE TABLE `ord_pull` ( | ||
`ID` INT | `ID` INT NOT NULL AUTO_INCREMENT, | ||
`ID_Ord` INT | `ID_Ord` INT NOT NULL COMMENT "core_orders.ID", | ||
`ID_Type` INT | `ID_Type` INT NOT NULL COMMENT "ord_pull_type.ID", | ||
`WhenPulled` DATETIME | `WhenPulled` DATETIME NOT NULL COMMENT "when this pull occurred", | ||
`WhenFreed` DATETIME | `WhenFreed` DATETIME DEFAULT NULL COMMENT "when this pull was dropped", | ||
`Notes` | `Notes` MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes", | ||
PRIMARY KEY(`ID`) | PRIMARY KEY(`ID`) | ||
) | ) | ||
ENGINE = MYISAM;</mysql> | ENGINE = MYISAM;</mysql> | ||
<section end=sql /> | <section end=sql /> | ||
Revision as of 11:41, 10 July 2009
About
- Purpose: Log of order pulls/releases
- Notes: this should probably be expanded into an order-related event log
- Relates to: Template:Vbzcart, Template:Vbzcart
- 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 Template:Vbzcart)
- History:
- 2009-07-09 Adapted from MS Access
- 2009-07-10 Expanded "Notes" from VARCHAR(255) to MEDIUMTEXT
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", `Notes` MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes", PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql> <section end=sql />