VbzCart/tables/rstk req item minima
Jump to navigation
Jump to search
About
- History:
- 2008-11-25 migrated from MS Access
SQL
<mysql>CREATE TABLE `rstk_req_item_minima` (
`ID_ItemType` INT NOT NULL COMMENT "ittyps.ID of item type with restriction", `ID_Supplier` INT NOT NULL COMMENT "cat_supp.ID of supplier", `QtyMin` INT DEFAULT NULL COMMENT "minimum qty; NULL means 1", `QtyMult` INT DEFAULT NULL COMMENT "qty multiples; NULL means 1",
PRIMARY KEY(`ID_ItemType`,`ID_Supplier`) )
ENGINE = MYISAM;</mysql>