CREATE TABLE IF NOT EXISTS `price` (
  `import_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `country` varchar(2) COLLATE utf8_bin DEFAULT NULL,
  `sku` varchar(7) COLLATE utf8_bin DEFAULT NULL,
  `date_from` date DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  PRIMARY KEY (`import_id`),
  UNIQUE KEY `sku_country_date_index` (`sku`,`country`,`date_from`),
  KEY `sku_index` (`sku`),
  KEY `country_index` (`country`),
  KEY `date_from_index` (`date_from`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1;

REPLACE INTO `price`
(`country`, `sku`, `price`, `date_from`)
VALUES
('uk', '123', '10.00', '2015-01-01'),
('uk', '123', '11.00', '2015-01-02'),
('uk', '123', '9.00', '2015-01-03'),
('uk', '123', '9.00', '2015-01-04'),
('uk', '123', '9.00', '2015-01-05'),
('uk', '123', '10.00', '2015-01-06'),
('uk', '123', '9.00', '2015-01-07'),
('uk', '123', '10.00', '2015-01-08'),
('uk', '124', '10.00', '2015-01-06'),
('uk', '125', '10.00', '2015-01-06'),
('ie', '123', '10.00', '2015-01-06'),
('ie', '123', '14.00', '2015-01-07'),
('ie', '125', '10.00', '2015-01-06')

('uk', '123', '9.00', '2015-01-04')
('uk', '123', '9.00', '2015-01-05')