User:Woozle/StockFerret/items

About

 * Purpose: master catalog of all items known to the system
 * Adapted from: VbzCart/tables/cat items
 * Fields:
 * CatNum: a user-relevant unique ID, such as a catalog or SKU number.
 * SuppNum: supplier's preferred unique ID, where applicable

SQL
CREATE TABLE `items` (  `ID`                     INT NOT NULL AUTO_INCREMENT,   `CatNum`    VARCHAR(64)  DEFAULT NULL COMMENT "catalog number: must be unique or null; can be changed",   `Descr`     VARCHAR(127) DEFAULT NULL COMMENT "item-specific description",   `SuppNum`   VARCHAR(32)  DEFAULT NULL COMMENT "supplier's catalog number, if available",   PRIMARY KEY(`ID`) ) ENGINE = MYISAM;