VbzCart/tables/ord pull - Revision history

Woozle: markup fix

2020-02-26T15:44:25Z

markup fix

← Older revision		Revision as of 15:44, 26 February 2020
Line 14:		Line 14:
	** '''2017-06-02''' Migrating to {{l/vbzcart/table\|event_vc_ord_hold}}; documenting {{l/sub\|migration}} process.		** '''2017-06-02''' Migrating to {{l/vbzcart/table\|event_vc_ord_hold}}; documenting {{l/sub\|migration}} process.
	==SQL==		==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 28:		Line 28:
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	)		)
	ENGINE = MYISAM;</~~mysql~~>		ENGINE = MYISAM;</source>

Woozle: moved migration stuff to subpage

2017-06-03T10:38:12Z

moved migration stuff to subpage

@@ Line 1: / Line 1: @@
-{{hdr/status/obsolete|This table (ord_pull) is being replaced by {{l/vbzcart/table|event_vc_ord_change}}.}}
+{{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
@@ Line 12: / Line 12: @@
 ** '''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 migration process.
+** '''2017-06-02''' Migrating to {{l/vbzcart/table|event_vc_ord_hold}}; documenting {{l/sub|migration}} process.
 ==SQL==
 <mysql>CREATE TABLE `ord_pull` (

Woozle: preliminary migration design

2017-06-02T11:48:18Z

preliminary migration design

@@ Line 12: / Line 12: @@
 ** '''2009-10-27''' Added user/machine fields; Notes -> NotesPull, added NotesFree
 *** This should ease the transition to using the {{vbzcart|table|ord_change}} table
 ==Migration==
-Notes:
+This is complicated by the fact that we will have '''two''' hold-event records for pulls which have been released.
 * VbzUser -> legacy.WhoAdmin
 * SysUser -> legacy.WhoSystem
 * Machine -> legacy.WhoNetwork
-There are 1665 Order Pull events to migrate, and we have a gap in the event table from IDs 1230 to 6354, so let's start the pulls at ID 1500.
+==step 2: released holds only==
 ==SQL==
 <mysql>CREATE TABLE `ord_pull` (

Woozle at 00:56, 2 June 2017

2017-06-02T00:56:17Z

← Older revision		Revision as of 00:56, 2 June 2017
Line 17:		Line 17:
	* SysUser -> legacy.WhoSystem		* SysUser -> legacy.WhoSystem
	* Machine -> legacy.WhoNetwork		* Machine -> legacy.WhoNetwork

			There are 1665 Order Pull events to migrate, and we have a gap in the event table from IDs 1230 to 6354, so let's start the pulls at ID 1500.
	==SQL==		==SQL==
	<mysql>CREATE TABLE `ord_pull` (		<mysql>CREATE TABLE `ord_pull` (

Woozle at 14:28, 1 June 2017

2017-06-01T14:28:28Z

← Older revision		Revision as of 14:28, 1 June 2017
Line 12:		Line 12:
	** '''2009-10-27''' Added user/machine fields; Notes -> NotesPull, added NotesFree		** '''2009-10-27''' Added user/machine fields; Notes -> NotesPull, added NotesFree
	*** This should ease the transition to using the {{vbzcart\|table\|ord_change}} table		*** This should ease the transition to using the {{vbzcart\|table\|ord_change}} table
			==Migration==
			Notes:
			* VbzUser -> legacy.WhoAdmin
			* SysUser -> legacy.WhoSystem
			* Machine -> legacy.WhoNetwork
	==SQL==		==SQL==
	<mysql>CREATE TABLE `ord_pull` (		<mysql>CREATE TABLE `ord_pull` (

Woozle: obsolete now

2017-06-01T12:38:38Z

obsolete now

← Older revision		Revision as of 12:38, 1 June 2017
Line 1:		Line 1:
			{{hdr/status/obsolete\|This table (ord_pull) is being replaced by {{l/vbzcart/table\|event_vc_ord_change}}.}}
	==About==		==About==
	* '''Purpose''': Log of order pulls/releases		* '''Purpose''': Log of order pulls/releases
Line 12:		Line 13:
	*** This should ease the transition to using the {{vbzcart\|table\|ord_change}} table		*** This should ease the transition to using the {{vbzcart\|table\|ord_change}} table
	==SQL==		==SQL==
	~~<section begin=sql />~~<mysql>CREATE TABLE `ord_pull` (		<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 27:		Line 28:
	)		)
	ENGINE = MYISAM;</mysql>		ENGINE = MYISAM;</mysql>
	~~<section end=sql />~~

Woozle: Notes -> NotesPull/NotesFree

2009-10-27T22:32:16Z

Notes -> NotesPull/NotesFree

← Older revision		Revision as of 22:32, 27 October 2009
Line 1:		Line 1:
	==About==		==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
	==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",
	`~~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;</mysql>
	<section end=sql />		<section end=sql />

Woozle: removed unintended characters

2009-10-27T15:28:57Z

removed unintended characters

← Older revision		Revision as of 15:28, 27 October 2009
Line 1:		Line 1:
	-==About==-		==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 should probably be expanded into an order-related event log

Woozle: added user/machine fields

2009-10-27T15:28:35Z

added user/machine fields

← Older revision		Revision as of 15:28, 27 October 2009
Line 1:		Line 1:
	==About==		-==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 should probably be expanded into an order-related event log
Line 9:		Line 9:
	** '''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
	==SQL==		==SQL==
	<section begin=sql /><mysql>CREATE TABLE `ord_pull` (		<section begin=sql /><mysql>CREATE TABLE `ord_pull` (
Line 16:		Line 17:
	`WhenPulled` DATETIME NOT NULL COMMENT "when this pull occurred",		`WhenPulled` DATETIME NOT NULL COMMENT "when this pull occurred",
	`WhenFreed` DATETIME DEFAULT NULL COMMENT "when this pull was dropped",		`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",		`Notes` MEDIUMTEXT DEFAULT NULL COMMENT "human-added notes",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)

Woozle: expanded "Notes" field

2009-07-10T11:41:34Z

expanded "Notes" field

← Older revision		Revision as of 11:41, 10 July 2009
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 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",
	`ID_Type` INT NOT NULL COMMENT "ord_pull_type.ID",		`ID_Type` INT NOT NULL COMMENT "ord_pull_type.ID",
	`WhenPulled` DATETIME NOT NULL COMMENT "when this pull occurred",		`WhenPulled` DATETIME NOT NULL COMMENT "when this pull occurred",
	`WhenFreed` DATETIME DEFAULT NULL COMMENT "when this pull was dropped",		`WhenFreed` DATETIME DEFAULT NULL COMMENT "when this pull was dropped",
	`Notes` ~~VARCHAR(255)~~ DEFAULT NULL COMMENT "human-added 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 />