· 8 years ago · Feb 19, 2018, 10:16 AM
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_foreign_urls`;
16CREATE TABLE `products_foreign_urls` (
17 `products_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 `url` VARCHAR(500) NOT NULL COMMENT 'URL Ñтраницы Ñ Ñ†ÐµÐ½Ð°Ð¼Ð¸' DEFAULT '',
21 UNIQUE INDEX `products_id_foreign_sites_id` (`products_id`, `foreign_sites_id`),
22 PRIMARY KEY (`products_foreign_urls_id`)
23)
24 COMMENT='СÑылки на Ñтраницы Ñ Ñ†ÐµÐ½Ð°Ð¼Ð¸ на внешних Ñайтах'
25 COLLATE='utf8_general_ci'
26 ENGINE=InnoDB
27;
28
29DROP TABLE IF EXISTS `products_foreign_sites_states`;
30CREATE TABLE `products_foreign_sites_states` (
31 `products_foreign_sites_states_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 UNIQUE INDEX `products_id_foreign_sites_id` (`products_id`, `foreign_sites_id`),
36 PRIMARY KEY (`products_foreign_sites_states_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 `products_price` DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Цена продажи',
49 `products_old_price` DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Ð—Ð°Ñ‡ÐµÑ€ÐºÐ½ÑƒÑ‚Ð°Ñ Ñ†ÐµÐ½Ð°',
50 `products_promo_price` DECIMAL(15,2) NOT NULL DEFAULT '0.00' COMMENT 'Цена по промокоду',
51 UNIQUE INDEX `products_id_foreign_sites_id` (`products_id`, `foreign_sites_id`),
52 PRIMARY KEY (`products_foreign_sites_prices_id`)
53)
54 COMMENT='Цены товара, загруженные Ñ Ð²Ð½ÐµÑˆÐ½Ð¸Ñ… Ñайтов'
55 COLLATE='utf8_general_ci'
56 ENGINE=InnoDB
57;