EVOLUTION-MANAGER

Edit File: TURISMO-26-08-2024.sql

-- MySQL dump 10.13  Distrib 8.0.34, for Win64 (x86_64)
--
-- Host: sucre.gob.ec    Database: websucregobec_turismo
-- ------------------------------------------------------
-- Server version	5.7.44-log-cll-lve

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `atractivo`
--

DROP TABLE IF EXISTS `atractivo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `atractivo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parroquia_id` int(11) DEFAULT NULL,
  `ficha_tecnica` text COLLATE utf8_unicode_ci,
  `ficha_tecnica_cod` text COLLATE utf8_unicode_ci,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `direccion` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `correo` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telefono` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `celular` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `celular_what` int(11) DEFAULT '0' COMMENT '1=SI 0=NO',
  `costo` decimal(2,0) DEFAULT NULL,
  `responsable` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `horario` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url_web` text COLLATE utf8_unicode_ci,
  `latitud` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `longitud` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url_fb` text COLLATE utf8_unicode_ci,
  `url_in` text COLLATE utf8_unicode_ci,
  `url_x` text COLLATE utf8_unicode_ci,
  `url_yt` text COLLATE utf8_unicode_ci,
  `codigo_url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_atractivo_parroquia_idx` (`parroquia_id`),
  CONSTRAINT `fk_atractivo_parroquia` FOREIGN KEY (`parroquia_id`) REFERENCES `parroquia` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `atractivo`
--

LOCK TABLES `atractivo` WRITE;
/*!40000 ALTER TABLE `atractivo` DISABLE KEYS */;
INSERT INTO `atractivo` VALUES (1,1,'https://drive.google.com/uc?id=1wkctwfDt9rLhDZiUa-aSPF33NIy_B-Gl&export=media','1wkctwfDt9rLhDZiUa-aSPF33NIy_B-Gl','Puerta de la Nacionalidad Ecuatoriana des','direccion de pruebas','atractivo@gmail.com','0000000000','0993283283',1,12,'holger Vidal','24/7','https://casa.ceibo.com','-0.63985','-80.41570','https://casa.ceibo.com','https://casa.ceibo.com','https://casa.ceibo.com','https://casa.ceibo.com','bpuerta-de-lab-nacionalidad-ecuatoriana-des','2024-06-13 21:31:18','2024-06-17 18:58:07',NULL);
/*!40000 ALTER TABLE `atractivo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `atractivo_imagen`
--

DROP TABLE IF EXISTS `atractivo_imagen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `atractivo_imagen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ruta` text COLLATE utf8_unicode_ci,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `detalle` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `atractivo_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_atractivo_imagen_atractivo_idx` (`atractivo_id`),
  CONSTRAINT `fk_atractivo_imagen_atractivo` FOREIGN KEY (`atractivo_id`) REFERENCES `atractivo` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `atractivo_imagen`
--

LOCK TABLES `atractivo_imagen` WRITE;
/*!40000 ALTER TABLE `atractivo_imagen` DISABLE KEYS */;
INSERT INTO `atractivo_imagen` VALUES (1,'imagenes/atractivos/1/atractivo-2024-06-141718397908-szoqT4GJ.webp','bpuerta-de-lab-nacionalidad-ecuatoriana-des','',1,'2024-06-14 20:45:08','2024-06-14 20:45:08',NULL);
/*!40000 ALTER TABLE `atractivo_imagen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `atractivo_ofrece`
--

DROP TABLE IF EXISTS `atractivo_ofrece`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `atractivo_ofrece` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `icono` text COLLATE utf8_unicode_ci,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `atractivo_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_atractivo_ofrece_atractivo_idx` (`atractivo_id`),
  CONSTRAINT `fk_atractivo_ofrece_atractivo` FOREIGN KEY (`atractivo_id`) REFERENCES `atractivo` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `atractivo_ofrece`
--

LOCK TABLES `atractivo_ofrece` WRITE;
/*!40000 ALTER TABLE `atractivo_ofrece` DISABLE KEYS */;
INSERT INTO `atractivo_ofrece` VALUES (1,'fas fa-asterisk fa-fw','Asientos',1,'2024-06-14 20:45:08','2024-06-14 20:45:08',NULL),(2,'fas fa-bus-alt fa-fw','Parada de Bus',1,'2024-06-14 20:45:08','2024-06-14 20:45:08',NULL);
/*!40000 ALTER TABLE `atractivo_ofrece` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `boletin`
--

DROP TABLE IF EXISTS `boletin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `boletin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `foto` text COLLATE utf8_unicode_ci,
  `detalle` text COLLATE utf8_unicode_ci,
  `codigo_url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `boletin`
--

LOCK TABLES `boletin` WRITE;
/*!40000 ALTER TABLE `boletin` DISABLE KEYS */;
/*!40000 ALTER TABLE `boletin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `carrousel`
--

DROP TABLE IF EXISTS `carrousel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `carrousel` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(250) DEFAULT NULL,
  `imagen` text,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=latin2;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `carrousel`
--

LOCK TABLES `carrousel` WRITE;
/*!40000 ALTER TABLE `carrousel` DISABLE KEYS */;
INSERT INTO `carrousel` VALUES (13,'','imagenes/carrousel/carrousel-2024-07-041720122682-uKhkbNJc.jpg','2024-07-04 19:51:22','2024-07-04 19:51:22',NULL),(14,'','imagenes/carrousel/carrousel-2024-07-041720122682-m7yv9eVx.jpg','2024-07-04 19:51:22','2024-07-04 19:51:22',NULL),(16,'','imagenes/carrousel/carrousel-2024-07-041720122682-7rnhtMI9.jpg','2024-07-04 19:51:22','2024-07-04 19:51:22',NULL),(17,'','imagenes/carrousel/carrousel-2024-07-041720122682-V2uUShxq.jpg','2024-07-04 19:51:22','2024-07-04 19:51:22',NULL),(18,'','imagenes/carrousel/carrousel-2024-07-041720122682-mvLUSo4r.jpg','2024-07-04 19:51:22','2024-07-04 19:51:22',NULL);
/*!40000 ALTER TABLE `carrousel` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cat_lista`
--

DROP TABLE IF EXISTS `cat_lista`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cat_lista` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_titulo_id` int(11) DEFAULT NULL,
  `nombre` varchar(450) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_lista_titulo_idx` (`cat_titulo_id`),
  CONSTRAINT `fk_lista_titulo` FOREIGN KEY (`cat_titulo_id`) REFERENCES `cat_titulo` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cat_lista`
--

LOCK TABLES `cat_lista` WRITE;
/*!40000 ALTER TABLE `cat_lista` DISABLE KEYS */;
INSERT INTO `cat_lista` VALUES (1,1,'Papel higénico'),(2,1,'Toallas'),(3,1,'Baño privado'),(4,1,'Artículos de aseo gratis'),(5,1,'Ducha con agua caliente'),(6,2,'Ropa de cama'),(7,2,'Armarios'),(8,3,'Servicio de Netflix'),(9,3,'TV de pantalla plana'),(10,4,'Extintores'),(11,4,'Cámaras de seguridad fuera del alojamiento'),(12,4,'Cámaras de seguridad en las zonas comunitarias'),(13,5,'Conexión a internet WI-FI'),(14,5,'DISPONIBLE en todo el establecimiento'),(15,6,'Aire acondicionado'),(16,6,'Prohibido fumar en todo el alojamiento'),(17,6,'Suelo de baldosa / mármol'),(18,6,'Habitaciones familiares'),(19,6,'Habitaciones sin humo'),(20,7,'Jardín'),(21,7,'Sala de estar'),(22,8,'Parking general'),(23,8,'Parking privado'),(24,8,'Parking adaptado a personas de movilidad reducida'),(25,9,'Acceso a pisos speriores mediante escaleras'),(26,10,'Enchufe cerca de la cama'),(27,10,'Perchero'),(28,11,'Servicio de limpieza diario'),(29,11,'Registro de entrada / salida privado'),(30,11,'Recepción 24 horas'),(31,12,'Horarios de apertura'),(32,12,'Para todas las edades'),(33,12,'Piscina pequeña'),(34,12,'Zona profunda'),(40,3,'Disney +'),(41,3,'Amazon Prime Video'),(42,3,'Claro Video');
/*!40000 ALTER TABLE `cat_lista` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cat_titulo`
--

DROP TABLE IF EXISTS `cat_titulo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cat_titulo` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titulo` varchar(450) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icono` varchar(450) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tipo` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cat_titulo`
--

LOCK TABLES `cat_titulo` WRITE;
/*!40000 ALTER TABLE `cat_titulo` DISABLE KEYS */;
INSERT INTO `cat_titulo` VALUES (1,'Baño','pagina/img/iconos/servicios/hoteleria/ofrece-banio.png',1),(2,'Habitaciones','pagina/img/iconos/servicios/hoteleria/ofrece-habitacion.png',1),(3,NULL,'pagina/img/iconos/servicios/hoteleria/ofrece-tv.png',1),(4,NULL,'pagina/img/iconos/servicios/hoteleria/ofrece-seguridad.png',1),(5,NULL,'pagina/img/iconos/servicios/hoteleria/ofrece-wifi.png',1),(6,NULL,'pagina/img/iconos/servicios/hoteleria/ofrece-otros.png',1),(7,'Exteriores','pagina/img/iconos/servicios/hoteleria/ofrece-exterior.png',1),(8,NULL,'pagina/img/iconos/servicios/hoteleria/ofrece-parqueo.png',1),(9,NULL,'pagina/img/iconos/servicios/hoteleria/ofrece-discapacidad.png',1),(10,'Instalaciones de la habitacion','pagina/img/iconos/servicios/hoteleria/ofrece-insta.png',1),(11,NULL,'pagina/img/iconos/servicios/hoteleria/ofrece-servicio.png',1),(12,NULL,'pagina/img/iconos/servicios/hoteleria/ofrece-piscina.png',1);
/*!40000 ALTER TABLE `cat_titulo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cat_titulo1`
--

DROP TABLE IF EXISTS `cat_titulo1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cat_titulo1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `titulo` varchar(450) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icono` varchar(450) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tipo` int(11) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cat_titulo1`
--

LOCK TABLES `cat_titulo1` WRITE;
/*!40000 ALTER TABLE `cat_titulo1` DISABLE KEYS */;
INSERT INTO `cat_titulo1` VALUES (1,'Piscina al aire libre','pagina/img/iconos/servicios/hoteleria/hotel-ofrece-1.png',1),(2,'Habitaciones familiares','pagina/img/iconos/servicios/hoteleria/hotel-ofrece-2.png',1),(3,'Parqueo gratis','pagina/img/iconos/servicios/hoteleria/hotel-ofrece-3.png',1),(4,'Wifi gratis','pagina/img/iconos/servicios/hoteleria/hotel-ofrece-4.png',1);
/*!40000 ALTER TABLE `cat_titulo1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cultura`
--

DROP TABLE IF EXISTS `cultura`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cultura` (
  `int` int(11) NOT NULL AUTO_INCREMENT,
  `tipo` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `detalle` text COLLATE utf8_unicode_ci,
  `imagen` text COLLATE utf8_unicode_ci,
  `codigo_url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`int`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cultura`
--

LOCK TABLES `cultura` WRITE;
/*!40000 ALTER TABLE `cultura` DISABLE KEYS */;
/*!40000 ALTER TABLE `cultura` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cultura_imagen`
--

DROP TABLE IF EXISTS `cultura_imagen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cultura_imagen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cultura_id` int(11) DEFAULT NULL,
  `ruta` text COLLATE utf8_unicode_ci,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_cultura_imagen_cultura_idx` (`cultura_id`),
  CONSTRAINT `fk_cultura_imagen_cultura` FOREIGN KEY (`cultura_id`) REFERENCES `cultura` (`int`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cultura_imagen`
--

LOCK TABLES `cultura_imagen` WRITE;
/*!40000 ALTER TABLE `cultura_imagen` DISABLE KEYS */;
/*!40000 ALTER TABLE `cultura_imagen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galeria_foto`
--

DROP TABLE IF EXISTS `galeria_foto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `galeria_foto` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tipo_foto_id` int(11) DEFAULT NULL,
  `ruta` text COLLATE utf8_unicode_ci,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_galeria_foto_tipo_foto_idx` (`tipo_foto_id`),
  CONSTRAINT `fk_galeria_foto_tipo_foto` FOREIGN KEY (`tipo_foto_id`) REFERENCES `tipo_foto` (`int`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `galeria_foto`
--

LOCK TABLES `galeria_foto` WRITE;
/*!40000 ALTER TABLE `galeria_foto` DISABLE KEYS */;
/*!40000 ALTER TABLE `galeria_foto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `galeria_video`
--

DROP TABLE IF EXISTS `galeria_video`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `galeria_video` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ruta` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `galeria_video`
--

LOCK TABLES `galeria_video` WRITE;
/*!40000 ALTER TABLE `galeria_video` DISABLE KEYS */;
/*!40000 ALTER TABLE `galeria_video` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `migrations`
--

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `migrations`
--

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `parroquia`
--

DROP TABLE IF EXISTS `parroquia`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `parroquia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `foto` text COLLATE utf8_unicode_ci,
  `orden` int(11) DEFAULT '0',
  `codigo_url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `parroquia`
--

LOCK TABLES `parroquia` WRITE;
/*!40000 ALTER TABLE `parroquia` DISABLE KEYS */;
INSERT INTO `parroquia` VALUES (1,'Bahía de Caráquez','pagina/img/inicio/inventario_ejemplo1.png',1,'bahia-de-caraquez'),(2,'Leonidas Plaza','pagina/img/inicio/inventario_ejemplo2.png',2,'leonidas-plaza'),(3,'Charapotó','pagina/img/inicio/inventario_ejemplo3.png',3,'charapoto'),(4,'San Isidro','pagina/img/inicio/inventario_ejemplo4.png',4,'san-isidro');
/*!40000 ALTER TABLE `parroquia` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_resets`
--

DROP TABLE IF EXISTS `password_resets`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_resets`
--

LOCK TABLES `password_resets` WRITE;
/*!40000 ALTER TABLE `password_resets` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_resets` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ruta`
--

DROP TABLE IF EXISTS `ruta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ruta` (
  `int` int(11) NOT NULL AUTO_INCREMENT,
  `parroquia_id` int(11) DEFAULT NULL,
  `tipo_ruta_id` int(11) DEFAULT NULL,
  `detalle` text COLLATE utf8_unicode_ci,
  `ficha` text COLLATE utf8_unicode_ci,
  `imagen` text COLLATE utf8_unicode_ci,
  `codigo_url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`int`),
  KEY `fk_ruta_parroquia_idx` (`parroquia_id`),
  KEY `fk_ruta_tiporuta_idx` (`tipo_ruta_id`),
  CONSTRAINT `fk_ruta_parroquia` FOREIGN KEY (`parroquia_id`) REFERENCES `parroquia` (`id`),
  CONSTRAINT `fk_ruta_tiporuta` FOREIGN KEY (`tipo_ruta_id`) REFERENCES `tipo_ruta` (`int`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ruta`
--

LOCK TABLES `ruta` WRITE;
/*!40000 ALTER TABLE `ruta` DISABLE KEYS */;
/*!40000 ALTER TABLE `ruta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `servicio`
--

DROP TABLE IF EXISTS `servicio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `servicio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parroquia_id` int(11) DEFAULT NULL,
  `tipo_servicio_id` int(11) DEFAULT NULL,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `direccion` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `correo` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `telefono` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `celular` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `celular_what` int(11) DEFAULT '0' COMMENT '1= SI 0=NO',
  `costo` decimal(2,0) DEFAULT NULL,
  `responsable` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `horario` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `latitud` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `longitud` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `url_web` text COLLATE utf8_unicode_ci,
  `url_fb` text COLLATE utf8_unicode_ci,
  `url_in` text COLLATE utf8_unicode_ci,
  `url_x` text COLLATE utf8_unicode_ci,
  `url_yt` text COLLATE utf8_unicode_ci,
  `texto` text COLLATE utf8_unicode_ci,
  `codigo_url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_servicio_parroquia_idx` (`parroquia_id`),
  KEY `fk_servicio_tipo_servicio_idx` (`tipo_servicio_id`),
  CONSTRAINT `fk_servicio_parroquia` FOREIGN KEY (`parroquia_id`) REFERENCES `parroquia` (`id`),
  CONSTRAINT `fk_servicio_tipo_servicio` FOREIGN KEY (`tipo_servicio_id`) REFERENCES `tipo_servicio` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=55 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `servicio`
--

LOCK TABLES `servicio` WRITE;
/*!40000 ALTER TABLE `servicio` DISABLE KEYS */;
INSERT INTO `servicio` VALUES (43,2,1,'Casa Ceibo','Bahia de caraquez','casa.ceibo@gmailcom','22555555555','0993283283',0,NULL,'Holger Vidal','24/7','-0.63985','-80.41570','https://casaceibo.com/','https://www.facebook.com/casaceibo','https://www.instagram.com/casaceibo/','https://x.com/casaceibo',NULL,NULL,'bcasab-ceibo','2024-06-11 22:02:43','2024-06-27 17:29:09',NULL),(44,1,1,'Hotel La Piedra','Avenida Virgilio Ratti 802, 131401, Bahía de Caráquez, Ecuador',NULL,'59352690780',NULL,1,NULL,NULL,NULL,'-0.5959457276513812','-80.42466685429548',NULL,'https://www.facebook.com/cialcotellapiedra/',NULL,NULL,NULL,'Hotel La Piedra es una excelente opción para tu estadía en Bahía de Caráquez. Después de refrescarse en la piscina al aire libre, los huéspedes pueden ir a comer a La Playa, que ofrece cocina internacional y abre sus puertas para el desayuno, el almuerzo y la cena.','hotel-la-piedra','2024-06-17 21:31:54','2024-08-26 18:14:52',NULL),(45,1,1,'Hostal Casa de Hospedaje','Avenida Velaso Ibarra y Calle 3 de Noviembre no 421 Esquina','casadehospedaje@hotmail.com','05269167','0986463023',0,NULL,'Marcos Davis Briones V.','24/7',NULL,NULL,'https://casadehospedaje.wixsite.com/hotelcasadehospedaje','https://www.facebook.com/profile.php?id=100081714979041&locale=es_LA','https://www.instagram.com/casadehospedaje/',NULL,NULL,NULL,'hostal-casa-de-hospedaje','2024-06-25 15:34:48','2024-06-25 17:15:59',NULL),(46,1,1,'Hostal Isabella','Ruta del sol, 131401',NULL,NULL,'0989698305',1,NULL,'Julio Garcia','24/7',NULL,NULL,NULL,'https://www.facebook.com/HostalIsabellaG/','https://www.instagram.com/hostal_isabella/',NULL,NULL,NULL,'hostal-isabella','2024-06-25 16:17:10','2024-06-25 17:16:18',NULL),(47,1,1,'Bahía Hotel','Av. Malecón 1708 y Vinueza',NULL,NULL,'0986971514',1,NULL,NULL,'24/7',NULL,NULL,NULL,NULL,'https://www.instagram.com/bahia_hotel0/',NULL,NULL,NULL,'baha-hotel','2024-06-25 17:14:09','2024-06-25 17:16:31',NULL),(48,1,1,'Hotel Bahía B&B','Av. Velasco Ibarrra y calle 1, esquina, astilleros','ecuadoradviser@gmail.com',NULL,'0939050717',1,NULL,NULL,'24/7',NULL,NULL,NULL,'https://www.facebook.com/BahiaBedAndBreakfast','https://www.instagram.com/hotel.bahiabyb/',NULL,NULL,NULL,'hotel-baha-bb','2024-06-25 17:31:47','2024-06-25 17:31:47',NULL),(49,1,1,'Buena Vista Place Hotel','Simon Bolivar 701 y Matheus','buenavistabahia@gmail.com',NULL,'0988768848',1,NULL,NULL,'24/7',NULL,NULL,'http://www.hotelbuenavistaplace.com/','https://www.facebook.com/HOTELBUENAVISTAPLACEENBAHIA?locale=es_LA','https://www.instagram.com/buenavistabahia/',NULL,NULL,NULL,'buena-vista-place-hotel','2024-06-27 15:56:53','2024-06-27 15:56:53',NULL),(50,2,1,'Hosteria Saiananda','Av Sixto Duran Ballen – Km. 6','alfredoharmsen@gmail.com',NULL,'0992374765',1,NULL,NULL,'24/7',NULL,NULL,'https://saiananda.com/','https://www.facebook.com/saiananda/?locale=es_LA','https://www.instagram.com/saiananda/',NULL,NULL,NULL,'hosteria-saiananda','2024-06-27 16:15:02','2024-06-27 16:15:02',NULL),(51,2,1,'Hostal Spondylys','Av Cesar Ruperti Dueñas entre Caran y Cayambe (Diagonal a las Antenas CNT)',NULL,NULL,'096 963 7327',1,NULL,NULL,NULL,NULL,NULL,NULL,'https://www.facebook.com/HostalSpondylus?locale=es_LA',NULL,NULL,NULL,NULL,'hostal-spondylys','2024-06-27 16:33:08','2024-06-27 16:33:08',NULL),(52,2,1,'Hostal Nelly','9HHF+H97',NULL,NULL,'0997619965',1,NULL,NULL,NULL,NULL,NULL,NULL,'https://www.facebook.com/profile.php?id=100064083187809&locale=es_LA',NULL,NULL,NULL,NULL,'hostal-nelly','2024-06-28 15:02:15','2024-06-28 15:02:15',NULL),(53,2,1,'Hostal María José','Nogales',NULL,NULL,'0995420025',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'hostal-mara-jos','2024-06-28 15:54:45','2024-06-28 15:54:45',NULL);
/*!40000 ALTER TABLE `servicio` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `servicio_imagen`
--

DROP TABLE IF EXISTS `servicio_imagen`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `servicio_imagen` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ruta` text COLLATE utf8_unicode_ci,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `detalle` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `servicio_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_servicio_imagen_servicio_idx` (`servicio_id`),
  CONSTRAINT `fk_servicio_imagen_servicio` FOREIGN KEY (`servicio_id`) REFERENCES `servicio` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `servicio_imagen`
--

LOCK TABLES `servicio_imagen` WRITE;
/*!40000 ALTER TABLE `servicio_imagen` DISABLE KEYS */;
INSERT INTO `servicio_imagen` VALUES (37,'imagenes/servicios/43/servicio-2024-06-111718143363-9rcBR7iN.webp','casa-ceibo','',43,'2024-06-11 22:02:43','2024-06-11 22:02:43',NULL),(38,'imagenes/servicios/43/servicio-2024-06-111718143363-0I7Pd8sJ.webp','casa-ceibo','',43,'2024-06-11 22:02:43','2024-06-11 22:02:43',NULL),(42,'imagenes/servicios/43/servicio-2024-06-171718659945-Gu5IRepN.jpg','casa-ceibo','',43,'2024-06-17 21:32:25','2024-06-17 21:32:25',NULL),(43,'imagenes/servicios/45/servicio-2024-06-251719330267-RAh9PwzB.jpg','hostal-casa-de-hospedaje','',45,'2024-06-25 15:44:27','2024-06-25 15:44:27',NULL),(44,'imagenes/servicios/45/servicio-2024-06-251719330572-LaZVHJQ5.png','hostal-casa-de-hospedaje','',45,'2024-06-25 15:49:32','2024-06-25 15:49:32',NULL),(45,'imagenes/servicios/46/servicio-2024-06-251719332230-5aWKtVN3.jpg','hostal-hi-isabella','',46,'2024-06-25 16:17:10','2024-06-25 16:17:10',NULL),(46,'imagenes/servicios/47/servicio-2024-06-251719335649-WEdFY7JV.png','baha-hotel','',47,'2024-06-25 17:14:09','2024-06-25 17:14:09',NULL),(48,'imagenes/servicios/44/servicio-2024-06-261719436975-zqy6nWMS.jpg','hotel-la-piedra','',44,'2024-06-26 21:22:55','2024-06-26 21:22:55',NULL),(49,'imagenes/servicios/44/servicio-2024-06-261719436975-q7TohjDn.jpg','hotel-la-piedra','',44,'2024-06-26 21:22:55','2024-06-26 21:22:55',NULL),(50,'imagenes/servicios/44/servicio-2024-06-261719436975-Jouq0Mrm.jpg','hotel-la-piedra','',44,'2024-06-26 21:22:55','2024-06-26 21:22:55',NULL),(51,'imagenes/servicios/48/servicio-2024-06-271719502593-Oj1rf0JN.jpg','hotel-baha-bb','',48,'2024-06-27 15:36:33','2024-06-27 15:36:33',NULL),(52,'imagenes/servicios/49/servicio-2024-06-271719503814-ByJCaEsg.jpg','buena-vista-place-hotel','',49,'2024-06-27 15:56:54','2024-06-27 15:56:54',NULL),(53,'imagenes/servicios/49/servicio-2024-06-271719503814-IOSlbQRs.jpg','buena-vista-place-hotel','',49,'2024-06-27 15:56:54','2024-06-27 15:56:54',NULL),(54,'imagenes/servicios/49/servicio-2024-06-271719503814-CosT65em.jpg','buena-vista-place-hotel','',49,'2024-06-27 15:56:54','2024-06-27 15:56:54',NULL),(55,'imagenes/servicios/50/servicio-2024-06-271719504902-JE7NLh2j.jpg','hosteria-saiananda','',50,'2024-06-27 16:15:02','2024-06-27 16:15:02',NULL),(56,'imagenes/servicios/50/servicio-2024-06-271719504902-q9gkMcQj.jpg','hosteria-saiananda','',50,'2024-06-27 16:15:02','2024-06-27 16:15:02',NULL),(57,'imagenes/servicios/50/servicio-2024-06-271719504902-LcY1dxJH.jpg','hosteria-saiananda','',50,'2024-06-27 16:15:02','2024-06-27 16:15:02',NULL),(58,'imagenes/servicios/51/servicio-2024-06-271719505988-HpeA7c5f.jpg','hostal-spondylys','',51,'2024-06-27 16:33:08','2024-06-27 16:33:08',NULL),(59,'imagenes/servicios/51/servicio-2024-06-271719505988-E1wT048m.jpg','hostal-spondylys','',51,'2024-06-27 16:33:08','2024-06-27 16:33:08',NULL),(60,'imagenes/servicios/52/servicio-2024-06-281719586935-fJ8jVxAD.jpg','hostal-nelly','',52,'2024-06-28 15:02:15','2024-06-28 15:02:15',NULL),(61,'imagenes/servicios/52/servicio-2024-06-281719586935-G2HSD9Jx.jpg','hostal-nelly','',52,'2024-06-28 15:02:15','2024-06-28 15:02:15',NULL),(62,'imagenes/servicios/52/servicio-2024-06-281719586935-n9tZpoe1.jpg','hostal-nelly','',52,'2024-06-28 15:02:15','2024-06-28 15:02:15',NULL),(63,'imagenes/servicios/53/servicio-2024-06-281719590438-5KklHm4c.jpg','hostal-mara-jos','',53,'2024-06-28 16:00:38','2024-06-28 16:00:38',NULL),(64,'imagenes/servicios/53/servicio-2024-06-281719590438-pJogdqIS.jpg','hostal-mara-jos','',53,'2024-06-28 16:00:38','2024-06-28 16:00:38',NULL);
/*!40000 ALTER TABLE `servicio_imagen` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `servicio_lista`
--

DROP TABLE IF EXISTS `servicio_lista`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `servicio_lista` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_lista_id` int(11) DEFAULT NULL,
  `servicio_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_servicio_lista_rela_idx` (`servicio_id`),
  KEY `fk_servicio_lista_lista_idx` (`cat_lista_id`),
  CONSTRAINT `fk_servicio_lista_lista` FOREIGN KEY (`cat_lista_id`) REFERENCES `cat_lista` (`id`),
  CONSTRAINT `fk_servicio_lista_servicio` FOREIGN KEY (`servicio_id`) REFERENCES `servicio` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `servicio_lista`
--

LOCK TABLES `servicio_lista` WRITE;
/*!40000 ALTER TABLE `servicio_lista` DISABLE KEYS */;
INSERT INTO `servicio_lista` VALUES (61,1,44),(62,2,44),(63,3,44),(64,4,44),(65,6,44),(66,7,44),(67,9,44),(68,13,44);
/*!40000 ALTER TABLE `servicio_lista` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `servicio_ofrece`
--

DROP TABLE IF EXISTS `servicio_ofrece`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `servicio_ofrece` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `icono` text COLLATE utf8_unicode_ci,
  `nombre` varchar(800) COLLATE utf8_unicode_ci DEFAULT NULL,
  `servicio_id` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL,
  `deleted_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_servicio_ofrece_servicio_idx` (`servicio_id`),
  CONSTRAINT `fk_servicio_ofrece_servicio` FOREIGN KEY (`servicio_id`) REFERENCES `servicio` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=171 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `servicio_ofrece`
--

LOCK TABLES `servicio_ofrece` WRITE;
/*!40000 ALTER TABLE `servicio_ofrece` DISABLE KEYS */;
INSERT INTO `servicio_ofrece` VALUES (125,'fas fa-wifi fa-fw','Zona Wifi',43,'2024-06-11 22:02:43','2024-06-11 22:02:43',NULL),(126,'fas fa-car-alt fa-fw','Parqueadero',43,'2024-06-11 22:02:43','2024-06-11 22:02:43',NULL),(127,'fas fa-water fa-fw','Piscinas',43,'2024-06-11 22:02:43','2024-06-11 22:02:43',NULL),(128,'fas fa-utensils fa-fw','Restaurante',43,'2024-06-11 22:02:43','2024-06-11 22:02:43',NULL),(131,'fas fa-wifi fa-fw','Wifi Gratis',45,'2024-06-25 15:34:48','2024-06-25 15:34:48',NULL),(132,'fas fa-parking fa-fw','Servicio de Parqueo',45,'2024-06-25 15:34:48','2024-06-25 15:34:48',NULL),(133,'fas fa-bed fa-fw','Habitaciones',45,'2024-06-25 15:34:48','2024-06-25 15:34:48',NULL),(134,'fas fa-video fa-fw','Vigilancia',45,'2024-06-25 15:34:48','2024-06-25 15:34:48',NULL),(135,'fas fa-wifi fa-fw','Wifi Gratis',46,'2024-06-25 16:17:10','2024-06-25 16:17:10',NULL),(136,'fas fa-swimming-pool fa-fw','Piscina',46,'2024-06-25 16:17:10','2024-06-25 16:17:10',NULL),(137,'fas fa-parking fa-fw','Estacionamiento',46,'2024-06-25 16:17:10','2024-06-25 16:17:10',NULL),(138,'fas fa-video fa-fw','Vigilancia',46,'2024-06-25 16:17:10','2024-06-25 16:17:10',NULL),(139,'fas fa-bed fa-fw','Habitaciones',46,'2024-06-25 16:17:10','2024-06-25 16:17:10',NULL),(140,'fas fa-bed fa-fw','Habitaciones',47,'2024-06-25 17:14:09','2024-06-25 17:14:09',NULL),(141,'fas fa-parking fa-fw','Estacionamiento',47,'2024-06-25 17:14:09','2024-06-25 17:14:09',NULL),(142,'fas fa-wifi fa-fw','Wifi Gratis',47,'2024-06-25 17:14:09','2024-06-25 17:14:09',NULL),(143,'fas fa-bed fa-fw','Habitaciones',48,'2024-06-25 17:31:47','2024-06-25 17:31:47',NULL),(144,'fas fa-parking fa-fw','Estacionamiento',48,'2024-06-25 17:31:47','2024-06-25 17:31:47',NULL),(145,'fas fa-wifi fa-fw','Wifi Gratis',48,'2024-06-25 17:31:47','2024-06-25 17:31:47',NULL),(146,'fas fa-tv fa-fw','Netflix',48,'2024-06-25 17:31:47','2024-06-25 17:31:47',NULL),(147,'fas fa-bed fa-fw','Habitaciones',49,'2024-06-27 15:56:53','2024-06-27 15:56:53',NULL),(148,'fas fa-wifi fa-fw','Wifi Gratis',49,'2024-06-27 15:56:53','2024-06-27 15:56:53',NULL),(149,'fas fa-air-freshener fa-fw','Aire Acondicionado',49,'2024-06-27 15:56:53','2024-06-27 15:56:53',NULL),(150,'fas fa-parking fa-fw','Estacionamiento',49,'2024-06-27 15:56:53','2024-06-27 15:56:53',NULL),(151,'fas fa-swimming-pool fa-fw','Piscina',49,'2024-06-27 15:56:53','2024-06-27 15:56:53',NULL),(152,'fas fa-parking fa-fw','Estacionamiento',50,'2024-06-27 16:15:02','2024-06-27 16:15:02',NULL),(153,'fas fa-wifi fa-fw','Wifi Gratis',50,'2024-06-27 16:15:02','2024-06-27 16:15:02',NULL),(154,'fas fa-spa fa-fw','SPA',50,'2024-06-27 16:15:02','2024-06-27 16:15:02',NULL),(155,'fas fa-hamburger fa-fw','Restaurante',50,'2024-06-27 16:15:02','2024-06-27 16:15:02',NULL),(156,'fas fa-wifi fa-fw','Wifi Gratis',51,'2024-06-27 16:33:08','2024-06-27 16:33:08',NULL),(157,'fas fa-parking fa-fw','Estacionamiento',51,'2024-06-27 16:33:08','2024-06-27 16:33:08',NULL),(158,'fas fa-tv fa-fw','TV CABLE',51,'2024-06-27 16:33:08','2024-06-27 16:33:08',NULL),(159,'fas fa-procedures fa-fw','Habitaciones',51,'2024-06-27 16:33:08','2024-06-27 16:33:08',NULL),(160,'fas fa-bed fa-fw','Habitaciones',52,'2024-06-28 15:02:15','2024-06-28 15:02:15',NULL),(161,'fas fa-wifi fa-fw','Wifi Gratis',52,'2024-06-28 15:02:15','2024-06-28 15:02:15',NULL),(162,'fas fa-air-freshener fa-fw','Aire Acondicionado',52,'2024-06-28 15:02:15','2024-06-28 15:02:15',NULL),(163,'fas fa-bed fa-fw','Habitaciones',53,'2024-06-28 16:00:38','2024-06-28 16:00:38',NULL),(164,'fas fa-air-freshener fa-fw','Aire Acondicionado',53,'2024-06-28 16:00:38','2024-06-28 16:00:38',NULL),(165,'fas fa-wifi fa-fw','Wifi Gratis',53,'2024-06-28 16:00:38','2024-06-28 16:00:38',NULL),(166,'fas fa-asterisk fa-fw','Hotel La Piedra Hotel La Piedra es una excelente opción para tu estadía en Bahía de Caráquez. Después de refrescarse en la piscina al aire libre, los huéspedes pueden ir a comer a La Playa, que ofrece cocina internacional y abre sus puertas para el desayuno, el almuerzo y la cena.',44,'2024-07-09 21:44:30','2024-07-09 21:44:30',NULL),(167,'fas fa-car-side fa-fw','Estacionamiento',44,'2024-07-09 21:48:39','2024-07-09 21:48:39',NULL),(168,'fas fa-swimmer fa-fw','Piscina',44,'2024-07-09 21:56:12','2024-07-09 21:56:12',NULL),(169,'fas fa-asterisk fa-fw','Aire acondicionado',44,'2024-07-09 22:04:38','2024-07-09 22:04:38',NULL),(170,'fas fa-utensils fa-fw','Restaurant',44,'2024-07-09 22:04:38','2024-07-09 22:04:38',NULL);
/*!40000 ALTER TABLE `servicio_ofrece` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `servicio_titulo1`
--

DROP TABLE IF EXISTS `servicio_titulo1`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `servicio_titulo1` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cat_titulo1_id` int(11) DEFAULT NULL,
  `servicio_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_servicio_titulo1_servicio_idx` (`servicio_id`),
  KEY `fk_servicio_titulo1_titulo1_idx` (`cat_titulo1_id`),
  CONSTRAINT `fk_servicio_titulo1_servicio` FOREIGN KEY (`servicio_id`) REFERENCES `servicio` (`id`),
  CONSTRAINT `fk_servicio_titulo1_titulo1` FOREIGN KEY (`cat_titulo1_id`) REFERENCES `cat_titulo1` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `servicio_titulo1`
--

LOCK TABLES `servicio_titulo1` WRITE;
/*!40000 ALTER TABLE `servicio_titulo1` DISABLE KEYS */;
INSERT INTO `servicio_titulo1` VALUES (20,2,44),(21,3,44),(22,4,44);
/*!40000 ALTER TABLE `servicio_titulo1` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tipo_foto`
--

DROP TABLE IF EXISTS `tipo_foto`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tipo_foto` (
  `int` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`int`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tipo_foto`
--

LOCK TABLES `tipo_foto` WRITE;
/*!40000 ALTER TABLE `tipo_foto` DISABLE KEYS */;
/*!40000 ALTER TABLE `tipo_foto` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tipo_ruta`
--

DROP TABLE IF EXISTS `tipo_ruta`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tipo_ruta` (
  `int` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icono` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `codigo_url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`int`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tipo_ruta`
--

LOCK TABLES `tipo_ruta` WRITE;
/*!40000 ALTER TABLE `tipo_ruta` DISABLE KEYS */;
/*!40000 ALTER TABLE `tipo_ruta` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `tipo_servicio`
--

DROP TABLE IF EXISTS `tipo_servicio`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tipo_servicio` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nombre` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `icono` text COLLATE utf8_unicode_ci,
  `codigo_url` varchar(200) COLLATE utf8_unicode_ci DEFAULT NULL,
  `tipo` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tipo_servicio`
--

LOCK TABLES `tipo_servicio` WRITE;
/*!40000 ALTER TABLE `tipo_servicio` DISABLE KEYS */;
INSERT INTO `tipo_servicio` VALUES (1,'Hotelería','pagina/img/iconos/inicio/casa.png','hoteleria',1),(2,'Alimentos y bebidas','pagina/img/iconos/inicio/menu.png','alimentos-bebidas',0),(3,'Agencia de servicios turísticos','pagina/img/iconos/inicio/agencia.png','agencia-de-servicios-turisticos',0),(4,'Centros turísticos comunitarios','pagina/img/iconos/inicio/centro_turistico.png','centros-turisticos-comunitarios',0),(5,'Transporte turístico','pagina/img/iconos/inicio/transporte.png','transporte-turistico',0);
/*!40000 ALTER TABLE `tipo_servicio` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Holger Vidal','holger.vidal@sucre.gob.ec',NULL,'$2y$10$j25.MfJuMB6.1qMYAuJA3u8OxBtTMHYEXMOm/svMsZRtOw4dGvKzG',NULL,NULL,NULL),(2,'Turismo','direccion_turismo@sucre.gob.ec',NULL,'$2y$10$NZe2.wifdHbSBUcblTd98.piuUSmk8P809GoVKlOeLt51ltuM3vJK',NULL,NULL,NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-08-26 13:28:56