· 7 years ago · Dec 05, 2018, 10:46 AM
1-- MySQL dump 10.13 Distrib 5.7.21, for macos10.13 (x86_64)
2--
3-- Host: 127.0.0.1 Database: wgame
4-- ------------------------------------------------------
5-- Server version 5.7.21
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `flatshares`
20--
21
22DROP TABLE IF EXISTS `flatshares`;
23/*!40101 SET @saved_cs_client = @@character_set_client */;
24/*!40101 SET character_set_client = utf8 */;
25CREATE TABLE `flatshares` (
26 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
27 `admin_id` int(10) unsigned DEFAULT NULL,
28 `flatsharename` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
29 `created_at` timestamp NULL DEFAULT NULL,
30 `updated_at` timestamp NULL DEFAULT NULL,
31 `count_roommates` int(11) DEFAULT '1',
32 `password` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
33 PRIMARY KEY (`id`),
34 KEY `flatshares_admin_id_foreign` (`admin_id`),
35 CONSTRAINT `flatshares_admin_id_foreign` FOREIGN KEY (`admin_id`) REFERENCES `users` (`id`)
36) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `flatshares`
41--
42
43LOCK TABLES `flatshares` WRITE;
44/*!40000 ALTER TABLE `flatshares` DISABLE KEYS */;
45INSERT INTO `flatshares` VALUES (1,3,'Testwg123',NULL,NULL,5,'test123'),(2,NULL,'TestWg2',NULL,NULL,4,'test123'),(9,2,'test123','2018-11-07 13:59:20','2018-11-07 13:59:20',5,'12345'),(10,4,'arsch oder titten wg','2018-11-21 09:58:43','2018-11-21 09:58:43',5,'123456789');
46/*!40000 ALTER TABLE `flatshares` ENABLE KEYS */;
47UNLOCK TABLES;
48
49--
50-- Table structure for table `flatshares_jobs`
51--
52
53DROP TABLE IF EXISTS `flatshares_jobs`;
54/*!40101 SET @saved_cs_client = @@character_set_client */;
55/*!40101 SET character_set_client = utf8 */;
56CREATE TABLE `flatshares_jobs` (
57 `id` int(11) NOT NULL AUTO_INCREMENT,
58 `flatshare_id` int(11) NOT NULL,
59 `title` varchar(255) NOT NULL,
60 `status_id` int(11) NOT NULL DEFAULT '1',
61 `score` int(11) NOT NULL DEFAULT '10',
62 `updated_at` datetime DEFAULT NULL,
63 `created_at` datetime DEFAULT NULL,
64 `turnus` int(11) NOT NULL,
65 PRIMARY KEY (`id`),
66 UNIQUE KEY `flatshares_jobs_id_uindex` (`id`)
67) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
68/*!40101 SET character_set_client = @saved_cs_client */;
69
70--
71-- Dumping data for table `flatshares_jobs`
72--
73
74LOCK TABLES `flatshares_jobs` WRITE;
75/*!40000 ALTER TABLE `flatshares_jobs` DISABLE KEYS */;
76INSERT INTO `flatshares_jobs` VALUES (4,10,'tes',1,12,'2018-11-18 15:34:09','2018-11-18 15:34:09',14),(5,10,'manns vernichten',1,12,'2018-11-18 22:06:19','2018-11-18 22:06:19',3),(6,9,'test',1,12,'2018-11-21 19:55:56','2018-11-21 19:55:56',9),(7,9,'test2',1,15,'2018-11-26 16:02:02','2018-11-26 16:02:02',5),(8,9,'Klo putzen',1,12,'2018-12-05 08:43:59','2018-12-05 08:43:59',3),(9,9,'Küche putzen',1,13,'2018-12-05 08:49:43','2018-12-05 08:49:43',2),(10,9,'test',1,12,'2018-12-05 09:13:01','2018-12-05 09:13:01',3);
77/*!40000 ALTER TABLE `flatshares_jobs` ENABLE KEYS */;
78UNLOCK TABLES;
79
80--
81-- Table structure for table `migrations`
82--
83
84DROP TABLE IF EXISTS `migrations`;
85/*!40101 SET @saved_cs_client = @@character_set_client */;
86/*!40101 SET character_set_client = utf8 */;
87CREATE TABLE `migrations` (
88 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
89 `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
90 `batch` int(11) NOT NULL,
91 PRIMARY KEY (`id`)
92) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
93/*!40101 SET character_set_client = @saved_cs_client */;
94
95--
96-- Dumping data for table `migrations`
97--
98
99LOCK TABLES `migrations` WRITE;
100/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
101INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2016_06_01_000001_create_oauth_auth_codes_table',1),(4,'2016_06_01_000002_create_oauth_access_tokens_table',1),(5,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(6,'2016_06_01_000004_create_oauth_clients_table',1),(7,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(8,'2018_09_18_201400_create_user_roles_table',1);
102/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
103UNLOCK TABLES;
104
105--
106-- Table structure for table `oauth_access_tokens`
107--
108
109DROP TABLE IF EXISTS `oauth_access_tokens`;
110/*!40101 SET @saved_cs_client = @@character_set_client */;
111/*!40101 SET character_set_client = utf8 */;
112CREATE TABLE `oauth_access_tokens` (
113 `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
114 `user_id` int(11) DEFAULT NULL,
115 `client_id` int(11) NOT NULL,
116 `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
117 `scopes` text COLLATE utf8mb4_unicode_ci,
118 `revoked` tinyint(1) NOT NULL,
119 `created_at` timestamp NULL DEFAULT NULL,
120 `updated_at` timestamp NULL DEFAULT NULL,
121 `expires_at` datetime DEFAULT NULL,
122 PRIMARY KEY (`id`),
123 KEY `oauth_access_tokens_user_id_index` (`user_id`)
124) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
125/*!40101 SET character_set_client = @saved_cs_client */;
126
127--
128-- Dumping data for table `oauth_access_tokens`
129--
130
131LOCK TABLES `oauth_access_tokens` WRITE;
132/*!40000 ALTER TABLE `oauth_access_tokens` DISABLE KEYS */;
133/*!40000 ALTER TABLE `oauth_access_tokens` ENABLE KEYS */;
134UNLOCK TABLES;
135
136--
137-- Table structure for table `oauth_auth_codes`
138--
139
140DROP TABLE IF EXISTS `oauth_auth_codes`;
141/*!40101 SET @saved_cs_client = @@character_set_client */;
142/*!40101 SET character_set_client = utf8 */;
143CREATE TABLE `oauth_auth_codes` (
144 `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
145 `user_id` int(11) NOT NULL,
146 `client_id` int(11) NOT NULL,
147 `scopes` text COLLATE utf8mb4_unicode_ci,
148 `revoked` tinyint(1) NOT NULL,
149 `expires_at` datetime DEFAULT NULL,
150 PRIMARY KEY (`id`)
151) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
152/*!40101 SET character_set_client = @saved_cs_client */;
153
154--
155-- Dumping data for table `oauth_auth_codes`
156--
157
158LOCK TABLES `oauth_auth_codes` WRITE;
159/*!40000 ALTER TABLE `oauth_auth_codes` DISABLE KEYS */;
160/*!40000 ALTER TABLE `oauth_auth_codes` ENABLE KEYS */;
161UNLOCK TABLES;
162
163--
164-- Table structure for table `oauth_clients`
165--
166
167DROP TABLE IF EXISTS `oauth_clients`;
168/*!40101 SET @saved_cs_client = @@character_set_client */;
169/*!40101 SET character_set_client = utf8 */;
170CREATE TABLE `oauth_clients` (
171 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
172 `user_id` int(11) DEFAULT NULL,
173 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
174 `secret` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
175 `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
176 `personal_access_client` tinyint(1) NOT NULL,
177 `password_client` tinyint(1) NOT NULL,
178 `revoked` tinyint(1) NOT NULL,
179 `created_at` timestamp NULL DEFAULT NULL,
180 `updated_at` timestamp NULL DEFAULT NULL,
181 PRIMARY KEY (`id`),
182 KEY `oauth_clients_user_id_index` (`user_id`)
183) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
184/*!40101 SET character_set_client = @saved_cs_client */;
185
186--
187-- Dumping data for table `oauth_clients`
188--
189
190LOCK TABLES `oauth_clients` WRITE;
191/*!40000 ALTER TABLE `oauth_clients` DISABLE KEYS */;
192/*!40000 ALTER TABLE `oauth_clients` ENABLE KEYS */;
193UNLOCK TABLES;
194
195--
196-- Table structure for table `oauth_personal_access_clients`
197--
198
199DROP TABLE IF EXISTS `oauth_personal_access_clients`;
200/*!40101 SET @saved_cs_client = @@character_set_client */;
201/*!40101 SET character_set_client = utf8 */;
202CREATE TABLE `oauth_personal_access_clients` (
203 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
204 `client_id` int(11) NOT NULL,
205 `created_at` timestamp NULL DEFAULT NULL,
206 `updated_at` timestamp NULL DEFAULT NULL,
207 PRIMARY KEY (`id`),
208 KEY `oauth_personal_access_clients_client_id_index` (`client_id`)
209) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
210/*!40101 SET character_set_client = @saved_cs_client */;
211
212--
213-- Dumping data for table `oauth_personal_access_clients`
214--
215
216LOCK TABLES `oauth_personal_access_clients` WRITE;
217/*!40000 ALTER TABLE `oauth_personal_access_clients` DISABLE KEYS */;
218/*!40000 ALTER TABLE `oauth_personal_access_clients` ENABLE KEYS */;
219UNLOCK TABLES;
220
221--
222-- Table structure for table `oauth_refresh_tokens`
223--
224
225DROP TABLE IF EXISTS `oauth_refresh_tokens`;
226/*!40101 SET @saved_cs_client = @@character_set_client */;
227/*!40101 SET character_set_client = utf8 */;
228CREATE TABLE `oauth_refresh_tokens` (
229 `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
230 `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
231 `revoked` tinyint(1) NOT NULL,
232 `expires_at` datetime DEFAULT NULL,
233 PRIMARY KEY (`id`),
234 KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
235) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
236/*!40101 SET character_set_client = @saved_cs_client */;
237
238--
239-- Dumping data for table `oauth_refresh_tokens`
240--
241
242LOCK TABLES `oauth_refresh_tokens` WRITE;
243/*!40000 ALTER TABLE `oauth_refresh_tokens` DISABLE KEYS */;
244/*!40000 ALTER TABLE `oauth_refresh_tokens` ENABLE KEYS */;
245UNLOCK TABLES;
246
247--
248-- Table structure for table `password_resets`
249--
250
251DROP TABLE IF EXISTS `password_resets`;
252/*!40101 SET @saved_cs_client = @@character_set_client */;
253/*!40101 SET character_set_client = utf8 */;
254CREATE TABLE `password_resets` (
255 `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
256 `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
257 `created_at` timestamp NULL DEFAULT NULL,
258 KEY `password_resets_email_index` (`email`)
259) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
260/*!40101 SET character_set_client = @saved_cs_client */;
261
262--
263-- Dumping data for table `password_resets`
264--
265
266LOCK TABLES `password_resets` WRITE;
267/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
268/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
269UNLOCK TABLES;
270
271--
272-- Table structure for table `user_flatshare_jobs`
273--
274
275DROP TABLE IF EXISTS `user_flatshare_jobs`;
276/*!40101 SET @saved_cs_client = @@character_set_client */;
277/*!40101 SET character_set_client = utf8 */;
278CREATE TABLE `user_flatshare_jobs` (
279 `id` int(11) NOT NULL AUTO_INCREMENT,
280 `user_id` int(11) NOT NULL,
281 `flatshare_jobs_id` int(11) NOT NULL,
282 `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
283 `updated_at` datetime DEFAULT NULL,
284 `duration` int(11) DEFAULT NULL,
285 `state` int(11) DEFAULT NULL,
286 PRIMARY KEY (`id`),
287 UNIQUE KEY `user_flatshare_jobs_id_uindex` (`id`),
288 KEY `user_flatshare_jobs_flatshares_jobs_id_fk` (`flatshare_jobs_id`),
289 CONSTRAINT `user_flatshare_jobs_flatshares_jobs_id_fk` FOREIGN KEY (`flatshare_jobs_id`) REFERENCES `flatshares_jobs` (`id`) ON DELETE CASCADE
290) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
291/*!40101 SET character_set_client = @saved_cs_client */;
292
293--
294-- Dumping data for table `user_flatshare_jobs`
295--
296
297LOCK TABLES `user_flatshare_jobs` WRITE;
298/*!40000 ALTER TABLE `user_flatshare_jobs` DISABLE KEYS */;
299INSERT INTO `user_flatshare_jobs` VALUES (26,1,4,'2018-11-26 16:01:16','2018-11-26 17:01:16',10,1),(27,1,5,'2018-11-26 16:01:28','2018-11-26 17:01:28',10,1),(29,2,7,'2018-11-26 16:02:19','2018-11-26 17:02:19',112,1);
300/*!40000 ALTER TABLE `user_flatshare_jobs` ENABLE KEYS */;
301UNLOCK TABLES;
302
303--
304-- Table structure for table `user_flatshares`
305--
306
307DROP TABLE IF EXISTS `user_flatshares`;
308/*!40101 SET @saved_cs_client = @@character_set_client */;
309/*!40101 SET character_set_client = utf8 */;
310CREATE TABLE `user_flatshares` (
311 `id` int(11) NOT NULL AUTO_INCREMENT,
312 `user_id` int(11) NOT NULL,
313 `flatshare_id` int(11) NOT NULL,
314 PRIMARY KEY (`id`),
315 UNIQUE KEY `user_flatshares_id_uindex` (`id`),
316 UNIQUE KEY `user_flatshares_user_id_uindex` (`user_id`)
317) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
318/*!40101 SET character_set_client = @saved_cs_client */;
319
320--
321-- Dumping data for table `user_flatshares`
322--
323
324LOCK TABLES `user_flatshares` WRITE;
325/*!40000 ALTER TABLE `user_flatshares` DISABLE KEYS */;
326INSERT INTO `user_flatshares` VALUES (1,1,1);
327/*!40000 ALTER TABLE `user_flatshares` ENABLE KEYS */;
328UNLOCK TABLES;
329
330--
331-- Table structure for table `user_roles`
332--
333
334DROP TABLE IF EXISTS `user_roles`;
335/*!40101 SET @saved_cs_client = @@character_set_client */;
336/*!40101 SET character_set_client = utf8 */;
337CREATE TABLE `user_roles` (
338 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
339 `userid` int(11) DEFAULT NULL,
340 `roleid` int(11) NOT NULL,
341 `created_at` timestamp NULL DEFAULT NULL,
342 `updated_at` timestamp NULL DEFAULT NULL,
343 PRIMARY KEY (`id`)
344) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
345/*!40101 SET character_set_client = @saved_cs_client */;
346
347--
348-- Dumping data for table `user_roles`
349--
350
351LOCK TABLES `user_roles` WRITE;
352/*!40000 ALTER TABLE `user_roles` DISABLE KEYS */;
353/*!40000 ALTER TABLE `user_roles` ENABLE KEYS */;
354UNLOCK TABLES;
355
356--
357-- Table structure for table `users`
358--
359
360DROP TABLE IF EXISTS `users`;
361/*!40101 SET @saved_cs_client = @@character_set_client */;
362/*!40101 SET character_set_client = utf8 */;
363CREATE TABLE `users` (
364 `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
365 `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
366 `lastname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
367 `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
368 `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
369 `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
370 `created_at` timestamp NULL DEFAULT NULL,
371 `updated_at` timestamp NULL DEFAULT NULL,
372 `flatshares_id` int(11) DEFAULT NULL,
373 `isAdmin` tinyint(1) NOT NULL DEFAULT '0',
374 PRIMARY KEY (`id`),
375 UNIQUE KEY `users_email_unique` (`email`),
376 UNIQUE KEY `users__id_unique` (`id`)
377) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
378/*!40101 SET character_set_client = @saved_cs_client */;
379
380--
381-- Dumping data for table `users`
382--
383
384LOCK TABLES `users` WRITE;
385/*!40000 ALTER TABLE `users` DISABLE KEYS */;
386INSERT INTO `users` VALUES (1,'Robin','Decker','robin.decker@stud.eah-jena.de','$2y$10$RJefGWVfnbp05UVYn9sDEeyA18hJmJfCASvG6wO98KY3sefVgJyR.','aQGDRm05O0rAjtVE90gET1WrwUJUurUY6vqlnEtkK05qdr7l5x1C0shmjxOK','2018-10-18 07:27:58','2018-11-07 15:20:57',9,0),(2,'Malte','Krekeler','maltekrekeler@web.de','$2y$10$u7PL6siBG4DWyKeuXwePpuxfpU.vB.TolCIjsLYh0juU/u6m7EXyO','tXD3yHjPM3xCPrLMsiOtXqJNaFCX60FvmpDbdolwdfxabyu1w7ZLDvHJVUWH','2018-10-19 09:12:04','2018-10-19 09:12:04',9,0),(3,'André','Weihermüller','robindtechno@gmail.com','$2y$10$saE.U4USEXJUbii1fHFf7.qrF2Kds3dawamo78amhzRbiGGKrkYFS','yLKaBBsziW78ImQwIVod2yASFK0Za8akFUxSJMAa07jEvlR5FxmqPud8KOmi','2018-10-19 09:12:48','2018-10-19 09:12:48',9,0),(4,'Robin2','Decker','a.w@bla.de','$2y$10$J5MuBxqcvF9Pvx0Skj3W/ewEMuKybBHL55JWZnCBXv9Lou6/NP/yS',NULL,'2018-11-21 09:58:22','2018-11-21 09:58:43',10,0);
387/*!40000 ALTER TABLE `users` ENABLE KEYS */;
388UNLOCK TABLES;
389/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
390
391/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
392/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
393/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
394/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
395/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
396/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
397/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
398
399-- Dump completed on 2018-12-05 10:18:06