9hU7GmJf

1CREATE TABLE IF NOT EXISTS `email_authorization` (
2  `id` int(11) NOT NULL AUTO_INCREMENT,
3  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
4  `object_type` enum('OK','VK') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'VK',
5  `object_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
6  `access_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
7  `auth_token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
8  `status` enum('ACCEPTED','WAITING') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'WAITING',
9  `expired_at` datetime DEFAULT NULL,
10  `created_at` datetime NOT NULL,
11  `updated_at` datetime NOT NULL,
12  PRIMARY KEY (`id`)
13) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
14
15CREATE TABLE IF NOT EXISTS `click_product` (
16  `product_shop_id` int(11) NOT NULL,
17  `clicks` int(11) NOT NULL DEFAULT '0',
18  PRIMARY KEY (`product_shop_id`)
19) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
20
21ALTER TABLE `click_product`
22  ADD CONSTRAINT `FK_9C4AE3959CCFDF6D` FOREIGN KEY (`product_shop_id`) REFERENCES `product_shop` (`id`) ON DELETE CASCADE;
23
24DROP TABLE IF EXISTS `emoji`;
25DROP TABLE IF EXISTS `mailing_receives`;
26DROP TABLE IF EXISTS `mailing_recommendation`;
27DROP TABLE IF EXISTS `mailing_recommendation_offers`;
28DROP TABLE IF EXISTS `mobile_device2`;
29DROP TABLE IF EXISTS `mobile_location_bck`;
30DROP TABLE IF EXISTS `offer_july`;
31DROP TABLE IF EXISTS `paper_mapping_item`;
32DROP TABLE IF EXISTS `sale_reports_backup`;
33DROP TABLE IF EXISTS `seodata_bck`;
34DROP TABLE IF EXISTS `shops_data`;
35DROP TABLE IF EXISTS `slide_old`;
36DROP TABLE IF EXISTS `special_page`;
37DROP TABLE IF EXISTS `special_page_flag`;
38DROP TABLE IF EXISTS `special_page_slide`;
39DROP TABLE IF EXISTS `special_page_widget`;
40DROP TABLE IF EXISTS `special_pages_widgets`;
41DROP TABLE IF EXISTS `user_recommendation_info`;
42DROP TABLE IF EXISTS `wl_route`;
43DROP TABLE IF EXISTS `offer_bck`;
44DROP TABLE IF EXISTS `shop_flag_bkp`;
45DROP TABLE IF EXISTS `user2`;
46DROP TABLE IF EXISTS `user_recommendation_info_offers`;
47DROP TABLE IF EXISTS `sale_reports_kupong`;
48DROP TABLE IF EXISTS `IMPORT-SEO`;
49DROP TABLE IF EXISTS `sale_reports_kk`;
50DROP TABLE IF EXISTS `sale_reports_updates`;
51DROP TABLE IF EXISTS `seodata_hreflangs`;
52DROP TABLE IF EXISTS `offer_feed`;
53DROP TABLE IF EXISTS `pointback_reward`;
54DROP TABLE IF EXISTS `sale_reports_old`;
55DROP TABLE IF EXISTS `search_offer`;
56DROP TABLE IF EXISTS `search_shop`;
57DROP TABLE IF EXISTS `search_tag`;
58DROP TABLE IF EXISTS `shop_bck`;
59DROP TABLE IF EXISTS `top`;
60DROP TABLE IF EXISTS `sale_reports_back`;
61DROP TABLE IF EXISTS `mobile_user_last_action2`;
62DROP TABLE IF EXISTS `shop_bkp`;
63DROP TABLE IF EXISTS `seodata_fuckup`;
64DROP TABLE IF EXISTS `OFFER_IMPORT`;
65DROP TABLE IF EXISTS `category_bck`;
66DROP TABLE IF EXISTS `coupons`;
67DROP TABLE IF EXISTS `shops`;
68DROP TABLE IF EXISTS `one_time_offer_bck`;
69DROP TABLE IF EXISTS `seodata_bck2`;
70DROP TABLE IF EXISTS `zalando_offer`;