· 8 years ago · Dec 21, 2017, 11:02 AM
1# ************************************************************
2# Sequel Pro SQL dump
3# Version 4541
4#
5# http://www.sequelpro.com/
6# https://github.com/sequelpro/sequelpro
7#
8# Host: 127.0.0.1 (MySQL 5.6.38)
9# Database: fortnite
10# Generation Time: 2017-12-21 10:58:02 +0000
11# ************************************************************
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/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
19/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
20/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
21
22
23# Dump of table games
24# ------------------------------------------------------------
25
26DROP TABLE IF EXISTS `games`;
27
28CREATE TABLE `games` (
29 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
30 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
31 `date` datetime NOT NULL,
32 `created_at` timestamp NULL DEFAULT NULL,
33 `updated_at` timestamp NULL DEFAULT NULL,
34 PRIMARY KEY (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
36
37LOCK TABLES `games` WRITE;
38/*!40000 ALTER TABLE `games` DISABLE KEYS */;
39
40INSERT INTO `games` (`id`, `name`, `date`, `created_at`, `updated_at`)
41VALUES
42 (1,'game1','2017-12-19 22:59:45','2017-12-19 22:59:48','2017-12-19 22:59:55'),
43 (2,'game2','2017-12-20 22:59:45','2017-12-19 22:59:48','2017-12-19 22:59:55'),
44 (3,'game3','2017-12-24 22:59:45','2017-12-19 22:59:48','2017-12-19 22:59:55');
45
46/*!40000 ALTER TABLE `games` ENABLE KEYS */;
47UNLOCK TABLES;
48
49
50# Dump of table migrations
51# ------------------------------------------------------------
52
53DROP TABLE IF EXISTS `migrations`;
54
55CREATE TABLE `migrations` (
56 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
57 `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
58 `batch` int(11) NOT NULL,
59 PRIMARY KEY (`id`)
60) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
61
62LOCK TABLES `migrations` WRITE;
63/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
64
65INSERT INTO `migrations` (`id`, `migration`, `batch`)
66VALUES
67 (1,'2014_10_12_000000_create_users_table',1),
68 (2,'2014_10_12_100000_create_password_resets_table',1),
69 (3,'2017_12_06_132026_create_tournaments_table',1),
70 (4,'2017_12_06_140214_create_partners_table',1),
71 (5,'2017_12_06_141253_create_games_table',1),
72 (6,'2017_12_06_142903_create_teams_table',1),
73 (7,'2017_12_06_154543_create_prices_table',1),
74 (8,'2017_12_06_155759_create_records_table',1),
75 (9,'2017_12_06_160749_create_settings_table',1),
76 (10,'2017_12_06_162921_create_teams_users_table',1),
77 (11,'2017_12_06_162921_create_tournament_game_table',1),
78 (12,'2017_12_06_162921_create_tournament_team_table',1),
79 (13,'2017_12_06_164927_create_scores_table',1);
80
81/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
82UNLOCK TABLES;
83
84
85# Dump of table partners
86# ------------------------------------------------------------
87
88DROP TABLE IF EXISTS `partners`;
89
90CREATE TABLE `partners` (
91 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
92 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
93 `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
94 `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
95 `about` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
96 `created_at` timestamp NULL DEFAULT NULL,
97 `updated_at` timestamp NULL DEFAULT NULL,
98 PRIMARY KEY (`id`)
99) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
100
101LOCK TABLES `partners` WRITE;
102/*!40000 ALTER TABLE `partners` DISABLE KEYS */;
103
104INSERT INTO `partners` (`id`, `name`, `url`, `image`, `about`, `created_at`, `updated_at`)
105VALUES
106 (1,'par1','','logo','ds','2017-12-21 08:10:21','2017-12-21 08:10:24'),
107 (2,'par1','','logo','dd','2017-12-21 08:10:21','2017-12-21 08:10:24'),
108 (3,'par1','','logo',' Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod dolor sit amet, consectetur adipisicing elit, sed do eiusm tempor incididunt ut labore','2017-12-21 08:10:21','2017-12-21 08:10:24'),
109 (4,'par1','','logo',' Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod dolor sit amet, consectetur adipisicing elit, sed do eiusm tempor incididunt ut labore','2017-12-21 08:10:21','2017-12-21 08:10:24'),
110 (5,'par1','','logo',' Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod dolor sit amet, consectetur adipisicing elit, sed do eiusm tempor incididunt ut labore','2017-12-21 08:10:21','2017-12-21 08:10:24'),
111 (6,'par1','','logo',' Lorem ipsum dolor sit amet, consectetur adipisicing elit, sed do eiusmod dolor sit amet, consectetur adipisicing elit, sed do eiusm tempor incididunt ut labore','2017-12-21 08:10:21','2017-12-21 08:10:24');
112
113/*!40000 ALTER TABLE `partners` ENABLE KEYS */;
114UNLOCK TABLES;
115
116
117# Dump of table password_resets
118# ------------------------------------------------------------
119
120DROP TABLE IF EXISTS `password_resets`;
121
122CREATE TABLE `password_resets` (
123 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
124 `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
125 `created_at` timestamp NULL DEFAULT NULL,
126 KEY `password_resets_email_index` (`email`),
127 KEY `password_resets_token_index` (`token`)
128) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
129
130
131
132# Dump of table prices
133# ------------------------------------------------------------
134
135DROP TABLE IF EXISTS `prices`;
136
137CREATE TABLE `prices` (
138 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
139 `first_10` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
140 `second_10` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
141 `third_10` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
142 `fifth_10` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
143 `tournament_id` int(10) unsigned NOT NULL,
144 `created_at` timestamp NULL DEFAULT NULL,
145 `updated_at` timestamp NULL DEFAULT NULL,
146 `fourth_10` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
147 PRIMARY KEY (`id`),
148 KEY `prices_tournament_id_foreign` (`tournament_id`),
149 CONSTRAINT `prices_tournament_id_foreign` FOREIGN KEY (`tournament_id`) REFERENCES `tournaments` (`id`)
150) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
151
152LOCK TABLES `prices` WRITE;
153/*!40000 ALTER TABLE `prices` DISABLE KEYS */;
154
155INSERT INTO `prices` (`id`, `first_10`, `second_10`, `third_10`, `fifth_10`, `tournament_id`, `created_at`, `updated_at`, `fourth_10`)
156VALUES
157 (2,'25000,- KÄ','15000 ,- KÄ','10000 ,- KÄ','TriÄko Bioraisen',1,'2017-12-19 23:01:09','2017-12-19 23:01:15','5000 ,- KÄ');
158
159/*!40000 ALTER TABLE `prices` ENABLE KEYS */;
160UNLOCK TABLES;
161
162
163# Dump of table records
164# ------------------------------------------------------------
165
166DROP TABLE IF EXISTS `records`;
167
168CREATE TABLE `records` (
169 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
170 `type` tinyint(4) NOT NULL,
171 `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
172 `user_id` int(10) unsigned NOT NULL,
173 `created_at` timestamp NULL DEFAULT NULL,
174 `updated_at` timestamp NULL DEFAULT NULL,
175 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
176 PRIMARY KEY (`id`),
177 KEY `records_user_id_foreign` (`user_id`),
178 CONSTRAINT `records_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
179) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
180
181LOCK TABLES `records` WRITE;
182/*!40000 ALTER TABLE `records` DISABLE KEYS */;
183
184INSERT INTO `records` (`id`, `type`, `url`, `user_id`, `created_at`, `updated_at`, `name`)
185VALUES
186 (1,1,'',1,'2017-12-19 18:26:02','2017-12-19 18:26:12',''),
187 (6,1,'',1,'2017-12-19 18:26:02','2017-12-19 18:26:12',''),
188 (7,1,'',1,'2017-12-19 18:26:02','2017-12-19 18:26:12',''),
189 (10,1,'https://www.youtube.com/watch?v=VhaZGzbkA8M&ab_channel=CristhianCoria',1,'2017-12-19 18:41:09','2017-12-19 18:41:09','LP');
190
191/*!40000 ALTER TABLE `records` ENABLE KEYS */;
192UNLOCK TABLES;
193
194
195# Dump of table scores
196# ------------------------------------------------------------
197
198DROP TABLE IF EXISTS `scores`;
199
200CREATE TABLE `scores` (
201 `game_id` int(10) unsigned NOT NULL,
202 `team_id` int(10) unsigned NOT NULL,
203 `score` int(11) NOT NULL,
204 `created_at` timestamp NULL DEFAULT NULL,
205 `updated_at` timestamp NULL DEFAULT NULL,
206 KEY `scores_game_id_foreign` (`game_id`),
207 KEY `scores_team_id_foreign` (`team_id`),
208 CONSTRAINT `scores_game_id_foreign` FOREIGN KEY (`game_id`) REFERENCES `games` (`id`),
209 CONSTRAINT `scores_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`)
210) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
211
212LOCK TABLES `scores` WRITE;
213/*!40000 ALTER TABLE `scores` DISABLE KEYS */;
214
215INSERT INTO `scores` (`game_id`, `team_id`, `score`, `created_at`, `updated_at`)
216VALUES
217 (1,2,105,'2017-12-20 08:33:54','2017-12-20 08:34:01'),
218 (1,3,80,'2017-12-20 08:33:54','2017-12-20 08:34:01'),
219 (1,6,25,'2017-12-20 08:33:54','2017-12-20 08:34:01'),
220 (2,2,105,'2017-12-20 08:33:54','2017-12-20 08:34:01'),
221 (2,3,80,'2017-12-20 08:33:54','2017-12-20 08:34:01'),
222 (2,6,25,'2017-12-20 08:33:54','2017-12-20 08:34:01'),
223 (3,2,25,'2017-12-20 10:53:08','2017-12-20 10:53:08'),
224 (3,3,105,'2017-12-20 10:53:08','2017-12-20 10:53:08'),
225 (3,6,80,'2017-12-20 10:53:08','2017-12-20 10:53:08');
226
227/*!40000 ALTER TABLE `scores` ENABLE KEYS */;
228UNLOCK TABLES;
229
230
231# Dump of table settings
232# ------------------------------------------------------------
233
234DROP TABLE IF EXISTS `settings`;
235
236CREATE TABLE `settings` (
237 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
238 `footer` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
239 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
240 `discord` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
241 `pass` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
242 `limit` int(11) NOT NULL,
243 `created_at` timestamp NULL DEFAULT NULL,
244 `updated_at` timestamp NULL DEFAULT NULL,
245 PRIMARY KEY (`id`)
246) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
247
248LOCK TABLES `settings` WRITE;
249/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
250
251INSERT INTO `settings` (`id`, `footer`, `email`, `discord`, `pass`, `limit`, `created_at`, `updated_at`)
252VALUES
253 (1,'<span>© 2017, vÅ¡echna práva vyhrazena</span>\r<span>Design by David Sejna (davidsejna [zavináÄ] seznam.cz) | Code by DuÅ¡an Matejka (dusan.matejka [zavináÄ] suiteapplications.eu)</span>','','','',5,NULL,NULL);
254
255/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
256UNLOCK TABLES;
257
258
259# Dump of table teams
260# ------------------------------------------------------------
261
262DROP TABLE IF EXISTS `teams`;
263
264CREATE TABLE `teams` (
265 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
266 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
267 `captain` int(10) unsigned NOT NULL,
268 `created_at` timestamp NULL DEFAULT NULL,
269 `updated_at` timestamp NULL DEFAULT NULL,
270 PRIMARY KEY (`id`),
271 KEY `teams_captain_foreign` (`captain`),
272 CONSTRAINT `teams_captain_foreign` FOREIGN KEY (`captain`) REFERENCES `users` (`id`)
273) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
274
275LOCK TABLES `teams` WRITE;
276/*!40000 ALTER TABLE `teams` DISABLE KEYS */;
277
278INSERT INTO `teams` (`id`, `name`, `captain`, `created_at`, `updated_at`)
279VALUES
280 (2,'team+',1,'2017-12-19 14:51:33','2017-12-19 14:51:33'),
281 (3,'Freaks',5,'2017-12-20 08:24:08','2017-12-20 08:24:15'),
282 (6,'Loosers',12,'2017-12-20 08:24:08','2017-12-20 08:24:15');
283
284/*!40000 ALTER TABLE `teams` ENABLE KEYS */;
285UNLOCK TABLES;
286
287
288# Dump of table teams_users
289# ------------------------------------------------------------
290
291DROP TABLE IF EXISTS `teams_users`;
292
293CREATE TABLE `teams_users` (
294 `user_id` int(10) unsigned NOT NULL,
295 `team_id` int(10) unsigned NOT NULL,
296 `created_at` timestamp NULL DEFAULT NULL,
297 `updated_at` timestamp NULL DEFAULT NULL,
298 KEY `teams_users_user_id_foreign` (`user_id`),
299 KEY `teams_users_team_id_foreign` (`team_id`),
300 CONSTRAINT `teams_users_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`),
301 CONSTRAINT `teams_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
302) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
303
304LOCK TABLES `teams_users` WRITE;
305/*!40000 ALTER TABLE `teams_users` DISABLE KEYS */;
306
307INSERT INTO `teams_users` (`user_id`, `team_id`, `created_at`, `updated_at`)
308VALUES
309 (1,2,'2017-12-19 14:51:33','2017-12-19 14:51:33'),
310 (2,2,'2017-12-19 14:51:33','2017-12-19 14:51:33'),
311 (3,2,'2017-12-19 14:51:33','2017-12-19 14:51:33'),
312 (4,2,'2017-12-19 14:51:33','2017-12-19 14:51:33'),
313 (5,3,'2017-12-20 08:27:40','2017-12-20 08:27:40'),
314 (7,3,'2017-12-20 08:27:40','2017-12-20 08:27:40'),
315 (6,3,'2017-12-20 08:27:40','2017-12-20 08:27:40'),
316 (9,3,'2017-12-20 08:27:40','2017-12-20 08:27:40'),
317 (8,6,'2017-12-20 08:27:40','2017-12-20 08:27:40'),
318 (10,6,'2017-12-20 08:27:40','2017-12-20 08:27:40'),
319 (12,6,'2017-12-20 08:27:40','2017-12-20 08:27:40'),
320 (13,6,'2017-12-20 08:30:01','2017-12-20 08:30:12');
321
322/*!40000 ALTER TABLE `teams_users` ENABLE KEYS */;
323UNLOCK TABLES;
324
325
326# Dump of table tournament_game
327# ------------------------------------------------------------
328
329DROP TABLE IF EXISTS `tournament_game`;
330
331CREATE TABLE `tournament_game` (
332 `tournament_id` int(10) unsigned NOT NULL,
333 `game_id` int(10) unsigned NOT NULL,
334 `created_at` timestamp NULL DEFAULT NULL,
335 `updated_at` timestamp NULL DEFAULT NULL,
336 KEY `tournament_game_tournament_id_foreign` (`tournament_id`),
337 KEY `tournament_game_game_id_foreign` (`game_id`),
338 CONSTRAINT `tournament_game_game_id_foreign` FOREIGN KEY (`game_id`) REFERENCES `games` (`id`),
339 CONSTRAINT `tournament_game_tournament_id_foreign` FOREIGN KEY (`tournament_id`) REFERENCES `tournaments` (`id`)
340) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
341
342LOCK TABLES `tournament_game` WRITE;
343/*!40000 ALTER TABLE `tournament_game` DISABLE KEYS */;
344
345INSERT INTO `tournament_game` (`tournament_id`, `game_id`, `created_at`, `updated_at`)
346VALUES
347 (1,1,'2017-12-19 23:01:46','2017-12-19 23:01:49'),
348 (1,2,'2017-12-19 23:01:46','2017-12-19 23:01:49'),
349 (1,3,'2017-12-20 10:54:24','2017-12-20 10:54:30');
350
351/*!40000 ALTER TABLE `tournament_game` ENABLE KEYS */;
352UNLOCK TABLES;
353
354
355# Dump of table tournament_team
356# ------------------------------------------------------------
357
358DROP TABLE IF EXISTS `tournament_team`;
359
360CREATE TABLE `tournament_team` (
361 `tournament_id` int(10) unsigned NOT NULL,
362 `team_id` int(10) unsigned NOT NULL,
363 `created_at` timestamp NULL DEFAULT NULL,
364 `updated_at` timestamp NULL DEFAULT NULL,
365 KEY `tournament_team_tournament_id_foreign` (`tournament_id`),
366 KEY `tournament_team_team_id_foreign` (`team_id`),
367 CONSTRAINT `tournament_team_team_id_foreign` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`),
368 CONSTRAINT `tournament_team_tournament_id_foreign` FOREIGN KEY (`tournament_id`) REFERENCES `tournaments` (`id`)
369) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
370
371LOCK TABLES `tournament_team` WRITE;
372/*!40000 ALTER TABLE `tournament_team` DISABLE KEYS */;
373
374INSERT INTO `tournament_team` (`tournament_id`, `team_id`, `created_at`, `updated_at`)
375VALUES
376 (1,2,'2017-12-20 08:31:19','2017-12-20 08:31:19'),
377 (1,6,'2017-12-20 08:31:19','2017-12-20 08:31:19'),
378 (1,3,'2017-12-20 08:31:19','2017-12-20 08:31:19');
379
380/*!40000 ALTER TABLE `tournament_team` ENABLE KEYS */;
381UNLOCK TABLES;
382
383
384# Dump of table tournaments
385# ------------------------------------------------------------
386
387DROP TABLE IF EXISTS `tournaments`;
388
389CREATE TABLE `tournaments` (
390 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
391 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
392 `system` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
393 `date` datetime NOT NULL,
394 `created_at` timestamp NULL DEFAULT NULL,
395 `updated_at` timestamp NULL DEFAULT NULL,
396 `registration_from` datetime DEFAULT NULL,
397 `registration_until` datetime DEFAULT NULL,
398 PRIMARY KEY (`id`)
399) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
400
401LOCK TABLES `tournaments` WRITE;
402/*!40000 ALTER TABLE `tournaments` DISABLE KEYS */;
403
404INSERT INTO `tournaments` (`id`, `name`, `system`, `date`, `created_at`, `updated_at`, `registration_from`, `registration_until`)
405VALUES
406 (1,'tur1','system','2017-12-19 22:59:23','2017-12-19 22:59:29','2017-12-19 22:59:32','2017-12-19 22:59:23','2017-12-23 22:59:23');
407
408/*!40000 ALTER TABLE `tournaments` ENABLE KEYS */;
409UNLOCK TABLES;
410
411
412# Dump of table users
413# ------------------------------------------------------------
414
415DROP TABLE IF EXISTS `users`;
416
417CREATE TABLE `users` (
418 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
419 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
420 `nickname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
421 `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
422 `admin` tinyint(4) NOT NULL DEFAULT '0',
423 `active` tinyint(4) NOT NULL DEFAULT '0',
424 `verification_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
425 `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
426 `created_at` timestamp NULL DEFAULT NULL,
427 `updated_at` timestamp NULL DEFAULT NULL,
428 PRIMARY KEY (`id`),
429 UNIQUE KEY `users_email_unique` (`email`),
430 UNIQUE KEY `users_nickname_unique` (`nickname`)
431) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
432
433LOCK TABLES `users` WRITE;
434/*!40000 ALTER TABLE `users` DISABLE KEYS */;
435
436INSERT INTO `users` (`id`, `email`, `nickname`, `password`, `admin`, `active`, `verification_code`, `remember_token`, `created_at`, `updated_at`)
437VALUES
438 (1,'l@d.sl','lukas','$2y$10$6.TO.8rsHEnz5Be5AesZb.BhmsQ6v4GZ2m9zjhIwoe4TJsFrjoUX2',0,1,'BRUvZvvUefQzeJT59J6N','InVwHc1FLDhOJftSy82mrO2NLk7nwXkjYkJU6e3UrGQVq0DZVoLXg3xZEQFm','2017-12-19 14:41:31','2017-12-19 18:55:59'),
439 (2,'l2@d.sk','lukas2','$2y$10$ddxROzhY8qTE2zKrq08Hh.ioDxK1JRP0fXge20S5jFQD4bo6mW/VS',0,1,'M3FX8LruIqWQiTLMJVrM',NULL,'2017-12-19 14:42:05','2017-12-19 14:42:05'),
440 (3,'lul@s.dk','lukas3','$2y$10$UZRh0HjC8V9O3S7U/qhKEOE76mKBpNMOvJgLBYceQe/VFTfvgof4W',0,1,'TSJlDEL8Y8w4VOHjhnLl',NULL,'2017-12-19 14:42:28','2017-12-19 14:42:28'),
441 (4,'ldsd@dsd.sdad','lukas4','$2y$10$2Rg7vrrWRPpURtL2vUm6g.nvaQHLDfRemyf9eQ03hfA29D7AvdL56',0,1,'vcH2rqYyRKEFVRH8qNYM',NULL,'2017-12-19 14:42:57','2017-12-19 14:42:57'),
442 (5,'alf@alf.sk','Alfons','$2y$10$Fu4PZyhsvjij5/G.vrC0vOEez/hEAMuNvLyQGL93uw2P9obydqltm',0,1,'tTGYgQbNLh99J2Ofn45o','RnP5gQvJiDLupB5CMMxapi212ayklXUleiargnHG18OEWiDWOZOFnuB2BPw5','2017-12-19 17:55:42','2017-12-19 18:26:44'),
443 (6,'alf@alf2.sk','Harry','$2y$10$Fu4PZyhsvjij5/G.vrC0vOEez/hEAMuNvLyQGL93uw2P9obydqltm',0,1,'tTGYgQbNLh99J2Ofn45o','RnP5gQvJiDLupB5CMMxapi212ayklXUleiargnHG18OEWiDWOZOFnuB2BPw5','2017-12-19 17:55:42','2017-12-19 18:26:44'),
444 (7,'alf@alf32.sk','Frodo','$2y$10$Fu4PZyhsvjij5/G.vrC0vOEez/hEAMuNvLyQGL93uw2P9obydqltm',0,1,'tTGYgQbNLh99J2Ofn45o','RnP5gQvJiDLupB5CMMxapi212ayklXUleiargnHG18OEWiDWOZOFnuB2BPw5','2017-12-19 17:55:42','2017-12-19 18:26:44'),
445 (8,'alf@alf3s2.sk','Frodoss','$2y$10$Fu4PZyhsvjij5/G.vrC0vOEez/hEAMuNvLyQGL93uw2P9obydqltm',0,1,'tTGYgQbNLh99J2Ofn45o','RnP5gQvJiDLupB5CMMxapi212ayklXUleiargnHG18OEWiDWOZOFnuB2BPw5','2017-12-19 17:55:42','2017-12-19 18:26:44'),
446 (9,'alf@alf3ss2.sk','Query','$2y$10$Fu4PZyhsvjij5/G.vrC0vOEez/hEAMuNvLyQGL93uw2P9obydqltm',0,1,'tTGYgQbNLh99J2Ofn45o','RnP5gQvJiDLupB5CMMxapi212ayklXUleiargnHG18OEWiDWOZOFnuB2BPw5','2017-12-19 17:55:42','2017-12-19 18:26:44'),
447 (10,'alf@alf3sxcxcs2.sk','Dsewss','$2y$10$Fu4PZyhsvjij5/G.vrC0vOEez/hEAMuNvLyQGL93uw2P9obydqltm',0,1,'tTGYgQbNLh99J2Ofn45o','RnP5gQvJiDLupB5CMMxapi212ayklXUleiargnHG18OEWiDWOZOFnuB2BPw5','2017-12-19 17:55:42','2017-12-19 18:26:44'),
448 (12,'das2sd.sk','Moore','$2y$10$Fu4PZyhsvjij5/G.vrC0vOEez/hEAMuNvLyQGL93uw2P9obydqltm',0,1,'tTGYgQbNLh99J2Ofn45o','RnP5gQvJiDLupB5CMMxapi212ayklXUleiargnHG18OEWiDWOZOFnuB2BPw5','2017-12-19 17:55:42','2017-12-19 18:26:44'),
449 (13,'das2sds.sk','NewSK','$2y$10$Fu4PZyhsvjij5/G.vrC0vOEez/hEAMuNvLyQGL93uw2P9obydqltm',0,1,'tTGYgQbNLh99J2Ofn45o','RnP5gQvJiDLupB5CMMxapi212ayklXUleiargnHG18OEWiDWOZOFnuB2BPw5','2017-12-19 17:55:42','2017-12-19 18:26:44'),
450 (14,'lukas.danko1@gmail.com','Gred','$2y$10$SLynxQYmcQapsrtP/dDIEuHbFZ1tYECmwQPz2a2qE9NXe2eAvGVku',1,1,'suyd0azPKYHMSFCAsKDd',NULL,'2017-12-21 10:52:43','2017-12-21 10:52:56');
451
452/*!40000 ALTER TABLE `users` ENABLE KEYS */;
453UNLOCK TABLES;
454
455
456
457/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
458/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
459/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
460/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
461/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
462/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;