· 9 years ago · Nov 05, 2016, 06:54 PM
1-- --------------------------------------------------------
2-- Vært: 127.0.0.1
3-- Server-version: 10.1.16-MariaDB - mariadb.org binary distribution
4-- ServerOS: Win32
5-- HeidiSQL Version: 9.4.0.5125
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14-- Dumping structure for tabel test.cache
15CREATE TABLE IF NOT EXISTS `cache` (
16 `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
17 `value` text COLLATE utf8_unicode_ci NOT NULL,
18 `expiration` int(11) NOT NULL,
19 UNIQUE KEY `cache_key_unique` (`key`)
20) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
21
22-- Dumping data for table test.cache: ~0 rows (approximately)
23/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
24/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
25
26-- Dumping structure for tabel test.drinks
27CREATE TABLE IF NOT EXISTS `drinks` (
28 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
29 `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
30 `data` text COLLATE utf8_unicode_ci NOT NULL,
31 `created_at` timestamp NULL DEFAULT NULL,
32 `updated_at` timestamp NULL DEFAULT NULL,
33 PRIMARY KEY (`id`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
35
36-- Dumping data for table test.drinks: ~0 rows (approximately)
37/*!40000 ALTER TABLE `drinks` DISABLE KEYS */;
38/*!40000 ALTER TABLE `drinks` ENABLE KEYS */;
39
40-- Dumping structure for tabel test.drinks_players
41CREATE TABLE IF NOT EXISTS `drinks_players` (
42 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
43 `player_id` int(11) NOT NULL,
44 `drink_id` int(11) NOT NULL,
45 `data` text COLLATE utf8_unicode_ci NOT NULL,
46 `created_at` timestamp NULL DEFAULT NULL,
47 `updated_at` timestamp NULL DEFAULT NULL,
48 PRIMARY KEY (`id`)
49) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
50
51-- Dumping data for table test.drinks_players: ~0 rows (approximately)
52/*!40000 ALTER TABLE `drinks_players` DISABLE KEYS */;
53/*!40000 ALTER TABLE `drinks_players` ENABLE KEYS */;
54
55-- Dumping structure for tabel test.migrations
56CREATE TABLE IF NOT EXISTS `migrations` (
57 `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
58 `batch` int(11) NOT NULL
59) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
60
61-- Dumping data for table test.migrations: ~17 rows (approximately)
62/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
63INSERT INTO `migrations` (`migration`, `batch`) VALUES
64 ('2014_10_12_000000_create_users_table', 1),
65 ('2014_10_12_100000_create_password_resets_table', 1),
66 ('2016_05_18_034510_tables_init', 1),
67 ('2016_05_18_044250_team_id', 1),
68 ('2016_05_18_044818_player_id', 1),
69 ('2016_05_19_113320_points_table', 1),
70 ('2016_05_19_131029_added_color', 1),
71 ('2016_11_01_214853_create_tours_table', 1),
72 ('2016_11_01_214904_create_stages_table', 1),
73 ('2016_11_01_214908_create_sections_table', 1),
74 ('2016_11_01_215951_softdeletes', 1),
75 ('2016_11_01_222444_PointsBoundToTeam', 1),
76 ('2016_11_03_161906_added_stage_id_to_points', 1),
77 ('2016_11_03_172143_create_cache_table', 1),
78 ('2016_11_03_174756_add_role_to_player', 1),
79 ('2016_11_04_160444_make_stageid_on_point_nullable', 1),
80 ('2016_11_04_163438_added_type_to_section', 1);
81/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
82
83-- Dumping structure for tabel test.password_resets
84CREATE TABLE IF NOT EXISTS `password_resets` (
85 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
86 `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
87 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
88 KEY `password_resets_email_index` (`email`),
89 KEY `password_resets_token_index` (`token`)
90) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
91
92-- Dumping data for table test.password_resets: ~0 rows (approximately)
93/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
94/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
95
96-- Dumping structure for tabel test.players
97CREATE TABLE IF NOT EXISTS `players` (
98 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
99 `team_id` int(11) NOT NULL,
100 `role` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
101 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
102 `data` text COLLATE utf8_unicode_ci NOT NULL,
103 `created_at` timestamp NULL DEFAULT NULL,
104 `updated_at` timestamp NULL DEFAULT NULL,
105 `deleted_at` timestamp NULL DEFAULT NULL,
106 PRIMARY KEY (`id`)
107) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
108
109-- Dumping data for table test.players: ~12 rows (approximately)
110/*!40000 ALTER TABLE `players` DISABLE KEYS */;
111INSERT INTO `players` (`id`, `team_id`, `role`, `name`, `data`, `created_at`, `updated_at`, `deleted_at`) VALUES
112 (1, 1, 'captain', 'Test', '', '2016-11-05 13:55:48', '2016-11-05 13:55:56', '2016-11-05 13:55:56'),
113 (2, 2, 'captain', 'TOBIAS', '', '2016-11-05 14:08:17', '2016-11-05 14:13:52', '2016-11-05 14:13:52'),
114 (3, 3, 'captain', 'Skodsæk', '', '2016-11-05 14:17:31', '2016-11-05 14:17:31', NULL),
115 (4, 3, '', 'Lysdal', '', '2016-11-05 14:17:59', '2016-11-05 14:17:59', NULL),
116 (5, 3, '', 'Tobias', '', '2016-11-05 14:18:13', '2016-11-05 14:18:13', NULL),
117 (6, 3, 'sprinter', 'Ølle', '', '2016-11-05 14:18:20', '2016-11-05 14:18:20', NULL),
118 (7, 3, 'mountain', 'Mark', '', '2016-11-05 14:18:48', '2016-11-05 14:18:48', NULL),
119 (8, 4, '', 'Karl Emil', '', '2016-11-05 14:21:08', '2016-11-05 14:21:08', NULL),
120 (9, 4, 'mountain', 'Frederik', '', '2016-11-05 14:21:22', '2016-11-05 14:21:22', NULL),
121 (10, 4, 'captain', 'Dan', '', '2016-11-05 14:22:29', '2016-11-05 14:22:29', NULL),
122 (11, 4, '', 'Just', '', '2016-11-05 14:22:49', '2016-11-05 14:22:49', NULL),
123 (12, 4, 'sprinter', 'Mads', '', '2016-11-05 14:23:00', '2016-11-05 14:23:00', NULL);
124/*!40000 ALTER TABLE `players` ENABLE KEYS */;
125
126-- Dumping structure for tabel test.points
127CREATE TABLE IF NOT EXISTS `points` (
128 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
129 `player_id` int(11) NOT NULL,
130 `stage_id` int(11) DEFAULT NULL,
131 `team_id` int(11) NOT NULL,
132 `points` int(11) NOT NULL,
133 `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
134 `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
135 `data` text COLLATE utf8_unicode_ci NOT NULL,
136 `deleted_at` timestamp NULL DEFAULT NULL,
137 `created_at` timestamp NULL DEFAULT NULL,
138 `updated_at` timestamp NULL DEFAULT NULL,
139 PRIMARY KEY (`id`)
140) ENGINE=InnoDB AUTO_INCREMENT=175 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
141
142-- Dumping data for table test.points: ~174 rows (approximately)
143/*!40000 ALTER TABLE `points` DISABLE KEYS */;
144INSERT INTO `points` (`id`, `player_id`, `stage_id`, `team_id`, `points`, `type`, `description`, `data`, `deleted_at`, `created_at`, `updated_at`) VALUES
145 (1, 1, NULL, 1, 1, 'beer', 'Test har drukket 1 øl', '', '2016-11-05 13:56:08', '2016-11-05 13:55:51', '2016-11-05 13:56:08'),
146 (2, 1, NULL, 1, 1, 'beer', 'Test har drukket 1 øl', '', '2016-11-05 13:56:06', '2016-11-05 13:55:52', '2016-11-05 13:56:06'),
147 (3, 1, NULL, 1, 1, 'beer', 'Test har drukket 1 øl', '', '2016-11-05 13:56:07', '2016-11-05 13:55:52', '2016-11-05 13:56:07'),
148 (4, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 14:43:12', '2016-11-05 14:43:12'),
149 (5, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 14:43:13', '2016-11-05 14:43:13'),
150 (6, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 14:43:14', '2016-11-05 14:43:14'),
151 (7, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', '2016-11-05 14:43:54', '2016-11-05 14:43:40', '2016-11-05 14:43:54'),
152 (8, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', '2016-11-05 14:43:55', '2016-11-05 14:43:47', '2016-11-05 14:43:55'),
153 (9, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 14:43:48', '2016-11-05 14:43:48'),
154 (10, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', NULL, '2016-11-05 14:44:15', '2016-11-05 14:44:15'),
155 (11, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 14:44:17', '2016-11-05 14:44:17'),
156 (12, 6, NULL, 3, 1, 'beer', 'Ølle har drukket 1 øl', '', NULL, '2016-11-05 14:44:18', '2016-11-05 14:44:18'),
157 (13, 7, NULL, 3, 1, 'beer', 'Mark har drukket 1 øl', '', NULL, '2016-11-05 14:44:20', '2016-11-05 14:44:20'),
158 (14, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 14:44:21', '2016-11-05 14:44:21'),
159 (15, 9, NULL, 4, 1, 'beer', 'Frederik har drukket 1 øl', '', NULL, '2016-11-05 14:44:34', '2016-11-05 14:44:34'),
160 (16, 11, NULL, 4, 1, 'beer', 'Just har drukket 1 øl', '', NULL, '2016-11-05 14:44:39', '2016-11-05 14:44:39'),
161 (17, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', '2016-11-05 14:46:25', '2016-11-05 14:46:22', '2016-11-05 14:46:25'),
162 (18, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 14:49:32', '2016-11-05 14:49:32'),
163 (19, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 14:53:58', '2016-11-05 14:53:58'),
164 (20, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 14:54:12', '2016-11-05 14:54:12'),
165 (21, 6, NULL, 3, 12, 'sprint', 'Ølle kom #1 i en sprint og har vundet 12', '', NULL, '2016-11-05 14:55:07', '2016-11-05 14:55:07'),
166 (22, 9, NULL, 4, 9, 'sprint', 'Frederik kom #2 i en sprint og har vundet 9', '', NULL, '2016-11-05 14:55:07', '2016-11-05 14:55:07'),
167 (23, 8, NULL, 4, 6, 'sprint', 'Karl Emil kom #3 i en sprint og har vundet 6', '', NULL, '2016-11-05 14:55:07', '2016-11-05 14:55:07'),
168 (24, 11, NULL, 4, 3, 'sprint', 'Just kom #4 i en sprint og har vundet 3', '', NULL, '2016-11-05 14:55:07', '2016-11-05 14:55:07'),
169 (25, 11, NULL, 4, 1, 'beer', 'Just har drukket 1 øl', '', NULL, '2016-11-05 14:55:14', '2016-11-05 14:55:14'),
170 (26, 6, NULL, 3, 1, 'beer', 'Ølle har drukket 1 øl', '', NULL, '2016-11-05 14:55:15', '2016-11-05 14:55:15'),
171 (27, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 14:55:25', '2016-11-05 14:55:25'),
172 (28, 9, NULL, 4, 1, 'beer', 'Frederik har drukket 1 øl', '', NULL, '2016-11-05 14:55:27', '2016-11-05 14:55:27'),
173 (29, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 14:55:31', '2016-11-05 14:55:31'),
174 (30, 9, NULL, 4, 5, 'mountain', 'Frederik har vundet 5 bjerg points', '', NULL, '2016-11-05 14:59:29', '2016-11-05 14:59:29'),
175 (31, 7, NULL, 3, 5, 'mountain', 'Mark har vundet 5 bjerg points', '', NULL, '2016-11-05 14:59:34', '2016-11-05 14:59:34'),
176 (32, 5, NULL, 3, 3, 'mountain', 'Tobias har vundet 3 bjerg points', '', NULL, '2016-11-05 14:59:38', '2016-11-05 14:59:38'),
177 (33, 3, NULL, 3, 1, 'mountain', 'Skodsæk har vundet 1 bjerg points', '', NULL, '2016-11-05 14:59:40', '2016-11-05 14:59:40'),
178 (34, 4, NULL, 3, 1, 'mountain', 'Lysdal har vundet 1 bjerg points', '', NULL, '2016-11-05 14:59:41', '2016-11-05 14:59:41'),
179 (35, 6, NULL, 3, 1, 'mountain', 'Ølle har vundet 1 bjerg points', '', NULL, '2016-11-05 14:59:43', '2016-11-05 14:59:43'),
180 (36, 11, NULL, 4, 1, 'mountain', 'Just har vundet 1 bjerg points', '', NULL, '2016-11-05 14:59:48', '2016-11-05 14:59:48'),
181 (37, 10, NULL, 4, 1, 'mountain', 'Dan har vundet 1 bjerg points', '', NULL, '2016-11-05 14:59:49', '2016-11-05 14:59:49'),
182 (38, 8, NULL, 4, 1, 'mountain', 'Karl Emil har vundet 1 bjerg points', '', NULL, '2016-11-05 14:59:51', '2016-11-05 14:59:51'),
183 (39, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 15:00:19', '2016-11-05 15:00:19'),
184 (40, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', NULL, '2016-11-05 15:00:50', '2016-11-05 15:00:50'),
185 (41, 7, NULL, 3, 1, 'beer', 'Mark har drukket 1 øl', '', NULL, '2016-11-05 15:01:29', '2016-11-05 15:01:29'),
186 (42, 9, NULL, 4, 1, 'beer', 'Frederik har drukket 1 øl', '', NULL, '2016-11-05 15:01:43', '2016-11-05 15:01:43'),
187 (43, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 15:01:54', '2016-11-05 15:01:54'),
188 (44, 6, NULL, 3, 1, 'beer', 'Ølle har drukket 1 øl', '', NULL, '2016-11-05 15:02:48', '2016-11-05 15:02:48'),
189 (45, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 15:02:57', '2016-11-05 15:02:57'),
190 (46, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 15:05:35', '2016-11-05 15:05:35'),
191 (47, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 15:05:52', '2016-11-05 15:05:52'),
192 (48, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 15:19:39', '2016-11-05 15:19:39'),
193 (49, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 15:24:49', '2016-11-05 15:24:49'),
194 (50, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 15:25:02', '2016-11-05 15:25:02'),
195 (51, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 15:25:06', '2016-11-05 15:25:06'),
196 (52, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 15:27:04', '2016-11-05 15:27:04'),
197 (53, 11, NULL, 4, 1, 'beer', 'Just har drukket 1 øl', '', NULL, '2016-11-05 15:27:15', '2016-11-05 15:27:15'),
198 (54, 7, NULL, 3, 1, 'beer', 'Mark har drukket 1 øl', '', NULL, '2016-11-05 15:27:48', '2016-11-05 15:27:48'),
199 (55, 12, NULL, 4, 1, 'beer', 'Mads har drukket 1 øl', '', NULL, '2016-11-05 15:28:54', '2016-11-05 15:28:54'),
200 (56, 6, NULL, 3, 1, 'beer', 'Ølle har drukket 1 øl', '', NULL, '2016-11-05 15:28:56', '2016-11-05 15:28:56'),
201 (57, 12, NULL, 4, 12, 'sprint', 'Mads kom #1 i en sprint og har vundet 12', '', NULL, '2016-11-05 15:29:06', '2016-11-05 15:29:06'),
202 (58, 6, NULL, 3, 9, 'sprint', 'Ølle kom #2 i en sprint og har vundet 9', '', NULL, '2016-11-05 15:29:06', '2016-11-05 15:29:06'),
203 (59, 7, NULL, 3, 6, 'mountain', 'Mark har vundet 6 bjerg points', '', NULL, '2016-11-05 15:32:39', '2016-11-05 15:32:39'),
204 (60, 9, NULL, 4, 6, 'mountain', 'Frederik har vundet 6 bjerg points', '', NULL, '2016-11-05 15:32:46', '2016-11-05 15:32:46'),
205 (61, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', NULL, '2016-11-05 15:32:49', '2016-11-05 15:32:49'),
206 (62, 3, NULL, 3, 1, 'mountain', 'Skodsæk har vundet 1 bjerg points', '', NULL, '2016-11-05 15:32:51', '2016-11-05 15:32:51'),
207 (63, 4, NULL, 3, 1, 'mountain', 'Lysdal har vundet 1 bjerg points', '', NULL, '2016-11-05 15:32:52', '2016-11-05 15:32:52'),
208 (64, 5, NULL, 3, 1, 'mountain', 'Tobias har vundet 1 bjerg points', '', NULL, '2016-11-05 15:32:54', '2016-11-05 15:32:54'),
209 (65, 6, NULL, 3, 1, 'mountain', 'Ølle har vundet 1 bjerg points', '', NULL, '2016-11-05 15:32:56', '2016-11-05 15:32:56'),
210 (66, 8, NULL, 4, 1, 'mountain', 'Karl Emil har vundet 1 bjerg points', '', NULL, '2016-11-05 15:32:57', '2016-11-05 15:32:57'),
211 (67, 9, NULL, 4, 1, 'mountain', 'Frederik har vundet 1 bjerg points', '', '2016-11-05 15:34:54', '2016-11-05 15:32:58', '2016-11-05 15:34:54'),
212 (68, 10, NULL, 4, 1, 'mountain', 'Dan har vundet 1 bjerg points', '', NULL, '2016-11-05 15:33:00', '2016-11-05 15:33:00'),
213 (69, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 15:37:00', '2016-11-05 15:37:00'),
214 (70, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 15:37:58', '2016-11-05 15:37:58'),
215 (71, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 15:38:01', '2016-11-05 15:38:01'),
216 (72, 7, NULL, 3, 1, 'beer', 'Mark har drukket 1 øl', '', NULL, '2016-11-05 15:38:49', '2016-11-05 15:38:49'),
217 (73, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', NULL, '2016-11-05 15:39:03', '2016-11-05 15:39:03'),
218 (74, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 15:39:10', '2016-11-05 15:39:10'),
219 (75, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 16:00:10', '2016-11-05 16:00:10'),
220 (76, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 16:00:11', '2016-11-05 16:00:11'),
221 (77, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 16:00:13', '2016-11-05 16:00:13'),
222 (78, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', NULL, '2016-11-05 16:00:16', '2016-11-05 16:00:16'),
223 (79, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 16:00:17', '2016-11-05 16:00:17'),
224 (80, 6, NULL, 3, 1, 'beer', 'Ølle har drukket 1 øl', '', NULL, '2016-11-05 16:00:18', '2016-11-05 16:00:18'),
225 (81, 7, NULL, 3, 1, 'beer', 'Mark har drukket 1 øl', '', NULL, '2016-11-05 16:00:20', '2016-11-05 16:00:20'),
226 (82, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 16:00:21', '2016-11-05 16:00:21'),
227 (83, 9, NULL, 4, 1, 'beer', 'Frederik har drukket 1 øl', '', NULL, '2016-11-05 16:00:23', '2016-11-05 16:00:23'),
228 (84, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 16:00:24', '2016-11-05 16:00:24'),
229 (85, 11, NULL, 4, 1, 'beer', 'Just har drukket 1 øl', '', NULL, '2016-11-05 16:00:26', '2016-11-05 16:00:26'),
230 (86, 12, NULL, 4, 1, 'beer', 'Mads har drukket 1 øl', '', NULL, '2016-11-05 16:00:29', '2016-11-05 16:00:29'),
231 (87, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 16:05:35', '2016-11-05 16:05:35'),
232 (88, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 16:05:42', '2016-11-05 16:05:42'),
233 (89, 12, NULL, 4, 12, 'sprint', 'Mads kom #1 i en sprint og har vundet 12', '', NULL, '2016-11-05 16:07:28', '2016-11-05 16:07:28'),
234 (90, 6, NULL, 3, 9, 'sprint', 'Ølle kom #2 i en sprint og har vundet 9', '', NULL, '2016-11-05 16:07:28', '2016-11-05 16:07:28'),
235 (91, 7, NULL, 3, 5, 'mountain', 'Mark har vundet 5 bjerg points', '', NULL, '2016-11-05 16:11:17', '2016-11-05 16:11:17'),
236 (92, 9, NULL, 4, 3, 'mountain', 'Frederik har vundet 3 bjerg points', '', NULL, '2016-11-05 16:11:22', '2016-11-05 16:11:22'),
237 (93, 5, NULL, 3, 1, 'mountain', 'Tobias har vundet 1 bjerg points', '', NULL, '2016-11-05 16:11:26', '2016-11-05 16:11:26'),
238 (94, 4, NULL, 3, 1, 'mountain', 'Lysdal har vundet 1 bjerg points', '', NULL, '2016-11-05 16:11:27', '2016-11-05 16:11:27'),
239 (95, 6, NULL, 3, 1, 'mountain', 'Ølle har vundet 1 bjerg points', '', NULL, '2016-11-05 16:11:28', '2016-11-05 16:11:28'),
240 (96, 12, NULL, 4, 1, 'mountain', 'Mads har vundet 1 bjerg points', '', NULL, '2016-11-05 16:11:30', '2016-11-05 16:11:30'),
241 (97, 11, NULL, 4, 1, 'mountain', 'Just har vundet 1 bjerg points', '', NULL, '2016-11-05 16:11:33', '2016-11-05 16:11:33'),
242 (98, 10, NULL, 4, 1, 'mountain', 'Dan har vundet 1 bjerg points', '', NULL, '2016-11-05 16:11:35', '2016-11-05 16:11:35'),
243 (99, 8, NULL, 4, 1, 'mountain', 'Karl Emil har vundet 1 bjerg points', '', NULL, '2016-11-05 16:11:37', '2016-11-05 16:11:37'),
244 (100, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 16:11:44', '2016-11-05 16:11:44'),
245 (101, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 16:16:15', '2016-11-05 16:16:15'),
246 (102, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', NULL, '2016-11-05 16:16:20', '2016-11-05 16:16:20'),
247 (103, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 16:17:10', '2016-11-05 16:17:10'),
248 (104, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 16:17:45', '2016-11-05 16:17:45'),
249 (105, 6, NULL, 3, 12, 'sprint', 'Ølle kom #1 i en sprint og har vundet 12', '', NULL, '2016-11-05 16:29:48', '2016-11-05 16:29:48'),
250 (106, 12, NULL, 4, 9, 'sprint', 'Mads kom #2 i en sprint og har vundet 9', '', NULL, '2016-11-05 16:29:48', '2016-11-05 16:29:48'),
251 (107, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 16:31:08', '2016-11-05 16:31:08'),
252 (108, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 16:31:32', '2016-11-05 16:31:32'),
253 (109, 11, NULL, 4, 1, 'beer', 'Just har drukket 1 øl', '', NULL, '2016-11-05 16:32:33', '2016-11-05 16:32:33'),
254 (110, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 16:33:12', '2016-11-05 16:33:12'),
255 (111, 6, NULL, 3, 12, 'sprint', 'Ølle kom #1 i en sprint og har vundet 12', '', NULL, '2016-11-05 16:34:14', '2016-11-05 16:34:14'),
256 (112, 12, NULL, 4, 9, 'sprint', 'Mads kom #2 i en sprint og har vundet 9', '', NULL, '2016-11-05 16:34:14', '2016-11-05 16:34:14'),
257 (113, 9, NULL, 4, 2, 'mountain', 'Frederik har vundet 2 bjerg points', '', NULL, '2016-11-05 16:37:58', '2016-11-05 16:37:58'),
258 (114, 8, NULL, 4, 1, 'mountain', 'Karl Emil har vundet 1 bjerg points', '', NULL, '2016-11-05 16:37:59', '2016-11-05 16:37:59'),
259 (115, 10, NULL, 4, 1, 'mountain', 'Dan har vundet 1 bjerg points', '', NULL, '2016-11-05 16:38:00', '2016-11-05 16:38:00'),
260 (116, 11, NULL, 4, 1, 'mountain', 'Just har vundet 1 bjerg points', '', NULL, '2016-11-05 16:38:01', '2016-11-05 16:38:01'),
261 (117, 12, NULL, 4, 1, 'mountain', 'Mads har vundet 1 bjerg points', '', NULL, '2016-11-05 16:38:02', '2016-11-05 16:38:02'),
262 (118, 7, NULL, 3, 1, 'mountain', 'Mark har vundet 1 bjerg points', '', NULL, '2016-11-05 16:38:03', '2016-11-05 16:38:03'),
263 (119, 6, NULL, 3, 1, 'mountain', 'Ølle har vundet 1 bjerg points', '', NULL, '2016-11-05 16:38:04', '2016-11-05 16:38:04'),
264 (120, 5, NULL, 3, 1, 'mountain', 'Tobias har vundet 1 bjerg points', '', NULL, '2016-11-05 16:38:05', '2016-11-05 16:38:05'),
265 (121, 4, NULL, 3, 1, 'mountain', 'Lysdal har vundet 1 bjerg points', '', NULL, '2016-11-05 16:38:06', '2016-11-05 16:38:06'),
266 (122, 3, NULL, 3, 1, 'mountain', 'Skodsæk har vundet 1 bjerg points', '', NULL, '2016-11-05 16:38:07', '2016-11-05 16:38:07'),
267 (123, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', NULL, '2016-11-05 16:39:09', '2016-11-05 16:39:09'),
268 (124, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 16:39:27', '2016-11-05 16:39:27'),
269 (125, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 16:41:52', '2016-11-05 16:41:52'),
270 (126, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 16:42:07', '2016-11-05 16:42:07'),
271 (127, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 16:42:40', '2016-11-05 16:42:40'),
272 (128, 11, NULL, 4, 1, 'beer', 'Just har drukket 1 øl', '', NULL, '2016-11-05 16:43:01', '2016-11-05 16:43:01'),
273 (129, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', NULL, '2016-11-05 16:43:03', '2016-11-05 16:43:03'),
274 (130, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 16:43:59', '2016-11-05 16:43:59'),
275 (131, 7, NULL, 3, 1, 'beer', 'Mark har drukket 1 øl', '', NULL, '2016-11-05 16:44:26', '2016-11-05 16:44:26'),
276 (132, 6, NULL, 3, 12, 'sprint', 'Ølle kom #1 i en sprint og har vundet 12', '', NULL, '2016-11-05 16:45:33', '2016-11-05 16:45:33'),
277 (133, 12, NULL, 4, 9, 'sprint', 'Mads kom #2 i en sprint og har vundet 9', '', NULL, '2016-11-05 16:45:33', '2016-11-05 16:45:33'),
278 (134, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 17:08:58', '2016-11-05 17:08:58'),
279 (135, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 17:10:31', '2016-11-05 17:10:31'),
280 (136, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', NULL, '2016-11-05 17:11:12', '2016-11-05 17:11:12'),
281 (137, 11, NULL, 4, 1, 'beer', 'Just har drukket 1 øl', '', NULL, '2016-11-05 17:11:41', '2016-11-05 17:11:41'),
282 (138, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 17:12:02', '2016-11-05 17:12:02'),
283 (139, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 17:12:46', '2016-11-05 17:12:46'),
284 (140, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 17:13:29', '2016-11-05 17:13:29'),
285 (141, 6, NULL, 3, 12, 'sprint', 'Ølle kom #1 i en sprint og har vundet 12', '', NULL, '2016-11-05 17:14:33', '2016-11-05 17:14:33'),
286 (142, 12, NULL, 4, 9, 'sprint', 'Mads kom #2 i en sprint og har vundet 9', '', NULL, '2016-11-05 17:14:34', '2016-11-05 17:14:34'),
287 (143, 9, NULL, 4, 6, 'mountain', 'Frederik har vundet 6 bjerg points', '', NULL, '2016-11-05 17:18:42', '2016-11-05 17:18:42'),
288 (144, 7, NULL, 3, 6, 'mountain', 'Mark har vundet 6 bjerg points', '', NULL, '2016-11-05 17:18:48', '2016-11-05 17:18:48'),
289 (145, 4, NULL, 3, 1, 'mountain', 'Lysdal har vundet 1 bjerg points', '', NULL, '2016-11-05 17:18:52', '2016-11-05 17:18:52'),
290 (146, 8, NULL, 4, 1, 'mountain', 'Karl Emil har vundet 1 bjerg points', '', NULL, '2016-11-05 17:18:54', '2016-11-05 17:18:54'),
291 (147, 10, NULL, 4, 1, 'mountain', 'Dan har vundet 1 bjerg points', '', NULL, '2016-11-05 17:18:56', '2016-11-05 17:18:56'),
292 (148, 11, NULL, 4, 1, 'mountain', 'Just har vundet 1 bjerg points', '', NULL, '2016-11-05 17:18:57', '2016-11-05 17:18:57'),
293 (149, 12, NULL, 4, 1, 'mountain', 'Mads har vundet 1 bjerg points', '', NULL, '2016-11-05 17:18:59', '2016-11-05 17:18:59'),
294 (150, 11, NULL, 4, 1, 'beer', 'Just har drukket 1 øl', '', NULL, '2016-11-05 17:22:22', '2016-11-05 17:22:22'),
295 (151, 11, NULL, 4, 1, 'beer', 'Just har drukket 1 øl', '', NULL, '2016-11-05 17:53:43', '2016-11-05 17:53:43'),
296 (152, 12, NULL, 4, 12, 'sprint', 'Mads kom #1 i en sprint og har vundet 12', '', NULL, '2016-11-05 17:55:10', '2016-11-05 17:55:10'),
297 (153, 9, NULL, 4, 5, 'mountain', 'Frederik har vundet 5 bjerg points', '', NULL, '2016-11-05 17:58:52', '2016-11-05 17:58:52'),
298 (154, 7, NULL, 3, 4, 'mountain', 'Mark har vundet 4 bjerg points', '', NULL, '2016-11-05 17:58:57', '2016-11-05 17:58:57'),
299 (155, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 17:59:05', '2016-11-05 17:59:05'),
300 (156, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 17:59:54', '2016-11-05 17:59:54'),
301 (157, 12, NULL, 4, 12, 'sprint', 'Mads kom #1 i en sprint og har vundet 12', '', NULL, '2016-11-05 17:59:57', '2016-11-05 17:59:57'),
302 (158, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', NULL, '2016-11-05 18:02:21', '2016-11-05 18:02:21'),
303 (159, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', NULL, '2016-11-05 18:04:11', '2016-11-05 18:04:11'),
304 (160, 10, NULL, 4, 1, 'beer', 'Dan har drukket 1 øl', '', '2016-11-05 18:04:51', '2016-11-05 18:04:46', '2016-11-05 18:04:51'),
305 (161, 11, NULL, 4, 1, 'beer', 'Just har drukket 1 øl', '', NULL, '2016-11-05 18:04:47', '2016-11-05 18:04:47'),
306 (162, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 18:14:41', '2016-11-05 18:14:41'),
307 (163, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 18:14:42', '2016-11-05 18:14:42'),
308 (164, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 18:14:44', '2016-11-05 18:14:44'),
309 (165, 4, NULL, 3, 1, 'beer', 'Lysdal har drukket 1 øl', '', NULL, '2016-11-05 18:14:46', '2016-11-05 18:14:46'),
310 (166, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 18:14:47', '2016-11-05 18:14:47'),
311 (167, 11, NULL, 4, 1, 'beer', 'Just har drukket 1 øl', '', NULL, '2016-11-05 18:22:24', '2016-11-05 18:22:24'),
312 (168, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 18:24:13', '2016-11-05 18:24:13'),
313 (169, 9, NULL, 4, 4, 'mountain', 'Frederik har vundet 4 bjerg points', '', NULL, '2016-11-05 18:24:26', '2016-11-05 18:24:26'),
314 (170, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 18:24:34', '2016-11-05 18:24:34'),
315 (171, 5, NULL, 3, 1, 'beer', 'Tobias har drukket 1 øl', '', NULL, '2016-11-05 18:27:56', '2016-11-05 18:27:56'),
316 (172, 3, NULL, 3, 1, 'beer', 'Skodsæk har drukket 1 øl', '', NULL, '2016-11-05 18:29:03', '2016-11-05 18:29:03'),
317 (173, 8, NULL, 4, 1, 'beer', 'Karl Emil har drukket 1 øl', '', NULL, '2016-11-05 18:29:18', '2016-11-05 18:29:18'),
318 (174, 12, NULL, 4, 12, 'sprint', 'Mads kom #1 i en sprint og har vundet 12', '', NULL, '2016-11-05 18:30:10', '2016-11-05 18:30:10');
319/*!40000 ALTER TABLE `points` ENABLE KEYS */;
320
321-- Dumping structure for tabel test.sections
322CREATE TABLE IF NOT EXISTS `sections` (
323 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
324 `stage_id` int(11) NOT NULL,
325 `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
326 `length` time NOT NULL,
327 `deleted_at` timestamp NULL DEFAULT NULL,
328 `created_at` timestamp NULL DEFAULT NULL,
329 `updated_at` timestamp NULL DEFAULT NULL,
330 PRIMARY KEY (`id`)
331) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
332
333-- Dumping data for table test.sections: ~0 rows (approximately)
334/*!40000 ALTER TABLE `sections` DISABLE KEYS */;
335/*!40000 ALTER TABLE `sections` ENABLE KEYS */;
336
337-- Dumping structure for tabel test.stages
338CREATE TABLE IF NOT EXISTS `stages` (
339 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
340 `tour_id` int(10) unsigned NOT NULL,
341 `stageNo` int(11) NOT NULL,
342 `type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
343 `length` time NOT NULL,
344 `deleted_at` timestamp NULL DEFAULT NULL,
345 `created_at` timestamp NULL DEFAULT NULL,
346 `updated_at` timestamp NULL DEFAULT NULL,
347 PRIMARY KEY (`id`)
348) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
349
350-- Dumping data for table test.stages: ~0 rows (approximately)
351/*!40000 ALTER TABLE `stages` DISABLE KEYS */;
352/*!40000 ALTER TABLE `stages` ENABLE KEYS */;
353
354-- Dumping structure for tabel test.teams
355CREATE TABLE IF NOT EXISTS `teams` (
356 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
357 `player_id` int(11) NOT NULL,
358 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
359 `color` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
360 `data` text COLLATE utf8_unicode_ci NOT NULL,
361 `created_at` timestamp NULL DEFAULT NULL,
362 `updated_at` timestamp NULL DEFAULT NULL,
363 `deleted_at` timestamp NULL DEFAULT NULL,
364 PRIMARY KEY (`id`)
365) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
366
367-- Dumping data for table test.teams: ~4 rows (approximately)
368/*!40000 ALTER TABLE `teams` DISABLE KEYS */;
369INSERT INTO `teams` (`id`, `player_id`, `name`, `color`, `data`, `created_at`, `updated_at`, `deleted_at`) VALUES
370 (1, 0, 'Test', 'red', '', '2016-11-05 13:55:43', '2016-11-05 13:56:02', '2016-11-05 13:56:02'),
371 (2, 0, 'TEST', 'red', '', '2016-11-05 14:08:09', '2016-11-05 14:13:54', '2016-11-05 14:13:54'),
372 (3, 0, 'Hold 1', 'red', '', '2016-11-05 14:16:51', '2016-11-05 14:16:51', NULL),
373 (4, 0, 'Hold 2', 'green', '', '2016-11-05 14:17:02', '2016-11-05 14:17:02', NULL);
374/*!40000 ALTER TABLE `teams` ENABLE KEYS */;
375
376-- Dumping structure for tabel test.tours
377CREATE TABLE IF NOT EXISTS `tours` (
378 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
379 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
380 `deleted_at` timestamp NULL DEFAULT NULL,
381 `created_at` timestamp NULL DEFAULT NULL,
382 `updated_at` timestamp NULL DEFAULT NULL,
383 PRIMARY KEY (`id`)
384) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
385
386-- Dumping data for table test.tours: ~0 rows (approximately)
387/*!40000 ALTER TABLE `tours` DISABLE KEYS */;
388/*!40000 ALTER TABLE `tours` ENABLE KEYS */;
389
390-- Dumping structure for tabel test.users
391CREATE TABLE IF NOT EXISTS `users` (
392 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
393 `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
394 `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
395 `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
396 `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
397 `created_at` timestamp NULL DEFAULT NULL,
398 `updated_at` timestamp NULL DEFAULT NULL,
399 PRIMARY KEY (`id`),
400 UNIQUE KEY `users_email_unique` (`email`)
401) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
402
403-- Dumping data for table test.users: ~1 rows (approximately)
404/*!40000 ALTER TABLE `users` DISABLE KEYS */;
405INSERT INTO `users` (`id`, `name`, `email`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
406 (1, 'chomsky', 'noam@erdermerekaffe.dk', '$2y$10$gYR5YqILgMX9siLBpCmLnegKhx/0TrLAxINVBQ1l09jwY3RGLLIFq', NULL, NULL, NULL);
407/*!40000 ALTER TABLE `users` ENABLE KEYS */;
408
409/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
410/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
411/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;