Woozle: Created page with "==About== * '''Purpose''': for tracking movements of places * '''Adapted from''': VbzCart/tables/stk bin history ==SQL== CREATE TABLE `places_hist` ( `ID` ..."

2013-03-09T03:04:20Z

Created page with "==About== * '''Purpose''': for tracking movements of places * '''Adapted from''': VbzCart/tables/stk bin history ==SQL== <mysql> CREATE TABLE `places_hist` ( `ID` ..."

New page

==About==
* '''Purpose''': for tracking movements of places
* '''Adapted from''': [[VbzCart/tables/stk bin history]]
==SQL==
<mysql>
CREATE TABLE `places_hist` (
`ID` INT NOT NULL AUTO_INCREMENT,
`ID_Place` INT NOT NULL COMMENT "places.ID of place being moved",
`WhenDone` DATETIME NOT NULL COMMENT "when the move happened",
`WhoAdmin` VARCHAR(127) NOT NULL COMMENT "software or OS username",
`WhoNetwork` VARCHAR(64) NOT NULL COMMENT "network name or IP address of client machine",
`ID_Srce` INT NOT NULL COMMENT "places.ID of where it came from (old parent ID; NULL = new bin)",
`ID_Dest` INT NOT NULL COMMENT "places.ID of where it was moved to (new parent ID; 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`)
) ENGINE = MYISAM;
</mysql>

User:Woozle/StockFerret/places hist - Revision history

Woozle: Created page with "==About== * '''Purpose''': for tracking movements of places * '''Adapted from''': VbzCart/tables/stk bin history ==SQL== CREATE TABLE `places_hist` ( `ID` ..."