User:Woozle/StockFerret/units

About

 * Purpose: units in stock
 * Adapted from: VbzCart/tables/stk items

SQL
CREATE TABLE `items` ( `ID`          INT          NOT NULL AUTO_INCREMENT,  `ID_Place`    INT      DEFAULT NULL COMMENT 'places.ID: which bin these items are in',  `ID_Item`     INT      DEFAULT NULL COMMENT 'items.ID: which exact type of item',  `Qty`         INT      DEFAULT NULL,  `WhenAdded`   DATETIME DEFAULT NULL COMMENT 'when stock record was created for this item',  `WhenChanged` DATETIME DEFAULT NULL COMMENT "when the quantity for this record was last altered (e.g. stock rmvd, or a split)",  `WhenCounted` DATETIME DEFAULT NULL COMMENT "when this stock record was last verified by hand-count",  `CatNum`   VARCHAR(63) DEFAULT NULL COMMENT "catalog number on tag (official cat# can change over time)",   `Notes`      TEXT,   PRIMARY KEY(`ID`) ) ENGINE = MYISAM;