CREATE TABLE `basket` (
 `basketNO` int(11) NOT NULL AUTO_INCREMENT,
 `productID` int(11) NOT NULL,
 PRIMARY KEY (`basketNO`),
 KEY `productID` (`productID`),
 CONSTRAINT `basket_ibfk_1` FOREIGN KEY (`productID`) REFERENCES `product` (`productID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8