VbzCart/tables/stk bin history - Revision history

Woozle: updated syntax highlighting tags

2020-02-03T16:00:47Z

updated syntax highlighting tags

← Older revision		Revision as of 16:00, 3 February 2020
Line 9:		Line 9:

	==SQL==		==SQL==
	<mysql>DROP TABLE IF EXISTS `stk_bin_history`;		<source lang=mysql>DROP TABLE IF EXISTS `stk_bin_history`;
	CREATE TABLE `stk_bin_history` (		CREATE TABLE `stk_bin_history` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
Line 22:		Line 22:
	`Notes` VARCHAR(255) DEFAULT NULL COMMENT "optional explanatory notes",		`Notes` VARCHAR(255) DEFAULT NULL COMMENT "optional explanatory notes",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = MYISAM;</~~mysql~~>		) ENGINE = MYISAM;</source>
	==Migration==		==Migration==
	The following were used to migrate from this table to EventPlex tables:		The following were used to migrate from this table to EventPlex tables:
	<mysql>INSERT INTO event_vc_bin (ID_Event, ID_Bin, ID_Srce, ID_Dest)		<source lang=mysql>INSERT INTO event_vc_bin (ID_Event, ID_Bin, ID_Srce, ID_Dest)
	SELECT ID+30000 AS NewID, ID_Bin, ID_Srce, ID_Dest		SELECT ID+30000 AS NewID, ID_Bin, ID_Srce, ID_Dest
	FROM stk_bin_history;		FROM stk_bin_history;
Line 44:		Line 44:
	INSERT INTO event (ID, WhenStart, TypeCode, Descrip)		INSERT INTO event (ID, WhenStart, TypeCode, Descrip)
	SELECT ID+30000 AS NewID, WhenDone, "legacy.bin", Descr		SELECT ID+30000 AS NewID, WhenDone, "legacy.bin", Descr
	FROM stk_bin_history;</~~mysql~~>		FROM stk_bin_history;</source>
	This is the reverse of the order in which they were executed, but order shouldn't matter. (I think.)		This is the reverse of the order in which they were executed, but order shouldn't matter. (I think.)

Woozle: migration SQL

2017-04-22T21:24:10Z

migration SQL

@@ Line 9: / Line 9: @@
 ==SQL==
-<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bin_history`;
+<mysql>DROP TABLE IF EXISTS `stk_bin_history`;
 CREATE TABLE `stk_bin_history` (
    `ID`                      INT NOT NULL AUTO_INCREMENT,
@@ Line 23: / Line 23: @@
    PRIMARY KEY(`ID`)
 ) ENGINE = MYISAM;</mysql>
-<section end=sql />
+==Migration==

Woozle: this is being replaced

2017-04-18T00:18:34Z

this is being replaced

← Older revision		Revision as of 00:18, 18 April 2017
Line 4:		Line 4:
	** '''2009-11-07''' Added "Descr" field and made ID_Srce/ID_Dest NOT NULL		** '''2009-11-07''' Added "Descr" field and made ID_Srce/ID_Dest NOT NULL
	** '''2009-12-20''' Added fields WhoAdmin, WhoSystem, WhoNetwork		** '''2009-12-20''' Added fields WhoAdmin, WhoSystem, WhoNetwork
			** '''2017-04-17''' Replacing this with {{l/same\|event_vc_bin}}
	* '''Fields''':		* '''Fields''':
	** '''Descr''' is for events other than moving, e.g. field changes or stock recounts		** '''Descr''' is for events other than moving, e.g. field changes or stock recounts

Woozle: added WhoAdmin, WhoSystem, WhoNetwork

2009-12-21T00:40:27Z

added WhoAdmin, WhoSystem, WhoNetwork

← Older revision		Revision as of 00:40, 21 December 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Documents changes to {{vbzcart\|table\|stk_bins}} data		* '''Purpose''': Documents things which happen to a stock bin -- usually changes to {{vbzcart\|table\|stk_bins}} data, but can also log collective movement of items to/from bins
	* '''History''':		* '''History''':
	** '''2009-11-07''' Added "Descr" field and made ID_Srce/ID_Dest NOT NULL		** '''2009-11-07''' Added "Descr" field and made ID_Srce/ID_Dest NOT NULL
			** '''2009-12-20''' Added fields WhoAdmin, WhoSystem, WhoNetwork
	* '''Fields''':		* '''Fields''':
	** '''Descr''' is for events other than moving, e.g. field changes or stock recounts		** '''Descr''' is for events other than moving, e.g. field changes or stock recounts
Line 9:		Line 10:
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bin_history`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bin_history`;
	CREATE TABLE `stk_bin_history` (		CREATE TABLE `stk_bin_history` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Bin` INT NOT NULL COMMENT "stk_bins.ID of bin being moved",		`ID_Bin` INT NOT NULL COMMENT "stk_bins.ID of bin being moved",
	`WhenDone` DATETIME NOT NULL COMMENT "when the move happened",		`WhenDone` DATETIME NOT NULL COMMENT "when the move happened",
	`ID_Srce` INT NOT NULL COMMENT "stk_places.ID of where the bin came from (NULL = new bin)",		`WhoAdmin` VARCHAR(127) NOT NULL COMMENT "VbzCart admin username",
	`ID_Dest` INT NOT NULL COMMENT "stk_places.ID of where the bin was moved to (NULL = bin destroyed)",		`WhoSystem` VARCHAR(127) DEFAULT NULL COMMENT "who logged into the operating system, if using non-web client app",
	`Descr` VARCHAR(255) DEFAULT NULL COMMENT "code-generated description for non-move events",		`WhoNetwork` VARCHAR(64) NOT NULL COMMENT "network name or IP address of client machine",
	`Notes` VARCHAR(255) DEFAULT NULL COMMENT "optional explanatory notes",		`ID_Srce` INT NOT NULL COMMENT "stk_places.ID of where the bin came from (NULL = new bin)",
			`ID_Dest` INT NOT NULL COMMENT "stk_places.ID of where the bin was moved to (NULL = bin destroyed)",
			`Descr` VARCHAR(255) DEFAULT NULL COMMENT "code-generated description for non-move events",
			`Notes` VARCHAR(255) DEFAULT NULL COMMENT "optional explanatory notes",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: /* About */ table name correction

2009-11-07T23:07:57Z

About: table name correction

← Older revision		Revision as of 23:07, 7 November 2009
Line 1:		Line 1:
	==About==		==About==
	* '''Purpose''': Documents changes to {{vbzcart\|table\|~~stk_bin~~}} data		* '''Purpose''': Documents changes to {{vbzcart\|table\|stk_bins}} data
	* '''History''':		* '''History''':
	** '''2009-11-07''' Added "Descr" field and made ID_Srce/ID_Dest NOT NULL		** '''2009-11-07''' Added "Descr" field and made ID_Srce/ID_Dest NOT NULL
	* '''Fields''':		* '''Fields''':
	** '''Descr''' is for events other than moving, e.g. field changes or stock recounts		** '''Descr''' is for events other than moving, e.g. field changes or stock recounts

	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bin_history`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bin_history`;

Woozle: 11/7 changes; started documentation section

2009-11-07T23:07:14Z

11/7 changes; started documentation section

← Older revision		Revision as of 23:07, 7 November 2009
Line 1:		Line 1:
	==About==		==About==
	''to ~~be documented~~''		* '''Purpose''': Documents changes to {{vbzcart\|table\|stk_bin}} data
			* '''History''':
			** '''2009-11-07''' Added "Descr" field and made ID_Srce/ID_Dest NOT NULL
			* '''Fields''':
			** '''Descr''' is for events other than moving, e.g. field changes or stock recounts
	==SQL==		==SQL==
	<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bin_history`;		<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bin_history`;

	CREATE TABLE `stk_bin_history` (		CREATE TABLE `stk_bin_history` (
	`ID` INT NOT NULL AUTO_INCREMENT,		`ID` INT NOT NULL AUTO_INCREMENT,
	`ID_Bin` INT NOT NULL COMMENT "stk_bins.ID of bin being moved",		`ID_Bin` INT NOT NULL COMMENT "stk_bins.ID of bin being moved",
	`WhenDone` DATETIME NOT NULL COMMENT "when the move happened",		`WhenDone` DATETIME NOT NULL COMMENT "when the move happened",
	`ID_Srce` INT COMMENT "stk_places.ID of where the bin came from (NULL = new bin)",		`ID_Srce` INT NOT NULL COMMENT "stk_places.ID of where the bin came from (NULL = new bin)",
	`ID_Dest` INT COMMENT "stk_places.ID of where the bin was moved to (NULL = bin destroyed)",		`ID_Dest` INT NOT NULL COMMENT "stk_places.ID of where the bin was moved to (NULL = bin destroyed)",
	`Notes` ~~varchar~~(255) DEFAULT NULL COMMENT "optional explanatory notes",		`Descr` VARCHAR(255) DEFAULT NULL COMMENT "code-generated description for non-move events",
			`Notes` VARCHAR(255) DEFAULT NULL COMMENT "optional explanatory notes",
	PRIMARY KEY(`ID`)		PRIMARY KEY(`ID`)
	) ENGINE = MYISAM;</mysql>		) ENGINE = MYISAM;</mysql>
	<section end=sql />		<section end=sql />

Woozle: extracted from VbzCart/tables

2008-12-29T17:42:38Z

extracted from VbzCart/tables

New page

==About==
''to be documented''
==SQL==
<section begin=sql /><mysql>DROP TABLE IF EXISTS `stk_bin_history`;

CREATE TABLE `stk_bin_history` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Bin` INT NOT NULL COMMENT "stk_bins.ID of bin being moved",
`WhenDone` DATETIME NOT NULL COMMENT "when the move happened",
`ID_Srce` INT COMMENT "stk_places.ID of where the bin came from (NULL = new bin)",
`ID_Dest` INT COMMENT "stk_places.ID of where the bin was moved to (NULL = bin destroyed)",
`Notes` varchar(255) DEFAULT NULL COMMENT "optional explanatory notes",
PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>
<section end=sql />