-- https://www.phpmyadmin.net
--
-- Servidor: localhost
-- Tiempo de generación: 17-12-2020 a las 14:12:10
-- Versión del servidor: 5.5.60-MariaDB
-- Versión de PHP: 5.4.16


--
-- Base de datos: `GBL_AGENDA`
--
CREATE DATABASE IF NOT EXISTS `GBL_AGENDA` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `GBL_AGENDA`;

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

--
-- Estructura de tabla para la tabla `anotaciones`
--

CREATE TABLE IF NOT EXISTS `anotaciones` (
  `ID` varchar(32) NOT NULL,
  `meta` varchar(15) NOT NULL,
  `fecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `comentario` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `anotaciones` (`ID`, `meta`, `fecha`, `comentario`) VALUES
('K0181920200519142100', 'K01819', '2020-05-19 12:22:11', 'Oscar, por favor, incluye a Alberto en el listado de distribución del reporte Intraday Postventa. Gracias.'),
('20200518185046', 'M103119', '2020-05-19 08:51:49', 'Ya sele el skill de transolver en los informes de telefonía SOR'),
('M10311920200518152118', 'M103119', '2020-05-18 13:22:51', 'Los scripts ya están creados, falta la parte HTML'),
('M10311920200518181525', 'M103119', '2020-05-18 16:16:04', 'Habrá que hacer una fiesta para celebrarlo'),
('K0181920200519090038', 'K01819', '2020-05-19 07:02:04', 'Oscar, por favor, modifica el orden de los mensajes del chat y déjalos como estaban al principio, como están ahora es muy lioso y no pueden seguirse las conversaciones. Gracias.'),
('M10311920200518152433', 'M103119', '2020-05-18 13:25:21', 'Migrar los scripts que no sean SQL de As400'),
('K0181920200519172013', 'K01819', '2020-05-19 15:23:06', 'Oscar, me pide Rebe que no se igualen los LEADs semanales de ARVAL, se están incorporando comerciales a mitad de semana y le están cayendo todos los LEADs para compensar los días que no han estado.\nMientras dure la situación del COVID19 no se debe igualar, que sean los agentes los que decidan a quién asignar. Gracias.'),
('K0181920200519142100', 'M103119', '2020-05-19 16:15:33', 'Ya esta incluido'),
('K0181920200519090038', 'M103119', '2020-05-19 16:24:46', 'Comprobar si ya sale ordenado por la fecha'),
('K0181920200519172013', 'M103119', '2020-05-19 16:36:09', 'La aplicación no asigna al comercial automáticamente, solo te hace una propuesta de a quien le tocaría, en el desplegable pueden escoger al comercial que quieran'),
('K0181920200520084601', 'K01819', '2020-05-20 06:48:00', 'Oscar, hay que configurar AVAYA ONE X a Fran y a Sara, si es necesario hacerlo en presencial quedamos de manera escalonada con ellos en plataforma.'),
('K0181920200519172013', 'K01819', '2020-05-20 06:49:25', 'O.k., me lo imaginaba, entonces sólo tienen que cambiar la asignación manualmente sobre la propuesta inicial de asignación. Gracias.'),
('M10311920200518152433', 'M103119', '2020-05-22 09:03:15', 'Control ejecucion de los scripts del Jueves 21/05/2020\n- Registros CMS Force: 6\n- Registros CMS SOR/ALD: 19\n- Registros CMS Fuera Horario: 4\n- Registros Consola SII: 0\n- Registros Cotizaciones: 0\n- Registros Cotizaciones WEB: 0\n- Registros Operaciones: 0\n- Registros Operaciones Full: 0\n- Registros PR Elevadas: 10\n- Registros PR Revisadas: 6\n'),
('M10311920200525103358', 'M103119', '2020-05-25 08:37:52', 'Dos botones, apuntar y ver.\n\nen ver: Tareas y llamdas'),
('K0181920200520084601', 'M103119', '2020-05-27 11:15:02', 'Hay que reclamar las extensiones que las migren'),
('M10311920200525103358', 'M103119', '2020-05-28 11:28:33', 'Lbreria CrearTabla\n - width = 0 ==> display none\n - crear icono, titulo para TH\n - formatField para formato fecha y checkbox'),
('K0181920200603093348', 'K01819', '2020-06-03 07:34:15', 'Detalle en email enviado.'),
('K0181920200603093348', 'M103119', '2020-06-03 15:20:08', 'Lo tengo que mirar con mas detenimiento, pero el descuadre creo que es porque el lunes resetee los paneles y el otro es el acumulado de la campaña'),
('M10311920200616100227', 'M103119', '2020-06-16 08:04:53', '	              Vhs.	Fichero Macro	 Macro OV	Macro Contrato  Oficina	Franja	Gestor\n1ª REMESA	71	11/06/2020	11/06/2020	12/06/2020	12/06/2020	18:00pm, Tarde	Fran\n2ª REMESA	73	11/06/2020	15/06/2020	16/06/2020	16/06/2020	14:55pm, Mañana	Sara\n3ª REMESA	121	11/06/2020	17/06/2020	18/06/2020	18/06/2020	18:00pm, Tarde	Fran\n4ª REMESA	104	11/06/2020	19/06/2020	22/06/2020	22/06/2020	14:55pm, Mañana	Sara\n'),
('K0181920200810185617', 'K01819', '2020-08-10 16:57:42', 'El cliente solicita incluir un nuevo campo, ya existente pero no visible en su reporting. En función del comercial asignado sabe el potencial de flota del cliente.'),
('M9941320200825153803', 'M99413', '2020-08-25 13:39:21', 'Esta es una nota solo para chusa'),
('M9941320200825153803', 'M103119', '2020-08-25 13:41:49', 'No puedo poner texto privado'),
('M9798120201023141706', 'M97981', '2020-10-23 12:55:49', '- Pendiente de que tramiten nueva cotización actualizada.\n- Pendiente de VR- Squotas e información para confeccionar los contratos.\n- Los R los puedo ir haciendo a falta de cumplimentar información económica'),
('M9798120201023141706', 'M97981', '2020-10-23 14:03:36', '*****  ALICIA NEGRILLO GOMEZ   23/10/2020 14:55\n- Pendiente de que tramiten nueva cotización actualizada.\n- Pendiente de VR- Squotas e información para confeccionar los contratos.\n- Los R los puedo ir haciendo a falta de cumplimentar información económica\n\n\n			\nOPERACIONES	BASTIDOR	MODELO R	\nA	WJMM62AVZ0C439371	5137	\nB	WJMM62AVZ0C439369	5138	\nC	WJMM62AVZ0C439203	5139	\nD	WJMM62AVZ0C439202	5140	\n\n-------\nE	WJMM62AVZ0C439201	5141	\nF	WJMM62AVZ0C439095	5142	\nG	WJMM62AVZ0C438986	5143	\nH	WJMM62AVZ0C438985	5144	\nI	WJMM62AVZ0C438882	5145	\nJ	WJMM62AVZ0C438881	5146	\n'),
('M9798120201023141706', 'M97981', '2020-10-26 12:05:37', 'OFERTAS VINCULANTES - OKS.\n\nCONTRATOS DE SISTEMA . PENDIENTE DE QUE ABRAN SISTEMA PARA CORRER LA MACRO QUE HE HECHO.\n\nCONTRATOS MANUALES. PENDIENTES.\n\nCONTRATOS R. ACTUALIZAR LOS PRIMEROS CON DATOS ECONÓMICOS Y TERMINAR EL RESTO.\n\nIMPORTANTE!!! PENDIENTE DE VR y SQUOTA POR PARTE DE TRANSOLVER.\n\n'),
('M9798120201023141706', 'M97981', '2020-10-26 14:43:22', '\n\n\n\nOFERTAS VINCULANTES - OKs.\n\nCONTRATOS MANUALES. OKs!!! A excepción del contrato de mantenimiento( falta vr - squota)\n\nCONTRATOS DE SISTEMA . PENDIENTE DE QUE ABRAN SISTEMA PARA CORRER LA MACRO QUE HE HECHO.\n\nCONTRATOS R. ACTUALIZAR LOS PRIMEROS CON DATOS ECONÓMICOS Y TERMINAR EL RESTO.- .......................................................esto va a ser lo siguiente con lo que me voy a poner.\n\n\n\n\nPor parte de Transolver: \n\nIMPORTANTE!!! PENDIENTE DE VR y SQUOTA POR PARTE DE TRANSOLVER.'),
('M9798120201023141706', 'M97981', '2020-10-26 15:24:04', '\nOFERTAS VINCULANTES - OKs.\n\n\nCONTRATOS DE SISTEMA . OKs\n\n\nFalta:\n\n\nCONTRATOS MANUALES. OKs!!! A excepción del contrato de mantenimiento( falta vr - squota)\n\n\nCONTRATOS R. ACTUALIZAR LOS PRIMEROS CON DATOS ECONÓMICOS Y TERMINAR EL RESTO.- .......................................................esto va a ser lo siguiente con lo que me voy a poner.\n\n\n\n\nPor parte de Transolver: \n\nIMPORTANTE!!! PENDIENTE DE VR y SQUOTA.'),
('M9798120201023141706', 'M97981', '2020-10-26 16:03:29', 'Orden de prioridad:\n\nModelos R: Alrededor de 1 hora.\n\nAnexos de mantenimiento: cuando llegue autorización VR - Squota.\n\n'),
('M9798120201023141706', 'M97981', '2020-10-26 16:04:48', 'Si llega antes VR- squota--> esto sería lo primero para así que me los vayan vinculando mientras yo hago los R.'),
('M9798120201023141706', 'M97981', '2020-10-27 10:40:15', 'O.V, Contratos, manuales y R - Terminados.\n\nFalta:\n\n- Archivo de correos y documentación.\n- Anexo de mantenimiento : cuando tengamos VR y Squotas.\n- Anexo de Recompra'),
('M9798120201023141706', 'M97981', '2020-10-27 14:37:34', '\n\nPendiente:\n\na) Terminar los 10 Anexos de mantenimientos -- incidencia con autorización recibida.\n\nb) Una vez terminado, se pueden vincular los documentos que hay en la carpetas para su envío.\n\n\n\nOPERACIÓN	                                                            BASTIDOR	                                                  MODELO R	\n\n\nY44A20200000263                                	           WJMM62AVZ0C439371                                       	5137	\nY44A20200000264                                     	   WJMM62AVZ0C439369	                                        5138	\nY44A20200000265	                                           WJMM62AVZ0C439203	                                        5139	\nY44A20200000266	                                           WJMM62AVZ0C439202	                                        5140	\nY44A20200000267	                                           WJMM62AVZ0C439201	                                        5141	\nY44A20200000268	                                           WJMM62AVZ0C439095	                                        5142	\nY44A20200000269	                                           WJMM62AVZ0C438986	                                        5143	\nY44A20200000270	                                           WJMM62AVZ0C438985	                                        5144	\nY44A20200000271                                            WJMM62AVZ0C438882	                                        5145	\nY44A20200000272                                      	   WJMM62AVZ0C438881	                                        5146	\n			\n'),
('M9798120201023141706', 'M97981', '2020-10-28 09:48:32', 'Actualizadas Fechas -- Pte de vinculación de documentos para su envío al comercial.'),
('M9798120201023141706', 'M97981', '2020-10-28 10:21:02', 'Enviados contratos al comercial.\n\nPendiente:\n\nArchivo de correos y apuntarme las tareas'),
('M9798120201023141706', 'M97981', '2020-10-28 11:25:49', 'Tarea Acabada'),
('M9798120201106162446', 'M97981', '2020-11-06 15:25:25', 'ANEXOS DE RECOMPRAR\n\nOP DE AURORA DE NILO -- AMPLIACIÓN\n\nCONTRATO DE TRANSOLVER DE LA AGENCIA'),
('M9798120201106162446', 'M97981', '2020-11-06 15:26:14', 'ARCHIVAR LOS CORREOS DEL CONTRATO DE TRANSOLVER DE LA K6'),
('K0003820201106175948', 'K00038', '2020-11-06 17:02:04', 'Por favor, Fabio a ver si es posible que no haya que hacer tanto doble click para esto.  Gracias'),
('K0003820201106175948', 'K01819', '2020-11-06 17:02:50', 'Recibido Merche, nos ponemos con ello'),
('K0003820201106175948', 'K01819', '2020-11-06 17:07:16', 'De: Mercedes Gonzalez Martinez [mailto:mgonzalezma@grupokonecta.com] \nEnviado el: viernes, 06 de noviembre de 2020 16:51\nPara: F Cabezas\nCC: Mara Martín de las Blancas González; Irma Brito Martín; MARÍA VELASCO ZAMORA\nAsunto: Manuales COM00045\n\nFabio, por favor, necesito que pongas en la COM00045 la posibilidad de subir manuales igual que en CNP pero que habilites el perfil para hacerlo a las 3. \n \nMara Martín de las Blancas\nIrma Brito Martín\nMaría Velasco Zamora\n \nGracias!!!\n \n'),
('K0181920201116190308', 'K01819', '2020-11-16 18:08:03', 'Oscar, \n\nConforme acabamos de comentar necesito implementar un módulo de reportes para la APP de Activos de tal forma que:\n\n* La APP genere un report con una foto fija de activos.\n* La APP genere un report con un histórico de movimientos de activos en un rango de fechas.\n* El acceso debe darse desde el NIVEL Simple al Global pasando por el Medio.\n* Con independencia del Nivel, cada usuario deberá ver únicamente los CECOS asignados por su META, a excepción del nivel global que lo vería todo.'),
('K0181920201116190913', 'K01819', '2020-11-16 18:14:53', 'Oscar, \n\nPor favor, necesito duplicar la APP del lanzador "Manuales SC CNP" para el servicio COM00045. Ej: "Manuales COM00045".\nEl acceso sería exclusivo para los agentes de esta campaña (yo me ocuparía de perfilar sus permisos).\n\nGracias.'),
('K0181920201116191639', 'K01819', '2020-11-16 18:27:36', 'El proyecto engloba la automatización de los siguiente ficheros con periodicidad diaria, semanal o mensual:\n\nControl de Costes:\n\n1.Ficheros de Coste.\n2. Fichero de Revisión de Personal.\n3. Fichero de revisión de usuarios.\n4. Ficheros de ocupación. \n5. Ficheros de Incorporación Presencial.\n6.Control de horas sobrantes.\n7. Cruce de Metas para sacar nombre.\n\nControl de Facturación:\n\n1. Fichero de estimaciones.\n2. Analíticas consolidadas.\n3. SIK.\n4. Estimaciones GEOBAN.\n\nControl de Gestión.\n\n1. Alertas.\n2. Cuadros de Seguimiento.\n3. Seguimiento de Huelga.\n4. Fichero de Reubicaciones.\n\n\n'),
('M10311920201118085056', 'M103119', '2020-11-18 10:51:18', 'Nos quedamos a la espera de un nuevo fichero para actualizar los activos.\nNo quedamos a la espera de que Benito nos de el script de lectura de la BB.DD de GT.\n\nPendientes de desarrollo por parte de GT para la carga masiva, hasta entonces Benito hace las cargas.'),
('M10311920201118085056', 'M103119', '2020-11-18 10:59:39', 'Desde seguridad informática nos dan acceso a lectura de BB.DD pero no escritura'),
('K0181920201116190913', 'M103119', '2020-11-18 11:30:19', 'Ya esta duplicada la aplicación, la he llamado ''Manuales Activacion'', solo pueden subir manuales Merche, tu y yo.\n\nFaltaría bajarla de nivel, dar acceso a los usuarios que nos digan y cambiarla el icono.'),
('M10311920201118085056', 'M103119', '2020-11-20 11:57:37', 'Enviar fichero con propiedades duplicadas a Sergio,\n\nCruzar BB.DD con fichero de Sergio.\n\nAhora script lectura NO y a esperar a que se cree un web service'),
('K0181920201116190913', 'K01819', '2020-11-24 15:35:02', 'Gracias Oscar, \n\nAdemás de Merche,tú y yo deben poder subir documentación:\n\nMara Martín de las Blancas\nIrma Brito Martín\nMaría Velasco Zamora\n\nVoy cambiando el icono y dando accesos a sus equipos.\n'),
('K0003820201106175948', 'K01819', '2020-11-24 15:50:24', 'Buenas tardes Merche, \n\nYa lo tienes, he dado accesos al grupo COM00045.\nGracias.\n\nUn saludo.'),
('K0181920201116190913', 'M103119', '2020-11-25 12:07:16', 'Ya están dados de alta los usuarios para que puedan subir manuales.'),
('K0181920201116190913', 'K01819', '2020-11-26 17:36:13', 'Gracias, cierro la tarea.'),
('K0003820201106175948', 'K01819', '2020-11-26 17:40:49', 'Ya están todos los usuarios perfilados.\nGracias.'),
('M10311920201202110013', 'M103119', '2020-12-02 10:03:32', '1.- Automatizar carga facturas de las APP control eventos y mirar como buscar los flujos de la LIQ. KM (Lunes - Viernes)\n\n2.- Crear Tabla de los eventos de Facturacion y automatizar la carga en MySQL (Lunes - Viernes y dia 1 del mes)\n\n3.- SQL para sacar el informe\n\n4.- Crear el HTML para sacar el informe\n'),
('K0181920201216172549', 'K01819', '2020-12-16 16:50:31', 'Oscar, \n\nConforme hemos comentado necesito duplicar la APP de ARVAL Campañas para adaptarla a la Campaña de Navidad de MTR ARVAL (manteniendo los 2 aplicativos actuales más éste nuevo).\n\nCodificaciones:\n\n1.Tipo de Producto.\n\n   * Particulares B2C.\n   * PYMES y Autónomos B2B.\n\n2. Tipo Comercial.\n\n   * Comercial (no vamos a tener Sales Support).\n\n3. Asignar a Comercial.\n\n   * Amando Ordóñez.\n   * Raquel Amoedo.\n   * Alberto Álvarez.\n\n4. Tipo de Entrada.\n\n   * Campaña de Navidad.\n   * LEAD.\n\n5. Estado candidato.\n\n   * Mismas codificaciones.\n\n6. Tipo de Oportunidad.\n\n   * Mismas codificaciones. \n\n7. Vehículo seleccionado.\n\n  * Segmento Turismo Pequeño.\n  * Segmento Turismo Mediano.\n  * Segmento Turismo Mediano Premium.\n  * Segmento Turismo Grande.\n  * Segmento Turismo Grande Premium.\n  * Segmento Turismo Turismo Gran Clase.\n  * Segmento Monovolumen.\n  * Segmento Todo Terreno 4*4.\n  * Segmento Todocamino Premium.\n  * Segmento Todocamino.\n  * Segmento Híbridos.\n  * Segmento Eléctricos.  \n  * Segmento Industrial. Furgoneta Carga 3,5m3.\n  * Segmento Industrial. Furgoneta Combi 3,5m3.\n  * Segmento Industrial. Furgoneta 5m3.\n  * Segmento Industrial. Furgoneta Pasajeros 9 plazas.\n  * Segmento Industrial. Furgoneta 6 plazas.\n  * Segmento Industrial. Furgoneta 14m3.\n  * Segmento Industrial. Furgoneta 10m3.\n\nPara el área de reporting adaptamos el informe actual a las nuevas codificaciones, teniendo en cuenta que no hay entrada de telefonía ni skill específico por lo que se reflejará en el informe general.\nEl listado de distribución del informe cambia, de momento que se reenvíe a ti y a mí, cuando esté revisado y o.k. te facilitaré los @ de cliente.\n\nMe gustaría incrustar un pdf con el detalle de los modelos por segmento, de manera que les sirva como argumentario de venta. Esto te lo paso por email.\n\nResto de funcionalidades como en la APP de Origen.\nDeadline este Viernes, arrancamos el lunes 21.\n\nGracias.\n\n\n\n\n\n\n\n\n');

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

--
-- Estructura de tabla para la tabla `anotacionesPRV`
--

CREATE TABLE IF NOT EXISTS `anotacionesPRV` (
  `ID` varchar(32) NOT NULL,
  `meta` varchar(15) NOT NULL,
  `fecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `comentario` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `anotacionesPRV` (`ID`, `meta`, `fecha`, `comentario`) VALUES
('K0181920200518183850', 'K01819', '2020-05-18 16:41:22', 'Eficiencia solicitada de 3 recursos.'),
('M10311920200518182000', 'M103119', '2020-06-04 10:00:41', 'Crear tabla seguimiento, dobleclick'),
('M9941320200825153803', 'M99413', '2020-08-25 13:39:51', 'Esta es personal');

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

--
-- Estructura de tabla para la tabla `contactos`
--

CREATE TABLE IF NOT EXISTS `contactos` (
  `meta` varchar(15) NOT NULL,
  `ID` varchar(32) NOT NULL,
  `nombre` varchar(32) NOT NULL,
  `apellidos` varchar(128) NOT NULL,
  `titulo` varchar(32) NOT NULL,
  `fCreacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `EXTN` int(8) DEFAULT NULL,
  `telefono` varchar(20) DEFAULT NULL,
  `movil` int(10) DEFAULT NULL,
  `eMail` varchar(256) NOT NULL,
  `direccion` varchar(256) DEFAULT NULL,
  `comentario` text
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `contactos` (`meta`, `ID`, `nombre`, `apellidos`, `titulo`, `fCreacion`, `EXTN`, `telefono`, `movil`, `eMail`, `direccion`, `comentario`) VALUES
('M103119', 'M10311920200510164422', 'CAU Konecta', 'Avda Induatria', 'CAU', '2020-05-10 14:44:22', 793474, '91 050 16 30', 902051141, 'cau@grupokonecta.com', 'Avda. Industria 50', 'URL: http://soporte.ind.local\r\nsoporteind@grupokonecta.com'),
('M103119', 'M10311920200510165928', 'GEOBAN', '', 'CAU', '2020-05-10 14:59:28', 0, '902 75 74 70', 911333785, 'sccau@santanderconsumer.com', '', 'Para el reseto de las contraseñas del AS400'),
('M103119', 'M10311920200510170147', 'LUIS', 'HERNANDEZ REAL', 'GEOBAN', '2020-05-10 15:01:47', 0, '91 724 67 48', 691895208, 'lhreal@geoban.es', '', 'Los fijos no funcionan'),
('M103119', 'M10311920200510170338', 'Monica', 'Sanchez', 'GEOBAN', '2020-05-10 15:03:38', 0, '912892592', 0, 'monicasanchez@gruposantander.com', '', 'Los fijos no funcionan, no tengo el móvil actual'),
('M103119', 'M10311920200510170456', 'Monica', 'Segura', 'GEOBAN', '2020-05-10 15:04:56', 0, '912892044', 0, 'mosegura@gruposantander.com', '', 'Los fijos no funcionan, no tengo el móvil actual'),
('M97981', 'M9798120201020164923', 'IVAN TRANSOLVER', '', 'TRANSOLVER', '2020-10-20 14:49:23', 55359, '913252062', 620109977, 'ivan.hernandezcordoba@external.cnhind.com', 'Avda. Aragón, 402- Madrid', ''),
('K00178', 'K0017820201020165755', 'Jose Luis ', 'Ochoa', 'NEGOCIO', '2020-10-20 14:57:55', 0, '912897090', 610492006, 'jlochoa@santanderconsumer.com', '', ''),
('K00178', 'K0017820201020165938', 'Luis', 'Del Arco', 'Dpto. VO', '2020-10-20 14:59:38', 0, '912899334', 912899334, 'ldelarco@santanderconsumer.com', '', ''),
('M12340', 'M1234020201022105241', 'Monica', 'Segura', 'GEOBAN', '2020-10-22 08:52:41', 0, '', 912892044, '', '', ''),
('M12340', 'M1234020201022110143', 'Neumáticos', '', 'GOOD YEAR', '2020-10-22 09:01:43', 0, '', 902196002, '', '', ''),
('M12340', 'M1234020201022111620', 'Asistencia Grúa', '', 'ALLIANZ', '2020-10-22 09:16:20', 0, '', 902102338, '', '', ''),
('M12340', 'M1234020201022112024', 'Vodafone', '', 'SERVICIO TEC', '2020-10-22 09:20:24', 0, '', 902113798, '', '', 'Autorizaciones de talleres averias opc 1\nPago de facturas opc 3'),
('M12340', 'M1234020201022112159', 'SC Renting', '', 'SERVICIO TEC', '2020-10-22 09:21:59', 0, '', 901330033, '', '', ''),
('M12340', 'M1234020201022112422', 'SC Renting', '', 'SEGUROS ', '2020-10-22 09:24:22', 0, '', 901330033, '', '', ''),
('M12340', 'M1234020201022112714', 'Multas', '', 'PYRAMID', '2020-10-22 09:27:14', 0, '', 902555567, '', '', ''),
('M12340', 'M1234020201022113204', 'Asitencia Internacional', '', 'ALLIANZ', '2020-10-22 09:32:04', 0, '', 914522915, '', '', ''),
('M12340', 'M1234020201022113548', 'Atención a cliente', '', 'SC FINANCIADO', '2020-10-22 09:35:48', 0, '', 911773230, '', '', ''),
('K00178', 'K0017820201022114636', 'Teresa', 'Jabalera Torrejon', 'RED SUC. HQ', '2020-10-22 09:46:36', 0, '610492350', 935213308, 'tjabalera@santanderconsumer.com', 'CL. VIA AUGUSTA 21-23 4ª BARCELONA', 'Director oficina Macro Auto'),
('M12340', 'M1234020201022125436', 'SC Renting', '', 'IMPAGADOS', '2020-10-22 10:54:36', 0, '', 917993893, '', '', ''),
('M12340', 'M1234020201022142013', 'Asistencia', '', 'MAZDA', '2020-10-22 12:20:13', 0, '', 915949370, '', '', ''),
('M12340', 'M1234020201022142128', 'Atención a cliente', '', 'MAZDA', '2020-10-22 12:21:28', 0, '', 916355922, '', '', ''),
('M12340', 'M1234020201022142303', 'SOLEDAD', '', 'Neumáticos', '2020-10-22 12:23:03', 0, '', 965681845, '', '', 'Red de autorizaciones a taller'),
('M12340', 'M1234020201022142416', 'SALCO', '', 'Neumáticos', '2020-10-22 12:24:16', 0, '', 986870976, '', '', 'Beatriz o Mª Carmen'),
('M12340', 'M1234020201022142527', 'NERMOVIL', '', 'Neumáticos', '2020-10-22 12:25:27', 0, '', 917252583, '', '', 'Pc. Antonio\nC/ Cartagena, 44\n\nTaller de la red de GY'),
('M12340', 'M1234020201022142706', 'LLANERA', '', 'Neumáticos', '2020-10-22 12:27:06', 0, '', 985980980, '', '', 'Rodrigo\nCambia en esté taller Aurelio de Konecta'),
('M12340', 'M1234020201104114925', 'Atención aL cliente', '', 'FORD', '2020-11-04 10:49:25', 0, '', 900807090, '', '', 'e-mail.: flotas1@ford.com'),
('K31897', 'K3189720201110131426', 'Ana', 'Bastida', 'ANA GREGORIO MOVIL', '2020-11-10 12:14:26', 0, '610001123', 0, 'anabru_24@hotmail.com', 'Calle Asia', ''),
('K00178', 'K0017820201116093044', 'Postventa SCR', '', 'Post- venta SCR', '2020-11-16 08:30:44', 0, '910502094', 910502094, '', '', ''),
('K02184', 'K0218420201211142448', 'Begoña ', 'de la Fuente Sanchez', 'Begoña de la Fuente Sanchez', '2020-12-11 13:24:48', 731560, '91 484 58 47 ', 610492682, 'bdelafuente@grupokonecta.com', 'Avenida de la Industria, 49 ', ''),
('K02184', 'K0218420201211142643', 'Ana Maria', 'Gregorio Bastida', 'Ana Maria Gregorio Bastida', '2020-12-11 13:26:43', 731748, '911774035', 610001123, 'amgregorio@grupokonecta.com', 'Avenida de la Industria, 49 ', ''),
('K02184', 'K0218420201211142856', 'Zulema ', 'de la Cal Navas', 'Zulema de la Cal Navas', '2020-12-11 13:28:56', 731861, '91 274 12 82', 672661633, 'zdelacal@grupokonecta.com', 'Avenida de la Industria, 49 ', ''),
('K02184', 'K0218420201215114304', 'África ', 'Zamora García  ', 'África Zamora García  ', '2020-12-15 10:43:04', 731860, '+34 91 274 12 97 ', 610492699, 'AZAMORA@GRUPOKONECTA.COM', 'AVENIDA DE LA INDUSTRIA 49', ''),
('K00178', 'K0017820201217104213', 'Patricia ', 'Candalija', 'GAR', '2020-12-17 09:42:13', 0, '912053489', 912053489, 'patricia.candalija@servexternos.santanderconsumer.com', '', ''),
('K02184', 'K0218420201216101137', 'Fabio', 'Cabezas Gívica', 'Fabio Cabezas Gívica', '2020-12-16 09:11:37', 731887, '91 205 37 88 ', 648138256, 'fcabezas@grupokonecta.com', 'AVENIDA DE LA INDUSTRIA 49', ''),
('K02184', 'K0218420201216104339', 'Mª Oliva', 'Miranda Riera', 'Mª Oliva Miranda Riera', '2020-12-16 09:43:39', 731700, '910504214', 607780080, 'omiranda@grupokonecta.com', 'AVENIDA DE LA INDUSTRIA 49', ''),
('K02184', 'K0218420201216110235', 'Mercedes ', 'Gonzalez Martinez', 'Mercedes Gonzalez Martinez', '2020-12-16 10:02:35', 741420, '912053456', 600459092, 'mgonzalezma@grupokonecta.com', 'AVENIDA DE LA INDUSTRIA 49', ''),
('K02184', 'K0218420201216113109', 'Marisa ', 'Haba de Llano', 'Marisa Haba de Llano', '2020-12-16 10:31:09', 731430, '912053787', 648246341, 'mlhaba@grupokonecta.com', 'AVENIDA DE LA INDUSTRIA 49', ''),
('K02184', 'K0218420201216114203', 'Marivi ', 'De Francisco Causapie', 'Marivi De Francisco Causapie', '2020-12-16 10:42:03', 730643, '', 600403083, 'mvfcausapie@grupokonecta.com', 'AVENIDA DE LA INDUSTRIA 49', ''),
('K02184', 'K0218420201216114932', 'Luis Miguel', 'Sanchez de Molina Martinez', 'Luis Miguel Sanchez de Molina Ma', '2020-12-16 10:49:32', 232443, '9148425744', 648246342, 'Luis Miguel Sánchez de Molina Martínez <lmsanchez@grupokonecta.com>', 'AVENIDA DE LA INDUSTRIA 49', ''),
('K02184', 'K0218420201216115453', 'Ana ', 'Gonzalez Sanz', 'Ana Gonzalez Sanz', '2020-12-16 10:54:53', 741372, '910502087', 657153660, 'agsanz@grupokonecta.com', 'AVENIDA DE LA INDUSTRIA 49', ''),
('K00178', 'K0017820201217105815', 'Fernando Jose', 'García Saura', 'GAR', '2020-12-17 09:58:15', 0, '912053489', 912053489, 'fjgarcias@ext.santanderconsumer.com', '', ''),
('M132331', 'M13233120201217130429', 'MARISOL', '', 'MARISOL', '2020-12-17 12:04:29', 0, '91 021 30 79', 0, '', '', '');

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

--
-- Estructura de tabla para la tabla `notas`
--

CREATE TABLE IF NOT EXISTS `notas` (
  `ID` varchar(32) NOT NULL,
  `meta` varchar(15) NOT NULL,
  `titulo` varchar(256) NOT NULL,
  `fCreacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `comentario` text NOT NULL,
  `color` varchar(8) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `notas` (`ID`, `meta`, `titulo`, `fCreacion`, `comentario`, `color`) VALUES
('M10311920200508102317', 'M103119', 'Estado APP Agenda Actual', '2020-05-08 08:23:17', 'Usuario:\r\n   Los Usuarios pueden ser personales o los puedes compartir. \r\n   Solo el propietario puede borrar o modificar. El compartir se hace después de haber creado el usuario\r\n   Pulsando sobre los *** te muestra la contraseña.\r\n   DobleClick sobre el usuario o titulo te muestra el detalle del usuario\r\n\r\nNotas:\r\n   Las notas pueden ser personales o las puedes compartir. \r\n   Solo el propietario puede borrar o modificar. El compartir se hace después de haber creado la nota\r\n   Pulsado sobre el cuadro de Color muestra una paleta de colores para seleccionar el color de la nota\r\n\r\nContactos:\r\n   Los contactos pueden ser personales o los puedes compartir.\r\n   Solo el propietario puede borrar o modificar. El compartir se hace después de haber creado el contacto\r\n\r\nTareas y Reuniones:\r\n   Pueden ser personales o los puedes compartir.\r\n   Solo el propietario puede borrar o modificar. El compartir se hace después de haberlo creado.\r\n   Todos los participantes pueden agregar notas publicas y el propietario pude agregar notas privadas que solo él ve\r\n', '#00b050'),
('M10311920200508174604', 'M103119', 'Linux', '2020-05-08 15:46:04', 'MySQL:\r\n/usr/libexec/mysqld (ejecutable)\r\n\r\n  mysql -u root -p (conectar MySQL por consola)\r\n  mysql> SHOW VARIABLES LIKE ''max_connections'';\r\n  mysql> SET GLOBAL max_connections = 1000;\r\n\r\n  sudo vim /etc/my.cnf ([mysqld] max_connections = 1000)\r\n  sudo systemctl restart mysql\r\n\r\n  Desde PHPadmin:\r\n   show processlist;\r\n   SELECT * FROM INFORMATION_SCHEMA.PROCESSLIST\r\n   SELECT DB, COUNT(*) AS NConn FROM INFORMATION_SCHEMA.PROCESSLIST GROUP BY DB\r\n\r\nSELECT CONCAT(''KILL '',ID,'';'')\r\nFROM   INFORMATION_SCHEMA.PROCESSLIST\r\nWHERE  DB = ''php_chat''\r\n       AND COMMAND = ''Query''\r\n       AND TIME > 100;\r\n\r\n   show session status;\r\n   show status like ''Threads%'';\r\n     Threads_cached. Es el número de procesos cacheados actualmente.\r\n     Threads_connected. Número de conexiones activas actualmente.\r\n     Threads_create. Las conexiones que se han creado hasta el momento.\r\n     Threads_running. Las que se están ejecutando actualmente.\r\n\r\n     MANTENIMIENTO:\r\n1.- CHECK TABLE "Nombre_Tabla"\r\n2.- ANALYZE TABLE "Nombre_Tabla"\r\n3.- REPAIR TABLE "Nombre_Tabla"\r\n4.- OPTIMIZE TABLE "Nombre_Tabla"\r\n5.- FLUSH TABLE "Nombre_Tabla"\r\n', '#a5a5a5'),
('M10311920200508190947', 'M103119', 'Unidades de red', '2020-05-08 17:09:47', '\\\\172.15.24.102\\servicios\\ALD_AUTOMOTIVE\r\n\\\\172.15.24.2\\bsservhipo3\r\n\\\\172.15.24.102\\servicios\\DPTO_Automocion\r\n\\\\172.15.24.102\\servicios\\DPTO_OPERACIONES_Y_GESTION\\datos responsables\\APP operaciones\r\n\r\n\\\\172.35.10.50\\QSPL (Usr AS400)\r\n\r\n\\\\180.185.66.11\\GB_FSUSERGB (Usr SCGBN)\r\n\\\\180.207.47.11\\c_scons1000 (Usr SCFES)\r\n\\\\180.205.39.210\\c8537\\SERV_BAN_TRANS\r\n\r\n\\\\180.109.64.8\\SharedFolder', '#fac08f'),
('M10311920200510171729', 'M103119', 'Tarjeta Acceso', '2020-05-10 15:17:29', 'Nº: 04140', '#8db3e2'),
('M10311920200518112207', 'M103119', 'NETFLIX', '2020-05-18 09:22:07', 'www.netflix.com\nmundoparalelog@gmail.com\nsanchinarro37\n\nHay 2 perfiles, Grace y Oscar', '#c0504d'),
('K0181920200521202558', 'K01819', 'Cuenta de resultados Canales Renting', '2020-05-21 18:25:58', 'Revisar en AX estado de las cuentas en meses no consolidados por analítica.\nActualizar datos en forecast 2.020.', '#c6d9f0'),
('K0181920200527161940', 'K01819', 'Desbloquear Cuenta SCGBN', '2020-05-27 14:19:40', '', '#dbe5f1'),
('M10311920200601181044', 'M103119', 'odbc PHP', '2020-06-01 16:10:44', 'https://www.connectionstrings.com/informix/\r\n\r\nhttps://www.php.net/manual/es/ref.pdo-odbc.php#ini.pdo-odbc.connection-pooling', '#4f81bd'),
('M10311920200605113604', 'M103119', 'DownLoad Client Access', '2020-06-05 09:36:04', 'https://ibm-i-access-para-windows.software.informer.com/download/\r\n\r\nhttps://download.informer.com/win-1193205079-d43064b8-68cce7e1/si42424_32.exe\r\n\r\nhttps://es.freedownloadmanager.org/Windows-PC/IBM-i-Access-para-Windows-GRATIS.html\r\n\r\nftp://ftp.software.ibm.com/as400/products/clientaccess/', '#c6d9f0'),
('M10311920200715143333', 'M103119', 'REFUERZO A OPEN BANK', '2020-07-15 12:33:33', 'Con esta aplicación podeis crear usuarios/notas/contactos/tareas/reuniones y las podeis compartir con otras personas, el que la crea es el administrador y el único que puede hacer modificaciones y el resto solo ver.\n\nPrimero se crea el elemnto que sea y luego se comparte con quien se quiera', '#ff0000'),
('M9941320200825153035', 'M99413', 'APP Proveedores', '2020-08-25 13:30:35', 'Unidades de red:\nH: \\\\nasscesp01.scfes.scf.corp\\c_scons1000 (Se conecta con usuario SCFES)\n\nS: \\\\v3pin1.san.corp\\c8537\\SERV_BAN_TRANS (Se conecta con usuario SCGBN)\n\nDesinversiones:\nH:\\AUTORRENTING\\DATOS AUTORRENTING\\SANTANDER CONSUMER RENTING\\FINALIZACIONES\\COMPARTIDO FINALIZACIONES Y DESINVERSIONES\\Desinversiones\\DESINVERSIONES.mdb\n\nControles:\nS:\\SCRENTING\\Matriz Controles\\Iber-rent.accdb\n\nCaja Registradora:\nH:\\AUTORRENTING\\DATOS AUTORRENTING\\SANTANDER CONSUMER RENTING\\CHUSA\\APP Control Facturacion.accdb\n\nModulo Finalizaciones:\ncopiar en el escritorio \nH:\\AUTORRENTING\\DATOS AUTORRENTING\\SANTANDER CONSUMER RENTING\\CHUSA\\BD_escritorio\\APP Modulo Finalizaciones.accdb y H:\\AUTORRENTING\\DATOS AUTORRENTING\\SANTANDER CONSUMER RENTING\\CHUSA\\BD_escritorio\\GESTOR_NUEVO_KONECTA_MODULO FINALIZACIONES.01.accdb\n\n\n\n', '#4bacc6'),
('M9941320200825153251', 'M99413', 'NO TOCAR', '2020-08-25 13:32:51', 'No modificar las nota a ver si las jodo ', ''),
('M10311920200909184938', 'M103119', 'Nuevo recurso CONSUMO', '2020-09-09 16:49:38', '\\\\datavnxa.ind.local\\MAD_MULTI-SCH', '#938953'),
('M10311920200918111757', 'M103119', 'Rutas RED USC', '2020-09-18 09:17:57', 'Las unidades de red de la usc son:\n\n\\\\datavnxa\\servicios\\dpto_usc\n\\\\172.15.24.102\\servicios\\dpto_usc\n\n\n\\\\datavnxa\\servicios\\dpto_usc\\DPTO_HBF_AUTORENTING\n\\\\172.15.24.102\\servicios\\dpto_usc\\DPTO_HBF_AUTORENTING', '#4f81bd'),
('M10311920201020133640', 'M103119', 'Acceso OWA Banco', '2020-10-20 11:36:40', 'https://outlook01.cloud.corp/owa/screntingcontratacion@santanderconsumer.com/\n\nhttps://outlook01.cloud.corp/owa/screntingcotizacion@santanderconsumer.com/\n\nhttps://outlook01.cloud.corp/owa/screntingformalizacion@santanderconsumer.com/\n\nhttps://outlook01.cloud.corp/owa/scautorentingcall@santanderconsumer.com/', ''),
('K0015320201211141623', 'K00153', 'Argumentario Encuestas NPS', '2020-12-11 13:16:23', 'Crear arg y solicitar desarrollo, telefonía e informes.', '#00b0f0'),
('M1269120201214112159', 'M12691', 'LLAMAR CLIENTE GER', '2020-12-14 10:21:59', '90550\n', '#00b0f0'),
('K0181920201029134553', 'K01819', 'Enseñar APP Agenda a Ana G.', '2020-10-29 12:45:53', 'Ana se incorpora al grupo de desarrollo de APPs', '#f2dcdb'),
('M9798120201207190352', 'M97981', 'MIÉRCOLES', '2020-12-07 18:03:52', '\nMI PLANING PARA EL MIÉRCOLES....\n\n\n\n\nA) Y34A20200000305 - 307 -  (02 unidades)10 DE DICIEMBRE --\n\nFALTA CONTRATO SISTEMA.\nAUTORIZACIÓN DE VR- SQUOTA ( MANTENIMIENTO)\nANEXO DE RECOMPRA.\n\n( resto hecho: manuales y R)\n\n-------------------------------------------\n\n\nYL0G00000000020 (01 unidades)-- 10 de DICIEMBRE -- \n\n- Nos tienen que enviar más datos.\n- Falta VR y squota - mantenimiento.\n- Falta O.V. y CONTRATO SISTEMA.\n\n( resto hecho: manuales y R)\n--------------------------------------------\n\nY46G00000000038 (03 VEHÍCULOS)-- 11 DICIEMBRE\n\n\n--------------------------------------------\n\nY46G00000000039( 01 VEHÍCULOS) -- 11 DICIEMBRE\n\n\n--------------------------------------------\n\n\nYK6G0000009 ( 02 UNIDADES) -- 15  DE DICIEMBRE \n\n\n\n', '#d99694'),
('K0218420201211141335', 'K02184', 'US Y CTS AJK', '2020-12-11 13:13:35', 'REVISAR U Y C DE AJK (hecho)\nAntigua: odbk6AET', '#ffff00'),
('M11157620201216203731', 'M111576', '', '2020-12-16 19:37:31', 'PTE PASE A IMPAGADOS 16/12\nREF 90980\nREF 90925\nREF 91013\nREF 90926', ''),
('M13233120201217130644', 'M132331', 'ALTAS JAZZTEL', '2020-12-17 12:06:44', 'NO PODEMOS DAR DE ALTA PASAPORTES.\nSALTA RIESGOS', '#ff0000'),
('K0218420201217131021', 'K02184', 'CONTRASEÑA FICHERO EXCEL', '2020-12-17 12:10:21', 'Proteger un archivo de Excel\nSeleccione Archivo > Información.\nSeleccione el cuadro Proteger libro y elija Cifrar con contraseña.\nEscriba una contraseña en el cuadro Contraseña y, después, seleccione Aceptar.\nConfirme la contraseña en el cuadro Reescribir contraseña y, después, seleccione Aceptar', 'undefine');

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

--
-- Estructura de tabla para la tabla `participantes`
--

CREATE TABLE IF NOT EXISTS `participantes` (
  `ID` varchar(32) NOT NULL,
  `idAsist` varchar(32) NOT NULL,
  `aceptar` tinyint(1) NOT NULL,
  `confirmado` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `participantes` (`ID`, `idAsist`, `aceptar`, `confirmado`) VALUES
('M10311920200506160553', 'K00063', 1, 1),
('M10311920200506160203', 'M103119', 1, 1),
('M10311920200506154610', 'M103119', 1, 1),
('M10311920200506140217', 'M103119', 1, 1),
('M10311920200506181314', 'M103119', 1, 1),
('20200508172919', 'M103119', 1, 1),
('M10311920200506114803', 'M103119', 1, 1),
('M10311920200506135949', 'M103119', 1, 1),
('M10311920200506160804', 'M103119', 1, 1),
('M10311920200506161227', 'M103119', 1, 1),
('M10311920200506160553', 'K01819', 1, 1),
('M10311920200508184026', 'M103119', 1, 1),
('M10311920200508184228', 'M103119', 1, 1),
('M10311920200508184939', 'M103119', 1, 1),
('M10311920200508185125', 'M103119', 1, 1),
('M10311920200508185438', 'M103119', 1, 1),
('M10311920200508185507', 'M103119', 1, 1),
('M10311920200508191757', 'M103119', 1, 1),
('M10311920200508191852', 'M103119', 1, 1),
('M10311920200715142645', 'M103119', 1, 1),
('K0181920200511123739', 'K01819', 1, 1),
('K0181920200512184952', 'K01819', 1, 1),
('M10311920200514091111', 'M103119', 1, 1),
('M10311920200506160553', 'M103119', 1, 1),
('M10311920200506161227', 'M96781', 1, 1),
('M10311920200506161227', 'K01819', 1, 1),
('M10311920200506160804', 'K01819', 1, 1),
('M10311920200506160804', 'M96781', 1, 1),
('M10311920200506160203', 'K01819', 1, 1),
('M9678120200519115750', 'M103119', 1, 1),
('M10311920200508102317', 'K00063', 1, 1),
('M10311920200508174604', 'M103119', 1, 1),
('M10311920200508190947', 'M103119', 1, 1),
('M10311920200510171729', 'M103119', 1, 1),
('M10311920200518112207', 'M103119', 1, 1),
('20200517141615', 'M103119', 1, 1),
('M10311920200510165928', 'K01819', 1, 1),
('M10311920200510170456', 'M103119', 1, 1),
('M10311920200510164422', 'M103119', 1, 1),
('M10311920200510165928', 'M103119', 1, 1),
('M10311920200510170147', 'M103119', 1, 1),
('M10311920200510170338', 'M103119', 1, 1),
('M10311920200510165928', 'M96781', 1, 1),
('M10311920200510165928', 'M99764', 1, 1),
('M10311920200510165928', 'M97981', 1, 1),
('M10311920200510165928', 'M99526', 1, 1),
('M10311920200510165928', 'M99765', 1, 1),
('M10311920200510165928', 'M71016', 1, 1),
('M10311920200510165928', 'M62270', 1, 1),
('M10311920200510165928', 'M26299', 1, 1),
('M10311920200510165928', 'M103141', 1, 1),
('M10311920200510165928', 'M143798', 1, 1),
('M10311920200510165928', 'M16532', 1, 1),
('M10311920200510165928', 'M12340', 1, 1),
('M10311920200510165928', 'K00178', 1, 1),
('M10311920200510165928', 'K02090', 1, 1),
('M10311920200510165928', 'M99413', 1, 1),
('M10311920200510165928', 'M126651', 1, 1),
('M10311920200510165928', 'M24725', 1, 1),
('M10311920200510165928', 'M63091', 1, 1),
('M10311920200510164422', 'K01819', 1, 1),
('M10311920200510164422', 'M96781', 1, 1),
('M10311920200510164422', 'M99764', 1, 1),
('M10311920200510164422', 'M97981', 1, 1),
('M10311920200510164422', 'M99526', 1, 1),
('M10311920200510164422', 'M99765', 1, 1),
('M10311920200510164422', 'M71016', 1, 1),
('M10311920200510164422', 'M62270', 1, 1),
('M10311920200510164422', 'M26299', 1, 1),
('M10311920200510164422', 'M103141', 1, 1),
('M10311920200510164422', 'M143798', 1, 1),
('M10311920200510164422', 'M16532', 1, 1),
('M10311920200510164422', 'M12340', 1, 1),
('M10311920200510164422', 'K00178', 1, 1),
('M10311920200510164422', 'K02090', 1, 1),
('M10311920200510164422', 'M99413', 1, 1),
('M10311920200510164422', 'M126651', 1, 1),
('M10311920200510164422', 'M24725', 1, 1),
('M10311920200510164422', 'M63091', 1, 1),
('M10311920200510164422', 'M139004', 1, 1),
('M10311920200510164422', 'M63086', 1, 1),
('M10311920200510164422', 'K02724', 1, 1),
('M10311920200510164422', 'M157693', 1, 1),
('M10311920200510164422', 'M115642', 1, 1),
('M10311920200510164422', 'M136575', 1, 1),
('M10311920200510164422', 'M16307', 1, 1),
('M10311920200510164422', 'M17923', 1, 1),
('M10311920200510164422', 'M120243', 1, 1),
('M10311920200510164422', 'M140605', 1, 1),
('M10311920200510164422', 'M125769', 1, 1),
('M10311920200510164422', 'M98372', 1, 1),
('M10311920200510164422', 'K01449', 1, 1),
('M10311920200510170147', 'K01819', 1, 1),
('M10311920200510170147', 'M96781', 1, 1),
('M10311920200510170338', 'K01819', 1, 1),
('M10311920200510170338', 'M96781', 1, 1),
('M10311920200510170456', 'K01819', 1, 1),
('M10311920200510170456', 'M96781', 1, 1),
('M10311920200506135949', 'K01819', 1, 1),
('M10311920200508102317', 'K01819', 1, 1),
('M10311920200508102317', 'M103119', 1, 1),
('M10311920200518152118', 'M103119', 1, 1),
('M10311920200518152433', 'M103119', 1, 1),
('K0181920200519090038', 'M103119', 1, 1),
('M9678120200519115654', 'M96781', 1, 1),
('M9678120200519115750', 'M96781', 1, 1),
('M9678120200519115841', 'M96781', 1, 1),
('M9678120200519115750', 'K01819', 1, 1),
('20200518185046', 'K01819', 1, 0),
('20200518185046', 'M103119', 1, 1),
('K0181920200519090038', 'K01819', 1, 1),
('K0181920200518183850', 'M103119', 1, 0),
('M10311920200518181525', 'K00063', 0, 0),
('M10311920200518181525', 'K01819', 1, 0),
('M10311920200518181525', 'M103119', 1, 1),
('K0181920200518181836', 'K01819', 1, 1),
('M10311920200518182000', 'M103119', 1, 1),
('M10311920200518182000', 'K01819', 1, 1),
('K0181920200518183850', 'K01819', 1, 1),
('K0181920200518183850', 'M96781', 1, 0),
('M9678120200519115841', 'K01819', 1, 1),
('M9678120200519115841', 'M103119', 1, 1),
('M9678120200519115654', 'K01819', 1, 1),
('M9678120200519115654', 'M103119', 1, 1),
('K0181920200519142100', 'K01819', 1, 1),
('K0181920200519142100', 'M103119', 1, 1),
('K0181920200519142100', 'M96781', 1, 1),
('K0181920200519172013', 'K01819', 1, 1),
('K0181920200519172013', 'M103119', 1, 1),
('K0181920200520084601', 'K01819', 1, 1),
('K0181920200520084601', 'M103119', 1, 1),
('K0181920200520084601', 'M96781', 1, 1),
('K0181920200520130717', 'K01819', 1, 1),
('K0181920200521202558', 'K01819', 1, 1),
('M10311920200525103358', 'M103119', 1, 1),
('M9678120200527102746', 'M96781', 1, 1),
('M9678120200527102816', 'M96781', 1, 1),
('M9678120200527102912', 'M96781', 1, 1),
('M9678120200527102912', 'K01819', 1, 1),
('M9678120200527103052', 'M96781', 1, 1),
('M9678120200527103215', 'M96781', 1, 1),
('M9678120200527103052', 'K01819', 1, 1),
('K0181920200527161940', 'K01819', 1, 1),
('K0181920200527161940', 'M96781', 1, 1),
('M10311920200601181044', 'M103119', 1, 1),
('K0181920200603093348', 'K01819', 1, 1),
('K0181920200603093348', 'M103119', 1, 1),
('K0181920200603093348', 'K01449', 1, 1),
('K0181920200706121550', 'M98372', 1, 1),
('M10311920200603114218', 'M103119', 1, 1),
('M10311920200603114218', 'K00173', 1, 1),
('M10311920200706112921', 'M103119', 1, 1),
('K0181920200706121550', 'K01819', 1, 1),
('K0181920200706102623', 'K01819', 1, 1),
('K0181920200706102716', 'K01819', 1, 1),
('M10311920200605113604', 'M103119', 1, 1),
('M10311920200616100227', 'M103119', 1, 1),
('M10311920200616100227', 'M96781', 1, 1),
('M10311920200616100227', 'M71016', 1, 1),
('M10311920200616100227', 'M63091', 1, 1),
('M10311920200616100227', 'K01819', 1, 1),
('M10311920200616165755', 'M103119', 1, 1),
('K0181920200706121550', 'M125769', 1, 1),
('M10311920200603114141', 'M103119', 1, 1),
('M10311920200603114141', 'K00173', 1, 1),
('K0181920200706121550', 'K01449', 1, 1),
('K0181920200707144732', 'K01819', 1, 1),
('K0181920200710091635', 'K01819', 1, 1),
('M10311920200710123149', 'M103119', 1, 1),
('M9952620200717095244', 'M99526', 1, 1),
('M10311920200715142645', 'M103141', 1, 1),
('M10311920200715143333', 'M103119', 1, 1),
('M10311920200715143333', 'M99764', 1, 1),
('M10311920200715143333', 'M103141', 1, 1),
('M10311920200715143333', 'M99413', 1, 1),
('M10311920200508102317', 'M99764', 1, 1),
('M10311920200508102317', 'M103141', 1, 1),
('M10311920200508102317', 'M99413', 1, 1),
('20200508172919', 'M99764', 1, 1),
('M9976420200716111858', 'M99764', 1, 1),
('M9976420200716111858', 'M103141', 1, 1),
('M9976420200716111858', 'M99413', 1, 1),
('M9976420200716111858', 'M103119', 1, 1),
('M10311920200715142645', 'M99413', 1, 1),
('M9952620200717095244', 'M103141', 1, 1),
('M9952620200717095244', 'M99413', 1, 1),
('K0181920200728192049', 'K01819', 1, 1),
('K0181920200810185617', 'K01819', 1, 1),
('K0181920200810185617', 'M103119', 1, 1),
('M9941320200825153035', 'M99413', 1, 1),
('M9941320200825153035', 'M99764', 1, 1),
('M9941320200825153035', 'M99526', 1, 1),
('M9941320200825153035', 'M103141', 1, 1),
('M9941320200825153251', 'M99413', 1, 1),
('M9941320200825153524', 'M99413', 1, 1),
('M9941320200825153803', 'M103141', 1, 1),
('M9941320200825153803', 'M99413', 1, 1),
('M9941320200825153803', 'M103119', 1, 1),
('K0181920200901214419', 'K01819', 1, 1),
('K0181920200908134004', 'K01819', 1, 1),
('M10311920200909184938', 'M103119', 1, 1),
('K0181920200914110341', 'K01819', 1, 1),
('M10311920200918111757', 'M103119', 1, 1),
('M10311920200918111757', 'M126651', 1, 1),
('M10311920200918111757', 'M96781', 1, 1),
('M10311920200918111757', 'M97981', 1, 1),
('M10311920200918111757', 'M71016', 1, 1),
('M10311920200918111757', 'M62270', 1, 1),
('M10311920200918111757', 'M26299', 1, 1),
('M10311920200918111757', 'M16532', 1, 1),
('M10311920200918111757', 'M12340', 1, 1),
('M10311920200918111757', 'K00178', 1, 1),
('M10311920200918111757', 'K02090', 1, 1),
('M10311920200918111757', 'M24725', 1, 1),
('M10311920200918111757', 'M63091', 1, 1),
('M10311920200706112921', 'M97981', 1, 1),
('M10311920200706112921', 'M71016', 1, 1),
('M10311920200706112921', 'M126651', 1, 1),
('M10311920200706112921', 'M63091', 1, 1),
('M10311920200918124625', 'K01819', 1, 1),
('M10311920200918124625', 'M103119', 1, 1),
('M10311920200918124625', 'M126651', 1, 1),
('K0181920201007104611', 'K01819', 1, 1),
('M10311920201020120255', 'M103119', 1, 1),
('M10311920201020133640', 'M24725', 1, 1),
('M10311920201020133640', 'M126651', 1, 1),
('M10311920201020133640', 'M71016', 1, 1),
('M10311920201020133640', 'M62270', 1, 1),
('M10311920201020133640', 'M16532', 1, 1),
('M10311920201020133640', 'M12340', 1, 1),
('M10311920201020133640', 'K00178', 1, 1),
('M10311920201020133640', 'M99413', 1, 1),
('M10311920201020133640', 'K01819', 1, 1),
('M10311920201020133640', 'M103119', 1, 1),
('M10311920201020133640', 'M96781', 1, 1),
('M10311920201020133640', 'M97981', 1, 1),
('M10311920201020133640', 'M63091', 1, 1),
('M9798120201020164923', 'M96781', 1, 1),
('M9798120201020164923', 'M97981', 1, 1),
('M9798120201020164923', 'M71016', 1, 1),
('M9798120201020164923', 'K00178', 1, 1),
('K0017820201020165755', 'K00178', 1, 1),
('K0017820201020165938', 'K00178', 1, 1),
('M9798120201020164923', 'M126651', 1, 1),
('M9798120201020164923', 'M63091', 1, 1),
('M9798120201020164923', 'K01819', 1, 1),
('M1234020201104114925', 'M62270', 1, 1),
('K0181920201021105059', 'K01819', 1, 1),
('K0181920201021105224', 'K01819', 1, 1),
('K0181920201021105224', 'M96781', 1, 1),
('K0181920201021105224', 'M97981', 1, 1),
('K0181920201021105224', 'M71016', 1, 1),
('K0181920201021105224', 'M62270', 1, 1),
('K0181920201021105224', 'M26299', 1, 1),
('K0181920201021105224', 'M16532', 1, 1),
('K0181920201021105224', 'M12340', 1, 1),
('K0181920201021105224', 'K00178', 1, 1),
('K0181920201021105224', 'K02090', 1, 1),
('K0181920201021105224', 'M126651', 1, 1),
('K0181920201021105224', 'M103119', 1, 1),
('K0181920201021105224', 'M24725', 1, 1),
('K0181920201021105224', 'M63091', 1, 1),
('K0181920201021105431', 'K01819', 1, 1),
('K0181920201021105431', 'M96781', 1, 1),
('K0181920201021105431', 'M97981', 1, 1),
('K0181920201021105431', 'M71016', 1, 1),
('K0181920201021105431', 'M62270', 1, 1),
('K0181920201021105431', 'M26299', 1, 1),
('K0181920201021105431', 'M16532', 1, 1),
('K0181920201021105431', 'M12340', 1, 1),
('K0181920201021105431', 'K00178', 1, 1),
('K0181920201021105431', 'K02090', 1, 1),
('K0181920201021105431', 'M126651', 1, 1),
('K0181920201021105431', 'M103119', 1, 1),
('K0181920201021105431', 'M24725', 1, 1),
('K0181920201021105431', 'M63091', 1, 1),
('M1234020201021105945', 'M12340', 1, 1),
('M1234020201021110152', 'M12340', 1, 1),
('M9798120201021131949', 'M97981', 1, 1),
('M9798120201021132151', 'M97981', 1, 1),
('M9798120201021132259', 'M97981', 1, 1),
('M9798120201021132429', 'M97981', 1, 1),
('M9798120201021132429', 'K01819', 1, 1),
('M1234020201022105241', 'M12340', 1, 1),
('M1234020201022105241', 'M96781', 1, 1),
('M1234020201022105241', 'M99526', 1, 1),
('M1234020201022105241', 'M71016', 1, 1),
('M1234020201022105241', 'M62270', 1, 1),
('M1234020201022105241', 'M26299', 1, 1),
('M1234020201022105241', 'M16532', 1, 1),
('M1234020201022105241', 'K00178', 1, 1),
('M1234020201022105241', 'K02090', 1, 1),
('M1234020201022105241', 'M126651', 1, 1),
('M1234020201022105241', 'M103119', 1, 1),
('M1234020201022105241', 'M24725', 1, 1),
('M1234020201022105241', 'M63091', 1, 1),
('K0017820201020165755', 'M96781', 1, 1),
('K0017820201020165755', 'M97981', 1, 1),
('K0017820201020165755', 'M99526', 1, 1),
('K0017820201020165755', 'M71016', 1, 1),
('K0017820201020165755', 'M62270', 1, 1),
('K0017820201020165755', 'M16532', 1, 1),
('K0017820201020165755', 'M12340', 1, 1),
('K0017820201020165755', 'M99413', 1, 1),
('K0017820201020165755', 'M126651', 1, 1),
('K0017820201020165755', 'M103119', 1, 1),
('M1234020201022110143', 'M12340', 1, 1),
('M1234020201022110143', 'M96781', 1, 1),
('M1234020201022110143', 'M97981', 1, 1),
('M1234020201022110143', 'M71016', 1, 1),
('M1234020201022110143', 'M62270', 1, 1),
('M1234020201022110143', 'M26299', 1, 1),
('M1234020201022110143', 'M16532', 1, 1),
('M1234020201022110143', 'K00178', 1, 1),
('M1234020201022110143', 'M126651', 1, 1),
('M1234020201022110143', 'M24725', 1, 1),
('M1234020201022110143', 'M63091', 1, 1),
('M1234020201022111620', 'M12340', 1, 1),
('M1234020201022111620', 'M96781', 1, 1),
('M1234020201022111620', 'M97981', 1, 1),
('M1234020201022111620', 'M71016', 1, 1),
('M1234020201022111620', 'M26299', 1, 1),
('M1234020201022111620', 'K00178', 1, 1),
('M1234020201022111620', 'K02090', 1, 1),
('M1234020201022111620', 'M126651', 1, 1),
('M1234020201022111620', 'M24725', 1, 1),
('M1234020201022111620', 'M63091', 1, 1),
('M1234020201022112024', 'M126651', 1, 1),
('M1234020201022112024', 'M97981', 1, 1),
('M1234020201022112024', 'M62270', 1, 1),
('M1234020201022112024', 'M16532', 1, 1),
('M1234020201022112024', 'M12340', 1, 1),
('M1234020201022112024', 'K02090', 1, 1),
('M1234020201022112159', 'M12340', 1, 1),
('M1234020201022112159', 'M97981', 1, 1),
('M1234020201022112159', 'M71016', 1, 1),
('M1234020201022112159', 'M62270', 1, 1),
('M1234020201022112159', 'M16532', 1, 1),
('M1234020201022112159', 'K00178', 1, 1),
('M1234020201022112159', 'K02090', 1, 1),
('M1234020201022112159', 'M126651', 1, 1),
('M1234020201022112159', 'M24725', 1, 1),
('M1234020201022112159', 'M63091', 1, 1),
('M1234020201022112422', 'M126651', 1, 1),
('M1234020201022112422', 'M97981', 1, 1),
('M1234020201022112422', 'M71016', 1, 1),
('M1234020201022112422', 'M62270', 1, 1),
('M1234020201022112422', 'M16532', 1, 1),
('M1234020201022112422', 'M12340', 1, 1),
('M1234020201022112422', 'K00178', 1, 1),
('M1234020201022112422', 'K02090', 1, 1),
('M1234020201022112422', 'M24725', 1, 1),
('M1234020201022112422', 'M63091', 1, 1),
('M1234020201022112714', 'M12340', 1, 1),
('M1234020201022112714', 'M96781', 1, 1),
('M1234020201022112714', 'M99526', 1, 1),
('M1234020201022112714', 'M62270', 1, 1),
('M1234020201022112714', 'M26299', 1, 1),
('M1234020201022112714', 'M103141', 1, 1),
('M1234020201022112714', 'M16532', 1, 1),
('M1234020201022112714', 'K00178', 1, 1),
('M1234020201022112714', 'K02090', 1, 1),
('M1234020201022112714', 'M99413', 1, 1),
('M1234020201022112714', 'M126651', 1, 1),
('M1234020201022112714', 'M24725', 1, 1),
('M1234020201022112714', 'M63091', 1, 1),
('M1234020201022113204', 'M12340', 1, 1),
('M1234020201022113204', 'M97981', 1, 1),
('M1234020201022113204', 'M62270', 1, 1),
('M1234020201022113204', 'M16532', 1, 1),
('M1234020201022113204', 'K02090', 1, 1),
('M1234020201022113204', 'M126651', 1, 1),
('M1234020201022113204', 'M24725', 1, 1),
('M1234020201022113204', 'M63091', 1, 1),
('M1234020201022113548', 'M12340', 1, 1),
('M1234020201022113548', 'M96781', 1, 1),
('M1234020201022113548', 'M99764', 1, 1),
('M1234020201022113548', 'M97981', 1, 1),
('M1234020201022113548', 'M99526', 1, 1),
('M1234020201022113548', 'M99765', 1, 1),
('M1234020201022113548', 'M71016', 1, 1),
('M1234020201022113548', 'M62270', 1, 1),
('M1234020201022113548', 'M26299', 1, 1),
('M1234020201022113548', 'M103141', 1, 1),
('M1234020201022113548', 'M143798', 1, 1),
('M1234020201022113548', 'M16532', 1, 1),
('M1234020201022113548', 'K00178', 1, 1),
('M1234020201022113548', 'K02090', 1, 1),
('M1234020201022113548', 'M99413', 1, 1),
('M1234020201022113548', 'M126651', 1, 1),
('M1234020201022113548', 'M103119', 1, 1),
('M1234020201022113548', 'M24725', 1, 1),
('M1234020201022113548', 'M63091', 1, 1),
('K0017820201022114636', 'M99413', 1, 1),
('K0017820201022114636', 'K00178', 1, 1),
('K0017820201022114636', 'M12340', 1, 1),
('K0017820201022114636', 'M96781', 1, 1),
('K0017820201022114636', 'M97981', 1, 1),
('K0017820201022114636', 'M99526', 1, 1),
('K0017820201022114636', 'M71016', 1, 1),
('K0017820201022114636', 'M62270', 1, 1),
('K0017820201022114636', 'M16532', 1, 1),
('K0017820201022114636', 'M126651', 1, 1),
('K0017820201022114636', 'M103119', 1, 1),
('M1234020201022125436', 'M126651', 1, 1),
('M1234020201022125436', 'M97981', 1, 1),
('M1234020201022125436', 'M71016', 1, 1),
('M1234020201022125436', 'M62270', 1, 1),
('M1234020201022125436', 'M26299', 1, 1),
('M1234020201022125436', 'M12340', 1, 1),
('M1234020201022125436', 'K02090', 1, 1),
('M1234020201022112024', 'M24725', 1, 1),
('M1234020201022112024', 'M63091', 1, 1),
('M1234020201022112024', 'K00178', 1, 1),
('M1234020201022125436', 'M24725', 1, 1),
('M1234020201022125436', 'M63091', 1, 1),
('M1234020201022125436', 'K00178', 1, 1),
('M1234020201022142013', 'M12340', 1, 1),
('M1234020201022142013', 'M62270', 1, 1),
('M1234020201022142128', 'M12340', 1, 1),
('M1234020201022142128', 'M62270', 1, 1),
('M1234020201022142128', 'M16532', 1, 1),
('M1234020201022142128', 'M24725', 1, 1),
('M1234020201022142303', 'M12340', 1, 1),
('M1234020201022142303', 'M62270', 1, 1),
('M1234020201022142303', 'M16532', 1, 1),
('M1234020201022142303', 'M24725', 1, 1),
('M1234020201022142416', 'M12340', 1, 1),
('M1234020201022142527', 'M12340', 1, 1),
('M1234020201022142706', 'M12340', 1, 1),
('M1234020201022142013', 'M24725', 1, 1),
('M1234020201022142013', 'K01819', 1, 1),
('M9798120201023141706', 'M97981', 1, 1),
('M9798120201023141706', 'M96781', 1, 1),
('M9798120201023141706', 'K01819', 1, 1),
('K0181920201028202055', 'K01819', 1, 1),
('K0181920201029134553', 'K01819', 1, 1),
('K0181920201029134553', 'K31897', 1, 1),
('M1234020201104114925', 'M12340', 1, 1),
('M1234020201104114925', 'M16532', 1, 1),
('M1234020201104114925', 'M24725', 1, 1),
('M9798120201106162446', 'M97981', 1, 1),
('M9798120201207190352', 'M96781', 1, 1),
('K0003820201106175948', 'K00038', 1, 1),
('K0003820201106175948', 'K01819', 1, 1),
('K3189720201110131426', 'K31897', 1, 1),
('K3189720201112111737', 'K31897', 1, 1),
('K0181920201113140515', 'K01819', 1, 1),
('K0181920201113140515', 'M96781', 1, 1),
('K0181920201113140515', 'M99764', 1, 1),
('K0181920201113140515', 'M97981', 1, 1),
('K0181920201113140515', 'M99526', 1, 1),
('K0181920201113140515', 'M99765', 1, 1),
('K0181920201113140515', 'M71016', 1, 1),
('K0181920201113140515', 'M62270', 1, 1),
('K0181920201113140515', 'M26299', 1, 1),
('K0181920201113140515', 'M103141', 1, 1),
('K0181920201113140515', 'M143798', 1, 1),
('K0181920201113140515', 'M16532', 1, 1),
('K0181920201113140515', 'M12340', 1, 1),
('K0181920201113140515', 'K00178', 1, 1),
('K0181920201113140515', 'K02090', 1, 1),
('K0181920201113140515', 'M99413', 1, 1),
('K0181920201113140515', 'M126651', 1, 1),
('K0181920201113140515', 'M103119', 1, 1),
('K0181920201113140515', 'M24725', 1, 1),
('K0181920201113140515', 'M63091', 1, 1),
('K0181920201113144508', 'K01819', 1, 1),
('K0181920201113144508', 'M96781', 1, 1),
('K0181920201113144508', 'M103119', 1, 1),
('K0017820201116093044', 'K00178', 1, 1),
('K0181920201116190308', 'K01819', 1, 1),
('K0181920201116190308', 'K31897', 1, 1),
('K0181920201116190913', 'K01819', 1, 1),
('K0181920201116190913', 'M103119', 1, 1),
('K0181920201116190913', 'K31897', 1, 1),
('K0181920201116191639', 'M103119', 1, 1),
('K0181920201116191639', 'K01819', 1, 1),
('K0181920201116191639', 'K00063', 1, 1),
('K0181920201116191639', 'K31897', 1, 1),
('K0181920201116190308', 'M103119', 1, 1),
('K0181920201116190308', 'K00063', 1, 1),
('K0181920201116191639', 'K14379', 1, 1),
('K0181920201116191639', 'K00038', 1, 1),
('M10311920201118085056', 'M103119', 1, 1),
('M10311920201118085056', 'K01819', 1, 1),
('M10311920201118085056', 'K00063', 1, 1),
('K0181920201119194624', 'K01819', 1, 1),
('M9678120201127094319', 'M96781', 1, 1),
('M9678120201127094319', 'K01819', 1, 1),
('M10311920201202110013', 'M103119', 1, 1),
('M9798120201207190352', 'M97981', 1, 1),
('M9798120201207190352', 'K01819', 1, 1),
('K0218420201211134409', 'K02184', 1, 1),
('K0218420201211134455', 'K02184', 1, 1),
('K0218420201211134545', 'K02184', 1, 1),
('K0218420201211134620', 'K02184', 1, 1),
('K0218420201211134707', 'K02184', 1, 1),
('K0218420201211134736', 'K02184', 1, 1),
('K0218420201211134807', 'K02184', 1, 1),
('K0218420201211134853', 'K02184', 1, 1),
('K0218420201211135421', 'K02184', 1, 1),
('K0218420201211135502', 'K02184', 1, 1),
('K0218420201211135540', 'K02184', 1, 1),
('K0218420201211135613', 'K02184', 1, 1),
('K0218420201211135707', 'K02184', 1, 1),
('K0218420201211135745', 'K02184', 1, 1),
('K0218420201211135822', 'K02184', 1, 1),
('K0218420201211135910', 'K02184', 1, 1),
('K0218420201211135948', 'K02184', 1, 1),
('K0218420201211140107', 'K02184', 1, 1),
('K0218420201211141335', 'K02184', 1, 1),
('K0015320201211141415', 'K00153', 1, 1),
('K0015320201211141623', 'K00153', 1, 1),
('K0218420201211142448', 'K02184', 1, 1),
('M9034920201211142501', 'M90349', 1, 1),
('K0218420201211142643', 'K02184', 1, 1),
('K0218420201211142856', 'K02184', 1, 1),
('M1269120201214112159', 'M12691', 1, 1),
('M10311920201214143255', 'M103119', 1, 1),
('M1234020201214153423', 'M12340', 1, 1),
('M1234020201214153423', 'M96781', 1, 1),
('M1234020201214153423', 'M16532', 1, 1),
('M1234020201214153423', 'K00178', 1, 1),
('K0108920201214183417', 'K01089', 1, 1),
('K0108920201214183515', 'K01089', 1, 1),
('K0218420201215114304', 'K02184', 1, 1),
('K0181920201216172549', 'K01819', 1, 1),
('K0218420201216101137', 'K02184', 1, 1),
('K0218420201216104339', 'K02184', 1, 1),
('K0218420201216110235', 'K02184', 1, 1),
('K0218420201216113109', 'K02184', 1, 1),
('K0218420201216114203', 'K02184', 1, 1),
('K0218420201216114932', 'K02184', 1, 1),
('K0218420201216115453', 'K02184', 1, 1),
('K0181920201216172549', 'M103119', 1, 1),
('K0181920201216172549', 'K01449', 1, 1),
('K0181920201216172549', 'M63086', 1, 1),
('K0181920201216172549', 'K00063', 1, 1),
('M11157620201216203731', 'M111576', 1, 1),
('K0017820201217104213', 'K00178', 1, 1),
('K0017820201217104213', 'M96781', 1, 1),
('K0017820201217104213', 'M97981', 1, 1),
('K0017820201217104213', 'M71016', 1, 1),
('K0017820201217104213', 'M62270', 1, 1),
('K0017820201217104213', 'M16532', 1, 1),
('K0017820201217104213', 'M12340', 1, 1),
('K0017820201217104213', 'M126651', 1, 1),
('K0017820201217104213', 'M103119', 1, 1),
('K0017820201217104213', 'M24725', 1, 1),
('K0017820201217104213', 'M63091', 1, 1),
('K0017820201217105815', 'K00178', 1, 1),
('M13233120201217130429', 'M132331', 1, 1),
('M13233120201217130541', 'M132331', 1, 1),
('M13233120201217130644', 'M132331', 1, 1),
('K0218420201217131021', 'K02184', 1, 1);

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

--
-- Estructura de tabla para la tabla `participantesEXTN`
--

CREATE TABLE IF NOT EXISTS `participantesEXTN` (
  `ID` varchar(32) NOT NULL,
  `nombre` varchar(64) NOT NULL,
  `confirmado` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `participantesEXTN` (`ID`, `nombre`, `confirmado`) VALUES
('M10311920201118085056', 'Javier Allende', 1),
('M10311920200518112207', 'Gracia Minguez', 1),
('M10311920201118085056', 'Benito Carrera', 1),
('M10311920201118085056', 'Sergio Fernandez', 1);

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

--
-- Estructura de tabla para la tabla `reuniones`
--

CREATE TABLE IF NOT EXISTS `reuniones` (
  `meta` varchar(15) NOT NULL,
  `idReunion` varchar(32) NOT NULL,
  `propietario` varchar(15) NOT NULL,
  `lugar` varchar(32) NOT NULL,
  `titulo` varchar(64) NOT NULL,
  `descripcion` varchar(256) NOT NULL,
  `fcreacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `fMeet` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ffMeet` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `reuniones` (`meta`, `idReunion`, `propietario`, `lugar`, `titulo`, `descripcion`, `fcreacion`, `fMeet`, `ffMeet`) VALUES
('M103119', 'M10311920201118085056', 'M103119', 'google meet', 'Integración Gestión de Activos con Meta4', 'Integración Gestion de Activos con Meta4', '2020-11-18 07:50:56', '2020-11-18 09:00:00', '2020-11-18 10:00:00'),
('K01819', 'K0181920200518183850', 'K01819', 'Video Call', 'Eficiencias SGO', 'Eficiencias Junio 20', '2020-05-18 16:38:50', '2020-05-22 09:05:00', '2020-05-22 10:05:00'),
('M103119', 'M10311920200518181525', 'M103119', 'Avda. Industria', 'Fin COVID-19', 'Fiesta fin confinamiento', '2020-05-18 16:15:25', '2020-06-15 08:00:00', '2020-06-15 17:00:00'),
('K31897', 'K3189720201112111737', 'K31897', 'asdfa', 'asdf', 'asdfasdf', '2020-11-12 10:17:37', '2020-11-12 10:11:00', '2020-11-12 10:11:00'),
('K00153', 'K0015320201211141415', 'K00153', 'POR MEET', 'KONOCERTE', 'COUCHING', '2020-12-11 13:14:15', '2020-12-15 09:00:00', '2020-12-15 13:12:00');

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

--
-- Estructura de tabla para la tabla `seguimiento`
--

CREATE TABLE IF NOT EXISTS `seguimiento` (
  `id` varchar(32) NOT NULL,
  `meta` varchar(15) NOT NULL,
  `fecha` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `seguimiento` (`id`, `meta`, `fecha`) VALUES
('M10311920200518182000', 'M103119', '2020-06-04 15:52:45'),
('M10311920200518152433', 'M103119', '2020-06-04 15:52:58'),
('M10311920200508185438', 'M103119', '2020-06-05 07:08:11'),
('M10311920200506154610', 'M103119', '2020-06-05 08:58:47'),
('M10311920200506160203', 'M103119', '2020-06-05 08:58:54'),
('M10311920200508190947', 'M103119', '2020-06-05 08:59:36'),
('M10311920200508102317', 'M103119', '2020-06-05 08:59:47'),
('M10311920200510164422', 'M103119', '2020-06-05 09:00:27'),
('K0181920200603093348', 'M103119', '2020-06-05 09:00:51'),
('M10311920200518182000', 'M103119', '2020-06-05 09:01:26'),
('M10311920200518181525', 'M103119', '2020-06-05 09:01:51'),
('K0181920200518183850', 'M103119', '2020-06-05 09:02:04'),
('M10311920200518181525', 'M103119', '2020-06-05 09:02:19'),
('M10311920200605113604', 'M103119', '2020-06-05 09:36:08'),
('M10311920200605113604', 'M103119', '2020-06-05 09:41:36'),
('M10311920200605113604', 'M103119', '2020-06-05 09:43:26'),
('M10311920200605113604', 'M103119', '2020-06-06 11:21:09'),
('M10311920200605113604', 'M103119', '2020-06-07 07:28:12'),
('M10311920200605113604', 'M103119', '2020-06-08 08:02:12'),
('K0181920200603093348', 'K01819', '2020-06-08 14:42:07'),
('M10311920200506140217', 'M103119', '2020-06-08 15:48:58'),
('M10311920200506140217', 'M103119', '2020-06-08 15:52:22'),
('M10311920200518182000', 'M103119', '2020-06-10 09:26:34'),
('M10311920200508191757', 'M103119', '2020-06-10 09:26:45'),
('M10311920200508185507', 'M103119', '2020-06-10 09:27:01'),
('M10311920200508191757', 'M103119', '2020-06-10 09:27:10'),
('M10311920200508191852', 'M103119', '2020-06-10 09:27:20'),
('M10311920200508191757', 'M103119', '2020-06-10 09:27:28'),
('M10311920200514091111', 'M103119', '2020-06-10 10:53:36'),
('M10311920200514091111', 'M103119', '2020-06-10 10:54:28'),
('M10311920200514091111', 'M103119', '2020-06-10 10:56:54'),
('M10311920200514091111', 'M103119', '2020-06-10 11:14:55'),
('M10311920200514091111', 'M103119', '2020-06-10 11:32:23'),
('M10311920200508191757', 'M103119', '2020-06-10 11:49:41'),
('M10311920200508191757', 'M103119', '2020-06-10 11:59:09'),
('M10311920200508185438', 'M103119', '2020-06-12 10:31:10'),
('M9678120200527102746', 'M96781', '2020-06-15 16:14:15'),
('M10311920200508185438', 'M103119', '2020-06-16 07:44:51'),
('M10311920200525103358', 'M103119', '2020-06-16 08:02:31'),
('M10311920200616100227', 'M103119', '2020-06-16 08:02:40'),
('M10311920200616100227', 'M103119', '2020-06-16 08:05:01'),
('M10311920200616100227', 'M103119', '2020-06-16 08:05:03'),
('M10311920200616100227', 'M103119', '2020-06-16 08:05:12'),
('M10311920200616100227', 'M103119', '2020-06-16 08:06:23'),
('M10311920200616100227', 'M103119', '2020-06-16 10:14:10'),
('M10311920200616100227', 'M103119', '2020-06-16 10:15:22'),
('M10311920200514091111', 'M103119', '2020-06-16 10:59:27'),
('M10311920200616165755', 'M103119', '2020-06-16 14:57:59'),
('M10311920200525103358', 'M103119', '2020-06-17 10:17:18'),
('M10311920200616100227', 'M103119', '2020-06-17 10:17:24'),
('M10311920200616100227', 'M103119', '2020-06-22 14:55:20'),
('M10311920200525103358', 'M103119', '2020-06-22 14:55:54'),
('K0181920200518181836', 'K01819', '2020-06-23 11:55:48'),
('M10311920200506161227', 'M103119', '2020-06-25 11:39:41'),
('M10311920200603114141', 'M103119', '2020-06-25 11:40:10'),
('M10311920200508102317', 'M103119', '2020-06-25 11:40:43'),
('M10311920200508190947', 'M103119', '2020-06-25 11:41:37'),
('M10311920200510170147', 'M103119', '2020-06-25 11:41:55'),
('M10311920200510165928', 'M103119', '2020-06-25 11:42:06'),
('M10311920200518182000', 'M103119', '2020-06-25 11:42:35'),
('M10311920200603114141', 'M103119', '2020-06-25 11:43:57'),
('K0181920200518181836', 'K01819', '2020-06-29 08:51:04'),
('M10311920200518182000', 'M103119', '2020-07-03 07:26:43'),
('M10311920200525103358', 'M103119', '2020-07-03 07:30:06'),
('M9678120200527103215', 'M96781', '2020-07-03 10:03:53'),
('K0181920200706102623', 'K01819', '2020-07-06 08:26:30'),
('M10311920200506160203', 'M103119', '2020-07-06 09:22:35'),
('M10311920200506135949', 'M103119', '2020-07-06 09:23:46'),
('K0181920200706121550', 'K01819', '2020-07-06 10:15:59'),
('K0181920200706121550', 'M125769', '2020-07-06 10:17:07'),
('M10311920200506160553', 'K01819', '2020-07-06 10:17:20'),
('M10311920200525103358', 'M103119', '2020-07-06 10:58:32'),
('M10311920200510165928', 'M103119', '2020-07-06 14:21:22'),
('M10311920200510165928', 'M103119', '2020-07-06 14:48:27'),
('M10311920200510165928', 'M103119', '2020-07-06 14:48:43'),
('M10311920200605113604', 'M103119', '2020-07-07 08:51:52'),
('M10311920200601181044', 'M103119', '2020-07-07 08:52:05'),
('M10311920200508174604', 'M103119', '2020-07-07 08:54:09'),
('M10311920200514091111', 'M103119', '2020-07-07 12:42:45'),
('M9678120200527102912', 'K01819', '2020-07-07 12:47:43'),
('M10311920200508191757', 'M103119', '2020-07-07 15:57:51'),
('M10311920200710123149', 'M103119', '2020-07-10 10:34:42'),
('20200508172919', 'M103119', '2020-07-14 14:35:20'),
('M10311920200601181044', 'M103119', '2020-07-14 15:26:20'),
('M10311920200506160203', 'K01819', '2020-07-15 08:38:57'),
('M10311920200506160203', 'M103119', '2020-07-15 12:21:41'),
('M10311920200506135949', 'M103119', '2020-07-15 12:23:48'),
('20200508172919', 'M103119', '2020-07-15 12:23:57'),
('M10311920200715142645', 'M103119', '2020-07-15 12:26:51'),
('M10311920200511154422', 'M103119', '2020-07-15 12:26:56'),
('M10311920200715142645', 'M103119', '2020-07-15 12:26:58'),
('M10311920200511154422', 'M103119', '2020-07-15 12:27:03'),
('M10311920200715142645', 'M103119', '2020-07-15 12:27:15'),
('M10311920200715142645', 'M103119', '2020-07-15 12:28:14'),
('M10311920200715143333', 'M103119', '2020-07-15 12:33:36'),
('M10311920200715143333', 'M103119', '2020-07-15 12:34:12'),
('M10311920200506135949', 'M103119', '2020-07-15 12:34:26'),
('20200508172919', 'M103119', '2020-07-15 12:34:31'),
('M10311920200715143333', 'M103119', '2020-07-15 12:34:59'),
('M10311920200715143333', 'M103119', '2020-07-15 12:38:53'),
('M10311920200605113604', 'M103119', '2020-07-15 12:38:57'),
('M10311920200508102317', 'M103119', '2020-07-15 12:39:17'),
('K0181920200518183850', 'M103119', '2020-07-15 12:41:05'),
('M10311920200518181525', 'M103119', '2020-07-15 12:41:22'),
('K0181920200518183850', 'M103119', '2020-07-15 12:41:45'),
('M10311920200508102317', 'M103119', '2020-07-15 12:42:23'),
('M10311920200506140217', 'M103119', '2020-07-15 12:43:15'),
('M10311920200506135949', 'M103119', '2020-07-16 09:03:20'),
('M10311920200715143333', 'M99764', '2020-07-16 09:04:59'),
('M10311920200508102317', 'M99764', '2020-07-16 09:05:13'),
('M10311920200715143333', 'M99764', '2020-07-16 09:05:32'),
('M10311920200715142645', 'M99764', '2020-07-16 09:05:47'),
('M10311920200715142645', 'M103119', '2020-07-16 09:06:03'),
('20200508172919', 'M103119', '2020-07-16 09:09:19'),
('20200508172919', 'M99764', '2020-07-16 09:09:51'),
('20200508172919', 'M103119', '2020-07-16 09:10:26'),
('M9976420200716111858', 'M99764', '2020-07-16 09:19:19'),
('M9976420200716111858', 'M99764', '2020-07-16 09:19:49'),
('M10311920200715142645', 'M103119', '2020-07-16 09:20:00'),
('', 'M103119', '2020-07-16 09:20:45'),
('M10311920200715142645', 'M103119', '2020-07-16 09:21:32'),
('M10311920200715143333', 'M103119', '2020-07-16 09:22:27'),
('M10311920200715143333', 'M99764', '2020-07-16 09:22:30'),
('20200508172919', 'M103119', '2020-07-16 09:33:08'),
('20200508172919', 'M99764', '2020-07-16 09:34:10'),
('M10311920200715142645', 'M103119', '2020-07-16 10:09:19'),
('M10311920200715142645', 'M103119', '2020-07-16 10:10:25'),
('M9976420200716111858', 'M99413', '2020-07-16 10:42:57'),
('K0181920200518181836', 'K01819', '2020-07-16 11:38:19'),
('K0181920200527161940', 'K01819', '2020-07-16 11:39:05'),
('K0181920200521202558', 'K01819', '2020-07-16 11:39:09'),
('M10311920200508102317', 'K01819', '2020-07-16 11:39:12'),
('K0181920200520084601', 'K01819', '2020-07-16 11:39:36'),
('K0181920200603093348', 'K01819', '2020-07-16 11:39:44'),
('M9976420200716111858', 'M103119', '2020-07-16 11:57:30'),
('20200508172919', 'M103119', '2020-07-16 11:57:44'),
('M10311920200518152433', 'M103119', '2020-07-16 11:58:16'),
('M10311920200525103358', 'M103119', '2020-07-16 11:58:33'),
('K0181920200518181836', 'K01819', '2020-07-16 12:05:55'),
('M10311920200715143333', 'M103119', '2020-07-16 13:31:52'),
('M10311920200510170147', 'M103119', '2020-07-16 13:32:45'),
('M10311920200518152433', 'M103119', '2020-07-16 13:33:02'),
('K0181920200518183850', 'M103119', '2020-07-16 13:33:22'),
('M10311920200715143333', 'M103119', '2020-07-16 13:51:20'),
('M9678120200519115841', 'M103119', '2020-07-16 13:53:20'),
('M10311920200715143333', 'M103119', '2020-07-16 14:15:49'),
('M10311920200715143333', 'M103119', '2020-07-16 14:39:12'),
('M10311920200715143333', 'M103119', '2020-07-16 14:40:06'),
('M10311920200715143333', 'M103119', '2020-07-16 14:40:54'),
('M10311920200715143333', 'M103119', '2020-07-16 14:41:59'),
('', 'M103119', '2020-07-16 14:42:11'),
('', 'M103119', '2020-07-16 14:42:12'),
('M10311920200508102317', 'M103119', '2020-07-16 14:42:59'),
('M10311920200706112921', 'M103119', '2020-07-16 14:57:44'),
('M10311920200715143333', 'M103119', '2020-07-16 14:57:58'),
('M10311920200518152433', 'M103119', '2020-07-16 15:04:47'),
('M10311920200525103358', 'M103119', '2020-07-16 15:08:03'),
('M9952620200717095244', 'M99526', '2020-07-17 07:53:01'),
('M10311920200506181314', 'M103119', '2020-07-17 07:53:03'),
('M10311920200506181314', 'M103119', '2020-07-17 07:53:18'),
('M9952620200717095244', 'M99526', '2020-07-17 07:53:32'),
('M10311920200506181314', 'M103119', '2020-07-17 07:55:08'),
('M9952620200717095244', 'M99526', '2020-07-17 07:55:09'),
('M10311920200506160804', 'M96781', '2020-07-17 09:12:33'),
('M10311920200715143333', 'M103119', '2020-07-17 09:54:09'),
('M10311920200715143333', 'M103119', '2020-07-17 09:59:07'),
('M10311920200715143333', 'M103119', '2020-07-17 10:02:22'),
('K0181920200518181836', 'K01819', '2020-07-17 10:13:24'),
('K0181920200518181836', 'K01819', '2020-07-17 10:13:38'),
('M10311920200506181314', 'M103119', '2020-07-20 10:06:38'),
('M9976420200716111858', 'M103119', '2020-07-22 07:41:54'),
('M10311920200506181314', 'M103119', '2020-07-22 07:42:38'),
('M10311920200616165755', 'M103119', '2020-07-22 08:54:36'),
('M10311920200616165755', 'M103119', '2020-07-22 09:49:08'),
('M10311920200715143333', 'M103119', '2020-07-22 10:01:09'),
('M10311920200616165755', 'M103119', '2020-07-22 10:01:31'),
('M10311920200510170147', 'M103119', '2020-07-22 10:07:02'),
('M10311920200510171729', 'M103119', '2020-07-22 10:07:18'),
('M10311920200510171729', 'M103119', '2020-07-22 10:07:26'),
('M10311920200508190947', 'M103119', '2020-07-22 13:55:30'),
('M10311920200508190947', 'M103119', '2020-07-22 13:58:17'),
('M10311920200715143333', 'M103119', '2020-07-22 13:58:54'),
('M10311920200715143333', 'M103119', '2020-07-22 14:32:22'),
('M10311920200715143333', 'M103119', '2020-07-22 14:34:24'),
('M10311920200715143333', 'M103119', '2020-07-22 14:35:50'),
('M10311920200715143333', 'M103119', '2020-07-22 14:43:44'),
('M10311920200715143333', 'M103119', '2020-07-22 14:44:30'),
('M10311920200715143333', 'M103119', '2020-07-22 14:48:41'),
('M10311920200508102317', 'M103119', '2020-07-22 15:03:47'),
('M10311920200508190947', 'M103119', '2020-07-22 15:04:06'),
('M10311920200508190947', 'M103119', '2020-07-22 15:05:02'),
('M10311920200508190947', 'M103119', '2020-07-22 15:09:39'),
('M10311920200508190947', 'M103119', '2020-07-22 15:10:51'),
('M10311920200508190947', 'M103119', '2020-07-22 15:12:57'),
('M10311920200508190947', 'M103119', '2020-07-22 15:14:22'),
('M10311920200508190947', 'M103119', '2020-07-22 15:33:06'),
('M10311920200508190947', 'M103119', '2020-07-22 15:33:58'),
('M10311920200508190947', 'M103119', '2020-07-22 15:40:30'),
('M10311920200508190947', 'M103119', '2020-07-22 15:42:38'),
('M10311920200510171729', 'M103119', '2020-07-22 15:45:07'),
('M10311920200510171729', 'M103119', '2020-07-22 15:46:19'),
('M10311920200518112207', 'M103119', '2020-07-22 15:49:31'),
('M10311920200518112207', 'M103119', '2020-07-22 15:51:31'),
('M10311920200518112207', 'M103119', '2020-07-22 15:52:21'),
('M10311920200605113604', 'M103119', '2020-07-22 15:53:24'),
('M10311920200601181044', 'M103119', '2020-07-22 15:59:26'),
('M10311920200601181044', 'M103119', '2020-07-22 16:01:34'),
('M10311920200601181044', 'M103119', '2020-07-22 16:02:54'),
('M10311920200510171729', 'M103119', '2020-07-22 16:06:15'),
('M10311920200510170147', 'M103119', '2020-07-22 16:06:46'),
('M10311920200510170147', 'M103119', '2020-07-22 16:23:02'),
('M10311920200510164422', 'M103119', '2020-07-22 16:23:21'),
('K0181920200706102716', 'K01819', '2020-07-23 08:01:16'),
('K0181920200521202558', 'K01819', '2020-07-28 17:44:35'),
('20200518185046', 'K01819', '2020-07-28 17:45:28'),
('M10311920200506160804', 'K01819', '2020-07-28 17:45:40'),
('K0181920200527161940', 'K01819', '2020-07-28 17:45:57'),
('M10311920200508102317', 'K01819', '2020-07-28 17:46:05'),
('K0181920200521202558', 'K01819', '2020-07-28 17:46:11'),
('K0181920200527161940', 'K01819', '2020-07-28 17:46:13'),
('K0181920200520084601', 'K01819', '2020-07-28 17:46:41'),
('K0181920200518183850', 'K01819', '2020-07-28 17:47:29'),
('M10311920200603114141', 'K00173', '2020-07-30 16:22:13'),
('M10311920200506135949', 'M103119', '2020-08-03 08:56:14'),
('M10311920200518112207', 'M103119', '2020-08-04 10:11:00'),
('M10311920200603114141', 'K00173', '2020-08-07 10:52:42'),
('K0181920200810185617', 'K01819', '2020-08-10 16:56:20'),
('K0181920200810185617', 'K01819', '2020-08-10 16:56:27'),
('M10311920200616100227', 'K01819', '2020-08-10 16:58:39'),
('K0181920200810185617', 'K01819', '2020-08-10 16:59:08'),
('K0181920200810185617', 'K01819', '2020-08-10 16:59:50'),
('20200518185046', 'K01819', '2020-08-10 17:00:00'),
('M10311920200603114141', 'K00173', '2020-08-12 16:33:12'),
('K0181920200810185617', 'K01819', '2020-08-14 12:32:34'),
('M10311920200506160203', 'M103119', '2020-08-18 09:53:14'),
('M10311920200506135949', 'M103119', '2020-08-18 09:53:29'),
('M10311920200603114141', 'K00173', '2020-08-19 15:46:06'),
('M10311920200603114141', 'K00173', '2020-08-20 12:55:44'),
('M10311920200506181314', 'M103119', '2020-08-23 06:46:02'),
('M10311920200506181314', 'M103119', '2020-08-23 07:00:15'),
('M10311920200506181314', 'M103119', '2020-08-24 09:33:34'),
('20200508172919', 'M103119', '2020-08-25 09:40:05'),
('M10311920200506135949', 'M103119', '2020-08-25 09:41:15'),
('20200508172919', 'M103119', '2020-08-25 09:47:07'),
('M9976420200716111858', 'M103119', '2020-08-25 12:46:50'),
('M10311920200715142645', 'M103119', '2020-08-25 12:47:06'),
('M10311920200715143333', 'M103119', '2020-08-25 12:47:23'),
('M10311920200508190947', 'M103119', '2020-08-25 12:47:36'),
('M10311920200510170147', 'M103119', '2020-08-25 12:47:49'),
('M10311920200510164422', 'M103119', '2020-08-25 12:47:59'),
('M10311920200715143333', 'M99413', '2020-08-25 13:19:16'),
('M9941320200825153035', 'M99413', '2020-08-25 13:30:46'),
('M9941320200825153251', 'M99413', '2020-08-25 13:32:57'),
('M9941320200825153035', 'M99413', '2020-08-25 13:33:01'),
('M9976420200716111858', 'M99413', '2020-08-25 13:33:59'),
('M10311920200715142645', 'M99413', '2020-08-25 13:34:21'),
('M10311920200510164422', 'M99413', '2020-08-25 13:36:50'),
('M9941320200825153803', 'M99413', '2020-08-25 13:38:06'),
('M9941320200825153803', 'M99413', '2020-08-25 13:39:40'),
('M9941320200825153803', 'M99413', '2020-08-25 13:39:54'),
('M9941320200825153803', 'M99413', '2020-08-25 13:40:43'),
('M9941320200825153803', 'M103119', '2020-08-25 13:41:09'),
('M9941320200825153803', 'M103119', '2020-08-25 13:41:09'),
('M9941320200825153803', 'M103119', '2020-08-25 13:42:02'),
('M9941320200825153803', 'M103119', '2020-08-25 13:42:02'),
('M10311920200506135949', 'M103119', '2020-08-25 13:42:22'),
('M10311920200506160804', 'M103119', '2020-08-25 13:42:48'),
('M9941320200825153803', 'M103119', '2020-08-25 13:43:18'),
('M9941320200825153803', 'M99413', '2020-08-25 13:44:06'),
('M9941320200825153035', 'M99413', '2020-08-25 13:44:57'),
('M10311920200715143333', 'M99413', '2020-08-25 13:45:48'),
('M10311920200508102317', 'M99413', '2020-08-25 13:46:09'),
('M9941320200825153035', 'M99413', '2020-08-25 13:46:45'),
('M9941320200825153035', 'M99413', '2020-08-25 13:48:06'),
('M9941320200825153035', 'M99413', '2020-08-25 13:48:21'),
('M9976420200716111858', 'M99413', '2020-08-25 13:51:12'),
('M9941320200825153524', 'M99413', '2020-08-25 13:51:19'),
('M9941320200825153524', 'M99413', '2020-08-25 13:51:30'),
('M9941320200825153035', 'M99413', '2020-08-25 13:52:09'),
('M9941320200825153524', 'M99413', '2020-08-26 14:05:45'),
('M9941320200825153035', 'M99413', '2020-08-26 14:05:53'),
('M9941320200825153035', 'M103141', '2020-08-26 14:07:02'),
('M9678120200527102746', 'M96781', '2020-08-27 14:30:17'),
('M9678120200527102816', 'M96781', '2020-08-27 14:30:34'),
('M10311920200506135949', 'M103119', '2020-08-28 09:31:55'),
('M10311920200706112921', 'M103119', '2020-08-28 09:32:10'),
('K0181920200518181836', 'K01819', '2020-08-29 09:58:28'),
('K0181920200706121550', 'K01819', '2020-09-01 15:44:48'),
('K0181920200706121550', 'K01819', '2020-09-01 19:45:45'),
('K0181920200710091635', 'K01819', '2020-09-03 06:49:15'),
('M10311920200506135949', 'M103119', '2020-09-04 09:25:04'),
('M10311920200706112921', 'M103119', '2020-09-04 09:25:54'),
('M10311920200506135949', 'M103119', '2020-09-04 09:26:31'),
('K0181920200908134004', 'K01819', '2020-09-08 11:43:06'),
('K0181920200908134004', 'K01819', '2020-09-08 11:46:28'),
('M9941320200825153035', 'M99413', '2020-09-09 07:02:43'),
('K0181920200914110341', 'K01819', '2020-09-14 09:06:40'),
('M10311920200508174604', 'M103119', '2020-09-14 14:16:30'),
('20200518185046', 'M103119', '2020-09-18 09:04:13'),
('M10311920200508174604', 'M103119', '2020-09-18 09:04:47'),
('M10311920200918111757', 'M103119', '2020-09-18 09:18:00'),
('M10311920200918111757', 'M126651', '2020-09-18 09:20:28'),
('M10311920200918111757', 'M126651', '2020-09-18 09:33:27'),
('M10311920200706112921', 'M103119', '2020-09-18 10:16:34'),
('M10311920200706112921', 'M103119', '2020-09-18 10:17:44'),
('M10311920200918124625', 'M103119', '2020-09-18 10:46:28'),
('M10311920200918124625', 'M103119', '2020-09-18 10:47:16'),
('M10311920200706112921', 'M103119', '2020-09-18 10:47:52'),
('M10311920200706112921', 'M103119', '2020-09-18 10:48:35'),
('M10311920200918111757', 'M126651', '2020-09-18 20:24:17'),
('M10311920200706112921', 'M126651', '2020-09-19 18:55:30'),
('M10311920200506160804', 'M96781', '2020-09-28 08:34:46'),
('M10311920200706112921', 'M103119', '2020-10-02 08:51:08'),
('M10311920200506154610', 'M103119', '2020-10-02 08:51:10'),
('M10311920200506160203', 'M103119', '2020-10-02 08:51:12'),
('M10311920200506135949', 'M103119', '2020-10-02 08:51:15'),
('M10311920200918124625', 'K01819', '2020-10-06 08:38:23'),
('M10311920200918124625', 'K01819', '2020-10-06 08:38:23'),
('M10311920200918124625', 'K01819', '2020-10-06 08:39:08'),
('M10311920200918124625', 'K01819', '2020-10-06 08:40:06'),
('M10311920200918124625', 'M103119', '2020-10-06 08:46:26'),
('M10311920200918124625', 'M103119', '2020-10-06 08:57:20'),
('M10311920200918124625', 'M103119', '2020-10-06 08:59:04'),
('M9941320200825153803', 'M103119', '2020-10-06 08:59:30'),
('M10311920200518112207', 'M103119', '2020-10-06 09:00:09'),
('M10311920200715143333', 'M103119', '2020-10-06 09:00:43'),
('M10311920200918111757', 'M103119', '2020-10-06 09:00:57'),
('M10311920200918124625', 'M103119', '2020-10-06 09:04:18'),
('M10311920200918124625', 'K01819', '2020-10-06 09:05:51'),
('M10311920200918124625', 'M103119', '2020-10-06 09:13:41'),
('K0181920200710091635', 'K01819', '2020-10-06 15:17:00'),
('M9678120200527102746', 'M96781', '2020-10-09 09:01:55'),
('M9678120200527102816', 'M96781', '2020-10-09 09:02:09'),
('M9678120200527103215', 'M96781', '2020-10-09 09:06:16'),
('M10311920200506135949', 'M103119', '2020-10-15 12:07:26'),
('', 'M103119', '2020-10-15 12:08:57'),
('', 'M103119', '2020-10-15 12:09:02'),
('M10311920200710123149', 'M103119', '2020-10-15 15:27:37'),
('20200508172919', 'M103119', '2020-10-16 06:38:21'),
('M10311920200706112921', 'M103119', '2020-10-16 06:44:29'),
('M10311920200706112921', 'M103119', '2020-10-16 06:50:22'),
('M10311920201020120255', 'M103119', '2020-10-20 10:02:58'),
('M10311920201020121911', 'M103119', '2020-10-20 10:19:16'),
('M10311920201020121911', 'M103119', '2020-10-20 10:21:08'),
('M10311920201020120255', 'M103119', '2020-10-20 10:27:13'),
('M10311920201020121911', 'M103119', '2020-10-20 10:27:31'),
('M10311920201020120255', 'M103119', '2020-10-20 10:31:11'),
('M10311920201020121911', 'M103119', '2020-10-20 10:31:33'),
('M10311920201020120255', 'M103119', '2020-10-20 10:42:24'),
('M10311920201020121911', 'M103119', '2020-10-20 10:42:45'),
('M10311920201020121911', 'M103119', '2020-10-20 10:51:32'),
('M10311920200508102317', 'K01819', '2020-10-20 11:25:03'),
('M10311920200506135949', 'K01819', '2020-10-20 11:26:18'),
('M10311920200506160203', 'K01819', '2020-10-20 11:26:24'),
('M10311920200506160203', 'K01819', '2020-10-20 11:26:27'),
('K0181920200527161940', 'K01819', '2020-10-20 11:27:39'),
('M10311920201020121911', 'M103119', '2020-10-20 11:29:02'),
('M10311920201020121911', 'M103119', '2020-10-20 11:30:35'),
('M10311920201020121911', 'M103119', '2020-10-20 11:33:37'),
('M10311920201020121911', 'M103119', '2020-10-20 11:33:59'),
('M10311920201020133523', 'M103119', '2020-10-20 11:35:26'),
('M10311920201020133523', 'K01819', '2020-10-20 11:35:46'),
('M10311920201020133523', 'M103119', '2020-10-20 11:35:59'),
('M10311920201020133523', 'K01819', '2020-10-20 11:36:10'),
('M10311920201020121911', 'M103119', '2020-10-20 11:36:10'),
('M10311920201020133640', 'M103119', '2020-10-20 11:36:43'),
('M10311920201020133640', 'M103119', '2020-10-20 11:37:04'),
('M10311920201020133640', 'K01819', '2020-10-20 11:37:16'),
('', 'M103119', '2020-10-20 11:40:29'),
('M10311920201020133640', 'M103119', '2020-10-20 11:41:19'),
('M10311920201020133640', 'K01819', '2020-10-20 13:52:19'),
('M10311920201020133640', 'K01819', '2020-10-20 14:03:26'),
('K0181920200901214419', 'K01819', '2020-10-20 14:09:27'),
('M10311920201020133640', 'M97981', '2020-10-20 14:35:10'),
('M10311920200918111757', 'M97981', '2020-10-20 14:39:59'),
('M10311920200918111757', 'M97981', '2020-10-20 14:39:59'),
('M10311920200918111757', 'M97981', '2020-10-20 14:39:59'),
('M10311920201020133640', 'M97981', '2020-10-20 14:40:11'),
('K0181920200527161940', 'K01819', '2020-10-20 14:40:13'),
('M10311920200918111757', 'M97981', '2020-10-20 14:40:14'),
('M10311920200508102317', 'K01819', '2020-10-20 14:40:25'),
('M10311920201020133640', 'K01819', '2020-10-20 14:40:34'),
('K0181920200527161940', 'K01819', '2020-10-20 14:40:41'),
('M10311920200508102317', 'K01819', '2020-10-20 14:40:49'),
('M10311920200510164422', 'K01819', '2020-10-20 14:41:29'),
('M10311920200510165928', 'K01819', '2020-10-20 14:41:35'),
('M10311920200510165928', 'M97981', '2020-10-20 14:41:44'),
('M9798120201020164923', 'M97981', '2020-10-20 14:49:29'),
('K0017820201020165755', 'K00178', '2020-10-20 14:58:08'),
('K0017820201020165938', 'K00178', '2020-10-20 15:00:02'),
('M9798120201020164923', 'M97981', '2020-10-20 15:18:18'),
('M10311920200510164422', 'K01819', '2020-10-20 15:18:19'),
('M9798120201020164923', 'K01819', '2020-10-20 15:18:54'),
('M9798120201020164923', 'M97981', '2020-10-20 15:19:11'),
('M9798120201020164923', 'K01819', '2020-10-20 15:20:23'),
('K0181920200908134004', 'K01819', '2020-10-20 15:21:34'),
('K0181920200520130717', 'K01819', '2020-10-20 15:22:23'),
('K0181920200706102716', 'K01819', '2020-10-20 15:23:39'),
('M9798120201021090321', 'M97981', '2020-10-21 07:03:26'),
('M9798120201021090321', 'M97981', '2020-10-21 07:03:44'),
('M9798120201021090321', 'M97981', '2020-10-21 07:09:22'),
('M9798120201021090321', 'M97981', '2020-10-21 07:11:44'),
('M9798120201021090321', 'M97981', '2020-10-21 07:27:26'),
('M9798120201021090321', 'M97981', '2020-10-21 08:11:57'),
('M9798120201021090321', 'M97981', '2020-10-21 08:44:21'),
('M9798120201021090321', 'M97981', '2020-10-21 08:51:59'),
('M9798120201021090321', 'M97981', '2020-10-21 08:52:05'),
('M9798120201021090321', 'M97981', '2020-10-21 08:52:14'),
('K0181920201021105224', 'K01819', '2020-10-21 08:52:28'),
('M9798120201021090321', 'M97981', '2020-10-21 08:53:46'),
('K0181920201021105431', 'K01819', '2020-10-21 08:54:56'),
('K0181920201021105431', 'K01819', '2020-10-21 08:55:32'),
('K0181920201021105224', 'K01819', '2020-10-21 08:57:30'),
('M9678120200519115841', 'K01819', '2020-10-21 08:57:39'),
('M9798120201021090321', 'M97981', '2020-10-21 09:18:59'),
('M9798120201021090321', 'M97981', '2020-10-21 09:46:14'),
('M9798120201021090321', 'M97981', '2020-10-21 09:54:07'),
('M9798120201021090321', 'M97981', '2020-10-21 10:12:55'),
('M9798120201021090321', 'M97981', '2020-10-21 10:56:59'),
('M10311920200706112921', 'M97981', '2020-10-21 11:09:24'),
('K0181920201021105224', 'M97981', '2020-10-21 11:10:24'),
('K0181920201021105431', 'M97981', '2020-10-21 11:10:34'),
('M10311920200706112921', 'M97981', '2020-10-21 11:10:45'),
('M9798120201021131949', 'M97981', '2020-10-21 11:19:51'),
('M10311920200510165928', 'M97981', '2020-10-21 11:22:08'),
('M10311920200706112921', 'M97981', '2020-10-21 11:23:18'),
('M10311920200706112921', 'M97981', '2020-10-21 11:24:34'),
('M9798120201021132429', 'M97981', '2020-10-21 11:24:53'),
('M9798120201021132429', 'M97981', '2020-10-21 11:25:04'),
('M10311920201020133640', 'M97981', '2020-10-21 11:26:33'),
('M9798120201021090321', 'M97981', '2020-10-21 12:15:50'),
('M9798120201021132429', 'M97981', '2020-10-21 13:16:42'),
('M10311920200706112921', 'M97981', '2020-10-21 13:16:50'),
('M9798120201021132259', 'M97981', '2020-10-21 13:17:24'),
('K0181920201021105431', 'M97981', '2020-10-21 13:17:30'),
('M9798120201021090321', 'M97981', '2020-10-21 13:17:51'),
('M9798120201021090321', 'M97981', '2020-10-21 13:25:52'),
('M9798120201021090321', 'M97981', '2020-10-21 13:26:07'),
('M9798120201021090321', 'M97981', '2020-10-21 14:00:23'),
('M9798120201021090321', 'M97981', '2020-10-21 14:39:39'),
('M9798120201021090321', 'M97981', '2020-10-21 14:39:55'),
('M10311920200510170456', 'K01819', '2020-10-21 18:34:28'),
('20200518185046', 'K01819', '2020-10-21 18:35:55'),
('K0181920200810185617', 'K01819', '2020-10-21 18:36:08'),
('M10311920200518181525', 'K01819', '2020-10-21 18:36:38'),
('M9798120201021090321', 'M97981', '2020-10-22 07:09:42'),
('M10311920200506160804', 'M96781', '2020-10-22 07:53:53'),
('M9678120200527102746', 'M96781', '2020-10-22 08:22:42'),
('K0017820201020165938', 'K00178', '2020-10-22 08:38:48'),
('K0017820201020165755', 'K00178', '2020-10-22 08:39:34'),
('K0181920201021105431', 'M12340', '2020-10-22 08:39:56'),
('K0017820201020165755', 'K00178', '2020-10-22 08:40:37'),
('K0017820201020165755', 'K00178', '2020-10-22 08:41:25'),
('M1234020201022104225', 'M12340', '2020-10-22 08:42:38'),
('M1234020201022104225', 'M12340', '2020-10-22 08:43:18'),
('K0017820201020165755', 'K00178', '2020-10-22 08:43:58'),
('M9798120201020164923', 'K00178', '2020-10-22 08:44:33'),
('K0017820201020165755', 'K00178', '2020-10-22 08:44:44'),
('M9798120201020164923', 'K00178', '2020-10-22 08:44:49'),
('K0017820201020165755', 'K00178', '2020-10-22 08:45:09'),
('K0017820201020165938', 'K00178', '2020-10-22 08:45:39'),
('M1234020201022104225', 'M12340', '2020-10-22 08:46:45'),
('M1234020201022104225', 'M12340', '2020-10-22 08:46:46'),
('M1234020201022104225', 'M12340', '2020-10-22 08:46:47'),
('M1234020201022104925', 'M12340', '2020-10-22 08:49:30'),
('K0017820201020165755', 'K00178', '2020-10-22 08:51:10'),
('M10311920200510165928', 'M12340', '2020-10-22 08:51:41'),
('M1234020201022105241', 'M12340', '2020-10-22 08:52:45'),
('M9798120201021090321', 'M97981', '2020-10-22 08:54:01'),
('M9798120201021090321', 'M97981', '2020-10-22 08:54:13'),
('M9798120201021090321', 'M97981', '2020-10-22 08:54:29'),
('K0017820201020165755', 'M12340', '2020-10-22 08:56:46'),
('M9798120201021090321', 'M97981', '2020-10-22 08:56:55'),
('M1234020201021105945', 'M12340', '2020-10-22 08:57:20'),
('M1234020201021110152', 'M12340', '2020-10-22 08:57:27'),
('M1234020201022110143', 'M12340', '2020-10-22 09:01:48'),
('M1234020201022111620', 'M12340', '2020-10-22 09:16:24'),
('M1234020201022112024', 'M12340', '2020-10-22 09:20:30'),
('M1234020201022112159', 'M12340', '2020-10-22 09:22:03'),
('M1234020201022112422', 'M12340', '2020-10-22 09:24:27'),
('M1234020201022112422', 'M12340', '2020-10-22 09:24:44'),
('M1234020201022112422', 'M12340', '2020-10-22 09:24:52'),
('M1234020201022112422', 'M12340', '2020-10-22 09:25:45'),
('M1234020201022112422', 'M12340', '2020-10-22 09:25:47'),
('M1234020201022112714', 'M12340', '2020-10-22 09:27:18'),
('M1234020201022112714', 'M12340', '2020-10-22 09:28:04'),
('M1234020201022112714', 'M12340', '2020-10-22 09:28:06'),
('M1234020201022113204', 'M12340', '2020-10-22 09:32:09'),
('M1234020201022113204', 'M12340', '2020-10-22 09:32:48'),
('M1234020201022113204', 'M12340', '2020-10-22 09:32:52'),
('M1234020201022113204', 'M12340', '2020-10-22 09:32:53'),
('M1234020201022113204', 'M12340', '2020-10-22 09:33:05'),
('M9798120201021090321', 'M97981', '2020-10-22 09:34:44'),
('M1234020201022113548', 'M12340', '2020-10-22 09:35:53'),
('K0017820201022114636', 'K00178', '2020-10-22 09:46:44'),
('K0017820201022114636', 'K00178', '2020-10-22 09:47:50'),
('K0017820201022114636', 'K00178', '2020-10-22 09:50:02'),
('K0017820201022114636', 'K00178', '2020-10-22 09:50:30'),
('M1234020201022112714', 'K00178', '2020-10-22 09:56:15'),
('M1234020201022110143', 'K00178', '2020-10-22 09:56:21'),
('M1234020201022105241', 'K00178', '2020-10-22 09:56:23'),
('K0017820201020165938', 'K00178', '2020-10-22 09:56:25'),
('M10311920200510165928', 'K00178', '2020-10-22 09:56:30'),
('M10311920200510164422', 'K00178', '2020-10-22 09:56:40'),
('M1234020201022111620', 'K00178', '2020-10-22 09:56:48'),
('M9798120201020164923', 'K00178', '2020-10-22 09:56:53'),
('K0017820201020165755', 'K00178', '2020-10-22 09:56:59'),
('K0017820201022114636', 'K00178', '2020-10-22 09:57:10'),
('M1234020201022125436', 'M12340', '2020-10-22 10:54:41'),
('K0017820201022114636', 'M12340', '2020-10-22 10:56:15'),
('M1234020201022112159', 'K00178', '2020-10-22 11:31:22'),
('M1234020201022112024', 'M12340', '2020-10-22 11:31:39'),
('M1234020201022112024', 'M12340', '2020-10-22 11:33:22'),
('M1234020201022112024', 'K00178', '2020-10-22 11:34:37'),
('M1234020201022112159', 'K00178', '2020-10-22 11:34:53'),
('M1234020201022113548', 'K00178', '2020-10-22 11:34:59'),
('M1234020201022125436', 'M12340', '2020-10-22 11:35:20'),
('M1234020201022125436', 'M12340', '2020-10-22 11:35:34'),
('M9798120201021090321', 'M97981', '2020-10-22 11:47:10'),
('M1234020201022112024', 'K00178', '2020-10-22 11:50:22'),
('M1234020201022110143', 'K00178', '2020-10-22 11:50:35'),
('M1234020201022142013', 'M12340', '2020-10-22 12:20:19'),
('M1234020201022142128', 'M12340', '2020-10-22 12:21:33'),
('M1234020201022142303', 'M12340', '2020-10-22 12:23:09'),
('M1234020201022142303', 'M12340', '2020-10-22 12:27:16'),
('M1234020201022142527', 'M12340', '2020-10-22 12:27:31'),
('M1234020201022142416', 'M12340', '2020-10-22 12:27:48'),
('M1234020201022142706', 'M12340', '2020-10-22 12:28:04'),
('M1234020201022142303', 'M12340', '2020-10-22 12:28:21'),
('M1234020201022142527', 'M12340', '2020-10-22 12:28:37'),
('M1234020201022142527', 'M12340', '2020-10-22 12:30:11'),
('M1234020201022142013', 'M12340', '2020-10-22 12:31:52'),
('M9798120201021090321', 'M97981', '2020-10-22 15:51:44'),
('M9798120201021132429', 'K01819', '2020-10-22 16:38:17'),
('M9798120201021090321', 'M97981', '2020-10-23 08:15:59'),
('M9798120201021090321', 'M97981', '2020-10-23 08:16:36'),
('M9798120201021090321', 'M97981', '2020-10-23 08:25:49'),
('M9798120201021090321', 'M97981', '2020-10-23 11:26:37'),
('M9798120201023141558', 'M97981', '2020-10-23 12:16:01'),
('M9798120201023141558', 'M97981', '2020-10-23 12:16:30'),
('M9798120201023141706', 'M97981', '2020-10-23 12:17:08'),
('M9798120201023141706', 'M97981', '2020-10-23 12:18:14'),
('M9798120201021090321', 'M97981', '2020-10-23 12:38:43'),
('M9798120201021090321', 'M97981', '2020-10-23 12:38:54'),
('M9798120201023141706', 'M97981', '2020-10-23 12:47:11'),
('M9798120201023141706', 'M97981', '2020-10-23 12:47:44'),
('M9798120201023141706', 'M97981', '2020-10-23 12:48:48'),
('M9798120201023141706', 'K01819', '2020-10-23 12:48:49'),
('M9798120201023141706', 'M97981', '2020-10-23 12:49:02'),
('M9798120201023141706', 'M97981', '2020-10-23 12:49:02'),
('20200518185046', 'K01819', '2020-10-23 12:49:28'),
('20200518185046', 'K01819', '2020-10-23 12:49:35'),
('M9798120201023141706', 'M97981', '2020-10-23 12:49:41'),
('20200518185046', 'K01819', '2020-10-23 12:49:57'),
('20200518185046', 'K01819', '2020-10-23 12:50:06'),
('M9798120201023141706', 'M97981', '2020-10-23 12:50:16'),
('M10311920201020133640', 'K01819', '2020-10-23 12:51:35'),
('M9798120201023141706', 'M97981', '2020-10-23 12:55:53'),
('M9798120201023141706', 'M97981', '2020-10-23 14:00:48'),
('M9798120201023141706', 'M97981', '2020-10-23 14:03:59'),
('M9798120201021090321', 'M97981', '2020-10-23 14:04:31'),
('M9798120201023141706', 'M97981', '2020-10-23 14:08:26'),
('M10311920200506154610', 'M103119', '2020-10-23 14:27:39'),
('M10311920200506154610', 'M103119', '2020-10-23 14:28:03'),
('M9798120201023141706', 'M97981', '2020-10-26 08:10:01'),
('M9798120201023141706', 'K01819', '2020-10-26 08:25:03'),
('M9798120201021090321', 'M97981', '2020-10-26 09:08:57'),
('M9798120201021090321', 'M97981', '2020-10-26 09:09:13'),
('M9798120201023141706', 'M97981', '2020-10-26 12:03:29'),
('M9798120201023141706', 'M97981', '2020-10-26 12:03:37'),
('M9798120201023141706', 'M97981', '2020-10-26 14:41:08'),
('M9798120201023141706', 'M97981', '2020-10-26 14:41:17'),
('M9798120201023141706', 'M97981', '2020-10-26 14:43:26'),
('M9798120201023141706', 'M97981', '2020-10-26 14:46:01'),
('M9798120201023141706', 'K01819', '2020-10-26 14:53:43'),
('M9798120201023141706', 'K01819', '2020-10-26 14:53:53'),
('M9798120201023141706', 'M97981', '2020-10-26 15:24:07'),
('M9798120201023141706', 'M97981', '2020-10-26 16:00:49'),
('M9798120201023141706', 'M97981', '2020-10-26 16:00:51'),
('M9798120201023141706', 'M97981', '2020-10-26 16:02:39'),
('M9798120201023141706', 'M97981', '2020-10-26 16:03:33'),
('M9798120201023141706', 'M97981', '2020-10-26 16:04:51'),
('M9798120201023141706', 'M97981', '2020-10-27 08:00:56'),
('M9798120201023141706', 'M97981', '2020-10-27 14:33:33'),
('M9798120201023141706', 'M97981', '2020-10-27 14:37:39'),
('M9798120201023141706', 'M97981', '2020-10-27 15:21:53'),
('M9798120201023141706', 'M97981', '2020-10-27 15:21:57'),
('M9798120201023141706', 'M97981', '2020-10-27 15:57:10'),
('M9798120201023141706', 'M97981', '2020-10-28 09:47:40'),
('M9798120201023141706', 'M97981', '2020-10-28 09:47:48'),
('M9798120201023141706', 'M97981', '2020-10-28 09:48:37'),
('M9798120201023141706', 'M97981', '2020-10-28 10:47:11'),
('M9798120201023141706', 'M97981', '2020-10-28 11:25:55'),
('M9798120201023141706', 'M97981', '2020-10-28 11:26:02'),
('M9798120201023141706', 'M97981', '2020-10-28 14:04:47'),
('K0181920201021105431', 'M12340', '2020-10-29 12:21:03'),
('M10311920200918124625', 'K01819', '2020-10-29 12:30:38'),
('K0181920201021105224', 'K01819', '2020-10-29 12:34:34'),
('K0181920200527161940', 'K01819', '2020-10-29 12:36:40'),
('K0181920200527161940', 'K01819', '2020-10-29 12:37:40'),
('K0181920200521202558', 'K01819', '2020-10-29 12:38:03'),
('M10311920200510164422', 'K01819', '2020-10-29 12:38:45'),
('20200518185046', 'K01819', '2020-10-29 12:39:26'),
('K0181920200518183850', 'K01819', '2020-10-29 12:41:37'),
('K0181920201029134553', 'K01819', '2020-10-29 12:45:59'),
('K0181920201029134553', 'K01819', '2020-10-29 15:52:22'),
('K0181920201029134553', 'K31897', '2020-11-02 13:58:19'),
('K3189720201102145851', 'K31897', '2020-11-02 13:59:14'),
('K3189720201102151813', 'K31897', '2020-11-02 14:19:19'),
('K3189720201102151813', 'K31897', '2020-11-02 14:20:56'),
('M10311920200706112921', 'M97981', '2020-11-02 14:23:21'),
('M9798120201021131949', 'M97981', '2020-11-02 14:23:32'),
('M9798120201021132429', 'M97981', '2020-11-02 14:23:36'),
('K0181920201021105431', 'M97981', '2020-11-02 14:23:44'),
('M9798120201021132151', 'M97981', '2020-11-02 14:23:51'),
('M9798120201021132259', 'M97981', '2020-11-02 14:23:56'),
('M9798120201021090321', 'M97981', '2020-11-02 14:24:08'),
('M9798120201021090321', 'M97981', '2020-11-02 14:24:13'),
('M9798120201023141706', 'M97981', '2020-11-02 14:24:30'),
('K0017820201022114636', 'M97981', '2020-11-02 14:25:27'),
('K0017820201020165755', 'M97981', '2020-11-02 14:25:38'),
('K3189720201103123359', 'K31897', '2020-11-03 11:35:31'),
('K3189720201103134807', 'K31897', '2020-11-03 12:48:19'),
('K3189720201103135109', 'K31897', '2020-11-03 12:51:22'),
('K3189720201103135109', 'K31897', '2020-11-03 12:51:43'),
('K3189720201103135109', 'K31897', '2020-11-03 12:51:51'),
('K3189720201103140919', 'K31897', '2020-11-03 13:09:27'),
('M1234020201104114925', 'M12340', '2020-11-04 10:49:29'),
('M1234020201104114925', 'M12340', '2020-11-04 10:49:41'),
('M1234020201104114925', 'M12340', '2020-11-04 10:49:52'),
('M1234020201104114925', 'M12340', '2020-11-04 10:50:37'),
('M1234020201104114925', 'M12340', '2020-11-04 10:50:42'),
('M9798120201106162446', 'M97981', '2020-11-06 15:24:49'),
('M9798120201106162446', 'M97981', '2020-11-06 15:25:50'),
('K0181920201106175845', 'K01819', '2020-11-06 16:58:48'),
('K0003820201106175948', 'K00038', '2020-11-06 16:59:59'),
('', 'K00038', '2020-11-06 17:00:17'),
('K0003820201106175948', 'K00038', '2020-11-06 17:00:35'),
('K0003820201106175948', 'K00038', '2020-11-06 17:01:09'),
('K0003820201106175948', 'K01819', '2020-11-06 17:02:09'),
('K0003820201106175948', 'K00038', '2020-11-06 17:02:42'),
('K0003820201106175948', 'K00038', '2020-11-06 17:02:58'),
('K0181920201106175845', 'K01819', '2020-11-06 17:03:09'),
('K0003820201106175948', 'K01819', '2020-11-06 17:06:28'),
('M9798120201106162446', 'M97981', '2020-11-09 08:04:09'),
('M9798120201106162446', 'M97981', '2020-11-10 08:48:26'),
('M9798120201106162446', 'M97981', '2020-11-10 08:48:28'),
('M9798120201106162446', 'M97981', '2020-11-10 08:48:31'),
('M9798120201106162446', 'M97981', '2020-11-10 08:59:07'),
('M9798120201023141706', 'M97981', '2020-11-10 08:59:18'),
('M9798120201110100100', 'M97981', '2020-11-10 09:01:02'),
('M9798120201110100100', 'M97981', '2020-11-10 09:01:07'),
('M9798120201110100100', 'M97981', '2020-11-10 11:23:50'),
('K3189720201110131426', 'K31897', '2020-11-10 12:14:31'),
('M9798120201110100100', 'M97981', '2020-11-10 15:27:09'),
('M9798120201110100100', 'M97981', '2020-11-10 15:27:37'),
('M10311920201020133640', 'M97981', '2020-11-11 08:16:35'),
('M9798120201110100100', 'M97981', '2020-11-11 08:16:39'),
('M9798120201110100100', 'M97981', '2020-11-11 08:16:58'),
('M10311920200603114141', 'K00173', '2020-11-11 11:29:43'),
('K3189720201112111737', 'K31897', '2020-11-12 10:17:40'),
('K3189720201112111737', 'K31897', '2020-11-12 11:11:58'),
('K0017820201022114636', 'K00178', '2020-11-12 12:52:43'),
('K0017820201020165755', 'K00178', '2020-11-12 12:53:13'),
('M9798120201110100100', 'M97981', '2020-11-12 14:36:18'),
('M10311920201020133640', 'M97981', '2020-11-13 10:48:42'),
('M10311920200918111757', 'M97981', '2020-11-13 12:24:59'),
('M10311920200918111757', 'M97981', '2020-11-13 12:25:14'),
('M10311920200918111757', 'M97981', '2020-11-13 12:25:14'),
('M10311920200918111757', 'M24725', '2020-11-13 12:26:43'),
('M10311920201020133640', 'M97981', '2020-11-13 12:27:04'),
('M10311920201020133640', 'M97981', '2020-11-13 12:27:16'),
('M10311920201020133640', 'M24725', '2020-11-13 12:27:19'),
('K0181920201113140515', 'K01819', '2020-11-13 13:05:23'),
('K0181920201113144508', 'K01819', '2020-11-13 13:45:59'),
('K0181920201029134553', 'K01819', '2020-11-13 13:49:46'),
('K0003820201106175948', 'K01819', '2020-11-13 13:50:02'),
('K0181920201116190308', 'K01819', '2020-11-16 18:03:13'),
('K0181920201116190308', 'K01819', '2020-11-16 18:04:09'),
('K0181920201116190308', 'K01819', '2020-11-16 18:08:10'),
('K0181920201116190913', 'K01819', '2020-11-16 18:09:22'),
('K0181920201116190913', 'K01819', '2020-11-16 18:15:11'),
('K0181920201116191639', 'K01819', '2020-11-16 18:16:45'),
('K0181920201116191639', 'K01819', '2020-11-16 18:17:23'),
('K0181920201116191639', 'K01819', '2020-11-16 18:27:56'),
('K0181920201116190308', 'K01819', '2020-11-16 18:28:52'),
('K0181920201116190308', 'K01819', '2020-11-16 18:29:08'),
('K0003820201106175948', 'K01819', '2020-11-16 18:34:26'),
('K0181920201116190308', 'M103119', '2020-11-17 08:07:00'),
('K0181920201116190308', 'K01819', '2020-11-17 09:40:32'),
('K0181920201116191639', 'K01819', '2020-11-17 09:40:51'),
('K0181920201116191639', 'K01819', '2020-11-17 09:42:47'),
('K0181920201116191639', 'K01819', '2020-11-17 10:03:46'),
('K0181920201116191639', 'K14379', '2020-11-17 10:04:25'),
('K0003820201106175948', 'K00038', '2020-11-17 10:04:38'),
('K0181920201116191639', 'K00038', '2020-11-17 10:04:52'),
('K0181920201116190308', 'K01819', '2020-11-17 10:08:10'),
('K0181920201116190308', 'K00063', '2020-11-17 10:08:14'),
('K0181920201116191639', 'M103119', '2020-11-17 10:39:55'),
('K0181920201116190913', 'M103119', '2020-11-17 10:40:23'),
('K0181920201116190308', 'M103119', '2020-11-17 17:12:35'),
('K0181920200710091635', 'K01819', '2020-11-17 17:41:19'),
('K0181920201116190308', 'K01819', '2020-11-17 18:31:14'),
('K0181920201116190308', 'K01819', '2020-11-17 18:32:02'),
('K0181920201113140515', 'K01819', '2020-11-17 18:33:16'),
('M10311920200506160553', 'K01819', '2020-11-17 18:33:37'),
('M9941320200825153803', 'M103119', '2020-11-18 07:45:51'),
('M10311920200525103358', 'M103119', '2020-11-18 07:46:42'),
('M10311920200518152433', 'M103119', '2020-11-18 07:47:14'),
('K0181920201116190308', 'M103119', '2020-11-18 07:48:10'),
('M10311920201118085056', 'M103119', '2020-11-18 07:51:02'),
('', 'M103119', '2020-11-18 07:51:15'),
('M10311920201118085056', 'M103119', '2020-11-18 10:48:18'),
('M10311920201118085056', 'M103119', '2020-11-18 10:51:44'),
('M9941320200825153803', 'M103119', '2020-11-18 10:52:49'),
('K0181920200603093348', 'M103119', '2020-11-18 10:54:04'),
('M10311920200518182000', 'M103119', '2020-11-18 10:54:16'),
('M10311920201118085056', 'M103119', '2020-11-18 10:54:35'),
('M10311920201118085056', 'M103119', '2020-11-18 11:09:27'),
('K0181920201116190913', 'M103119', '2020-11-18 11:09:40'),
('K0181920201116190913', 'M103119', '2020-11-18 11:10:41'),
('K0181920201116190913', 'M103119', '2020-11-18 11:30:48'),
('M10311920201118085056', 'M103119', '2020-11-19 10:54:46'),
('K0181920201116190913', 'M103119', '2020-11-19 10:55:12'),
('K0181920201119194624', 'K01819', '2020-11-19 18:46:29'),
('M10311920201118085056', 'M103119', '2020-11-20 11:56:11'),
('M9798120201021132429', 'M97981', '2020-11-23 07:52:49'),
('K0181920200710091635', 'K01819', '2020-11-23 12:24:28'),
('K0181920200710091635', 'K01819', '2020-11-23 12:24:40'),
('K0181920201113140515', 'K01819', '2020-11-23 12:24:58'),
('K0181920201116191639', 'K01819', '2020-11-24 08:09:50'),
('K0181920201116191639', 'K01819', '2020-11-24 08:10:27'),
('M10311920200518182000', 'K01819', '2020-11-24 08:10:56'),
('K0181920200519142100', 'K01819', '2020-11-24 08:11:14'),
('M9678120200527102816', 'M96781', '2020-11-24 08:25:21'),
('M9678120200527102746', 'M96781', '2020-11-24 08:25:36'),
('M9678120200527103215', 'M96781', '2020-11-24 08:25:55'),
('K0181920201116190913', 'K01819', '2020-11-24 15:32:19'),
('K0003820201106175948', 'K01819', '2020-11-24 15:33:05'),
('K0181920201116190913', 'K01819', '2020-11-24 15:33:28'),
('K0181920201116190913', 'K01819', '2020-11-24 15:33:34'),
('K0003820201106175948', 'K01819', '2020-11-24 15:47:42'),
('K0003820201106175948', 'K01819', '2020-11-24 15:49:25'),
('K0003820201106175948', 'K01819', '2020-11-24 15:50:33'),
('K0181920201116190913', 'K01819', '2020-11-25 08:50:22'),
('K0181920201116190913', 'M103119', '2020-11-25 09:14:32'),
('K0181920201116190913', 'M103119', '2020-11-25 12:04:25'),
('M10311920200508184026', 'M103119', '2020-11-25 12:07:53'),
('M10311920200508184026', 'M103119', '2020-11-25 12:08:17'),
('M10311920200616165755', 'M103119', '2020-11-25 12:08:27'),
('M10311920200603114141', 'M103119', '2020-11-25 12:08:35'),
('K0181920201021105224', 'M103119', '2020-11-25 12:08:42'),
('M10311920200603114218', 'M103119', '2020-11-25 12:09:25'),
('M10311920200605113604', 'M103119', '2020-11-25 12:09:42'),
('K0181920201116190913', 'K01819', '2020-11-26 17:35:44'),
('K0181920201116190913', 'K01819', '2020-11-26 17:37:18'),
('K0003820201106175948', 'K01819', '2020-11-26 17:40:06'),
('K0181920201116191639', 'K01819', '2020-11-26 17:41:24'),
('M9678120201127094319', 'M96781', '2020-11-27 08:43:25'),
('K0181920201116191639', 'K00038', '2020-11-27 09:58:41'),
('K0003820201106175948', 'K01819', '2020-11-27 10:00:39'),
('K0181920201116191639', 'K01819', '2020-11-27 10:00:39'),
('K0181920201116191639', 'K01819', '2020-11-27 10:00:52'),
('K0181920201116191639', 'M103119', '2020-11-27 10:07:47'),
('M10311920200715142645', 'M103119', '2020-11-27 10:10:26'),
('M10311920200715142645', 'M103119', '2020-11-27 10:13:24'),
('M10311920200715142645', 'M103119', '2020-11-27 10:21:19'),
('M10311920200715142645', 'M103119', '2020-11-27 10:22:15'),
('M9976420200716111858', 'M103119', '2020-11-27 10:23:23'),
('M10311920200715142645', 'M103119', '2020-11-27 10:23:31'),
('M10311920200918124625', 'M103119', '2020-11-27 10:51:32'),
('M10311920200918124625', 'K01819', '2020-11-27 15:30:11'),
('M10311920200918124625', 'K01819', '2020-11-27 15:30:43'),
('M10311920200918124625', 'K01819', '2020-11-27 15:31:10'),
('K0181920201021105059', 'K01819', '2020-12-01 08:52:08'),
('K0181920201116191639', 'K01819', '2020-12-02 09:25:15'),
('K0181920201116191639', 'M103119', '2020-12-02 09:53:45'),
('M9976420200716111858', 'M103119', '2020-12-02 09:54:07'),
('M10311920200506160553', 'M103119', '2020-12-02 09:54:23'),
('K0181920201021105431', 'M103119', '2020-12-02 09:54:44'),
('M10311920201202110013', 'M103119', '2020-12-02 10:00:18'),
('M10311920201020133640', 'M97981', '2020-12-03 11:50:24'),
('M10311920201020133640', 'M97981', '2020-12-04 08:07:32'),
('M9798120201110100100', 'M97981', '2020-12-07 17:59:43'),
('M9798120201207190352', 'M97981', '2020-12-07 18:03:55'),
('M9798120201207190352', 'M97981', '2020-12-07 18:05:17'),
('M9798120201207190352', 'M97981', '2020-12-09 08:01:12'),
('M9798120201207190352', 'M97981', '2020-12-09 08:19:40'),
('M9798120201207190352', 'M97981', '2020-12-09 08:21:22'),
('M9798120201207190352', 'M97981', '2020-12-09 08:44:18'),
('M9798120201207190352', 'M97981', '2020-12-09 10:18:46'),
('M9798120201207190352', 'M97981', '2020-12-09 10:50:51'),
('M9798120201207190352', 'M97981', '2020-12-09 11:48:02'),
('M10311920201020133640', 'M97981', '2020-12-09 11:48:08'),
('M9798120201207190352', 'M97981', '2020-12-09 11:55:38'),
('M9798120201207190352', 'K01819', '2020-12-09 11:59:56'),
('M9798120201207190352', 'M97981', '2020-12-09 12:07:46'),
('M9798120201207190352', 'M97981', '2020-12-09 13:21:02'),
('M9798120201207190352', 'M97981', '2020-12-09 13:21:29'),
('M9798120201207190352', 'M97981', '2020-12-09 15:05:56'),
('M9798120201207190352', 'M97981', '2020-12-09 15:36:06'),
('M9798120201207190352', 'M97981', '2020-12-10 08:03:23'),
('M10311920201020133640', 'M97981', '2020-12-10 09:11:54'),
('M9798120201207190352', 'M97981', '2020-12-10 10:37:34'),
('M9798120201021132429', 'K01819', '2020-12-10 19:46:15'),
('K0181920201119194624', 'K01819', '2020-12-10 19:46:19'),
('K0181920200908134004', 'K01819', '2020-12-10 19:49:23'),
('M10311920200510171729', 'M103119', '2020-12-11 11:06:52'),
('M10311920200510171729', 'M103119', '2020-12-11 11:15:13'),
('M10311920201202110013', 'M103119', '2020-12-11 11:15:52'),
('K0218420201211134455', 'K02184', '2020-12-11 12:45:02'),
('K0015320201211141623', 'K00153', '2020-12-11 13:22:51'),
('K0015320201211141623', 'K00153', '2020-12-11 13:23:09'),
('K0015320201211141415', 'K00153', '2020-12-11 13:23:26'),
('K0218420201211142448', 'K02184', '2020-12-11 13:24:57'),
('K0003820201106175948', 'K01819', '2020-12-11 14:37:36'),
('K0181920201116191639', 'K01819', '2020-12-11 14:38:09'),
('M10311920201020120255', 'M103119', '2020-12-12 10:34:19'),
('M10311920200506160203', 'M103119', '2020-12-12 10:34:28'),
('M9678120200519115654', 'M103119', '2020-12-12 10:34:38'),
('M10311920200510171729', 'M103119', '2020-12-12 10:35:00'),
('M10311920200510171729', 'M103119', '2020-12-12 10:35:18'),
('M10311920201118085056', 'M103119', '2020-12-12 10:35:39'),
('K0181920200519172013', 'M103119', '2020-12-12 10:36:38'),
('M10311920200518181525', 'M103119', '2020-12-12 10:37:07'),
('M9034920201211142501', 'M90349', '2020-12-14 11:59:33'),
('M10311920201214143255', 'M103119', '2020-12-14 13:35:24'),
('M1234020201214153423', 'M12340', '2020-12-14 14:35:14'),
('M1234020201214153423', 'M12340', '2020-12-14 14:35:46'),
('M1234020201214153423', 'M12340', '2020-12-14 14:36:01'),
('M1234020201214153423', 'M12340', '2020-12-14 14:36:47'),
('M1234020201214153423', 'M12340', '2020-12-14 14:37:10'),
('M1234020201214153423', 'M12340', '2020-12-14 14:37:29'),
('M1234020201214153423', 'M12340', '2020-12-14 14:37:34'),
('M1234020201214153423', 'M12340', '2020-12-14 14:37:39'),
('M1234020201214153423', 'M12340', '2020-12-14 14:37:46'),
('M1234020201214153423', 'M12340', '2020-12-14 14:39:06'),
('M10311920200506160553', 'M103119', '2020-12-14 18:10:39'),
('K0218420201211135502', 'K02184', '2020-12-15 09:57:13'),
('K0218420201211141335', 'K02184', '2020-12-15 09:57:56'),
('K0218420201211141335', 'K02184', '2020-12-15 09:58:29'),
('K0218420201215114304', 'K02184', '2020-12-15 10:43:25'),
('K0218420201211142643', 'K02184', '2020-12-15 11:16:38'),
('M10311920201202110013', 'M103119', '2020-12-15 14:03:29'),
('M10311920201202110013', 'M103119', '2020-12-15 14:03:29'),
('M10311920201118085056', 'M103119', '2020-12-15 14:06:21'),
('M10311920201118085056', 'M103119', '2020-12-15 14:06:39'),
('M10311920201118085056', 'M103119', '2020-12-15 14:07:12'),
('M10311920201118085056', 'M103119', '2020-12-15 14:08:12'),
('K0181920201116191639', 'K14379', '2020-12-15 15:16:26'),
('M10311920201118085056', 'M103119', '2020-12-15 15:30:17'),
('M10311920201118085056', 'M103119', '2020-12-15 15:31:06'),
('M10311920201118085056', 'M103119', '2020-12-15 15:52:52'),
('M10311920201202110013', 'M103119', '2020-12-15 15:53:02'),
('M10311920201202110013', 'M103119', '2020-12-15 16:14:53'),
('K0181920201116191639', 'M103119', '2020-12-15 16:15:06'),
('M10311920201202110013', 'M103119', '2020-12-15 16:44:40'),
('M10311920201202110013', 'M103119', '2020-12-16 08:18:00'),
('M10311920201202110013', 'M103119', '2020-12-16 08:22:37'),
('M10311920201202110013', 'M103119', '2020-12-16 08:25:01'),
('M10311920201118085056', 'K01819', '2020-12-16 09:07:19'),
('M10311920201118085056', 'K01819', '2020-12-16 09:08:59'),
('M9798120201207190352', 'K01819', '2020-12-16 09:12:32'),
('M10311920201118085056', 'M103119', '2020-12-16 09:13:42'),
('K0218420201211142643', 'K02184', '2020-12-16 09:13:45'),
('M10311920201118085056', 'K01819', '2020-12-16 09:14:04'),
('M9034920201211142501', 'M90349', '2020-12-16 09:20:13'),
('K0181920201116191639', 'K01819', '2020-12-16 09:24:20');
INSERT INTO `seguimiento` (`id`, `meta`, `fecha`) VALUES
('K0181920201116191639', 'M103119', '2020-12-16 09:37:23'),
('K0181920201116191639', 'M103119', '2020-12-16 09:39:04'),
('M10311920201202110013', 'M103119', '2020-12-16 09:39:48'),
('M10311920201202110013', 'M103119', '2020-12-16 09:40:18'),
('M10311920200508190947', 'M103119', '2020-12-16 09:40:37'),
('M10311920200506135949', 'M103119', '2020-12-16 09:40:43'),
('K0218420201216104339', 'K02184', '2020-12-16 09:48:34'),
('M10311920200510170147', 'K01819', '2020-12-16 09:55:10'),
('M10311920200510165928', 'K01819', '2020-12-16 09:56:36'),
('K0218420201215114304', 'K02184', '2020-12-16 09:56:36'),
('K0218420201211142643', 'K02184', '2020-12-16 11:01:26'),
('K0218420201216104339', 'K02184', '2020-12-16 11:01:56'),
('K0218420201211142448', 'K02184', '2020-12-16 11:02:52'),
('K0218420201211142856', 'K02184', '2020-12-16 11:03:49'),
('K0218420201215123105', 'K02184', '2020-12-16 11:04:48'),
('20200518185046', 'M103119', '2020-12-16 11:09:33'),
('M10311920201118085056', 'M103119', '2020-12-16 11:09:40'),
('M10311920201202110013', 'M103119', '2020-12-16 11:11:41'),
('K0218420201216115453', 'K02184', '2020-12-16 11:30:15'),
('M10311920200506160804', 'M103119', '2020-12-16 11:34:49'),
('M10311920200506160804', 'M103119', '2020-12-16 11:34:55'),
('K0218420201215114304', 'K02184', '2020-12-16 11:35:28'),
('M10311920200506160804', 'M103119', '2020-12-16 11:36:13'),
('', 'K02184', '2020-12-16 11:36:24'),
('K0181920201113144508', 'M103119', '2020-12-16 11:36:57'),
('M10311920200706112921', 'M103119', '2020-12-16 11:37:00'),
('M10311920200506154610', 'M103119', '2020-12-16 11:37:02'),
('M10311920200506160203', 'M103119', '2020-12-16 11:37:03'),
('20200508172919', 'M103119', '2020-12-16 11:37:04'),
('M10311920200603114218', 'M103119', '2020-12-16 11:37:37'),
('M10311920200510171729', 'M103119', '2020-12-16 11:38:44'),
('M10311920200514091111', 'M103119', '2020-12-16 11:38:57'),
('M10311920200506135949', 'M103119', '2020-12-16 11:39:41'),
('M10311920200508184026', 'M103119', '2020-12-16 11:42:28'),
('M10311920200506154610', 'M103119', '2020-12-16 11:43:28'),
('M9678120200519115750', 'M103119', '2020-12-16 11:44:53'),
('M10311920200508191757', 'M103119', '2020-12-16 11:45:05'),
('M10311920200514091111', 'M103119', '2020-12-16 11:45:08'),
('M10311920200506140217', 'M103119', '2020-12-16 11:45:18'),
('M10311920200518112207', 'M103119', '2020-12-16 11:46:42'),
('M10311920200506160203', 'M103119', '2020-12-16 11:58:13'),
('M10311920200506160203', 'M103119', '2020-12-16 11:59:05'),
('20200508172919', 'M103119', '2020-12-16 12:00:52'),
('M10311920200506160804', 'M103119', '2020-12-16 12:01:21'),
('M10311920201214143255', 'M103119', '2020-12-16 12:01:32'),
('M10311920200506160553', 'M103119', '2020-12-16 12:02:46'),
('M10311920200918124625', 'M103119', '2020-12-16 12:02:59'),
('M10311920200506160804', 'M103119', '2020-12-16 12:03:09'),
('M10311920200506161227', 'M103119', '2020-12-16 12:10:06'),
('M10311920200706112921', 'M103119', '2020-12-16 12:10:53'),
('M10311920200506114803', 'M103119', '2020-12-16 12:11:20'),
('M10311920200710123149', 'M103119', '2020-12-16 12:11:45'),
('M10311920201020120255', 'M103119', '2020-12-16 12:13:57'),
('M10311920201202110013', 'M103119', '2020-12-16 12:14:07'),
('M10311920201020120255', 'M103119', '2020-12-16 12:15:48'),
('M10311920201202110013', 'M103119', '2020-12-16 12:15:54'),
('K0181920201116191639', 'M103119', '2020-12-16 12:16:05'),
('M9678120200519115841', 'M103119', '2020-12-16 12:16:23'),
('K0181920201116191639', 'M103119', '2020-12-16 12:16:29'),
('M10311920200601181044', 'M103119', '2020-12-16 12:18:59'),
('M10311920200909184938', 'M103119', '2020-12-16 12:19:04'),
('M10311920200918111757', 'M103119', '2020-12-16 12:19:07'),
('M10311920200508102317', 'M103119', '2020-12-16 12:19:20'),
('M10311920200510170456', 'M103119', '2020-12-16 12:21:50'),
('M10311920200510170147', 'M103119', '2020-12-16 12:21:53'),
('K0017820201020165755', 'M103119', '2020-12-16 12:23:13'),
('M1234020201022113548', 'M103119', '2020-12-16 12:23:15'),
('K0017820201020165755', 'M103119', '2020-12-16 12:23:56'),
('M10311920200508190947', 'M103119', '2020-12-16 12:24:08'),
('K0181920201116191639', 'M103119', '2020-12-16 12:24:17'),
('M10311920201118085056', 'M103119', '2020-12-16 12:26:53'),
('M10311920201118085056', 'M103119', '2020-12-16 12:27:37'),
('M10311920201118085056', 'M103119', '2020-12-16 12:28:50'),
('M10311920201118085056', 'M103119', '2020-12-16 12:29:43'),
('M10311920201118085056', 'M103119', '2020-12-16 12:30:30'),
('M10311920200518181525', 'M103119', '2020-12-16 12:30:50'),
('K0181920200518183850', 'M103119', '2020-12-16 12:30:53'),
('M10311920200518181525', 'M103119', '2020-12-16 12:30:57'),
('M10311920201020120255', 'M103119', '2020-12-16 12:31:15'),
('M10311920200508102317', 'M103119', '2020-12-16 12:31:21'),
('M1234020201022113548', 'M103119', '2020-12-16 12:31:30'),
('M10311920201202110013', 'M103119', '2020-12-16 12:31:38'),
('M10311920201118085056', 'M103119', '2020-12-16 12:31:46'),
('M10311920200506160203', 'M103119', '2020-12-16 12:33:36'),
('M10311920200508191757', 'M103119', '2020-12-16 12:33:41'),
('20200508172919', 'M103119', '2020-12-16 12:33:50'),
('M10311920201020133640', 'M103119', '2020-12-16 12:33:57'),
('M10311920200918111757', 'M103119', '2020-12-16 12:34:07'),
('M10311920200605113604', 'M103119', '2020-12-16 12:34:20'),
('K0017820201022114636', 'M103119', '2020-12-16 12:34:29'),
('K0181920201116191639', 'M103119', '2020-12-16 12:34:50'),
('M10311920201118085056', 'M103119', '2020-12-16 12:35:27'),
('K0181920201216172549', 'K01819', '2020-12-16 16:26:08'),
('K0181920201116191639', 'K01819', '2020-12-16 16:59:30'),
('K0181920201216172549', 'M103119', '2020-12-16 17:21:55'),
('K0181920201116191639', 'M103119', '2020-12-16 17:25:24'),
('M9678120200519115750', 'M103119', '2020-12-16 17:27:15'),
('K0181920201113144508', 'M103119', '2020-12-16 17:27:35'),
('20200508172919', 'M103119', '2020-12-16 17:27:39'),
('M10311920200518112207', 'M103119', '2020-12-16 17:28:09'),
('M10311920200510171729', 'M103119', '2020-12-16 17:28:24'),
('M10311920200508102317', 'M103119', '2020-12-16 17:28:32'),
('M10311920200510170147', 'M103119', '2020-12-16 17:28:47'),
('K0181920201216172549', 'M103119', '2020-12-16 17:29:21'),
('M10311920201118085056', 'M103119', '2020-12-16 17:29:42'),
('M10311920200506181314', 'M103119', '2020-12-16 18:14:27'),
('M10311920200918124625', 'K01819', '2020-12-16 19:21:52'),
('M1234020201022142013', 'K01819', '2020-12-16 19:22:13'),
('M10311920200510170456', 'K01819', '2020-12-16 19:22:26'),
('M11157620201216203731', 'M111576', '2020-12-16 19:37:35'),
('M11157620201216203731', 'M111576', '2020-12-16 20:19:21'),
('M11157620201216203731', 'M111576', '2020-12-16 20:19:28'),
('M11157620201216203731', 'M111576', '2020-12-16 20:19:38'),
('K0017820201217104213', 'K00178', '2020-12-17 09:42:20'),
('K0017820201217105815', 'K00178', '2020-12-17 09:58:21'),
('M1234020201022105241', 'K00178', '2020-12-17 09:58:24'),
('M9798120201020164923', 'K00178', '2020-12-17 09:58:31'),
('M1234020201022105241', 'K00178', '2020-12-17 09:58:39'),
('K0017820201020165755', 'K00178', '2020-12-17 09:59:58'),
('M1234020201022125436', 'K00178', '2020-12-17 10:00:01'),
('M1234020201022110143', 'K00178', '2020-12-17 10:00:03'),
('K0017820201020165938', 'K00178', '2020-12-17 10:00:06'),
('M1234020201022111620', 'K00178', '2020-12-17 10:05:02'),
('M10311920200510164422', 'K00178', '2020-12-17 10:05:09'),
('M10311920200510165928', 'K00178', '2020-12-17 10:05:15'),
('M1234020201022111620', 'K00178', '2020-12-17 10:05:32'),
('M10311920200510164422', 'K00178', '2020-12-17 10:05:35'),
('M10311920200510165928', 'K00178', '2020-12-17 10:05:38'),
('K0017820201217105815', 'K00178', '2020-12-17 10:05:45'),
('M10311920201202110013', 'M103119', '2020-12-17 10:11:57'),
('K0181920201216172549', 'M103119', '2020-12-17 10:12:27'),
('K0181920201216172549', 'M103119', '2020-12-17 10:54:12'),
('M13233120201217130644', 'M132331', '2020-12-17 12:06:55'),
('M13233120201217130429', 'M132331', '2020-12-17 12:07:07'),
('M13233120201217130541', 'M132331', '2020-12-17 12:07:21'),
('M13233120201217130541', 'M132331', '2020-12-17 12:09:53'),
('M13233120201217130541', 'M132331', '2020-12-17 12:10:40'),
('M13233120201217130644', 'M132331', '2020-12-17 12:10:57'),
('M13233120201217130429', 'M132331', '2020-12-17 12:11:07'),
('M13233120201217130429', 'M132331', '2020-12-17 12:11:16');

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

--
-- Estructura de tabla para la tabla `tareas`
--

CREATE TABLE IF NOT EXISTS `tareas` (
  `ID` varchar(32) NOT NULL,
  `meta` varchar(15) NOT NULL,
  `propietario` varchar(15) NOT NULL,
  `titulo` varchar(64) NOT NULL,
  `Descripcion` varchar(256) NOT NULL,
  `fCreacion` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `prioridad` int(1) NOT NULL,
  `fInicio` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `fFin` timestamp NULL DEFAULT NULL,
  `completada` tinyint(1) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

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

INSERT INTO `tareas` (`ID`, `meta`, `propietario`, `titulo`, `Descripcion`, `fCreacion`, `prioridad`, `fInicio`, `fFin`, `completada`) VALUES
('M10311920200518182000', 'M103119', 'M103119', 'APP Agenda', 'Mejoras de la app', '2020-05-18 16:20:00', 1, '2020-05-18 16:19:00', '2020-05-31 16:19:00', 1),
('M10311920200518152433', 'M103119', 'M103119', 'Migrar Script', 'Migrar scripts desde 180 a Lenovo', '2020-05-18 13:24:33', 1, '2020-05-18 13:23:00', '2020-05-31 13:23:00', 1),
('M10311920200518152118', 'M103119', 'M103119', 'Controles Finde', 'APP ver los CHK actividades', '2020-05-18 13:21:18', 1, '2020-05-18 13:19:00', '2020-05-24 13:19:00', 1),
('20200518185046', 'K01819', 'K01819', 'Skill Transolver', 'Incluir Skill Transolver en portal de informes', '2020-05-18 16:50:46', 1, '2020-05-18 16:49:00', '2020-05-18 16:49:00', 1),
('K0181920200519090038', 'K01819', 'K01819', 'Ordenación CHAT Konecta', 'Ordenación CHAT Konecta', '2020-05-19 07:00:38', 1, '2020-05-19 06:59:00', '2020-05-19 06:59:00', 1),
('K0181920200519142100', 'K01819', 'K01819', 'Reporte Intraday', 'Incluir nuevo destinatario', '2020-05-19 12:21:00', 1, '2020-05-19 12:20:00', '2020-05-19 12:20:00', 1),
('K0181920200519172013', 'K01819', 'K01819', 'Asignación LEADs ARVAL', 'No igualar LEADs semanales', '2020-05-19 15:20:13', 1, '2020-05-19 15:19:00', '2020-05-19 15:19:00', 1),
('K0181920200520084601', 'K01819', 'K01819', 'Telefonía AVAYA ONE X', 'Agentes sin AOX en SCR', '2020-05-20 06:46:01', 0, '2020-05-20 06:45:00', '2020-05-20 06:45:00', 1),
('M10311920200525103358', 'M103119', 'M103119', 'Tareas SOR', 'Apuntar las tareas SOR Sara', '2020-05-25 08:33:58', 1, '2020-05-25 08:33:00', '2020-05-31 08:33:00', 1),
('K0181920200603093348', 'K01819', 'K01819', 'Revisión Informe Spring Campaing', 'Revisar Comerciales ', '2020-06-03 07:33:48', 1, '2020-06-03 07:32:00', '2020-06-03 07:32:00', 1),
('M10311920200616100227', 'M103119', 'M103119', 'FLOTA PROA', 'Plan de ejecucion flota', '2020-06-16 08:02:27', 1, '2020-06-16 08:01:00', '2020-06-16 08:01:00', 1),
('K0181920200810185617', 'K01819', 'K01819', 'REFLEX', 'Añadir campo comercial en reporting cliente', '2020-08-10 16:56:17', 1, '2020-08-10 16:55:00', '2020-08-10 16:55:00', 1),
('M9941320200825153803', 'M99413', 'M99413', 'Prueba Task', 'Prueba Task', '2020-08-25 13:38:03', 1, '2020-08-25 13:37:00', '2020-08-28 13:37:00', 1),
('M9798120201023141706', 'M97981', 'M97981', 'Y44G00000000008  ', '10 contratos 27 octubre', '2020-10-23 12:17:06', 0, '2020-10-23 12:16:00', '2020-10-28 13:16:00', 1),
('M9798120201106162446', 'M97981', 'M97981', '09 noviembre', 'PENDIENTE', '2020-11-06 15:24:46', 1, '2020-11-09 15:24:00', '2020-11-10 15:24:00', 1),
('K0181920201116190308', 'K01819', 'K01819', 'Modulo de Reporting APP Activos', 'APP Activos', '2020-11-16 18:03:08', 0, '2020-11-16 18:02:00', '2020-11-17 18:32:00', 1),
('K0003820201106175948', 'K00038', 'K00038', 'MANUALES COM00045', 'Incluir icono de manuales ', '2020-11-06 16:59:48', 0, '2020-11-06 16:59:00', '2020-11-06 16:59:00', 0),
('K0181920201116190913', 'K01819', 'K01819', 'MANUALES COM00045', 'APP censado de ficheros COM00045', '2020-11-16 18:09:13', 1, '2020-11-16 18:08:00', '2020-11-26 17:36:00', 1),
('K0181920201116191639', 'K01819', 'K01819', 'Proyecto Control de Facturación y Costes', 'APP Control Costes y Facturación (Global Desk)', '2020-11-16 18:16:39', 1, '2020-11-16 18:15:00', '2021-01-24 18:15:00', 0),
('M10311920201202110013', 'M103119', 'M103119', 'Informe Mensual Eventos', 'Informe Mensual Eventos', '2020-12-02 10:00:13', 1, '2020-12-02 10:00:00', '2020-12-28 10:00:00', 1),
('M9034920201211142501', 'M90349', 'M90349', 'anexos incorporación agentes presenciales', '', '2020-12-11 13:25:01', 1, '2020-12-14 07:00:00', '2020-12-14 08:00:00', 0),
('K0181920201216172549', 'K01819', 'K01819', 'APP Campaña Navidad MTR ARVAL', 'Renting Flexible', '2020-12-16 16:25:49', 0, '2020-12-16 16:24:00', '2020-12-18 11:00:00', 0);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `contactos`
--
ALTER TABLE `contactos`
  ADD PRIMARY KEY (`ID`);

--
-- Indices de la tabla `notas`
--
ALTER TABLE `notas`
  ADD PRIMARY KEY (`ID`);

--
-- Indices de la tabla `participantes`
--
ALTER TABLE `participantes`
  ADD PRIMARY KEY (`ID`,`idAsist`);

--
-- Indices de la tabla `participantesEXTN`
--
ALTER TABLE `participantesEXTN`
  ADD PRIMARY KEY (`ID`,`nombre`);

--
-- Indices de la tabla `reuniones`
--
ALTER TABLE `reuniones`
  ADD PRIMARY KEY (`idReunion`);

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

--
-- Indices de la tabla `tareas`
--
ALTER TABLE `tareas`
  ADD PRIMARY KEY (`ID`);
