· 6 years ago · Aug 12, 2019, 01:04 PM
1CREATE TABLE IF NOT EXISTS `zdama_product` (
2 `dataID` int(11) NOT NULL AUTO_INCREMENT,
3 `productID` int(11) NOT NULL,
4 `url` varchar(255) NOT NULL,
5 `size` int(11) NOT NULL,
6 `amount` int(11) NOT NULL,
7 PRIMARY KEY (`dataID`),
8 UNIQUE KEY `productID` (`productID`,`url`,`size`)
9) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;