--
-- Host: localhost    Database: lasalle-test
-- ------------------------------------------------------


--
-- Table structure for table `actividad`
--

CREATE TABLE `actividad` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned DEFAULT NULL,
  `id_contenido` int(10) unsigned DEFAULT NULL,
  `tipo_contenido` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `actividad_id_user_foreign` (`id_user`),
  CONSTRAINT `actividad_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `actividad`
--


--
-- Table structure for table `agenda`
--

CREATE TABLE `agenda` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_evento` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `agenda_id_evento_foreign` (`id_evento`),
  CONSTRAINT `agenda_id_evento_foreign` FOREIGN KEY (`id_evento`) REFERENCES `eventos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `agenda`
--


--
-- Table structure for table `agenda_expositor`
--

CREATE TABLE `agenda_expositor` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_item_agenda` int(10) unsigned NOT NULL,
  `id_expositor` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `agenda_expositor_id_item_agenda_foreign` (`id_item_agenda`),
  KEY `agenda_expositor_id_expositor_foreign` (`id_expositor`),
  CONSTRAINT `agenda_expositor_id_expositor_foreign` FOREIGN KEY (`id_expositor`) REFERENCES `expositor` (`id`) ON DELETE CASCADE,
  CONSTRAINT `agenda_expositor_id_item_agenda_foreign` FOREIGN KEY (`id_item_agenda`) REFERENCES `item_agenda` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `agenda_expositor`
--


--
-- Table structure for table `anuncios`
--

CREATE TABLE `anuncios` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `hora_anuncio` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_evento` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `anuncios_id_evento_foreign` (`id_evento`),
  CONSTRAINT `anuncios_id_evento_foreign` FOREIGN KEY (`id_evento`) REFERENCES `eventos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `anuncios`
--


--
-- Table structure for table `articulos_etiquetas`
--

CREATE TABLE `articulos_etiquetas` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_articulo` int(10) unsigned DEFAULT NULL,
  `id_etiqueta` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `articulos_etiquetas_id_articulo_foreign` (`id_articulo`),
  KEY `articulos_etiquetas_id_etiqueta_foreign` (`id_etiqueta`),
  CONSTRAINT `articulos_etiquetas_id_articulo_foreign` FOREIGN KEY (`id_articulo`) REFERENCES `novedades` (`id`),
  CONSTRAINT `articulos_etiquetas_id_etiqueta_foreign` FOREIGN KEY (`id_etiqueta`) REFERENCES `etiquetas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `articulos_etiquetas`
--


--
-- Table structure for table `canales_chat`
--

CREATE TABLE `canales_chat` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_usuario_prin` int(10) unsigned NOT NULL,
  `id_usuario_sec` int(10) unsigned NOT NULL,
  `aceptado` smallint(6) NOT NULL DEFAULT '0',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `read_usu_prin` tinyint(4) NOT NULL DEFAULT '1',
  `read_usu_sec` tinyint(4) NOT NULL DEFAULT '1',
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_message_date` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `id_grupo` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `canales_chat_id_usuario_prin_foreign` (`id_usuario_prin`),
  KEY `canales_chat_id_usuario_sec_foreign` (`id_usuario_sec`),
  KEY `canales_chat_id_grupo_foreign` (`id_grupo`),
  CONSTRAINT `canales_chat_id_grupo_foreign` FOREIGN KEY (`id_grupo`) REFERENCES `grupos` (`id`),
  CONSTRAINT `canales_chat_id_usuario_prin_foreign` FOREIGN KEY (`id_usuario_prin`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `canales_chat_id_usuario_sec_foreign` FOREIGN KEY (`id_usuario_sec`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `canales_chat`
--


--
-- Table structure for table `categoria_etiquetas`
--

CREATE TABLE `categoria_etiquetas` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categoria_etiquetas`
--

INSERT INTO `categoria_etiquetas` VALUES (1,'Áreas de interés',NULL,NULL,'#2c8bec'),(2,'Perfil',NULL,NULL,'#28bf9d');

--
-- Table structure for table `categoriapregunta`
--

CREATE TABLE `categoriapregunta` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tiene que haber una categoría creada con id cero, sino falla la creación de encuestas.';

--
-- Dumping data for table `categoriapregunta`
--

INSERT INTO `categoriapregunta` VALUES (0,'General',NULL,NULL,NULL);

--
-- Table structure for table `categoriapregunta_idioma`
--

CREATE TABLE `categoriapregunta_idioma` (
  `id_categoriapregunta` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL,
  `titulo` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_categoriapregunta`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categoriapregunta_idioma`
--


--
-- Table structure for table `categorias`
--

CREATE TABLE `categorias` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `categoria` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `categorias`
--

INSERT INTO `categorias` VALUES (1,'Platinum','2019-08-26 14:31:55','2020-03-07 13:18:03','2020-03-07 13:18:03'),(2,'Gold','2019-08-26 14:32:02','2020-03-07 13:17:56','2020-03-07 13:17:56'),(3,'Silver','2019-09-17 15:59:06','2020-03-07 13:17:48','2020-03-07 13:17:48'),(6,'Principal','2020-03-07 12:46:14','2020-03-07 13:17:31','2020-03-07 13:17:31'),(7,'Platino','2020-03-07 13:18:21','2020-03-07 13:18:21',NULL),(8,'STGO','2022-06-10 22:16:33','2022-06-10 22:16:33',NULL),(9,'Oro','2022-10-12 19:19:39','2022-10-12 19:19:39',NULL);

--
-- Table structure for table `colores`
--

CREATE TABLE `colores` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `codigo_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `colores`
--


--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_id` int(10) unsigned NOT NULL,
  `author_id` int(10) unsigned NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `comments_author_id_foreign` (`author_id`),
  CONSTRAINT `comments_author_id_foreign` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comments`
--


--
-- Table structure for table `empresa`
--

CREATE TABLE `empresa` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `detalle` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `empresa`
--


--
-- Table structure for table `encuesta_idioma`
--

CREATE TABLE `encuesta_idioma` (
  `id_encuesta` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL,
  `titulo` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_encuesta`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `encuesta_idioma`
--


--
-- Table structure for table `encuestas`
--

CREATE TABLE `encuestas` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `encuesta` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_evento` int(10) unsigned NOT NULL,
  `tipo` smallint(6) NOT NULL DEFAULT '2',
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `encuestas_id_evento_foreign` (`id_evento`),
  CONSTRAINT `encuestas_id_evento_foreign` FOREIGN KEY (`id_evento`) REFERENCES `eventos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `encuestas`
--


--
-- Table structure for table `etiquetas`
--

CREATE TABLE `etiquetas` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `etiqueta` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `color` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `id_category` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `etiquetas_id_category_foreign` (`id_category`),
  CONSTRAINT `etiquetas_id_category_foreign` FOREIGN KEY (`id_category`) REFERENCES `categoria_etiquetas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `etiquetas`
--


--
-- Table structure for table `eventos`
--

CREATE TABLE `eventos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `fecha_inicio` datetime DEFAULT NULL,
  `fecha_fin` datetime DEFAULT NULL,
  `lugar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion_lugar` longtext COLLATE utf8mb4_unicode_ci,
  `imagen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitud` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitud` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'evento',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `link_evento` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `link_galeria` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `publicado` smallint(6) NOT NULL DEFAULT '0',
  `link_inscripcion` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `v2` tinyint(1) NOT NULL DEFAULT '0',
  `codigo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_admin` int(10) unsigned DEFAULT NULL,
  `id_plan` int(10) unsigned DEFAULT NULL,
  `galery` tinyint(1) NOT NULL DEFAULT '0',
  `id_tipoinscripcion` int(10) unsigned NOT NULL,
  `group` tinyint(1) NOT NULL DEFAULT '0',
  `visible_users` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_joined` text COLLATE utf8mb4_unicode_ci,
  `private_link` text COLLATE utf8mb4_unicode_ci,
  `chat` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Si está en 1 permite que se visualize el chat en los eventos',
  PRIMARY KEY (`id`),
  KEY `eventos_id_admin_foreign` (`id_admin`),
  KEY `eventos_id_plan_foreign` (`id_plan`),
  CONSTRAINT `eventos_id_admin_foreign` FOREIGN KEY (`id_admin`) REFERENCES `users` (`id`),
  CONSTRAINT `eventos_id_plan_foreign` FOREIGN KEY (`id_plan`) REFERENCES `planes_evento` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `eventos`
--


--
-- Table structure for table `eventos_etiquetas`
--

CREATE TABLE `eventos_etiquetas` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_evento` int(10) unsigned DEFAULT NULL,
  `id_etiqueta` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `eventos_etiquetas_id_evento_foreign` (`id_evento`),
  KEY `eventos_etiquetas_id_etiqueta_foreign` (`id_etiqueta`),
  CONSTRAINT `eventos_etiquetas_id_etiqueta_foreign` FOREIGN KEY (`id_etiqueta`) REFERENCES `etiquetas` (`id`),
  CONSTRAINT `eventos_etiquetas_id_evento_foreign` FOREIGN KEY (`id_evento`) REFERENCES `eventos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `eventos_etiquetas`
--


--
-- Table structure for table `eventos_idioma`
--

CREATE TABLE `eventos_idioma` (
  `id_evento` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL,
  `titulo` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `lugar` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion_lugar` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_evento`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `eventos_idioma`
--


--
-- Table structure for table `excel_mail_send`
--

CREATE TABLE `excel_mail_send` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned DEFAULT NULL,
  `mail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `apellido` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `excel_mail_send_id_user_index` (`id_user`),
  CONSTRAINT `excel_mail_send_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `excel_mail_send`
--


--
-- Table structure for table `expositor`
--

CREATE TABLE `expositor` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ocupacion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `foto` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `biografia` longtext COLLATE utf8mb4_unicode_ci,
  `linkedin` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_evento` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `thumbnail` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `expositor_id_evento_foreign` (`id_evento`),
  CONSTRAINT `expositor_id_evento_foreign` FOREIGN KEY (`id_evento`) REFERENCES `eventos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expositor`
--


--
-- Table structure for table `expositor_idioma`
--

CREATE TABLE `expositor_idioma` (
  `id_expositor` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL,
  `nombre` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `ocupacion` text COLLATE utf8mb4_unicode_ci,
  `biografia` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_expositor`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `expositor_idioma`
--


--
-- Table structure for table `galeria`
--

CREATE TABLE `galeria` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tipo` int(11) NOT NULL,
  `link` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_user` int(10) unsigned NOT NULL,
  `id_evento` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `thumbnail` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `galeria_id_user_foreign` (`id_user`),
  KEY `galeria_id_evento_foreign` (`id_evento`),
  CONSTRAINT `galeria_id_evento_foreign` FOREIGN KEY (`id_evento`) REFERENCES `eventos` (`id`),
  CONSTRAINT `galeria_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `galeria`
--


--
-- Table structure for table `group_notification`
--

CREATE TABLE `group_notification` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_user` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `group_notification_id_user_foreign` (`id_user`),
  CONSTRAINT `group_notification_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `group_notification`
--


--
-- Table structure for table `grupo_articulo`
--

CREATE TABLE `grupo_articulo` (
  `id_grupo` int(10) unsigned NOT NULL,
  `id_articulo` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_grupo`,`id_articulo`),
  KEY `grupo_articulo_id_articulo_foreign` (`id_articulo`),
  CONSTRAINT `grupo_articulo_id_articulo_foreign` FOREIGN KEY (`id_articulo`) REFERENCES `novedades` (`id`),
  CONSTRAINT `grupo_articulo_id_grupo_foreign` FOREIGN KEY (`id_grupo`) REFERENCES `grupos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grupo_articulo`
--


--
-- Table structure for table `grupo_evento`
--

CREATE TABLE `grupo_evento` (
  `id_grupo` int(10) unsigned NOT NULL,
  `id_evento` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_grupo`,`id_evento`),
  KEY `grupo_evento_id_evento_foreign` (`id_evento`),
  CONSTRAINT `grupo_evento_id_evento_foreign` FOREIGN KEY (`id_evento`) REFERENCES `eventos` (`id`),
  CONSTRAINT `grupo_evento_id_grupo_foreign` FOREIGN KEY (`id_grupo`) REFERENCES `grupos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grupo_evento`
--


--
-- Table structure for table `grupo_interes`
--

CREATE TABLE `grupo_interes` (
  `id_grupo` int(10) unsigned NOT NULL,
  `id_etiqueta` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_grupo`,`id_etiqueta`),
  KEY `grupo_interes_id_etiqueta_foreign` (`id_etiqueta`),
  CONSTRAINT `grupo_interes_id_etiqueta_foreign` FOREIGN KEY (`id_etiqueta`) REFERENCES `etiquetas` (`id`),
  CONSTRAINT `grupo_interes_id_grupo_foreign` FOREIGN KEY (`id_grupo`) REFERENCES `grupos` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grupo_interes`
--


--
-- Table structure for table `grupo_miembros`
--

CREATE TABLE `grupo_miembros` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned DEFAULT NULL,
  `id_grupo` int(10) unsigned DEFAULT NULL,
  `moderador` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_tipo_autoridad` int(11) NOT NULL DEFAULT '4',
  `last_notification_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_chat_access` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `last_message_written` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `grupo_miembros_id_user_foreign` (`id_user`),
  KEY `grupo_miembros_id_grupo_foreign` (`id_grupo`),
  CONSTRAINT `grupo_miembros_id_grupo_foreign` FOREIGN KEY (`id_grupo`) REFERENCES `grupos` (`id`),
  CONSTRAINT `grupo_miembros_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grupo_miembros`
--


--
-- Table structure for table `grupo_sponsor`
--

CREATE TABLE `grupo_sponsor` (
  `id_grupo` int(10) unsigned NOT NULL,
  `id_sponsor` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_grupo`,`id_sponsor`),
  KEY `grupo_sponsor_id_sponsor_foreign` (`id_sponsor`),
  CONSTRAINT `grupo_sponsor_id_grupo_foreign` FOREIGN KEY (`id_grupo`) REFERENCES `grupos` (`id`),
  CONSTRAINT `grupo_sponsor_id_sponsor_foreign` FOREIGN KEY (`id_sponsor`) REFERENCES `sponsors` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grupo_sponsor`
--


--
-- Table structure for table `grupos`
--

CREATE TABLE `grupos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `imagen` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_admin` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_tipoinscripcion` int(10) unsigned DEFAULT NULL,
  `publicado` smallint(1) NOT NULL DEFAULT '0',
  `chat_room` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `chat` smallint(6) NOT NULL DEFAULT '0',
  `only_inscribed` smallint(6) NOT NULL DEFAULT '0',
  `valida_inscripcion` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `visible_users` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipo_grupo` int(10) unsigned DEFAULT NULL,
  `es_moderado` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Si está en 1 permite que los moderadores apueben los contenidos en los grupos',
  PRIMARY KEY (`id`),
  KEY `grupos_id_dmin_foreign` (`id_admin`),
  KEY `grupos_id_tipoinscripcion_foreign` (`id_tipoinscripcion`),
  KEY `grupos_tipo_grupo_foreign` (`tipo_grupo`),
  CONSTRAINT `grupos_id_dmin_foreign` FOREIGN KEY (`id_admin`) REFERENCES `users` (`id`),
  CONSTRAINT `grupos_id_tipoinscripcion_foreign` FOREIGN KEY (`id_tipoinscripcion`) REFERENCES `tipo_inscripcion` (`id`),
  CONSTRAINT `grupos_tipo_grupo_foreign` FOREIGN KEY (`tipo_grupo`) REFERENCES `types_groups` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grupos`
--


--
-- Table structure for table `grupos_idioma`
--

CREATE TABLE `grupos_idioma` (
  `id_grupo` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL DEFAULT '0',
  `titulo` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_grupo`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `grupos_idioma`
--


--
-- Table structure for table `hotel_idioma`
--

CREATE TABLE `hotel_idioma` (
  `id_hotel` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL,
  `titulo` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `bajada` text COLLATE utf8mb4_unicode_ci,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_hotel`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hotel_idioma`
--


--
-- Table structure for table `hoteles`
--

CREATE TABLE `hoteles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `imagen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `bajada` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `descripcion` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_evento` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `hoteles_id_evento_foreign` (`id_evento`),
  CONSTRAINT `hoteles_id_evento_foreign` FOREIGN KEY (`id_evento`) REFERENCES `eventos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `hoteles`
--


--
-- Table structure for table `idioma`
--

CREATE TABLE `idioma` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `codigo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `idioma`
--

INSERT INTO `idioma` VALUES (1,'Español','es',NULL,NULL);

--
-- Table structure for table `info_payments`
--

CREATE TABLE `info_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `detalle` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `info_payments_id_idioma_foreign` (`id_idioma`),
  CONSTRAINT `info_payments_id_idioma_foreign` FOREIGN KEY (`id_idioma`) REFERENCES `idioma` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `info_payments`
--


--
-- Table structure for table `item_agenda`
--

CREATE TABLE `item_agenda` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hora_inicio` datetime DEFAULT NULL,
  `lugar` text COLLATE utf8mb4_unicode_ci,
  `hora_fin` datetime DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_agenda` int(10) unsigned NOT NULL,
  `descripcion_item` longtext COLLATE utf8mb4_unicode_ci,
  `id_evento` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `item_agenda_id_agenda_foreign` (`id_agenda`),
  KEY `item_agenda_id_evento_foreign` (`id_evento`),
  CONSTRAINT `item_agenda_id_evento_foreign` FOREIGN KEY (`id_evento`) REFERENCES `eventos` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `item_agenda`
--


--
-- Table structure for table `itemagenda_idioma`
--

CREATE TABLE `itemagenda_idioma` (
  `id_itemagenda` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL,
  `titulo` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `lugar` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_itemagenda`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `itemagenda_idioma`
--


--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_reserved_at_index` (`queue`,`reserved_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `jobs`
--


--
-- Table structure for table `likes`
--

CREATE TABLE `likes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_id` int(10) unsigned NOT NULL,
  `author_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `likes_author_id_foreign` (`author_id`),
  CONSTRAINT `likes_author_id_foreign` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `likes`
--


--
-- Table structure for table `material`
--

CREATE TABLE `material` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` text COLLATE utf8mb4_unicode_ci,
  `contenido` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_item_agenda` int(10) unsigned NOT NULL,
  `id_tipo_material` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `material_id_item_agenda_foreign` (`id_item_agenda`),
  KEY `material_id_tipo_material_foreign` (`id_tipo_material`),
  CONSTRAINT `material_id_item_agenda_foreign` FOREIGN KEY (`id_item_agenda`) REFERENCES `item_agenda` (`id`) ON DELETE CASCADE,
  CONSTRAINT `material_id_tipo_material_foreign` FOREIGN KEY (`id_tipo_material`) REFERENCES `tipo_material` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `material`
--


--
-- Table structure for table `mediafiles`
--

CREATE TABLE `mediafiles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `file_path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_size` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `duration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `podcasts_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `mediafiles_podcasts_id_foreign` (`podcasts_id`),
  CONSTRAINT `mediafiles_podcasts_id_foreign` FOREIGN KEY (`podcasts_id`) REFERENCES `podcasts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `mediafiles`
--


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

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 AUTO_INCREMENT=195 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` VALUES (1,'2017_04_27_104823_crear_tabla_users',1),(2,'2017_04_27_113220_crear_tabla_eventos',1),(3,'2017_04_27_113322_crear_tabla_novedades',1),(4,'2017_04_27_113419_crear_tabla_agenda',1),(5,'2017_04_27_113502_crear_tabla_anuncios',1),(6,'2017_04_27_113739_crear_tabla_user_evento',1),(7,'2017_04_27_113818_crear_tabla_encuestas',1),(8,'2017_04_27_113904_crear_tabla_preguntas',1),(9,'2017_04_27_113940_crear_tabla_opciones_rta',1),(10,'2017_04_27_114023_crear_tabla_respuesta',1),(11,'2017_04_27_114057_crear_tabla_expositor',1),(12,'2017_04_27_114412_crear_tabla_tipo_material',1),(13,'2017_04_27_114506_crear_tabla_user_encuesta',1),(14,'2017_04_27_114603_crear_tabla_admins',1),(15,'2017_04_27_152958_crear_tabla_item_agenda',1),(16,'2017_04_27_153747_crear_tabla_agenda_expositores',1),(17,'2017_04_27_153951_crear_tabla_materiales',1),(18,'2017_05_01_204523_agregar_campos_tabla_novedades',1),(19,'2017_05_01_204948_agregar_campos_tabla_eventos',1),(20,'2017_05_01_205048_agregar_campos_tabla_itemAgenda',1),(21,'2017_05_02_170409_crear_tabla_user_item_agenda',1),(22,'2017_05_02_171059_agregar_campos_tabla_eventos2',1),(23,'2017_05_05_142824_agregar_campos_tabla_encuestas',1),(24,'2017_05_05_142908_agregar_campos_tabla_user',1),(25,'2017_05_06_004546_crear_tabla_users_favoritos',1),(26,'2017_05_09_035316_crear_tabla_notificaciones',1),(27,'2017_05_10_055512_actualizar_tabla_usuarios2',1),(28,'2017_05_10_055516_actualizar_tabla_usuarios3',1),(29,'2017_05_17_024022_actualizar_tabla_encuestas_evento',1),(30,'2017_05_17_025222_actualizar_tabla_preguntas1',1),(31,'2017_05_24_005303_crear_tabla_etiquetas',1),(32,'2017_05_24_005703_agregar_campo_etiquetas_tabla_user',1),(33,'2017_05_26_031747_agregar_campo_color_etiquetas',1),(34,'2017_05_26_050331_agregar_campo_fotoLinkedin_users',1),(35,'2017_05_30_223315_crear_tabla_colores',1),(36,'2017_05_31_140752_crear_tabla_hoteles',1),(37,'2017_05_31_140956_agregar_campo_hotel_eventos',1),(38,'2017_06_03_055034_crear_tabla_categorias',1),(39,'2017_06_03_055224_crear_tabla_sponsors',1),(40,'2017_06_03_104138_crear_tabla_empresa',1),(41,'2017_06_05_231337_act_tabla_canales_chat0605',1),(42,'2017_06_06_042534_agregar_campo_evento_notificaciones',1),(43,'2017_06_06_123411_act_tabla_canales_chat0606',1),(44,'2017_06_06_213313_act_tabla_canales_chat06061',1),(45,'2017_06_07_120212_update_iser_table_071617',1),(46,'2017_06_07_121400_update_iser_table_0716123',1),(47,'2017_06_09_144550_act_item_agenda_0906',1),(48,'2017_06_09_204523_agregar_campos_tabla_hotel',1),(49,'2017_06_12_173740_act_eventos_1206',1),(50,'2017_06_13_020450_act_novedad_345',1),(51,'2017_06_13_195620_update_tables_1306',1),(52,'2017_06_14_022213_update_tables_11135',1),(53,'2017_06_14_023840_update_tables_11135567',1),(54,'2017_06_14_225027_create_table_categoriapregunta',1),(55,'2017_06_15_101712_add_campo_comentario',1),(56,'2017_06_15_114906_event_publicado',1),(57,'2017_06_21_154102_campos_no_requeridos',1),(58,'2017_06_30_065904_actualizar_tabla_itemagenda',1),(59,'2017_07_10_223803_update_table_categoriapreguntas',2),(60,'2017_07_10_232340_update_table_preguntas',2),(61,'2017_07_19_212723_add_field_linkinscripcion_evento',3),(62,'2017_07_19_213658_update_field_linkinscripcion_evento',3),(63,'2017_07_27_214008_crear_tabla_paises2',4),(64,'2017_07_27_215410_campo_pais_usuarios',4),(65,'2017_07_28_165229_update_tabla_paises',4),(66,'2017_08_02_064701_create_table_useretiquetas',4),(67,'2017_08_10_221233_add_table_languages',5),(68,'2017_08_10_223159_add_table_eventos_idioma',5),(69,'2017_08_15_195354_update_field_nullables_evento-idiomas',5),(70,'2017_08_15_230705_add_table_novedad_idioma',5),(71,'2017_08_16_001042_add_table_sponsor_idioma',5),(72,'2017_08_16_011114_add_table_orador_idioma',5),(73,'2017_08_16_054141_add_table_hotel_idioma',5),(74,'2017_08_16_055539_add_table_encuesta_idioma',5),(75,'2017_08_16_063812_add_table_pregunta_idioma',5),(76,'2017_08_16_071829_add_table_categoriapregunta_idioma',5),(77,'2017_08_16_093211_add_table_itemagenda_idioma',5),(78,'2017_08_16_100520_add_field_lang_users',5),(79,'2017_08_19_085636_update_table_itemagenda_idioma',5),(80,'2017_08_19_094921_update_table_eventos',5),(81,'2017_08_19_100841_update_table_novedades',5),(82,'2017_09_18_022824_add_field_code_evento',6),(83,'2017_09_20_070410_add_admin_event',6),(84,'2017_09_29_002258_add_tabla_planes_evento',7),(85,'2017_09_29_012948_add_field_plan_evento',7),(86,'2017_10_03_042216_create_table_infoPayments',8),(87,'2017_10_09_042557_add_field_galery_event',9),(88,'2017_10_09_073731_add_table_galery',9),(89,'2017_10_16_233100_add_foto_users',9),(90,'2017_10_17_014840_add_sorteo_code_users',9),(91,'2017_10_20_080304_add_winner_users',9),(92,'2017_10_24_125704_add_thumb_galery',9),(93,'2017_10_27_102718_add_table_planes_idioma',10),(94,'2017_10_30_140948_update_planes_evento',10),(95,'2017_11_14_201459_add_thumb_expositor',11),(96,'2018_02_14_042556_login_iae',12),(97,'2018_02_20_022316_add_update_tags_user',13),(98,'2018_02_20_063048_add_interest_category',13),(99,'2018_02_20_063226_add_interest_category_relation',13),(100,'2018_02_20_070725_add_color_interest_category',13),(101,'2018_02_20_155204_add_table_eventos_etiquetas',13),(102,'2018_02_27_024119_add_table_articulos_etiquetas',14),(103,'2018_03_01_042427_add_user_last_connection',15),(104,'2018_03_01_045205_tipo_inscripcion_eventos',15),(105,'2018_03_01_053607_rename_tipo_inscripcion_eventos',16),(106,'2018_03_14_191358_estructura_para_grupos',17),(107,'2018_03_15_030100_fix_idadmin_grupo',17),(108,'2018_03_15_045924_add_group_inscription_and_create_table_group_members',17),(109,'2018_03_15_051241_add_tipo_inscription_idioma',17),(110,'2018_03_15_051648_rm_colum_texto_in_tipo_inscription',17),(111,'2018_04_04_040329_add_field_publicado_in_groups',18),(112,'2018_04_04_055951_add_table_no_asistencias',18),(113,'2018_04_04_074442_add_field_chat_room_in_groups',18),(114,'2018_04_04_103941_add_field_chat_in_group',18),(115,'2018_04_05_020528_add_field_group_in_canales_chat',19),(116,'2018_04_10_111537_add_date_novedad',20),(117,'2018_04_13_120017_add_deleted_at_grupo_sponsor',21),(118,'2018_04_27_213401_add_user_id_iae',22),(119,'2018_04_30_083201_add_only_inscribed',22),(120,'2018_05_28_130136_add_email_validate_field',23),(121,'2018_05_28_145741_add_user_validate_in_groups',23),(122,'2018_05_29_075609_add_email_send_link_field',23),(123,'2018_06_19_082126_create_jobs_table',24),(124,'2018_07_25_164122_users_points_fields',24),(125,'2018_08_29_134941_add_soft_deletes_to_user_table',25),(126,'2018_08_29_142009_chance_text_by_longtext',25),(127,'2018_09_04_061117_add_table_actividad',25),(128,'2018_10_04_104122_create_publicidades_table',26),(129,'2018_10_04_110647_create_publicidades_novedades_table',26),(130,'2019_05_06_145844_admit_null_user_mail',27),(131,'2019_07_16_130639_create_users_invitados',28),(132,'2019_07_24_070942_crear_tipo_user',29),(133,'2019_08_01_154945_create_visible_release_users_table',30),(134,'2019_08_01_174644_add_visible_rol_to_groups',31),(135,'2019_08_01_181453_add_visible_rol_to_eventos',32),(136,'2019_08_01_183515_add_visible_rol_to_novedades',33),(137,'2019_08_02_120150_delete_table_visible_releases_user',34),(138,'2019_08_02_120150_delete_table_user_invitados',35),(139,'2019_08_06_111608_set_bio_users',36),(140,'2019_08_06_112537_set_tipo_grupo_grupos',37),(141,'2019_09_11_102322_add_fecha_de_nacimento_User',37),(142,'2019_09_11_105730_create_table_UserInvitedGroupInteresent',37),(143,'2019_12_19_121457_create_table_groups_types',38),(144,'2019_12_20_111936_create_table_component_ionic_tabs_menu',38),(149,'2020_02_27_183120_create_apple_table',39),(150,'2020_02_27_183202_add_attr_to_apple_table',39),(151,'2020_02_12_101913_create_promotions_table',40),(152,'2020_02_14_105147_create_table_promo_category',40),(153,'2020_03_06_180840_update_atrib_promotions',40),(154,'2020_03_19_151100_update_promotions-atribute_form',40),(155,'2020_04_04_155248_create_comments_table',41),(156,'2020_04_07_220022_create_likes_table',42),(157,'2020_04_30_112807_create_table_config',42),(158,'2020_05_11_123227_add-atributes-iae-in-connect',42),(159,'2020_06_02_113011_change_atribute_value_string_text',42),(160,'2020_05_19_163650_add_email_joined_table_eventos',43),(161,'2020_05_26_132222_add_redirect_private_And_atributes_user_tipos',43),(162,'2020_06_02_170504_create_search_fields_table',43),(163,'2020_06_02_172434_create_tipo_autoridad_grupo_table',43),(164,'2020_06_02_172553_add_tipo_autoridad_field',43),(165,'2020_06_15_130741_softdelet_table_noasistencias',43),(166,'2020_06_23_125718_add_atribute_es_moderado_in_table_grupos',44),(167,'2020_03_19_121502_create_podcasts_table',45),(168,'2020_03_19_121609_create_mediafiles_table',45),(169,'2020_03_19_122610_create_taxonomy_table',45),(170,'2020_03_19_142303_podcasts_taxonomy_podcasts_etiqueta',45),(171,'2020_08_12_103947_add_group_chat_notification_fields',46),(172,'2021_04_08_162916_add_atribute_novedades_urls',47),(174,'2022_02_02_144716_add_user_chat_connection_status',48),(175,'2022_04_13_125146_add__modalidad__presencial_online_table_eventos',49),(176,'2022_06_16_105400_add_authorization_code',50),(177,'2021_09_22_065149_create_share_table',51),(178,'2022_05_11_142910_system_user_token_table',51),(179,'2022_12_12_143207_add_last_message_written_grupo_miembros',51),(180,'2022_12_21_150714_create_table_config_directorio_web',52),(181,'2023_01_17_170438_add_atribute_search_fields',52),(182,'2023_04_27_132133_maillist',53),(183,'2023_04_27_145455_update_maillist',53),(184,'2022_05_09_161017_group_notification',54),(185,'2023_02_22_141415_add_atribute_chat_events',54),(186,'2023_03_29_110947_salas',54),(187,'2023_03_29_112459_salas_horarios',54),(188,'2023_03_29_153436_salas_feriados',54),(189,'2023_03_29_234515_salas_user',54),(190,'2023_03_30_145845_salas_feriados_update',54),(191,'2023_03_30_174926_salas_user_update',54),(192,'2023_03_31_110908_add_idsalas_in_feriado',54),(193,'2023_04_13_211559_add_delete_salas_horarios',54),(194,'2023_05_03_115811_add_description_salas',54);

--
-- Table structure for table `noasistencias`
--

CREATE TABLE `noasistencias` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned DEFAULT NULL,
  `id_evento` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `noasistencias_id_user_foreign` (`id_user`),
  KEY `noasistencias_id_evento_foreign` (`id_evento`),
  CONSTRAINT `noasistencias_id_evento_foreign` FOREIGN KEY (`id_evento`) REFERENCES `eventos` (`id`),
  CONSTRAINT `noasistencias_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `noasistencias`
--


--
-- Table structure for table `notificaciones`
--

CREATE TABLE `notificaciones` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_evento` int(11) NOT NULL,
  `display_limit_date` datetime DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notificaciones`
--


--
-- Table structure for table `novedad_idioma`
--

CREATE TABLE `novedad_idioma` (
  `id_novedad` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL DEFAULT '1',
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `short_title` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_novedad`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `novedad_idioma`
--


--
-- Table structure for table `novedades`
--

CREATE TABLE `novedades` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `imagen` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tipo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'novedad',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `short_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `publicado` smallint(6) NOT NULL DEFAULT '0',
  `v2` tinyint(1) NOT NULL DEFAULT '0',
  `group` tinyint(1) NOT NULL DEFAULT '0',
  `fecha` date DEFAULT NULL,
  `id_user` int(11) DEFAULT NULL,
  `show_user` int(11) DEFAULT '1',
  `visible_users` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isUrl` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Si está en 1 indica que novedad es link externo',
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `metadata` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `novedades`
--


--
-- Table structure for table `opciones_rta`
--

CREATE TABLE `opciones_rta` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `opcion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_pregunta` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `opciones_rta_id_pregunta_foreign` (`id_pregunta`),
  CONSTRAINT `opciones_rta_id_pregunta_foreign` FOREIGN KEY (`id_pregunta`) REFERENCES `preguntas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `opciones_rta`
--


--
-- Table structure for table `paises`
--

CREATE TABLE `paises` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `iso` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `text` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `activo` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=241 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `paises`
--

INSERT INTO `paises` VALUES (1,'AF','Afganistán',1,NULL,NULL,NULL),(2,'AX','Islas Gland',1,NULL,NULL,NULL),(3,'AL','Albania',1,NULL,NULL,NULL),(4,'DE','Alemania',1,NULL,NULL,NULL),(5,'AD','Andorra',1,NULL,NULL,NULL),(6,'AO','Angola',1,NULL,NULL,NULL),(7,'AI','Anguilla',1,NULL,NULL,NULL),(8,'AQ','Antártida',1,NULL,NULL,NULL),(9,'AG','Antigua y Barbuda',1,NULL,NULL,NULL),(10,'AN','Antillas Holandesas',1,NULL,NULL,NULL),(11,'SA','Arabia Saudí',1,NULL,NULL,NULL),(12,'DZ','Argelia',1,NULL,NULL,NULL),(13,'AR','Argentina',1,NULL,NULL,NULL),(14,'AM','Armenia',1,NULL,NULL,NULL),(15,'AW','Aruba',1,NULL,NULL,NULL),(16,'AU','Australia',1,NULL,NULL,NULL),(17,'AT','Austria',1,NULL,NULL,NULL),(18,'AZ','Azerbaiyán',1,NULL,NULL,NULL),(19,'BS','Bahamas',1,NULL,NULL,NULL),(20,'BH','Bahréin',1,NULL,NULL,NULL),(21,'BD','Bangladesh',1,NULL,NULL,NULL),(22,'BB','Barbados',1,NULL,NULL,NULL),(23,'BY','Bielorrusia',1,NULL,NULL,NULL),(24,'BE','Bélgica',1,NULL,NULL,NULL),(25,'BZ','Belice',1,NULL,NULL,NULL),(26,'BJ','Benin',1,NULL,NULL,NULL),(27,'BM','Bermudas',1,NULL,NULL,NULL),(28,'BT','Bhután',1,NULL,NULL,NULL),(29,'BO','Bolivia',1,NULL,NULL,NULL),(30,'BA','Bosnia y Herzegovina',1,NULL,NULL,NULL),(31,'BW','Botsuana',1,NULL,NULL,NULL),(32,'BV','Isla Bouvet',1,NULL,NULL,NULL),(33,'BR','Brasil',1,NULL,NULL,NULL),(34,'BN','Brunéi',1,NULL,NULL,NULL),(35,'BG','Bulgaria',1,NULL,NULL,NULL),(36,'BF','Burkina Faso',1,NULL,NULL,NULL),(37,'BI','Burundi',1,NULL,NULL,NULL),(38,'CV','Cabo Verde',1,NULL,NULL,NULL),(39,'KY','Islas Caimán',1,NULL,NULL,NULL),(40,'KH','Camboya',1,NULL,NULL,NULL),(41,'CM','Camerún',1,NULL,NULL,NULL),(42,'CA','Canadá',1,NULL,NULL,NULL),(43,'CF','República Centroafricana',1,NULL,NULL,NULL),(44,'TD','Chad',1,NULL,NULL,NULL),(45,'CZ','República Checa',1,NULL,NULL,NULL),(46,'CL','Chile',1,NULL,NULL,NULL),(47,'CN','China',1,NULL,NULL,NULL),(48,'CY','Chipre',1,NULL,NULL,NULL),(49,'CX','Isla de Navidad',1,NULL,NULL,NULL),(50,'VA','Ciudad del Vaticano',1,NULL,NULL,NULL),(51,'CC','Islas Cocos',1,NULL,NULL,NULL),(52,'CO','Colombia',1,NULL,NULL,NULL),(53,'KM','Comoras',1,NULL,NULL,NULL),(54,'CD','República Democrática del Congo',1,NULL,NULL,NULL),(55,'CG','Congo',1,NULL,NULL,NULL),(56,'CK','Islas Cook',1,NULL,NULL,NULL),(57,'KP','Corea del Norte',1,NULL,NULL,NULL),(58,'KR','Corea del Sur',1,NULL,NULL,NULL),(59,'CI','Costa de Marfil',1,NULL,NULL,NULL),(60,'CR','Costa Rica',1,NULL,NULL,NULL),(61,'HR','Croacia',1,NULL,NULL,NULL),(62,'CU','Cuba',1,NULL,NULL,NULL),(63,'DK','Dinamarca',1,NULL,NULL,NULL),(64,'DM','Dominica',1,NULL,NULL,NULL),(65,'DO','República Dominicana',1,NULL,NULL,NULL),(66,'EC','Ecuador',1,NULL,NULL,NULL),(67,'EG','Egipto',1,NULL,NULL,NULL),(68,'SV','El Salvador',1,NULL,NULL,NULL),(69,'AE','Emiratos Árabes Unidos',1,NULL,NULL,NULL),(70,'ER','Eritrea',1,NULL,NULL,NULL),(71,'SK','Eslovaquia',1,NULL,NULL,NULL),(72,'SI','Eslovenia',1,NULL,NULL,NULL),(73,'ES','España',1,NULL,NULL,NULL),(74,'UM','Islas ultramarinas de Estados Unidos',1,NULL,NULL,NULL),(75,'US','Estados Unidos',1,NULL,NULL,NULL),(76,'EE','Estonia',1,NULL,NULL,NULL),(77,'ET','Etiopía',1,NULL,NULL,NULL),(78,'FO','Islas Feroe',1,NULL,NULL,NULL),(79,'PH','Filipinas',1,NULL,NULL,NULL),(80,'FI','Finlandia',1,NULL,NULL,NULL),(81,'FJ','Fiyi',1,NULL,NULL,NULL),(82,'FR','Francia',1,NULL,NULL,NULL),(83,'GA','Gabón',1,NULL,NULL,NULL),(84,'GM','Gambia',1,NULL,NULL,NULL),(85,'GE','Georgia',1,NULL,NULL,NULL),(86,'GS','Islas Georgias del Sur y Sandwich del Sur',1,NULL,NULL,NULL),(87,'GH','Ghana',1,NULL,NULL,NULL),(88,'GI','Gibraltar',1,NULL,NULL,NULL),(89,'GD','Granada',1,NULL,NULL,NULL),(90,'GR','Grecia',1,NULL,NULL,NULL),(91,'GL','Groenlandia',1,NULL,NULL,NULL),(92,'GP','Guadalupe',1,NULL,NULL,NULL),(93,'GU','Guam',1,NULL,NULL,NULL),(94,'GT','Guatemala',1,NULL,NULL,NULL),(95,'GF','Guayana Francesa',1,NULL,NULL,NULL),(96,'GN','Guinea',1,NULL,NULL,NULL),(97,'GQ','Guinea Ecuatorial',1,NULL,NULL,NULL),(98,'GW','Guinea-Bissau',1,NULL,NULL,NULL),(99,'GY','Guyana',1,NULL,NULL,NULL),(100,'HT','Haití',1,NULL,NULL,NULL),(101,'HM','Islas Heard y McDonald',1,NULL,NULL,NULL),(102,'HN','Honduras',1,NULL,NULL,NULL),(103,'HK','Hong Kong',1,NULL,NULL,NULL),(104,'HU','Hungría',1,NULL,NULL,NULL),(105,'IN','India',1,NULL,NULL,NULL),(106,'ID','Indonesia',1,NULL,NULL,NULL),(107,'IR','Irán',1,NULL,NULL,NULL),(108,'IQ','Iraq',1,NULL,NULL,NULL),(109,'IE','Irlanda',1,NULL,NULL,NULL),(110,'IS','Islandia',1,NULL,NULL,NULL),(111,'IL','Israel',1,NULL,NULL,NULL),(112,'IT','Italia',1,NULL,NULL,NULL),(113,'JM','Jamaica',1,NULL,NULL,NULL),(114,'JP','Japón',1,NULL,NULL,NULL),(115,'JO','Jordania',1,NULL,NULL,NULL),(116,'KZ','Kazajstán',1,NULL,NULL,NULL),(117,'KE','Kenia',1,NULL,NULL,NULL),(118,'KG','Kirguistán',1,NULL,NULL,NULL),(119,'KI','Kiribati',1,NULL,NULL,NULL),(120,'KW','Kuwait',1,NULL,NULL,NULL),(121,'LA','Laos',1,NULL,NULL,NULL),(122,'LS','Lesotho',1,NULL,NULL,NULL),(123,'LV','Letonia',1,NULL,NULL,NULL),(124,'LB','Líbano',1,NULL,NULL,NULL),(125,'LR','Liberia',1,NULL,NULL,NULL),(126,'LY','Libia',1,NULL,NULL,NULL),(127,'LI','Liechtenstein',1,NULL,NULL,NULL),(128,'LT','Lituania',1,NULL,NULL,NULL),(129,'LU','Luxemburgo',1,NULL,NULL,NULL),(130,'MO','Macao',1,NULL,NULL,NULL),(131,'MK','ARY Macedonia',1,NULL,NULL,NULL),(132,'MG','Madagascar',1,NULL,NULL,NULL),(133,'MY','Malasia',1,NULL,NULL,NULL),(134,'MW','Malawi',1,NULL,NULL,NULL),(135,'MV','Maldivas',1,NULL,NULL,NULL),(136,'ML','Malí',1,NULL,NULL,NULL),(137,'MT','Malta',1,NULL,NULL,NULL),(138,'FK','Islas Malvinas',1,NULL,NULL,NULL),(139,'MP','Islas Marianas del Norte',1,NULL,NULL,NULL),(140,'MA','Marruecos',1,NULL,NULL,NULL),(141,'MH','Islas Marshall',1,NULL,NULL,NULL),(142,'MQ','Martinica',1,NULL,NULL,NULL),(143,'MU','Mauricio',1,NULL,NULL,NULL),(144,'MR','Mauritania',1,NULL,NULL,NULL),(145,'YT','Mayotte',1,NULL,NULL,NULL),(146,'MX','México',1,NULL,NULL,NULL),(147,'FM','Micronesia',1,NULL,NULL,NULL),(148,'MD','Moldavia',1,NULL,NULL,NULL),(149,'MC','Mónaco',1,NULL,NULL,NULL),(150,'MN','Mongolia',1,NULL,NULL,NULL),(151,'MS','Montserrat',1,NULL,NULL,NULL),(152,'MZ','Mozambique',1,NULL,NULL,NULL),(153,'MM','Myanmar',1,NULL,NULL,NULL),(154,'NA','Namibia',1,NULL,NULL,NULL),(155,'NR','Nauru',1,NULL,NULL,NULL),(156,'NP','Nepal',1,NULL,NULL,NULL),(157,'NI','Nicaragua',1,NULL,NULL,NULL),(158,'NE','Níger',1,NULL,NULL,NULL),(159,'NG','Nigeria',1,NULL,NULL,NULL),(160,'NU','Niue',1,NULL,NULL,NULL),(161,'NF','Isla Norfolk',1,NULL,NULL,NULL),(162,'NO','Noruega',1,NULL,NULL,NULL),(163,'NC','Nueva Caledonia',1,NULL,NULL,NULL),(164,'NZ','Nueva Zelanda',1,NULL,NULL,NULL),(165,'OM','Omán',1,NULL,NULL,NULL),(166,'NL','Países Bajos',1,NULL,NULL,NULL),(167,'PK','Pakistán',1,NULL,NULL,NULL),(168,'PW','Palau',1,NULL,NULL,NULL),(169,'PS','Palestina',1,NULL,NULL,NULL),(170,'PA','Panamá',1,NULL,NULL,NULL),(171,'PG','Papúa Nueva Guinea',1,NULL,NULL,NULL),(172,'PY','Paraguay',1,NULL,NULL,NULL),(173,'PE','Perú',1,NULL,NULL,NULL),(174,'PN','Islas Pitcairn',1,NULL,NULL,NULL),(175,'PF','Polinesia Francesa',1,NULL,NULL,NULL),(176,'PL','Polonia',1,NULL,NULL,NULL),(177,'PT','Portugal',1,NULL,NULL,NULL),(178,'PR','Puerto Rico',1,NULL,NULL,NULL),(179,'QA','Qatar',1,NULL,NULL,NULL),(180,'GB','Reino Unido',1,NULL,NULL,NULL),(181,'RE','Reunión',1,NULL,NULL,NULL),(182,'RW','Ruanda',1,NULL,NULL,NULL),(183,'RO','Rumania',1,NULL,NULL,NULL),(184,'RU','Rusia',1,NULL,NULL,NULL),(185,'EH','Sahara Occidental',1,NULL,NULL,NULL),(186,'SB','Islas Salomón',1,NULL,NULL,NULL),(187,'WS','Samoa',1,NULL,NULL,NULL),(188,'AS','Samoa Americana',1,NULL,NULL,NULL),(189,'KN','San Cristóbal y Nevis',1,NULL,NULL,NULL),(190,'SM','San Marino',1,NULL,NULL,NULL),(191,'PM','San Pedro y Miquelón',1,NULL,NULL,NULL),(192,'VC','San Vicente y las Granadinas',1,NULL,NULL,NULL),(193,'SH','Santa Helena',1,NULL,NULL,NULL),(194,'LC','Santa Lucía',1,NULL,NULL,NULL),(195,'ST','Santo Tomé y Príncipe',1,NULL,NULL,NULL),(196,'SN','Senegal',1,NULL,NULL,NULL),(197,'CS','Serbia y Montenegro',1,NULL,NULL,NULL),(198,'SC','Seychelles',1,NULL,NULL,NULL),(199,'SL','Sierra Leona',1,NULL,NULL,NULL),(200,'SG','Singapur',1,NULL,NULL,NULL),(201,'SY','Siria',1,NULL,NULL,NULL),(202,'SO','Somalia',1,NULL,NULL,NULL),(203,'LK','Sri Lanka',1,NULL,NULL,NULL),(204,'SZ','Suazilandia',1,NULL,NULL,NULL),(205,'ZA','Sudáfrica',1,NULL,NULL,NULL),(206,'SD','Sudán',1,NULL,NULL,NULL),(207,'SE','Suecia',1,NULL,NULL,NULL),(208,'CH','Suiza',1,NULL,NULL,NULL),(209,'SR','Surinam',1,NULL,NULL,NULL),(210,'SJ','Svalbard y Jan Mayen',1,NULL,NULL,NULL),(211,'TH','Tailandia',1,NULL,NULL,NULL),(212,'TW','Taiwán',1,NULL,NULL,NULL),(213,'TZ','Tanzania',1,NULL,NULL,NULL),(214,'TJ','Tayikistán',1,NULL,NULL,NULL),(215,'IO','Territorio Británico del Océano Índico',1,NULL,NULL,NULL),(216,'TF','Territorios Australes Franceses',1,NULL,NULL,NULL),(217,'TL','Timor Oriental',1,NULL,NULL,NULL),(218,'TG','Togo',1,NULL,NULL,NULL),(219,'TK','Tokelau',1,NULL,NULL,NULL),(220,'TO','Tonga',1,NULL,NULL,NULL),(221,'TT','Trinidad y Tobago',1,NULL,NULL,NULL),(222,'TN','Túnez',1,NULL,NULL,NULL),(223,'TC','Islas Turcas y Caicos',1,NULL,NULL,NULL),(224,'TM','Turkmenistán',1,NULL,NULL,NULL),(225,'TR','Turquía',1,NULL,NULL,NULL),(226,'TV','Tuvalu',1,NULL,NULL,NULL),(227,'UA','Ucrania',1,NULL,NULL,NULL),(228,'UG','Uganda',1,NULL,NULL,NULL),(229,'UY','Uruguay',1,NULL,NULL,NULL),(230,'UZ','Uzbekistán',1,NULL,NULL,NULL),(231,'VU','Vanuatu',1,NULL,NULL,NULL),(232,'VE','Venezuela',1,NULL,NULL,NULL),(233,'VN','Vietnam',1,NULL,NULL,NULL),(234,'VG','Islas Vírgenes Británicas',1,NULL,NULL,NULL),(235,'VI','Islas Vírgenes de los Estados Unidos',1,NULL,NULL,NULL),(236,'WF','Wallis y Futuna',1,NULL,NULL,NULL),(237,'YE','Yemen',1,NULL,NULL,NULL),(238,'DJ','Yibuti',1,NULL,NULL,NULL),(239,'ZM','Zambia',1,NULL,NULL,NULL),(240,'ZW','Zimbabue',1,NULL,NULL,NULL);

--
-- Table structure for table `planes_evento`
--

CREATE TABLE `planes_evento` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `precio` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `planes_evento`
--


--
-- Table structure for table `planes_idioma`
--

CREATE TABLE `planes_idioma` (
  `id_plan` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL,
  `nombre` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_plan`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `planes_idioma`
--


--
-- Table structure for table `podcasts`
--

CREATE TABLE `podcasts` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `audio_author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `short_description` longtext COLLATE utf8mb4_unicode_ci,
  `fecha_publicacion` date NOT NULL,
  `publicado` tinyint(1) NOT NULL DEFAULT '0',
  `show_author` tinyint(1) NOT NULL DEFAULT '0',
  `author_id` int(10) unsigned NOT NULL,
  `visibility_rols` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `podcasts_author_id_foreign` (`author_id`),
  CONSTRAINT `podcasts_author_id_foreign` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `podcasts`
--


--
-- Table structure for table `podcasts_etiqueta`
--

CREATE TABLE `podcasts_etiqueta` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `podcasts_id` int(10) unsigned DEFAULT NULL,
  `etiquetas_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `podcasts_etiqueta_podcasts_id_foreign` (`podcasts_id`),
  KEY `podcasts_etiqueta_etiquetas_id_foreign` (`etiquetas_id`),
  CONSTRAINT `podcasts_etiqueta_etiquetas_id_foreign` FOREIGN KEY (`etiquetas_id`) REFERENCES `etiquetas` (`id`),
  CONSTRAINT `podcasts_etiqueta_podcasts_id_foreign` FOREIGN KEY (`podcasts_id`) REFERENCES `podcasts` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `podcasts_etiqueta`
--


--
-- Table structure for table `podcasts_idioma`
--

CREATE TABLE `podcasts_idioma` (
  `titulo` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` text COLLATE utf8mb4_unicode_ci,
  `audio_author` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `short_description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `podcasts_id` int(10) unsigned NOT NULL,
  `idioma_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`podcasts_id`,`idioma_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `podcasts_idioma`
--


--
-- Table structure for table `podcasts_taxonomy`
--

CREATE TABLE `podcasts_taxonomy` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `podcasts_id` int(10) unsigned DEFAULT NULL,
  `taxonomy_id` int(10) unsigned DEFAULT NULL,
  `featured` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `podcasts_taxonomy_podcasts_id_foreign` (`podcasts_id`),
  KEY `podcasts_taxonomy_taxonomy_id_foreign` (`taxonomy_id`),
  CONSTRAINT `podcasts_taxonomy_podcasts_id_foreign` FOREIGN KEY (`podcasts_id`) REFERENCES `podcasts` (`id`),
  CONSTRAINT `podcasts_taxonomy_taxonomy_id_foreign` FOREIGN KEY (`taxonomy_id`) REFERENCES `taxonomy` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `podcasts_taxonomy`
--


--
-- Table structure for table `pregunta_idioma`
--

CREATE TABLE `pregunta_idioma` (
  `id_pregunta` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL,
  `titulo` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_pregunta`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pregunta_idioma`
--


--
-- Table structure for table `preguntas`
--

CREATE TABLE `preguntas` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `texto` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categoria` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_encuesta` int(10) unsigned NOT NULL,
  `orden` int(11) NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `id_categoria` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `preguntas_id_encuesta_foreign` (`id_encuesta`),
  KEY `preguntas_id_categoria_foreign` (`id_categoria`),
  CONSTRAINT `preguntas_id_categoria_foreign` FOREIGN KEY (`id_categoria`) REFERENCES `categoriapregunta` (`id`),
  CONSTRAINT `preguntas_id_encuesta_foreign` FOREIGN KEY (`id_encuesta`) REFERENCES `encuestas` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `preguntas`
--


--
-- Table structure for table `promo_category`
--

CREATE TABLE `promo_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `visible` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promo_category`
--


--
-- Table structure for table `promo_relation_category`
--

CREATE TABLE `promo_relation_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `promotion` int(10) unsigned DEFAULT NULL,
  `category` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `promo_relation_category_promotion_foreign` (`promotion`),
  KEY `promo_relation_category_category_foreign` (`category`),
  CONSTRAINT `promo_relation_category_category_foreign` FOREIGN KEY (`category`) REFERENCES `promo_category` (`id`),
  CONSTRAINT `promo_relation_category_promotion_foreign` FOREIGN KEY (`promotion`) REFERENCES `promotions` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promo_relation_category`
--


--
-- Table structure for table `promotion_etiqueta`
--

CREATE TABLE `promotion_etiqueta` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `promotion` int(10) unsigned DEFAULT NULL,
  `etiqueta` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `promotion_etiqueta_promotion_foreign` (`promotion`),
  KEY `promotion_etiqueta_etiqueta_foreign` (`etiqueta`),
  CONSTRAINT `promotion_etiqueta_etiqueta_foreign` FOREIGN KEY (`etiqueta`) REFERENCES `etiquetas` (`id`),
  CONSTRAINT `promotion_etiqueta_promotion_foreign` FOREIGN KEY (`promotion`) REFERENCES `promotions` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promotion_etiqueta`
--


--
-- Table structure for table `promotions`
--

CREATE TABLE `promotions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `business` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `benefited_rol` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from` datetime DEFAULT NULL,
  `until` datetime DEFAULT NULL,
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `all` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promotions`
--


--
-- Table structure for table `publicidades`
--

CREATE TABLE `publicidades` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `fecha_inicio` date NOT NULL,
  `fecha_fin` date DEFAULT NULL,
  `posicion` int(11) DEFAULT NULL,
  `imagen` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `articulos_todos` int(11) NOT NULL DEFAULT '0',
  `link` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `publicidades`
--


--
-- Table structure for table `publicidades_novedades`
--

CREATE TABLE `publicidades_novedades` (
  `id_publicidad` int(10) unsigned NOT NULL,
  `id_novedad` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `publicidades_novedades`
--


--
-- Table structure for table `respuesta`
--

CREATE TABLE `respuesta` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_opcion` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_user` int(10) unsigned NOT NULL,
  `id_pregunta` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `comentario` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `respuesta_id_user_foreign` (`id_user`),
  KEY `respuesta_id_pregunta_foreign` (`id_pregunta`),
  CONSTRAINT `respuesta_id_pregunta_foreign` FOREIGN KEY (`id_pregunta`) REFERENCES `preguntas` (`id`) ON DELETE CASCADE,
  CONSTRAINT `respuesta_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `respuesta`
--


--
-- Table structure for table `salas`
--

CREATE TABLE `salas` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ubicacion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `publicado` tinyint(1) NOT NULL,
  `id_user` int(10) unsigned NOT NULL,
  `foto` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `capacidad_maxima` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `descripcion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `salas_id_user_foreign` (`id_user`),
  CONSTRAINT `salas_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salas`
--


--
-- Table structure for table `salas_feriados`
--

CREATE TABLE `salas_feriados` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_sala` int(10) unsigned DEFAULT NULL,
  `fecha` date NOT NULL,
  `fecha_fin` date DEFAULT NULL,
  `temporal` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `salas_feriados_id_sala_foreign` (`id_sala`),
  CONSTRAINT `salas_feriados_id_sala_foreign` FOREIGN KEY (`id_sala`) REFERENCES `salas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salas_feriados`
--


--
-- Table structure for table `salas_horarios`
--

CREATE TABLE `salas_horarios` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_sala` int(10) unsigned NOT NULL,
  `from` time NOT NULL,
  `to` time NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `salas_horarios_id_sala_foreign` (`id_sala`),
  CONSTRAINT `salas_horarios_id_sala_foreign` FOREIGN KEY (`id_sala`) REFERENCES `salas` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salas_horarios`
--


--
-- Table structure for table `salas_user`
--

CREATE TABLE `salas_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned NOT NULL,
  `id_sala` int(10) unsigned NOT NULL,
  `id_horario` int(10) unsigned NOT NULL,
  `fecha` date NOT NULL,
  `status` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `salas_user_id_user_foreign` (`id_user`),
  KEY `salas_user_id_sala_foreign` (`id_sala`),
  KEY `salas_user_id_horario_foreign` (`id_horario`),
  CONSTRAINT `salas_user_id_horario_foreign` FOREIGN KEY (`id_horario`) REFERENCES `salas_horarios` (`id`),
  CONSTRAINT `salas_user_id_sala_foreign` FOREIGN KEY (`id_sala`) REFERENCES `salas` (`id`),
  CONSTRAINT `salas_user_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `salas_user`
--


--
-- Table structure for table `search_fields`
--

CREATE TABLE `search_fields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `field_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `home_field` tinyint(1) NOT NULL DEFAULT '0',
  `nav_field` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `search_fields`
--


--
-- Table structure for table `shared`
--

CREATE TABLE `shared` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content_id` int(10) unsigned NOT NULL,
  `author_id` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shared_author_id_index` (`author_id`),
  CONSTRAINT `shared_author_id_foreign` FOREIGN KEY (`author_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shared`
--

INSERT INTO `shared` VALUES (1,'EVENTOS',3,1,'2023-04-15 01:12:28','2023-04-15 01:12:28',NULL),(2,'NOVEDADES',5,2,'2023-04-18 12:46:35','2023-04-18 12:46:35',NULL),(3,'NOVEDADES',5,2,'2023-04-18 12:46:39','2023-04-18 12:46:39',NULL),(4,'PODCASTS',2,2,'2023-04-18 17:52:49','2023-04-18 17:52:49',NULL),(5,'PODCASTS',2,1812,'2023-04-18 17:53:57','2023-04-18 17:53:57',NULL),(6,'PODCASTS',2,2,'2023-04-18 17:58:52','2023-04-18 17:58:52',NULL),(7,'NOVEDADES',10,1811,'2023-04-19 20:43:43','2023-04-19 20:43:43',NULL),(8,'PODCASTS',7,2,'2023-04-20 19:19:36','2023-04-20 19:19:36',NULL),(9,'EVENTOS',5,2,'2023-04-24 18:27:15','2023-04-24 18:27:15',NULL),(10,'EVENTOS',5,2,'2023-04-24 18:27:54','2023-04-24 18:27:54',NULL),(11,'GRUPOS',10,2,'2023-04-24 18:33:23','2023-04-24 18:33:23',NULL),(12,'GRUPOS',10,1812,'2023-08-31 03:02:57','2023-08-31 03:02:57',NULL);

--
-- Table structure for table `sponsor_idioma`
--

CREATE TABLE `sponsor_idioma` (
  `id_sponsor` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL,
  `titulo` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `link` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_sponsor`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sponsor_idioma`
--


--
-- Table structure for table `sponsors`
--

CREATE TABLE `sponsors` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `titulo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descripcion` longtext COLLATE utf8mb4_unicode_ci,
  `link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_categoria` int(11) NOT NULL,
  `id_evento` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sponsors`
--


--
-- Table structure for table `tabs_menu`
--

CREATE TABLE `tabs_menu` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `translate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `component` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_group_art` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tabs` tinyint(1) NOT NULL DEFAULT '0',
  `index` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tabs_menu`
--

INSERT INTO `tabs_menu` VALUES (1,'home','MAIN','ios-home','HomePage','0',1,1),(2,'eventos','EVENTS','ios-calendar','EventosPage','0',1,2),(3,'grupos','GROUPS','ios-people','ListaGruposPage','0',1,3),(4,'menu','MENU','ios-menu','MenuPage','0',1,4),(5,'articulos','MENU-ARTICULO','arrow-forward','VistaMenuPage','0',0,1),(6,'podcasts','PODCASTS','arrow-forward','PodcastsListPage','0',0,2);

--
-- Table structure for table `taxonomy`
--

CREATE TABLE `taxonomy` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `idioma_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `taxonomy`
--

INSERT INTO `taxonomy` VALUES (1,'Conferencia','conferencia',1,NULL,NULL),(2,'Clase online','clase-online',1,NULL,NULL),(3,'Filosofía','filosofia',1,NULL,NULL),(4,'Economía','economia',1,NULL,NULL),(5,'Educación','educacion',1,NULL,NULL),(6,'Empresa','empresa',1,NULL,NULL),(7,'Investigación','investigacion',1,NULL,NULL),(8,'Ciencia','ciencia',1,NULL,NULL),(9,'Tecnología','tecnologia',1,NULL,NULL),(10,'Salud','salud',1,NULL,NULL),(11,'Política','politica',1,NULL,NULL),(13,'Musica Clasica','musica-clasica',1,'2023-04-19 23:02:40','2023-04-19 23:02:40'),(26,'Piano','piano',1,'2023-04-20 13:18:26','2023-04-20 13:18:26'),(27,'Arpa','arpa',1,'2023-04-20 13:20:05','2023-04-20 13:20:05'),(28,'Zoologico','zoologico',1,'2023-04-20 13:28:37','2023-04-20 13:28:37'),(29,'Cuatro y Maracas','cuatro-y-maracas',1,'2023-04-20 13:28:56','2023-04-20 13:28:56'),(30,'Amor','amor',1,'2023-04-20 13:29:17','2023-04-20 13:29:17'),(31,'Rock','rock',1,'2023-04-20 17:55:45','2023-04-20 17:55:45'),(32,'Tonos','tonos',1,'2023-04-20 17:57:20','2023-04-20 17:57:20'),(33,'Hila','hila',1,'2023-04-20 19:33:49','2023-04-20 19:33:49');

--
-- Table structure for table `tipo_autoridad_grupo`
--

CREATE TABLE `tipo_autoridad_grupo` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tipo_autoridad` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tipo_autoridad_grupo`
--

INSERT INTO `tipo_autoridad_grupo` VALUES (1,'Presidente'),(2,'Vicepresidente'),(3,'Secretario/a'),(4,'Miembro');

--
-- Table structure for table `tipo_inscripcion`
--

CREATE TABLE `tipo_inscripcion` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tipo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tipo_inscripcion`
--

INSERT INTO `tipo_inscripcion` VALUES (1,'1',NULL,NULL),(2,'1',NULL,NULL),(4,'2',NULL,NULL),(5,'2',NULL,NULL),(6,'3',NULL,NULL),(7,'3',NULL,NULL);

--
-- Table structure for table `tipo_inscripcion_idioma`
--

CREATE TABLE `tipo_inscripcion_idioma` (
  `id_tipoinscripcion` int(10) unsigned NOT NULL,
  `id_idioma` int(10) unsigned NOT NULL,
  `nombre` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id_tipoinscripcion`,`id_idioma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tipo_inscripcion_idioma`
--

INSERT INTO `tipo_inscripcion_idioma` VALUES (1,1,'Público',NULL,NULL),(2,1,'Privado',NULL,NULL),(4,1,'Abierto a miembros del grupo',NULL,NULL),(5,1,'Anotación Manual',NULL,NULL),(6,1,'Abierto',NULL,NULL),(7,1,'Cerrado',NULL,NULL);

--
-- Table structure for table `tipo_material`
--

CREATE TABLE `tipo_material` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `tipo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tipo_material`
--

INSERT INTO `tipo_material` VALUES (1,'link',NULL,NULL,NULL),(2,'pdf',NULL,NULL,NULL);

--
-- Table structure for table `types_groups`
--

CREATE TABLE `types_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `translate` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `featured` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `types_groups`
--

INSERT INTO `types_groups` VALUES (0,'Ninguno','Sin clasificar',0),(3,'Grupos de Interes','MENU-INTERES',0),(4,'Programas','MENU-PROGRAMS',1);

--
-- Table structure for table `user_encuesta`
--

CREATE TABLE `user_encuesta` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_user` int(10) unsigned NOT NULL,
  `id_encuesta` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_encuesta_id_user_foreign` (`id_user`),
  KEY `user_encuesta_id_encuesta_foreign` (`id_encuesta`),
  CONSTRAINT `user_encuesta_id_encuesta_foreign` FOREIGN KEY (`id_encuesta`) REFERENCES `encuestas` (`id`),
  CONSTRAINT `user_encuesta_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_encuesta`
--


--
-- Table structure for table `user_etiquetas`
--

CREATE TABLE `user_etiquetas` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `id_user` int(10) unsigned DEFAULT NULL,
  `id_etiqueta` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_etiquetas_id_user_foreign` (`id_user`),
  KEY `user_etiquetas_id_etiqueta_foreign` (`id_etiqueta`),
  CONSTRAINT `user_etiquetas_id_etiqueta_foreign` FOREIGN KEY (`id_etiqueta`) REFERENCES `etiquetas` (`id`),
  CONSTRAINT `user_etiquetas_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_etiquetas`
--


--
-- Table structure for table `user_evento`
--

CREATE TABLE `user_evento` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `hotel` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `restricciones` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT '',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_user` int(10) unsigned NOT NULL,
  `id_evento` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_evento_id_evento_foreign` (`id_evento`),
  KEY `user_evento_id_user_foreign` (`id_user`),
  CONSTRAINT `user_evento_id_evento_foreign` FOREIGN KEY (`id_evento`) REFERENCES `eventos` (`id`),
  CONSTRAINT `user_evento_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_evento`
--


--
-- Table structure for table `user_item_agenda`
--

CREATE TABLE `user_item_agenda` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `favorito` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `id_item_agenda` int(10) unsigned NOT NULL,
  `id_user` int(10) unsigned NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_item_agenda_id_item_agenda_foreign` (`id_item_agenda`),
  KEY `user_item_agenda_id_user_foreign` (`id_user`),
  CONSTRAINT `user_item_agenda_id_item_agenda_foreign` FOREIGN KEY (`id_item_agenda`) REFERENCES `item_agenda` (`id`),
  CONSTRAINT `user_item_agenda_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_item_agenda`
--


--
-- Table structure for table `user_tipos`
--

CREATE TABLE `user_tipos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `descripcion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `visible` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `show` tinyint(1) DEFAULT NULL COMMENT 'Si está en 1 muestra el tipo en el perfil, si está en cero no lo muestra',
  `comment` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_tipos`
--

INSERT INTO `user_tipos` VALUES (1,'Alumno',1,'2019-07-24 13:27:16',NULL,NULL,NULL),(2,'Alumni',1,'2019-07-24 13:27:38',NULL,NULL,NULL),(3,'Alumni Senior',0,'2019-07-24 13:27:58',NULL,NULL,NULL),(4,'Profesor',1,'2019-07-31 14:22:25',NULL,NULL,NULL),(5,'Invitado',1,'2019-07-31 14:23:03',NULL,NULL,NULL),(6,'Anonimo',0,'2020-09-16 12:48:49',NULL,NULL,NULL),(7,'Connect Content',0,NULL,NULL,NULL,NULL),(8,'System',0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `users_email`
--

CREATE TABLE `users_email` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_user` int(10) unsigned NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `send_last_link` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `users_email_id_user_foreign` (`id_user`),
  KEY `email` (`email`),
  CONSTRAINT `users_email_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users_email`
--


--
-- Table structure for table `users_favoritos`
--

CREATE TABLE `users_favoritos` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(11) NOT NULL,
  `id_user_favorito` int(11) NOT NULL,
  `favorito` smallint(6) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users_favoritos`
--


--
-- Table structure for table `users_invited_group_int`
--

CREATE TABLE `users_invited_group_int` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `id_user` int(10) unsigned DEFAULT NULL,
  `id_grupo` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `users_invited_group_int_id_user_foreign` (`id_user`),
  KEY `users_invited_group_int_id_grupo_foreign` (`id_grupo`),
  CONSTRAINT `users_invited_group_int_id_grupo_foreign` FOREIGN KEY (`id_grupo`) REFERENCES `grupos` (`id`),
  CONSTRAINT `users_invited_group_int_id_user_foreign` FOREIGN KEY (`id_user`) REFERENCES `users` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users_invited_group_int`
--



