hULTjhDy

1DROP TABLE IF EXISTS `products`;
2CREATE TABLE `products` (
3  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
4  `name` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
5  PRIMARY KEY (`id`)
6) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
7
8INSERT INTO `products` VALUES ('1', 'apple');
9INSERT INTO `products` VALUES ('2', 'orange');
10INSERT INTO `products` VALUES ('3', 'banana');
11INSERT INTO `products` VALUES ('4', 'kiwi');
12INSERT INTO `products` VALUES ('5', 'strawberry');
13
14DROP TABLE IF EXISTS `products_shop_previews`;
15CREATE TABLE `products_shop_previews` (
16  `product_id` int(11) DEFAULT NULL,
17  `shop_preview_id` int(11) DEFAULT NULL
18) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
19
20INSERT INTO `products_shop_previews` VALUES ('1', '1');
21INSERT INTO `products_shop_previews` VALUES ('2', '1');
22INSERT INTO `products_shop_previews` VALUES ('3', '2');
23INSERT INTO `products_shop_previews` VALUES ('4', '2');
24INSERT INTO `products_shop_previews` VALUES ('1', '3');
25INSERT INTO `products_shop_previews` VALUES ('2', '3');
26INSERT INTO `products_shop_previews` VALUES ('3', '3');
27
28DROP TABLE IF EXISTS `shop_previews`;
29CREATE TABLE `shop_previews` (
30  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
31  `name` varchar(255) COLLATE utf8_czech_ci DEFAULT NULL,
32  `publish` datetime DEFAULT NULL,
33  PRIMARY KEY (`id`)
34) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
35
36INSERT INTO `shop_previews` VALUES ('1', 'best', '2016-08-30 21:25:51');
37INSERT INTO `shop_previews` VALUES ('2', 'cheap', '2016-08-31 21:26:11');
38INSERT INTO `shop_previews` VALUES ('3', 'news', '2016-09-01 21:26:34');