-- phpMyAdmin SQL Dump
-- version 4.2.11
-- http://www.phpmyadmin.net
--
-- Počítač: localhost
-- Vytvořeno: Ned 25. led 2015, 21:13
-- Verze serveru: 5.5.41-0ubuntu0.14.10.1
-- Verze PHP: 5.5.12-2ubuntu4.1

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Databáze: `minicup-2015`
--

-- --------------------------------------------------------

--
-- Struktura tabulky `category`
--

CREATE TABLE IF NOT EXISTS `category` (
`id` int(11) NOT NULL,
  `year_id` int(11) DEFAULT NULL,
  `name` char(30) COLLATE utf8_czech_ci NOT NULL,
  `slug` char(30) COLLATE utf8_czech_ci NOT NULL,
  `default` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `category`
--

INSERT INTO `category` (`id`, `year_id`, `name`, `slug`, `default`) VALUES
(1, 1, 'mladší', 'mladsi', 1),
(2, 1, 'starší', 'starsi', 0);

-- --------------------------------------------------------

--
-- Struktura tabulky `day`
--

CREATE TABLE IF NOT EXISTS `day` (
`id` int(11) NOT NULL,
  `day` date NOT NULL,
  `year_id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `day`
--

INSERT INTO `day` (`id`, `day`, `year_id`) VALUES
(77, '2015-05-23', 1),
(78, '2015-05-24', 1),
(79, '2015-05-25', 1);

-- --------------------------------------------------------

--
-- Struktura tabulky `match`
--

CREATE TABLE IF NOT EXISTS `match` (
`id` int(11) NOT NULL,
  `match_term_id` int(11) DEFAULT NULL,
  `category_id` int(11) NOT NULL,
  `home_team_info_id` int(11) NOT NULL,
  `away_team_info_id` int(11) NOT NULL,
  `score_home` int(11) DEFAULT NULL,
  `score_away` int(11) DEFAULT NULL,
  `confirmed` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB AUTO_INCREMENT=1609 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `match`
--

INSERT INTO `match` (`id`, `match_term_id`, `category_id`, `home_team_info_id`, `away_team_info_id`, `score_home`, `score_away`, `confirmed`) VALUES
(1585, 1034, 1, 78, 79, 14, 6, 1),
(1586, 1035, 1, 80, 81, 3, 8, 1),
(1587, 1036, 1, 82, 83, 6, 7, 1),
(1588, 1037, 1, 84, 85, 12, 16, 1),
(1589, 1038, 1, 86, 87, 6, 6, 1),
(1590, 1039, 1, 88, 83, 2, 4, 1),
(1591, 1040, 1, 80, 78, 6, 22, 1),
(1592, 1041, 1, 89, 79, 12, 13, 1),
(1593, 1042, 1, 87, 82, 17, 8, 1),
(1594, 1043, 1, 81, 84, 23, 5, 1),
(1595, 1044, 1, 85, 88, 15, 22, 1),
(1596, 1045, 1, 83, 86, 0, 8, 1),
(1597, 1046, 1, 78, 89, 16, 10, 1),
(1598, 1047, 1, 84, 80, 10, 10, 1),
(1599, 1048, 1, 79, 87, 9, 12, 1),
(1600, 1049, 1, 88, 81, 4, 11, 1),
(1601, 1050, 1, 86, 85, 16, 10, 1),
(1602, 1051, 1, 82, 89, 7, 14, 1),
(1603, 1052, 1, 84, 78, 6, 23, 1),
(1604, 1053, 1, 87, 89, 15, 15, 1),
(1605, 1054, 1, 80, 88, 13, 18, 1),
(1606, 1055, 1, 83, 79, 6, 17, 1),
(1607, 1056, 1, 81, 86, 5, 4, 1),
(1608, 1057, 1, 85, 82, 12, 11, 1);

-- --------------------------------------------------------

--
-- Struktura tabulky `match_term`
--

CREATE TABLE IF NOT EXISTS `match_term` (
`id` int(11) NOT NULL,
  `start` time NOT NULL,
  `end` time NOT NULL,
  `day_id` int(11) NOT NULL,
  `location` varchar(50) COLLATE utf8_czech_ci NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=1058 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `match_term`
--

INSERT INTO `match_term` (`id`, `start`, `end`, `day_id`, `location`) VALUES
(554, '13:00:00', '13:30:00', 77, ''),
(555, '13:30:00', '14:00:00', 77, ''),
(556, '14:00:00', '14:30:00', 77, ''),
(557, '14:30:00', '15:00:00', 77, ''),
(558, '15:00:00', '15:30:00', 77, ''),
(559, '15:30:00', '16:00:00', 77, ''),
(560, '16:00:00', '16:30:00', 77, ''),
(561, '16:30:00', '17:00:00', 77, ''),
(562, '17:00:00', '17:30:00', 77, ''),
(563, '09:00:00', '09:30:00', 78, ''),
(564, '09:30:00', '10:00:00', 78, ''),
(565, '10:00:00', '10:30:00', 78, ''),
(566, '10:30:00', '11:00:00', 78, ''),
(567, '11:00:00', '11:30:00', 78, ''),
(568, '11:30:00', '12:00:00', 78, ''),
(569, '12:00:00', '12:30:00', 78, ''),
(570, '12:30:00', '13:00:00', 78, ''),
(571, '13:00:00', '13:30:00', 78, ''),
(572, '13:30:00', '14:00:00', 78, ''),
(573, '14:00:00', '14:30:00', 78, ''),
(574, '14:30:00', '15:00:00', 78, ''),
(575, '15:00:00', '15:30:00', 78, ''),
(576, '09:00:00', '09:30:00', 79, ''),
(577, '09:30:00', '10:00:00', 79, ''),
(578, '10:00:00', '10:30:00', 79, ''),
(579, '10:30:00', '11:00:00', 79, ''),
(580, '11:00:00', '11:30:00', 79, ''),
(581, '11:30:00', '12:00:00', 79, ''),
(582, '12:00:00', '12:30:00', 79, ''),
(583, '12:30:00', '13:00:00', 79, ''),
(584, '13:00:00', '13:30:00', 79, ''),
(585, '13:30:00', '14:00:00', 79, ''),
(586, '14:00:00', '14:30:00', 79, ''),
(587, '13:00:00', '13:30:00', 77, ''),
(588, '13:00:00', '13:30:00', 77, ''),
(589, '13:00:00', '13:30:00', 77, ''),
(590, '13:00:00', '13:30:00', 77, ''),
(591, '13:00:00', '13:30:00', 77, ''),
(592, '13:30:00', '14:00:00', 77, ''),
(593, '13:30:00', '14:00:00', 77, ''),
(594, '14:00:00', '14:30:00', 77, ''),
(595, '14:00:00', '14:30:00', 77, ''),
(596, '14:30:00', '15:00:00', 77, ''),
(597, '14:30:00', '15:00:00', 77, ''),
(598, '15:00:00', '15:30:00', 77, ''),
(599, '15:00:00', '15:30:00', 77, ''),
(600, '15:30:00', '16:00:00', 77, ''),
(601, '15:30:00', '16:00:00', 77, ''),
(602, '16:00:00', '16:30:00', 77, ''),
(603, '16:00:00', '16:30:00', 77, ''),
(604, '16:30:00', '17:00:00', 77, ''),
(605, '16:30:00', '17:00:00', 77, ''),
(606, '17:00:00', '17:30:00', 77, ''),
(607, '17:00:00', '17:30:00', 77, ''),
(608, '09:00:00', '09:30:00', 78, ''),
(609, '09:00:00', '09:30:00', 78, ''),
(610, '09:30:00', '10:00:00', 78, ''),
(611, '09:30:00', '10:00:00', 78, ''),
(612, '10:00:00', '10:30:00', 78, ''),
(613, '10:00:00', '10:30:00', 78, ''),
(614, '13:00:00', '13:30:00', 77, ''),
(615, '13:00:00', '13:30:00', 77, ''),
(616, '13:30:00', '14:00:00', 77, ''),
(617, '13:30:00', '14:00:00', 77, ''),
(618, '14:00:00', '14:30:00', 77, ''),
(619, '14:00:00', '14:30:00', 77, ''),
(620, '14:30:00', '15:00:00', 77, ''),
(621, '14:30:00', '15:00:00', 77, ''),
(622, '15:00:00', '15:30:00', 77, ''),
(623, '15:00:00', '15:30:00', 77, ''),
(624, '15:30:00', '16:00:00', 77, ''),
(625, '15:30:00', '16:00:00', 77, ''),
(626, '16:00:00', '16:30:00', 77, ''),
(627, '16:00:00', '16:30:00', 77, ''),
(628, '16:30:00', '17:00:00', 77, ''),
(629, '16:30:00', '17:00:00', 77, ''),
(630, '17:00:00', '17:30:00', 77, ''),
(631, '17:00:00', '17:30:00', 77, ''),
(632, '09:00:00', '09:30:00', 78, ''),
(633, '09:00:00', '09:30:00', 78, ''),
(634, '09:30:00', '10:00:00', 78, ''),
(635, '09:30:00', '10:00:00', 78, ''),
(636, '10:00:00', '10:30:00', 78, ''),
(637, '10:00:00', '10:30:00', 78, ''),
(638, '10:30:00', '11:00:00', 78, ''),
(639, '10:30:00', '11:00:00', 78, ''),
(640, '11:00:00', '11:30:00', 78, ''),
(641, '11:00:00', '11:30:00', 78, ''),
(642, '11:30:00', '12:00:00', 78, ''),
(643, '11:30:00', '12:00:00', 78, ''),
(644, '12:00:00', '12:30:00', 78, ''),
(645, '12:00:00', '12:30:00', 78, ''),
(646, '12:30:00', '13:00:00', 78, ''),
(647, '12:30:00', '13:00:00', 78, ''),
(648, '13:00:00', '13:30:00', 78, ''),
(649, '13:00:00', '13:30:00', 78, ''),
(650, '13:30:00', '14:00:00', 78, ''),
(651, '13:30:00', '14:00:00', 78, ''),
(652, '14:00:00', '14:30:00', 78, ''),
(653, '14:00:00', '14:30:00', 78, ''),
(654, '14:30:00', '15:00:00', 78, ''),
(655, '14:30:00', '15:00:00', 78, ''),
(656, '15:00:00', '15:30:00', 78, ''),
(657, '15:00:00', '15:30:00', 78, ''),
(658, '09:00:00', '09:30:00', 79, ''),
(659, '09:00:00', '09:30:00', 79, ''),
(660, '09:30:00', '10:00:00', 79, ''),
(661, '09:30:00', '10:00:00', 79, ''),
(662, '10:00:00', '10:30:00', 79, ''),
(663, '10:00:00', '10:30:00', 79, ''),
(664, '10:30:00', '11:00:00', 79, ''),
(665, '10:30:00', '11:00:00', 79, ''),
(666, '11:00:00', '11:30:00', 79, ''),
(667, '11:00:00', '11:30:00', 79, ''),
(668, '11:30:00', '12:00:00', 79, ''),
(669, '11:30:00', '12:00:00', 79, ''),
(670, '12:00:00', '12:30:00', 79, ''),
(671, '12:00:00', '12:30:00', 79, ''),
(672, '12:30:00', '13:00:00', 79, ''),
(673, '12:30:00', '13:00:00', 79, ''),
(674, '13:00:00', '13:30:00', 79, ''),
(675, '13:00:00', '13:30:00', 79, ''),
(676, '13:30:00', '14:00:00', 79, ''),
(677, '13:30:00', '14:00:00', 79, ''),
(678, '14:00:00', '14:30:00', 79, ''),
(679, '14:00:00', '14:30:00', 79, ''),
(680, '13:00:00', '13:30:00', 77, ''),
(681, '13:00:00', '13:30:00', 77, ''),
(682, '13:30:00', '14:00:00', 77, ''),
(683, '13:30:00', '14:00:00', 77, ''),
(684, '14:00:00', '14:30:00', 77, ''),
(685, '14:00:00', '14:30:00', 77, ''),
(686, '14:30:00', '15:00:00', 77, ''),
(687, '14:30:00', '15:00:00', 77, ''),
(688, '15:00:00', '15:30:00', 77, ''),
(689, '15:00:00', '15:30:00', 77, ''),
(690, '15:30:00', '16:00:00', 77, ''),
(691, '15:30:00', '16:00:00', 77, ''),
(692, '16:00:00', '16:30:00', 77, ''),
(693, '16:00:00', '16:30:00', 77, ''),
(694, '16:30:00', '17:00:00', 77, ''),
(695, '16:30:00', '17:00:00', 77, ''),
(696, '17:00:00', '17:30:00', 77, ''),
(697, '17:00:00', '17:30:00', 77, ''),
(698, '09:00:00', '09:30:00', 78, ''),
(699, '09:00:00', '09:30:00', 78, ''),
(700, '09:30:00', '10:00:00', 78, ''),
(701, '09:30:00', '10:00:00', 78, ''),
(702, '10:00:00', '10:30:00', 78, ''),
(703, '10:00:00', '10:30:00', 78, ''),
(704, '10:30:00', '11:00:00', 78, ''),
(705, '10:30:00', '11:00:00', 78, ''),
(706, '11:00:00', '11:30:00', 78, ''),
(707, '11:00:00', '11:30:00', 78, ''),
(708, '11:30:00', '12:00:00', 78, ''),
(709, '11:30:00', '12:00:00', 78, ''),
(710, '12:00:00', '12:30:00', 78, ''),
(711, '12:00:00', '12:30:00', 78, ''),
(712, '12:30:00', '13:00:00', 78, ''),
(713, '12:30:00', '13:00:00', 78, ''),
(714, '13:00:00', '13:30:00', 78, ''),
(715, '13:00:00', '13:30:00', 78, ''),
(716, '13:30:00', '14:00:00', 78, ''),
(717, '13:30:00', '14:00:00', 78, ''),
(718, '14:00:00', '14:30:00', 78, ''),
(719, '14:00:00', '14:30:00', 78, ''),
(720, '14:30:00', '15:00:00', 78, ''),
(721, '14:30:00', '15:00:00', 78, ''),
(722, '15:00:00', '15:30:00', 78, ''),
(723, '15:00:00', '15:30:00', 78, ''),
(724, '09:00:00', '09:30:00', 79, ''),
(725, '09:00:00', '09:30:00', 79, ''),
(726, '09:30:00', '10:00:00', 79, ''),
(727, '09:30:00', '10:00:00', 79, ''),
(728, '10:00:00', '10:30:00', 79, ''),
(729, '10:00:00', '10:30:00', 79, ''),
(730, '10:30:00', '11:00:00', 79, ''),
(731, '10:30:00', '11:00:00', 79, ''),
(732, '11:00:00', '11:30:00', 79, ''),
(733, '11:00:00', '11:30:00', 79, ''),
(734, '11:30:00', '12:00:00', 79, ''),
(735, '11:30:00', '12:00:00', 79, ''),
(736, '12:00:00', '12:30:00', 79, ''),
(737, '12:00:00', '12:30:00', 79, ''),
(738, '12:30:00', '13:00:00', 79, ''),
(739, '12:30:00', '13:00:00', 79, ''),
(740, '13:00:00', '13:30:00', 79, ''),
(741, '13:00:00', '13:30:00', 79, ''),
(742, '13:30:00', '14:00:00', 79, ''),
(743, '13:30:00', '14:00:00', 79, ''),
(744, '14:00:00', '14:30:00', 79, ''),
(745, '14:00:00', '14:30:00', 79, ''),
(746, '13:00:00', '13:30:00', 77, ''),
(747, '13:00:00', '13:30:00', 77, ''),
(748, '13:30:00', '14:00:00', 77, ''),
(749, '13:30:00', '14:00:00', 77, ''),
(750, '14:00:00', '14:30:00', 77, ''),
(751, '14:00:00', '14:30:00', 77, ''),
(752, '14:30:00', '15:00:00', 77, ''),
(753, '14:30:00', '15:00:00', 77, ''),
(754, '15:00:00', '15:30:00', 77, ''),
(755, '15:00:00', '15:30:00', 77, ''),
(756, '15:30:00', '16:00:00', 77, ''),
(757, '15:30:00', '16:00:00', 77, ''),
(758, '16:00:00', '16:30:00', 77, ''),
(759, '16:00:00', '16:30:00', 77, ''),
(760, '16:30:00', '17:00:00', 77, ''),
(761, '16:30:00', '17:00:00', 77, ''),
(762, '17:00:00', '17:30:00', 77, ''),
(763, '17:00:00', '17:30:00', 77, ''),
(764, '09:00:00', '09:30:00', 78, ''),
(765, '09:00:00', '09:30:00', 78, ''),
(766, '09:30:00', '10:00:00', 78, ''),
(767, '09:30:00', '10:00:00', 78, ''),
(768, '10:00:00', '10:30:00', 78, ''),
(769, '10:00:00', '10:30:00', 78, ''),
(770, '10:30:00', '11:00:00', 78, ''),
(771, '10:30:00', '11:00:00', 78, ''),
(772, '11:00:00', '11:30:00', 78, ''),
(773, '11:00:00', '11:30:00', 78, ''),
(774, '11:30:00', '12:00:00', 78, ''),
(775, '11:30:00', '12:00:00', 78, ''),
(776, '12:00:00', '12:30:00', 78, ''),
(777, '12:00:00', '12:30:00', 78, ''),
(778, '12:30:00', '13:00:00', 78, ''),
(779, '12:30:00', '13:00:00', 78, ''),
(780, '13:00:00', '13:30:00', 78, ''),
(781, '13:00:00', '13:30:00', 78, ''),
(782, '13:30:00', '14:00:00', 78, ''),
(783, '13:30:00', '14:00:00', 78, ''),
(784, '14:00:00', '14:30:00', 78, ''),
(785, '14:00:00', '14:30:00', 78, ''),
(786, '14:30:00', '15:00:00', 78, ''),
(787, '14:30:00', '15:00:00', 78, ''),
(788, '15:00:00', '15:30:00', 78, ''),
(789, '15:00:00', '15:30:00', 78, ''),
(790, '09:00:00', '09:30:00', 79, ''),
(791, '09:00:00', '09:30:00', 79, ''),
(792, '09:30:00', '10:00:00', 79, ''),
(793, '09:30:00', '10:00:00', 79, ''),
(794, '10:00:00', '10:30:00', 79, ''),
(795, '10:00:00', '10:30:00', 79, ''),
(796, '10:30:00', '11:00:00', 79, ''),
(797, '10:30:00', '11:00:00', 79, ''),
(798, '11:00:00', '11:30:00', 79, ''),
(799, '11:00:00', '11:30:00', 79, ''),
(800, '11:30:00', '12:00:00', 79, ''),
(801, '11:30:00', '12:00:00', 79, ''),
(802, '12:00:00', '12:30:00', 79, ''),
(803, '12:00:00', '12:30:00', 79, ''),
(804, '12:30:00', '13:00:00', 79, ''),
(805, '12:30:00', '13:00:00', 79, ''),
(806, '13:00:00', '13:30:00', 79, ''),
(807, '13:00:00', '13:30:00', 79, ''),
(808, '13:30:00', '14:00:00', 79, ''),
(809, '13:30:00', '14:00:00', 79, ''),
(810, '14:00:00', '14:30:00', 79, ''),
(811, '14:00:00', '14:30:00', 79, ''),
(812, '13:00:00', '13:30:00', 77, ''),
(813, '13:00:00', '13:30:00', 77, ''),
(814, '13:30:00', '14:00:00', 77, ''),
(815, '13:30:00', '14:00:00', 77, ''),
(816, '14:00:00', '14:30:00', 77, ''),
(817, '14:00:00', '14:30:00', 77, ''),
(818, '14:30:00', '15:00:00', 77, ''),
(819, '14:30:00', '15:00:00', 77, ''),
(820, '15:00:00', '15:30:00', 77, ''),
(821, '15:00:00', '15:30:00', 77, ''),
(822, '15:30:00', '16:00:00', 77, ''),
(823, '15:30:00', '16:00:00', 77, ''),
(824, '16:00:00', '16:30:00', 77, ''),
(825, '16:00:00', '16:30:00', 77, ''),
(826, '16:30:00', '17:00:00', 77, ''),
(827, '16:30:00', '17:00:00', 77, ''),
(828, '17:00:00', '17:30:00', 77, ''),
(829, '17:00:00', '17:30:00', 77, ''),
(830, '09:00:00', '09:30:00', 78, ''),
(831, '09:00:00', '09:30:00', 78, ''),
(832, '09:30:00', '10:00:00', 78, ''),
(833, '09:30:00', '10:00:00', 78, ''),
(834, '10:00:00', '10:30:00', 78, ''),
(835, '10:00:00', '10:30:00', 78, ''),
(836, '10:30:00', '11:00:00', 78, ''),
(837, '10:30:00', '11:00:00', 78, ''),
(838, '11:00:00', '11:30:00', 78, ''),
(839, '11:00:00', '11:30:00', 78, ''),
(840, '11:30:00', '12:00:00', 78, ''),
(841, '11:30:00', '12:00:00', 78, ''),
(842, '12:00:00', '12:30:00', 78, ''),
(843, '12:00:00', '12:30:00', 78, ''),
(844, '12:30:00', '13:00:00', 78, ''),
(845, '12:30:00', '13:00:00', 78, ''),
(846, '13:00:00', '13:30:00', 78, ''),
(847, '13:00:00', '13:30:00', 78, ''),
(848, '13:30:00', '14:00:00', 78, ''),
(849, '13:30:00', '14:00:00', 78, ''),
(850, '14:00:00', '14:30:00', 78, ''),
(851, '14:00:00', '14:30:00', 78, ''),
(852, '14:30:00', '15:00:00', 78, ''),
(853, '14:30:00', '15:00:00', 78, ''),
(854, '15:00:00', '15:30:00', 78, ''),
(855, '15:00:00', '15:30:00', 78, ''),
(856, '09:00:00', '09:30:00', 79, ''),
(857, '09:00:00', '09:30:00', 79, ''),
(858, '09:30:00', '10:00:00', 79, ''),
(859, '09:30:00', '10:00:00', 79, ''),
(860, '10:00:00', '10:30:00', 79, ''),
(861, '10:00:00', '10:30:00', 79, ''),
(862, '10:30:00', '11:00:00', 79, ''),
(863, '10:30:00', '11:00:00', 79, ''),
(864, '11:00:00', '11:30:00', 79, ''),
(865, '11:00:00', '11:30:00', 79, ''),
(866, '11:30:00', '12:00:00', 79, ''),
(867, '11:30:00', '12:00:00', 79, ''),
(868, '12:00:00', '12:30:00', 79, ''),
(869, '12:00:00', '12:30:00', 79, ''),
(870, '12:30:00', '13:00:00', 79, ''),
(871, '12:30:00', '13:00:00', 79, ''),
(872, '13:00:00', '13:30:00', 79, ''),
(873, '13:00:00', '13:30:00', 79, ''),
(874, '13:30:00', '14:00:00', 79, ''),
(875, '13:30:00', '14:00:00', 79, ''),
(876, '14:00:00', '14:30:00', 79, ''),
(877, '14:00:00', '14:30:00', 79, ''),
(878, '13:00:00', '13:30:00', 77, ''),
(879, '13:00:00', '13:30:00', 77, ''),
(880, '13:30:00', '14:00:00', 77, ''),
(881, '13:30:00', '14:00:00', 77, ''),
(882, '14:00:00', '14:30:00', 77, ''),
(883, '14:00:00', '14:30:00', 77, ''),
(884, '14:30:00', '15:00:00', 77, ''),
(885, '14:30:00', '15:00:00', 77, ''),
(886, '15:00:00', '15:30:00', 77, ''),
(887, '15:00:00', '15:30:00', 77, ''),
(888, '15:30:00', '16:00:00', 77, ''),
(889, '15:30:00', '16:00:00', 77, ''),
(890, '16:00:00', '16:30:00', 77, ''),
(891, '16:00:00', '16:30:00', 77, ''),
(892, '16:30:00', '17:00:00', 77, ''),
(893, '16:30:00', '17:00:00', 77, ''),
(894, '17:00:00', '17:30:00', 77, ''),
(895, '17:00:00', '17:30:00', 77, ''),
(896, '09:00:00', '09:30:00', 78, ''),
(897, '09:00:00', '09:30:00', 78, ''),
(898, '09:30:00', '10:00:00', 78, ''),
(899, '09:30:00', '10:00:00', 78, ''),
(900, '10:00:00', '10:30:00', 78, ''),
(901, '10:00:00', '10:30:00', 78, ''),
(902, '10:30:00', '11:00:00', 78, ''),
(903, '10:30:00', '11:00:00', 78, ''),
(904, '11:00:00', '11:30:00', 78, ''),
(905, '11:00:00', '11:30:00', 78, ''),
(906, '11:30:00', '12:00:00', 78, ''),
(907, '11:30:00', '12:00:00', 78, ''),
(908, '12:00:00', '12:30:00', 78, ''),
(909, '12:00:00', '12:30:00', 78, ''),
(910, '12:30:00', '13:00:00', 78, ''),
(911, '12:30:00', '13:00:00', 78, ''),
(912, '13:00:00', '13:30:00', 78, ''),
(913, '13:00:00', '13:30:00', 78, ''),
(914, '13:30:00', '14:00:00', 78, ''),
(915, '13:30:00', '14:00:00', 78, ''),
(916, '14:00:00', '14:30:00', 78, ''),
(917, '14:00:00', '14:30:00', 78, ''),
(918, '14:30:00', '15:00:00', 78, ''),
(919, '14:30:00', '15:00:00', 78, ''),
(920, '15:00:00', '15:30:00', 78, ''),
(921, '15:00:00', '15:30:00', 78, ''),
(922, '09:00:00', '09:30:00', 79, ''),
(923, '09:00:00', '09:30:00', 79, ''),
(924, '09:30:00', '10:00:00', 79, ''),
(925, '09:30:00', '10:00:00', 79, ''),
(926, '10:00:00', '10:30:00', 79, ''),
(927, '10:00:00', '10:30:00', 79, ''),
(928, '10:30:00', '11:00:00', 79, ''),
(929, '10:30:00', '11:00:00', 79, ''),
(930, '11:00:00', '11:30:00', 79, ''),
(931, '11:00:00', '11:30:00', 79, ''),
(932, '11:30:00', '12:00:00', 79, ''),
(933, '11:30:00', '12:00:00', 79, ''),
(934, '12:00:00', '12:30:00', 79, ''),
(935, '12:00:00', '12:30:00', 79, ''),
(936, '12:30:00', '13:00:00', 79, ''),
(937, '12:30:00', '13:00:00', 79, ''),
(938, '13:00:00', '13:30:00', 79, ''),
(939, '13:00:00', '13:30:00', 79, ''),
(940, '13:30:00', '14:00:00', 79, ''),
(941, '13:30:00', '14:00:00', 79, ''),
(942, '14:00:00', '14:30:00', 79, ''),
(943, '14:00:00', '14:30:00', 79, ''),
(944, '13:00:00', '13:30:00', 77, ''),
(945, '13:00:00', '13:30:00', 77, ''),
(946, '13:30:00', '14:00:00', 77, ''),
(947, '13:30:00', '14:00:00', 77, ''),
(948, '14:00:00', '14:30:00', 77, ''),
(949, '14:00:00', '14:30:00', 77, ''),
(950, '14:30:00', '15:00:00', 77, ''),
(951, '14:30:00', '15:00:00', 77, ''),
(952, '15:00:00', '15:30:00', 77, ''),
(953, '15:00:00', '15:30:00', 77, ''),
(954, '15:30:00', '16:00:00', 77, ''),
(955, '15:30:00', '16:00:00', 77, ''),
(956, '16:00:00', '16:30:00', 77, ''),
(957, '16:00:00', '16:30:00', 77, ''),
(958, '16:30:00', '17:00:00', 77, ''),
(959, '16:30:00', '17:00:00', 77, ''),
(960, '17:00:00', '17:30:00', 77, ''),
(961, '17:00:00', '17:30:00', 77, ''),
(962, '09:00:00', '09:30:00', 78, ''),
(963, '09:00:00', '09:30:00', 78, ''),
(964, '09:30:00', '10:00:00', 78, ''),
(965, '09:30:00', '10:00:00', 78, ''),
(966, '10:00:00', '10:30:00', 78, ''),
(967, '10:00:00', '10:30:00', 78, ''),
(968, '10:30:00', '11:00:00', 78, ''),
(969, '10:30:00', '11:00:00', 78, ''),
(970, '11:00:00', '11:30:00', 78, ''),
(971, '11:00:00', '11:30:00', 78, ''),
(972, '11:30:00', '12:00:00', 78, ''),
(973, '11:30:00', '12:00:00', 78, ''),
(974, '12:00:00', '12:30:00', 78, ''),
(975, '12:00:00', '12:30:00', 78, ''),
(976, '12:30:00', '13:00:00', 78, ''),
(977, '12:30:00', '13:00:00', 78, ''),
(978, '13:00:00', '13:30:00', 78, ''),
(979, '13:00:00', '13:30:00', 78, ''),
(980, '13:30:00', '14:00:00', 78, ''),
(981, '13:30:00', '14:00:00', 78, ''),
(982, '14:00:00', '14:30:00', 78, ''),
(983, '14:00:00', '14:30:00', 78, ''),
(984, '14:30:00', '15:00:00', 78, ''),
(985, '14:30:00', '15:00:00', 78, ''),
(986, '15:00:00', '15:30:00', 78, ''),
(987, '15:00:00', '15:30:00', 78, ''),
(988, '09:00:00', '09:30:00', 79, ''),
(989, '09:00:00', '09:30:00', 79, ''),
(990, '09:30:00', '10:00:00', 79, ''),
(991, '09:30:00', '10:00:00', 79, ''),
(992, '10:00:00', '10:30:00', 79, ''),
(993, '10:00:00', '10:30:00', 79, ''),
(994, '10:30:00', '11:00:00', 79, ''),
(995, '10:30:00', '11:00:00', 79, ''),
(996, '11:00:00', '11:30:00', 79, ''),
(997, '11:00:00', '11:30:00', 79, ''),
(998, '11:30:00', '12:00:00', 79, ''),
(999, '11:30:00', '12:00:00', 79, ''),
(1000, '12:00:00', '12:30:00', 79, ''),
(1001, '12:00:00', '12:30:00', 79, ''),
(1002, '12:30:00', '13:00:00', 79, ''),
(1003, '12:30:00', '13:00:00', 79, ''),
(1004, '13:00:00', '13:30:00', 79, ''),
(1005, '13:00:00', '13:30:00', 79, ''),
(1006, '13:30:00', '14:00:00', 79, ''),
(1007, '13:30:00', '14:00:00', 79, ''),
(1008, '14:00:00', '14:30:00', 79, ''),
(1009, '14:00:00', '14:30:00', 79, ''),
(1010, '13:00:00', '13:30:00', 77, ''),
(1011, '13:00:00', '13:30:00', 77, ''),
(1012, '13:30:00', '14:00:00', 77, ''),
(1013, '13:30:00', '14:00:00', 77, ''),
(1014, '14:00:00', '14:30:00', 77, ''),
(1015, '14:00:00', '14:30:00', 77, ''),
(1016, '14:30:00', '15:00:00', 77, ''),
(1017, '14:30:00', '15:00:00', 77, ''),
(1018, '15:00:00', '15:30:00', 77, ''),
(1019, '15:00:00', '15:30:00', 77, ''),
(1020, '15:30:00', '16:00:00', 77, ''),
(1021, '15:30:00', '16:00:00', 77, ''),
(1022, '16:00:00', '16:30:00', 77, ''),
(1023, '16:00:00', '16:30:00', 77, ''),
(1024, '16:30:00', '17:00:00', 77, ''),
(1025, '16:30:00', '17:00:00', 77, ''),
(1026, '17:00:00', '17:30:00', 77, ''),
(1027, '17:00:00', '17:30:00', 77, ''),
(1028, '09:00:00', '09:30:00', 78, ''),
(1029, '09:00:00', '09:30:00', 78, ''),
(1030, '09:30:00', '10:00:00', 78, ''),
(1031, '09:30:00', '10:00:00', 78, ''),
(1032, '10:00:00', '10:30:00', 78, ''),
(1033, '10:00:00', '10:30:00', 78, ''),
(1034, '13:00:00', '13:30:00', 77, ''),
(1035, '13:00:00', '13:30:00', 77, ''),
(1036, '13:30:00', '14:00:00', 77, ''),
(1037, '13:30:00', '14:00:00', 77, ''),
(1038, '14:00:00', '14:30:00', 77, ''),
(1039, '14:00:00', '14:30:00', 77, ''),
(1040, '14:30:00', '15:00:00', 77, ''),
(1041, '14:30:00', '15:00:00', 77, ''),
(1042, '15:00:00', '15:30:00', 77, ''),
(1043, '15:00:00', '15:30:00', 77, ''),
(1044, '15:30:00', '16:00:00', 77, ''),
(1045, '15:30:00', '16:00:00', 77, ''),
(1046, '16:00:00', '16:30:00', 77, ''),
(1047, '16:00:00', '16:30:00', 77, ''),
(1048, '16:30:00', '17:00:00', 77, ''),
(1049, '16:30:00', '17:00:00', 77, ''),
(1050, '17:00:00', '17:30:00', 77, ''),
(1051, '17:00:00', '17:30:00', 77, ''),
(1052, '09:00:00', '09:30:00', 78, ''),
(1053, '09:00:00', '09:30:00', 78, ''),
(1054, '09:30:00', '10:00:00', 78, ''),
(1055, '09:30:00', '10:00:00', 78, ''),
(1056, '10:00:00', '10:30:00', 78, ''),
(1057, '10:00:00', '10:30:00', 78, '');

-- --------------------------------------------------------

--
-- Struktura tabulky `online_report`
--

CREATE TABLE IF NOT EXISTS `online_report` (
`id` int(11) NOT NULL,
  `match_id` int(11) NOT NULL,
  `message` text COLLATE utf8_czech_ci NOT NULL,
  `type` char(20) COLLATE utf8_czech_ci NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `added` datetime NOT NULL,
  `author` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

-- --------------------------------------------------------

--
-- Struktura tabulky `photo`
--

CREATE TABLE IF NOT EXISTS `photo` (
`id` int(11) NOT NULL,
  `path_full` text COLLATE utf8_czech_ci NOT NULL,
  `path_thumb` text COLLATE utf8_czech_ci NOT NULL,
  `captured` datetime NOT NULL,
  `author_id` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `photo`
--

INSERT INTO `photo` (`id`, `path_full`, `path_thumb`, `captured`, `author_id`) VALUES
(1, 'cesta_full', 'cesta_thumb', '2015-01-19 22:11:20', 1);

-- --------------------------------------------------------

--
-- Struktura tabulky `photo_tag`
--

CREATE TABLE IF NOT EXISTS `photo_tag` (
  `photo_id` int(11) NOT NULL,
  `tag_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `photo_tag`
--

INSERT INTO `photo_tag` (`photo_id`, `tag_id`) VALUES
(1, 1);

-- --------------------------------------------------------

--
-- Struktura tabulky `static_content`
--

CREATE TABLE IF NOT EXISTS `static_content` (
`id` int(11) NOT NULL,
  `content` text COLLATE utf8_czech_ci NOT NULL,
  `updated` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  `user_id` int(11) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `static_content`
--

INSERT INTO `static_content` (`id`, `content`, `updated`, `user_id`) VALUES
(1, 'Vítejte!\r\n--------\r\n\r\nMůžete používat syntax Texy!, pokud Vám vyhovuje:\r\n- třeba **tučné** písmo nebo *kurzíva*\r\n- a takto se dělá "odkaz":http://texy.info\r\n- více najdete na stránce \r\n\r\nLook at homepage:[Team:default].\r\n\r\n\r\n"syntax":[syntax]\r\n\r\n\r\nAle také můžete zůstat u HTML:\r\n- takto <b>HTML</b>\r\n- nebo i <b class=xx>úplně <i>hloupě</b>, Texy! to pořeší\r\n\r\n\r\n[syntax]: /cs/syntax', '2015-01-24 20:49:00', 1);

-- --------------------------------------------------------

--
-- Struktura tabulky `tag`
--

CREATE TABLE IF NOT EXISTS `tag` (
`id` int(11) NOT NULL,
  `name` text COLLATE utf8_czech_ci,
  `slug` text COLLATE utf8_czech_ci NOT NULL,
  `is_gallery` int(11) NOT NULL DEFAULT '0',
  `main_photo_id` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `tag`
--

INSERT INTO `tag` (`id`, `name`, `slug`, `is_gallery`, `main_photo_id`) VALUES
(1, 'nějaký tag', 'nejaky-tag', 0, 1);

-- --------------------------------------------------------

--
-- Struktura tabulky `team`
--

CREATE TABLE IF NOT EXISTS `team` (
`id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `team_info_id` int(11) NOT NULL,
  `order` int(11) NOT NULL,
  `points` int(11) NOT NULL,
  `scored` int(11) NOT NULL,
  `received` int(11) NOT NULL,
  `inserted` datetime NOT NULL,
  `actual` int(11) NOT NULL DEFAULT '0',
  `after_match_id` int(11) DEFAULT NULL
) ENGINE=InnoDB AUTO_INCREMENT=5828 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `team`
--

INSERT INTO `team` (`id`, `category_id`, `team_info_id`, `order`, `points`, `scored`, `received`, `inserted`, `actual`, `after_match_id`) VALUES
(5560, 1, 78, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1585),
(5561, 1, 79, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1585),
(5562, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:36', 0, 1586),
(5563, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:36', 0, 1586),
(5564, 1, 80, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1586),
(5565, 1, 81, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1586),
(5566, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:36', 0, 1587),
(5567, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:36', 0, 1587),
(5568, 1, 80, 0, 0, 3, 8, '2015-01-25 21:12:36', 0, 1587),
(5569, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:36', 0, 1587),
(5570, 1, 82, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1587),
(5571, 1, 83, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1587),
(5572, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:36', 0, 1588),
(5573, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:36', 0, 1588),
(5574, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:36', 0, 1588),
(5575, 1, 80, 0, 0, 3, 8, '2015-01-25 21:12:36', 0, 1588),
(5576, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:36', 0, 1588),
(5577, 1, 83, 0, 2, 7, 6, '2015-01-25 21:12:36', 0, 1588),
(5578, 1, 84, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1588),
(5579, 1, 85, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1588),
(5580, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:36', 0, 1589),
(5581, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:36', 0, 1589),
(5582, 1, 83, 0, 2, 7, 6, '2015-01-25 21:12:37', 0, 1589),
(5583, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:37', 0, 1589),
(5584, 1, 80, 0, 0, 3, 8, '2015-01-25 21:12:37', 0, 1589),
(5585, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:37', 0, 1589),
(5586, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:37', 0, 1589),
(5587, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:37', 0, 1589),
(5588, 1, 86, 0, 0, 0, 0, '2015-01-25 21:12:37', 0, 1589),
(5589, 1, 87, 0, 0, 0, 0, '2015-01-25 21:12:37', 0, 1589),
(5590, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:37', 0, 1590),
(5591, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:37', 0, 1590),
(5592, 1, 83, 0, 2, 7, 6, '2015-01-25 21:12:37', 0, 1590),
(5593, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:37', 0, 1590),
(5594, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:37', 0, 1590),
(5595, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:37', 0, 1590),
(5596, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:37', 0, 1590),
(5597, 1, 80, 0, 0, 3, 8, '2015-01-25 21:12:37', 0, 1590),
(5598, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:37', 0, 1590),
(5599, 1, 87, 0, 1, 6, 6, '2015-01-25 21:12:37', 0, 1590),
(5600, 1, 88, 0, 0, 0, 0, '2015-01-25 21:12:37', 0, 1590),
(5601, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:37', 0, 1591),
(5602, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:37', 0, 1591),
(5603, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:37', 0, 1591),
(5604, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:37', 0, 1591),
(5605, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:37', 0, 1591),
(5606, 1, 87, 0, 1, 6, 6, '2015-01-25 21:12:37', 0, 1591),
(5607, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:37', 0, 1591),
(5608, 1, 80, 0, 0, 3, 8, '2015-01-25 21:12:37', 0, 1591),
(5609, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:37', 0, 1591),
(5610, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:37', 0, 1591),
(5611, 1, 88, 0, 0, 2, 4, '2015-01-25 21:12:37', 0, 1591),
(5612, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:38', 0, 1592),
(5613, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:38', 0, 1592),
(5614, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:38', 0, 1592),
(5615, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:38', 0, 1592),
(5616, 1, 87, 0, 1, 6, 6, '2015-01-25 21:12:38', 0, 1592),
(5617, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:38', 0, 1592),
(5618, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:38', 0, 1592),
(5619, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:38', 0, 1592),
(5620, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:38', 0, 1592),
(5621, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:38', 0, 1592),
(5622, 1, 88, 0, 0, 2, 4, '2015-01-25 21:12:38', 0, 1592),
(5623, 1, 89, 0, 0, 0, 0, '2015-01-25 21:12:38', 0, 1592),
(5624, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:38', 0, 1593),
(5625, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:38', 0, 1593),
(5626, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:38', 0, 1593),
(5627, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:38', 0, 1593),
(5628, 1, 87, 0, 1, 6, 6, '2015-01-25 21:12:38', 0, 1593),
(5629, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:38', 0, 1593),
(5630, 1, 88, 0, 0, 2, 4, '2015-01-25 21:12:38', 0, 1593),
(5631, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:38', 0, 1593),
(5632, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:38', 0, 1593),
(5633, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:38', 0, 1593),
(5634, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:38', 0, 1593),
(5635, 1, 89, 0, 0, 12, 13, '2015-01-25 21:12:38', 0, 1593),
(5636, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:38', 0, 1594),
(5637, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:38', 0, 1594),
(5638, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:38', 0, 1594),
(5639, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:38', 0, 1594),
(5640, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:38', 0, 1594),
(5641, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:39', 0, 1594),
(5642, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:39', 0, 1594),
(5643, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:39', 0, 1594),
(5644, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:39', 0, 1594),
(5645, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:39', 0, 1594),
(5646, 1, 88, 0, 0, 2, 4, '2015-01-25 21:12:39', 0, 1594),
(5647, 1, 89, 0, 0, 12, 13, '2015-01-25 21:12:39', 0, 1594),
(5648, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:39', 0, 1595),
(5649, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:39', 0, 1595),
(5650, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:39', 0, 1595),
(5651, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:39', 0, 1595),
(5652, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:39', 0, 1595),
(5653, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:39', 0, 1595),
(5654, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:39', 0, 1595),
(5655, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:39', 0, 1595),
(5656, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:39', 0, 1595),
(5657, 1, 84, 0, 0, 17, 39, '2015-01-25 21:12:39', 0, 1595),
(5658, 1, 88, 0, 0, 2, 4, '2015-01-25 21:12:39', 0, 1595),
(5659, 1, 89, 0, 0, 12, 13, '2015-01-25 21:12:39', 0, 1595),
(5660, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:40', 0, 1596),
(5661, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:40', 0, 1596),
(5662, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:40', 0, 1596),
(5663, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:40', 0, 1596),
(5664, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:40', 0, 1596),
(5665, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:40', 0, 1596),
(5666, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:40', 0, 1596),
(5667, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:40', 0, 1596),
(5668, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:40', 0, 1596),
(5669, 1, 84, 0, 0, 17, 39, '2015-01-25 21:12:40', 0, 1596),
(5670, 1, 88, 0, 2, 24, 19, '2015-01-25 21:12:40', 0, 1596),
(5671, 1, 89, 0, 0, 12, 13, '2015-01-25 21:12:40', 0, 1596),
(5672, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:40', 0, 1597),
(5673, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:40', 0, 1597),
(5674, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:40', 0, 1597),
(5675, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:40', 0, 1597),
(5676, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:40', 0, 1597),
(5677, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:40', 0, 1597),
(5678, 1, 88, 0, 2, 24, 19, '2015-01-25 21:12:40', 0, 1597),
(5679, 1, 86, 0, 3, 14, 6, '2015-01-25 21:12:40', 0, 1597),
(5680, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:40', 0, 1597),
(5681, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:40', 0, 1597),
(5682, 1, 84, 0, 0, 17, 39, '2015-01-25 21:12:40', 0, 1597),
(5683, 1, 89, 0, 0, 12, 13, '2015-01-25 21:12:40', 0, 1597),
(5684, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:41', 0, 1598),
(5685, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:41', 0, 1598),
(5686, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:41', 0, 1598),
(5687, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:41', 0, 1598),
(5688, 1, 86, 0, 3, 14, 6, '2015-01-25 21:12:41', 0, 1598),
(5689, 1, 88, 0, 2, 24, 19, '2015-01-25 21:12:41', 0, 1598),
(5690, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:41', 0, 1598),
(5691, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:41', 0, 1598),
(5692, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:41', 0, 1598),
(5693, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:41', 0, 1598),
(5694, 1, 84, 0, 0, 17, 39, '2015-01-25 21:12:41', 0, 1598),
(5695, 1, 89, 0, 0, 22, 29, '2015-01-25 21:12:41', 0, 1598),
(5696, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:41', 0, 1599),
(5697, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:41', 0, 1599),
(5698, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:41', 0, 1599),
(5699, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:41', 0, 1599),
(5700, 1, 86, 0, 3, 14, 6, '2015-01-25 21:12:41', 0, 1599),
(5701, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:41', 0, 1599),
(5702, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:41', 0, 1599),
(5703, 1, 88, 0, 2, 24, 19, '2015-01-25 21:12:41', 0, 1599),
(5704, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:41', 0, 1599),
(5705, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:41', 0, 1599),
(5706, 1, 84, 0, 1, 27, 49, '2015-01-25 21:12:41', 0, 1599),
(5707, 1, 89, 0, 0, 22, 29, '2015-01-25 21:12:41', 0, 1599),
(5708, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:42', 0, 1600),
(5709, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:42', 0, 1600),
(5710, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:42', 0, 1600),
(5711, 1, 87, 0, 5, 35, 23, '2015-01-25 21:12:42', 0, 1600),
(5712, 1, 86, 0, 3, 14, 6, '2015-01-25 21:12:42', 0, 1600),
(5713, 1, 88, 0, 2, 24, 19, '2015-01-25 21:12:42', 0, 1600),
(5714, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:42', 0, 1600),
(5715, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:42', 0, 1600),
(5716, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:42', 0, 1600),
(5717, 1, 84, 0, 1, 27, 49, '2015-01-25 21:12:42', 0, 1600),
(5718, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:42', 0, 1600),
(5719, 1, 89, 0, 0, 22, 29, '2015-01-25 21:12:42', 0, 1600),
(5720, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:42', 0, 1601),
(5721, 1, 87, 0, 5, 35, 23, '2015-01-25 21:12:42', 0, 1601),
(5722, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:42', 0, 1601),
(5723, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:42', 0, 1601),
(5724, 1, 86, 0, 3, 14, 6, '2015-01-25 21:12:42', 0, 1601),
(5725, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:42', 0, 1601),
(5726, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:42', 0, 1601),
(5727, 1, 88, 0, 2, 28, 30, '2015-01-25 21:12:42', 0, 1601),
(5728, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:42', 0, 1601),
(5729, 1, 84, 0, 1, 27, 49, '2015-01-25 21:12:42', 0, 1601),
(5730, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:42', 0, 1601),
(5731, 1, 89, 0, 0, 22, 29, '2015-01-25 21:12:42', 0, 1601),
(5732, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:42', 0, 1602),
(5733, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:43', 0, 1602),
(5734, 1, 87, 0, 5, 35, 23, '2015-01-25 21:12:43', 0, 1602),
(5735, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:43', 0, 1602),
(5736, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:43', 0, 1602),
(5737, 1, 88, 0, 2, 28, 30, '2015-01-25 21:12:43', 0, 1602),
(5738, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:43', 0, 1602),
(5739, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:43', 0, 1602),
(5740, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:43', 0, 1602),
(5741, 1, 84, 0, 1, 27, 49, '2015-01-25 21:12:43', 0, 1602),
(5742, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:43', 0, 1602),
(5743, 1, 89, 0, 0, 22, 29, '2015-01-25 21:12:43', 0, 1602),
(5744, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:43', 0, 1603),
(5745, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:43', 0, 1603),
(5746, 1, 87, 0, 5, 35, 23, '2015-01-25 21:12:43', 0, 1603),
(5747, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:43', 0, 1603),
(5748, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:43', 0, 1603),
(5749, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:43', 0, 1603),
(5750, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:43', 0, 1603),
(5751, 1, 88, 0, 2, 28, 30, '2015-01-25 21:12:43', 0, 1603),
(5752, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:43', 0, 1603),
(5753, 1, 84, 0, 1, 27, 49, '2015-01-25 21:12:43', 0, 1603),
(5754, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:43', 0, 1603),
(5755, 1, 89, 0, 2, 36, 36, '2015-01-25 21:12:43', 0, 1603),
(5756, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:43', 0, 1604),
(5757, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:43', 0, 1604),
(5758, 1, 87, 0, 5, 35, 23, '2015-01-25 21:12:43', 0, 1604),
(5759, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:44', 0, 1604),
(5760, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:44', 0, 1604),
(5761, 1, 88, 0, 2, 28, 30, '2015-01-25 21:12:44', 0, 1604),
(5762, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:44', 0, 1604),
(5763, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:44', 0, 1604),
(5764, 1, 89, 0, 2, 36, 36, '2015-01-25 21:12:44', 0, 1604),
(5765, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:44', 0, 1604),
(5766, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:44', 0, 1604),
(5767, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:44', 0, 1604),
(5768, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:44', 0, 1605),
(5769, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:44', 0, 1605),
(5770, 1, 87, 0, 6, 50, 38, '2015-01-25 21:12:44', 0, 1605),
(5771, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:44', 0, 1605),
(5772, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:44', 0, 1605),
(5773, 1, 89, 0, 3, 51, 51, '2015-01-25 21:12:44', 0, 1605),
(5774, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:44', 0, 1605),
(5775, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:44', 0, 1605),
(5776, 1, 88, 0, 2, 28, 30, '2015-01-25 21:12:44', 0, 1605),
(5777, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:44', 0, 1605),
(5778, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:44', 0, 1605),
(5779, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:44', 0, 1605),
(5780, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:44', 0, 1606),
(5781, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:44', 0, 1606),
(5782, 1, 87, 0, 6, 50, 38, '2015-01-25 21:12:44', 0, 1606),
(5783, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:44', 0, 1606),
(5784, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:44', 0, 1606),
(5785, 1, 89, 0, 3, 51, 51, '2015-01-25 21:12:45', 0, 1606),
(5786, 1, 88, 0, 4, 46, 43, '2015-01-25 21:12:45', 0, 1606),
(5787, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:45', 0, 1606),
(5788, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:45', 0, 1606),
(5789, 1, 80, 0, 1, 32, 58, '2015-01-25 21:12:45', 0, 1606),
(5790, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:45', 0, 1606),
(5791, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:45', 0, 1606),
(5792, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:45', 0, 1607),
(5793, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:45', 0, 1607),
(5794, 1, 87, 0, 6, 50, 38, '2015-01-25 21:12:45', 0, 1607),
(5795, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:45', 0, 1607),
(5796, 1, 88, 0, 4, 46, 43, '2015-01-25 21:12:45', 0, 1607),
(5797, 1, 83, 0, 4, 17, 33, '2015-01-25 21:12:45', 0, 1607),
(5798, 1, 89, 0, 3, 51, 51, '2015-01-25 21:12:45', 0, 1607),
(5799, 1, 79, 0, 4, 45, 44, '2015-01-25 21:12:45', 0, 1607),
(5800, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:45', 0, 1607),
(5801, 1, 80, 0, 1, 32, 58, '2015-01-25 21:12:45', 0, 1607),
(5802, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:45', 0, 1607),
(5803, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:45', 0, 1607),
(5804, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:45', 0, 1608),
(5805, 1, 81, 0, 8, 47, 16, '2015-01-25 21:12:45', 0, 1608),
(5806, 1, 87, 0, 6, 50, 38, '2015-01-25 21:12:45', 0, 1608),
(5807, 1, 86, 0, 5, 34, 21, '2015-01-25 21:12:45', 0, 1608),
(5808, 1, 88, 0, 4, 46, 43, '2015-01-25 21:12:45', 0, 1608),
(5809, 1, 83, 0, 4, 17, 33, '2015-01-25 21:12:45', 0, 1608),
(5810, 1, 79, 0, 4, 45, 44, '2015-01-25 21:12:46', 0, 1608),
(5811, 1, 89, 0, 3, 51, 51, '2015-01-25 21:12:46', 0, 1608),
(5812, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:46', 0, 1608),
(5813, 1, 80, 0, 1, 32, 58, '2015-01-25 21:12:46', 0, 1608),
(5814, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:46', 0, 1608),
(5815, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:46', 0, 1608),
(5816, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:46', 1, NULL),
(5817, 1, 81, 0, 8, 47, 16, '2015-01-25 21:12:46', 1, NULL),
(5818, 1, 87, 0, 6, 50, 38, '2015-01-25 21:12:46', 1, NULL),
(5819, 1, 86, 0, 5, 34, 21, '2015-01-25 21:12:46', 1, NULL),
(5820, 1, 79, 0, 4, 45, 44, '2015-01-25 21:12:46', 1, NULL),
(5821, 1, 83, 0, 4, 17, 33, '2015-01-25 21:12:46', 1, NULL),
(5822, 1, 88, 0, 4, 46, 43, '2015-01-25 21:12:46', 1, NULL),
(5823, 1, 89, 0, 3, 51, 51, '2015-01-25 21:12:46', 1, NULL),
(5824, 1, 85, 0, 4, 53, 61, '2015-01-25 21:12:46', 1, NULL),
(5825, 1, 80, 0, 1, 32, 58, '2015-01-25 21:12:46', 1, NULL),
(5826, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:46', 1, NULL),
(5827, 1, 82, 0, 0, 32, 50, '2015-01-25 21:12:46', 1, NULL);

--
-- Spouště `team`
--
DELIMITER //
CREATE TRIGGER `team_bi` BEFORE INSERT ON `team`
 FOR EACH ROW SET NEW.inserted = NOW()
//
DELIMITER ;

-- --------------------------------------------------------

--
-- Struktura tabulky `team_info`
--

CREATE TABLE IF NOT EXISTS `team_info` (
`id` int(11) NOT NULL,
  `category_id` int(11) NOT NULL,
  `name` char(30) COLLATE utf8_czech_ci NOT NULL,
  `slug` char(30) COLLATE utf8_czech_ci NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `team_info`
--

INSERT INTO `team_info` (`id`, `category_id`, `name`, `slug`) VALUES
(81, 1, 'DHK Zora Olomouc', 'dhk-zora-olomouc'),
(83, 1, 'Handball Val. Meziříčí', 'handball-val-mezirici'),
(87, 1, 'HBC Jičín', 'hbc-jicin'),
(77, 1, 'jiný test', 'jiny-test'),
(82, 1, 'Otrokovice', 'otrokovice'),
(79, 1, 'SK Žeravice A', 'sk-zeravice-a'),
(85, 1, 'SK Žeravice B', 'sk-zeravice-b'),
(86, 1, 'Sokol Prostějov', 'sokol-prostejov'),
(89, 1, 'STM Olomouc', 'stm-olomouc'),
(88, 1, 'ŠKP Bratislava', 'skp-bratislava'),
(78, 1, 'Tatran Litovel', 'tatran-litovel'),
(76, 1, 'Test', 'test'),
(84, 1, 'TJ JM Chodov', 'tj-jm-chodov'),
(80, 1, 'Velká Bystřice', 'velka-bystrice');

-- --------------------------------------------------------

--
-- Struktura tabulky `user`
--

CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL,
  `username` text COLLATE utf8_czech_ci NOT NULL,
  `password_hash` text COLLATE utf8_czech_ci NOT NULL,
  `role` text COLLATE utf8_czech_ci NOT NULL,
  `fullname` text COLLATE utf8_czech_ci NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `user`
--

INSERT INTO `user` (`id`, `username`, `password_hash`, `role`, `fullname`) VALUES
(1, 'joe', '$2y$10$HZGTs1GzZB70Bbpc2HLnFeyBYdaudLWW/gOd7CVEcpf8C4nURUVRi', 'admin', 'Joe Kolář');

-- --------------------------------------------------------

--
-- Struktura tabulky `year`
--

CREATE TABLE IF NOT EXISTS `year` (
`id` int(11) NOT NULL,
  `year` year(4) NOT NULL,
  `name` text COLLATE utf8_czech_ci,
  `actual` tinyint(1) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;

--
-- Vypisuji data pro tabulku `year`
--

INSERT INTO `year` (`id`, `year`, `name`, `actual`) VALUES
(1, 2015, NULL, 1);

--
-- Klíče pro exportované tabulky
--

--
-- Klíče pro tabulku `category`
--
ALTER TABLE `category`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`), ADD KEY `year_id` (`year_id`);

--
-- Klíče pro tabulku `day`
--
ALTER TABLE `day`
 ADD PRIMARY KEY (`id`), ADD KEY `year_id` (`year_id`);

--
-- Klíče pro tabulku `match`
--
ALTER TABLE `match`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id` (`id`), ADD KEY `AI_id` (`id`), ADD KEY `home_team_id` (`home_team_info_id`), ADD KEY `away_team_id` (`away_team_info_id`), ADD KEY `match_term_id` (`match_term_id`), ADD KEY `category_id` (`category_id`);

--
-- Klíče pro tabulku `match_term`
--
ALTER TABLE `match_term`
 ADD PRIMARY KEY (`id`), ADD KEY `day_id` (`day_id`);

--
-- Klíče pro tabulku `online_report`
--
ALTER TABLE `online_report`
 ADD PRIMARY KEY (`id`), ADD KEY `match_id` (`match_id`), ADD KEY `author` (`author`);

--
-- Klíče pro tabulku `photo`
--
ALTER TABLE `photo`
 ADD PRIMARY KEY (`id`), ADD KEY `author_id` (`author_id`);

--
-- Klíče pro tabulku `photo_tag`
--
ALTER TABLE `photo_tag`
 ADD PRIMARY KEY (`photo_id`,`tag_id`), ADD KEY `tag_id` (`tag_id`);

--
-- Klíče pro tabulku `static_content`
--
ALTER TABLE `static_content`
 ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`);

--
-- Klíče pro tabulku `tag`
--
ALTER TABLE `tag`
 ADD PRIMARY KEY (`id`), ADD KEY `main_photo_id` (`main_photo_id`);

--
-- Klíče pro tabulku `team`
--
ALTER TABLE `team`
 ADD PRIMARY KEY (`id`), ADD KEY `category_id` (`category_id`), ADD KEY `team_info_id` (`team_info_id`), ADD KEY `after_match_id` (`after_match_id`);

--
-- Klíče pro tabulku `team_info`
--
ALTER TABLE `team_info`
 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `category_id_name_slug` (`category_id`,`name`,`slug`);

--
-- Klíče pro tabulku `user`
--
ALTER TABLE `user`
 ADD PRIMARY KEY (`id`);

--
-- Klíče pro tabulku `year`
--
ALTER TABLE `year`
 ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pro tabulky
--

--
-- AUTO_INCREMENT pro tabulku `category`
--
ALTER TABLE `category`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT pro tabulku `day`
--
ALTER TABLE `day`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=80;
--
-- AUTO_INCREMENT pro tabulku `match`
--
ALTER TABLE `match`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1609;
--
-- AUTO_INCREMENT pro tabulku `match_term`
--
ALTER TABLE `match_term`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1058;
--
-- AUTO_INCREMENT pro tabulku `online_report`
--
ALTER TABLE `online_report`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT pro tabulku `photo`
--
ALTER TABLE `photo`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pro tabulku `static_content`
--
ALTER TABLE `static_content`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pro tabulku `tag`
--
ALTER TABLE `tag`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pro tabulku `team`
--
ALTER TABLE `team`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5828;
--
-- AUTO_INCREMENT pro tabulku `team_info`
--
ALTER TABLE `team_info`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=90;
--
-- AUTO_INCREMENT pro tabulku `user`
--
ALTER TABLE `user`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT pro tabulku `year`
--
ALTER TABLE `year`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- Omezení pro exportované tabulky
--

--
-- Omezení pro tabulku `category`
--
ALTER TABLE `category`
ADD CONSTRAINT `category_ibfk_1` FOREIGN KEY (`year_id`) REFERENCES `year` (`id`);

--
-- Omezení pro tabulku `day`
--
ALTER TABLE `day`
ADD CONSTRAINT `day_ibfk_1` FOREIGN KEY (`year_id`) REFERENCES `year` (`id`);

--
-- Omezení pro tabulku `match`
--
ALTER TABLE `match`
ADD CONSTRAINT `match_ibfk_1` FOREIGN KEY (`match_term_id`) REFERENCES `match_term` (`id`),
ADD CONSTRAINT `match_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
ADD CONSTRAINT `match_ibfk_5` FOREIGN KEY (`home_team_info_id`) REFERENCES `team_info` (`id`),
ADD CONSTRAINT `match_ibfk_6` FOREIGN KEY (`away_team_info_id`) REFERENCES `team_info` (`id`);

--
-- Omezení pro tabulku `match_term`
--
ALTER TABLE `match_term`
ADD CONSTRAINT `day_id` FOREIGN KEY (`day_id`) REFERENCES `day` (`id`);

--
-- Omezení pro tabulku `online_report`
--
ALTER TABLE `online_report`
ADD CONSTRAINT `online_report_ibfk_1` FOREIGN KEY (`match_id`) REFERENCES `match` (`id`),
ADD CONSTRAINT `online_report_ibfk_3` FOREIGN KEY (`author`) REFERENCES `user` (`id`);

--
-- Omezení pro tabulku `photo`
--
ALTER TABLE `photo`
ADD CONSTRAINT `photo_ibfk_1` FOREIGN KEY (`author_id`) REFERENCES `user` (`id`);

--
-- Omezení pro tabulku `photo_tag`
--
ALTER TABLE `photo_tag`
ADD CONSTRAINT `photo_tag_ibfk_1` FOREIGN KEY (`photo_id`) REFERENCES `photo` (`id`),
ADD CONSTRAINT `photo_tag_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`);

--
-- Omezení pro tabulku `static_content`
--
ALTER TABLE `static_content`
ADD CONSTRAINT `static_content_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

--
-- Omezení pro tabulku `tag`
--
ALTER TABLE `tag`
ADD CONSTRAINT `tag_ibfk_1` FOREIGN KEY (`main_photo_id`) REFERENCES `photo` (`id`);

--
-- Omezení pro tabulku `team`
--
ALTER TABLE `team`
ADD CONSTRAINT `team_ibfk_1` FOREIGN KEY (`team_info_id`) REFERENCES `team_info` (`id`),
ADD CONSTRAINT `team_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
ADD CONSTRAINT `team_ibfk_6` FOREIGN KEY (`after_match_id`) REFERENCES `match` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;

--
-- Omezení pro tabulku `team_info`
--
ALTER TABLE `team_info`
ADD CONSTRAINT `team_info_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;