DROP TABLE IF EXISTS `branch`;
CREATE TABLE `branch` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `branch` (`id`, `name`) VALUES
(1, 'Bratislava'),
(2, 'Nitra');

DROP TABLE IF EXISTS `item`;
CREATE TABLE `item` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `branch_id` int(10) unsigned NOT NULL,
  `name` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `branch_id` (`branch_id`),
  CONSTRAINT `item_ibfk_2` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `item` (`id`, `branch_id`, `name`) VALUES
(1, 1,  'Kladivo'),
(2, 1,  'Vŕtačka'),
(3, 2,  'Brúska'),
(5, 2,  'Šrobovák'),
(6, 2,  'Píla');

DROP TABLE IF EXISTS `opening_hour`;
CREATE TABLE `opening_hour` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `branch_id` int(10) unsigned NOT NULL,
  `day` tinyint(1) unsigned DEFAULT NULL,
  `date` date DEFAULT NULL,
  `from` time NOT NULL DEFAULT '00:00:00',
  `to` time NOT NULL DEFAULT '23:59:59',
  PRIMARY KEY (`id`),
  KEY `branch_id` (`branch_id`),
  CONSTRAINT `opening_hour_ibfk_1` FOREIGN KEY (`branch_id`) REFERENCES `branch` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

INSERT INTO `opening_hour` (`id`, `branch_id`, `day`, `date`, `from`, `to`) VALUES
(1, 1,  1,  NULL,   '08:00:00', '16:00:00'),
(2, 1,  2,  NULL,   '08:00:00', '16:00:00'),
(3, 1,  3,  NULL,   '08:00:00', '16:00:00'),
(4, 1,  4,  NULL,   '08:00:00', '16:00:00'),
(5, 1,  5,  NULL,   '08:00:00', '16:00:00'),
(6, 1,  NULL,   '2016-01-01',   '09:00:00', '12:00:00'),
(7, 1,  NULL,   '2016-12-24',   '09:00:00', '12:00:00'),
(8, 1,  NULL,   '2016-12-25',   '09:00:00', '12:00:00'),
(9, 1,  NULL,   '2016-12-31',   '09:00:00', '12:00:00'),
(10,    2,  1,  NULL,   '08:00:00', '18:00:00'),
(11,    2,  2,  NULL,   '08:00:00', '18:00:00'),
(12,    2,  3,  NULL,   '08:00:00', '18:00:00'),
(13,    2,  4,  NULL,   '08:00:00', '18:00:00'),
(14,    2,  5,  NULL,   '08:00:00', '18:00:00'),
(15,    2,  6,  NULL,   '08:00:00', '12:00:00'),
(16,    2,  7,  NULL,   '08:00:00', '12:00:00');