VbzCart/tables/rstk req item minima

From HTYP, the free directory anyone can edit

[edit] About

• History:
  • 2008-11-25 migrated from MS Access

[edit] SQL

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;