-- phpMyAdmin SQL Dump
-- version 4.9.7
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 08-12-2022 a las 15:46:26
-- Versión del servidor: 5.6.51-cll-lve
-- Versión de PHP: 7.4.30

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de datos: `vultur-ar`
--

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(12, '2019_08_18_150802_modelo', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `modelos`
--

CREATE TABLE `modelos` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `target` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('mp4','gif','360-image','360-video','fbx') COLLATE utf8mb4_unicode_ci NOT NULL,
  `private` tinyint(1) DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `activo` tinyint(1) DEFAULT '1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `modelos`
--

INSERT INTO `modelos` (`id`, `name`, `target`, `model`, `type`, `private`, `created_at`, `updated_at`, `activo`) VALUES
('1_policia', 'Policia', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/1_policia.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/1_policia.mp4', 'mp4', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('2_espoli', 'Espoli', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/2_espoli.png', 'https://uawa.s3-sa-east-1.amazonaws.com/models/2_espoli.mp4', 'mp4', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('3_rosaGuadalupe', 'Rosa Guadalupe', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/3_rosaGuadalupe.png', 'https://uawa.s3-sa-east-1.amazonaws.com/models/3_rosaguadalupe.mp4', 'mp4', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('4_arthur', 'Arthur', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/4_arthur.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/4_arthur.gif', 'gif', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('5_joker', 'Joker', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/5_joker.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/5_joker.gif', 'fbx', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('uio_1_catedral', 'Catedral', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/uio_1_catedral.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/uio_1_catedral.jpg', '360-image', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('uio_2_san_francisco', 'San Francisco', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/uio_2_san_francisco.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/uio_2_san_francisco.jpg', '360-image', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('uio_3_basilica', 'Basilica', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/uio_3_basilica.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/uio_3_basilica.jpg', '360-image', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('uio_4_san_agustin', 'San Agustin', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/uio_4_san_agustin.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/uio_4_san_agustin.jpg', '360-image', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('uio_5_carmen_bajo', 'Carmen Bajo', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/uio_5_carmen_bajo.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/uio_5_carmen_bajo.jpg', '360-image', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('uio_6_estadio', 'Estadio', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/uio_6_estadio.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/uio_6_estadio.jpg', '360-image', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('uio_7_panecillo', 'Panecillo', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/uio_7_panecillo.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/uio_7_panecillo.jpg', '360-image', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('uio_8_mitad_mundo', 'Mitad del Mundo', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/uio_8_mitad_mundo.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/uio_8_mitad_mundo.jpg', '360-image', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('uio_9_san_blas', 'San Blas', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/uio_9_san_blas.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/uio_9_san_blas.jpg', '360-image', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('navidad_2020', 'Navidad', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/navidad_2020.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/navidad_2020.mp4', 'mp4', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('ademic', 'Ademic', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/ademic.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/ademic.mp4', 'mp4', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('navidad_don_bosco', 'Navidad Don Bosco', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/navidad_don_bosco.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/navidad_don_bosco.mp4', 'mp4', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('nacional_uawa', 'Nacional', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/nacional_uawa.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/nacional_uawa.mp4', 'mp4', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('presentacion_antimanchas', 'Anti-Manchas', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/presentacion_antimanchas.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/presentacion_antimanchas.mp4', 'mp4', 1, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('presentacion_ar', 'AR', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/presentacion_ar.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/presentacion_ar.mp4', 'mp4', 1, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('presentacion_color', 'Color', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/presentacion_color.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/presentacion_color.mp4', 'mp4', 1, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('presentacion_proteccionuv', 'Proteccion UV', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/presentacion_proteccionuv.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/presentacion_proteccionuv.mp4', 'mp4', 1, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('presentacion_secado', 'Secado', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/presentacion_secado.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/presentacion_secado.mp4', 'mp4', 1, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('gema', 'Gema', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/gema.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/gema.mp4', 'mp4', 0, '2021-01-06 03:50:19', '2021-01-06 03:50:19', 1),
('virgen2021', 'Virgen 2021', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/virgen2021.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/virgen2021.jpg', '360-image', 0, '2021-10-27 03:50:19', '2021-10-27 03:50:19', 1),
('quitotazas', 'Quito Tazas', 'https://uawa.s3-sa-east-1.amazonaws.com/targets/quitotazas.jpg', 'https://uawa.s3-sa-east-1.amazonaws.com/models/quitotazas.mp4', 'mp4', 0, '2022-06-02 03:50:19', '2022-06-02 03:50:19', 1);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `registros`
--

CREATE TABLE `registros` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `ip` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `modelo` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `visualizaciones` bigint(20) UNSIGNED DEFAULT '1',
  `fecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `continente` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pais` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provincia` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ciudad` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `codigoPostal` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitud` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `longitud` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `registros`
--

INSERT INTO `registros` (`id`, `ip`, `modelo`, `visualizaciones`, `fecha`, `continente`, `pais`, `provincia`, `ciudad`, `codigoPostal`, `latitud`, `longitud`) VALUES
(45, '157.100.88.0', 'uio_5_carmen_bajo', 1, '2020-12-01 09:06:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(44, '157.100.88.0', 'uio_3_basilica', 1, '2020-12-01 09:05:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(43, '157.100.88.0', 'uio_2_san_francisco', 1, '2020-12-01 09:04:49', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(42, '157.100.88.0', 'uio_1_catedral', 1, '2020-12-01 08:51:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(41, '190.63.1.81', 'uio_2_san_francisco', 1, '2020-12-01 03:40:46', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(40, '181.113.99.161', 'uio_7_panecillo', 1, '2020-11-30 09:44:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(39, '190.11.0.121', '1_policia', 1, '2020-11-30 08:56:36', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(38, '157.100.87.168', 'uio_9_san_blas', 1, '2020-11-29 22:08:45', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(37, '190.63.119.19', 'uio_7_panecillo', 1, '2020-11-29 06:05:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(36, '190.63.119.80', 'uio_3_basilica', 1, '2020-11-29 00:52:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(35, '190.111.82.101', 'uio_2_san_francisco', 1, '2020-11-29 00:12:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(34, '190.111.82.101', 'uio_3_basilica', 1, '2020-11-29 00:01:30', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(33, '181.196.72.57', 'ademic', 1, '2020-11-27 06:13:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(32, '200.7.247.201', 'uio_2_san_francisco', 1, '2020-11-27 02:18:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(31, '200.7.247.201', 'uio_5_carmen_bajo', 1, '2020-11-27 02:15:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(30, '157.100.88.0', '2_espoli', 1, '2020-11-26 09:51:09', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(29, '157.100.88.0', '3_rosaGuadalupe', 1, '2020-11-26 09:35:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(28, '157.100.88.0', 'uio_9_san_blas', 1, '2020-11-26 09:08:33', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(27, '157.100.88.0', 'uio_8_mitad_mundo', 1, '2020-11-26 09:06:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(26, '157.100.88.0', 'uio_6_estadio', 1, '2020-11-26 09:05:58', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(25, '157.100.88.0', 'uio_5_carmen_bajo', 1, '2020-11-26 09:05:42', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(24, '157.100.88.0', 'uio_4_san_agustin', 1, '2020-11-26 09:05:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(23, '157.100.88.0', 'uio_3_basilica', 1, '2020-11-26 09:05:06', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(22, '157.100.88.0', 'uio_2_san_francisco', 1, '2020-11-26 09:04:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(21, '157.100.88.0', 'uio_1_catedral', 1, '2020-11-26 09:04:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(20, '157.100.88.0', 'navidad_2020', 1, '2020-11-26 09:03:11', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(19, '192.188.58.15', 'uio_8_mitad_mundo', 1, '2020-11-26 04:24:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, '192.188.58.15', 'ademic', 1, '2020-11-26 04:23:09', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(17, '190.111.82.128', 'ademic', 1, '2020-11-25 08:14:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, '186.46.200.7', 'uio_4_san_agustin', 1, '2020-11-25 04:21:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, '190.63.1.155', 'ademic', 1, '2020-11-24 23:44:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, '192.188.58.14', 'ademic', 1, '2020-11-24 19:56:15', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, '190.63.1.46', 'uio_7_panecillo', 1, '2020-11-24 19:43:40', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, '181.199.60.11', 'ademic', 2, '2020-11-24 09:30:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, '200.63.105.146', 'ademic', 1, '2020-11-24 08:44:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, '192.188.58.15', 'ademic', 1, '2020-11-24 02:10:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, '181.199.61.192', 'ademic', 2, '2020-11-24 00:32:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, '192.188.58.14', 'ademic', 1, '2020-11-23 20:46:13', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, '192.188.58.14', '1_policia', 1, '2020-11-23 19:09:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, '190.63.235.73', 'ademic', 1, '2020-11-23 20:43:53', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, '181.199.60.128', '1_policia', 1, '2020-11-23 09:03:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, '181.199.61.192', '1_policia', 1, '2020-11-23 11:17:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, '95.127.157.67', 'ademic', 1, '2020-11-23 07:39:59', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(1, '79.148.61.104', '1_policia', 1, '2020-11-23 07:29:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, '79.148.61.104', 'navidad_2020', 1, '2020-11-23 07:34:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(46, '157.100.88.0', 'uio_6_estadio', 1, '2020-12-01 09:06:23', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(47, '157.100.88.0', 'uio_7_panecillo', 2, '2020-12-01 09:06:37', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(48, '186.46.204.25', 'uio_2_san_francisco', 1, '2020-12-02 01:04:05', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(49, '200.7.246.151', 'uio_9_san_blas', 1, '2020-12-02 02:17:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(50, '200.7.246.151', 'uio_1_catedral', 1, '2020-12-02 02:18:38', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(56, '88.11.72.250', '1_policia', 2, '2020-12-02 00:39:27', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(57, '186.46.207.39', 'uio_2_san_francisco', 1, '2020-12-02 01:43:21', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(58, '190.63.1.114', 'uio_2_san_francisco', 1, '2020-12-02 01:45:43', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(59, '190.63.1.114', 'uio_9_san_blas', 1, '2020-12-02 01:46:36', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(60, '190.63.1.114', 'uio_1_catedral', 1, '2020-12-02 01:47:30', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(61, '190.63.1.114', 'uio_4_san_agustin', 1, '2020-12-02 01:48:18', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(62, '157.100.88.0', 'uio_9_san_blas', 3, '2020-12-02 01:59:09', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(63, '190.63.150.152', 'ademic', 1, '2020-12-02 15:16:15', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(64, '181.39.184.86', 'uio_3_basilica', 1, '2020-12-03 14:24:47', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(65, '181.113.66.138', 'uio_5_carmen_bajo', 1, '2020-12-04 01:24:37', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(66, '157.100.89.110', 'uio_5_carmen_bajo', 1, '2020-12-05 02:17:33', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(67, '157.100.91.0', 'uio_8_mitad_mundo', 1, '2020-12-05 03:57:29', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(68, '109.232.66.195', '4_arthur', 1, '2020-12-07 19:57:08', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(69, '109.232.66.195', 'navidad_2020', 1, '2020-12-07 20:00:28', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(70, '181.199.83.202', '1_policia', 1, '2020-12-09 23:47:09', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(71, '181.199.83.202', 'uio_8_mitad_mundo', 1, '2020-12-09 23:49:19', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(72, '200.7.247.125', 'ademic', 1, '2020-12-10 03:07:44', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(73, '200.7.247.71', 'ademic', 1, '2020-12-10 14:18:31', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(74, '192.188.58.10', 'ademic', 1, '2020-12-10 14:21:30', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(75, '157.100.88.0', 'presentacion_ar', 2, '2020-12-11 04:00:15', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(76, '157.100.88.0', 'presentacion_color', 2, '2020-12-11 04:01:50', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(77, '157.100.88.0', 'presentacion_secado', 2, '2020-12-11 04:02:04', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(78, '157.100.88.0', 'presentacion_antimanchas', 1, '2020-12-11 04:03:14', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(79, '157.100.88.0', 'presentacion_proteccionuv', 1, '2020-12-11 04:03:17', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(80, '200.7.246.48', 'uio_6_estadio', 1, '2020-12-14 14:43:27', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(81, '190.63.1.185', '1_policia', 1, '2020-12-14 17:39:08', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(82, '190.63.235.2', '1_policia', 1, '2020-12-14 17:44:44', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(83, '157.100.89.203', '1_policia', 1, '2020-12-15 01:53:01', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(84, '190.57.150.82', 'uio_9_san_blas', 1, '2020-12-16 21:18:02', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(85, '157.100.87.60', 'uio_7_panecillo', 1, '2020-12-18 01:17:29', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(86, '157.100.87.60', '1_policia', 1, '2020-12-18 01:24:42', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(87, '88.11.72.26', 'navidad_don_bosco', 2, '2020-12-19 00:59:06', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(88, '157.100.87.60', 'navidad_don_bosco', 1, '2020-12-20 14:12:05', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(89, '201.183.164.68', 'navidad_don_bosco', 1, '2020-12-20 22:09:10', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(90, '157.100.87.60', 'navidad_don_bosco', 1, '2020-12-21 22:50:03', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(91, '157.100.87.35', 'navidad_don_bosco', 1, '2020-12-21 23:24:20', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(92, '200.7.246.186', 'navidad_don_bosco', 1, '2020-12-22 17:58:36', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(93, '191.99.138.252', 'navidad_don_bosco', 1, '2020-12-22 18:07:22', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(94, '179.49.52.56', 'navidad_don_bosco', 1, '2020-12-22 18:21:38', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(95, '157.100.91.49', 'navidad_don_bosco', 3, '2020-12-22 18:22:19', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(96, '191.99.117.212', 'navidad_don_bosco', 1, '2020-12-22 18:22:24', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(97, '191.99.103.131', 'navidad_don_bosco', 1, '2020-12-22 18:22:27', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(98, '157.100.89.202', 'navidad_don_bosco', 1, '2020-12-22 18:23:39', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(99, '157.100.88.176', 'navidad_don_bosco', 1, '2020-12-22 18:24:29', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(100, '191.99.141.89', 'navidad_don_bosco', 1, '2020-12-22 18:24:57', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(101, '186.69.113.55', 'navidad_don_bosco', 1, '2020-12-22 18:25:11', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(102, '45.236.105.106', 'navidad_don_bosco', 3, '2020-12-22 18:25:21', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(103, '157.100.87.76', 'navidad_don_bosco', 1, '2020-12-22 18:25:28', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(104, '190.63.115.8', 'navidad_don_bosco', 1, '2020-12-22 18:25:39', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(105, '190.63.119.34', 'navidad_don_bosco', 1, '2020-12-22 18:25:57', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(106, '157.100.87.55', 'navidad_don_bosco', 1, '2020-12-22 18:27:07', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(107, '186.46.205.250', 'navidad_don_bosco', 1, '2020-12-22 18:28:36', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(108, '186.71.241.255', 'navidad_don_bosco', 1, '2020-12-22 18:28:53', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(109, '186.101.161.6', 'navidad_don_bosco', 1, '2020-12-22 18:30:59', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(110, '157.100.87.35', 'navidad_don_bosco', 1, '2020-12-22 18:49:12', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(111, '190.11.1.159', 'navidad_don_bosco', 1, '2020-12-22 19:39:36', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(112, '186.4.196.150', 'uio_7_panecillo', 1, '2020-12-22 20:14:02', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(113, '181.113.99.113', 'navidad_don_bosco', 1, '2020-12-23 01:36:47', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(114, '190.152.81.18', 'navidad_don_bosco', 1, '2020-12-23 01:50:49', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(115, '190.111.82.110', 'uio_6_estadio', 1, '2020-12-25 04:02:44', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(116, '190.111.82.110', 'uio_5_carmen_bajo', 1, '2020-12-25 04:04:23', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(117, '157.100.89.203', '1_policia', 1, '2020-12-25 17:20:51', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(118, '200.7.246.58', 'uio_2_san_francisco', 1, '2020-12-30 19:07:40', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(119, '201.183.164.9', 'uio_8_mitad_mundo', 1, '2020-12-31 00:47:35', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(120, '191.99.138.252', 'navidad_don_bosco', 1, '2020-12-31 01:01:08', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(121, '100.100.100.20', 'uio_9_san_blas', 1, '2021-01-02 15:45:27', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(122, '100.100.100.20', 'uio_1_catedral', 1, '2021-01-02 15:48:57', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(123, '88.11.72.26', 'nacional_uawa', 1, '2021-01-05 21:04:41', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(124, '190.63.254.97', '1_policia', 1, '2021-01-05 22:15:37', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(125, '200.7.247.75', 'uio_6_estadio', 1, '2021-01-14 17:07:20', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(126, '157.100.89.189', 'uio_8_mitad_mundo', 1, '2021-01-16 16:38:58', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(127, '157.100.89.189', 'uio_1_catedral', 1, '2021-01-16 16:41:30', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(128, '157.100.89.189', '1_policia', 1, '2021-01-16 16:57:31', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(129, '190.11.7.225', 'uio_8_mitad_mundo', 1, '2021-01-17 00:59:14', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(130, '190.111.82.144', '1_policia', 1, '2021-01-17 18:41:41', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(131, '193.152.127.103', 'navidad_don_bosco', 1, '2021-01-21 22:26:50', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(132, '193.152.127.103', 'nacional_uawa', 1, '2021-01-21 22:26:58', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(133, '190.111.93.144', 'nacional_uawa', 1, '2021-01-22 02:40:32', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(134, '190.63.235.168', '2_espoli', 1, '2021-01-24 02:10:54', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(135, '190.63.1.12', '1_policia', 1, '2021-01-27 13:23:48', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(136, '190.63.1.12', 'presentacion_secado', 1, '2021-01-27 20:23:30', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(137, '190.63.1.12', 'presentacion_antimanchas', 1, '2021-01-27 20:24:04', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(138, '190.11.3.67', '1_policia', 1, '2021-01-31 19:38:32', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(139, '200.7.246.107', '2_espoli', 1, '2021-02-20 19:21:49', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(140, '200.7.246.107', '1_policia', 1, '2021-02-20 19:22:39', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(141, '200.7.246.107', 'nacional_uawa', 1, '2021-02-20 19:24:23', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(142, '200.125.228.109', '1_policia', 1, '2021-02-28 20:59:44', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(143, '200.125.228.109', '2_espoli', 1, '2021-02-28 21:01:25', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(144, '200.7.246.159', '1_policia', 1, '2021-03-08 22:03:36', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(145, '190.63.112.93', 'presentacion_proteccionuv', 1, '2021-03-24 00:22:20', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(146, '190.63.112.93', 'presentacion_ar', 1, '2021-03-24 00:22:39', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(147, '157.100.174.164', '1_policia', 1, '2021-03-24 16:25:06', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(148, '200.7.246.57', '1_policia', 1, '2021-03-26 14:41:19', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(149, '200.7.246.213', 'uio_9_san_blas', 1, '2021-04-20 17:19:32', 'Europa', 'España', 'Balears', 'Cala Lliteres', '07599', '39.71870040893555', '3.4630000591278076'),
(150, '81.38.143.121', 'gema', 1, '2021-04-29 02:49:08', 'Europa', 'España', 'Balears', 'Cala Guya', '07599', '39.71879959106445', '3.4588000774383545'),
(151, '190.63.235.156', 'gema', 1, '2021-04-29 13:46:24', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(152, '190.63.240.154', '1_policia', 1, '2021-05-01 15:04:57', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(153, '190.63.238.237', '1_policia', 1, '2021-05-01 15:07:27', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(154, '181.39.169.210', 'uio_8_mitad_mundo', 1, '2021-05-07 15:45:56', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(155, '181.188.200.241', '1_policia', 1, '2021-05-13 12:59:55', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(156, '190.63.254.125', '1_policia', 1, '2021-05-16 14:55:59', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(157, '190.63.254.125', 'gema', 1, '2021-05-16 14:59:43', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(158, '190.63.240.199', '1_policia', 1, '2021-05-16 15:12:15', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(159, '190.63.240.199', 'gema', 1, '2021-05-16 15:12:48', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(160, '190.63.240.199', 'ademic', 1, '2021-05-16 15:16:56', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(161, '200.7.247.162', 'gema', 1, '2021-05-16 15:39:44', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(162, '200.125.249.248', 'gema', 1, '2021-05-16 16:02:43', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(163, '190.63.240.199', 'nacional_uawa', 1, '2021-05-16 16:04:25', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(164, '190.12.11.159', 'gema', 1, '2021-05-16 20:31:14', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(165, '190.63.113.9', 'gema', 1, '2021-05-25 01:27:10', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(166, '190.63.1.212', 'nacional_uawa', 1, '2021-05-31 21:19:01', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(167, '190.63.150.100', 'gema', 1, '2021-06-02 16:31:43', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(168, '200.85.83.180', 'gema', 1, '2021-06-03 22:08:01', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(169, '190.63.1.250', 'uio_2_san_francisco', 1, '2021-06-06 21:39:21', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(170, '190.63.150.66', 'uio_1_catedral', 1, '2021-06-07 02:18:13', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(171, '190.63.150.66', 'uio_3_basilica', 1, '2021-06-07 02:19:23', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(172, '190.63.150.66', 'uio_7_panecillo', 1, '2021-06-07 17:46:39', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(173, '190.63.150.66', 'uio_8_mitad_mundo', 1, '2021-06-07 17:47:35', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(174, '190.63.1.182', 'nacional_uawa', 1, '2021-06-10 15:36:26', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(175, '190.63.237.186', '1_policia', 1, '2021-06-11 14:38:35', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(176, '190.63.1.52', 'gema', 1, '2021-06-17 21:41:22', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(177, '190.63.1.52', '1_policia', 1, '2021-06-17 21:42:56', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(178, '200.85.83.142', 'gema', 1, '2021-06-18 02:34:09', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(179, '157.100.172.147', 'uio_8_mitad_mundo', 2, '2021-06-18 18:22:18', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(180, '157.100.172.147', 'uio_7_panecillo', 1, '2021-06-18 18:30:55', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(181, '190.63.150.234', 'nacional_uawa', 1, '2021-06-19 20:39:03', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(182, '190.63.1.130', '3_rosaGuadalupe', 1, '2021-06-21 11:57:10', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(183, '157.100.174.247', 'nacional_uawa', 1, '2021-06-21 16:00:34', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(184, '200.7.223.104', 'nacional_uawa', 2, '2021-06-21 16:59:59', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(185, '181.39.213.17', 'nacional_uawa', 2, '2021-06-25 23:28:13', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.30000001192092896', '-78.48332977294922'),
(186, '190.63.1.218', 'gema', 1, '2021-07-01 00:33:26', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(187, '200.7.246.8', 'uio_7_panecillo', 1, '2021-07-02 21:23:06', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(188, '179.49.61.105', 'uio_8_mitad_mundo', 1, '2021-07-03 03:33:46', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(189, '181.113.97.243', 'uio_7_panecillo', 1, '2021-07-07 17:45:34', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(190, '181.175.243.24', 'uio_7_panecillo', 1, '2021-07-08 17:40:11', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(191, '181.175.243.24', 'uio_7_panecillo', 1, '2021-07-09 17:03:22', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(192, '190.63.1.150', 'ademic', 1, '2021-07-21 00:52:53', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(193, '190.63.1.150', 'gema', 1, '2021-07-21 15:47:20', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(194, '45.183.143.109', '1_policia', 1, '2021-07-24 17:47:02', 'Sudamerica', 'Ecuador', NULL, NULL, NULL, '-2', '-77.30000305175781'),
(195, '181.112.164.186', '1_policia', 1, '2021-07-24 18:48:50', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(196, '190.63.235.64', '1_policia', 1, '2021-07-25 01:27:02', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(197, '190.63.1.176', 'gema', 1, '2021-07-25 01:30:19', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(198, '190.63.1.176', '1_policia', 1, '2021-07-25 01:31:19', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(199, '181.112.222.139', 'gema', 1, '2021-07-26 18:21:00', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(200, '181.112.222.139', 'gema', 2, '2021-07-28 14:09:29', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(201, '200.7.247.18', 'nacional_uawa', 1, '2021-07-29 22:24:01', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(202, '190.63.240.53', 'ademic', 1, '2021-08-17 22:25:08', 'Sudamerica', 'Ecuador', 'Provincia de Guayas', 'Guayaquil', NULL, '-2.194999933242798', '-79.9000015258789'),
(203, '157.100.174.146', '1_policia', 2, '2021-08-19 02:09:23', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(204, '190.152.81.148', 'nacional_uawa', 1, '2021-08-27 02:13:57', 'Sudamerica', 'Ecuador', 'Provincia de Pichincha', 'Quito', NULL, '-0.2231999933719635', '-78.51270294189453'),
(205, '45.71.255.23', '1_policia', 3, '2021-08-31 22:35:46', 'Sudamerica', 'Ecuador', 'Provincia de El Oro', 'Piñas', NULL, '-3.68149995803833', '-79.68199920654297'),
(206, '45.71.255.23', 'gema', 1, '2021-08-31 22:37:49', 'Sudamerica', 'Ecuador', 'Provincia de El Oro', 'Piñas', NULL, '-3.68149995803833', '-79.68199920654297'),
(207, '186.178.45.104', '1_policia', 1, '2021-09-07 16:36:56', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(208, '186.178.45.104', 'gema', 1, '2021-09-07 16:40:46', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(209, '200.24.150.88', '1_policia', 1, '2021-09-07 21:22:47', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(210, '200.24.150.88', '1_policia', 1, '2021-09-09 01:12:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(211, '190.63.235.245', 'nacional_uawa', 1, '2021-09-15 14:49:46', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(212, '190.63.235.245', 'uio_7_panecillo', 1, '2021-09-15 16:29:25', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(213, '179.49.52.242', 'nacional_uawa', 1, '2021-09-16 13:22:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(214, '190.63.235.245', 'presentacion_secado', 1, '2021-09-16 17:39:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(215, '190.63.235.245', 'presentacion_ar', 1, '2021-09-16 17:39:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(216, '200.7.247.203', 'uio_7_panecillo', 1, '2021-09-25 17:35:52', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(217, '190.155.196.209', 'nacional_uawa', 1, '2021-09-28 17:19:14', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(218, '190.52.194.165', '1_policia', 1, '2021-10-06 03:13:31', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(219, '186.46.223.130', 'gema', 1, '2021-10-08 14:05:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(220, '190.63.150.115', 'gema', 1, '2021-10-08 14:18:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(221, '200.7.246.140', 'uio_7_panecillo', 1, '2021-10-22 21:48:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(222, '193.152.126.237', 'navidad_don_bosco', 1, '2021-10-26 16:23:36', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(223, '193.152.126.237', '4_arthur', 1, '2021-10-26 16:23:51', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(224, '193.152.126.237', 'nacional_uawa', 1, '2021-10-26 16:24:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(225, '193.152.126.237', 'uio_1_catedral', 1, '2021-10-26 16:49:07', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(226, '83.42.190.255', 'virgen2021', 1, '2021-10-26 16:55:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(227, '193.152.126.237', 'virgen2021', 1, '2021-10-26 17:00:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(228, '181.188.201.27', 'gema', 1, '2021-10-29 17:20:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(229, '181.188.200.183', 'gema', 1, '2021-11-04 19:03:43', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(230, '45.173.230.111', 'gema', 1, '2021-11-04 19:07:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(231, '190.63.115.56', '1_policia', 1, '2021-11-06 14:14:22', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(232, '190.63.115.56', 'uio_6_estadio', 1, '2021-11-06 14:16:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(233, '157.100.174.43', 'ademic', 1, '2021-12-08 20:52:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(234, '200.7.247.151', 'virgen2021', 1, '2021-12-30 20:13:44', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(235, '157.100.91.250', '2_espoli', 1, '2022-01-02 23:47:21', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(236, '157.100.172.105', 'nacional_uawa', 1, '2022-01-08 02:02:26', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(237, '190.63.113.189', 'gema', 1, '2022-01-19 12:45:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(238, '190.63.113.189', '2_espoli', 1, '2022-01-19 12:50:54', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(239, '200.105.247.247', '1_policia', 1, '2022-01-20 18:31:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(240, '181.39.169.199', '1_policia', 1, '2022-02-27 17:05:04', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(241, '190.63.119.12', 'uio_7_panecillo', 1, '2022-03-23 01:32:50', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(242, '88.28.27.156', '1_policia', 1, '2022-04-22 21:41:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(243, '157.100.174.63', 'virgen2021', 1, '2022-05-24 03:43:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(244, '181.113.99.131', 'uio_4_san_agustin', 1, '2022-05-28 16:56:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(245, '157.100.174.63', '2_espoli', 1, '2022-05-28 20:55:48', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(246, '157.100.174.63', '1_policia', 1, '2022-05-28 20:56:02', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(247, '95.127.35.73', 'quitotazas', 1, '2022-05-31 23:42:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(248, '141.170.212.234', 'virgen2021', 3, '2022-06-14 23:08:24', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(249, '141.170.212.234', 'quitotazas', 3, '2022-06-14 23:23:03', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(250, '141.170.212.234', '1_policia', 1, '2022-06-14 23:34:34', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(251, '88.28.24.64', 'quitotazas', 1, '2022-06-15 00:07:57', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(252, '190.63.121.34', 'uio_8_mitad_mundo', 1, '2022-08-03 13:35:19', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(253, '190.63.121.34', 'uio_7_panecillo', 1, '2022-08-03 13:36:35', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(254, '157.100.174.63', 'uio_9_san_blas', 1, '2022-09-14 15:34:55', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(255, '157.100.174.63', 'uio_1_catedral', 1, '2022-09-14 15:42:01', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(256, '157.100.174.63', 'uio_5_carmen_bajo', 1, '2022-09-14 15:45:41', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(257, '157.100.174.63', 'uio_2_san_francisco', 1, '2022-09-14 15:50:28', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(258, '157.100.174.63', 'uio_4_san_agustin', 1, '2022-09-14 15:58:18', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(259, '157.100.174.63', 'uio_6_estadio', 1, '2022-09-14 15:59:27', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(260, '157.100.174.63', 'quitotazas', 1, '2022-09-14 16:40:16', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(261, '157.100.174.63', 'uio_3_basilica', 1, '2022-09-14 21:33:47', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(262, '190.63.238.185', 'quitotazas', 1, '2022-10-05 15:19:39', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(263, '200.7.247.103', 'virgen2021', 1, '2022-10-29 16:01:32', NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(264, '190.63.98.239', 'virgen2021', 1, '2022-10-29 16:13:47', NULL, NULL, NULL, NULL, NULL, NULL, NULL);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `registro_mes`
--

CREATE TABLE `registro_mes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `escaneosTotales` bigint(20) UNSIGNED DEFAULT NULL,
  `mesNombre` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mesNumero` bigint(20) UNSIGNED DEFAULT '1',
  `anyo` bigint(20) UNSIGNED DEFAULT '1',
  `gasto_aws` bigint(20) UNSIGNED DEFAULT '0',
  `gasto_dominio` bigint(20) UNSIGNED DEFAULT '0',
  `gasto_hosting` bigint(20) UNSIGNED DEFAULT '0',
  `fecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Volcado de datos para la tabla `registro_mes`
--

INSERT INTO `registro_mes` (`id`, `escaneosTotales`, `mesNombre`, `mesNumero`, `anyo`, `gasto_aws`, `gasto_dominio`, `gasto_hosting`, `fecha`) VALUES
(6, 43, 'November', 11, 2020, 25, 39, 0, '2021-05-24 22:09:43'),
(7, 79, 'diciembre', 12, 2020, 25, 0, 0, '2021-04-28 22:34:53'),
(8, 18, 'enero', 1, 2021, 25, 0, 0, '2021-04-28 22:34:38'),
(9, 5, 'febrero', 2, 2021, 23, 0, 0, '2021-04-28 22:35:38'),
(10, 5, 'marzo', 3, 2021, 25, 0, 0, '2021-04-28 22:36:04'),
(11, 3, 'abril', 4, 2021, 35, 0, 0, '2021-05-24 21:25:48'),
(12, 13, 'mayo', 5, 2021, 43, 0, 0, '2021-12-22 17:44:51'),
(13, 22, 'junio', 6, 2021, 24, 0, 0, '2021-12-22 17:45:50'),
(14, 16, 'julio', 7, 2021, 24, 0, 0, '2021-12-22 17:45:53'),
(15, 8, 'agosto', 8, 2021, 24, 0, 0, '2021-12-22 17:46:03'),
(16, 11, 'septiembre', 9, 2021, 23, 0, 0, '2021-12-22 17:46:24'),
(17, 11, 'octubre', 10, 2021, 24, 0, 0, '2021-12-22 17:46:58'),
(18, 4, 'noviembre', 11, 2021, 23, 39, 0, '2021-12-22 17:47:55'),
(19, 2, 'diciembre', 12, 2021, 0, 0, 0, '2021-12-31 07:00:00'),
(20, 5, 'enero', 1, 2022, 0, 0, 0, '2022-01-31 07:00:00'),
(21, 1, 'febrero', 2, 2022, 0, 0, 0, '2022-02-28 07:00:00'),
(22, 1, 'marzo', 3, 2022, 0, 0, 0, '2022-03-31 07:00:00'),
(23, 1, 'abril', 4, 2022, 0, 0, 0, '2022-04-30 07:00:00'),
(24, 5, 'mayo', 5, 2022, 0, 0, 0, '2022-05-31 07:00:00'),
(25, 0, 'julio', 7, 2022, 0, 0, 0, '2022-07-31 07:00:00'),
(26, 2, 'agosto', 8, 2022, 0, 0, 0, '2022-08-31 07:00:00'),
(27, 8, 'septiembre', 9, 2022, 0, 0, 0, '2022-09-30 07:00:00');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indices de la tabla `modelos`
--
ALTER TABLE `modelos`
  ADD UNIQUE KEY `modelos_id_unique` (`id`);

--
-- Indices de la tabla `registros`
--
ALTER TABLE `registros`
  ADD PRIMARY KEY (`id`),
  ADD KEY `registros_modelo_foreign` (`modelo`);

--
-- Indices de la tabla `registro_mes`
--
ALTER TABLE `registro_mes`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT de la tabla `registros`
--
ALTER TABLE `registros`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=265;

--
-- AUTO_INCREMENT de la tabla `registro_mes`
--
ALTER TABLE `registro_mes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
COMMIT;

/*!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 */;
