· 8 years ago · Feb 16, 2018, 04:16 PM
1DROP TABLE IF EXISTS `foreign_sites`;
2CREATE TABLE `foreign_sites` (
3 `foreign_sites_id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID внешнего Ñайта',
4 `name` VARCHAR(50) NOT NULL COMMENT 'Ðазвание внешнего Ñайта' DEFAULT '',
5 PRIMARY KEY (`foreign_sites_id`)
6)
7COMMENT='Внешние Ñайты'
8COLLATE='utf8_general_ci'
9ENGINE=InnoDB
10;
11
12INSERT INTO `foreign_sites` (`name`) VALUES ('Wildberries');
13
14
15DROP TABLE IF EXISTS `products_to_foreign_urls`;
16CREATE TABLE `products_to_foreign_urls` (
17 `products_to_foreign_urls_id` INT(10) NOT NULL AUTO_INCREMENT,
18 `products_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'ID корневого товара из products_legacy',
19 `foreign_sites_id` INT(11) NOT NULL COMMENT 'ID внешнего Ñайта',
20 `prices_url` VARCHAR(500) NOT NULL COMMENT 'URL Ñтраницы Ñ Ñ†ÐµÐ½Ð°Ð¼Ð¸' DEFAULT '',
21 INDEX `products_id_foreign_sites_id` (`products_id`, `foreign_sites_id`),
22 PRIMARY KEY (`products_to_foreign_urls_id`)
23)
24 COMMENT='СÑылки на Ñтраницы Ñ Ñ†ÐµÐ½Ð°Ð¼Ð¸ на внешних Ñайтах'
25 COLLATE='utf8_general_ci'
26 ENGINE=InnoDB
27;
28
29DROP TABLE IF EXISTS `products_to_foreign_sites_state`;
30CREATE TABLE `products_to_foreign_sites_state` (
31 `products_to_foreign_sites_state_id` INT(10) NOT NULL AUTO_INCREMENT,
32 `products_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'ID товара',
33 `foreign_sites_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'ID внешнего Ñайта',
34 `is_parsed` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' COMMENT 'ПропарÑили',
35 INDEX `products_id_foreign_sites_id` (`products_id`, `foreign_sites_id`),
36 PRIMARY KEY (`products_to_foreign_sites_state_id`)
37)
38 COMMENT='СоÑтоÑние парÑинга цены на внешних Ñайтах'
39 COLLATE='utf8_general_ci'
40 ENGINE=InnoDB
41;
42
43DROP TABLE IF EXISTS `products_foreign_sites_prices`;
44CREATE TABLE `products_foreign_sites_prices` (
45 `products_foreign_sites_prices_id` INT(10) NOT NULL AUTO_INCREMENT,
46 `products_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'ID товара',
47 `foreign_sites_id` INT(11) NOT NULL DEFAULT '0' COMMENT 'ID внешнего Ñайта',
48 `price` DECIMAL(15,2) NOT NULL DEFAULT '0.00',
49 `promo_price` DECIMAL(15,2) NOT NULL DEFAULT '0.00',
50 INDEX `products_id_foreign_sites_id` (`products_id`, `foreign_sites_id`),
51 PRIMARY KEY (`products_foreign_sites_prices_id`)
52)
53 COMMENT='Цены товара, загруженные Ñ Ð²Ð½ÐµÑˆÐ½Ð¸Ñ… Ñайтов'
54 COLLATE='utf8_general_ci'
55 ENGINE=InnoDB
56;