VbzCart/docs/tables/stk bin history: Difference between revisions

From Woozle Writes Code
< VbzCart‎ | docs‎ | tables
Jump to navigation Jump to search
imported>Woozle
(11/7 changes; started documentation section)
imported>Woozle
m (→‎About: table name correction)
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`;

Revision as of 23:07, 7 November 2009

About

  • Purpose: Documents changes to Template:Vbzcart 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

<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 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`)

) ENGINE = MYISAM;</mysql> <section end=sql />