User:Woozle/StockFerret/places hist
< User:Woozle | StockFerret
Jump to navigation
Jump to search
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>