Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement