CREATE TABLE product_quantities (
 pqid  INT UNSIGNED PRIMARY KEY AUTO_INCREMENT,
 pcode BIGINT UNSIGNED,
 qty   INT UNSIGNED,
 length DECIMAL(3,2),
 width  DECIMAL(3,2),
 height DECIMAL(3,2),
 weight DECIMAL(3,2)
);