API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 21st, 2019
91
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 64.72 KB | None | 0 0
raw download clone embed print report
  1. -- MySQL dump 10.13  Distrib 5.7.24, for Linux (x86_64)
  2. --
  3. -- Host: localhost    Database: ucarmx12_main
  4. -- ------------------------------------------------------
  5. -- Server version   5.7.24-0ubuntu0.18.04.1
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `brands`
  20. --
  21.  
  22. DROP TABLE IF EXISTS `brands`;
  23. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE TABLE `brands` (
  26.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  27.   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  28.   `created_at` timestamp NULL DEFAULT NULL,
  29.   `updated_at` timestamp NULL DEFAULT NULL,
  30.   PRIMARY KEY (`id`)
  31. ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  32. /*!40101 SET character_set_client = @saved_cs_client */;
  33.  
  34. --
  35. -- Dumping data for table `brands`
  36. --
  37.  
  38. LOCK TABLES `brands` WRITE;
  39. /*!40000 ALTER TABLE `brands` DISABLE KEYS */;
  40. INSERT INTO `brands` VALUES (1,'Ford','2018-12-30 18:39:32','2018-12-30 18:39:32'),(2,'Wolkswagen','2018-12-30 19:14:22','2018-12-30 19:14:22'),(3,'Nissan','2018-12-30 19:14:27','2018-12-30 19:14:27'),(4,'Chevrolet','2018-12-30 19:14:32','2018-12-30 19:14:32'),(5,'Renault','2018-12-30 19:14:38','2018-12-30 19:14:38'),(6,'Suburban','2018-12-30 19:14:48','2018-12-30 19:14:48'),(7,'Mitsubishi','2018-12-30 19:14:54','2018-12-30 19:14:54'),(8,'Subaru','2018-12-30 19:15:02','2018-12-30 19:15:02');
  41. /*!40000 ALTER TABLE `brands` ENABLE KEYS */;
  42. UNLOCK TABLES;
  43.  
  44. --
  45. -- Table structure for table `cars`
  46. --
  47.  
  48. DROP TABLE IF EXISTS `cars`;
  49. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  50. /*!40101 SET character_set_client = utf8 */;
  51. CREATE TABLE `cars` (
  52.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  53.   `subsidiary_id` int(10) unsigned NOT NULL,
  54.   `brand_id` int(10) unsigned NOT NULL,
  55.   `model_id` int(10) unsigned NOT NULL,
  56.   `color_id` int(10) unsigned NOT NULL,
  57.   `plates` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  58.   `gearing` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  59.   `year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  60.   `doors` int(11) NOT NULL,
  61.   `size` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  62.   `price` decimal(8,2) DEFAULT NULL,
  63.   `rent` decimal(7,2) DEFAULT NULL,
  64.   `inspire` text COLLATE utf8mb4_unicode_ci,
  65.   `details` text COLLATE utf8mb4_unicode_ci,
  66.   `images` text COLLATE utf8mb4_unicode_ci,
  67.   `published` tinyint(1) NOT NULL,
  68.   `created_at` timestamp NULL DEFAULT NULL,
  69.   `updated_at` timestamp NULL DEFAULT NULL,
  70.   PRIMARY KEY (`id`)
  71. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  72. /*!40101 SET character_set_client = @saved_cs_client */;
  73.  
  74. --
  75. -- Dumping data for table `cars`
  76. --
  77.  
  78. LOCK TABLES `cars` WRITE;
  79. /*!40000 ALTER TABLE `cars` DISABLE KEYS */;
  80. INSERT INTO `cars` VALUES (1,1,2,5,5,'MVH-41-57','automatic','2018',2,'compact',NULL,1399.00,'Comodo y fantastico','2 puertas automatico','[\"autos\\/January2019\\/BThSb3mMcfF4xCtVienB.jpg\"]',1,'2019-01-06 10:09:50','2019-01-06 19:29:24');
  81. /*!40000 ALTER TABLE `cars` ENABLE KEYS */;
  82. UNLOCK TABLES;
  83.  
  84. --
  85. -- Table structure for table `colors`
  86. --
  87.  
  88. DROP TABLE IF EXISTS `colors`;
  89. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  90. /*!40101 SET character_set_client = utf8 */;
  91. CREATE TABLE `colors` (
  92.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  93.   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  94.   `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  95.   `created_at` timestamp NULL DEFAULT NULL,
  96.   `updated_at` timestamp NULL DEFAULT NULL,
  97.   PRIMARY KEY (`id`)
  98. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  99. /*!40101 SET character_set_client = @saved_cs_client */;
  100.  
  101. --
  102. -- Dumping data for table `colors`
  103. --
  104.  
  105. LOCK TABLES `colors` WRITE;
  106. /*!40000 ALTER TABLE `colors` DISABLE KEYS */;
  107. INSERT INTO `colors` VALUES (1,'Rojo','#c52222','2018-12-30 19:03:35','2018-12-30 19:04:01'),(2,'Negro','#000000','2018-12-30 19:03:45','2018-12-30 19:03:45'),(3,'Blanco','#ffffff','2018-12-30 19:03:53','2018-12-30 19:04:15'),(4,'Plata','#f2f2f2','2019-01-06 10:04:43','2019-01-06 10:04:43'),(5,'Gris','#929292','2019-01-06 10:05:23','2019-01-06 10:05:23');
  108. /*!40000 ALTER TABLE `colors` ENABLE KEYS */;
  109. UNLOCK TABLES;
  110.  
  111. --
  112. -- Table structure for table `data_rows`
  113. --
  114.  
  115. DROP TABLE IF EXISTS `data_rows`;
  116. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  117. /*!40101 SET character_set_client = utf8 */;
  118. CREATE TABLE `data_rows` (
  119.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  120.   `data_type_id` int(10) unsigned NOT NULL,
  121.   `field` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  122.   `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  123.   `display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  124.   `required` tinyint(1) NOT NULL DEFAULT '0',
  125.   `browse` tinyint(1) NOT NULL DEFAULT '1',
  126.   `read` tinyint(1) NOT NULL DEFAULT '1',
  127.   `edit` tinyint(1) NOT NULL DEFAULT '1',
  128.   `add` tinyint(1) NOT NULL DEFAULT '1',
  129.   `delete` tinyint(1) NOT NULL DEFAULT '1',
  130.   `details` text COLLATE utf8mb4_unicode_ci,
  131.   `order` int(11) NOT NULL DEFAULT '1',
  132.   PRIMARY KEY (`id`),
  133.   KEY `data_rows_data_type_id_foreign` (`data_type_id`),
  134.   CONSTRAINT `data_rows_data_type_id_foreign` FOREIGN KEY (`data_type_id`) REFERENCES `data_types` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
  135. ) ENGINE=InnoDB AUTO_INCREMENT=170 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  136. /*!40101 SET character_set_client = @saved_cs_client */;
  137.  
  138. --
  139. -- Dumping data for table `data_rows`
  140. --
  141.  
  142. LOCK TABLES `data_rows` WRITE;
  143. /*!40000 ALTER TABLE `data_rows` DISABLE KEYS */;
  144. INSERT INTO `data_rows` VALUES (1,1,'id','number','ID',1,0,0,0,0,0,NULL,1),(2,1,'name','text','Name',1,1,1,1,1,1,NULL,2),(3,1,'email','text','Email',1,1,1,1,1,1,NULL,3),(4,1,'password','password','Password',1,0,0,1,1,0,NULL,4),(5,1,'remember_token','text','Remember Token',0,0,0,0,0,0,NULL,5),(6,1,'created_at','timestamp','Fecha de Creación',0,1,1,0,0,0,NULL,6),(7,1,'updated_at','timestamp','Fecha de Modificación',0,0,0,0,0,0,NULL,7),(8,1,'avatar','image','Avatar',0,1,1,1,1,1,NULL,8),(9,1,'user_belongsto_role_relationship','relationship','Role',0,1,1,1,1,0,'{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsTo\",\"column\":\"role_id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"roles\",\"pivot\":0}',10),(10,1,'user_belongstomany_role_relationship','relationship','Roles',0,1,1,1,1,0,'{\"model\":\"TCG\\\\Voyager\\\\Models\\\\Role\",\"table\":\"roles\",\"type\":\"belongsToMany\",\"column\":\"id\",\"key\":\"id\",\"label\":\"display_name\",\"pivot_table\":\"user_roles\",\"pivot\":\"1\",\"taggable\":\"0\"}',11),(11,1,'locale','text','Locale',0,1,1,1,1,0,NULL,12),(12,1,'settings','hidden','Settings',0,0,0,0,0,0,NULL,12),(13,2,'id','number','ID',1,0,0,0,0,0,'{}',1),(14,2,'name','text','Name',1,1,1,1,1,1,'{}',3),(15,2,'created_at','timestamp','Fecha de Creación',0,0,0,0,0,0,'{}',4),(16,2,'updated_at','timestamp','Fecha de Modificación',0,0,0,0,0,0,'{}',5),(17,3,'id','number','ID',1,0,0,0,0,0,NULL,1),(18,3,'name','text','Name',1,1,1,1,1,1,NULL,2),(19,3,'created_at','timestamp','Fecha de Creación',0,0,0,0,0,0,NULL,3),(20,3,'updated_at','timestamp','Fecha de Modificación',0,0,0,0,0,0,NULL,4),(21,3,'display_name','text','Display Name',1,1,1,1,1,1,NULL,5),(22,1,'role_id','text','Role',1,1,1,1,1,1,NULL,9),(23,5,'id','number','Id',1,0,0,0,0,0,'{}',1),(24,5,'plates','text','Placas',1,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',10),(26,5,'gearing','select_dropdown','Cambios',1,1,1,1,1,1,'{\"default\":\"automatic\",\"options\":{\"automatic\":\"Automatico\",\"manual\":\"Manual\"},\"display\":{\"width\":\"1\"}}',11),(28,5,'year','number','Año',1,1,1,1,1,1,'{\"default\":\"2019\",\"display\":{\"width\":\"1\"}}',12),(29,5,'doors','number','Número de Puertas',1,1,1,1,1,1,'{\"default\":\"4\",\"display\":{\"width\":\"2\"}}',13),(30,5,'size','select_dropdown','Tamaño',1,1,1,1,1,1,'{\"default\":\"option1\",\"options\":{\"compact\":\"Compacto\",\"sedan\":\"Sedan\",\"pickup\":\"Pickup\",\"van\":\"Van\"},\"display\":{\"width\":\"2\"}}',14),(31,5,'price','number','Precio de Venta',0,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',15),(32,5,'rent','number','Precio de Renta',0,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',16),(34,5,'inspire','text_area','Comentario Inspiracional',0,1,1,1,1,1,'{\"display\":{\"width\":\"3\"}}',17),(35,5,'details','text_area','Detalles',0,1,1,1,1,1,'{\"display\":{\"width\":\"3\"}}',18),(42,5,'published','checkbox','Publicar?',1,1,1,1,1,1,'{\"on\":\"Si, Publicalo\",\"off\":\"No, Ocultalo\",\"checked\":\"false\",\"display\":{\"width\":\"3\"}}',20),(43,5,'created_at','timestamp','Creado',0,1,1,0,0,0,'{}',21),(44,5,'updated_at','timestamp','Actualizado',0,0,0,0,0,0,'{}',22),(45,7,'id','number','Id',1,0,0,0,0,0,'{}',1),(46,7,'name','text','Nombre de Sucursal',1,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',3),(47,7,'address','text','Calle y Número',1,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',5),(48,7,'locality','text','Localidad',1,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',7),(49,7,'zip','number','Codigo Postal',1,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',10),(50,7,'email','text','Email',1,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',4),(51,7,'phone_1','text','Teléfono 1',1,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',11),(52,7,'phone_2','text','Teléfono 2',0,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',12),(53,7,'map_coordinates','coordinates','Ubicación (Mapa)',1,1,1,1,1,1,'{\"display\":{\"width\":\"12\"}}',2),(54,7,'logo','image','Logo',0,1,1,1,1,1,'{\"display\":{\"width\":\"4\"}}',13),(67,9,'id','text','Id',1,0,0,0,0,0,'{}',1),(68,9,'title','text','Título',0,1,1,1,1,1,'{\"default\":\"rent\",\"options\":{\"rent\":\"Inicio\",\"catalog\":\"Ver Cat\\u00e1logo\",\"contact\":\"Cont\\u00e1ctanos\"},\"display\":{\"width\":\"4\"}}',3),(73,9,'description_1','markdown_editor','Descripción Izquierda',1,1,1,1,1,1,'{\"null\":\"\",\"display\":{\"width\":\"5\"}}',7),(74,9,'description_2','markdown_editor','Descripción Derecha',0,1,1,1,1,1,'{\"null\":\"\",\"display\":{\"width\":\"5\"}}',9),(75,9,'image','image','Imagen',1,1,1,1,1,1,'{\"resize\":{\"width\":\"455\",\"height\":\"303\"},\"quality\":\"85%\",\"upsize\":true,\"display\":{\"width\":\"2\"}}',8),(76,9,'position','number','Posición',1,1,1,1,1,1,'{\"default\":1,\"display\":{\"width\":\"2\"}}',6),(77,9,'created_at','timestamp','Fecha de Creación',0,1,1,0,0,0,'{}',11),(78,9,'updated_at','timestamp','Fecha de Modificación',0,0,0,0,0,0,'{}',12),(80,11,'id','text','Id',1,0,0,0,0,0,'{}',1),(83,11,'year','number','Año',1,1,1,1,1,1,'{\"default\":2019,\"display\":{\"width\":\"1\"}}',10),(84,11,'size','select_dropdown','Tamaño',1,1,1,1,1,1,'{\"default\":\"scooter\",\"options\":{\"scooter\":\"Scooter\",\"vespa\":\"Vespa\",\"moped\":\"Motoneta\",\"bike\":\"Motocicleta\"},\"display\":{\"width\":\"1\"}}',11),(85,11,'price','number','Precio de Venta',0,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',12),(86,11,'rent','number','Precio de Renta',0,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',13),(87,11,'inspire','text_area','Comentario Inspiracional',0,1,1,1,1,1,'{\"display\":{\"width\":\"3\"}}',14),(88,11,'details','text_area','Detalles',0,1,1,1,1,1,'{\"display\":{\"width\":\"3\"}}',15),(89,11,'images','multiple_images','Imagenes',1,1,1,1,1,1,'{\"display\":{\"width\":\"3\"}}',16),(90,11,'published','checkbox','Publicar?',1,1,1,1,1,1,'{\"on\":\"Si, Publicalo\",\"off\":\"No, Ocultalo\",\"checked\":\"false\",\"display\":{\"width\":\"3\"}}',17),(91,11,'created_at','timestamp','Fecha de Creación',0,1,1,1,0,1,'{}',18),(92,11,'updated_at','timestamp','Fecha de Modificación',0,0,0,0,0,0,'{}',19),(93,12,'id','text','Id',1,0,0,0,0,0,'{}',1),(94,12,'slider','select_dropdown','Slider',1,1,1,1,1,1,'{\"default\":\"main\",\"options\":{\"main\":\"Principal\"},\"display\":{\"width\":\"4\"}}',2),(95,12,'slide_position','select_dropdown','Posición del Slide',1,1,1,1,1,1,'{\"default\":\"center\",\"options\":{\"top\":\"Arriba\",\"center\":\"Centro\",\"bottom\":\"Abajo\"},\"display\":{\"width\":\"4\"}}',3),(96,12,'text_position','select_dropdown','Posición del Texto',1,1,1,1,1,1,'{\"default\":\"center\",\"options\":{\"left\":\"Izquierda\",\"center\":\"Centro\",\"right\":\"Derecha\"},\"display\":{\"width\":\"4\"}}',4),(97,12,'title','text','Título',0,1,1,1,1,1,'{\"display\":{\"width\":\"4\"}}',5),(98,12,'title_fade_in','select_dropdown','Efecto de Título',1,1,1,1,1,1,'{\"default\":\"top\",\"options\":{\"down\":\"Desde Arriba\",\"left\":\"Desde la Derecha\",\"right\":\"Desde la Izquierda\",\"top\":\"Desde Abaj\"},\"display\":{\"width\":\"4\"}}',6),(99,12,'subtitle','text','Subítulo',0,1,1,1,1,1,'{\"display\":{\"width\":\"4\"}}',8),(100,12,'subtitle_fade_id','select_dropdown','Efecto de Subítulo',1,1,1,1,1,1,'{\"default\":\"top\",\"options\":{\"down\":\"Desde Arriba\",\"left\":\"Desde la Derecha\",\"right\":\"Desde la Izquierda\",\"top\":\"Desde Abaj\"},\"display\":{\"width\":\"4\"}}',9),(101,12,'comment','text','Comentario',0,1,1,1,1,1,'{\"display\":{\"width\":\"8\"}}',11),(102,12,'button_text','text','Texto de Boton',0,1,1,1,1,1,'{\"display\":{\"width\":\"4\"}}',13),(104,12,'button_fade_in','select_dropdown','Efecto de Boton',1,1,1,1,1,1,'{\"default\":\"center\",\"options\":{\"down\":\"Desde Arriba\",\"left\":\"Desde la Derecha\",\"right\":\"Desde la Izquierda\",\"top\":\"Desde Abaj\"},\"display\":{\"width\":\"4\"}}',15),(105,12,'image','image','Imagen',1,1,1,1,1,1,'{\"resize\":{\"width\":\"1920\",\"height\":\"1280\"},\"quality\":\"70%\",\"upsize\":true,\"display\":{\"width\":\"4\"}}',16),(107,12,'created_at','timestamp','Fecha de Creación',0,1,1,0,0,0,'{}',18),(108,12,'updated_at','timestamp','Fecha de Modificación',0,0,0,0,0,0,'{}',19),(109,12,'title_lighting','select_dropdown','Tono de Título',1,1,1,1,1,1,'{\"default\":\"light\",\"options\":{\"light\":\"Claro\",\"medium\":\"Medio\",\"dark\":\"Oscuro\"},\"display\":{\"width\":\"4\"}}',7),(110,12,'subtitle_lighting','select_dropdown','Tono de Subítulo',1,1,1,1,1,1,'{\"default\":\"light\",\"options\":{\"light\":\"Claro\",\"medium\":\"Medio\",\"dark\":\"Oscuro\"},\"display\":{\"width\":\"4\"}}',10),(111,12,'comment_lighting','select_dropdown','Tono de Comentario',1,1,1,1,1,1,'{\"default\":\"light\",\"options\":{\"light\":\"Claro\",\"medium\":\"Medio\",\"dark\":\"Oscuro\"},\"display\":{\"width\":\"4\"}}',12),(112,12,'button_route','select_dropdown','Enlace del Boton',0,1,1,1,1,1,'{\"default\":\"catalog\",\"options\":{\"home\":\"Inicio\",\"services\":\"Servicios\",\"subsidiaries\":\"Sucursales\",\"catalog\":\"Catalogo\",\"contact\":\"Contacto\"},\"display\":{\"width\":\"4\"}}',14),(113,7,'colony','text','Colonia',1,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',6),(114,7,'created_at','timestamp','Fecha de Creación',0,1,1,0,0,0,'{}',14),(115,7,'updated_at','timestamp','Fecha de Modificación',0,0,0,0,0,0,'{}',15),(116,7,'city','text','Ciudad',1,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',8),(117,7,'state','select_dropdown','Estado',1,1,1,1,1,1,'{\"default\":\"Oaxaca\",\"options\":{\"Aguascalientes\":\"Aguascalientes\",\"Baja California\":\"Baja California\",\"Baja California Sur\":\"Baja California Sur\",\"Campeche\":\"Campeche\",\"Coahuila de Zaragoza\":\"Coahuila de Zaragoza\",\"Colima\":\"Colima\",\"Chiapas\":\"Chiapas\",\"Chihuahua\":\"Chihuahua\",\"Distrito Federal\":\"Distrito Federal\",\"Durango\":\"Durango\",\"Guanajuato\":\"Guanajuato\",\"Guerrero\":\"Guerrero\",\"Hidalgo\":\"Hidalgo\",\"Jalisco\":\"Jalisco\",\"M\\u00e9xico\":\"M\\u00e9xico\",\"Michoac\\u00e1n de Ocampo\":\"Michoac\\u00e1n de Ocampo\",\"Morelos\":\"Morelos\",\"Nayarit\":\"Nayarit\",\"Nuevo Le\\u00f3n\":\"Nuevo Le\\u00f3n\",\"Oaxaca\":\"Oaxaca\",\"Puebla\":\"Puebla\",\"Quer\\u00e9taro\":\"Quer\\u00e9taro\",\"Quintana Roo\":\"Quintana Roo\",\"San Luis Potos\\u00ed\":\"San Luis Potos\\u00ed\",\"Sinaloa\":\"Sinaloa\",\"Sonora\":\"Sonora\",\"Tabasco\":\"Tabasco\",\"Tamaulipas\":\"Tamaulipas\",\"Tlaxcala\":\"Tlaxcala\",\"Veracruz de Ignacio de la Llave\":\"Veracruz de Ignacio de la Llave\",\"Yucat\\u00e1n\":\"Yucat\\u00e1n\",\"Zacatecas\":\"Zacatecas\"},\"display\":{\"width\":\"2\"}}',9),(118,9,'button_route_1','select_dropdown','Boton Izquierdo',0,1,1,1,1,1,'{\"default\":\"catalog\",\"options\":{\"\":\"Ninguno\",\"home\":\"Inicio\",\"services\":\"Servicios\",\"subsidiaries\":\"Sucursales\",\"catalog\":\"Catalogo\",\"contact\":\"Contacto\"},\"null\":\"\",\"display\":{\"width\":\"2\"}}',4),(119,9,'button_route_2','select_dropdown','Boton Derecho',0,1,1,1,1,1,'{\"default\":\"\",\"options\":{\"\":\"Ninguno\",\"home\":\"Inicio\",\"services\":\"Servicios\",\"subsidiaries\":\"Sucursales\",\"catalog\":\"Catalogo\",\"contact\":\"Contacto\"},\"null\":\"\",\"display\":{\"width\":\"2\"}}',5),(120,15,'id','text','Id',1,0,0,0,0,0,'{}',1),(121,15,'title','text','Título',1,1,1,1,1,1,'{\"display\":{\"width\":\"4\"}}',3),(122,15,'comment','markdown_editor','Comentario',1,1,1,1,1,1,'{\"display\":{\"width\":\"4\"}}',5),(123,15,'anchor_route','select_dropdown','Enlace',0,1,1,1,1,1,'{\"default\":\"catalog\",\"options\":{\"index\":\"Inicio\",\"catalog\":\"Ver Cat\\u00e1logo\",\"contact\":\"Cont\\u00e1ctanos\"},\"display\":{\"width\":\"4\"}}',4),(124,15,'position','select_dropdown','Posición (Ping: Izq., Pong: Der.)',1,1,1,1,1,1,'{\"default\":\"Ping (Izquierda)\",\"options\":{\"ping\":\"Ping (Izquierda)\",\"pong\":\"Pong (Derecha)\"},\"display\":{\"width\":\"4\"}}',7),(125,15,'created_at','timestamp','Fecha de Creación',0,1,1,0,0,0,'{}',8),(126,15,'updated_at','timestamp','Fecha de Modificación',0,0,0,0,0,0,'{}',9),(127,9,'icon','image','Icono',1,1,1,1,1,1,'{\"resize\":{\"width\":\"50\",\"height\":null},\"quality\":\"85%\",\"upsize\":false,\"display\":{\"width\":\"2\"}}',10),(128,9,'label','text','Etiqueta',1,1,1,1,1,1,'{\"display\":{\"width\":\"2\"}}',2),(130,15,'page','select_dropdown','Página',1,1,1,1,1,1,'{\"default\":\"catalog\",\"options\":{\"home\":\"Inicio\",\"catalog\":\"Catalogo\",\"contact\":\"Contacto\"},\"display\":{\"width\":\"4\"}}',2),(131,15,'image','image','Image',1,1,1,1,1,1,'{\"resize\":{\"width\":\"555\",\"height\":\"370\"},\"quality\":\"75%\",\"upsize\":true,\"display\":{\"width\":\"4\"}}',6),(135,5,'images','multiple_images','Images',0,1,1,1,1,1,'{\"display\":{\"width\":\"3\"},\"thumbnails\":[{\"name\":\"small\",\"resize\":{\"width\":\"121\",\"height\":\"83\"}},{\"name\":\"cropped\",\"crop\":{\"width\":\"570\",\"height\":\"390\"}}]}',19),(136,5,'subsidiary_id','hidden','Subsidiary Id',1,1,1,1,1,1,'{}',3),(137,11,'motorcycle_belongsto_subsidiary_relationship','relationship','Sucursal',0,1,1,1,1,1,'{\"model\":\"App\\\\Subsidiary\",\"table\":\"subsidiaries\",\"type\":\"belongsTo\",\"column\":\"subsidiary_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":null,\"pivot\":\"0\",\"taggable\":null}',2),(138,11,'subsidiary_id','text','Subsidiary Id',1,0,0,0,0,0,'{}',3),(139,16,'id','text','Id',1,0,0,0,0,0,'{}',1),(140,16,'name','text','Nombre',1,1,1,1,1,1,'{}',2),(141,16,'created_at','timestamp','Created At',0,1,1,0,0,0,'{}',3),(142,16,'updated_at','timestamp','Updated At',0,0,0,0,0,0,'{}',4),(143,18,'id','text','Id',1,0,0,0,0,0,'{}',1),(144,18,'name','text','Nombre',1,1,1,1,1,1,'{}',2),(145,18,'created_at','timestamp','Created At',0,1,1,0,0,0,'{}',3),(146,18,'updated_at','timestamp','Updated At',0,0,0,0,0,0,'{}',4),(147,19,'id','text','Id',1,0,0,0,0,0,'{}',1),(148,19,'name','text','Nombre',1,1,1,1,1,1,'{}',2),(149,19,'value','color','Color',1,1,1,1,1,1,'{}',3),(150,19,'created_at','timestamp','Created At',0,1,1,0,0,0,'{}',4),(151,19,'updated_at','timestamp','Updated At',0,0,0,0,0,0,'{}',5),(155,5,'brand_id','hidden','Brand Id',1,1,1,1,1,1,'{}',5),(156,5,'model_id','hidden','Model Id',0,1,1,1,1,1,'{}',7),(157,5,'color_id','hidden','Color Id',0,1,1,1,1,1,'{}',9),(158,11,'motorcycle_belongsto_model_relationship','relationship','Modelo',0,1,1,1,1,1,'{\"model\":\"App\\\\Model\",\"table\":\"models\",\"type\":\"belongsTo\",\"column\":\"model_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":null,\"pivot\":\"0\",\"taggable\":null}',6),(159,11,'brand_id','hidden','Brand Id',1,0,0,0,0,0,'{}',5),(160,11,'model_id','hidden','Model Id',1,0,0,0,0,0,'{}',7),(161,11,'color_id','hidden','Color',1,0,0,0,0,0,'{}',9),(162,11,'motorcycle_belongsto_color_relationship','relationship','Color',0,1,1,1,1,1,'{\"model\":\"App\\\\Color\",\"table\":\"colors\",\"type\":\"belongsTo\",\"column\":\"color_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":null,\"pivot\":\"0\",\"taggable\":null}',8),(163,11,'motorcycle_belongsto_brand_relationship','relationship','Marca',0,1,1,1,1,1,'{\"model\":\"App\\\\Brand\",\"table\":\"brands\",\"type\":\"belongsTo\",\"column\":\"brand_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":null,\"pivot\":\"0\",\"taggable\":null}',4),(164,7,'details','markdown_editor','Detalles',0,1,1,1,1,1,'{\"display\":{\"width\":\"4\"}}',3),(166,5,'car_belongsto_subsidiary_relationship','relationship','Sucursal',1,1,1,1,1,1,'{\"model\":\"App\\\\Subsidiary\",\"table\":\"subsidiaries\",\"type\":\"belongsTo\",\"column\":\"subsidiary_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":null,\"pivot\":null,\"taggable\":null}',23),(167,5,'car_belongsto_brand_relationship','relationship','Marca',1,1,1,1,1,1,'{\"model\":\"App\\\\Brand\",\"table\":\"brands\",\"type\":\"belongsTo\",\"column\":\"brand_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":null,\"pivot\":null,\"taggable\":null}',24),(168,5,'car_belongsto_model_relationship','relationship','Modelo',1,1,1,1,1,1,'{\"model\":\"App\\\\Model\",\"table\":\"models\",\"type\":\"belongsTo\",\"column\":\"model_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":null,\"pivot\":null,\"taggable\":null}',25),(169,5,'car_belongsto_color_relationship','relationship','Color',1,1,1,1,1,1,'{\"model\":\"App\\\\Color\",\"table\":\"colors\",\"type\":\"belongsTo\",\"column\":\"color_id\",\"key\":\"id\",\"label\":\"name\",\"pivot_table\":null,\"pivot\":null,\"taggable\":null}',26);
  145. /*!40000 ALTER TABLE `data_rows` ENABLE KEYS */;
  146. UNLOCK TABLES;
  147.  
  148. --
  149. -- Table structure for table `data_types`
  150. --
  151.  
  152. DROP TABLE IF EXISTS `data_types`;
  153. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  154. /*!40101 SET character_set_client = utf8 */;
  155. CREATE TABLE `data_types` (
  156.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  157.   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  158.   `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  159.   `display_name_singular` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  160.   `display_name_plural` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  161.   `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  162.   `model_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  163.   `policy_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  164.   `controller` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  165.   `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  166.   `generate_permissions` tinyint(1) NOT NULL DEFAULT '0',
  167.   `server_side` tinyint(4) NOT NULL DEFAULT '0',
  168.   `details` text COLLATE utf8mb4_unicode_ci,
  169.   `created_at` timestamp NULL DEFAULT NULL,
  170.   `updated_at` timestamp NULL DEFAULT NULL,
  171.   PRIMARY KEY (`id`),
  172.   UNIQUE KEY `data_types_name_unique` (`name`),
  173.   UNIQUE KEY `data_types_slug_unique` (`slug`)
  174. ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  175. /*!40101 SET character_set_client = @saved_cs_client */;
  176.  
  177. --
  178. -- Dumping data for table `data_types`
  179. --
  180.  
  181. LOCK TABLES `data_types` WRITE;
  182. /*!40000 ALTER TABLE `data_types` DISABLE KEYS */;
  183. INSERT INTO `data_types` VALUES (1,'users','users','User','Users','voyager-person','TCG\\Voyager\\Models\\User','TCG\\Voyager\\Policies\\UserPolicy','','',1,0,NULL,'2018-12-11 12:51:05','2018-12-11 12:51:05'),(2,'menus','menus','Menu','Menus','voyager-list','TCG\\Voyager\\Models\\Menu',NULL,NULL,NULL,1,0,'{\"order_column\":null,\"order_display_column\":null}','2018-12-11 12:51:05','2018-12-21 11:33:04'),(3,'roles','roles','Role','Roles','voyager-lock','TCG\\Voyager\\Models\\Role',NULL,'','',1,0,NULL,'2018-12-11 12:51:05','2018-12-11 12:51:05'),(5,'cars','autos','Auto','Autos',NULL,'App\\Car',NULL,NULL,NULL,1,0,'{\"order_column\":\"id\",\"order_display_column\":\"id\"}','2018-12-11 13:45:10','2019-01-06 18:55:32'),(7,'subsidiaries','subsidiaries','Sucursal','Sucursales',NULL,'App\\Subsidiary',NULL,NULL,NULL,1,0,'{\"order_column\":null,\"order_display_column\":\"name\"}','2018-12-19 10:25:18','2018-12-30 18:35:27'),(9,'services','services','Servicio','Servicios',NULL,'App\\Service',NULL,NULL,NULL,1,0,'{\"order_column\":null,\"order_display_column\":null}','2018-12-19 11:17:39','2018-12-30 13:35:51'),(11,'motorcycles','motocicletas','Motocicleta','Motocicletas',NULL,'App\\Motorcycle',NULL,NULL,NULL,1,0,'{\"order_column\":null,\"order_display_column\":null}','2018-12-20 11:01:26','2018-12-30 04:47:39'),(12,'slides','slides','Slide','Slides',NULL,'App\\Slide',NULL,NULL,NULL,1,0,'{\"order_column\":null,\"order_display_column\":null}','2018-12-20 12:35:45','2018-12-21 12:08:07'),(15,'ping_pongs','ping-pongs','Ping Pong','Ping Pongs',NULL,'App\\PingPong',NULL,NULL,NULL,1,0,'{\"order_column\":null,\"order_display_column\":null}','2018-12-21 08:45:57','2018-12-21 12:26:33'),(16,'brands','brands','Marca','Marcas',NULL,'App\\Brand',NULL,NULL,NULL,1,0,'{\"order_column\":null,\"order_display_column\":null}','2018-12-21 12:38:52','2018-12-21 12:41:16'),(18,'models','models','Modelo','Modelos',NULL,'App\\Model',NULL,NULL,NULL,1,0,'{\"order_column\":null,\"order_display_column\":null}','2018-12-21 12:40:48','2018-12-21 12:41:01'),(19,'colors','colors','Color','Colores',NULL,'App\\Color',NULL,NULL,NULL,1,0,'{\"order_column\":null,\"order_display_column\":null}','2018-12-21 12:42:23','2018-12-21 12:42:34');
  184. /*!40000 ALTER TABLE `data_types` ENABLE KEYS */;
  185. UNLOCK TABLES;
  186.  
  187. --
  188. -- Table structure for table `menu_items`
  189. --
  190.  
  191. DROP TABLE IF EXISTS `menu_items`;
  192. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  193. /*!40101 SET character_set_client = utf8 */;
  194. CREATE TABLE `menu_items` (
  195.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  196.   `menu_id` int(10) unsigned DEFAULT NULL,
  197.   `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  198.   `url` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  199.   `target` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self',
  200.   `icon_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  201.   `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  202.   `parent_id` int(11) DEFAULT NULL,
  203.   `order` int(11) NOT NULL,
  204.   `created_at` timestamp NULL DEFAULT NULL,
  205.   `updated_at` timestamp NULL DEFAULT NULL,
  206.   `route` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  207.   `parameters` text COLLATE utf8mb4_unicode_ci,
  208.   PRIMARY KEY (`id`),
  209.   KEY `menu_items_menu_id_foreign` (`menu_id`),
  210.   CONSTRAINT `menu_items_menu_id_foreign` FOREIGN KEY (`menu_id`) REFERENCES `menus` (`id`) ON DELETE CASCADE
  211. ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  212. /*!40101 SET character_set_client = @saved_cs_client */;
  213.  
  214. --
  215. -- Dumping data for table `menu_items`
  216. --
  217.  
  218. LOCK TABLES `menu_items` WRITE;
  219. /*!40000 ALTER TABLE `menu_items` DISABLE KEYS */;
  220. INSERT INTO `menu_items` VALUES (1,1,'Panel de Administación','','_self','voyager-dashboard','#000000',NULL,1,'2018-12-11 12:51:05','2018-12-30 18:57:03','voyager.dashboard','null'),(2,1,'Media','','_self','voyager-images',NULL,1,4,'2018-12-11 12:51:05','2018-12-19 10:38:26','voyager.media.index',NULL),(3,1,'Usuarios','','_self','voyager-person','#000000',1,3,'2018-12-11 12:51:05','2018-12-30 18:56:34','voyager.users.index','null'),(4,1,'Roles','','_self','voyager-lock',NULL,1,2,'2018-12-11 12:51:05','2018-12-19 10:38:22','voyager.roles.index',NULL),(5,1,'Tools','','_self','voyager-tools',NULL,NULL,4,'2018-12-11 12:51:05','2018-12-21 12:53:17',NULL,NULL),(6,1,'Menu Builder','','_self','voyager-list',NULL,5,1,'2018-12-11 12:51:05','2018-12-19 10:37:28','voyager.menus.index',NULL),(7,1,'Database','','_self','voyager-data',NULL,5,2,'2018-12-11 12:51:05','2018-12-19 10:37:28','voyager.database.index',NULL),(8,1,'Compass','','_self','voyager-compass',NULL,5,3,'2018-12-11 12:51:05','2018-12-19 10:37:28','voyager.compass.index',NULL),(9,1,'BREAD','','_self','voyager-bread',NULL,5,4,'2018-12-11 12:51:05','2018-12-19 10:37:28','voyager.bread.index',NULL),(10,1,'Configuraciones','','_self','voyager-settings','#000000',1,1,'2018-12-11 12:51:05','2018-12-30 18:56:17','voyager.settings.index','null'),(11,1,'Hooks','','_self','voyager-hook',NULL,5,5,'2018-12-11 12:55:02','2018-12-19 10:37:28','voyager.hooks',NULL),(12,1,'Autos','','_self','fa fa-car','#000000',18,1,'2018-12-11 13:45:10','2018-12-21 12:55:33','voyager.autos.index','null'),(15,1,'Sucursales','','_self','voyager-shop','#000000',17,1,'2018-12-19 10:25:18','2018-12-21 13:06:46','voyager.subsidiaries.index','null'),(16,1,'Slides','','_self','voyager-play','#000000',17,2,'2018-12-19 10:34:30','2018-12-21 13:06:46','voyager.slides.index','null'),(17,1,'Ajustes','','_self','voyager-params','#000000',NULL,3,'2018-12-19 10:37:21','2018-12-21 13:06:12',NULL,''),(18,1,'Catálogo','','_self','voyager-archive','#000000',NULL,2,'2018-12-19 10:38:05','2018-12-20 13:29:57',NULL,''),(19,1,'Servicios','','_self','voyager-certificate','#000000',17,4,'2018-12-19 11:17:39','2018-12-21 13:06:46','voyager.services.index','null'),(21,1,'Motocicletas','','_self','fa fa-motorcycle','#000000',18,2,'2018-12-20 11:01:26','2018-12-21 12:55:33','voyager.motocicleta.index','null'),(23,1,'Ping Pongs','','_self','fa fa-comments-o','#000000',17,3,'2018-12-21 08:45:57','2018-12-21 13:06:46','voyager.ping-pongs.index','null'),(24,2,'Inicio','','_self',NULL,'#000000',NULL,1,'2018-12-21 11:01:36','2018-12-21 11:37:28','home',NULL),(25,2,'Servicios','','_self',NULL,'#000000',NULL,2,'2018-12-21 11:03:55','2018-12-21 11:37:28','services',NULL),(26,2,'Catálogo','','_self',NULL,'#000000',NULL,3,'2018-12-21 11:04:41','2018-12-21 11:37:30','catalog',NULL),(27,2,'Contacto','','_self',NULL,'#000000',NULL,5,'2018-12-21 11:05:34','2019-01-06 20:03:24','home','null'),(28,2,'Sucursales','','_self',NULL,'#000000',NULL,4,'2018-12-21 11:37:24','2019-01-06 15:41:20','subsidiaries','null'),(29,1,'Marcas','','_self','voyager-paw','#000000',17,5,'2018-12-21 12:52:21','2018-12-21 12:56:46','voyager.brands.index','null'),(30,1,'Modelos','','_self','voyager-dashboard','#000000',17,6,'2018-12-21 12:53:10','2018-12-21 13:01:30','voyager.models.index','null'),(31,1,'Colores','','_self','voyager-brush','#000000',17,7,'2018-12-21 12:53:36','2018-12-21 12:57:03','voyager.colors.index','null');
  221. /*!40000 ALTER TABLE `menu_items` ENABLE KEYS */;
  222. UNLOCK TABLES;
  223.  
  224. --
  225. -- Table structure for table `menus`
  226. --
  227.  
  228. DROP TABLE IF EXISTS `menus`;
  229. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  230. /*!40101 SET character_set_client = utf8 */;
  231. CREATE TABLE `menus` (
  232.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  233.   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  234.   `created_at` timestamp NULL DEFAULT NULL,
  235.   `updated_at` timestamp NULL DEFAULT NULL,
  236.   PRIMARY KEY (`id`),
  237.   UNIQUE KEY `menus_name_unique` (`name`)
  238. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  239. /*!40101 SET character_set_client = @saved_cs_client */;
  240.  
  241. --
  242. -- Dumping data for table `menus`
  243. --
  244.  
  245. LOCK TABLES `menus` WRITE;
  246. /*!40000 ALTER TABLE `menus` DISABLE KEYS */;
  247. INSERT INTO `menus` VALUES (1,'admin','2018-12-11 12:51:05','2018-12-11 12:51:05'),(2,'site.main','2018-12-17 07:48:41','2018-12-21 11:33:23');
  248. /*!40000 ALTER TABLE `menus` ENABLE KEYS */;
  249. UNLOCK TABLES;
  250.  
  251. --
  252. -- Table structure for table `migrations`
  253. --
  254.  
  255. DROP TABLE IF EXISTS `migrations`;
  256. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  257. /*!40101 SET character_set_client = utf8 */;
  258. CREATE TABLE `migrations` (
  259.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  260.   `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  261.   `batch` int(11) NOT NULL,
  262.   PRIMARY KEY (`id`)
  263. ) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  264. /*!40101 SET character_set_client = @saved_cs_client */;
  265.  
  266. --
  267. -- Dumping data for table `migrations`
  268. --
  269.  
  270. LOCK TABLES `migrations` WRITE;
  271. /*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
  272. INSERT INTO `migrations` VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2016_01_01_000000_add_voyager_user_fields',1),(4,'2016_01_01_000000_create_data_types_table',1),(5,'2016_05_19_173453_create_menu_table',1),(6,'2016_10_21_190000_create_roles_table',1),(7,'2016_10_21_190000_create_settings_table',1),(8,'2016_11_30_135954_create_permission_table',1),(9,'2016_11_30_141208_create_permission_role_table',1),(10,'2016_12_26_201236_data_types__add__server_side',1),(11,'2017_01_13_000000_add_route_to_menu_items_table',1),(12,'2017_01_14_005015_create_translations_table',1),(13,'2017_01_15_000000_make_table_name_nullable_in_permissions_table',1),(14,'2017_03_06_000000_add_controller_to_data_types_table',1),(15,'2017_04_21_000000_add_order_to_data_rows_table',1),(16,'2017_07_05_210000_add_policyname_to_data_types_table',1),(17,'2017_08_05_000000_add_group_to_settings_table',1),(18,'2017_11_26_013050_add_user_role_relationship',1),(19,'2017_11_26_015000_create_user_roles_table',1),(20,'2018_03_11_000000_add_user_settings',1),(21,'2018_03_14_000000_add_details_to_data_types_table',1),(22,'2018_03_16_000000_make_settings_value_nullable',1),(23,'2017_03_20_002259_create_cars_table',2);
  273. /*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
  274. UNLOCK TABLES;
  275.  
  276. --
  277. -- Table structure for table `models`
  278. --
  279.  
  280. DROP TABLE IF EXISTS `models`;
  281. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  282. /*!40101 SET character_set_client = utf8 */;
  283. CREATE TABLE `models` (
  284.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  285.   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  286.   `created_at` timestamp NULL DEFAULT NULL,
  287.   `updated_at` timestamp NULL DEFAULT NULL,
  288.   PRIMARY KEY (`id`)
  289. ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  290. /*!40101 SET character_set_client = @saved_cs_client */;
  291.  
  292. --
  293. -- Dumping data for table `models`
  294. --
  295.  
  296. LOCK TABLES `models` WRITE;
  297. /*!40000 ALTER TABLE `models` DISABLE KEYS */;
  298. INSERT INTO `models` VALUES (1,'Fiesta','2018-12-30 19:03:08','2018-12-30 19:03:08'),(2,'Duster','2018-12-30 19:15:17','2018-12-30 19:15:17'),(3,'Aveo','2018-12-30 19:15:22','2018-12-30 19:15:22'),(4,'March','2018-12-30 19:15:28','2018-12-30 19:15:28'),(5,'Beetle','2018-12-30 19:15:33','2018-12-30 19:15:33'),(6,'Tiida','2018-12-30 19:15:38','2018-12-30 19:15:38'),(7,'suburban','2018-12-30 19:15:45','2018-12-30 19:15:45'),(8,'Versa','2018-12-30 19:15:50','2018-12-30 19:15:50'),(9,'L200','2018-12-30 19:15:55','2018-12-30 19:15:55'),(10,'Lobo','2018-12-30 19:16:00','2018-12-30 19:16:00'),(11,'Impreza','2018-12-30 19:16:05','2018-12-30 19:16:05');
  299. /*!40000 ALTER TABLE `models` ENABLE KEYS */;
  300. UNLOCK TABLES;
  301.  
  302. --
  303. -- Table structure for table `motorcycles`
  304. --
  305.  
  306. DROP TABLE IF EXISTS `motorcycles`;
  307. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  308. /*!40101 SET character_set_client = utf8 */;
  309. CREATE TABLE `motorcycles` (
  310.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  311.   `brand_id` int(10) unsigned NOT NULL,
  312.   `model_id` int(10) unsigned NOT NULL,
  313.   `year` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  314.   `size` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  315.   `price` decimal(10,0) DEFAULT NULL,
  316.   `rent` decimal(10,0) DEFAULT NULL,
  317.   `color_id` int(10) unsigned NOT NULL,
  318.   `inspire` text COLLATE utf8mb4_unicode_ci,
  319.   `details` text COLLATE utf8mb4_unicode_ci,
  320.   `images` text COLLATE utf8mb4_unicode_ci NOT NULL,
  321.   `published` tinytext COLLATE utf8mb4_unicode_ci NOT NULL,
  322.   `subsidiary_id` int(10) unsigned NOT NULL,
  323.   `created_at` timestamp NULL DEFAULT NULL,
  324.   `updated_at` timestamp NULL DEFAULT NULL,
  325.   PRIMARY KEY (`id`)
  326. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  327. /*!40101 SET character_set_client = @saved_cs_client */;
  328.  
  329. --
  330. -- Dumping data for table `motorcycles`
  331. --
  332.  
  333. LOCK TABLES `motorcycles` WRITE;
  334. /*!40000 ALTER TABLE `motorcycles` DISABLE KEYS */;
  335. /*!40000 ALTER TABLE `motorcycles` ENABLE KEYS */;
  336. UNLOCK TABLES;
  337.  
  338. --
  339. -- Table structure for table `password_resets`
  340. --
  341.  
  342. DROP TABLE IF EXISTS `password_resets`;
  343. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  344. /*!40101 SET character_set_client = utf8 */;
  345. CREATE TABLE `password_resets` (
  346.   `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  347.   `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  348.   `created_at` timestamp NULL DEFAULT NULL,
  349.   KEY `password_resets_email_index` (`email`)
  350. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  351. /*!40101 SET character_set_client = @saved_cs_client */;
  352.  
  353. --
  354. -- Dumping data for table `password_resets`
  355. --
  356.  
  357. LOCK TABLES `password_resets` WRITE;
  358. /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
  359. /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
  360. UNLOCK TABLES;
  361.  
  362. --
  363. -- Table structure for table `permission_role`
  364. --
  365.  
  366. DROP TABLE IF EXISTS `permission_role`;
  367. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  368. /*!40101 SET character_set_client = utf8 */;
  369. CREATE TABLE `permission_role` (
  370.   `permission_id` int(10) unsigned NOT NULL,
  371.   `role_id` int(10) unsigned NOT NULL,
  372.   PRIMARY KEY (`permission_id`,`role_id`),
  373.   KEY `permission_role_permission_id_index` (`permission_id`),
  374.   KEY `permission_role_role_id_index` (`role_id`),
  375.   CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  376.   CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
  377. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  378. /*!40101 SET character_set_client = @saved_cs_client */;
  379.  
  380. --
  381. -- Dumping data for table `permission_role`
  382. --
  383.  
  384. LOCK TABLES `permission_role` WRITE;
  385. /*!40000 ALTER TABLE `permission_role` DISABLE KEYS */;
  386. INSERT INTO `permission_role` VALUES (1,1),(1,2),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(27,2),(28,1),(28,2),(29,1),(29,2),(30,1),(30,2),(31,1),(31,2),(32,1),(32,2),(33,1),(33,2),(34,1),(34,2),(35,1),(35,2),(36,1),(36,2),(42,1),(42,2),(43,1),(43,2),(44,1),(44,2),(45,1),(45,2),(46,1),(46,2),(52,1),(52,2),(53,1),(53,2),(54,1),(54,2),(55,1),(55,2),(56,1),(56,2),(57,1),(57,2),(58,1),(58,2),(59,1),(59,2),(60,1),(60,2),(61,1),(61,2),(72,1),(72,2),(73,1),(73,2),(74,1),(74,2),(75,1),(75,2),(76,1),(76,2),(77,1),(77,2),(78,1),(78,2),(79,1),(79,2),(80,1),(80,2),(81,1),(81,2),(82,1),(82,2),(83,1),(83,2),(84,1),(84,2),(85,1),(85,2),(86,1),(86,2),(87,1),(87,2),(88,1),(88,2),(89,1),(89,2),(90,1),(90,2),(91,1),(91,2);
  387. /*!40000 ALTER TABLE `permission_role` ENABLE KEYS */;
  388. UNLOCK TABLES;
  389.  
  390. --
  391. -- Table structure for table `permissions`
  392. --
  393.  
  394. DROP TABLE IF EXISTS `permissions`;
  395. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  396. /*!40101 SET character_set_client = utf8 */;
  397. CREATE TABLE `permissions` (
  398.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  399.   `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  400.   `table_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  401.   `created_at` timestamp NULL DEFAULT NULL,
  402.   `updated_at` timestamp NULL DEFAULT NULL,
  403.   PRIMARY KEY (`id`),
  404.   KEY `permissions_key_index` (`key`)
  405. ) ENGINE=InnoDB AUTO_INCREMENT=92 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  406. /*!40101 SET character_set_client = @saved_cs_client */;
  407.  
  408. --
  409. -- Dumping data for table `permissions`
  410. --
  411.  
  412. LOCK TABLES `permissions` WRITE;
  413. /*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
  414. INSERT INTO `permissions` VALUES (1,'browse_admin',NULL,'2018-12-11 12:51:05','2018-12-11 12:51:05'),(2,'browse_bread',NULL,'2018-12-11 12:51:05','2018-12-11 12:51:05'),(3,'browse_database',NULL,'2018-12-11 12:51:05','2018-12-11 12:51:05'),(4,'browse_media',NULL,'2018-12-11 12:51:05','2018-12-11 12:51:05'),(5,'browse_compass',NULL,'2018-12-11 12:51:05','2018-12-11 12:51:05'),(6,'browse_menus','menus','2018-12-11 12:51:05','2018-12-11 12:51:05'),(7,'read_menus','menus','2018-12-11 12:51:05','2018-12-11 12:51:05'),(8,'edit_menus','menus','2018-12-11 12:51:05','2018-12-11 12:51:05'),(9,'add_menus','menus','2018-12-11 12:51:05','2018-12-11 12:51:05'),(10,'delete_menus','menus','2018-12-11 12:51:05','2018-12-11 12:51:05'),(11,'browse_roles','roles','2018-12-11 12:51:05','2018-12-11 12:51:05'),(12,'read_roles','roles','2018-12-11 12:51:05','2018-12-11 12:51:05'),(13,'edit_roles','roles','2018-12-11 12:51:05','2018-12-11 12:51:05'),(14,'add_roles','roles','2018-12-11 12:51:05','2018-12-11 12:51:05'),(15,'delete_roles','roles','2018-12-11 12:51:05','2018-12-11 12:51:05'),(16,'browse_users','users','2018-12-11 12:51:05','2018-12-11 12:51:05'),(17,'read_users','users','2018-12-11 12:51:05','2018-12-11 12:51:05'),(18,'edit_users','users','2018-12-11 12:51:05','2018-12-11 12:51:05'),(19,'add_users','users','2018-12-11 12:51:05','2018-12-11 12:51:05'),(20,'delete_users','users','2018-12-11 12:51:05','2018-12-11 12:51:05'),(21,'browse_settings','settings','2018-12-11 12:51:05','2018-12-11 12:51:05'),(22,'read_settings','settings','2018-12-11 12:51:05','2018-12-11 12:51:05'),(23,'edit_settings','settings','2018-12-11 12:51:05','2018-12-11 12:51:05'),(24,'add_settings','settings','2018-12-11 12:51:05','2018-12-11 12:51:05'),(25,'delete_settings','settings','2018-12-11 12:51:05','2018-12-11 12:51:05'),(26,'browse_hooks',NULL,'2018-12-11 12:55:02','2018-12-11 12:55:02'),(27,'browse_cars','cars','2018-12-11 13:45:10','2018-12-11 13:45:10'),(28,'read_cars','cars','2018-12-11 13:45:10','2018-12-11 13:45:10'),(29,'edit_cars','cars','2018-12-11 13:45:10','2018-12-11 13:45:10'),(30,'add_cars','cars','2018-12-11 13:45:10','2018-12-11 13:45:10'),(31,'delete_cars','cars','2018-12-11 13:45:10','2018-12-11 13:45:10'),(32,'browse_subsidiaries','subsidiaries','2018-12-19 10:25:18','2018-12-19 10:25:18'),(33,'read_subsidiaries','subsidiaries','2018-12-19 10:25:18','2018-12-19 10:25:18'),(34,'edit_subsidiaries','subsidiaries','2018-12-19 10:25:18','2018-12-19 10:25:18'),(35,'add_subsidiaries','subsidiaries','2018-12-19 10:25:18','2018-12-19 10:25:18'),(36,'delete_subsidiaries','subsidiaries','2018-12-19 10:25:18','2018-12-19 10:25:18'),(42,'browse_services','services','2018-12-19 11:17:39','2018-12-19 11:17:39'),(43,'read_services','services','2018-12-19 11:17:39','2018-12-19 11:17:39'),(44,'edit_services','services','2018-12-19 11:17:39','2018-12-19 11:17:39'),(45,'add_services','services','2018-12-19 11:17:39','2018-12-19 11:17:39'),(46,'delete_services','services','2018-12-19 11:17:39','2018-12-19 11:17:39'),(52,'browse_motorcycles','motorcycles','2018-12-20 11:01:26','2018-12-20 11:01:26'),(53,'read_motorcycles','motorcycles','2018-12-20 11:01:26','2018-12-20 11:01:26'),(54,'edit_motorcycles','motorcycles','2018-12-20 11:01:26','2018-12-20 11:01:26'),(55,'add_motorcycles','motorcycles','2018-12-20 11:01:26','2018-12-20 11:01:26'),(56,'delete_motorcycles','motorcycles','2018-12-20 11:01:26','2018-12-20 11:01:26'),(57,'browse_slides','slides','2018-12-20 12:35:45','2018-12-20 12:35:45'),(58,'read_slides','slides','2018-12-20 12:35:45','2018-12-20 12:35:45'),(59,'edit_slides','slides','2018-12-20 12:35:45','2018-12-20 12:35:45'),(60,'add_slides','slides','2018-12-20 12:35:45','2018-12-20 12:35:45'),(61,'delete_slides','slides','2018-12-20 12:35:45','2018-12-20 12:35:45'),(72,'browse_ping_pongs','ping_pongs','2018-12-21 08:45:57','2018-12-21 08:45:57'),(73,'read_ping_pongs','ping_pongs','2018-12-21 08:45:57','2018-12-21 08:45:57'),(74,'edit_ping_pongs','ping_pongs','2018-12-21 08:45:57','2018-12-21 08:45:57'),(75,'add_ping_pongs','ping_pongs','2018-12-21 08:45:57','2018-12-21 08:45:57'),(76,'delete_ping_pongs','ping_pongs','2018-12-21 08:45:57','2018-12-21 08:45:57'),(77,'browse_brands','brands','2018-12-21 12:38:52','2018-12-21 12:38:52'),(78,'read_brands','brands','2018-12-21 12:38:52','2018-12-21 12:38:52'),(79,'edit_brands','brands','2018-12-21 12:38:52','2018-12-21 12:38:52'),(80,'add_brands','brands','2018-12-21 12:38:52','2018-12-21 12:38:52'),(81,'delete_brands','brands','2018-12-21 12:38:52','2018-12-21 12:38:52'),(82,'browse_models','models','2018-12-21 12:40:48','2018-12-21 12:40:48'),(83,'read_models','models','2018-12-21 12:40:48','2018-12-21 12:40:48'),(84,'edit_models','models','2018-12-21 12:40:48','2018-12-21 12:40:48'),(85,'add_models','models','2018-12-21 12:40:48','2018-12-21 12:40:48'),(86,'delete_models','models','2018-12-21 12:40:48','2018-12-21 12:40:48'),(87,'browse_colors','colors','2018-12-21 12:42:23','2018-12-21 12:42:23'),(88,'read_colors','colors','2018-12-21 12:42:23','2018-12-21 12:42:23'),(89,'edit_colors','colors','2018-12-21 12:42:23','2018-12-21 12:42:23'),(90,'add_colors','colors','2018-12-21 12:42:23','2018-12-21 12:42:23'),(91,'delete_colors','colors','2018-12-21 12:42:23','2018-12-21 12:42:23');
  415. /*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
  416. UNLOCK TABLES;
  417.  
  418. --
  419. -- Table structure for table `ping_pongs`
  420. --
  421.  
  422. DROP TABLE IF EXISTS `ping_pongs`;
  423. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  424. /*!40101 SET character_set_client = utf8 */;
  425. CREATE TABLE `ping_pongs` (
  426.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  427.   `page` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  428.   `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  429.   `comment` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  430.   `anchor_route` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  431.   `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  432.   `position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  433.   `created_at` timestamp NULL DEFAULT NULL,
  434.   `updated_at` timestamp NULL DEFAULT NULL,
  435.   PRIMARY KEY (`id`)
  436. ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  437. /*!40101 SET character_set_client = @saved_cs_client */;
  438.  
  439. --
  440. -- Dumping data for table `ping_pongs`
  441. --
  442.  
  443. LOCK TABLES `ping_pongs` WRITE;
  444. /*!40000 ALTER TABLE `ping_pongs` DISABLE KEYS */;
  445. INSERT INTO `ping_pongs` VALUES (1,'index','RENTA DE AUTOS, MOTOS','Elige el que mas te guste y apartalo.','catalog','ping-pongs/December2018/R0W9NvTvUQlS6VJpBHAb.jpg','ping','2018-12-21 09:45:58','2018-12-21 09:45:58'),(2,'index','AMPLIA GAMA DE VEHICULOS','Vehiculos evaluados y certificados en cuanto a calidad tecnica, estetica y funcionalidad al 100%','catalog','ping-pongs/December2018/YB8PwJpNcri6MmDaBWUZ.jpg','pong','2018-12-21 09:48:24','2018-12-21 10:57:26'),(3,'index','RENTA DE FLOTILLAS','Rentas a largo plazo deducibles fiscalmente al 100%','contact','ping-pongs/December2018/OPymJ8op3RRFjUZgrzHR.jpg','ping','2018-12-21 09:49:09','2018-12-21 09:49:09');
  446. /*!40000 ALTER TABLE `ping_pongs` ENABLE KEYS */;
  447. UNLOCK TABLES;
  448.  
  449. --
  450. -- Table structure for table `roles`
  451. --
  452.  
  453. DROP TABLE IF EXISTS `roles`;
  454. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  455. /*!40101 SET character_set_client = utf8 */;
  456. CREATE TABLE `roles` (
  457.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  458.   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  459.   `display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  460.   `created_at` timestamp NULL DEFAULT NULL,
  461.   `updated_at` timestamp NULL DEFAULT NULL,
  462.   PRIMARY KEY (`id`),
  463.   UNIQUE KEY `roles_name_unique` (`name`)
  464. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  465. /*!40101 SET character_set_client = @saved_cs_client */;
  466.  
  467. --
  468. -- Dumping data for table `roles`
  469. --
  470.  
  471. LOCK TABLES `roles` WRITE;
  472. /*!40000 ALTER TABLE `roles` DISABLE KEYS */;
  473. INSERT INTO `roles` VALUES (1,'root','Root','2018-12-11 12:26:31','2018-12-19 09:59:32'),(2,'admin','Administrador','2018-12-11 12:51:05','2018-12-19 10:07:06');
  474. /*!40000 ALTER TABLE `roles` ENABLE KEYS */;
  475. UNLOCK TABLES;
  476.  
  477. --
  478. -- Table structure for table `services`
  479. --
  480.  
  481. DROP TABLE IF EXISTS `services`;
  482. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  483. /*!40101 SET character_set_client = utf8 */;
  484. CREATE TABLE `services` (
  485.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  486.   `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  487.   `label` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  488.   `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  489.   `button_route_1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  490.   `button_route_2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  491.   `description_1` text COLLATE utf8mb4_unicode_ci NOT NULL,
  492.   `description_2` text COLLATE utf8mb4_unicode_ci,
  493.   `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  494.   `position` int(11) NOT NULL DEFAULT '0',
  495.   `created_at` timestamp NULL DEFAULT NULL,
  496.   `updated_at` timestamp NULL DEFAULT NULL,
  497.   PRIMARY KEY (`id`)
  498. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  499. /*!40101 SET character_set_client = @saved_cs_client */;
  500.  
  501. --
  502. -- Dumping data for table `services`
  503. --
  504.  
  505. LOCK TABLES `services` WRITE;
  506. /*!40000 ALTER TABLE `services` DISABLE KEYS */;
  507. INSERT INTO `services` VALUES (1,'services/December2018/4U9M1OV4GwjEZ5ZjrDGy.jpeg','Renta','Renta un Auto o una Motocicleta','catalog','catalog','# Requisitos\r\n\r\n* **Autos**:\r\n  * Identificacion/pasaporte, licencia vigente, aceptamos todas las tarjeta de credito.\r\n* **Motos**: \r\n  * Tarjeta, licencia vigente, identificacion/pasaporte.',NULL,'services/December2018/xNxQpalP21sFx7tVUYKe.jpg',0,'2018-12-21 09:14:12','2018-12-30 14:40:02');
  508. /*!40000 ALTER TABLE `services` ENABLE KEYS */;
  509. UNLOCK TABLES;
  510.  
  511. --
  512. -- Table structure for table `settings`
  513. --
  514.  
  515. DROP TABLE IF EXISTS `settings`;
  516. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  517. /*!40101 SET character_set_client = utf8 */;
  518. CREATE TABLE `settings` (
  519.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  520.   `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  521.   `display_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  522.   `value` text COLLATE utf8mb4_unicode_ci,
  523.   `details` text COLLATE utf8mb4_unicode_ci,
  524.   `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  525.   `order` int(11) NOT NULL DEFAULT '1',
  526.   `group` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  527.   PRIMARY KEY (`id`),
  528.   UNIQUE KEY `settings_key_unique` (`key`)
  529. ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  530. /*!40101 SET character_set_client = @saved_cs_client */;
  531.  
  532. --
  533. -- Dumping data for table `settings`
  534. --
  535.  
  536. LOCK TABLES `settings` WRITE;
  537. /*!40000 ALTER TABLE `settings` DISABLE KEYS */;
  538. INSERT INTO `settings` VALUES (1,'site.title','Site Title','Ücar','','text',1,'Site'),(2,'site.description','Site Description','Renta de Autos y Motos','','text',2,'Site'),(3,'site.logo','Site Logo','settings/December2018/X1VwNnqWVbXWtKhsFLVS.png','','image',3,'Site'),(4,'site.google_analytics_tracking_id','Google Analytics Tracking ID',NULL,'','text',4,'Site'),(5,'admin.bg_image','Admin Background Image','','','image',5,'Admin'),(6,'admin.title','Admin Title','Administración','','text',1,'Admin'),(7,'admin.description','Admin Description','Panel de Administración del Sitio','','text',2,'Admin'),(8,'admin.loader','Admin Loader','','','image',3,'Admin'),(9,'admin.icon_image','Admin Icon Image','','','image',4,'Admin'),(10,'admin.google_analytics_client_id','Google Analytics Client ID (used for admin dashboard)',NULL,'','text',1,'Admin'),(12,'social-network.facebook_link','Enlace de Facebook','https://es-la.facebook.com/UcarMx/',NULL,'text',6,'Social Network'),(13,'social-network.twitter_link','Enlace de Twitter','https://twitter.com/ucarmx',NULL,'text',7,'Social Network'),(14,'site.stamp','Estampa','settings/December2018/lYWNIMN409djy2SgO2FC.jpg',NULL,'image',8,'Site'),(15,'site.who-we-are','Quienes Somos','Somos una empresa dedicada al servicio de renta de autos y motocicletas a lo largo del territorio nacional',NULL,'text_area',9,'Site'),(16,'site.what-we-do','Que Hacemos','Nos especializamos en proveer servicios de renta de vehiculos en todo el territorio nacional.',NULL,'text_area',10,'Site'),(17,'site.mission','Misión','Brindar una atención personalizada a cada uno de nuestros clientes. Logrando asi su preferencia',NULL,'text_area',11,'Site'),(18,'site.vision','Visión','Ser el proveedor indicado en la renta de vehiculos para nuestro cliente',NULL,'text_area',12,'Site'),(19,'site.catalog','Catalogo','Elije el modelo que mas te guste.',NULL,'text_area',13,'Site');
  539. /*!40000 ALTER TABLE `settings` ENABLE KEYS */;
  540. UNLOCK TABLES;
  541.  
  542. --
  543. -- Table structure for table `slides`
  544. --
  545.  
  546. DROP TABLE IF EXISTS `slides`;
  547. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  548. /*!40101 SET character_set_client = utf8 */;
  549. CREATE TABLE `slides` (
  550.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  551.   `slider` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  552.   `slide_position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'center',
  553.   `text_position` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'center',
  554.   `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  555.   `title_fade_in` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'top',
  556.   `title_lighting` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'light',
  557.   `subtitle` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  558.   `subtitle_fade_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'top',
  559.   `subtitle_lighting` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'medium',
  560.   `comment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  561.   `comment_lighting` varchar(25) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'dark',
  562.   `button_text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  563.   `button_route` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  564.   `button_fade_in` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'bottom',
  565.   `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  566.   `created_at` timestamp NULL DEFAULT NULL,
  567.   `updated_at` timestamp NULL DEFAULT NULL,
  568.   PRIMARY KEY (`id`)
  569. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  570. /*!40101 SET character_set_client = @saved_cs_client */;
  571.  
  572. --
  573. -- Dumping data for table `slides`
  574. --
  575.  
  576. LOCK TABLES `slides` WRITE;
  577. /*!40000 ALTER TABLE `slides` DISABLE KEYS */;
  578. INSERT INTO `slides` VALUES (1,'main','top','left','Renta de autos y motos','down','medium','Renta tu auto hoy mismo y disfruta de tus vacaciones','down','light',NULL,'light','Servicios','home','down','sliders/December2018/GMptCensoxZoeVBGlMgo.jpg','2018-12-19 11:36:00','2018-12-21 12:01:52');
  579. /*!40000 ALTER TABLE `slides` ENABLE KEYS */;
  580. UNLOCK TABLES;
  581.  
  582. --
  583. -- Table structure for table `subsidiaries`
  584. --
  585.  
  586. DROP TABLE IF EXISTS `subsidiaries`;
  587. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  588. /*!40101 SET character_set_client = utf8 */;
  589. CREATE TABLE `subsidiaries` (
  590.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  591.   `name` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL,
  592.   `details` text COLLATE utf8mb4_unicode_ci,
  593.   `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  594.   `colony` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  595.   `locality` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  596.   `city` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  597.   `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  598.   `zip` varchar(6) COLLATE utf8mb4_unicode_ci NOT NULL,
  599.   `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  600.   `phone_1` varchar(18) COLLATE utf8mb4_unicode_ci NOT NULL,
  601.   `phone_2` varchar(18) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  602.   `map_coordinates` geometry NOT NULL,
  603.   `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  604.   `created_at` timestamp NULL DEFAULT NULL,
  605.   `updated_at` timestamp NULL DEFAULT NULL,
  606.   PRIMARY KEY (`id`)
  607. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  608. /*!40101 SET character_set_client = @saved_cs_client */;
  609.  
  610. --
  611. -- Dumping data for table `subsidiaries`
  612. --
  613.  
  614. LOCK TABLES `subsidiaries` WRITE;
  615. /*!40000 ALTER TABLE `subsidiaries` DISABLE KEYS */;
  616. INSERT INTO `subsidiaries` VALUES (1,'Ücar',NULL,'Calle del Morro S/N','Col. Marinero','Santa María Colotepec','Pochutla','Oaxaca','70934','ucarpto@gmail.com','(954) 582-32-24','(954) 149-03-04',_binary '\0\0\0\0\0\0\0<?C?\?X??\?\??/@','subsidiaries/December2018/u1vanLqikTaQURttMh6r.jpg','2018-12-19 12:01:00','2019-01-06 16:21:44');
  617. /*!40000 ALTER TABLE `subsidiaries` ENABLE KEYS */;
  618. UNLOCK TABLES;
  619.  
  620. --
  621. -- Table structure for table `translations`
  622. --
  623.  
  624. DROP TABLE IF EXISTS `translations`;
  625. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  626. /*!40101 SET character_set_client = utf8 */;
  627. CREATE TABLE `translations` (
  628.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  629.   `table_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  630.   `column_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  631.   `foreign_key` int(10) unsigned NOT NULL,
  632.   `locale` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  633.   `value` text COLLATE utf8mb4_unicode_ci NOT NULL,
  634.   `created_at` timestamp NULL DEFAULT NULL,
  635.   `updated_at` timestamp NULL DEFAULT NULL,
  636.   PRIMARY KEY (`id`),
  637.   UNIQUE KEY `translations_table_name_column_name_foreign_key_locale_unique` (`table_name`,`column_name`,`foreign_key`,`locale`)
  638. ) ENGINE=InnoDB AUTO_INCREMENT=48 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  639. /*!40101 SET character_set_client = @saved_cs_client */;
  640.  
  641. --
  642. -- Dumping data for table `translations`
  643. --
  644.  
  645. LOCK TABLES `translations` WRITE;
  646. /*!40000 ALTER TABLE `translations` DISABLE KEYS */;
  647. INSERT INTO `translations` VALUES (1,'data_types','display_name_singular',5,'en','Auto','2018-12-11 13:45:46','2018-12-11 13:45:46'),(2,'data_types','display_name_plural',5,'en','Autos','2018-12-11 13:45:46','2018-12-11 13:45:46'),(5,'menu_items','title',17,'en','','2018-12-19 10:37:21','2018-12-19 10:37:21'),(6,'menu_items','title',18,'en','','2018-12-19 10:38:05','2018-12-19 10:38:05'),(7,'menu_items','title',15,'en','Sucursales','2018-12-19 10:39:20','2018-12-19 10:39:20'),(11,'menu_items','title',19,'en','Services','2018-12-19 11:48:13','2018-12-19 11:48:13'),(12,'menu_items','title',12,'en','Autos','2018-12-20 11:07:45','2018-12-20 11:07:45'),(13,'menu_items','title',21,'en','Motocicletas','2018-12-20 11:21:41','2018-12-20 11:21:41'),(14,'data_types','display_name_singular',12,'en','Slide','2018-12-20 12:46:45','2018-12-20 12:46:45'),(15,'data_types','display_name_plural',12,'en','Slides','2018-12-20 12:46:45','2018-12-20 12:46:45'),(16,'menu_items','title',16,'en','Sliders','2018-12-20 13:26:11','2018-12-20 13:26:11'),(17,'data_types','display_name_singular',7,'en','Sucursal','2018-12-21 05:16:34','2018-12-21 05:16:34'),(18,'data_types','display_name_plural',7,'en','Sucursales','2018-12-21 05:16:34','2018-12-21 05:16:34'),(19,'data_types','display_name_singular',9,'en','Service','2018-12-21 07:28:42','2018-12-21 07:28:42'),(20,'data_types','display_name_plural',9,'en','Services','2018-12-21 07:28:42','2018-12-21 07:28:42'),(21,'menu_items','title',23,'en','Ping Pongs','2018-12-21 08:48:24','2018-12-21 08:48:24'),(22,'data_types','display_name_singular',15,'en','Ping Pong','2018-12-21 09:36:28','2018-12-21 09:36:28'),(23,'data_types','display_name_plural',15,'en','Ping Pongs','2018-12-21 09:36:28','2018-12-21 09:36:28'),(24,'menu_items','title',24,'en','','2018-12-21 11:01:36','2018-12-21 11:01:36'),(25,'menu_items','title',25,'en','','2018-12-21 11:03:55','2018-12-21 11:03:55'),(26,'menu_items','title',26,'en','','2018-12-21 11:04:41','2018-12-21 11:04:41'),(27,'menu_items','title',27,'en','','2018-12-21 11:05:35','2018-12-21 11:05:35'),(28,'data_types','display_name_singular',2,'en','Menu','2018-12-21 11:13:02','2018-12-21 11:13:02'),(29,'data_types','display_name_plural',2,'en','Menus','2018-12-21 11:13:02','2018-12-21 11:13:02'),(30,'menu_items','title',28,'en','','2018-12-21 11:37:24','2018-12-21 11:37:24'),(31,'data_types','display_name_singular',11,'en','Motocicleta','2018-12-21 11:50:01','2018-12-21 11:50:01'),(32,'data_types','display_name_plural',11,'en','Motocicletas','2018-12-21 11:50:01','2018-12-21 11:50:01'),(33,'data_types','display_name_singular',18,'en','Modelo','2018-12-21 12:41:01','2018-12-21 12:41:01'),(34,'data_types','display_name_plural',18,'en','Modelos','2018-12-21 12:41:01','2018-12-21 12:41:01'),(35,'data_types','display_name_singular',16,'en','Marca','2018-12-21 12:41:16','2018-12-21 12:41:16'),(36,'data_types','display_name_plural',16,'en','Marcas','2018-12-21 12:41:16','2018-12-21 12:41:16'),(37,'data_types','display_name_singular',19,'en','Color','2018-12-21 12:42:34','2018-12-21 12:42:34'),(38,'data_types','display_name_plural',19,'en','Colores','2018-12-21 12:42:34','2018-12-21 12:42:34'),(39,'menu_items','title',29,'en','','2018-12-21 12:52:21','2018-12-21 12:52:21'),(40,'menu_items','title',30,'en','','2018-12-21 12:53:10','2018-12-21 12:53:10'),(41,'menu_items','title',31,'en','','2018-12-21 12:53:36','2018-12-21 12:53:36'),(42,'menu_items','title',1,'en','Dashboard','2018-12-21 13:04:16','2018-12-21 13:04:16'),(44,'menu_items','title',10,'en','Settings','2018-12-30 18:56:17','2018-12-30 18:56:17'),(45,'menu_items','title',3,'en','Users','2018-12-30 18:56:34','2018-12-30 18:56:34'),(46,'data_types','display_name_singular',5,'es','Auto','2019-01-06 18:37:33','2019-01-06 18:37:33'),(47,'data_types','display_name_plural',5,'es','Autos','2019-01-06 18:37:33','2019-01-06 18:37:33');
  648. /*!40000 ALTER TABLE `translations` ENABLE KEYS */;
  649. UNLOCK TABLES;
  650.  
  651. --
  652. -- Table structure for table `user_roles`
  653. --
  654.  
  655. DROP TABLE IF EXISTS `user_roles`;
  656. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  657. /*!40101 SET character_set_client = utf8 */;
  658. CREATE TABLE `user_roles` (
  659.   `user_id` int(10) unsigned NOT NULL,
  660.   `role_id` int(10) unsigned NOT NULL,
  661.   PRIMARY KEY (`user_id`,`role_id`),
  662.   KEY `user_roles_user_id_index` (`user_id`),
  663.   KEY `user_roles_role_id_index` (`role_id`),
  664.   CONSTRAINT `user_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  665.   CONSTRAINT `user_roles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
  666. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  667. /*!40101 SET character_set_client = @saved_cs_client */;
  668.  
  669. --
  670. -- Dumping data for table `user_roles`
  671. --
  672.  
  673. LOCK TABLES `user_roles` WRITE;
  674. /*!40000 ALTER TABLE `user_roles` DISABLE KEYS */;
  675. INSERT INTO `user_roles` VALUES (1,1),(2,2);
  676. /*!40000 ALTER TABLE `user_roles` ENABLE KEYS */;
  677. UNLOCK TABLES;
  678.  
  679. --
  680. -- Table structure for table `users`
  681. --
  682.  
  683. DROP TABLE IF EXISTS `users`;
  684. /*!40101 SET @saved_cs_client     = @@character_set_client */;
  685. /*!40101 SET character_set_client = utf8 */;
  686. CREATE TABLE `users` (
  687.   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  688.   `role_id` int(10) unsigned DEFAULT NULL,
  689.   `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  690.   `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  691.   `avatar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'users/default.png',
  692.   `email_verified_at` timestamp NULL DEFAULT NULL,
  693.   `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  694.   `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  695.   `settings` text COLLATE utf8mb4_unicode_ci,
  696.   `created_at` timestamp NULL DEFAULT NULL,
  697.   `updated_at` timestamp NULL DEFAULT NULL,
  698.   PRIMARY KEY (`id`),
  699.   UNIQUE KEY `users_email_unique` (`email`),
  700.   KEY `users_role_id_foreign` (`role_id`),
  701.   CONSTRAINT `users_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`)
  702. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  703. /*!40101 SET character_set_client = @saved_cs_client */;
  704.  
  705. --
  706. -- Dumping data for table `users`
  707. --
  708.  
  709. LOCK TABLES `users` WRITE;
  710. /*!40000 ALTER TABLE `users` DISABLE KEYS */;
  711. INSERT INTO `users` VALUES (1,1,'mariano','quarkmarino@gmail.com','users/December2018/7985vJ9qBhvmGa4yHZvH.png',NULL,'$2y$10$pxIvPlX78TWPYSNlD3OqGeMA.bE3g9dnSqc.5SjAijkBFDv2GN6b2','F4UlL3TvnqqU0QLbTlTQwHyeK5tQ4P4JKrjDqEbDEA1v8FEdHYGnhf6QAZbk','{\"locale\":\"es\"}','2018-12-11 12:26:31','2018-12-19 10:06:02'),(2,2,'adriana','adrianarb_2701@hotmail.com','users/December2018/twaL9uaH6EKB9Jnc4b42.png',NULL,'$2y$10$icr/wnQje893VY/Z54lQTOyDpvf6PINbXxJOVnUtvtTReE.GgM5mG','1WOVPUoeLCDR5y15T6iN75QejEQpEfBYHLIUcWrUEJI6Gb1pLlQQrnFCI5Rd','{\"locale\":\"es\"}','2018-12-19 10:01:51','2018-12-19 10:07:23');
  712. /*!40000 ALTER TABLE `users` ENABLE KEYS */;
  713. UNLOCK TABLES;
  714. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  715.  
  716. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  717. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  718. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  719. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  720. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  721. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  722. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  723.  
  724. -- Dump completed on 2019-01-12 20:42:46
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!