T0kRxx1P

1CREATE DATABASE  IF NOT EXISTS `lessgo_production` /*!40100 DEFAULT CHARACTER SET utf8 */;
2USE `lessgo_production`;
3-- MySQL dump 10.13  Distrib 5.7.17, for macos10.12 (x86_64)
4--
5-- Host: ls-d3ea1ab8c9bc460c593ae31e10395d10a3da5c0d.c8ubdzgojcqo.eu-central-1.rds.amazonaws.com    Database: lessgo_production
6-- ------------------------------------------------------
7-- Server version	5.7.26-log
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
20SET @@SESSION.SQL_LOG_BIN= 0;
21
22--
23-- GTID state at the beginning of the backup 
24--
25
26SET @@GLOBAL.GTID_PURGED='';
27
28--
29-- Table structure for table `cars`
30--
31
32DROP TABLE IF EXISTS `cars`;
33/*!40101 SET @saved_cs_client     = @@character_set_client */;
34/*!40101 SET character_set_client = utf8 */;
35CREATE TABLE `cars` (
36  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
37  `patente` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
38  `description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
39  `user_id` int(10) unsigned NOT NULL,
40  `created_at` timestamp NULL DEFAULT NULL,
41  `updated_at` timestamp NULL DEFAULT NULL,
42  PRIMARY KEY (`id`),
43  KEY `cars_user_id_foreign` (`user_id`),
44  CONSTRAINT `cars_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
45) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
46/*!40101 SET character_set_client = @saved_cs_client */;
47
48--
49-- Dumping data for table `cars`
50--
51
52LOCK TABLES `cars` WRITE;
53/*!40000 ALTER TABLE `cars` DISABLE KEYS */;
54INSERT INTO `cars` VALUES (1,'72-71718','NOT USED YET',1,'2019-08-01 21:00:56','2019-08-01 21:00:56'),(2,'24-58326','NOT USED YET',28,'2019-08-03 00:23:44','2019-08-03 00:23:44'),(3,'15-10685','NOT USED YET',9,'2019-08-03 12:16:41','2019-08-03 12:16:41'),(4,'21-66402','NOT USED YET',15,'2019-08-04 09:25:49','2019-08-04 09:25:49'),(5,'12-31232','NOT USED YET',30,'2019-08-04 14:46:30','2019-08-04 14:46:30');
55/*!40000 ALTER TABLE `cars` ENABLE KEYS */;
56UNLOCK TABLES;
57
58--
59-- Table structure for table `conversations`
60--
61
62DROP TABLE IF EXISTS `conversations`;
63/*!40101 SET @saved_cs_client     = @@character_set_client */;
64/*!40101 SET character_set_client = utf8 */;
65CREATE TABLE `conversations` (
66  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
67  `type` int(11) NOT NULL,
68  `title` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
69  `trip_id` int(10) unsigned DEFAULT NULL,
70  `created_at` timestamp NULL DEFAULT NULL,
71  `updated_at` timestamp NULL DEFAULT NULL,
72  `deleted_at` timestamp NULL DEFAULT NULL,
73  PRIMARY KEY (`id`),
74  KEY `conversations_trip_id_foreign` (`trip_id`),
75  CONSTRAINT `conversations_trip_id_foreign` FOREIGN KEY (`trip_id`) REFERENCES `trips` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
76) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
77/*!40101 SET character_set_client = @saved_cs_client */;
78
79--
80-- Dumping data for table `conversations`
81--
82
83LOCK TABLES `conversations` WRITE;
84/*!40000 ALTER TABLE `conversations` DISABLE KEYS */;
85INSERT INTO `conversations` VALUES (1,0,'',NULL,'2019-08-01 23:31:41','2019-08-04 19:25:59',NULL),(2,0,'',NULL,'2019-08-04 16:26:29','2019-08-04 16:52:29',NULL);
86/*!40000 ALTER TABLE `conversations` ENABLE KEYS */;
87UNLOCK TABLES;
88
89--
90-- Table structure for table `conversations_users`
91--
92
93DROP TABLE IF EXISTS `conversations_users`;
94/*!40101 SET @saved_cs_client     = @@character_set_client */;
95/*!40101 SET character_set_client = utf8 */;
96CREATE TABLE `conversations_users` (
97  `conversation_id` int(10) unsigned NOT NULL,
98  `user_id` int(10) unsigned NOT NULL,
99  `created_at` timestamp NULL DEFAULT NULL,
100  `updated_at` timestamp NULL DEFAULT NULL,
101  `read` tinyint(1) NOT NULL,
102  KEY `conversations_users_conversation_id_foreign` (`conversation_id`),
103  KEY `conversations_users_user_id_foreign` (`user_id`),
104  CONSTRAINT `conversations_users_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
105  CONSTRAINT `conversations_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
106) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
107/*!40101 SET character_set_client = @saved_cs_client */;
108
109--
110-- Dumping data for table `conversations_users`
111--
112
113LOCK TABLES `conversations_users` WRITE;
114/*!40000 ALTER TABLE `conversations_users` DISABLE KEYS */;
115INSERT INTO `conversations_users` VALUES (1,1,'2019-08-01 23:31:41','2019-08-04 19:16:03',1),(1,3,'2019-08-01 23:31:41','2019-08-04 21:07:18',1),(2,1,'2019-08-04 16:26:29','2019-08-04 19:10:12',1),(2,30,'2019-08-04 16:26:29','2019-08-04 22:11:21',1);
116/*!40000 ALTER TABLE `conversations_users` ENABLE KEYS */;
117UNLOCK TABLES;
118
119--
120-- Table structure for table `donations`
121--
122
123DROP TABLE IF EXISTS `donations`;
124/*!40101 SET @saved_cs_client     = @@character_set_client */;
125/*!40101 SET character_set_client = utf8 */;
126CREATE TABLE `donations` (
127  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
128  `user_id` int(10) unsigned NOT NULL,
129  `month` datetime NOT NULL,
130  `has_donated` tinyint(1) NOT NULL,
131  `has_denied` tinyint(1) NOT NULL,
132  `ammount` int(10) unsigned NOT NULL,
133  `created_at` timestamp NULL DEFAULT NULL,
134  `updated_at` timestamp NULL DEFAULT NULL,
135  `trip_id` int(10) unsigned DEFAULT NULL,
136  PRIMARY KEY (`id`),
137  KEY `donations_user_id_foreign` (`user_id`),
138  CONSTRAINT `donations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
139) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
140/*!40101 SET character_set_client = @saved_cs_client */;
141
142--
143-- Dumping data for table `donations`
144--
145
146LOCK TABLES `donations` WRITE;
147/*!40000 ALTER TABLE `donations` DISABLE KEYS */;
148/*!40000 ALTER TABLE `donations` ENABLE KEYS */;
149UNLOCK TABLES;
150
151--
152-- Table structure for table `friends`
153--
154
155DROP TABLE IF EXISTS `friends`;
156/*!40101 SET @saved_cs_client     = @@character_set_client */;
157/*!40101 SET character_set_client = utf8 */;
158CREATE TABLE `friends` (
159  `uid1` int(10) unsigned NOT NULL,
160  `uid2` int(10) unsigned NOT NULL,
161  `origin` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
162  `state` int(11) NOT NULL,
163  `created_at` timestamp NULL DEFAULT NULL,
164  `updated_at` timestamp NULL DEFAULT NULL,
165  KEY `friends_uid1_foreign` (`uid1`),
166  KEY `friends_uid2_foreign` (`uid2`),
167  CONSTRAINT `friends_uid1_foreign` FOREIGN KEY (`uid1`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
168  CONSTRAINT `friends_uid2_foreign` FOREIGN KEY (`uid2`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
169) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
170/*!40101 SET character_set_client = @saved_cs_client */;
171
172--
173-- Dumping data for table `friends`
174--
175
176LOCK TABLES `friends` WRITE;
177/*!40000 ALTER TABLE `friends` DISABLE KEYS */;
178/*!40000 ALTER TABLE `friends` ENABLE KEYS */;
179UNLOCK TABLES;
180
181--
182-- Table structure for table `jobs`
183--
184
185DROP TABLE IF EXISTS `jobs`;
186/*!40101 SET @saved_cs_client     = @@character_set_client */;
187/*!40101 SET character_set_client = utf8 */;
188CREATE TABLE `jobs` (
189  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
190  `queue` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
191  `payload` longtext COLLATE utf8_unicode_ci NOT NULL,
192  `attempts` tinyint(3) unsigned NOT NULL,
193  `reserved` tinyint(3) unsigned NOT NULL,
194  `reserved_at` int(10) unsigned DEFAULT NULL,
195  `available_at` int(10) unsigned NOT NULL,
196  `created_at` int(10) unsigned NOT NULL,
197  PRIMARY KEY (`id`),
198  KEY `jobs_queue_reserved_reserved_at_index` (`queue`,`reserved`,`reserved_at`)
199) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
200/*!40101 SET character_set_client = @saved_cs_client */;
201
202--
203-- Dumping data for table `jobs`
204--
205
206LOCK TABLES `jobs` WRITE;
207/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
208/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
209UNLOCK TABLES;
210
211--
212-- Table structure for table `messages`
213--
214
215DROP TABLE IF EXISTS `messages`;
216/*!40101 SET @saved_cs_client     = @@character_set_client */;
217/*!40101 SET character_set_client = utf8 */;
218CREATE TABLE `messages` (
219  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
220  `text` text COLLATE utf8_unicode_ci NOT NULL,
221  `estado` int(11) NOT NULL,
222  `user_id` int(10) unsigned NOT NULL,
223  `conversation_id` int(10) unsigned NOT NULL,
224  `created_at` timestamp NULL DEFAULT NULL,
225  `updated_at` timestamp NULL DEFAULT NULL,
226  PRIMARY KEY (`id`),
227  KEY `messages_user_id_foreign` (`user_id`),
228  KEY `messages_conversation_id_foreign` (`conversation_id`),
229  CONSTRAINT `messages_conversation_id_foreign` FOREIGN KEY (`conversation_id`) REFERENCES `conversations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
230  CONSTRAINT `messages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
231) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
232/*!40101 SET character_set_client = @saved_cs_client */;
233
234--
235-- Dumping data for table `messages`
236--
237
238LOCK TABLES `messages` WRITE;
239/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
240INSERT INTO `messages` VALUES (1,'abc',0,3,1,'2019-08-02 12:15:36','2019-08-02 12:15:36'),(2,'123',0,3,1,'2019-08-02 12:15:44','2019-08-02 12:15:44'),(3,' Did you hack me? ',0,3,1,'2019-08-02 23:34:00','2019-08-02 23:34:00'),(4,'hi',0,3,1,'2019-08-03 01:41:15','2019-08-03 01:41:15'),(5,'Sjjsjssjus',0,1,1,'2019-08-03 14:09:41','2019-08-03 14:09:41'),(6,'No ',0,1,1,'2019-08-03 14:09:49','2019-08-03 14:09:49'),(7,'Test',0,1,1,'2019-08-04 15:40:56','2019-08-04 15:40:56'),(8,'hello',0,1,2,'2019-08-04 16:26:33','2019-08-04 16:26:33'),(9,'hello',0,1,2,'2019-08-04 16:50:25','2019-08-04 16:50:25'),(10,'test',0,1,2,'2019-08-04 16:52:29','2019-08-04 16:52:29'),(11,'كيفك',0,3,1,'2019-08-04 17:20:27','2019-08-04 17:20:27'),(12,'لا',0,3,1,'2019-08-04 17:27:22','2019-08-04 17:27:22'),(13,'faster test',0,1,1,'2019-08-04 18:00:06','2019-08-04 18:00:06'),(14,'why zs so slow',0,1,1,'2019-08-04 18:00:16','2019-08-04 18:00:16'),(15,'!!',0,1,1,'2019-08-04 18:00:19','2019-08-04 18:00:19'),(16,'test',0,1,1,'2019-08-04 18:00:33','2019-08-04 18:00:33'),(17,'-_-',0,1,1,'2019-08-04 18:00:40','2019-08-04 18:00:40'),(18,'again test',0,1,1,'2019-08-04 19:07:20','2019-08-04 19:07:20'),(19,'test',0,1,1,'2019-08-04 19:07:33','2019-08-04 19:07:33'),(20,'again',0,1,1,'2019-08-04 19:09:08','2019-08-04 19:09:08'),(21,'and again',0,1,1,'2019-08-04 19:15:49','2019-08-04 19:15:49'),(22,' Y',0,3,1,'2019-08-04 19:25:59','2019-08-04 19:25:59');
241/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
242UNLOCK TABLES;
243
244--
245-- Table structure for table `migrations`
246--
247
248DROP TABLE IF EXISTS `migrations`;
249/*!40101 SET @saved_cs_client     = @@character_set_client */;
250/*!40101 SET character_set_client = utf8 */;
251CREATE TABLE `migrations` (
252  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
253  `batch` int(11) NOT NULL
254) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
255/*!40101 SET character_set_client = @saved_cs_client */;
256
257--
258-- Dumping data for table `migrations`
259--
260
261LOCK TABLES `migrations` WRITE;
262/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
263INSERT INTO `migrations` VALUES ('2014_10_12_000000_create_users_table',1),('2014_10_12_100000_create_password_resets_table',1),('2016_09_14_143722_devices_table',1),('2016_09_14_143841_friends_table',1),('2016_09_14_144645_conversations_table',1),('2016_09_14_144841_messages_table',1),('2016_09_14_145401_trips_table',1),('2016_09_15_111148_trip_passengers_table',1),('2016_09_15_111401_recurrent_trip_day_table',1),('2016_09_15_111534_calificaciones_table',1),('2016_09_15_115020_social_accounts_table',1),('2016_12_27_122959_trips_points_table',1),('2017_02_04_140901_conversations_user_table',1),('2017_02_04_142909_conversation_trips_foreign',1),('2017_03_15_032813_add_unread_to_conversations_user',1),('2017_03_15_160928_user_message_read',1),('2017_03_16_190317_add_trip_return_field',1),('2017_03_17_114307_create_cars_table',1),('2017_03_17_125226_add_cars_field_trips',1),('2017_03_22_192208_create_table_notifications',1),('2017_03_22_192246_create_table_notifications_params',1),('2017_04_12_165701_add_notifications_field_devices',1),('2017_05_09_143145_add_last_conenection_user',1),('2017_05_18_095245_add_canceled_state',1),('2017_07_24_191841_change_co2_type',1),('2017_07_27_170421_create_jobs_table',1),('2017_08_05_075232_add_has_pin',1),('2018_04_14_075232_rating_is_available',1),('2018_04_16_180352_subscription_table',1),('2018_05_09_192208_create_table_donations',1),('2018_05_15_173403_UpdateRatingsAvailable',1),('2018_09_01_075232_add_is_member',1),('2018_12_30_075232_donation_trip',1),('2019_01_27_075232_users_monthly_donate',1),('2019_02_06_012418_set_user_nullable_fields',1),('2019_02_09_162026_add_parent_trip_id',1),('2019_02_09_171613_set_trip_nullable_fields',1),('2019_02_12_075232_users_messages_remember',1),('2019_07_18_075232_suscription_is_passenger',1);
264/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
265UNLOCK TABLES;
266
267--
268-- Table structure for table `notifications`
269--
270
271DROP TABLE IF EXISTS `notifications`;
272/*!40101 SET @saved_cs_client     = @@character_set_client */;
273/*!40101 SET character_set_client = utf8 */;
274CREATE TABLE `notifications` (
275  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
276  `user_id` int(10) unsigned NOT NULL,
277  `type` text COLLATE utf8_unicode_ci NOT NULL,
278  `read_at` datetime DEFAULT NULL,
279  `deleted_at` datetime DEFAULT NULL,
280  `created_at` timestamp NULL DEFAULT NULL,
281  `updated_at` timestamp NULL DEFAULT NULL,
282  PRIMARY KEY (`id`),
283  KEY `notifications_user_id_foreign` (`user_id`),
284  CONSTRAINT `notifications_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
285) ENGINE=InnoDB AUTO_INCREMENT=166 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
286/*!40101 SET character_set_client = @saved_cs_client */;
287
288--
289-- Dumping data for table `notifications`
290--
291
292LOCK TABLES `notifications` WRITE;
293/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
294INSERT INTO `notifications` VALUES (1,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:57:14',NULL,'2019-08-01 23:23:46','2019-08-04 19:57:14'),(2,3,'STS\\Notifications\\AcceptPassengerNotification','2019-08-04 19:58:44',NULL,'2019-08-01 23:24:20','2019-08-04 19:58:44'),(3,3,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:58:44',NULL,'2019-08-01 23:24:58','2019-08-04 19:58:44'),(4,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:57:14',NULL,'2019-08-01 23:25:12','2019-08-04 19:57:14'),(5,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:28:37','2019-08-03 00:37:36'),(6,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:28:42','2019-08-03 00:37:36'),(7,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:28:44','2019-08-03 00:37:36'),(8,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:28:47','2019-08-03 00:37:36'),(9,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:28:49','2019-08-03 00:37:36'),(10,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:28:52','2019-08-03 00:37:36'),(11,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:28:53','2019-08-03 00:37:36'),(12,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:29:03','2019-08-03 00:37:36'),(13,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:29:04','2019-08-03 00:37:36'),(14,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:29:05','2019-08-03 00:37:36'),(15,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:29:07','2019-08-03 00:37:36'),(16,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:29:09','2019-08-03 00:37:36'),(17,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:29:10','2019-08-03 00:37:36'),(18,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:29:11','2019-08-03 00:37:36'),(19,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:29:13','2019-08-03 00:37:36'),(20,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:30:01','2019-08-03 00:37:36'),(21,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:30:03','2019-08-03 00:37:36'),(22,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:36',NULL,'2019-08-03 00:30:04','2019-08-03 00:37:36'),(23,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:07','2019-08-03 00:37:35'),(24,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:09','2019-08-03 00:37:35'),(25,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:12','2019-08-03 00:37:35'),(26,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:13','2019-08-03 00:37:35'),(27,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:18','2019-08-03 00:37:35'),(28,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:33','2019-08-03 00:37:35'),(29,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:34','2019-08-03 00:37:35'),(30,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:36','2019-08-03 00:37:35'),(31,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:38','2019-08-03 00:37:35'),(32,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:39','2019-08-03 00:37:35'),(33,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:40','2019-08-03 00:37:35'),(34,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:50','2019-08-03 00:37:35'),(35,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:30:52','2019-08-03 00:37:35'),(36,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:32:02','2019-08-03 00:37:35'),(37,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:32:04','2019-08-03 00:37:35'),(38,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:32:06','2019-08-03 00:37:35'),(39,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:32:08','2019-08-03 00:37:35'),(40,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:32:09','2019-08-03 00:37:35'),(41,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:32:15','2019-08-03 00:37:35'),(42,8,'STS\\Notifications\\SubscriptionMatchNotification','2019-08-03 00:37:35',NULL,'2019-08-03 00:32:23','2019-08-03 00:37:35'),(43,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:58:44',NULL,'2019-08-03 02:46:28','2019-08-04 19:58:44'),(44,3,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:58:43',NULL,'2019-08-03 02:46:41','2019-08-04 19:58:43'),(45,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:58:43',NULL,'2019-08-03 14:08:40','2019-08-04 19:58:43'),(46,1,'STS\\Notifications\\AcceptPassengerNotification','2019-08-04 19:57:14',NULL,'2019-08-03 14:08:52','2019-08-04 19:57:14'),(47,1,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:57:14',NULL,'2019-08-03 14:11:50','2019-08-04 19:57:14'),(48,3,'STS\\Notifications\\AcceptPassengerNotification','2019-08-04 19:58:43',NULL,'2019-08-04 14:42:23','2019-08-04 19:58:43'),(49,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:57:14',NULL,'2019-08-04 14:46:46','2019-08-04 19:57:14'),(50,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:57:14',NULL,'2019-08-04 14:46:52','2019-08-04 19:57:14'),(51,3,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:58:43',NULL,'2019-08-04 14:54:17','2019-08-04 19:58:43'),(52,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 15:43:03','2019-08-04 19:57:13'),(53,30,'STS\\Notifications\\AcceptPassengerNotification','2019-08-04 19:24:11',NULL,'2019-08-04 16:00:32','2019-08-04 19:24:11'),(54,30,'STS\\Notifications\\NewMessageNotification','2019-08-04 19:24:11',NULL,'2019-08-04 16:50:25','2019-08-04 19:24:11'),(55,30,'STS\\Notifications\\NewMessageNotification','2019-08-04 19:24:11',NULL,'2019-08-04 16:52:29','2019-08-04 19:24:11'),(56,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:58:43',NULL,'2019-08-04 18:20:00','2019-08-04 19:58:43'),(57,30,'STS\\Notifications\\DeleteTripNotification','2019-08-04 19:24:11',NULL,'2019-08-04 18:33:13','2019-08-04 19:24:11'),(58,3,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:58:43',NULL,'2019-08-04 18:45:25','2019-08-04 19:58:43'),(59,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:58:43',NULL,'2019-08-04 18:45:56','2019-08-04 19:58:43'),(60,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:58:43',NULL,'2019-08-04 18:46:27','2019-08-04 19:58:43'),(61,3,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:58:43',NULL,'2019-08-04 18:47:06','2019-08-04 19:58:43'),(62,3,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:58:42',NULL,'2019-08-04 18:51:54','2019-08-04 19:58:42'),(63,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:58:42',NULL,'2019-08-04 18:53:10','2019-08-04 19:58:42'),(64,3,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:58:42',NULL,'2019-08-04 18:56:24','2019-08-04 19:58:42'),(65,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:58:42',NULL,'2019-08-04 18:57:42','2019-08-04 19:58:42'),(66,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:58:42',NULL,'2019-08-04 19:02:29','2019-08-04 19:58:42'),(67,30,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:24:11',NULL,'2019-08-04 19:06:54','2019-08-04 19:24:11'),(68,30,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:24:11',NULL,'2019-08-04 19:07:03','2019-08-04 19:24:11'),(69,30,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:24:11',NULL,'2019-08-04 19:07:05','2019-08-04 19:24:11'),(70,30,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:24:11',NULL,'2019-08-04 19:09:56','2019-08-04 19:24:11'),(71,30,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:24:11',NULL,'2019-08-04 19:10:00','2019-08-04 19:24:11'),(72,30,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:24:10',NULL,'2019-08-04 19:10:04','2019-08-04 19:24:10'),(73,30,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:24:10',NULL,'2019-08-04 19:10:05','2019-08-04 19:24:10'),(74,30,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:24:10',NULL,'2019-08-04 19:10:08','2019-08-04 19:24:10'),(75,3,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:58:42',NULL,'2019-08-04 19:16:13','2019-08-04 19:58:42'),(76,30,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:24:10',NULL,'2019-08-04 19:16:27','2019-08-04 19:24:10'),(77,30,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:24:10',NULL,'2019-08-04 19:16:31','2019-08-04 19:24:10'),(78,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:58:42',NULL,'2019-08-04 19:16:42','2019-08-04 19:58:42'),(79,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:58:42',NULL,'2019-08-04 19:16:53','2019-08-04 19:58:42'),(80,3,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:58:42',NULL,'2019-08-04 19:18:54','2019-08-04 19:58:42'),(81,30,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:24:10',NULL,'2019-08-04 19:20:24','2019-08-04 19:24:10'),(82,1,'STS\\Notifications\\AcceptPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:21:56','2019-08-04 19:57:13'),(83,30,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:24:10',NULL,'2019-08-04 19:23:34','2019-08-04 19:24:10'),(84,30,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:24:10',NULL,'2019-08-04 19:24:07','2019-08-04 19:24:10'),(85,1,'STS\\Notifications\\AcceptPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:24:25','2019-08-04 19:57:13'),(86,30,'STS\\Notifications\\AcceptPassengerNotification',NULL,NULL,'2019-08-04 19:26:17','2019-08-04 19:26:17'),(87,1,'STS\\Notifications\\AcceptPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:26:19','2019-08-04 19:57:13'),(88,1,'STS\\Notifications\\DeleteTripNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:27:27','2019-08-04 19:57:13'),(89,1,'STS\\Notifications\\DeleteTripNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:29:14','2019-08-04 19:57:13'),(90,30,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-04 19:33:38','2019-08-04 19:33:38'),(91,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 19:33:43','2019-08-04 19:33:43'),(92,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:40:06','2019-08-04 19:57:13'),(93,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:41:04','2019-08-04 19:57:13'),(94,1,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:41:15','2019-08-04 19:57:13'),(95,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:42:03','2019-08-04 19:57:13'),(96,1,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:43:38','2019-08-04 19:57:13'),(97,3,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:58:41',NULL,'2019-08-04 19:44:53','2019-08-04 19:58:41'),(98,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:46:38','2019-08-04 19:57:13'),(99,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:47:37','2019-08-04 19:57:13'),(100,1,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:57:13',NULL,'2019-08-04 19:47:50','2019-08-04 19:57:13'),(101,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 19:48:49','2019-08-04 19:48:49'),(102,30,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-04 19:48:55','2019-08-04 19:48:55'),(103,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 19:52:36','2019-08-04 19:52:36'),(104,30,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-04 19:52:39','2019-08-04 19:52:39'),(105,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 19:56:38','2019-08-04 19:56:38'),(106,30,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-04 19:56:42','2019-08-04 19:56:42'),(107,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 19:58:41',NULL,'2019-08-04 19:56:49','2019-08-04 19:58:41'),(108,3,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 19:58:41',NULL,'2019-08-04 19:58:13','2019-08-04 19:58:41'),(109,1,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 20:09:15','2019-08-04 20:09:15'),(110,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 20:38:39',NULL,'2019-08-04 20:31:06','2019-08-04 20:38:39'),(111,3,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 20:38:39',NULL,'2019-08-04 20:33:56','2019-08-04 20:38:39'),(112,1,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-04 20:34:07','2019-08-04 20:34:07'),(113,30,'STS\\Notifications\\AcceptPassengerNotification','2019-08-04 20:41:13',NULL,'2019-08-04 20:38:51','2019-08-04 20:41:13'),(114,30,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 20:41:13',NULL,'2019-08-04 20:39:13','2019-08-04 20:41:13'),(115,30,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 20:41:13',NULL,'2019-08-04 20:39:24','2019-08-04 20:41:13'),(116,30,'STS\\Notifications\\RequestPassengerNotification','2019-08-04 20:41:13',NULL,'2019-08-04 20:39:30','2019-08-04 20:41:13'),(117,30,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 20:41:12',NULL,'2019-08-04 20:39:33','2019-08-04 20:41:12'),(118,30,'STS\\Notifications\\CancelPassengerNotification','2019-08-04 20:41:12',NULL,'2019-08-04 20:39:50','2019-08-04 20:41:12'),(119,3,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 20:44:47','2019-08-04 20:44:47'),(120,3,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 20:44:57','2019-08-04 20:44:57'),(121,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 20:45:10','2019-08-04 20:45:10'),(122,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:28',NULL,'2019-08-04 21:29:20','2019-08-06 16:03:28'),(123,1,'STS\\Notifications\\CancelPassengerNotification','2019-08-06 16:03:27',NULL,'2019-08-04 21:29:58','2019-08-06 16:03:27'),(124,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:27',NULL,'2019-08-04 21:30:35','2019-08-06 16:03:27'),(125,1,'STS\\Notifications\\CancelPassengerNotification','2019-08-06 16:03:27',NULL,'2019-08-04 21:31:26','2019-08-06 16:03:27'),(126,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:27',NULL,'2019-08-04 21:31:44','2019-08-06 16:03:27'),(127,1,'STS\\Notifications\\CancelPassengerNotification','2019-08-06 16:03:27',NULL,'2019-08-04 21:32:53','2019-08-06 16:03:27'),(128,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 21:34:26','2019-08-04 21:34:26'),(129,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 21:34:29','2019-08-04 21:34:29'),(130,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 21:34:30','2019-08-04 21:34:30'),(131,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:27',NULL,'2019-08-04 21:35:14','2019-08-06 16:03:27'),(132,1,'STS\\Notifications\\CancelPassengerNotification','2019-08-06 16:03:27',NULL,'2019-08-04 21:35:28','2019-08-06 16:03:27'),(133,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:27',NULL,'2019-08-04 21:36:16','2019-08-06 16:03:27'),(134,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 21:43:18','2019-08-04 21:43:18'),(135,30,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-04 21:43:53','2019-08-04 21:43:53'),(136,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 21:44:04','2019-08-04 21:44:04'),(137,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 21:44:09','2019-08-04 21:44:09'),(138,30,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-04 21:44:57','2019-08-04 21:44:57'),(139,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 21:45:44','2019-08-04 21:45:44'),(140,30,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-04 21:46:19','2019-08-04 21:46:19'),(141,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 21:52:55','2019-08-04 21:52:55'),(142,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 21:58:07','2019-08-04 21:58:07'),(143,30,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-04 21:58:56','2019-08-04 21:58:56'),(144,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 21:59:10','2019-08-04 21:59:10'),(145,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:27',NULL,'2019-08-04 22:03:53','2019-08-06 16:03:27'),(146,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:26',NULL,'2019-08-04 22:04:38','2019-08-06 16:03:26'),(147,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:26',NULL,'2019-08-04 22:06:32','2019-08-06 16:03:26'),(148,1,'STS\\Notifications\\CancelPassengerNotification','2019-08-06 16:03:26',NULL,'2019-08-04 22:06:35','2019-08-06 16:03:26'),(149,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:26',NULL,'2019-08-04 22:06:46','2019-08-06 16:03:26'),(150,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:26',NULL,'2019-08-04 22:08:22','2019-08-06 16:03:26'),(151,1,'STS\\Notifications\\CancelPassengerNotification','2019-08-06 16:03:26',NULL,'2019-08-04 22:10:36','2019-08-06 16:03:26'),(152,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:26',NULL,'2019-08-04 22:10:50','2019-08-06 16:03:26'),(153,1,'STS\\Notifications\\CancelPassengerNotification','2019-08-06 16:03:26',NULL,'2019-08-04 22:11:07','2019-08-06 16:03:26'),(154,1,'STS\\Notifications\\RequestPassengerNotification','2019-08-06 16:03:26',NULL,'2019-08-04 22:13:32','2019-08-06 16:03:26'),(155,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 22:14:54','2019-08-04 22:14:54'),(156,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 22:16:24','2019-08-04 22:16:24'),(157,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 22:16:37','2019-08-04 22:16:37'),(158,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-04 22:16:40','2019-08-04 22:16:40'),(159,30,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-04 22:16:44','2019-08-04 22:16:44'),(160,30,'STS\\Notifications\\AcceptPassengerNotification',NULL,NULL,'2019-08-04 22:18:52','2019-08-04 22:18:52'),(161,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-06 15:05:07','2019-08-06 15:05:07'),(162,30,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-06 15:06:02','2019-08-06 15:06:02'),(163,30,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-06 15:51:01','2019-08-06 15:51:01'),(164,1,'STS\\Notifications\\CancelPassengerNotification',NULL,NULL,'2019-08-06 23:13:16','2019-08-06 23:13:16'),(165,1,'STS\\Notifications\\RequestPassengerNotification',NULL,NULL,'2019-08-06 23:14:42','2019-08-06 23:14:42');
295/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
296UNLOCK TABLES;
297
298--
299-- Table structure for table `notifications_params`
300--
301
302DROP TABLE IF EXISTS `notifications_params`;
303/*!40101 SET @saved_cs_client     = @@character_set_client */;
304/*!40101 SET character_set_client = utf8 */;
305CREATE TABLE `notifications_params` (
306  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
307  `notification_id` int(10) unsigned NOT NULL,
308  `key` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
309  `value_id` int(10) unsigned NOT NULL,
310  `value_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
311  `value_text` text COLLATE utf8_unicode_ci,
312  `created_at` timestamp NULL DEFAULT NULL,
313  `updated_at` timestamp NULL DEFAULT NULL,
314  PRIMARY KEY (`id`),
315  KEY `notifications_params_value_id_value_type_index` (`value_id`,`value_type`),
316  KEY `notifications_params_notification_id_foreign` (`notification_id`),
317  CONSTRAINT `notifications_params_notification_id_foreign` FOREIGN KEY (`notification_id`) REFERENCES `notifications` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
318) ENGINE=InnoDB AUTO_INCREMENT=305 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
319/*!40101 SET character_set_client = @saved_cs_client */;
320
321--
322-- Dumping data for table `notifications_params`
323--
324
325LOCK TABLES `notifications_params` WRITE;
326/*!40000 ALTER TABLE `notifications_params` DISABLE KEYS */;
327INSERT INTO `notifications_params` VALUES (1,1,'trip',36,'STS\\Entities\\Trip',NULL,'2019-08-01 23:23:46','2019-08-01 23:23:46'),(2,1,'from',3,'STS\\User',NULL,'2019-08-01 23:23:46','2019-08-01 23:23:46'),(3,2,'trip',36,'STS\\Entities\\Trip',NULL,'2019-08-01 23:24:20','2019-08-01 23:24:20'),(4,2,'from',1,'STS\\User',NULL,'2019-08-01 23:24:20','2019-08-01 23:24:20'),(5,3,'trip',36,'STS\\Entities\\Trip',NULL,'2019-08-01 23:24:58','2019-08-01 23:24:58'),(6,3,'from',1,'STS\\User',NULL,'2019-08-01 23:24:58','2019-08-01 23:24:58'),(7,3,'canceledState',0,'','1','2019-08-01 23:24:58','2019-08-01 23:24:58'),(8,4,'trip',36,'STS\\Entities\\Trip',NULL,'2019-08-01 23:25:12','2019-08-01 23:25:12'),(9,4,'from',3,'STS\\User',NULL,'2019-08-01 23:25:12','2019-08-01 23:25:12'),(10,5,'trip',37,'STS\\Entities\\Trip',NULL,'2019-08-03 00:28:37','2019-08-03 00:28:37'),(11,6,'trip',38,'STS\\Entities\\Trip',NULL,'2019-08-03 00:28:42','2019-08-03 00:28:42'),(12,7,'trip',39,'STS\\Entities\\Trip',NULL,'2019-08-03 00:28:44','2019-08-03 00:28:44'),(13,8,'trip',40,'STS\\Entities\\Trip',NULL,'2019-08-03 00:28:47','2019-08-03 00:28:47'),(14,9,'trip',41,'STS\\Entities\\Trip',NULL,'2019-08-03 00:28:49','2019-08-03 00:28:49'),(15,10,'trip',42,'STS\\Entities\\Trip',NULL,'2019-08-03 00:28:52','2019-08-03 00:28:52'),(16,11,'trip',43,'STS\\Entities\\Trip',NULL,'2019-08-03 00:28:53','2019-08-03 00:28:53'),(17,12,'trip',44,'STS\\Entities\\Trip',NULL,'2019-08-03 00:29:03','2019-08-03 00:29:03'),(18,13,'trip',45,'STS\\Entities\\Trip',NULL,'2019-08-03 00:29:04','2019-08-03 00:29:04'),(19,14,'trip',46,'STS\\Entities\\Trip',NULL,'2019-08-03 00:29:05','2019-08-03 00:29:05'),(20,15,'trip',47,'STS\\Entities\\Trip',NULL,'2019-08-03 00:29:07','2019-08-03 00:29:07'),(21,16,'trip',48,'STS\\Entities\\Trip',NULL,'2019-08-03 00:29:09','2019-08-03 00:29:09'),(22,17,'trip',49,'STS\\Entities\\Trip',NULL,'2019-08-03 00:29:10','2019-08-03 00:29:10'),(23,18,'trip',50,'STS\\Entities\\Trip',NULL,'2019-08-03 00:29:11','2019-08-03 00:29:11'),(24,19,'trip',51,'STS\\Entities\\Trip',NULL,'2019-08-03 00:29:13','2019-08-03 00:29:13'),(25,20,'trip',52,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:01','2019-08-03 00:30:01'),(26,21,'trip',53,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:03','2019-08-03 00:30:03'),(27,22,'trip',54,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:04','2019-08-03 00:30:04'),(28,23,'trip',55,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:07','2019-08-03 00:30:07'),(29,24,'trip',56,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:09','2019-08-03 00:30:09'),(30,25,'trip',57,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:12','2019-08-03 00:30:12'),(31,26,'trip',58,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:13','2019-08-03 00:30:13'),(32,27,'trip',59,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:18','2019-08-03 00:30:18'),(33,28,'trip',60,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:33','2019-08-03 00:30:33'),(34,29,'trip',61,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:34','2019-08-03 00:30:34'),(35,30,'trip',62,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:36','2019-08-03 00:30:36'),(36,31,'trip',63,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:38','2019-08-03 00:30:38'),(37,32,'trip',64,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:39','2019-08-03 00:30:39'),(38,33,'trip',65,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:40','2019-08-03 00:30:40'),(39,34,'trip',66,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:50','2019-08-03 00:30:50'),(40,35,'trip',67,'STS\\Entities\\Trip',NULL,'2019-08-03 00:30:52','2019-08-03 00:30:52'),(41,36,'trip',68,'STS\\Entities\\Trip',NULL,'2019-08-03 00:32:02','2019-08-03 00:32:02'),(42,37,'trip',69,'STS\\Entities\\Trip',NULL,'2019-08-03 00:32:04','2019-08-03 00:32:04'),(43,38,'trip',70,'STS\\Entities\\Trip',NULL,'2019-08-03 00:32:06','2019-08-03 00:32:06'),(44,39,'trip',71,'STS\\Entities\\Trip',NULL,'2019-08-03 00:32:08','2019-08-03 00:32:08'),(45,40,'trip',72,'STS\\Entities\\Trip',NULL,'2019-08-03 00:32:09','2019-08-03 00:32:09'),(46,41,'trip',73,'STS\\Entities\\Trip',NULL,'2019-08-03 00:32:15','2019-08-03 00:32:15'),(47,42,'trip',74,'STS\\Entities\\Trip',NULL,'2019-08-03 00:32:23','2019-08-03 00:32:23'),(48,43,'trip',75,'STS\\Entities\\Trip',NULL,'2019-08-03 02:46:28','2019-08-03 02:46:28'),(49,43,'from',1,'STS\\User',NULL,'2019-08-03 02:46:28','2019-08-03 02:46:28'),(50,44,'trip',75,'STS\\Entities\\Trip',NULL,'2019-08-03 02:46:41','2019-08-03 02:46:41'),(51,44,'from',1,'STS\\User',NULL,'2019-08-03 02:46:41','2019-08-03 02:46:41'),(52,45,'trip',75,'STS\\Entities\\Trip',NULL,'2019-08-03 14:08:40','2019-08-03 14:08:40'),(53,45,'from',1,'STS\\User',NULL,'2019-08-03 14:08:40','2019-08-03 14:08:40'),(54,46,'trip',75,'STS\\Entities\\Trip',NULL,'2019-08-03 14:08:52','2019-08-03 14:08:52'),(55,46,'from',3,'STS\\User',NULL,'2019-08-03 14:08:52','2019-08-03 14:08:52'),(56,47,'trip',75,'STS\\Entities\\Trip',NULL,'2019-08-03 14:11:50','2019-08-03 14:11:50'),(57,47,'from',3,'STS\\User',NULL,'2019-08-03 14:11:50','2019-08-03 14:11:50'),(58,47,'canceledState',0,'','1','2019-08-03 14:11:50','2019-08-03 14:11:50'),(59,48,'trip',36,'STS\\Entities\\Trip',NULL,'2019-08-04 14:42:23','2019-08-04 14:42:23'),(60,48,'from',1,'STS\\User',NULL,'2019-08-04 14:42:23','2019-08-04 14:42:23'),(61,49,'trip',80,'STS\\Entities\\Trip',NULL,'2019-08-04 14:46:46','2019-08-04 14:46:46'),(62,49,'from',30,'STS\\User',NULL,'2019-08-04 14:46:46','2019-08-04 14:46:46'),(63,50,'trip',80,'STS\\Entities\\Trip',NULL,'2019-08-04 14:46:52','2019-08-04 14:46:52'),(64,50,'from',30,'STS\\User',NULL,'2019-08-04 14:46:52','2019-08-04 14:46:52'),(65,51,'trip',36,'STS\\Entities\\Trip',NULL,'2019-08-04 14:54:17','2019-08-04 14:54:17'),(66,51,'from',1,'STS\\User',NULL,'2019-08-04 14:54:17','2019-08-04 14:54:17'),(67,51,'canceledState',0,'','1','2019-08-04 14:54:17','2019-08-04 14:54:17'),(68,52,'trip',36,'STS\\Entities\\Trip',NULL,'2019-08-04 15:43:03','2019-08-04 15:43:03'),(69,52,'from',30,'STS\\User',NULL,'2019-08-04 15:43:03','2019-08-04 15:43:03'),(70,53,'trip',36,'STS\\Entities\\Trip',NULL,'2019-08-04 16:00:32','2019-08-04 16:00:32'),(71,53,'from',1,'STS\\User',NULL,'2019-08-04 16:00:32','2019-08-04 16:00:32'),(72,54,'from',1,'STS\\User',NULL,'2019-08-04 16:50:25','2019-08-04 16:50:25'),(73,54,'messages',9,'STS\\Entities\\Message',NULL,'2019-08-04 16:50:25','2019-08-04 16:50:25'),(74,55,'from',1,'STS\\User',NULL,'2019-08-04 16:52:29','2019-08-04 16:52:29'),(75,55,'messages',10,'STS\\Entities\\Message',NULL,'2019-08-04 16:52:29','2019-08-04 16:52:29'),(76,56,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 18:20:00','2019-08-04 18:20:00'),(77,56,'from',1,'STS\\User',NULL,'2019-08-04 18:20:00','2019-08-04 18:20:00'),(78,57,'trip',36,'STS\\Entities\\Trip',NULL,'2019-08-04 18:33:13','2019-08-04 18:33:13'),(79,57,'from',1,'STS\\User',NULL,'2019-08-04 18:33:13','2019-08-04 18:33:13'),(80,57,'hash',0,'','M1YNZoqWzJtxQGpLricTBqqRkxOZjMMTJlTOQBOh','2019-08-04 18:33:13','2019-08-04 18:33:13'),(81,58,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 18:45:25','2019-08-04 18:45:25'),(82,58,'from',1,'STS\\User',NULL,'2019-08-04 18:45:25','2019-08-04 18:45:25'),(83,59,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 18:45:56','2019-08-04 18:45:56'),(84,59,'from',1,'STS\\User',NULL,'2019-08-04 18:45:56','2019-08-04 18:45:56'),(85,60,'trip',82,'STS\\Entities\\Trip',NULL,'2019-08-04 18:46:27','2019-08-04 18:46:27'),(86,60,'from',1,'STS\\User',NULL,'2019-08-04 18:46:27','2019-08-04 18:46:27'),(87,61,'trip',82,'STS\\Entities\\Trip',NULL,'2019-08-04 18:47:06','2019-08-04 18:47:06'),(88,61,'from',1,'STS\\User',NULL,'2019-08-04 18:47:06','2019-08-04 18:47:06'),(89,62,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 18:51:54','2019-08-04 18:51:54'),(90,62,'from',1,'STS\\User',NULL,'2019-08-04 18:51:54','2019-08-04 18:51:54'),(91,63,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 18:53:10','2019-08-04 18:53:10'),(92,63,'from',1,'STS\\User',NULL,'2019-08-04 18:53:10','2019-08-04 18:53:10'),(93,64,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 18:56:24','2019-08-04 18:56:24'),(94,64,'from',1,'STS\\User',NULL,'2019-08-04 18:56:24','2019-08-04 18:56:24'),(95,65,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 18:57:42','2019-08-04 18:57:42'),(96,65,'from',1,'STS\\User',NULL,'2019-08-04 18:57:42','2019-08-04 18:57:42'),(97,66,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 19:02:29','2019-08-04 19:02:29'),(98,66,'from',30,'STS\\User',NULL,'2019-08-04 19:02:29','2019-08-04 19:02:29'),(99,67,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:06:54','2019-08-04 19:06:54'),(100,67,'from',1,'STS\\User',NULL,'2019-08-04 19:06:54','2019-08-04 19:06:54'),(101,68,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:07:03','2019-08-04 19:07:03'),(102,68,'from',1,'STS\\User',NULL,'2019-08-04 19:07:03','2019-08-04 19:07:03'),(103,69,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:07:05','2019-08-04 19:07:05'),(104,69,'from',1,'STS\\User',NULL,'2019-08-04 19:07:05','2019-08-04 19:07:05'),(105,70,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:09:56','2019-08-04 19:09:56'),(106,70,'from',1,'STS\\User',NULL,'2019-08-04 19:09:56','2019-08-04 19:09:56'),(107,71,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:10:00','2019-08-04 19:10:00'),(108,71,'from',1,'STS\\User',NULL,'2019-08-04 19:10:00','2019-08-04 19:10:00'),(109,72,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:10:04','2019-08-04 19:10:04'),(110,72,'from',1,'STS\\User',NULL,'2019-08-04 19:10:04','2019-08-04 19:10:04'),(111,73,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:10:05','2019-08-04 19:10:05'),(112,73,'from',1,'STS\\User',NULL,'2019-08-04 19:10:05','2019-08-04 19:10:05'),(113,74,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:10:08','2019-08-04 19:10:08'),(114,74,'from',1,'STS\\User',NULL,'2019-08-04 19:10:08','2019-08-04 19:10:08'),(115,75,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 19:16:13','2019-08-04 19:16:13'),(116,75,'from',1,'STS\\User',NULL,'2019-08-04 19:16:13','2019-08-04 19:16:13'),(117,76,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:16:28','2019-08-04 19:16:28'),(118,76,'from',1,'STS\\User',NULL,'2019-08-04 19:16:28','2019-08-04 19:16:28'),(119,77,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:16:31','2019-08-04 19:16:31'),(120,77,'from',1,'STS\\User',NULL,'2019-08-04 19:16:31','2019-08-04 19:16:31'),(121,78,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 19:16:42','2019-08-04 19:16:42'),(122,78,'from',1,'STS\\User',NULL,'2019-08-04 19:16:42','2019-08-04 19:16:42'),(123,79,'trip',82,'STS\\Entities\\Trip',NULL,'2019-08-04 19:16:53','2019-08-04 19:16:53'),(124,79,'from',1,'STS\\User',NULL,'2019-08-04 19:16:53','2019-08-04 19:16:53'),(125,80,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 19:18:54','2019-08-04 19:18:54'),(126,80,'from',1,'STS\\User',NULL,'2019-08-04 19:18:54','2019-08-04 19:18:54'),(127,81,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:20:24','2019-08-04 19:20:24'),(128,81,'from',1,'STS\\User',NULL,'2019-08-04 19:20:24','2019-08-04 19:20:24'),(129,82,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:21:56','2019-08-04 19:21:56'),(130,82,'from',30,'STS\\User',NULL,'2019-08-04 19:21:56','2019-08-04 19:21:56'),(131,83,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:23:34','2019-08-04 19:23:34'),(132,83,'from',1,'STS\\User',NULL,'2019-08-04 19:23:34','2019-08-04 19:23:34'),(133,83,'canceledState',0,'','2','2019-08-04 19:23:34','2019-08-04 19:23:34'),(134,84,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:24:07','2019-08-04 19:24:07'),(135,84,'from',1,'STS\\User',NULL,'2019-08-04 19:24:07','2019-08-04 19:24:07'),(136,85,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:24:25','2019-08-04 19:24:25'),(137,85,'from',30,'STS\\User',NULL,'2019-08-04 19:24:25','2019-08-04 19:24:25'),(138,86,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 19:26:17','2019-08-04 19:26:17'),(139,86,'from',3,'STS\\User',NULL,'2019-08-04 19:26:17','2019-08-04 19:26:17'),(140,87,'trip',82,'STS\\Entities\\Trip',NULL,'2019-08-04 19:26:19','2019-08-04 19:26:19'),(141,87,'from',3,'STS\\User',NULL,'2019-08-04 19:26:19','2019-08-04 19:26:19'),(142,88,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:27:27','2019-08-04 19:27:27'),(143,88,'from',30,'STS\\User',NULL,'2019-08-04 19:27:27','2019-08-04 19:27:27'),(144,88,'hash',0,'','e3YdXqlsZhSbYxq85X2rgwCiBEdWTIJtQ9cMcAEQ','2019-08-04 19:27:27','2019-08-04 19:27:27'),(145,89,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:29:14','2019-08-04 19:29:14'),(146,89,'from',30,'STS\\User',NULL,'2019-08-04 19:29:14','2019-08-04 19:29:14'),(147,89,'hash',0,'','UKOiflfO6xSyNNwawmJahnPvu8GKvSLslWqCQFb1','2019-08-04 19:29:14','2019-08-04 19:29:14'),(148,90,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:33:38','2019-08-04 19:33:38'),(149,90,'from',1,'STS\\User',NULL,'2019-08-04 19:33:38','2019-08-04 19:33:38'),(150,90,'canceledState',0,'','2','2019-08-04 19:33:38','2019-08-04 19:33:38'),(151,91,'trip',84,'STS\\Entities\\Trip',NULL,'2019-08-04 19:33:43','2019-08-04 19:33:43'),(152,91,'from',1,'STS\\User',NULL,'2019-08-04 19:33:43','2019-08-04 19:33:43'),(153,92,'trip',88,'STS\\Entities\\Trip',NULL,'2019-08-04 19:40:06','2019-08-04 19:40:06'),(154,92,'from',30,'STS\\User',NULL,'2019-08-04 19:40:06','2019-08-04 19:40:06'),(155,93,'trip',88,'STS\\Entities\\Trip',NULL,'2019-08-04 19:41:04','2019-08-04 19:41:04'),(156,93,'from',30,'STS\\User',NULL,'2019-08-04 19:41:04','2019-08-04 19:41:04'),(157,94,'trip',88,'STS\\Entities\\Trip',NULL,'2019-08-04 19:41:15','2019-08-04 19:41:15'),(158,94,'from',30,'STS\\User',NULL,'2019-08-04 19:41:15','2019-08-04 19:41:15'),(159,95,'trip',88,'STS\\Entities\\Trip',NULL,'2019-08-04 19:42:03','2019-08-04 19:42:03'),(160,95,'from',30,'STS\\User',NULL,'2019-08-04 19:42:03','2019-08-04 19:42:03'),(161,96,'trip',88,'STS\\Entities\\Trip',NULL,'2019-08-04 19:43:38','2019-08-04 19:43:38'),(162,96,'from',30,'STS\\User',NULL,'2019-08-04 19:43:38','2019-08-04 19:43:38'),(163,97,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 19:44:53','2019-08-04 19:44:53'),(164,97,'from',30,'STS\\User',NULL,'2019-08-04 19:44:53','2019-08-04 19:44:53'),(165,97,'canceledState',0,'','2','2019-08-04 19:44:53','2019-08-04 19:44:53'),(166,98,'trip',88,'STS\\Entities\\Trip',NULL,'2019-08-04 19:46:38','2019-08-04 19:46:38'),(167,98,'from',30,'STS\\User',NULL,'2019-08-04 19:46:38','2019-08-04 19:46:38'),(168,99,'trip',88,'STS\\Entities\\Trip',NULL,'2019-08-04 19:47:37','2019-08-04 19:47:37'),(169,99,'from',30,'STS\\User',NULL,'2019-08-04 19:47:37','2019-08-04 19:47:37'),(170,100,'trip',88,'STS\\Entities\\Trip',NULL,'2019-08-04 19:47:50','2019-08-04 19:47:50'),(171,100,'from',30,'STS\\User',NULL,'2019-08-04 19:47:51','2019-08-04 19:47:51'),(172,101,'trip',90,'STS\\Entities\\Trip',NULL,'2019-08-04 19:48:49','2019-08-04 19:48:49'),(173,101,'from',1,'STS\\User',NULL,'2019-08-04 19:48:49','2019-08-04 19:48:49'),(174,102,'trip',90,'STS\\Entities\\Trip',NULL,'2019-08-04 19:48:55','2019-08-04 19:48:55'),(175,102,'from',1,'STS\\User',NULL,'2019-08-04 19:48:55','2019-08-04 19:48:55'),(176,103,'trip',90,'STS\\Entities\\Trip',NULL,'2019-08-04 19:52:36','2019-08-04 19:52:36'),(177,103,'from',1,'STS\\User',NULL,'2019-08-04 19:52:37','2019-08-04 19:52:37'),(178,104,'trip',90,'STS\\Entities\\Trip',NULL,'2019-08-04 19:52:39','2019-08-04 19:52:39'),(179,104,'from',1,'STS\\User',NULL,'2019-08-04 19:52:39','2019-08-04 19:52:39'),(180,105,'trip',90,'STS\\Entities\\Trip',NULL,'2019-08-04 19:56:38','2019-08-04 19:56:38'),(181,105,'from',1,'STS\\User',NULL,'2019-08-04 19:56:38','2019-08-04 19:56:38'),(182,106,'trip',90,'STS\\Entities\\Trip',NULL,'2019-08-04 19:56:42','2019-08-04 19:56:42'),(183,106,'from',1,'STS\\User',NULL,'2019-08-04 19:56:42','2019-08-04 19:56:42'),(184,107,'trip',81,'STS\\Entities\\Trip',NULL,'2019-08-04 19:56:49','2019-08-04 19:56:49'),(185,107,'from',1,'STS\\User',NULL,'2019-08-04 19:56:49','2019-08-04 19:56:49'),(186,108,'trip',82,'STS\\Entities\\Trip',NULL,'2019-08-04 19:58:13','2019-08-04 19:58:13'),(187,108,'from',1,'STS\\User',NULL,'2019-08-04 19:58:13','2019-08-04 19:58:13'),(188,108,'canceledState',0,'','2','2019-08-04 19:58:13','2019-08-04 19:58:13'),(189,109,'trip',91,'STS\\Entities\\Trip',NULL,'2019-08-04 20:09:15','2019-08-04 20:09:15'),(190,109,'from',30,'STS\\User',NULL,'2019-08-04 20:09:15','2019-08-04 20:09:15'),(191,110,'trip',92,'STS\\Entities\\Trip',NULL,'2019-08-04 20:31:06','2019-08-04 20:31:06'),(192,110,'from',30,'STS\\User',NULL,'2019-08-04 20:31:06','2019-08-04 20:31:06'),(193,111,'trip',92,'STS\\Entities\\Trip',NULL,'2019-08-04 20:33:56','2019-08-04 20:33:56'),(194,111,'from',30,'STS\\User',NULL,'2019-08-04 20:33:56','2019-08-04 20:33:56'),(195,112,'trip',91,'STS\\Entities\\Trip',NULL,'2019-08-04 20:34:07','2019-08-04 20:34:07'),(196,112,'from',30,'STS\\User',NULL,'2019-08-04 20:34:08','2019-08-04 20:34:08'),(197,113,'trip',92,'STS\\Entities\\Trip',NULL,'2019-08-04 20:38:51','2019-08-04 20:38:51'),(198,113,'from',3,'STS\\User',NULL,'2019-08-04 20:38:51','2019-08-04 20:38:51'),(199,114,'trip',94,'STS\\Entities\\Trip',NULL,'2019-08-04 20:39:13','2019-08-04 20:39:13'),(200,114,'from',1,'STS\\User',NULL,'2019-08-04 20:39:13','2019-08-04 20:39:13'),(201,115,'trip',94,'STS\\Entities\\Trip',NULL,'2019-08-04 20:39:24','2019-08-04 20:39:24'),(202,115,'from',1,'STS\\User',NULL,'2019-08-04 20:39:24','2019-08-04 20:39:24'),(203,116,'trip',94,'STS\\Entities\\Trip',NULL,'2019-08-04 20:39:30','2019-08-04 20:39:30'),(204,116,'from',1,'STS\\User',NULL,'2019-08-04 20:39:30','2019-08-04 20:39:30'),(205,117,'trip',94,'STS\\Entities\\Trip',NULL,'2019-08-04 20:39:33','2019-08-04 20:39:33'),(206,117,'from',1,'STS\\User',NULL,'2019-08-04 20:39:33','2019-08-04 20:39:33'),(207,118,'trip',92,'STS\\Entities\\Trip',NULL,'2019-08-04 20:39:50','2019-08-04 20:39:50'),(208,118,'from',3,'STS\\User',NULL,'2019-08-04 20:39:50','2019-08-04 20:39:50'),(209,118,'canceledState',0,'','1','2019-08-04 20:39:50','2019-08-04 20:39:50'),(210,119,'trip',92,'STS\\Entities\\Trip',NULL,'2019-08-04 20:44:47','2019-08-04 20:44:47'),(211,119,'from',30,'STS\\User',NULL,'2019-08-04 20:44:47','2019-08-04 20:44:47'),(212,120,'trip',92,'STS\\Entities\\Trip',NULL,'2019-08-04 20:44:57','2019-08-04 20:44:57'),(213,120,'from',1,'STS\\User',NULL,'2019-08-04 20:44:57','2019-08-04 20:44:57'),(214,121,'trip',94,'STS\\Entities\\Trip',NULL,'2019-08-04 20:45:10','2019-08-04 20:45:10'),(215,121,'from',1,'STS\\User',NULL,'2019-08-04 20:45:10','2019-08-04 20:45:10'),(216,122,'trip',95,'STS\\Entities\\Trip',NULL,'2019-08-04 21:29:20','2019-08-04 21:29:20'),(217,122,'from',30,'STS\\User',NULL,'2019-08-04 21:29:20','2019-08-04 21:29:20'),(218,123,'trip',95,'STS\\Entities\\Trip',NULL,'2019-08-04 21:29:58','2019-08-04 21:29:58'),(219,123,'from',30,'STS\\User',NULL,'2019-08-04 21:29:58','2019-08-04 21:29:58'),(220,124,'trip',95,'STS\\Entities\\Trip',NULL,'2019-08-04 21:30:35','2019-08-04 21:30:35'),(221,124,'from',30,'STS\\User',NULL,'2019-08-04 21:30:35','2019-08-04 21:30:35'),(222,125,'trip',95,'STS\\Entities\\Trip',NULL,'2019-08-04 21:31:26','2019-08-04 21:31:26'),(223,125,'from',30,'STS\\User',NULL,'2019-08-04 21:31:26','2019-08-04 21:31:26'),(224,126,'trip',96,'STS\\Entities\\Trip',NULL,'2019-08-04 21:31:44','2019-08-04 21:31:44'),(225,126,'from',30,'STS\\User',NULL,'2019-08-04 21:31:44','2019-08-04 21:31:44'),(226,127,'trip',96,'STS\\Entities\\Trip',NULL,'2019-08-04 21:32:53','2019-08-04 21:32:53'),(227,127,'from',30,'STS\\User',NULL,'2019-08-04 21:32:53','2019-08-04 21:32:53'),(228,128,'trip',97,'STS\\Entities\\Trip',NULL,'2019-08-04 21:34:26','2019-08-04 21:34:26'),(229,128,'from',1,'STS\\User',NULL,'2019-08-04 21:34:26','2019-08-04 21:34:26'),(230,129,'trip',97,'STS\\Entities\\Trip',NULL,'2019-08-04 21:34:29','2019-08-04 21:34:29'),(231,129,'from',1,'STS\\User',NULL,'2019-08-04 21:34:29','2019-08-04 21:34:29'),(232,130,'trip',97,'STS\\Entities\\Trip',NULL,'2019-08-04 21:34:30','2019-08-04 21:34:30'),(233,130,'from',1,'STS\\User',NULL,'2019-08-04 21:34:30','2019-08-04 21:34:30'),(234,131,'trip',95,'STS\\Entities\\Trip',NULL,'2019-08-04 21:35:14','2019-08-04 21:35:14'),(235,131,'from',30,'STS\\User',NULL,'2019-08-04 21:35:14','2019-08-04 21:35:14'),(236,132,'trip',95,'STS\\Entities\\Trip',NULL,'2019-08-04 21:35:28','2019-08-04 21:35:28'),(237,132,'from',30,'STS\\User',NULL,'2019-08-04 21:35:28','2019-08-04 21:35:28'),(238,133,'trip',95,'STS\\Entities\\Trip',NULL,'2019-08-04 21:36:16','2019-08-04 21:36:16'),(239,133,'from',30,'STS\\User',NULL,'2019-08-04 21:36:16','2019-08-04 21:36:16'),(240,134,'trip',98,'STS\\Entities\\Trip',NULL,'2019-08-04 21:43:19','2019-08-04 21:43:19'),(241,134,'from',1,'STS\\User',NULL,'2019-08-04 21:43:19','2019-08-04 21:43:19'),(242,135,'trip',98,'STS\\Entities\\Trip',NULL,'2019-08-04 21:43:53','2019-08-04 21:43:53'),(243,135,'from',1,'STS\\User',NULL,'2019-08-04 21:43:53','2019-08-04 21:43:53'),(244,136,'trip',98,'STS\\Entities\\Trip',NULL,'2019-08-04 21:44:04','2019-08-04 21:44:04'),(245,136,'from',1,'STS\\User',NULL,'2019-08-04 21:44:04','2019-08-04 21:44:04'),(246,137,'trip',98,'STS\\Entities\\Trip',NULL,'2019-08-04 21:44:09','2019-08-04 21:44:09'),(247,137,'from',1,'STS\\User',NULL,'2019-08-04 21:44:09','2019-08-04 21:44:09'),(248,138,'trip',98,'STS\\Entities\\Trip',NULL,'2019-08-04 21:44:57','2019-08-04 21:44:57'),(249,138,'from',1,'STS\\User',NULL,'2019-08-04 21:44:57','2019-08-04 21:44:57'),(250,139,'trip',98,'STS\\Entities\\Trip',NULL,'2019-08-04 21:45:44','2019-08-04 21:45:44'),(251,139,'from',1,'STS\\User',NULL,'2019-08-04 21:45:44','2019-08-04 21:45:44'),(252,140,'trip',98,'STS\\Entities\\Trip',NULL,'2019-08-04 21:46:19','2019-08-04 21:46:19'),(253,140,'from',1,'STS\\User',NULL,'2019-08-04 21:46:19','2019-08-04 21:46:19'),(254,141,'trip',98,'STS\\Entities\\Trip',NULL,'2019-08-04 21:52:55','2019-08-04 21:52:55'),(255,141,'from',1,'STS\\User',NULL,'2019-08-04 21:52:55','2019-08-04 21:52:55'),(256,142,'trip',98,'STS\\Entities\\Trip',NULL,'2019-08-04 21:58:07','2019-08-04 21:58:07'),(257,142,'from',3,'STS\\User',NULL,'2019-08-04 21:58:07','2019-08-04 21:58:07'),(258,143,'trip',98,'STS\\Entities\\Trip',NULL,'2019-08-04 21:58:56','2019-08-04 21:58:56'),(259,143,'from',1,'STS\\User',NULL,'2019-08-04 21:58:56','2019-08-04 21:58:56'),(260,144,'trip',98,'STS\\Entities\\Trip',NULL,'2019-08-04 21:59:10','2019-08-04 21:59:10'),(261,144,'from',1,'STS\\User',NULL,'2019-08-04 21:59:10','2019-08-04 21:59:10'),(262,145,'trip',99,'STS\\Entities\\Trip',NULL,'2019-08-04 22:03:53','2019-08-04 22:03:53'),(263,145,'from',30,'STS\\User',NULL,'2019-08-04 22:03:53','2019-08-04 22:03:53'),(264,146,'trip',99,'STS\\Entities\\Trip',NULL,'2019-08-04 22:04:38','2019-08-04 22:04:38'),(265,146,'from',30,'STS\\User',NULL,'2019-08-04 22:04:38','2019-08-04 22:04:38'),(266,147,'trip',99,'STS\\Entities\\Trip',NULL,'2019-08-04 22:06:32','2019-08-04 22:06:32'),(267,147,'from',30,'STS\\User',NULL,'2019-08-04 22:06:32','2019-08-04 22:06:32'),(268,148,'trip',99,'STS\\Entities\\Trip',NULL,'2019-08-04 22:06:35','2019-08-04 22:06:35'),(269,148,'from',30,'STS\\User',NULL,'2019-08-04 22:06:35','2019-08-04 22:06:35'),(270,149,'trip',99,'STS\\Entities\\Trip',NULL,'2019-08-04 22:06:46','2019-08-04 22:06:46'),(271,149,'from',30,'STS\\User',NULL,'2019-08-04 22:06:46','2019-08-04 22:06:46'),(272,150,'trip',99,'STS\\Entities\\Trip',NULL,'2019-08-04 22:08:22','2019-08-04 22:08:22'),(273,150,'from',30,'STS\\User',NULL,'2019-08-04 22:08:22','2019-08-04 22:08:22'),(274,151,'trip',99,'STS\\Entities\\Trip',NULL,'2019-08-04 22:10:36','2019-08-04 22:10:36'),(275,151,'from',30,'STS\\User',NULL,'2019-08-04 22:10:36','2019-08-04 22:10:36'),(276,152,'trip',99,'STS\\Entities\\Trip',NULL,'2019-08-04 22:10:50','2019-08-04 22:10:50'),(277,152,'from',30,'STS\\User',NULL,'2019-08-04 22:10:50','2019-08-04 22:10:50'),(278,153,'trip',99,'STS\\Entities\\Trip',NULL,'2019-08-04 22:11:07','2019-08-04 22:11:07'),(279,153,'from',30,'STS\\User',NULL,'2019-08-04 22:11:07','2019-08-04 22:11:07'),(280,154,'trip',100,'STS\\Entities\\Trip',NULL,'2019-08-04 22:13:32','2019-08-04 22:13:32'),(281,154,'from',30,'STS\\User',NULL,'2019-08-04 22:13:32','2019-08-04 22:13:32'),(282,155,'trip',101,'STS\\Entities\\Trip',NULL,'2019-08-04 22:14:54','2019-08-04 22:14:54'),(283,155,'from',1,'STS\\User',NULL,'2019-08-04 22:14:54','2019-08-04 22:14:54'),(284,156,'trip',101,'STS\\Entities\\Trip',NULL,'2019-08-04 22:16:24','2019-08-04 22:16:24'),(285,156,'from',1,'STS\\User',NULL,'2019-08-04 22:16:24','2019-08-04 22:16:24'),(286,157,'trip',101,'STS\\Entities\\Trip',NULL,'2019-08-04 22:16:37','2019-08-04 22:16:37'),(287,157,'from',1,'STS\\User',NULL,'2019-08-04 22:16:37','2019-08-04 22:16:37'),(288,158,'trip',101,'STS\\Entities\\Trip',NULL,'2019-08-04 22:16:40','2019-08-04 22:16:40'),(289,158,'from',1,'STS\\User',NULL,'2019-08-04 22:16:40','2019-08-04 22:16:40'),(290,159,'trip',101,'STS\\Entities\\Trip',NULL,'2019-08-04 22:16:44','2019-08-04 22:16:44'),(291,159,'from',1,'STS\\User',NULL,'2019-08-04 22:16:44','2019-08-04 22:16:44'),(292,160,'trip',100,'STS\\Entities\\Trip',NULL,'2019-08-04 22:18:52','2019-08-04 22:18:52'),(293,160,'from',1,'STS\\User',NULL,'2019-08-04 22:18:52','2019-08-04 22:18:52'),(294,161,'trip',101,'STS\\Entities\\Trip',NULL,'2019-08-06 15:05:07','2019-08-06 15:05:07'),(295,161,'from',1,'STS\\User',NULL,'2019-08-06 15:05:07','2019-08-06 15:05:07'),(296,162,'trip',101,'STS\\Entities\\Trip',NULL,'2019-08-06 15:06:02','2019-08-06 15:06:02'),(297,162,'from',1,'STS\\User',NULL,'2019-08-06 15:06:03','2019-08-06 15:06:03'),(298,163,'trip',101,'STS\\Entities\\Trip',NULL,'2019-08-06 15:51:01','2019-08-06 15:51:01'),(299,163,'from',1,'STS\\User',NULL,'2019-08-06 15:51:01','2019-08-06 15:51:01'),(300,164,'trip',100,'STS\\Entities\\Trip',NULL,'2019-08-06 23:13:16','2019-08-06 23:13:16'),(301,164,'from',30,'STS\\User',NULL,'2019-08-06 23:13:16','2019-08-06 23:13:16'),(302,164,'canceledState',0,'','2','2019-08-06 23:13:16','2019-08-06 23:13:16'),(303,165,'trip',100,'STS\\Entities\\Trip',NULL,'2019-08-06 23:14:42','2019-08-06 23:14:42'),(304,165,'from',30,'STS\\User',NULL,'2019-08-06 23:14:43','2019-08-06 23:14:43');
328/*!40000 ALTER TABLE `notifications_params` ENABLE KEYS */;
329UNLOCK TABLES;
330
331--
332-- Table structure for table `password_resets`
333--
334
335DROP TABLE IF EXISTS `password_resets`;
336/*!40101 SET @saved_cs_client     = @@character_set_client */;
337/*!40101 SET character_set_client = utf8 */;
338CREATE TABLE `password_resets` (
339  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
340  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
341  `created_at` timestamp NOT NULL,
342  KEY `password_resets_email_index` (`email`),
343  KEY `password_resets_token_index` (`token`)
344) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
345/*!40101 SET character_set_client = @saved_cs_client */;
346
347--
348-- Dumping data for table `password_resets`
349--
350
351LOCK TABLES `password_resets` WRITE;
352/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
353/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
354UNLOCK TABLES;
355
356--
357-- Table structure for table `rating`
358--
359
360DROP TABLE IF EXISTS `rating`;
361/*!40101 SET @saved_cs_client     = @@character_set_client */;
362/*!40101 SET character_set_client = utf8 */;
363CREATE TABLE `rating` (
364  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
365  `trip_id` int(10) unsigned NOT NULL,
366  `user_id_from` int(10) unsigned NOT NULL,
367  `user_id_to` int(10) unsigned NOT NULL,
368  `user_to_type` int(11) NOT NULL,
369  `user_to_state` int(11) NOT NULL,
370  `rating` int(11) DEFAULT NULL,
371  `comment` text COLLATE utf8_unicode_ci NOT NULL,
372  `reply_comment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
373  `reply_comment_created_at` datetime DEFAULT NULL,
374  `voted` tinyint(1) NOT NULL,
375  `rate_at` datetime DEFAULT NULL,
376  `voted_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
377  `created_at` timestamp NULL DEFAULT NULL,
378  `updated_at` timestamp NULL DEFAULT NULL,
379  `available` tinyint(1) NOT NULL,
380  PRIMARY KEY (`id`),
381  KEY `rating_user_id_from_foreign` (`user_id_from`),
382  KEY `rating_user_id_to_foreign` (`user_id_to`),
383  KEY `rating_trip_id_foreign` (`trip_id`),
384  CONSTRAINT `rating_trip_id_foreign` FOREIGN KEY (`trip_id`) REFERENCES `trips` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
385  CONSTRAINT `rating_user_id_from_foreign` FOREIGN KEY (`user_id_from`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
386  CONSTRAINT `rating_user_id_to_foreign` FOREIGN KEY (`user_id_to`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
387) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
388/*!40101 SET character_set_client = @saved_cs_client */;
389
390--
391-- Dumping data for table `rating`
392--
393
394LOCK TABLES `rating` WRITE;
395/*!40000 ALTER TABLE `rating` DISABLE KEYS */;
396/*!40000 ALTER TABLE `rating` ENABLE KEYS */;
397UNLOCK TABLES;
398
399--
400-- Table structure for table `recurrent_trip_day`
401--
402
403DROP TABLE IF EXISTS `recurrent_trip_day`;
404/*!40101 SET @saved_cs_client     = @@character_set_client */;
405/*!40101 SET character_set_client = utf8 */;
406CREATE TABLE `recurrent_trip_day` (
407  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
408  `trip_id` int(10) unsigned NOT NULL,
409  `day` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
410  `hour` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
411  PRIMARY KEY (`id`),
412  KEY `recurrent_trip_day_trip_id_foreign` (`trip_id`),
413  CONSTRAINT `recurrent_trip_day_trip_id_foreign` FOREIGN KEY (`trip_id`) REFERENCES `trips` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
414) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
415/*!40101 SET character_set_client = @saved_cs_client */;
416
417--
418-- Dumping data for table `recurrent_trip_day`
419--
420
421LOCK TABLES `recurrent_trip_day` WRITE;
422/*!40000 ALTER TABLE `recurrent_trip_day` DISABLE KEYS */;
423/*!40000 ALTER TABLE `recurrent_trip_day` ENABLE KEYS */;
424UNLOCK TABLES;
425
426--
427-- Table structure for table `social_accounts`
428--
429
430DROP TABLE IF EXISTS `social_accounts`;
431/*!40101 SET @saved_cs_client     = @@character_set_client */;
432/*!40101 SET character_set_client = utf8 */;
433CREATE TABLE `social_accounts` (
434  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
435  `user_id` int(10) unsigned NOT NULL,
436  `provider_user_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
437  `provider` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
438  `created_at` timestamp NULL DEFAULT NULL,
439  `updated_at` timestamp NULL DEFAULT NULL,
440  PRIMARY KEY (`id`),
441  KEY `social_accounts_user_id_foreign` (`user_id`),
442  CONSTRAINT `social_accounts_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
443) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
444/*!40101 SET character_set_client = @saved_cs_client */;
445
446--
447-- Dumping data for table `social_accounts`
448--
449
450LOCK TABLES `social_accounts` WRITE;
451/*!40000 ALTER TABLE `social_accounts` DISABLE KEYS */;
452/*!40000 ALTER TABLE `social_accounts` ENABLE KEYS */;
453UNLOCK TABLES;
454
455--
456-- Table structure for table `subscriptions`
457--
458
459DROP TABLE IF EXISTS `subscriptions`;
460/*!40101 SET @saved_cs_client     = @@character_set_client */;
461/*!40101 SET character_set_client = utf8 */;
462CREATE TABLE `subscriptions` (
463  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
464  `user_id` int(10) unsigned NOT NULL,
465  `trip_date` datetime DEFAULT NULL,
466  `from_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
467  `from_json_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
468  `from_lat` double DEFAULT NULL,
469  `from_lng` double DEFAULT NULL,
470  `from_radio` double DEFAULT NULL,
471  `from_sin_lat` double DEFAULT NULL,
472  `from_cos_lat` double DEFAULT NULL,
473  `from_sin_lng` double DEFAULT NULL,
474  `from_cos_lng` double DEFAULT NULL,
475  `to_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
476  `to_json_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
477  `to_lat` double DEFAULT NULL,
478  `to_lng` double DEFAULT NULL,
479  `to_radio` double DEFAULT NULL,
480  `to_sin_lat` double DEFAULT NULL,
481  `to_cos_lat` double DEFAULT NULL,
482  `to_sin_lng` double DEFAULT NULL,
483  `to_cos_lng` double DEFAULT NULL,
484  `state` tinyint(1) NOT NULL,
485  `created_at` timestamp NULL DEFAULT NULL,
486  `updated_at` timestamp NULL DEFAULT NULL,
487  `is_passenger` tinyint(1) NOT NULL,
488  PRIMARY KEY (`id`),
489  KEY `subscriptions_user_id_foreign` (`user_id`),
490  CONSTRAINT `subscriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
491) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
492/*!40101 SET character_set_client = @saved_cs_client */;
493
494--
495-- Dumping data for table `subscriptions`
496--
497
498LOCK TABLES `subscriptions` WRITE;
499/*!40000 ALTER TABLE `subscriptions` DISABLE KEYS */;
500INSERT INTO `subscriptions` VALUES (1,23,'2019-08-04 00:00:00','Sport City, Al-Shaheed Street, Urjan al Sharqiyah, Tariq, Amman, 11192, Jordan','[]',31.9857183,35.9037253,14.580574759055,0.52970786102514,0.84818015890975,0.58642502339174,0.81000351353559,'German Jordanian University, Madaba Al Gharbi Street, Madaba, 17110, Jordan','[]',31.7767556,35.802320626992,600.87582729961,0.52661095805928,0.8501064044294,0.58499052468602,0.81104012602803,1,'2019-08-01 22:30:38','2019-08-01 22:30:38',0);
501/*!40000 ALTER TABLE `subscriptions` ENABLE KEYS */;
502UNLOCK TABLES;
503
504--
505-- Table structure for table `trip_passengers`
506--
507
508DROP TABLE IF EXISTS `trip_passengers`;
509/*!40101 SET @saved_cs_client     = @@character_set_client */;
510/*!40101 SET character_set_client = utf8 */;
511CREATE TABLE `trip_passengers` (
512  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
513  `user_id` int(10) unsigned NOT NULL,
514  `trip_id` int(10) unsigned NOT NULL,
515  `passenger_type` int(11) NOT NULL,
516  `request_state` int(11) NOT NULL,
517  `canceled_state` int(11) DEFAULT NULL,
518  `created_at` timestamp NULL DEFAULT NULL,
519  `updated_at` timestamp NULL DEFAULT NULL,
520  PRIMARY KEY (`id`),
521  KEY `trip_passengers_user_id_foreign` (`user_id`),
522  KEY `trip_passengers_trip_id_foreign` (`trip_id`),
523  CONSTRAINT `trip_passengers_trip_id_foreign` FOREIGN KEY (`trip_id`) REFERENCES `trips` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
524  CONSTRAINT `trip_passengers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
525) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
526/*!40101 SET character_set_client = @saved_cs_client */;
527
528--
529-- Dumping data for table `trip_passengers`
530--
531
532LOCK TABLES `trip_passengers` WRITE;
533/*!40000 ALTER TABLE `trip_passengers` DISABLE KEYS */;
534INSERT INTO `trip_passengers` VALUES (41,30,95,1,3,0,'2019-08-04 21:29:19','2019-08-04 21:29:58'),(42,30,95,1,3,0,'2019-08-04 21:30:35','2019-08-04 21:31:26'),(43,30,96,1,3,0,'2019-08-04 21:31:44','2019-08-04 21:32:53'),(44,1,97,1,0,NULL,'2019-08-04 21:34:26','2019-08-04 21:34:26'),(45,1,97,1,0,NULL,'2019-08-04 21:34:29','2019-08-04 21:34:29'),(46,1,97,1,0,NULL,'2019-08-04 21:34:30','2019-08-04 21:34:30'),(47,30,95,1,3,0,'2019-08-04 21:35:14','2019-08-04 21:35:28'),(48,30,95,1,0,NULL,'2019-08-04 21:36:16','2019-08-04 21:36:16'),(49,1,98,1,3,0,'2019-08-04 21:43:18','2019-08-04 21:43:52'),(50,1,98,1,3,0,'2019-08-04 21:44:04','2019-08-04 21:44:57'),(51,1,98,1,3,0,'2019-08-04 21:44:09','2019-08-04 21:44:57'),(52,1,98,1,3,0,'2019-08-04 21:45:43','2019-08-04 21:46:19'),(53,1,98,1,3,0,'2019-08-04 21:52:55','2019-08-04 21:58:56'),(54,3,98,1,0,NULL,'2019-08-04 21:58:07','2019-08-04 21:58:07'),(55,1,98,1,0,NULL,'2019-08-04 21:59:10','2019-08-04 21:59:10'),(56,30,99,1,3,0,'2019-08-04 22:03:53','2019-08-04 22:06:35'),(57,30,99,1,3,0,'2019-08-04 22:04:38','2019-08-04 22:06:35'),(58,30,99,1,3,0,'2019-08-04 22:06:32','2019-08-04 22:06:35'),(59,30,99,1,3,0,'2019-08-04 22:06:46','2019-08-04 22:10:35'),(60,30,99,1,3,0,'2019-08-04 22:08:22','2019-08-04 22:10:35'),(61,30,99,1,3,0,'2019-08-04 22:10:50','2019-08-04 22:11:07'),(62,30,100,1,3,2,'2019-08-04 22:13:32','2019-08-06 23:13:16'),(63,1,101,1,3,0,'2019-08-04 22:14:54','2019-08-04 22:16:44'),(64,1,101,1,3,0,'2019-08-04 22:16:24','2019-08-04 22:16:44'),(65,1,101,1,3,0,'2019-08-04 22:16:37','2019-08-04 22:16:44'),(66,1,101,1,3,0,'2019-08-04 22:16:39','2019-08-04 22:16:44'),(67,1,101,1,3,0,'2019-08-06 15:05:07','2019-08-06 15:06:02'),(68,1,101,1,0,NULL,'2019-08-06 15:51:01','2019-08-06 15:51:01'),(69,30,100,1,0,NULL,'2019-08-06 23:14:42','2019-08-06 23:14:42');
535/*!40000 ALTER TABLE `trip_passengers` ENABLE KEYS */;
536UNLOCK TABLES;
537
538--
539-- Table structure for table `trips`
540--
541
542DROP TABLE IF EXISTS `trips`;
543/*!40101 SET @saved_cs_client     = @@character_set_client */;
544/*!40101 SET character_set_client = utf8 */;
545CREATE TABLE `trips` (
546  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
547  `user_id` int(10) unsigned NOT NULL,
548  `from_town` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
549  `to_town` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
550  `trip_date` datetime NOT NULL,
551  `description` varchar(1500) COLLATE utf8_unicode_ci NOT NULL,
552  `total_seats` int(11) NOT NULL,
553  `friendship_type_id` int(11) NOT NULL,
554  `distance` double NOT NULL,
555  `estimated_time` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
556  `co2` double NOT NULL,
557  `es_recurrente` int(11) DEFAULT NULL,
558  `is_passenger` tinyint(1) NOT NULL,
559  `mail_send` tinyint(1) NOT NULL DEFAULT '0',
560  `enc_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
561  `created_at` timestamp NULL DEFAULT NULL,
562  `updated_at` timestamp NULL DEFAULT NULL,
563  `deleted_at` timestamp NULL DEFAULT NULL,
564  `return_trip_id` int(10) unsigned DEFAULT NULL,
565  `car_id` int(10) unsigned DEFAULT NULL,
566  `parent_trip_id` int(10) unsigned DEFAULT NULL,
567  PRIMARY KEY (`id`),
568  KEY `trips_user_id_foreign` (`user_id`),
569  KEY `trips_return_trip_id_foreign` (`return_trip_id`),
570  KEY `trips_car_id_foreign` (`car_id`),
571  KEY `trips_parent_trip_id_foreign` (`parent_trip_id`),
572  CONSTRAINT `trips_car_id_foreign` FOREIGN KEY (`car_id`) REFERENCES `cars` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
573  CONSTRAINT `trips_parent_trip_id_foreign` FOREIGN KEY (`parent_trip_id`) REFERENCES `trips` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
574  CONSTRAINT `trips_return_trip_id_foreign` FOREIGN KEY (`return_trip_id`) REFERENCES `trips` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
575  CONSTRAINT `trips_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
576) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
577/*!40101 SET character_set_client = @saved_cs_client */;
578
579--
580-- Dumping data for table `trips`
581--
582
583LOCK TABLES `trips` WRITE;
584/*!40000 ALTER TABLE `trips` DISABLE KEYS */;
585INSERT INTO `trips` VALUES (95,1,'Amman, 11181, Jordan','Madaba, 17110, Jordan','2019-08-04 22:00:00','',1,2,38989,'00:50',5848.35,NULL,0,0,'123','2019-08-04 21:24:59','2019-08-04 21:42:20','2019-08-04 21:42:20',NULL,1,NULL),(96,1,'Amman, 11181, Jordan','Madaba, 17110, Jordan','2019-08-27 22:00:00','',1,2,38989,'00:50',5848.35,NULL,0,0,'123','2019-08-04 21:31:09','2019-08-04 21:43:41','2019-08-04 21:43:41',NULL,1,NULL),(97,30,'7th Circle, Zahran Street, Sweifieh, Amman, 11195, Jordan','German Jordanian University, Madaba Al Gharbi Street, Madaba, 17110, Jordan','2019-08-27 22:00:00','',1,2,22615.2,'00:28',3392.28,NULL,0,0,'123','2019-08-04 21:33:19','2019-08-04 21:35:07','2019-08-04 21:35:07',NULL,5,NULL),(98,30,'Amman, 11181, Jordan','Madaba, 17110, Jordan','2019-08-04 22:00:00','',1,2,38989,'00:50',5848.35,NULL,0,0,'123','2019-08-04 21:42:55','2019-08-04 21:42:55',NULL,NULL,5,NULL),(99,1,'Buenos Aires, Ciudad Autónoma de Buenos Aires, Argentina','Santo Tomé, Municipio de Santo Tomé, Departamento Santo Tomé, Corrientes, 3340, Argentina','2019-08-20 22:00:00','',2,2,849481.2,'10:07',127422.18,NULL,0,0,'123','2019-08-04 22:03:19','2019-08-04 22:11:49','2019-08-04 22:11:49',NULL,1,NULL),(100,1,'Villa Mercedes, Municipio de Villa Mercedes, General Pedernera, San Luis, D5730, Argentina','San Luis, Municipio de San Luis, Juan Martín de Pueyrredón, San Luis, Argentina','2019-08-28 23:00:00','',2,2,0,'00:00',0,NULL,0,0,'123','2019-08-04 22:12:52','2019-08-04 22:12:52',NULL,NULL,1,NULL),(101,30,'San Luis, Municipio de San Luis, Juan Martín de Pueyrredón, San Luis, Argentina','Municipio de San Marcos Sierras, Pedanía San Marcos, Departamento Cruz del Eje, Córdoba, X5280, Argentina','2019-08-27 23:00:00','',2,2,405991.8,'06:04',60898.77,NULL,0,0,'123','2019-08-04 22:14:24','2019-08-04 22:14:24',NULL,NULL,5,NULL),(102,1,'Amman, 11181, Jordan','Madaba, 17110, Jordan','2019-08-06 16:00:00','',1,2,39177.9,'00:51',5876.685,NULL,0,0,'123','2019-08-06 15:05:32','2019-08-06 15:05:32',NULL,NULL,1,NULL);
586/*!40000 ALTER TABLE `trips` ENABLE KEYS */;
587UNLOCK TABLES;
588
589--
590-- Table structure for table `trips_points`
591--
592
593DROP TABLE IF EXISTS `trips_points`;
594/*!40101 SET @saved_cs_client     = @@character_set_client */;
595/*!40101 SET character_set_client = utf8 */;
596CREATE TABLE `trips_points` (
597  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
598  `trip_id` int(10) unsigned NOT NULL,
599  `address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
600  `json_address` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
601  `lat` double NOT NULL,
602  `lng` double NOT NULL,
603  `sin_lat` double NOT NULL,
604  `cos_lat` double NOT NULL,
605  `sin_lng` double NOT NULL,
606  `cos_lng` double NOT NULL,
607  `created_at` timestamp NULL DEFAULT NULL,
608  `updated_at` timestamp NULL DEFAULT NULL,
609  PRIMARY KEY (`id`),
610  KEY `trips_points_trip_id_foreign` (`trip_id`),
611  CONSTRAINT `trips_points_trip_id_foreign` FOREIGN KEY (`trip_id`) REFERENCES `trips` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
612) ENGINE=InnoDB AUTO_INCREMENT=239 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
613/*!40101 SET character_set_client = @saved_cs_client */;
614
615--
616-- Dumping data for table `trips_points`
617--
618
619LOCK TABLES `trips_points` WRITE;
620/*!40000 ALTER TABLE `trips_points` DISABLE KEYS */;
621INSERT INTO `trips_points` VALUES (223,95,'Amman, 11181, Jordan','{\"country\":\"Jordan\",\"province\":\"Amman\",\"city\":\"Amman\",\"Street\":\"\",\"number\":\"\"}',31.9515694,35.9239625,0.52920224248637,0.84849571981678,0.58671108472209,0.80979633431143,'2019-08-04 21:24:59','2019-08-04 21:24:59'),(224,95,'Madaba, 17110, Jordan','{\"country\":\"Jordan\",\"province\":\"Madaba\",\"city\":\"Madaba\",\"Street\":\"\",\"number\":\"\"}',31.7165941,35.7943856,0.52571804237442,0.85065888575974,0.58487819622551,0.81112113496073,'2019-08-04 21:24:59','2019-08-04 21:24:59'),(225,96,'Amman, 11181, Jordan','{\"country\":\"Jordan\",\"province\":\"Amman\",\"city\":\"Amman\",\"Street\":\"\",\"number\":\"\"}',31.9515694,35.9239625,0.52920224248637,0.84849571981678,0.58671108472209,0.80979633431143,'2019-08-04 21:31:09','2019-08-04 21:31:09'),(226,96,'Madaba, 17110, Jordan','{\"country\":\"Jordan\",\"province\":\"Madaba\",\"city\":\"Madaba\",\"Street\":\"\",\"number\":\"\"}',31.7165941,35.7943856,0.52571804237442,0.85065888575974,0.58487819622551,0.81112113496073,'2019-08-04 21:31:09','2019-08-04 21:31:09'),(227,97,'7th Circle, Zahran Street, Sweifieh, Amman, 11195, Jordan','{\"country\":\"Jordan\",\"province\":\"Amman\",\"city\":\"7th Circle\",\"Street\":\"\",\"number\":\"\"}',31.9593416,35.8576141,0.52931733646885,0.84842392547212,0.58577294899122,0.81047520148993,'2019-08-04 21:33:19','2019-08-04 21:33:19'),(228,97,'German Jordanian University, Madaba Al Gharbi Street, Madaba, 17110, Jordan','{\"country\":\"Jordan\",\"province\":\"Madaba\",\"city\":\"German Jordanian University\",\"Street\":\"\",\"number\":\"\"}',31.7767556,35.802320626992,0.52661095805928,0.8501064044294,0.58499052468602,0.81104012602803,'2019-08-04 21:33:19','2019-08-04 21:33:19'),(229,98,'Amman, 11181, Jordan','{\"country\":\"Jordan\",\"province\":\"Amman\",\"city\":\"Amman\",\"Street\":\"\",\"number\":\"\"}',31.9515694,35.9239625,0.52920224248637,0.84849571981678,0.58671108472209,0.80979633431143,'2019-08-04 21:42:55','2019-08-04 21:42:55'),(230,98,'Madaba, 17110, Jordan','{\"country\":\"Jordan\",\"province\":\"Madaba\",\"city\":\"Madaba\",\"Street\":\"\",\"number\":\"\"}',31.7165941,35.7943856,0.52571804237442,0.85065888575974,0.58487819622551,0.81112113496073,'2019-08-04 21:42:55','2019-08-04 21:42:55'),(231,99,'Buenos Aires, Ciudad Autónoma de Buenos Aires, Argentina','{\"pais\":\"Argentina\",\"provincia\":\"Ciudad Aut\\u00f3noma de Buenos Aires\",\"ciudad\":\"Buenos Aires\",\"calle\":\"\",\"numero\":\"\"}',-34.6075616,-58.437076,-0.56795237337899,0.82306142029205,-0.85206582617003,0.52343464527407,'2019-08-04 22:03:19','2019-08-04 22:03:19'),(232,99,'Santo Tomé, Municipio de Santo Tomé, Departamento Santo Tomé, Corrientes, 3340, Argentina','{\"pais\":\"Argentina\",\"provincia\":\"Corrientes\",\"ciudad\":\"Santo Tom\\u00e9\",\"calle\":\"\",\"numero\":\"\"}',-28.5497034,-56.0351419,-0.47792094390593,0.8784028525546,-0.82938039301219,0.55868431487464,'2019-08-04 22:03:19','2019-08-04 22:03:19'),(233,100,'Villa Mercedes, Municipio de Villa Mercedes, General Pedernera, San Luis, D5730, Argentina','{\"pais\":\"Argentina\",\"provincia\":\"San Luis\",\"ciudad\":\"Villa Mercedes\",\"calle\":\"\",\"numero\":\"\"}',-33.6740913,-65.462277,-0.55446816763601,0.83220493334176,-0.90968804355846,0.41529226263774,'2019-08-04 22:12:53','2019-08-04 22:12:53'),(234,100,'San Luis, Municipio de San Luis, Juan Martín de Pueyrredón, San Luis, Argentina','{\"pais\":\"Argentina\",\"provincia\":\"San Luis\",\"ciudad\":\"San Luis\",\"calle\":\"\",\"numero\":\"\"}',-33.3019696,-66.3369903,-0.54905154939172,0.83578848766333,-0.91592190099631,0.40135653884709,'2019-08-04 22:12:53','2019-08-04 22:12:53'),(235,101,'San Luis, Municipio de San Luis, Juan Martín de Pueyrredón, San Luis, Argentina','{\"pais\":\"Argentina\",\"provincia\":\"San Luis\",\"ciudad\":\"San Luis\",\"calle\":\"\",\"numero\":\"\"}',-33.3019696,-66.3369903,-0.54905154939172,0.83578848766333,-0.91592190099631,0.40135653884709,'2019-08-04 22:14:24','2019-08-04 22:14:24'),(236,101,'Municipio de San Marcos Sierras, Pedanía San Marcos, Departamento Cruz del Eje, Córdoba, X5280, Argentina','{\"pais\":\"Argentina\",\"provincia\":\"C\\u00f3rdoba\",\"ciudad\":\"Municipio de San Marcos Sierras\",\"calle\":\"\",\"numero\":\"\"}',-30.76695565,-64.6504909,-0.51154738947374,0.85925506592781,-0.90371293361991,0.42813891858612,'2019-08-04 22:14:24','2019-08-04 22:14:24'),(237,102,'Amman, 11181, Jordan','{\"country\":\"Jordan\",\"province\":\"Amman\",\"city\":\"Amman\",\"Street\":\"\",\"number\":\"\"}',31.9515694,35.9239625,0.52920224248637,0.84849571981678,0.58671108472209,0.80979633431143,'2019-08-06 15:05:32','2019-08-06 15:05:32'),(238,102,'Madaba, 17110, Jordan','{\"country\":\"Jordan\",\"province\":\"Madaba\",\"city\":\"Madaba\",\"Street\":\"\",\"number\":\"\"}',31.7165941,35.7943856,0.52571804237442,0.85065888575974,0.58487819622551,0.81112113496073,'2019-08-06 15:05:32','2019-08-06 15:05:32');
622/*!40000 ALTER TABLE `trips_points` ENABLE KEYS */;
623UNLOCK TABLES;
624
625--
626-- Table structure for table `user_message_read`
627--
628
629DROP TABLE IF EXISTS `user_message_read`;
630/*!40101 SET @saved_cs_client     = @@character_set_client */;
631/*!40101 SET character_set_client = utf8 */;
632CREATE TABLE `user_message_read` (
633  `created_at` timestamp NULL DEFAULT NULL,
634  `updated_at` timestamp NULL DEFAULT NULL,
635  `user_id` int(10) unsigned NOT NULL,
636  `message_id` int(10) unsigned NOT NULL,
637  `read` tinyint(1) NOT NULL,
638  KEY `user_message_read_user_id_foreign` (`user_id`),
639  KEY `user_message_read_message_id_foreign` (`message_id`),
640  CONSTRAINT `user_message_read_message_id_foreign` FOREIGN KEY (`message_id`) REFERENCES `messages` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
641  CONSTRAINT `user_message_read_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
642) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
643/*!40101 SET character_set_client = @saved_cs_client */;
644
645--
646-- Dumping data for table `user_message_read`
647--
648
649LOCK TABLES `user_message_read` WRITE;
650/*!40000 ALTER TABLE `user_message_read` DISABLE KEYS */;
651INSERT INTO `user_message_read` VALUES (NULL,NULL,30,8,0),(NULL,NULL,30,9,0),(NULL,NULL,30,10,0);
652/*!40000 ALTER TABLE `user_message_read` ENABLE KEYS */;
653UNLOCK TABLES;
654
655--
656-- Table structure for table `users`
657--
658
659DROP TABLE IF EXISTS `users`;
660/*!40101 SET @saved_cs_client     = @@character_set_client */;
661/*!40101 SET character_set_client = utf8 */;
662CREATE TABLE `users` (
663  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
664  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
665  `email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
666  `password` varchar(60) COLLATE utf8_unicode_ci DEFAULT NULL,
667  `terms_and_conditions` tinyint(1) NOT NULL,
668  `birthday` date DEFAULT NULL,
669  `gender` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
670  `nro_doc` varchar(15) COLLATE utf8_unicode_ci DEFAULT NULL,
671  `patente` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
672  `description` varchar(1000) COLLATE utf8_unicode_ci DEFAULT NULL,
673  `mobile_phone` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
674  `cartype` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
675  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
676  `banned` tinyint(1) NOT NULL DEFAULT '0',
677  `is_admin` tinyint(1) NOT NULL DEFAULT '0',
678  `active` tinyint(1) NOT NULL DEFAULT '0',
679  `activation_token` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
680  `emails_notifications` tinyint(1) NOT NULL,
681  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
682  `created_at` timestamp NULL DEFAULT NULL,
683  `updated_at` timestamp NULL DEFAULT NULL,
684  `last_connection` datetime DEFAULT NULL,
685  `has_pin` tinyint(1) NOT NULL DEFAULT '0',
686  `is_member` tinyint(1) NOT NULL DEFAULT '0',
687  `monthly_donate` tinyint(1) NOT NULL DEFAULT '0',
688  `do_not_alert_request_seat` tinyint(1) NOT NULL,
689  `do_not_alert_accept_passenger` tinyint(1) NOT NULL,
690  `do_not_alert_pending_rates` tinyint(1) NOT NULL,
691  PRIMARY KEY (`id`)
692) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
693/*!40101 SET character_set_client = @saved_cs_client */;
694
695--
696-- Dumping data for table `users`
697--
698
699LOCK TABLES `users` WRITE;
700/*!40000 ALTER TABLE `users` DISABLE KEYS */;
701INSERT INTO `users` VALUES (1,'Khaled Daoudieh','K.daoudieh@gju.edu.jo','$2y$10$CETdtlIK9eQv6dXiL7WOpeJdqBUOogViuqhgpHxLiNcJm2gATWru6',1,'1995-08-09','male','Hd62272728','','CTO @lessgoapp  | Web #developer, #DevOps engineer and #Infosec, Into #Startups, #Cyber_security and #Privacy, #CS Student @ GJU','5467878484884','Porsche','080120191254340770740001564653274.jpeg',0,1,1,'NULL',0,'NULL','2019-07-28 16:54:50','2019-08-06 16:10:04','2019-08-06 16:10:04',1,1,0,1,1,1),(3,'Ahmad Abualfeilat','a.abualfeilat@gju.edu.jo','$2y$10$2GROzYRq2WZ3PfCky3Ayl.eXJrHc6R2fMk7pzjYFVnC3fNJcGUHtG',1,'1995-02-11','male','','','Traveling around ','0799433424','Ford Fusion','072920191457540262826001564401474.jpeg',0,0,1,'NULL',1,'NULL','2019-07-29 14:53:45','2019-08-06 15:02:40','2019-08-06 15:02:40',0,0,0,1,1,1),(4,'Raed Abdallah','ra.abdallah@gju.edu.jo','$2y$10$cHghQlgZJRn8Qx8/aNgC9.RHYStMJ3B7fdiNpRnMWHmssvH1UR6/K',1,'1997-07-24','male','','','Hi i love food','NULL','NULL','073020191601330704402001564491693.jpeg',0,0,1,'NULL',1,'NULL','2019-07-30 15:59:56','2019-08-01 20:30:33','2019-08-01 20:30:33',0,0,0,0,0,0),(5,'Mohammed  Rashdan ','Mohammed.rashdan@gju.edu.jo','$2y$10$82yr95b6jHiPKIkxsbAc/OizzXYtJZ3bI.FOszkrguomwMD2PGDSC',1,'0000-00-00','male','NULL','','NULL','NULL','NULL','NULL',0,0,1,'NULL',1,'NULL','2019-08-01 13:41:01','2019-08-04 12:23:49','2019-08-04 12:23:49',0,0,0,0,0,0),(7,'Mohammad Obaid','m.obaid1@gju.edu.jo','$2y$10$/h7GneyNCrgfcq4CwMYnEO2PjQLlpoFkIm671eEayQBAKVjacDP.u',1,'0000-00-00','male','NULL','','NULL','NULL','NULL','080120191532580675738001564662778.jpeg',0,0,1,'NULL',1,'NULL','2019-08-01 15:10:56','2019-08-01 16:01:50','2019-08-01 16:01:50',0,0,0,0,0,0),(8,'Ahmed  Shwiat ','A.AlShwiat@gju.edu.jo','$2y$10$0w/YcFbLM9uIUfcZfU1z0ecvWbQF5tlTr20I6S5z4gETfgGMkh9ka',1,'0000-00-00','male','NULL','','NULL','NULL','NULL','NULL',0,0,1,'NULL',1,'NULL','2019-08-01 15:52:21','2019-08-06 16:16:26','2019-08-06 16:16:26',0,0,0,0,0,0),(9,'owen majali','ow.almajali@gju.edu.jo','$2y$10$h5XNupVSBl5GYgq04A.HMO1yZJv/GhcBqLi4NvBK9MSeeO9xAZRWi',1,'1997-01-15','male','','','no smoking ❌','+962772809610','audi','080120191613140908523001564665194.jpeg',0,0,1,'NULL',1,'NULL','2019-08-01 16:12:00','2019-08-04 18:22:52','2019-08-04 18:22:52',0,0,0,0,0,0),(10,'Ibrahim Lello','i.lello@gju.edu.jo','$2y$10$LohYzIu74YCZIQSZBlE4t.rz87QPhAzHc/mJGeOPSyu5C9M7LhSnK',1,'1999-02-21','male','9991006195','','Don\'t  forget to bring snacks with you ','0790622462','Nissan','080120191624190070249001564665859.jpeg',0,0,1,'NULL',1,'NULL','2019-08-01 16:14:47','2019-08-01 16:29:21','2019-08-01 16:29:21',0,0,0,0,0,0),(11,'Amer Ghaith','A.Ghaith1@gju.edu.jo','$2y$10$PW2UE1iYkzk7qo7oR2k8oOU1LRv9OmJ4OsoTjwOksIVG/DAYEKLWm',1,'0000-00-00','male','NULL','','NULL','NULL','NULL','NULL',0,0,1,'NULL',1,'NULL','2019-08-01 16:27:49','2019-08-01 16:35:16','2019-08-01 16:35:16',0,0,0,0,0,0),(12,'Sufyan Hassan','sufyan@gju.edu.jo','$2y$10$89eSUaQEJ7OJE1KU8rOXfeK2Q5W/C458bWBqvJs0MKtCYQNWfBbWS',1,'0000-00-00','male','NULL','','NULL','NULL','NULL','NULL',0,0,0,'nowje9RHAqFzJfVc8gvYvttKV6nHy7MB2txvodld',1,'NULL','2019-08-01 16:34:58','2019-08-01 16:34:58','2019-08-01 13:34:58',0,0,0,0,0,0),(13,'Rashad Barakeh','R.barakeh@gju.edu.jo','$2y$10$EdTkQJLRA3lwizSsWCKgHu79J011Tptrq3P4HkwlfMHYHlvk6u1zO',1,'0000-00-00','male','NULL','','NULL','NULL','NULL','NULL',0,0,1,'NULL',1,'NULL','2019-08-01 16:59:29','2019-08-04 23:05:20','2019-08-04 23:05:20',0,0,0,0,0,0),(14,'Nadeem Adnan','N.Frihat@gju.edu.jo','$2y$10$EAcLTmVokqVf880ZxqZDbOXdTYVeL5QQNm9R8UVXAsjcSHRYTLTE2',1,'0000-00-00','male','NULL','','NULL','NULL','NULL','NULL',0,0,1,'NULL',1,'NULL','2019-08-01 16:59:39','2019-08-06 16:22:00','2019-08-06 16:22:00',0,0,0,0,0,0),(15,'Omar Qawas','O.alkawas@gju.edu.jo','$2y$10$8rdVOIA6na0.uQPls2iHq.2CKE70oOkOe9G1e5QyQak8IJ.KNPJgG',1,'1995-07-03','male','9951039669','','A 5th year student Energy engineering\n','0790329003','Suziki','080420190924060098254001564899846.jpeg',0,0,1,'NULL',1,'NULL','2019-08-01 17:25:34','2019-08-05 00:11:01','2019-08-05 00:11:01',0,0,0,0,0,0),(16,'Ahmad IIIII','s.ssjhd@gju.edu.jo','$2y$10$Lwiark93vaZ8Xv59nTILTuYIcS6nZvZUyF3zO5EcBTEb4N.0W1Kj.',1,'0000-00-00','male','NULL','','NULL','NULL','NULL','NULL',0,0,0,'LM07kAYjtp9QIrOGok8Z8jnBluyH9rDcvKPIQYkF',1,'NULL','2019-08-01 17:39:52','2019-08-01 17:39:52','2019-08-01 14:39:52',0,0,0,0,0,0),(17,'Sanad Jawabreh','s.jawabreh@gju.edu.jo','$2y$10$b2odATDOO1XkM4EXI5FcwONhq0qS.dAu9.XlRqda19w12b/5sZzHq',1,'1998-11-27','male','9981060499','','I love volleyball','0795663675','Ioniq','080120191749510801640001564670991.jpeg',0,0,1,'NULL',1,'NULL','2019-08-01 17:45:44','2019-08-02 09:45:47','2019-08-02 09:45:47',0,0,0,1,0,0),(18,'Adnan Qatouni','a.qatouni@gju.edu.jo','$2y$10$CY.mcet19.bFiQ3LX5q5y.NdH1sw39I5MwhnkF.AZg0Sj6U4E4r46',1,'0000-00-00','male','NULL','','NULL','NULL','NULL','NULL',0,0,1,NULL,1,'NULL','2019-08-01 18:26:09','2019-08-04 14:25:36','2019-08-04 14:25:36',0,0,0,0,0,0),(19,'Mohmmed  Bani Yasin ','m.yasin@gju.edu.jo','$2y$10$YDfLpHNpyWNqrfA6hf0r4ui7RPNhGcpCeEZXV69xyj3aXFgDpWIgK',1,'0000-00-00','male','NULL','','NULL','NULL','NULL','NULL',0,0,1,'NULL',1,'NULL','2019-08-01 18:27:11','2019-08-01 22:14:37','2019-08-01 22:14:37',0,0,0,0,0,0),(20,'Rund Sunna','R.sunna1@gju.edu.jo','$2y$10$rM7aSpIVfwz8bzwlicjqiuJIfIInGI/VpuTYhzV795DfCOcxlS946',1,'1999-10-02','female','','','Translation @GJU','0770787344','NULL','NULL',0,0,1,'NULL',1,'NULL','2019-08-01 18:44:54','2019-08-01 18:50:24','2019-08-01 18:50:24',0,0,0,0,0,0),(21,'Yousef  Juwailes ','Y.juwalies@gju.edu.jo','$2y$10$sm85egKomXjKDWUsMWdcT..ngqTzt1EPlh/BblyCrz0D7DSEb07We',1,'1998-03-12','male','P312959','','5th year mechanical engineering student, particular interested in movies, music and art. I\'ll.. get you snacks.. ',NULL,NULL,'080120192145280896112001564685128.jpeg',0,0,1,NULL,1,NULL,'2019-08-01 21:39:10','2019-08-02 09:03:57','2019-08-02 09:03:57',0,0,0,0,0,0),(22,'Wissam Ataleh','W.ataleh@gju.edu.jo','$2y$10$QSKviw9tv8q3mrup3M3bfeygMiQ7cRDPwqBeR7FMy9j1PWudpG8xu',1,'1990-11-04','male','','','Wissam ataleh\n',NULL,NULL,'080120192152090990309001564685529.jpeg',0,0,1,NULL,1,NULL,'2019-08-01 21:46:23','2019-08-06 16:03:19','2019-08-06 16:03:19',0,0,0,0,0,0),(23,'Maen Zaid','m.almuhaisen@gju.edu.jo','$2y$10$TLijM2gxTLheY1kB2XUogeiiaUQSpy7T5sNmtE0vbQ4.sLzntBxXu',1,'1996-08-10','male','','','Industrial Engineering Student @GJU\n','0792862679',NULL,'080120192226250212903001564687585.jpeg',0,0,1,NULL,1,NULL,'2019-08-01 22:25:00','2019-08-01 22:31:24','2019-08-01 22:31:24',0,0,0,0,0,0),(24,'Amjad Haddad','a.haddad@gju.edu.jo','$2y$10$6AZdx1T13ZApamZwiW9v0e2EyVwM5LexfOe1e5OEzGwN4DYGGG1Uu',1,NULL,'male',NULL,'',NULL,NULL,NULL,NULL,0,0,1,NULL,1,NULL,'2019-08-01 22:48:22','2019-08-01 22:50:09','2019-08-01 22:50:09',0,0,0,0,0,0),(25,'Ali Abunowar','A.abunowar@gju.edu.jo','$2y$10$DFZbWqu0U.2WmG1m6/Acxed9Q9fLWKnxE7bzVi35mBNAoPqZOIAf6',1,NULL,'male',NULL,'',NULL,NULL,NULL,NULL,0,0,1,NULL,1,NULL,'2019-08-02 11:01:00','2019-08-02 11:07:22','2019-08-02 11:07:22',0,0,0,0,0,0),(26,'Ibraheem Nofal','I.nofal@gju.edu.jo','$2y$10$5wm2A4/xWpzqssh/aoefIu7Bn/RuTcJsk1nv2Rl/SrZ3ebefp.H1W',1,'1996-01-17','male','','','A GJU computer engineering graduate',NULL,NULL,NULL,0,0,1,NULL,1,NULL,'2019-08-02 16:31:44','2019-08-06 19:39:02','2019-08-06 19:39:02',0,0,0,0,0,0),(27,'Tareq Rafed','T.rafid@gju.edu.jo','$2y$10$Hxmlt21EJ1IGPvyfAiBrL.vnhHvsFmNsooaWNv0FM8z5UdRyYeG5i',1,NULL,'male',NULL,'',NULL,NULL,NULL,NULL,0,0,1,NULL,1,NULL,'2019-08-02 19:51:47','2019-08-02 20:47:29','2019-08-02 20:47:29',0,0,0,0,0,0),(28,'Ali Al-Rifaie','A.dawoud@gju.edu.jo','$2y$10$fmR7qYMVAQS5KLxWa5mUlOL3qW6OWBpvxYGJ6QRbIYLHaJJEoIkUa',1,'1999-06-30','male','9991031295','','Mechanical and maintenance engineering , from Irbid , I live in Marj Al-hamam and I prefer music while driving . ','0790164050','Ford Fusion T 2017','080320190025150204437001564781115.jpeg',0,0,1,NULL,0,NULL,'2019-08-03 00:12:05','2019-08-03 00:39:45','2019-08-03 00:39:45',0,0,0,0,0,0),(29,'Ehab Hwaidi','I.huwaidi@gju.edu.jo','$2y$10$X/mcJgkOA4X7HaSEcpgES.W4q3pGKPoF6a8vTi.nwjlH0wq.ZzPNm',1,'1999-10-23','male','','','I love my University ','0797253183',NULL,'080420190023580265960001564867438.jpeg',0,0,1,NULL,1,NULL,'2019-08-04 00:16:07','2019-08-04 10:18:39','2019-08-04 10:18:39',0,0,0,0,0,0),(30,'test test','test@gju.edu.jo','$2y$10$9F1wzMLwwBKIDzx/b8lUqO5PZvKH85qP1uB5GM4yRKdSc7g9jqHKO',1,'1990-08-16','male','1231231231','','kjashdjahshdjkahdj kjashdjahshdjkahdjkjashdjahshdjkahdj kjashdjahshdjkahdj',NULL,NULL,'080420191445590641825001564919159.jpeg',0,0,1,NULL,1,NULL,'2019-08-04 14:44:31','2019-08-06 23:16:12','2019-08-06 23:16:12',0,0,0,1,0,0),(31,'Dea\'a Algharabli','D.algharabli@gju.edu.jo','$2y$10$0.7EGTFd1NogquM67ge3i.cM2U6ogLhZpfZn6Q7U4KgeEdGozsNRi',1,NULL,'male',NULL,'',NULL,NULL,NULL,NULL,0,0,0,'A9dS30h2UfFUuugm5SPWxHBxLUCd15YUaVWgOD3w',1,NULL,'2019-08-04 19:10:52','2019-08-04 19:10:52',NULL,0,0,0,0,0,0),(32,'Omar Haitham ','O.qader@gju.edu.jo','$2y$10$FiUh.aAH1KnBMVdr7kdYI.i3pJSuU3wPEpLaH5rjfZsSFq5Gn0QQC',1,NULL,'male',NULL,'',NULL,NULL,NULL,NULL,0,0,1,NULL,1,NULL,'2019-08-06 16:11:13','2019-08-06 16:20:06','2019-08-06 16:20:06',0,0,0,0,0,0);
702/*!40000 ALTER TABLE `users` ENABLE KEYS */;
703UNLOCK TABLES;
704
705--
706-- Table structure for table `users_devices`
707--
708
709DROP TABLE IF EXISTS `users_devices`;
710/*!40101 SET @saved_cs_client     = @@character_set_client */;
711/*!40101 SET character_set_client = utf8 */;
712CREATE TABLE `users_devices` (
713  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
714  `user_id` int(10) unsigned NOT NULL,
715  `session_id` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
716  `device_id` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
717  `device_type` varchar(12) COLLATE utf8_unicode_ci NOT NULL,
718  `app_version` int(11) NOT NULL,
719  `created_at` timestamp NULL DEFAULT NULL,
720  `updated_at` timestamp NULL DEFAULT NULL,
721  `notifications` tinyint(1) NOT NULL,
722  `language` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
723  PRIMARY KEY (`id`),
724  KEY `users_devices_user_id_foreign` (`user_id`),
725  CONSTRAINT `users_devices_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
726) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
727/*!40101 SET character_set_client = @saved_cs_client */;
728
729--
730-- Dumping data for table `users_devices`
731--
732
733LOCK TABLES `users_devices` WRITE;
734/*!40000 ALTER TABLE `users_devices` DISABLE KEYS */;
735INSERT INTO `users_devices` VALUES (18,5,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjUsImlzcyI6Imh0dHBzOi8vbGVzc2dvLmFwcC9hcGkvbG9naW4iLCJpYXQiOjE1NjQ2NjMzMTEsImV4cCI6MTU2NTI2ODExMSwibmJmIjoxNTY0NjYzMzExLCJqdGkiOiJHOEFZa1FmSmpNUUhHdVZkIn0.FVkt1InWijNO3r-WtQVz-MdpFdXFG7JGApAm_RMmwTA','eHhhXqY-ATA:APA91bE_lEKBYVrt3EAlHIY71jK3g3j-Glt1yCNdNO39zMhgmMy1yjEJxLk2VVfCI2519YXFyEMF4y3fE1I76sEw96kctYh6NwMoRArgAu4nztCyCiLNKpVoZMQ5IqgMmcVi0k8483Rq','Android',3,'2019-08-01 15:41:51','2019-08-01 15:41:51',1,'es'),(19,8,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjgsImlzcyI6Imh0dHBzOi8vbGVzc2dvLmFwcC9hcGkvbG9naW4iLCJpYXQiOjE1NjQ2NjQxNDUsImV4cCI6MTU2NTI2ODk0NSwibmJmIjoxNTY0NjY0MTQ1LCJqdGkiOiJhVVdHbnJkSmI5MjdUb29EIn0.lx4QSyhFaZ1yDHIfeZYBDfB0PuuA7OB52C-AU2Pi55o','cEjIyLpWWQ0:APA91bH9-xsvtaCKKMgBTPhuZ3hMi3IPJeViMjIafgThax2RUgAYx01uQyNWJCjH_RZGI_mx9YSPEHfZKUcXa2nkyQyAQOk4aKS1afF5Km2x-8O-pXsQXkM_kZ7iK2XeIu6AnzHY9CtP','Android',3,'2019-08-01 15:55:46','2019-08-06 16:16:22',1,'es'),(20,11,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjExLCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0NjY2MTg4LCJleHAiOjE1NjUyNzA5ODgsIm5iZiI6MTU2NDY2NjE4OCwianRpIjoiNGRhaG1oZ3UwY2JVWVNDaCJ9.dQpLJEZR3XB8YwAfMMlEbUv1jZyaoyti9jLB1TBzUCA','dOKbH9NjD08:APA91bGCSlAGjqd8Z1liqtMVvpoNxyt74YTB-aggbl1GTDs9lMs_IeYTuqcyxIV7HuNc49i8ITaUTy3gCYlh1uktY-mDm0rok5eyP24JRI0iDXQimPx98cTUDZlhWvjZgGXKXeYKhQ4Z','Android',3,'2019-08-01 16:29:49','2019-08-01 16:29:49',1,'es'),(21,13,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjEzLCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0NjY4MDEzLCJleHAiOjE1NjUyNzI4MTMsIm5iZiI6MTU2NDY2ODAxMywianRpIjoiMVlNZjhxWE5WYUZwaHpZdyJ9.8xf6JvgnNmivU-GmCL2InIXolAAlS-l_xr6FB9fRjg0','fvhqTr7XFiE:APA91bHioppHqDttrtVBJTwOxEkhW-6tTZXrutTwVneLpFtmmxef291peV18Ldk_zlBqUS7d3Q11dVZlTHsuz7H1rAo0IOR-sUvOmmeYBET_jgZ_9zZeY7geHZXi8kYN30QnYr4bYkeY','Android',3,'2019-08-01 17:00:14','2019-08-01 17:00:14',1,'es'),(23,17,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjE3LCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0NjcxMDc3LCJleHAiOjE1NjUyNzU4NzcsIm5iZiI6MTU2NDY3MTA3NywianRpIjoibEptaG0xSkpFTmVGVU9VdSJ9.Qh76cBAbajOBHbjlZn4cFPtHQRsKJe_CamR_3J6VfnQ','dIrsgy6jicY:APA91bFnsG0UTeUpsjxz5x_1y5_1JfzgSx-uqezAprN3xt8dr7EHyOzvECDhqIt6f7ajux_53A2IM_vx1k0CVg_dsVlMdF_Blf0Tni9wVY98OcIpnIDaTAeMzLbRqA6L3Mb5ashRIi6E','Android',3,'2019-08-01 17:51:18','2019-08-01 17:51:18',1,'es'),(24,19,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjE5LCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0NjczMzQ2LCJleHAiOjE1NjUyNzgxNDYsIm5iZiI6MTU2NDY3MzM0NiwianRpIjoiWDJjR1lPQ1VKcFpLcEJ6eSJ9.mSTT8v1up130d-81Zy68eqwOXr481rY4l-op7Gdt4FM','crCJIYhJSRg:APA91bH9_4X4jYWuTQPh84SGbKdOMriFLak-3NGpZhArfb16-8ZUyYUQCeWuAoV3a7pZAg3Ej-72KPtX-ZlFqBW3MJcb3hbXXaSXpBS-cAxUYheBrFHYQP97lpLNYGxk4Kgn61jsSE05','Android',3,'2019-08-01 18:29:07','2019-08-01 18:29:07',1,'es'),(25,20,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjIwLCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0Njc0NDg1LCJleHAiOjE1NjUyNzkyODUsIm5iZiI6MTU2NDY3NDQ4NSwianRpIjoiV1VLSGk0UHBvQkpsakFZbCJ9.oTnHnlQdtwFP89AjZJZH0cGW3oWJNUMlKDSWr6hKOsY','ftI3bnwwbVM:APA91bF6wVBKS8fdgHnxLHO1spkYcrVw5cTRzvWR-p81qN_gCpJIIANsSrCOf2sXyJXni28hK4Ra2ZvOJEoFBxbdOsCwWMqIL0ratg2MtbkkdwNGWMrMBbBP11aKSGdvfPsGT7LGGKUT','Android',3,'2019-08-01 18:48:05','2019-08-01 18:49:23',1,'es'),(29,22,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjIyLCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0Njg1Mzk2LCJleHAiOjE1NjUyOTAxOTYsIm5iZiI6MTU2NDY4NTM5NiwianRpIjoiYno5OUlNVGZFSWM2dUdZSSJ9.OR-U1LUYEfAUPsn6n8MK4lZjWBRNgSqCEVnfo1Fyyw4','djDKdGydfVs:APA91bFk85vapbPP1hZLwWfjuW2hgi81WWw7MVnb0z76mXSzMPGbAfIwvsDlSTwf-90fF2gcMdjC4RILz8w6VragvkygLbUPeC3zbAeoTOmsjWjf43IGoQKilYOeJUe3VHGqNvD1qtl3','Android',3,'2019-08-01 21:49:58','2019-08-01 21:49:58',1,'es'),(30,23,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjIzLCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0Njg3ODEwLCJleHAiOjE1NjUyOTI2MTAsIm5iZiI6MTU2NDY4NzgxMCwianRpIjoiamt4OGVMV05ISEF2ZDRaOCJ9.3M-hH_eYyoEOW-Hvyc3j0Dl46mh__0F5F5jD9P9fitM','dF8nujuE8jE:APA91bEcqVtcS1nKLi5o13YUpb5f8MRStz9AS9RCtOPvcP4TmW_nZ_YxPIw-LKKEM7w9jJ8s237odag0_H3sgLiXuPeZ405pIvEV9hyH2D_9ZMxUtbHf2L1yydyQoqmu_EzDG5TJuGbZ','Android',3,'2019-08-01 22:30:11','2019-08-01 22:30:11',1,'es'),(33,25,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjI1LCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0NzMyOTQxLCJleHAiOjE1NjUzMzc3NDEsIm5iZiI6MTU2NDczMjk0MSwianRpIjoiWnVsQjBTWEU4TmdmOW5ETiJ9.71SVQZ84I1l3ECSPdJFHHML856w0Gg5SR8p3B7pAyuM','f41hhNQ--Ek:APA91bGUE1MmGqXR5sOq-02-HTFUtWUD9bj-tpTE3o2qgNcyUI9GpMZhtBZEYFkdy0uhyTi9PccnMyl7jYp0_iTQDLaCeb6Dl-JlIwEyt-SLBC44X7rhLpoRG_m0JW9b67cvwh8OVrwG','Android',3,'2019-08-02 11:02:22','2019-08-02 11:02:22',1,'es'),(34,26,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjI2LCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0NzUzMjA0LCJleHAiOjE1NjUzNTgwMDQsIm5iZiI6MTU2NDc1MzIwNCwianRpIjoiNEdoVzExaFg4SkU5SXhqOCJ9.vNPRXiSngvgPen9IxD_UpLgcTB_uHtQnGbm-X39xw_w','c6BY4LACVJQ:APA91bESA_FcH4xDccGWxvb_zxNigEJxeCFYaV5ekI3BXUov_blUcfB47s14uKkDvafePVhzmwaSgu-eXKmQRcQzsdI8N6iPm7-UfDPjzNETpwOfRLhcFtNSamSwlRFaWgFbpFdUFm5T','Android',3,'2019-08-02 16:40:12','2019-08-06 19:38:33',1,'es'),(35,27,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjI3LCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0NzY3Mjc1LCJleHAiOjE1NjUzNzIwNzUsIm5iZiI6MTU2NDc2NzI3NSwianRpIjoic2JJWmVISjdyNVFhRW9EbiJ9._MrcntmgVIgYzMy3BK5FBqHfcGEUz4TPBh69nyYDrzM','dBZFdM-UASc:APA91bH8k68UXYHgC5ejgepAvdK3kCqyOTyfPAZcJO9gZXkmUWYYDtmrowL2v56EhcvCWgPTmbt9RCGUwHqWwsJtiX0LHGjLLajkt_VLUAxRk-XYAWCKyg2-l6sacSwICuR7BeidqDZY','Android',3,'2019-08-02 20:34:36','2019-08-02 20:34:36',1,'es'),(36,28,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjI4LCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0NzgwNzYyLCJleHAiOjE1NjUzODU1NjIsIm5iZiI6MTU2NDc4MDc2MiwianRpIjoiTGRMa2R3ejhsdVJtY0V5VSJ9.ILSSfOCvdBkZB7kkVBOrIunjJ_1lvnOXqg0DlslhjwA','cbWG6mGpWEg:APA91bEq8s2U5BE7032NDuksILF4iLjfEmT9l9P1Z55512JhOLI7ClBha2zw8N4tPaHE2KaIppq2e2hRY9hiwE549DL-g3aLCdoZ3E8onSC8OIhnXaIE3klECdDXGmOnvqDpEBf3Vsk0','Android',3,'2019-08-03 00:19:23','2019-08-03 00:39:41',1,'es'),(37,15,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjE1LCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0Nzg2Mjc5LCJleHAiOjE1NjUzOTEwNzksIm5iZiI6MTU2NDc4NjI3OSwianRpIjoiWVd2RzFva0Q1azdOaXBmZSJ9.Td9zWTrhGhd7Db3GM_NSbAq1d7_gR7CU3y0qPNyq9_Y','eLwEs0zdwUY:APA91bHqQd5TMrXXD-Fs9gz-lQx2UppCvad5UnQoUvNm8vZtvZEKsnZWGM41HUgZIIMeOnhSqOwIAi8XRyyQftZ8PkHy0Q3XIG_7xwZ4ut9Q-1w6s2uYMt3y4Rq0s-dY1ExM37uOZ11K','Android',3,'2019-08-03 01:51:20','2019-08-05 00:10:01',1,'es'),(38,9,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjksImlzcyI6Imh0dHBzOi8vbGVzc2dvLmFwcC9hcGkvbG9naW4iLCJpYXQiOjE1NjQ4MjMxNDYsImV4cCI6MTU2NTQyNzk0NiwibmJmIjoxNTY0ODIzMTQ2LCJqdGkiOiJWU0ZRQmJJS3FjYW9Ub2lpIn0.v4a3xhMzjEnn_uoKMZOuMIq2IPQUEVL7_2-AmsZyawI','dnFeQi42dz8:APA91bH2sE6XtTwoa3FP9Yp-irwCxBk2KbAGcvOK2O_SVpzGl7OBhUj1Ho2TYEoEVWSbK-qpQV6k8beYcqOmlWHkOVO72SrdQP7GSTyL66w1lFS4YjzQw2MMRjyE-ip3RYZVmquHIR2j','Android',3,'2019-08-03 12:05:47','2019-08-03 12:05:47',1,'es'),(43,30,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjMwLCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY0OTQzNDMwLCJleHAiOjE1NjU1NDgyMzAsIm5iZiI6MTU2NDk0MzQzMCwianRpIjoiNEU0blFsQVBhdXRRNlhQYSJ9.U0rXkjbnWiVXWdpi1_iKIZfwY3LJAIDZwdYxKQO6ptw','cU1uYjCF-cw:APA91bG9_HDLah8c5fesnqI7ZUaKiDZEgYxnM0MahwSpiVtGFLz04R4WbxZbE8hxP56j8qfI06m0fz0uUCJxE9eZSoBuXtkWWkiOhwcN5J9gwr9wIvuEDlB-xhmtT00YmMRZWoZ-3az6','Android',3,'2019-08-04 21:30:31','2019-08-04 21:30:31',1,'es'),(44,3,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjMsImlzcyI6Imh0dHBzOi8vbGVzc2dvLmFwcC9hcGkvbG9naW4iLCJpYXQiOjE1NjQ5NDUxNzcsImV4cCI6MTU2NTU0OTk3NywibmJmIjoxNTY0OTQ1MTc3LCJqdGkiOiJaTlBJQXdaQlNBdXZBMkN1In0.mjw0ODia4s-zhHP5sSIoCPtYMSW3_SOR1KCrAPRt664','cQlpM0yuWXI:APA91bHa0wgaciA5aEQ4eMBs5l6Ja0ZuZC6TX_-Pp4kRQ47TXPRkGSnyNZPG9wugHLHCpGVxGfd5uxOFy5XHV85k0EW5i-q0HXs72ShEoM2XQcCTS8-UBSU8jN9gBO496m9fVdFQzs0k','Android',3,'2019-08-04 21:59:38','2019-08-04 23:20:41',1,'es'),(45,1,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjEsImlzcyI6Imh0dHBzOi8vbGVzc2dvLmFwcC9hcGkvbG9naW4iLCJpYXQiOjE1NjUwOTMwOTYsImV4cCI6MTU2NTY5Nzg5NiwibmJmIjoxNTY1MDkzMDk2LCJqdGkiOiJkYWRmQmhuZ0JaczkydTJNIn0.7M-tIgpYOqGiJ5q6Sl8d5vfLhRF5GgJ_rlRenEfNHYc','dpjwyu0bzwo:APA91bFlhrgOSjxf-P4RYMSn5nBSlqW2umhU2AVOw-hxrd4G5U9A9mYSBt-anNeMZicfkSl1vgbos_Z8eX7RkiMft9WNfBWhSj9M-aAzztzT4ScIg59usJDKHlVpY9S7ywHeDgM3chVM','Android',3,'2019-08-06 15:04:57','2019-08-06 16:03:11',1,'es'),(46,32,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjMyLCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY1MDk3MzY2LCJleHAiOjE1NjU3MDIxNjYsIm5iZiI6MTU2NTA5NzM2NiwianRpIjoiVEtsMGFkb2FKdGp5NkMweSJ9.WUIu0K8FC5T8_606Ei-Vs1m2rWcc-isZRV_PaoOzGUE','ey8My-wOtOo:APA91bHLNQzE3lfPgSRPHJ-o5iBfyR0gOT3T6TlOHNkO-8grlV3700kTztmdZdMvlvXw-gpx1nC-8huo715CYuLkbNX1Zv8ou1N02Xwuxb8vM1jN2OdjoMhFr36yE4PbQWjpCZN8GYWO','Android',3,'2019-08-06 16:16:07','2019-08-06 16:16:07',1,'es'),(47,14,'eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjE0LCJpc3MiOiJodHRwczovL2xlc3Nnby5hcHAvYXBpL2xvZ2luIiwiaWF0IjoxNTY1MDk3NzEyLCJleHAiOjE1NjU3MDI1MTIsIm5iZiI6MTU2NTA5NzcxMiwianRpIjoiUVRFSHhES29KZllIcTZ0NCJ9.xMbFk1fKSchR7ONPhHKuHGtobRh946rmU2DvkRcDhmM','e-QdDJhT8Vk:APA91bHtwDrzz3Mav10vVBfJ4MHBj-oDDLAahsbJO7RyqCnN5_Zn6orpOnQejAVJDUmbvoObLEJbTC7URKaCru7oCgMD-8j4MAQFik2Wn_zZVYXjFp1WXwMb4nm20Te9Y-4nEochRAJl','Android',3,'2019-08-06 16:21:52','2019-08-06 16:21:52',1,'es');
736/*!40000 ALTER TABLE `users_devices` ENABLE KEYS */;
737UNLOCK TABLES;
738
739--
740-- Dumping events for database 'lessgo_production'
741--
742
743--
744-- Dumping routines for database 'lessgo_production'
745--
746/*!50003 DROP PROCEDURE IF EXISTS `update_rating_availability` */;
747/*!50003 SET @saved_cs_client      = @@character_set_client */ ;
748/*!50003 SET @saved_cs_results     = @@character_set_results */ ;
749/*!50003 SET @saved_col_connection = @@collation_connection */ ;
750/*!50003 SET character_set_client  = utf8 */ ;
751/*!50003 SET character_set_results = utf8 */ ;
752/*!50003 SET collation_connection  = utf8_unicode_ci */ ;
753/*!50003 SET @saved_sql_mode       = @@sql_mode */ ;
754/*!50003 SET sql_mode              = 'NO_ENGINE_SUBSTITUTION' */ ;
755DELIMITER ;;
756CREATE DEFINER=`lessgoapp`@`%` PROCEDURE `update_rating_availability`(
757            IN _id INT,
758            IN _trip_id INT,
759            IN _user_id_from INT,
760            IN _user_id_to INT
761          )
762BEGIN
763            UPDATE rating ra
764                  SET ra.available = CASE
765                      WHEN (ra.created_at <=  ( Now() - INTERVAL 15 day ))  THEN 1
766                      WHEN (
767                          (SELECT count(*)
768                          FROM (SELECT * FROM rating) AS r
769                                 INNER JOIN (SELECT * FROM rating) AS r2
770                                    ON r.trip_id = r2.trip_id
771                                         AND r.user_id_from = r2.user_id_to
772                                         AND r.user_id_to = r2.user_id_from
773                                         AND r.voted = r2.voted 
774                               WHERE r.id = _id) > 0
775                      ) THEN 1
776                      ELSE 0
777                  END 
778                  WHERE ra.id != _id
779                        AND ra.trip_id = _trip_id
780                        AND ra.user_id_to = _user_id_from
781                        AND ra.user_id_from = _user_id_to
782                        AND ra.voted = 1;
783          END ;;
784DELIMITER ;
785/*!50003 SET sql_mode              = @saved_sql_mode */ ;
786/*!50003 SET character_set_client  = @saved_cs_client */ ;
787/*!50003 SET character_set_results = @saved_cs_results */ ;
788/*!50003 SET collation_connection  = @saved_col_connection */ ;
789SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;
790/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
791
792/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
793/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
794/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
795/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
796/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
797/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
798/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
799
800-- Dump completed on 2019-08-06 23:16:42