· 8 years ago · Jun 11, 2018, 08:26 PM
1CREATE TABLE IF NOT EXISTS `parts_products` (
2 `part_id` int(10) unsigned NOT NULL,
3 `retailer_id` varchar(45) NOT NULL,
4 `timestamp` int(11) DEFAULT NULL,
5 `retailer_item_number` varchar(128) DEFAULT NULL,
6 `price` int(11) DEFAULT NULL,
7 `affiliate_link` varchar(512) DEFAULT NULL,
8 `in_stock` tinyint(4) DEFAULT NULL,
9 `exists` int(11) NOT NULL DEFAULT '0',
10 PRIMARY KEY (`part_id`,`retailer_id`),
11 KEY `fk_products_retailers1` (`retailer_id`),
12 KEY `fk_products_parts1` (`part_id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8;