API tools faq
paste
Advertisement
JoeE

M15 - sb aftech 24 matches

JoeE
Jan 25th, 2015
467
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 51.88 KB | None | 0 0
raw download clone embed print report
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.2.11
  3. -- http://www.phpmyadmin.net
  4. --
  5. -- Počítač: localhost
  6. -- Vytvořeno: Ned 25. led 2015, 21:13
  7. -- Verze serveru: 5.5.41-0ubuntu0.14.10.1
  8. -- Verze PHP: 5.5.12-2ubuntu4.1
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET time_zone = "+00:00";
  12.  
  13.  
  14. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17. /*!40101 SET NAMES utf8 */;
  18.  
  19. --
  20. -- Databáze: `minicup-2015`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Struktura tabulky `category`
  27. --
  28.  
  29. CREATE TABLE IF NOT EXISTS `category` (
  30. `id` INT(11) NOT NULL,
  31.   `year_id` INT(11) DEFAULT NULL,
  32.   `name` CHAR(30) COLLATE utf8_czech_ci NOT NULL,
  33.   `slug` CHAR(30) COLLATE utf8_czech_ci NOT NULL,
  34.   `default` INT(11) NOT NULL DEFAULT '0'
  35. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  36.  
  37. --
  38. -- Vypisuji data pro tabulku `category`
  39. --
  40.  
  41. INSERT INTO `category` (`id`, `year_id`, `name`, `slug`, `default`) VALUES
  42. (1, 1, 'mladší', 'mladsi', 1),
  43. (2, 1, 'starší', 'starsi', 0);
  44.  
  45. -- --------------------------------------------------------
  46.  
  47. --
  48. -- Struktura tabulky `day`
  49. --
  50.  
  51. CREATE TABLE IF NOT EXISTS `day` (
  52. `id` INT(11) NOT NULL,
  53.   `day` DATE NOT NULL,
  54.   `year_id` INT(11) NOT NULL
  55. ) ENGINE=InnoDB AUTO_INCREMENT=80 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  56.  
  57. --
  58. -- Vypisuji data pro tabulku `day`
  59. --
  60.  
  61. INSERT INTO `day` (`id`, `day`, `year_id`) VALUES
  62. (77, '2015-05-23', 1),
  63. (78, '2015-05-24', 1),
  64. (79, '2015-05-25', 1);
  65.  
  66. -- --------------------------------------------------------
  67.  
  68. --
  69. -- Struktura tabulky `match`
  70. --
  71.  
  72. CREATE TABLE IF NOT EXISTS `match` (
  73. `id` INT(11) NOT NULL,
  74.   `match_term_id` INT(11) DEFAULT NULL,
  75.   `category_id` INT(11) NOT NULL,
  76.   `home_team_info_id` INT(11) NOT NULL,
  77.   `away_team_info_id` INT(11) NOT NULL,
  78.   `score_home` INT(11) DEFAULT NULL,
  79.   `score_away` INT(11) DEFAULT NULL,
  80.   `confirmed` INT(11) NOT NULL DEFAULT '0'
  81. ) ENGINE=InnoDB AUTO_INCREMENT=1609 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  82.  
  83. --
  84. -- Vypisuji data pro tabulku `match`
  85. --
  86.  
  87. INSERT INTO `match` (`id`, `match_term_id`, `category_id`, `home_team_info_id`, `away_team_info_id`, `score_home`, `score_away`, `confirmed`) VALUES
  88. (1585, 1034, 1, 78, 79, 14, 6, 1),
  89. (1586, 1035, 1, 80, 81, 3, 8, 1),
  90. (1587, 1036, 1, 82, 83, 6, 7, 1),
  91. (1588, 1037, 1, 84, 85, 12, 16, 1),
  92. (1589, 1038, 1, 86, 87, 6, 6, 1),
  93. (1590, 1039, 1, 88, 83, 2, 4, 1),
  94. (1591, 1040, 1, 80, 78, 6, 22, 1),
  95. (1592, 1041, 1, 89, 79, 12, 13, 1),
  96. (1593, 1042, 1, 87, 82, 17, 8, 1),
  97. (1594, 1043, 1, 81, 84, 23, 5, 1),
  98. (1595, 1044, 1, 85, 88, 15, 22, 1),
  99. (1596, 1045, 1, 83, 86, 0, 8, 1),
  100. (1597, 1046, 1, 78, 89, 16, 10, 1),
  101. (1598, 1047, 1, 84, 80, 10, 10, 1),
  102. (1599, 1048, 1, 79, 87, 9, 12, 1),
  103. (1600, 1049, 1, 88, 81, 4, 11, 1),
  104. (1601, 1050, 1, 86, 85, 16, 10, 1),
  105. (1602, 1051, 1, 82, 89, 7, 14, 1),
  106. (1603, 1052, 1, 84, 78, 6, 23, 1),
  107. (1604, 1053, 1, 87, 89, 15, 15, 1),
  108. (1605, 1054, 1, 80, 88, 13, 18, 1),
  109. (1606, 1055, 1, 83, 79, 6, 17, 1),
  110. (1607, 1056, 1, 81, 86, 5, 4, 1),
  111. (1608, 1057, 1, 85, 82, 12, 11, 1);
  112.  
  113. -- --------------------------------------------------------
  114.  
  115. --
  116. -- Struktura tabulky `match_term`
  117. --
  118.  
  119. CREATE TABLE IF NOT EXISTS `match_term` (
  120. `id` INT(11) NOT NULL,
  121.   `start` TIME NOT NULL,
  122.   `end` TIME NOT NULL,
  123.   `day_id` INT(11) NOT NULL,
  124.   `location` VARCHAR(50) COLLATE utf8_czech_ci NOT NULL
  125. ) ENGINE=InnoDB AUTO_INCREMENT=1058 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  126.  
  127. --
  128. -- Vypisuji data pro tabulku `match_term`
  129. --
  130.  
  131. INSERT INTO `match_term` (`id`, `start`, `end`, `day_id`, `location`) VALUES
  132. (554, '13:00:00', '13:30:00', 77, ''),
  133. (555, '13:30:00', '14:00:00', 77, ''),
  134. (556, '14:00:00', '14:30:00', 77, ''),
  135. (557, '14:30:00', '15:00:00', 77, ''),
  136. (558, '15:00:00', '15:30:00', 77, ''),
  137. (559, '15:30:00', '16:00:00', 77, ''),
  138. (560, '16:00:00', '16:30:00', 77, ''),
  139. (561, '16:30:00', '17:00:00', 77, ''),
  140. (562, '17:00:00', '17:30:00', 77, ''),
  141. (563, '09:00:00', '09:30:00', 78, ''),
  142. (564, '09:30:00', '10:00:00', 78, ''),
  143. (565, '10:00:00', '10:30:00', 78, ''),
  144. (566, '10:30:00', '11:00:00', 78, ''),
  145. (567, '11:00:00', '11:30:00', 78, ''),
  146. (568, '11:30:00', '12:00:00', 78, ''),
  147. (569, '12:00:00', '12:30:00', 78, ''),
  148. (570, '12:30:00', '13:00:00', 78, ''),
  149. (571, '13:00:00', '13:30:00', 78, ''),
  150. (572, '13:30:00', '14:00:00', 78, ''),
  151. (573, '14:00:00', '14:30:00', 78, ''),
  152. (574, '14:30:00', '15:00:00', 78, ''),
  153. (575, '15:00:00', '15:30:00', 78, ''),
  154. (576, '09:00:00', '09:30:00', 79, ''),
  155. (577, '09:30:00', '10:00:00', 79, ''),
  156. (578, '10:00:00', '10:30:00', 79, ''),
  157. (579, '10:30:00', '11:00:00', 79, ''),
  158. (580, '11:00:00', '11:30:00', 79, ''),
  159. (581, '11:30:00', '12:00:00', 79, ''),
  160. (582, '12:00:00', '12:30:00', 79, ''),
  161. (583, '12:30:00', '13:00:00', 79, ''),
  162. (584, '13:00:00', '13:30:00', 79, ''),
  163. (585, '13:30:00', '14:00:00', 79, ''),
  164. (586, '14:00:00', '14:30:00', 79, ''),
  165. (587, '13:00:00', '13:30:00', 77, ''),
  166. (588, '13:00:00', '13:30:00', 77, ''),
  167. (589, '13:00:00', '13:30:00', 77, ''),
  168. (590, '13:00:00', '13:30:00', 77, ''),
  169. (591, '13:00:00', '13:30:00', 77, ''),
  170. (592, '13:30:00', '14:00:00', 77, ''),
  171. (593, '13:30:00', '14:00:00', 77, ''),
  172. (594, '14:00:00', '14:30:00', 77, ''),
  173. (595, '14:00:00', '14:30:00', 77, ''),
  174. (596, '14:30:00', '15:00:00', 77, ''),
  175. (597, '14:30:00', '15:00:00', 77, ''),
  176. (598, '15:00:00', '15:30:00', 77, ''),
  177. (599, '15:00:00', '15:30:00', 77, ''),
  178. (600, '15:30:00', '16:00:00', 77, ''),
  179. (601, '15:30:00', '16:00:00', 77, ''),
  180. (602, '16:00:00', '16:30:00', 77, ''),
  181. (603, '16:00:00', '16:30:00', 77, ''),
  182. (604, '16:30:00', '17:00:00', 77, ''),
  183. (605, '16:30:00', '17:00:00', 77, ''),
  184. (606, '17:00:00', '17:30:00', 77, ''),
  185. (607, '17:00:00', '17:30:00', 77, ''),
  186. (608, '09:00:00', '09:30:00', 78, ''),
  187. (609, '09:00:00', '09:30:00', 78, ''),
  188. (610, '09:30:00', '10:00:00', 78, ''),
  189. (611, '09:30:00', '10:00:00', 78, ''),
  190. (612, '10:00:00', '10:30:00', 78, ''),
  191. (613, '10:00:00', '10:30:00', 78, ''),
  192. (614, '13:00:00', '13:30:00', 77, ''),
  193. (615, '13:00:00', '13:30:00', 77, ''),
  194. (616, '13:30:00', '14:00:00', 77, ''),
  195. (617, '13:30:00', '14:00:00', 77, ''),
  196. (618, '14:00:00', '14:30:00', 77, ''),
  197. (619, '14:00:00', '14:30:00', 77, ''),
  198. (620, '14:30:00', '15:00:00', 77, ''),
  199. (621, '14:30:00', '15:00:00', 77, ''),
  200. (622, '15:00:00', '15:30:00', 77, ''),
  201. (623, '15:00:00', '15:30:00', 77, ''),
  202. (624, '15:30:00', '16:00:00', 77, ''),
  203. (625, '15:30:00', '16:00:00', 77, ''),
  204. (626, '16:00:00', '16:30:00', 77, ''),
  205. (627, '16:00:00', '16:30:00', 77, ''),
  206. (628, '16:30:00', '17:00:00', 77, ''),
  207. (629, '16:30:00', '17:00:00', 77, ''),
  208. (630, '17:00:00', '17:30:00', 77, ''),
  209. (631, '17:00:00', '17:30:00', 77, ''),
  210. (632, '09:00:00', '09:30:00', 78, ''),
  211. (633, '09:00:00', '09:30:00', 78, ''),
  212. (634, '09:30:00', '10:00:00', 78, ''),
  213. (635, '09:30:00', '10:00:00', 78, ''),
  214. (636, '10:00:00', '10:30:00', 78, ''),
  215. (637, '10:00:00', '10:30:00', 78, ''),
  216. (638, '10:30:00', '11:00:00', 78, ''),
  217. (639, '10:30:00', '11:00:00', 78, ''),
  218. (640, '11:00:00', '11:30:00', 78, ''),
  219. (641, '11:00:00', '11:30:00', 78, ''),
  220. (642, '11:30:00', '12:00:00', 78, ''),
  221. (643, '11:30:00', '12:00:00', 78, ''),
  222. (644, '12:00:00', '12:30:00', 78, ''),
  223. (645, '12:00:00', '12:30:00', 78, ''),
  224. (646, '12:30:00', '13:00:00', 78, ''),
  225. (647, '12:30:00', '13:00:00', 78, ''),
  226. (648, '13:00:00', '13:30:00', 78, ''),
  227. (649, '13:00:00', '13:30:00', 78, ''),
  228. (650, '13:30:00', '14:00:00', 78, ''),
  229. (651, '13:30:00', '14:00:00', 78, ''),
  230. (652, '14:00:00', '14:30:00', 78, ''),
  231. (653, '14:00:00', '14:30:00', 78, ''),
  232. (654, '14:30:00', '15:00:00', 78, ''),
  233. (655, '14:30:00', '15:00:00', 78, ''),
  234. (656, '15:00:00', '15:30:00', 78, ''),
  235. (657, '15:00:00', '15:30:00', 78, ''),
  236. (658, '09:00:00', '09:30:00', 79, ''),
  237. (659, '09:00:00', '09:30:00', 79, ''),
  238. (660, '09:30:00', '10:00:00', 79, ''),
  239. (661, '09:30:00', '10:00:00', 79, ''),
  240. (662, '10:00:00', '10:30:00', 79, ''),
  241. (663, '10:00:00', '10:30:00', 79, ''),
  242. (664, '10:30:00', '11:00:00', 79, ''),
  243. (665, '10:30:00', '11:00:00', 79, ''),
  244. (666, '11:00:00', '11:30:00', 79, ''),
  245. (667, '11:00:00', '11:30:00', 79, ''),
  246. (668, '11:30:00', '12:00:00', 79, ''),
  247. (669, '11:30:00', '12:00:00', 79, ''),
  248. (670, '12:00:00', '12:30:00', 79, ''),
  249. (671, '12:00:00', '12:30:00', 79, ''),
  250. (672, '12:30:00', '13:00:00', 79, ''),
  251. (673, '12:30:00', '13:00:00', 79, ''),
  252. (674, '13:00:00', '13:30:00', 79, ''),
  253. (675, '13:00:00', '13:30:00', 79, ''),
  254. (676, '13:30:00', '14:00:00', 79, ''),
  255. (677, '13:30:00', '14:00:00', 79, ''),
  256. (678, '14:00:00', '14:30:00', 79, ''),
  257. (679, '14:00:00', '14:30:00', 79, ''),
  258. (680, '13:00:00', '13:30:00', 77, ''),
  259. (681, '13:00:00', '13:30:00', 77, ''),
  260. (682, '13:30:00', '14:00:00', 77, ''),
  261. (683, '13:30:00', '14:00:00', 77, ''),
  262. (684, '14:00:00', '14:30:00', 77, ''),
  263. (685, '14:00:00', '14:30:00', 77, ''),
  264. (686, '14:30:00', '15:00:00', 77, ''),
  265. (687, '14:30:00', '15:00:00', 77, ''),
  266. (688, '15:00:00', '15:30:00', 77, ''),
  267. (689, '15:00:00', '15:30:00', 77, ''),
  268. (690, '15:30:00', '16:00:00', 77, ''),
  269. (691, '15:30:00', '16:00:00', 77, ''),
  270. (692, '16:00:00', '16:30:00', 77, ''),
  271. (693, '16:00:00', '16:30:00', 77, ''),
  272. (694, '16:30:00', '17:00:00', 77, ''),
  273. (695, '16:30:00', '17:00:00', 77, ''),
  274. (696, '17:00:00', '17:30:00', 77, ''),
  275. (697, '17:00:00', '17:30:00', 77, ''),
  276. (698, '09:00:00', '09:30:00', 78, ''),
  277. (699, '09:00:00', '09:30:00', 78, ''),
  278. (700, '09:30:00', '10:00:00', 78, ''),
  279. (701, '09:30:00', '10:00:00', 78, ''),
  280. (702, '10:00:00', '10:30:00', 78, ''),
  281. (703, '10:00:00', '10:30:00', 78, ''),
  282. (704, '10:30:00', '11:00:00', 78, ''),
  283. (705, '10:30:00', '11:00:00', 78, ''),
  284. (706, '11:00:00', '11:30:00', 78, ''),
  285. (707, '11:00:00', '11:30:00', 78, ''),
  286. (708, '11:30:00', '12:00:00', 78, ''),
  287. (709, '11:30:00', '12:00:00', 78, ''),
  288. (710, '12:00:00', '12:30:00', 78, ''),
  289. (711, '12:00:00', '12:30:00', 78, ''),
  290. (712, '12:30:00', '13:00:00', 78, ''),
  291. (713, '12:30:00', '13:00:00', 78, ''),
  292. (714, '13:00:00', '13:30:00', 78, ''),
  293. (715, '13:00:00', '13:30:00', 78, ''),
  294. (716, '13:30:00', '14:00:00', 78, ''),
  295. (717, '13:30:00', '14:00:00', 78, ''),
  296. (718, '14:00:00', '14:30:00', 78, ''),
  297. (719, '14:00:00', '14:30:00', 78, ''),
  298. (720, '14:30:00', '15:00:00', 78, ''),
  299. (721, '14:30:00', '15:00:00', 78, ''),
  300. (722, '15:00:00', '15:30:00', 78, ''),
  301. (723, '15:00:00', '15:30:00', 78, ''),
  302. (724, '09:00:00', '09:30:00', 79, ''),
  303. (725, '09:00:00', '09:30:00', 79, ''),
  304. (726, '09:30:00', '10:00:00', 79, ''),
  305. (727, '09:30:00', '10:00:00', 79, ''),
  306. (728, '10:00:00', '10:30:00', 79, ''),
  307. (729, '10:00:00', '10:30:00', 79, ''),
  308. (730, '10:30:00', '11:00:00', 79, ''),
  309. (731, '10:30:00', '11:00:00', 79, ''),
  310. (732, '11:00:00', '11:30:00', 79, ''),
  311. (733, '11:00:00', '11:30:00', 79, ''),
  312. (734, '11:30:00', '12:00:00', 79, ''),
  313. (735, '11:30:00', '12:00:00', 79, ''),
  314. (736, '12:00:00', '12:30:00', 79, ''),
  315. (737, '12:00:00', '12:30:00', 79, ''),
  316. (738, '12:30:00', '13:00:00', 79, ''),
  317. (739, '12:30:00', '13:00:00', 79, ''),
  318. (740, '13:00:00', '13:30:00', 79, ''),
  319. (741, '13:00:00', '13:30:00', 79, ''),
  320. (742, '13:30:00', '14:00:00', 79, ''),
  321. (743, '13:30:00', '14:00:00', 79, ''),
  322. (744, '14:00:00', '14:30:00', 79, ''),
  323. (745, '14:00:00', '14:30:00', 79, ''),
  324. (746, '13:00:00', '13:30:00', 77, ''),
  325. (747, '13:00:00', '13:30:00', 77, ''),
  326. (748, '13:30:00', '14:00:00', 77, ''),
  327. (749, '13:30:00', '14:00:00', 77, ''),
  328. (750, '14:00:00', '14:30:00', 77, ''),
  329. (751, '14:00:00', '14:30:00', 77, ''),
  330. (752, '14:30:00', '15:00:00', 77, ''),
  331. (753, '14:30:00', '15:00:00', 77, ''),
  332. (754, '15:00:00', '15:30:00', 77, ''),
  333. (755, '15:00:00', '15:30:00', 77, ''),
  334. (756, '15:30:00', '16:00:00', 77, ''),
  335. (757, '15:30:00', '16:00:00', 77, ''),
  336. (758, '16:00:00', '16:30:00', 77, ''),
  337. (759, '16:00:00', '16:30:00', 77, ''),
  338. (760, '16:30:00', '17:00:00', 77, ''),
  339. (761, '16:30:00', '17:00:00', 77, ''),
  340. (762, '17:00:00', '17:30:00', 77, ''),
  341. (763, '17:00:00', '17:30:00', 77, ''),
  342. (764, '09:00:00', '09:30:00', 78, ''),
  343. (765, '09:00:00', '09:30:00', 78, ''),
  344. (766, '09:30:00', '10:00:00', 78, ''),
  345. (767, '09:30:00', '10:00:00', 78, ''),
  346. (768, '10:00:00', '10:30:00', 78, ''),
  347. (769, '10:00:00', '10:30:00', 78, ''),
  348. (770, '10:30:00', '11:00:00', 78, ''),
  349. (771, '10:30:00', '11:00:00', 78, ''),
  350. (772, '11:00:00', '11:30:00', 78, ''),
  351. (773, '11:00:00', '11:30:00', 78, ''),
  352. (774, '11:30:00', '12:00:00', 78, ''),
  353. (775, '11:30:00', '12:00:00', 78, ''),
  354. (776, '12:00:00', '12:30:00', 78, ''),
  355. (777, '12:00:00', '12:30:00', 78, ''),
  356. (778, '12:30:00', '13:00:00', 78, ''),
  357. (779, '12:30:00', '13:00:00', 78, ''),
  358. (780, '13:00:00', '13:30:00', 78, ''),
  359. (781, '13:00:00', '13:30:00', 78, ''),
  360. (782, '13:30:00', '14:00:00', 78, ''),
  361. (783, '13:30:00', '14:00:00', 78, ''),
  362. (784, '14:00:00', '14:30:00', 78, ''),
  363. (785, '14:00:00', '14:30:00', 78, ''),
  364. (786, '14:30:00', '15:00:00', 78, ''),
  365. (787, '14:30:00', '15:00:00', 78, ''),
  366. (788, '15:00:00', '15:30:00', 78, ''),
  367. (789, '15:00:00', '15:30:00', 78, ''),
  368. (790, '09:00:00', '09:30:00', 79, ''),
  369. (791, '09:00:00', '09:30:00', 79, ''),
  370. (792, '09:30:00', '10:00:00', 79, ''),
  371. (793, '09:30:00', '10:00:00', 79, ''),
  372. (794, '10:00:00', '10:30:00', 79, ''),
  373. (795, '10:00:00', '10:30:00', 79, ''),
  374. (796, '10:30:00', '11:00:00', 79, ''),
  375. (797, '10:30:00', '11:00:00', 79, ''),
  376. (798, '11:00:00', '11:30:00', 79, ''),
  377. (799, '11:00:00', '11:30:00', 79, ''),
  378. (800, '11:30:00', '12:00:00', 79, ''),
  379. (801, '11:30:00', '12:00:00', 79, ''),
  380. (802, '12:00:00', '12:30:00', 79, ''),
  381. (803, '12:00:00', '12:30:00', 79, ''),
  382. (804, '12:30:00', '13:00:00', 79, ''),
  383. (805, '12:30:00', '13:00:00', 79, ''),
  384. (806, '13:00:00', '13:30:00', 79, ''),
  385. (807, '13:00:00', '13:30:00', 79, ''),
  386. (808, '13:30:00', '14:00:00', 79, ''),
  387. (809, '13:30:00', '14:00:00', 79, ''),
  388. (810, '14:00:00', '14:30:00', 79, ''),
  389. (811, '14:00:00', '14:30:00', 79, ''),
  390. (812, '13:00:00', '13:30:00', 77, ''),
  391. (813, '13:00:00', '13:30:00', 77, ''),
  392. (814, '13:30:00', '14:00:00', 77, ''),
  393. (815, '13:30:00', '14:00:00', 77, ''),
  394. (816, '14:00:00', '14:30:00', 77, ''),
  395. (817, '14:00:00', '14:30:00', 77, ''),
  396. (818, '14:30:00', '15:00:00', 77, ''),
  397. (819, '14:30:00', '15:00:00', 77, ''),
  398. (820, '15:00:00', '15:30:00', 77, ''),
  399. (821, '15:00:00', '15:30:00', 77, ''),
  400. (822, '15:30:00', '16:00:00', 77, ''),
  401. (823, '15:30:00', '16:00:00', 77, ''),
  402. (824, '16:00:00', '16:30:00', 77, ''),
  403. (825, '16:00:00', '16:30:00', 77, ''),
  404. (826, '16:30:00', '17:00:00', 77, ''),
  405. (827, '16:30:00', '17:00:00', 77, ''),
  406. (828, '17:00:00', '17:30:00', 77, ''),
  407. (829, '17:00:00', '17:30:00', 77, ''),
  408. (830, '09:00:00', '09:30:00', 78, ''),
  409. (831, '09:00:00', '09:30:00', 78, ''),
  410. (832, '09:30:00', '10:00:00', 78, ''),
  411. (833, '09:30:00', '10:00:00', 78, ''),
  412. (834, '10:00:00', '10:30:00', 78, ''),
  413. (835, '10:00:00', '10:30:00', 78, ''),
  414. (836, '10:30:00', '11:00:00', 78, ''),
  415. (837, '10:30:00', '11:00:00', 78, ''),
  416. (838, '11:00:00', '11:30:00', 78, ''),
  417. (839, '11:00:00', '11:30:00', 78, ''),
  418. (840, '11:30:00', '12:00:00', 78, ''),
  419. (841, '11:30:00', '12:00:00', 78, ''),
  420. (842, '12:00:00', '12:30:00', 78, ''),
  421. (843, '12:00:00', '12:30:00', 78, ''),
  422. (844, '12:30:00', '13:00:00', 78, ''),
  423. (845, '12:30:00', '13:00:00', 78, ''),
  424. (846, '13:00:00', '13:30:00', 78, ''),
  425. (847, '13:00:00', '13:30:00', 78, ''),
  426. (848, '13:30:00', '14:00:00', 78, ''),
  427. (849, '13:30:00', '14:00:00', 78, ''),
  428. (850, '14:00:00', '14:30:00', 78, ''),
  429. (851, '14:00:00', '14:30:00', 78, ''),
  430. (852, '14:30:00', '15:00:00', 78, ''),
  431. (853, '14:30:00', '15:00:00', 78, ''),
  432. (854, '15:00:00', '15:30:00', 78, ''),
  433. (855, '15:00:00', '15:30:00', 78, ''),
  434. (856, '09:00:00', '09:30:00', 79, ''),
  435. (857, '09:00:00', '09:30:00', 79, ''),
  436. (858, '09:30:00', '10:00:00', 79, ''),
  437. (859, '09:30:00', '10:00:00', 79, ''),
  438. (860, '10:00:00', '10:30:00', 79, ''),
  439. (861, '10:00:00', '10:30:00', 79, ''),
  440. (862, '10:30:00', '11:00:00', 79, ''),
  441. (863, '10:30:00', '11:00:00', 79, ''),
  442. (864, '11:00:00', '11:30:00', 79, ''),
  443. (865, '11:00:00', '11:30:00', 79, ''),
  444. (866, '11:30:00', '12:00:00', 79, ''),
  445. (867, '11:30:00', '12:00:00', 79, ''),
  446. (868, '12:00:00', '12:30:00', 79, ''),
  447. (869, '12:00:00', '12:30:00', 79, ''),
  448. (870, '12:30:00', '13:00:00', 79, ''),
  449. (871, '12:30:00', '13:00:00', 79, ''),
  450. (872, '13:00:00', '13:30:00', 79, ''),
  451. (873, '13:00:00', '13:30:00', 79, ''),
  452. (874, '13:30:00', '14:00:00', 79, ''),
  453. (875, '13:30:00', '14:00:00', 79, ''),
  454. (876, '14:00:00', '14:30:00', 79, ''),
  455. (877, '14:00:00', '14:30:00', 79, ''),
  456. (878, '13:00:00', '13:30:00', 77, ''),
  457. (879, '13:00:00', '13:30:00', 77, ''),
  458. (880, '13:30:00', '14:00:00', 77, ''),
  459. (881, '13:30:00', '14:00:00', 77, ''),
  460. (882, '14:00:00', '14:30:00', 77, ''),
  461. (883, '14:00:00', '14:30:00', 77, ''),
  462. (884, '14:30:00', '15:00:00', 77, ''),
  463. (885, '14:30:00', '15:00:00', 77, ''),
  464. (886, '15:00:00', '15:30:00', 77, ''),
  465. (887, '15:00:00', '15:30:00', 77, ''),
  466. (888, '15:30:00', '16:00:00', 77, ''),
  467. (889, '15:30:00', '16:00:00', 77, ''),
  468. (890, '16:00:00', '16:30:00', 77, ''),
  469. (891, '16:00:00', '16:30:00', 77, ''),
  470. (892, '16:30:00', '17:00:00', 77, ''),
  471. (893, '16:30:00', '17:00:00', 77, ''),
  472. (894, '17:00:00', '17:30:00', 77, ''),
  473. (895, '17:00:00', '17:30:00', 77, ''),
  474. (896, '09:00:00', '09:30:00', 78, ''),
  475. (897, '09:00:00', '09:30:00', 78, ''),
  476. (898, '09:30:00', '10:00:00', 78, ''),
  477. (899, '09:30:00', '10:00:00', 78, ''),
  478. (900, '10:00:00', '10:30:00', 78, ''),
  479. (901, '10:00:00', '10:30:00', 78, ''),
  480. (902, '10:30:00', '11:00:00', 78, ''),
  481. (903, '10:30:00', '11:00:00', 78, ''),
  482. (904, '11:00:00', '11:30:00', 78, ''),
  483. (905, '11:00:00', '11:30:00', 78, ''),
  484. (906, '11:30:00', '12:00:00', 78, ''),
  485. (907, '11:30:00', '12:00:00', 78, ''),
  486. (908, '12:00:00', '12:30:00', 78, ''),
  487. (909, '12:00:00', '12:30:00', 78, ''),
  488. (910, '12:30:00', '13:00:00', 78, ''),
  489. (911, '12:30:00', '13:00:00', 78, ''),
  490. (912, '13:00:00', '13:30:00', 78, ''),
  491. (913, '13:00:00', '13:30:00', 78, ''),
  492. (914, '13:30:00', '14:00:00', 78, ''),
  493. (915, '13:30:00', '14:00:00', 78, ''),
  494. (916, '14:00:00', '14:30:00', 78, ''),
  495. (917, '14:00:00', '14:30:00', 78, ''),
  496. (918, '14:30:00', '15:00:00', 78, ''),
  497. (919, '14:30:00', '15:00:00', 78, ''),
  498. (920, '15:00:00', '15:30:00', 78, ''),
  499. (921, '15:00:00', '15:30:00', 78, ''),
  500. (922, '09:00:00', '09:30:00', 79, ''),
  501. (923, '09:00:00', '09:30:00', 79, ''),
  502. (924, '09:30:00', '10:00:00', 79, ''),
  503. (925, '09:30:00', '10:00:00', 79, ''),
  504. (926, '10:00:00', '10:30:00', 79, ''),
  505. (927, '10:00:00', '10:30:00', 79, ''),
  506. (928, '10:30:00', '11:00:00', 79, ''),
  507. (929, '10:30:00', '11:00:00', 79, ''),
  508. (930, '11:00:00', '11:30:00', 79, ''),
  509. (931, '11:00:00', '11:30:00', 79, ''),
  510. (932, '11:30:00', '12:00:00', 79, ''),
  511. (933, '11:30:00', '12:00:00', 79, ''),
  512. (934, '12:00:00', '12:30:00', 79, ''),
  513. (935, '12:00:00', '12:30:00', 79, ''),
  514. (936, '12:30:00', '13:00:00', 79, ''),
  515. (937, '12:30:00', '13:00:00', 79, ''),
  516. (938, '13:00:00', '13:30:00', 79, ''),
  517. (939, '13:00:00', '13:30:00', 79, ''),
  518. (940, '13:30:00', '14:00:00', 79, ''),
  519. (941, '13:30:00', '14:00:00', 79, ''),
  520. (942, '14:00:00', '14:30:00', 79, ''),
  521. (943, '14:00:00', '14:30:00', 79, ''),
  522. (944, '13:00:00', '13:30:00', 77, ''),
  523. (945, '13:00:00', '13:30:00', 77, ''),
  524. (946, '13:30:00', '14:00:00', 77, ''),
  525. (947, '13:30:00', '14:00:00', 77, ''),
  526. (948, '14:00:00', '14:30:00', 77, ''),
  527. (949, '14:00:00', '14:30:00', 77, ''),
  528. (950, '14:30:00', '15:00:00', 77, ''),
  529. (951, '14:30:00', '15:00:00', 77, ''),
  530. (952, '15:00:00', '15:30:00', 77, ''),
  531. (953, '15:00:00', '15:30:00', 77, ''),
  532. (954, '15:30:00', '16:00:00', 77, ''),
  533. (955, '15:30:00', '16:00:00', 77, ''),
  534. (956, '16:00:00', '16:30:00', 77, ''),
  535. (957, '16:00:00', '16:30:00', 77, ''),
  536. (958, '16:30:00', '17:00:00', 77, ''),
  537. (959, '16:30:00', '17:00:00', 77, ''),
  538. (960, '17:00:00', '17:30:00', 77, ''),
  539. (961, '17:00:00', '17:30:00', 77, ''),
  540. (962, '09:00:00', '09:30:00', 78, ''),
  541. (963, '09:00:00', '09:30:00', 78, ''),
  542. (964, '09:30:00', '10:00:00', 78, ''),
  543. (965, '09:30:00', '10:00:00', 78, ''),
  544. (966, '10:00:00', '10:30:00', 78, ''),
  545. (967, '10:00:00', '10:30:00', 78, ''),
  546. (968, '10:30:00', '11:00:00', 78, ''),
  547. (969, '10:30:00', '11:00:00', 78, ''),
  548. (970, '11:00:00', '11:30:00', 78, ''),
  549. (971, '11:00:00', '11:30:00', 78, ''),
  550. (972, '11:30:00', '12:00:00', 78, ''),
  551. (973, '11:30:00', '12:00:00', 78, ''),
  552. (974, '12:00:00', '12:30:00', 78, ''),
  553. (975, '12:00:00', '12:30:00', 78, ''),
  554. (976, '12:30:00', '13:00:00', 78, ''),
  555. (977, '12:30:00', '13:00:00', 78, ''),
  556. (978, '13:00:00', '13:30:00', 78, ''),
  557. (979, '13:00:00', '13:30:00', 78, ''),
  558. (980, '13:30:00', '14:00:00', 78, ''),
  559. (981, '13:30:00', '14:00:00', 78, ''),
  560. (982, '14:00:00', '14:30:00', 78, ''),
  561. (983, '14:00:00', '14:30:00', 78, ''),
  562. (984, '14:30:00', '15:00:00', 78, ''),
  563. (985, '14:30:00', '15:00:00', 78, ''),
  564. (986, '15:00:00', '15:30:00', 78, ''),
  565. (987, '15:00:00', '15:30:00', 78, ''),
  566. (988, '09:00:00', '09:30:00', 79, ''),
  567. (989, '09:00:00', '09:30:00', 79, ''),
  568. (990, '09:30:00', '10:00:00', 79, ''),
  569. (991, '09:30:00', '10:00:00', 79, ''),
  570. (992, '10:00:00', '10:30:00', 79, ''),
  571. (993, '10:00:00', '10:30:00', 79, ''),
  572. (994, '10:30:00', '11:00:00', 79, ''),
  573. (995, '10:30:00', '11:00:00', 79, ''),
  574. (996, '11:00:00', '11:30:00', 79, ''),
  575. (997, '11:00:00', '11:30:00', 79, ''),
  576. (998, '11:30:00', '12:00:00', 79, ''),
  577. (999, '11:30:00', '12:00:00', 79, ''),
  578. (1000, '12:00:00', '12:30:00', 79, ''),
  579. (1001, '12:00:00', '12:30:00', 79, ''),
  580. (1002, '12:30:00', '13:00:00', 79, ''),
  581. (1003, '12:30:00', '13:00:00', 79, ''),
  582. (1004, '13:00:00', '13:30:00', 79, ''),
  583. (1005, '13:00:00', '13:30:00', 79, ''),
  584. (1006, '13:30:00', '14:00:00', 79, ''),
  585. (1007, '13:30:00', '14:00:00', 79, ''),
  586. (1008, '14:00:00', '14:30:00', 79, ''),
  587. (1009, '14:00:00', '14:30:00', 79, ''),
  588. (1010, '13:00:00', '13:30:00', 77, ''),
  589. (1011, '13:00:00', '13:30:00', 77, ''),
  590. (1012, '13:30:00', '14:00:00', 77, ''),
  591. (1013, '13:30:00', '14:00:00', 77, ''),
  592. (1014, '14:00:00', '14:30:00', 77, ''),
  593. (1015, '14:00:00', '14:30:00', 77, ''),
  594. (1016, '14:30:00', '15:00:00', 77, ''),
  595. (1017, '14:30:00', '15:00:00', 77, ''),
  596. (1018, '15:00:00', '15:30:00', 77, ''),
  597. (1019, '15:00:00', '15:30:00', 77, ''),
  598. (1020, '15:30:00', '16:00:00', 77, ''),
  599. (1021, '15:30:00', '16:00:00', 77, ''),
  600. (1022, '16:00:00', '16:30:00', 77, ''),
  601. (1023, '16:00:00', '16:30:00', 77, ''),
  602. (1024, '16:30:00', '17:00:00', 77, ''),
  603. (1025, '16:30:00', '17:00:00', 77, ''),
  604. (1026, '17:00:00', '17:30:00', 77, ''),
  605. (1027, '17:00:00', '17:30:00', 77, ''),
  606. (1028, '09:00:00', '09:30:00', 78, ''),
  607. (1029, '09:00:00', '09:30:00', 78, ''),
  608. (1030, '09:30:00', '10:00:00', 78, ''),
  609. (1031, '09:30:00', '10:00:00', 78, ''),
  610. (1032, '10:00:00', '10:30:00', 78, ''),
  611. (1033, '10:00:00', '10:30:00', 78, ''),
  612. (1034, '13:00:00', '13:30:00', 77, ''),
  613. (1035, '13:00:00', '13:30:00', 77, ''),
  614. (1036, '13:30:00', '14:00:00', 77, ''),
  615. (1037, '13:30:00', '14:00:00', 77, ''),
  616. (1038, '14:00:00', '14:30:00', 77, ''),
  617. (1039, '14:00:00', '14:30:00', 77, ''),
  618. (1040, '14:30:00', '15:00:00', 77, ''),
  619. (1041, '14:30:00', '15:00:00', 77, ''),
  620. (1042, '15:00:00', '15:30:00', 77, ''),
  621. (1043, '15:00:00', '15:30:00', 77, ''),
  622. (1044, '15:30:00', '16:00:00', 77, ''),
  623. (1045, '15:30:00', '16:00:00', 77, ''),
  624. (1046, '16:00:00', '16:30:00', 77, ''),
  625. (1047, '16:00:00', '16:30:00', 77, ''),
  626. (1048, '16:30:00', '17:00:00', 77, ''),
  627. (1049, '16:30:00', '17:00:00', 77, ''),
  628. (1050, '17:00:00', '17:30:00', 77, ''),
  629. (1051, '17:00:00', '17:30:00', 77, ''),
  630. (1052, '09:00:00', '09:30:00', 78, ''),
  631. (1053, '09:00:00', '09:30:00', 78, ''),
  632. (1054, '09:30:00', '10:00:00', 78, ''),
  633. (1055, '09:30:00', '10:00:00', 78, ''),
  634. (1056, '10:00:00', '10:30:00', 78, ''),
  635. (1057, '10:00:00', '10:30:00', 78, '');
  636.  
  637. -- --------------------------------------------------------
  638.  
  639. --
  640. -- Struktura tabulky `online_report`
  641. --
  642.  
  643. CREATE TABLE IF NOT EXISTS `online_report` (
  644. `id` INT(11) NOT NULL,
  645.   `match_id` INT(11) NOT NULL,
  646.   `message` text COLLATE utf8_czech_ci NOT NULL,
  647.   `type` CHAR(20) COLLATE utf8_czech_ci NOT NULL,
  648.   `updated` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  649.   `added` datetime NOT NULL,
  650.   `author` INT(11) NOT NULL
  651. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  652.  
  653. -- --------------------------------------------------------
  654.  
  655. --
  656. -- Struktura tabulky `photo`
  657. --
  658.  
  659. CREATE TABLE IF NOT EXISTS `photo` (
  660. `id` INT(11) NOT NULL,
  661.   `path_full` text COLLATE utf8_czech_ci NOT NULL,
  662.   `path_thumb` text COLLATE utf8_czech_ci NOT NULL,
  663.   `captured` datetime NOT NULL,
  664.   `author_id` INT(11) DEFAULT NULL
  665. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  666.  
  667. --
  668. -- Vypisuji data pro tabulku `photo`
  669. --
  670.  
  671. INSERT INTO `photo` (`id`, `path_full`, `path_thumb`, `captured`, `author_id`) VALUES
  672. (1, 'cesta_full', 'cesta_thumb', '2015-01-19 22:11:20', 1);
  673.  
  674. -- --------------------------------------------------------
  675.  
  676. --
  677. -- Struktura tabulky `photo_tag`
  678. --
  679.  
  680. CREATE TABLE IF NOT EXISTS `photo_tag` (
  681.   `photo_id` INT(11) NOT NULL,
  682.   `tag_id` INT(11) NOT NULL
  683. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  684.  
  685. --
  686. -- Vypisuji data pro tabulku `photo_tag`
  687. --
  688.  
  689. INSERT INTO `photo_tag` (`photo_id`, `tag_id`) VALUES
  690. (1, 1);
  691.  
  692. -- --------------------------------------------------------
  693.  
  694. --
  695. -- Struktura tabulky `static_content`
  696. --
  697.  
  698. CREATE TABLE IF NOT EXISTS `static_content` (
  699. `id` INT(11) NOT NULL,
  700.   `content` text COLLATE utf8_czech_ci NOT NULL,
  701.   `updated` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP,
  702.   `user_id` INT(11) NOT NULL
  703. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  704.  
  705. --
  706. -- Vypisuji data pro tabulku `static_content`
  707. --
  708.  
  709. INSERT INTO `static_content` (`id`, `content`, `updated`, `user_id`) VALUES
  710. (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);
  711.  
  712. -- --------------------------------------------------------
  713.  
  714. --
  715. -- Struktura tabulky `tag`
  716. --
  717.  
  718. CREATE TABLE IF NOT EXISTS `tag` (
  719. `id` INT(11) NOT NULL,
  720.   `name` text COLLATE utf8_czech_ci,
  721.   `slug` text COLLATE utf8_czech_ci NOT NULL,
  722.   `is_gallery` INT(11) NOT NULL DEFAULT '0',
  723.   `main_photo_id` INT(11) DEFAULT NULL
  724. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  725.  
  726. --
  727. -- Vypisuji data pro tabulku `tag`
  728. --
  729.  
  730. INSERT INTO `tag` (`id`, `name`, `slug`, `is_gallery`, `main_photo_id`) VALUES
  731. (1, 'nějaký tag', 'nejaky-tag', 0, 1);
  732.  
  733. -- --------------------------------------------------------
  734.  
  735. --
  736. -- Struktura tabulky `team`
  737. --
  738.  
  739. CREATE TABLE IF NOT EXISTS `team` (
  740. `id` INT(11) NOT NULL,
  741.   `category_id` INT(11) NOT NULL,
  742.   `team_info_id` INT(11) NOT NULL,
  743.   `order` INT(11) NOT NULL,
  744.   `points` INT(11) NOT NULL,
  745.   `scored` INT(11) NOT NULL,
  746.   `received` INT(11) NOT NULL,
  747.   `inserted` datetime NOT NULL,
  748.   `actual` INT(11) NOT NULL DEFAULT '0',
  749.   `after_match_id` INT(11) DEFAULT NULL
  750. ) ENGINE=InnoDB AUTO_INCREMENT=5828 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  751.  
  752. --
  753. -- Vypisuji data pro tabulku `team`
  754. --
  755.  
  756. INSERT INTO `team` (`id`, `category_id`, `team_info_id`, `order`, `points`, `scored`, `received`, `inserted`, `actual`, `after_match_id`) VALUES
  757. (5560, 1, 78, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1585),
  758. (5561, 1, 79, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1585),
  759. (5562, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:36', 0, 1586),
  760. (5563, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:36', 0, 1586),
  761. (5564, 1, 80, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1586),
  762. (5565, 1, 81, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1586),
  763. (5566, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:36', 0, 1587),
  764. (5567, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:36', 0, 1587),
  765. (5568, 1, 80, 0, 0, 3, 8, '2015-01-25 21:12:36', 0, 1587),
  766. (5569, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:36', 0, 1587),
  767. (5570, 1, 82, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1587),
  768. (5571, 1, 83, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1587),
  769. (5572, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:36', 0, 1588),
  770. (5573, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:36', 0, 1588),
  771. (5574, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:36', 0, 1588),
  772. (5575, 1, 80, 0, 0, 3, 8, '2015-01-25 21:12:36', 0, 1588),
  773. (5576, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:36', 0, 1588),
  774. (5577, 1, 83, 0, 2, 7, 6, '2015-01-25 21:12:36', 0, 1588),
  775. (5578, 1, 84, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1588),
  776. (5579, 1, 85, 0, 0, 0, 0, '2015-01-25 21:12:36', 0, 1588),
  777. (5580, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:36', 0, 1589),
  778. (5581, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:36', 0, 1589),
  779. (5582, 1, 83, 0, 2, 7, 6, '2015-01-25 21:12:37', 0, 1589),
  780. (5583, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:37', 0, 1589),
  781. (5584, 1, 80, 0, 0, 3, 8, '2015-01-25 21:12:37', 0, 1589),
  782. (5585, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:37', 0, 1589),
  783. (5586, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:37', 0, 1589),
  784. (5587, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:37', 0, 1589),
  785. (5588, 1, 86, 0, 0, 0, 0, '2015-01-25 21:12:37', 0, 1589),
  786. (5589, 1, 87, 0, 0, 0, 0, '2015-01-25 21:12:37', 0, 1589),
  787. (5590, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:37', 0, 1590),
  788. (5591, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:37', 0, 1590),
  789. (5592, 1, 83, 0, 2, 7, 6, '2015-01-25 21:12:37', 0, 1590),
  790. (5593, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:37', 0, 1590),
  791. (5594, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:37', 0, 1590),
  792. (5595, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:37', 0, 1590),
  793. (5596, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:37', 0, 1590),
  794. (5597, 1, 80, 0, 0, 3, 8, '2015-01-25 21:12:37', 0, 1590),
  795. (5598, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:37', 0, 1590),
  796. (5599, 1, 87, 0, 1, 6, 6, '2015-01-25 21:12:37', 0, 1590),
  797. (5600, 1, 88, 0, 0, 0, 0, '2015-01-25 21:12:37', 0, 1590),
  798. (5601, 1, 78, 0, 2, 14, 6, '2015-01-25 21:12:37', 0, 1591),
  799. (5602, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:37', 0, 1591),
  800. (5603, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:37', 0, 1591),
  801. (5604, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:37', 0, 1591),
  802. (5605, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:37', 0, 1591),
  803. (5606, 1, 87, 0, 1, 6, 6, '2015-01-25 21:12:37', 0, 1591),
  804. (5607, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:37', 0, 1591),
  805. (5608, 1, 80, 0, 0, 3, 8, '2015-01-25 21:12:37', 0, 1591),
  806. (5609, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:37', 0, 1591),
  807. (5610, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:37', 0, 1591),
  808. (5611, 1, 88, 0, 0, 2, 4, '2015-01-25 21:12:37', 0, 1591),
  809. (5612, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:38', 0, 1592),
  810. (5613, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:38', 0, 1592),
  811. (5614, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:38', 0, 1592),
  812. (5615, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:38', 0, 1592),
  813. (5616, 1, 87, 0, 1, 6, 6, '2015-01-25 21:12:38', 0, 1592),
  814. (5617, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:38', 0, 1592),
  815. (5618, 1, 79, 0, 0, 6, 14, '2015-01-25 21:12:38', 0, 1592),
  816. (5619, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:38', 0, 1592),
  817. (5620, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:38', 0, 1592),
  818. (5621, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:38', 0, 1592),
  819. (5622, 1, 88, 0, 0, 2, 4, '2015-01-25 21:12:38', 0, 1592),
  820. (5623, 1, 89, 0, 0, 0, 0, '2015-01-25 21:12:38', 0, 1592),
  821. (5624, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:38', 0, 1593),
  822. (5625, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:38', 0, 1593),
  823. (5626, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:38', 0, 1593),
  824. (5627, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:38', 0, 1593),
  825. (5628, 1, 87, 0, 1, 6, 6, '2015-01-25 21:12:38', 0, 1593),
  826. (5629, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:38', 0, 1593),
  827. (5630, 1, 88, 0, 0, 2, 4, '2015-01-25 21:12:38', 0, 1593),
  828. (5631, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:38', 0, 1593),
  829. (5632, 1, 82, 0, 0, 6, 7, '2015-01-25 21:12:38', 0, 1593),
  830. (5633, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:38', 0, 1593),
  831. (5634, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:38', 0, 1593),
  832. (5635, 1, 89, 0, 0, 12, 13, '2015-01-25 21:12:38', 0, 1593),
  833. (5636, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:38', 0, 1594),
  834. (5637, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:38', 0, 1594),
  835. (5638, 1, 81, 0, 2, 8, 3, '2015-01-25 21:12:38', 0, 1594),
  836. (5639, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:38', 0, 1594),
  837. (5640, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:38', 0, 1594),
  838. (5641, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:39', 0, 1594),
  839. (5642, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:39', 0, 1594),
  840. (5643, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:39', 0, 1594),
  841. (5644, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:39', 0, 1594),
  842. (5645, 1, 84, 0, 0, 12, 16, '2015-01-25 21:12:39', 0, 1594),
  843. (5646, 1, 88, 0, 0, 2, 4, '2015-01-25 21:12:39', 0, 1594),
  844. (5647, 1, 89, 0, 0, 12, 13, '2015-01-25 21:12:39', 0, 1594),
  845. (5648, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:39', 0, 1595),
  846. (5649, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:39', 0, 1595),
  847. (5650, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:39', 0, 1595),
  848. (5651, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:39', 0, 1595),
  849. (5652, 1, 85, 0, 2, 16, 12, '2015-01-25 21:12:39', 0, 1595),
  850. (5653, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:39', 0, 1595),
  851. (5654, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:39', 0, 1595),
  852. (5655, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:39', 0, 1595),
  853. (5656, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:39', 0, 1595),
  854. (5657, 1, 84, 0, 0, 17, 39, '2015-01-25 21:12:39', 0, 1595),
  855. (5658, 1, 88, 0, 0, 2, 4, '2015-01-25 21:12:39', 0, 1595),
  856. (5659, 1, 89, 0, 0, 12, 13, '2015-01-25 21:12:39', 0, 1595),
  857. (5660, 1, 83, 0, 4, 11, 8, '2015-01-25 21:12:40', 0, 1596),
  858. (5661, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:40', 0, 1596),
  859. (5662, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:40', 0, 1596),
  860. (5663, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:40', 0, 1596),
  861. (5664, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:40', 0, 1596),
  862. (5665, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:40', 0, 1596),
  863. (5666, 1, 86, 0, 1, 6, 6, '2015-01-25 21:12:40', 0, 1596),
  864. (5667, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:40', 0, 1596),
  865. (5668, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:40', 0, 1596),
  866. (5669, 1, 84, 0, 0, 17, 39, '2015-01-25 21:12:40', 0, 1596),
  867. (5670, 1, 88, 0, 2, 24, 19, '2015-01-25 21:12:40', 0, 1596),
  868. (5671, 1, 89, 0, 0, 12, 13, '2015-01-25 21:12:40', 0, 1596),
  869. (5672, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:40', 0, 1597),
  870. (5673, 1, 78, 0, 4, 36, 12, '2015-01-25 21:12:40', 0, 1597),
  871. (5674, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:40', 0, 1597),
  872. (5675, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:40', 0, 1597),
  873. (5676, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:40', 0, 1597),
  874. (5677, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:40', 0, 1597),
  875. (5678, 1, 88, 0, 2, 24, 19, '2015-01-25 21:12:40', 0, 1597),
  876. (5679, 1, 86, 0, 3, 14, 6, '2015-01-25 21:12:40', 0, 1597),
  877. (5680, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:40', 0, 1597),
  878. (5681, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:40', 0, 1597),
  879. (5682, 1, 84, 0, 0, 17, 39, '2015-01-25 21:12:40', 0, 1597),
  880. (5683, 1, 89, 0, 0, 12, 13, '2015-01-25 21:12:40', 0, 1597),
  881. (5684, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:41', 0, 1598),
  882. (5685, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:41', 0, 1598),
  883. (5686, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:41', 0, 1598),
  884. (5687, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:41', 0, 1598),
  885. (5688, 1, 86, 0, 3, 14, 6, '2015-01-25 21:12:41', 0, 1598),
  886. (5689, 1, 88, 0, 2, 24, 19, '2015-01-25 21:12:41', 0, 1598),
  887. (5690, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:41', 0, 1598),
  888. (5691, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:41', 0, 1598),
  889. (5692, 1, 80, 0, 0, 9, 30, '2015-01-25 21:12:41', 0, 1598),
  890. (5693, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:41', 0, 1598),
  891. (5694, 1, 84, 0, 0, 17, 39, '2015-01-25 21:12:41', 0, 1598),
  892. (5695, 1, 89, 0, 0, 22, 29, '2015-01-25 21:12:41', 0, 1598),
  893. (5696, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:41', 0, 1599),
  894. (5697, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:41', 0, 1599),
  895. (5698, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:41', 0, 1599),
  896. (5699, 1, 87, 0, 3, 23, 14, '2015-01-25 21:12:41', 0, 1599),
  897. (5700, 1, 86, 0, 3, 14, 6, '2015-01-25 21:12:41', 0, 1599),
  898. (5701, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:41', 0, 1599),
  899. (5702, 1, 79, 0, 2, 19, 26, '2015-01-25 21:12:41', 0, 1599),
  900. (5703, 1, 88, 0, 2, 24, 19, '2015-01-25 21:12:41', 0, 1599),
  901. (5704, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:41', 0, 1599),
  902. (5705, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:41', 0, 1599),
  903. (5706, 1, 84, 0, 1, 27, 49, '2015-01-25 21:12:41', 0, 1599),
  904. (5707, 1, 89, 0, 0, 22, 29, '2015-01-25 21:12:41', 0, 1599),
  905. (5708, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:42', 0, 1600),
  906. (5709, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:42', 0, 1600),
  907. (5710, 1, 81, 0, 4, 31, 8, '2015-01-25 21:12:42', 0, 1600),
  908. (5711, 1, 87, 0, 5, 35, 23, '2015-01-25 21:12:42', 0, 1600),
  909. (5712, 1, 86, 0, 3, 14, 6, '2015-01-25 21:12:42', 0, 1600),
  910. (5713, 1, 88, 0, 2, 24, 19, '2015-01-25 21:12:42', 0, 1600),
  911. (5714, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:42', 0, 1600),
  912. (5715, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:42', 0, 1600),
  913. (5716, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:42', 0, 1600),
  914. (5717, 1, 84, 0, 1, 27, 49, '2015-01-25 21:12:42', 0, 1600),
  915. (5718, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:42', 0, 1600),
  916. (5719, 1, 89, 0, 0, 22, 29, '2015-01-25 21:12:42', 0, 1600),
  917. (5720, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:42', 0, 1601),
  918. (5721, 1, 87, 0, 5, 35, 23, '2015-01-25 21:12:42', 0, 1601),
  919. (5722, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:42', 0, 1601),
  920. (5723, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:42', 0, 1601),
  921. (5724, 1, 86, 0, 3, 14, 6, '2015-01-25 21:12:42', 0, 1601),
  922. (5725, 1, 85, 0, 2, 31, 34, '2015-01-25 21:12:42', 0, 1601),
  923. (5726, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:42', 0, 1601),
  924. (5727, 1, 88, 0, 2, 28, 30, '2015-01-25 21:12:42', 0, 1601),
  925. (5728, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:42', 0, 1601),
  926. (5729, 1, 84, 0, 1, 27, 49, '2015-01-25 21:12:42', 0, 1601),
  927. (5730, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:42', 0, 1601),
  928. (5731, 1, 89, 0, 0, 22, 29, '2015-01-25 21:12:42', 0, 1601),
  929. (5732, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:42', 0, 1602),
  930. (5733, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:43', 0, 1602),
  931. (5734, 1, 87, 0, 5, 35, 23, '2015-01-25 21:12:43', 0, 1602),
  932. (5735, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:43', 0, 1602),
  933. (5736, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:43', 0, 1602),
  934. (5737, 1, 88, 0, 2, 28, 30, '2015-01-25 21:12:43', 0, 1602),
  935. (5738, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:43', 0, 1602),
  936. (5739, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:43', 0, 1602),
  937. (5740, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:43', 0, 1602),
  938. (5741, 1, 84, 0, 1, 27, 49, '2015-01-25 21:12:43', 0, 1602),
  939. (5742, 1, 82, 0, 0, 14, 24, '2015-01-25 21:12:43', 0, 1602),
  940. (5743, 1, 89, 0, 0, 22, 29, '2015-01-25 21:12:43', 0, 1602),
  941. (5744, 1, 78, 0, 6, 52, 22, '2015-01-25 21:12:43', 0, 1603),
  942. (5745, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:43', 0, 1603),
  943. (5746, 1, 87, 0, 5, 35, 23, '2015-01-25 21:12:43', 0, 1603),
  944. (5747, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:43', 0, 1603),
  945. (5748, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:43', 0, 1603),
  946. (5749, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:43', 0, 1603),
  947. (5750, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:43', 0, 1603),
  948. (5751, 1, 88, 0, 2, 28, 30, '2015-01-25 21:12:43', 0, 1603),
  949. (5752, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:43', 0, 1603),
  950. (5753, 1, 84, 0, 1, 27, 49, '2015-01-25 21:12:43', 0, 1603),
  951. (5754, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:43', 0, 1603),
  952. (5755, 1, 89, 0, 2, 36, 36, '2015-01-25 21:12:43', 0, 1603),
  953. (5756, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:43', 0, 1604),
  954. (5757, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:43', 0, 1604),
  955. (5758, 1, 87, 0, 5, 35, 23, '2015-01-25 21:12:43', 0, 1604),
  956. (5759, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:44', 0, 1604),
  957. (5760, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:44', 0, 1604),
  958. (5761, 1, 88, 0, 2, 28, 30, '2015-01-25 21:12:44', 0, 1604),
  959. (5762, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:44', 0, 1604),
  960. (5763, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:44', 0, 1604),
  961. (5764, 1, 89, 0, 2, 36, 36, '2015-01-25 21:12:44', 0, 1604),
  962. (5765, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:44', 0, 1604),
  963. (5766, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:44', 0, 1604),
  964. (5767, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:44', 0, 1604),
  965. (5768, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:44', 0, 1605),
  966. (5769, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:44', 0, 1605),
  967. (5770, 1, 87, 0, 6, 50, 38, '2015-01-25 21:12:44', 0, 1605),
  968. (5771, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:44', 0, 1605),
  969. (5772, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:44', 0, 1605),
  970. (5773, 1, 89, 0, 3, 51, 51, '2015-01-25 21:12:44', 0, 1605),
  971. (5774, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:44', 0, 1605),
  972. (5775, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:44', 0, 1605),
  973. (5776, 1, 88, 0, 2, 28, 30, '2015-01-25 21:12:44', 0, 1605),
  974. (5777, 1, 80, 0, 1, 19, 40, '2015-01-25 21:12:44', 0, 1605),
  975. (5778, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:44', 0, 1605),
  976. (5779, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:44', 0, 1605),
  977. (5780, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:44', 0, 1606),
  978. (5781, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:44', 0, 1606),
  979. (5782, 1, 87, 0, 6, 50, 38, '2015-01-25 21:12:44', 0, 1606),
  980. (5783, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:44', 0, 1606),
  981. (5784, 1, 83, 0, 4, 11, 16, '2015-01-25 21:12:44', 0, 1606),
  982. (5785, 1, 89, 0, 3, 51, 51, '2015-01-25 21:12:45', 0, 1606),
  983. (5786, 1, 88, 0, 4, 46, 43, '2015-01-25 21:12:45', 0, 1606),
  984. (5787, 1, 79, 0, 2, 28, 38, '2015-01-25 21:12:45', 0, 1606),
  985. (5788, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:45', 0, 1606),
  986. (5789, 1, 80, 0, 1, 32, 58, '2015-01-25 21:12:45', 0, 1606),
  987. (5790, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:45', 0, 1606),
  988. (5791, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:45', 0, 1606),
  989. (5792, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:45', 0, 1607),
  990. (5793, 1, 81, 0, 6, 42, 12, '2015-01-25 21:12:45', 0, 1607),
  991. (5794, 1, 87, 0, 6, 50, 38, '2015-01-25 21:12:45', 0, 1607),
  992. (5795, 1, 86, 0, 5, 30, 16, '2015-01-25 21:12:45', 0, 1607),
  993. (5796, 1, 88, 0, 4, 46, 43, '2015-01-25 21:12:45', 0, 1607),
  994. (5797, 1, 83, 0, 4, 17, 33, '2015-01-25 21:12:45', 0, 1607),
  995. (5798, 1, 89, 0, 3, 51, 51, '2015-01-25 21:12:45', 0, 1607),
  996. (5799, 1, 79, 0, 4, 45, 44, '2015-01-25 21:12:45', 0, 1607),
  997. (5800, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:45', 0, 1607),
  998. (5801, 1, 80, 0, 1, 32, 58, '2015-01-25 21:12:45', 0, 1607),
  999. (5802, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:45', 0, 1607),
  1000. (5803, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:45', 0, 1607),
  1001. (5804, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:45', 0, 1608),
  1002. (5805, 1, 81, 0, 8, 47, 16, '2015-01-25 21:12:45', 0, 1608),
  1003. (5806, 1, 87, 0, 6, 50, 38, '2015-01-25 21:12:45', 0, 1608),
  1004. (5807, 1, 86, 0, 5, 34, 21, '2015-01-25 21:12:45', 0, 1608),
  1005. (5808, 1, 88, 0, 4, 46, 43, '2015-01-25 21:12:45', 0, 1608),
  1006. (5809, 1, 83, 0, 4, 17, 33, '2015-01-25 21:12:45', 0, 1608),
  1007. (5810, 1, 79, 0, 4, 45, 44, '2015-01-25 21:12:46', 0, 1608),
  1008. (5811, 1, 89, 0, 3, 51, 51, '2015-01-25 21:12:46', 0, 1608),
  1009. (5812, 1, 85, 0, 2, 41, 50, '2015-01-25 21:12:46', 0, 1608),
  1010. (5813, 1, 80, 0, 1, 32, 58, '2015-01-25 21:12:46', 0, 1608),
  1011. (5814, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:46', 0, 1608),
  1012. (5815, 1, 82, 0, 0, 21, 38, '2015-01-25 21:12:46', 0, 1608),
  1013. (5816, 1, 78, 0, 8, 75, 28, '2015-01-25 21:12:46', 1, NULL),
  1014. (5817, 1, 81, 0, 8, 47, 16, '2015-01-25 21:12:46', 1, NULL),
  1015. (5818, 1, 87, 0, 6, 50, 38, '2015-01-25 21:12:46', 1, NULL),
  1016. (5819, 1, 86, 0, 5, 34, 21, '2015-01-25 21:12:46', 1, NULL),
  1017. (5820, 1, 79, 0, 4, 45, 44, '2015-01-25 21:12:46', 1, NULL),
  1018. (5821, 1, 83, 0, 4, 17, 33, '2015-01-25 21:12:46', 1, NULL),
  1019. (5822, 1, 88, 0, 4, 46, 43, '2015-01-25 21:12:46', 1, NULL),
  1020. (5823, 1, 89, 0, 3, 51, 51, '2015-01-25 21:12:46', 1, NULL),
  1021. (5824, 1, 85, 0, 4, 53, 61, '2015-01-25 21:12:46', 1, NULL),
  1022. (5825, 1, 80, 0, 1, 32, 58, '2015-01-25 21:12:46', 1, NULL),
  1023. (5826, 1, 84, 0, 1, 33, 72, '2015-01-25 21:12:46', 1, NULL),
  1024. (5827, 1, 82, 0, 0, 32, 50, '2015-01-25 21:12:46', 1, NULL);
  1025.  
  1026. --
  1027. -- Spouště `team`
  1028. --
  1029. DELIMITER //
  1030. CREATE TRIGGER `team_bi` BEFORE INSERT ON `team`
  1031.  FOR EACH ROW SET NEW.inserted = NOW()
  1032. //
  1033. DELIMITER ;
  1034.  
  1035. -- --------------------------------------------------------
  1036.  
  1037. --
  1038. -- Struktura tabulky `team_info`
  1039. --
  1040.  
  1041. CREATE TABLE IF NOT EXISTS `team_info` (
  1042. `id` INT(11) NOT NULL,
  1043.   `category_id` INT(11) NOT NULL,
  1044.   `name` CHAR(30) COLLATE utf8_czech_ci NOT NULL,
  1045.   `slug` CHAR(30) COLLATE utf8_czech_ci NOT NULL
  1046. ) ENGINE=InnoDB AUTO_INCREMENT=90 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  1047.  
  1048. --
  1049. -- Vypisuji data pro tabulku `team_info`
  1050. --
  1051.  
  1052. INSERT INTO `team_info` (`id`, `category_id`, `name`, `slug`) VALUES
  1053. (81, 1, 'DHK Zora Olomouc', 'dhk-zora-olomouc'),
  1054. (83, 1, 'Handball Val. Meziříčí', 'handball-val-mezirici'),
  1055. (87, 1, 'HBC Jičín', 'hbc-jicin'),
  1056. (77, 1, 'jiný test', 'jiny-test'),
  1057. (82, 1, 'Otrokovice', 'otrokovice'),
  1058. (79, 1, 'SK Žeravice A', 'sk-zeravice-a'),
  1059. (85, 1, 'SK Žeravice B', 'sk-zeravice-b'),
  1060. (86, 1, 'Sokol Prostějov', 'sokol-prostejov'),
  1061. (89, 1, 'STM Olomouc', 'stm-olomouc'),
  1062. (88, 1, 'ŠKP Bratislava', 'skp-bratislava'),
  1063. (78, 1, 'Tatran Litovel', 'tatran-litovel'),
  1064. (76, 1, 'Test', 'test'),
  1065. (84, 1, 'TJ JM Chodov', 'tj-jm-chodov'),
  1066. (80, 1, 'Velká Bystřice', 'velka-bystrice');
  1067.  
  1068. -- --------------------------------------------------------
  1069.  
  1070. --
  1071. -- Struktura tabulky `user`
  1072. --
  1073.  
  1074. CREATE TABLE IF NOT EXISTS `user` (
  1075. `id` INT(11) NOT NULL,
  1076.   `username` text COLLATE utf8_czech_ci NOT NULL,
  1077.   `password_hash` text COLLATE utf8_czech_ci NOT NULL,
  1078.   `role` text COLLATE utf8_czech_ci NOT NULL,
  1079.   `fullname` text COLLATE utf8_czech_ci NOT NULL
  1080. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  1081.  
  1082. --
  1083. -- Vypisuji data pro tabulku `user`
  1084. --
  1085.  
  1086. INSERT INTO `user` (`id`, `username`, `password_hash`, `role`, `fullname`) VALUES
  1087. (1, 'joe', '$2y$10$HZGTs1GzZB70Bbpc2HLnFeyBYdaudLWW/gOd7CVEcpf8C4nURUVRi', 'admin', 'Joe Kolář');
  1088.  
  1089. -- --------------------------------------------------------
  1090.  
  1091. --
  1092. -- Struktura tabulky `year`
  1093. --
  1094.  
  1095. CREATE TABLE IF NOT EXISTS `year` (
  1096. `id` INT(11) NOT NULL,
  1097.   `year` YEAR(4) NOT NULL,
  1098.   `name` text COLLATE utf8_czech_ci,
  1099.   `actual` tinyint(1) NOT NULL
  1100. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;
  1101.  
  1102. --
  1103. -- Vypisuji data pro tabulku `year`
  1104. --
  1105.  
  1106. INSERT INTO `year` (`id`, `year`, `name`, `actual`) VALUES
  1107. (1, 2015, NULL, 1);
  1108.  
  1109. --
  1110. -- Klíče pro exportované tabulky
  1111. --
  1112.  
  1113. --
  1114. -- Klíče pro tabulku `category`
  1115. --
  1116. ALTER TABLE `category`
  1117.  ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `slug` (`slug`), ADD KEY `year_id` (`year_id`);
  1118.  
  1119. --
  1120. -- Klíče pro tabulku `day`
  1121. --
  1122. ALTER TABLE `day`
  1123.  ADD PRIMARY KEY (`id`), ADD KEY `year_id` (`year_id`);
  1124.  
  1125. --
  1126. -- Klíče pro tabulku `match`
  1127. --
  1128. ALTER TABLE `match`
  1129.  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`);
  1130.  
  1131. --
  1132. -- Klíče pro tabulku `match_term`
  1133. --
  1134. ALTER TABLE `match_term`
  1135.  ADD PRIMARY KEY (`id`), ADD KEY `day_id` (`day_id`);
  1136.  
  1137. --
  1138. -- Klíče pro tabulku `online_report`
  1139. --
  1140. ALTER TABLE `online_report`
  1141.  ADD PRIMARY KEY (`id`), ADD KEY `match_id` (`match_id`), ADD KEY `author` (`author`);
  1142.  
  1143. --
  1144. -- Klíče pro tabulku `photo`
  1145. --
  1146. ALTER TABLE `photo`
  1147.  ADD PRIMARY KEY (`id`), ADD KEY `author_id` (`author_id`);
  1148.  
  1149. --
  1150. -- Klíče pro tabulku `photo_tag`
  1151. --
  1152. ALTER TABLE `photo_tag`
  1153.  ADD PRIMARY KEY (`photo_id`,`tag_id`), ADD KEY `tag_id` (`tag_id`);
  1154.  
  1155. --
  1156. -- Klíče pro tabulku `static_content`
  1157. --
  1158. ALTER TABLE `static_content`
  1159.  ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`);
  1160.  
  1161. --
  1162. -- Klíče pro tabulku `tag`
  1163. --
  1164. ALTER TABLE `tag`
  1165.  ADD PRIMARY KEY (`id`), ADD KEY `main_photo_id` (`main_photo_id`);
  1166.  
  1167. --
  1168. -- Klíče pro tabulku `team`
  1169. --
  1170. ALTER TABLE `team`
  1171.  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`);
  1172.  
  1173. --
  1174. -- Klíče pro tabulku `team_info`
  1175. --
  1176. ALTER TABLE `team_info`
  1177.  ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `category_id_name_slug` (`category_id`,`name`,`slug`);
  1178.  
  1179. --
  1180. -- Klíče pro tabulku `user`
  1181. --
  1182. ALTER TABLE `user`
  1183.  ADD PRIMARY KEY (`id`);
  1184.  
  1185. --
  1186. -- Klíče pro tabulku `year`
  1187. --
  1188. ALTER TABLE `year`
  1189.  ADD PRIMARY KEY (`id`);
  1190.  
  1191. --
  1192. -- AUTO_INCREMENT pro tabulky
  1193. --
  1194.  
  1195. --
  1196. -- AUTO_INCREMENT pro tabulku `category`
  1197. --
  1198. ALTER TABLE `category`
  1199. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=3;
  1200. --
  1201. -- AUTO_INCREMENT pro tabulku `day`
  1202. --
  1203. ALTER TABLE `day`
  1204. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=80;
  1205. --
  1206. -- AUTO_INCREMENT pro tabulku `match`
  1207. --
  1208. ALTER TABLE `match`
  1209. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1609;
  1210. --
  1211. -- AUTO_INCREMENT pro tabulku `match_term`
  1212. --
  1213. ALTER TABLE `match_term`
  1214. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=1058;
  1215. --
  1216. -- AUTO_INCREMENT pro tabulku `online_report`
  1217. --
  1218. ALTER TABLE `online_report`
  1219. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT;
  1220. --
  1221. -- AUTO_INCREMENT pro tabulku `photo`
  1222. --
  1223. ALTER TABLE `photo`
  1224. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  1225. --
  1226. -- AUTO_INCREMENT pro tabulku `static_content`
  1227. --
  1228. ALTER TABLE `static_content`
  1229. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  1230. --
  1231. -- AUTO_INCREMENT pro tabulku `tag`
  1232. --
  1233. ALTER TABLE `tag`
  1234. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  1235. --
  1236. -- AUTO_INCREMENT pro tabulku `team`
  1237. --
  1238. ALTER TABLE `team`
  1239. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5828;
  1240. --
  1241. -- AUTO_INCREMENT pro tabulku `team_info`
  1242. --
  1243. ALTER TABLE `team_info`
  1244. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=90;
  1245. --
  1246. -- AUTO_INCREMENT pro tabulku `user`
  1247. --
  1248. ALTER TABLE `user`
  1249. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  1250. --
  1251. -- AUTO_INCREMENT pro tabulku `year`
  1252. --
  1253. ALTER TABLE `year`
  1254. MODIFY `id` INT(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
  1255. --
  1256. -- Omezení pro exportované tabulky
  1257. --
  1258.  
  1259. --
  1260. -- Omezení pro tabulku `category`
  1261. --
  1262. ALTER TABLE `category`
  1263. ADD CONSTRAINT `category_ibfk_1` FOREIGN KEY (`year_id`) REFERENCES `year` (`id`);
  1264.  
  1265. --
  1266. -- Omezení pro tabulku `day`
  1267. --
  1268. ALTER TABLE `day`
  1269. ADD CONSTRAINT `day_ibfk_1` FOREIGN KEY (`year_id`) REFERENCES `year` (`id`);
  1270.  
  1271. --
  1272. -- Omezení pro tabulku `match`
  1273. --
  1274. ALTER TABLE `match`
  1275. ADD CONSTRAINT `match_ibfk_1` FOREIGN KEY (`match_term_id`) REFERENCES `match_term` (`id`),
  1276. ADD CONSTRAINT `match_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  1277. ADD CONSTRAINT `match_ibfk_5` FOREIGN KEY (`home_team_info_id`) REFERENCES `team_info` (`id`),
  1278. ADD CONSTRAINT `match_ibfk_6` FOREIGN KEY (`away_team_info_id`) REFERENCES `team_info` (`id`);
  1279.  
  1280. --
  1281. -- Omezení pro tabulku `match_term`
  1282. --
  1283. ALTER TABLE `match_term`
  1284. ADD CONSTRAINT `day_id` FOREIGN KEY (`day_id`) REFERENCES `day` (`id`);
  1285.  
  1286. --
  1287. -- Omezení pro tabulku `online_report`
  1288. --
  1289. ALTER TABLE `online_report`
  1290. ADD CONSTRAINT `online_report_ibfk_1` FOREIGN KEY (`match_id`) REFERENCES `match` (`id`),
  1291. ADD CONSTRAINT `online_report_ibfk_3` FOREIGN KEY (`author`) REFERENCES `user` (`id`);
  1292.  
  1293. --
  1294. -- Omezení pro tabulku `photo`
  1295. --
  1296. ALTER TABLE `photo`
  1297. ADD CONSTRAINT `photo_ibfk_1` FOREIGN KEY (`author_id`) REFERENCES `user` (`id`);
  1298.  
  1299. --
  1300. -- Omezení pro tabulku `photo_tag`
  1301. --
  1302. ALTER TABLE `photo_tag`
  1303. ADD CONSTRAINT `photo_tag_ibfk_1` FOREIGN KEY (`photo_id`) REFERENCES `photo` (`id`),
  1304. ADD CONSTRAINT `photo_tag_ibfk_2` FOREIGN KEY (`tag_id`) REFERENCES `tag` (`id`);
  1305.  
  1306. --
  1307. -- Omezení pro tabulku `static_content`
  1308. --
  1309. ALTER TABLE `static_content`
  1310. ADD CONSTRAINT `static_content_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);
  1311.  
  1312. --
  1313. -- Omezení pro tabulku `tag`
  1314. --
  1315. ALTER TABLE `tag`
  1316. ADD CONSTRAINT `tag_ibfk_1` FOREIGN KEY (`main_photo_id`) REFERENCES `photo` (`id`);
  1317.  
  1318. --
  1319. -- Omezení pro tabulku `team`
  1320. --
  1321. ALTER TABLE `team`
  1322. ADD CONSTRAINT `team_ibfk_1` FOREIGN KEY (`team_info_id`) REFERENCES `team_info` (`id`),
  1323. ADD CONSTRAINT `team_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`),
  1324. ADD CONSTRAINT `team_ibfk_6` FOREIGN KEY (`after_match_id`) REFERENCES `match` (`id`) ON DELETE SET NULL ON UPDATE SET NULL;
  1325.  
  1326. --
  1327. -- Omezení pro tabulku `team_info`
  1328. --
  1329. ALTER TABLE `team_info`
  1330. ADD CONSTRAINT `team_info_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`);
  1331.  
  1332. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  1333. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  1334. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!