portal_usuarios_last.sql

-- phpMyAdmin SQL Dump
-- version 4.9.1
-- https://www.phpmyadmin.net/
--
-- Servidor: 127.0.0.1
-- Tiempo de generación: 01-11-2019 a las 23:07:58
-- Versión del servidor: 10.4.8-MariaDB
-- Versión de PHP: 7.1.32

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de datos: `portal_usuarios`
--

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

--
-- Estructura de tabla para la tabla `administrador`
--

CREATE TABLE `administrador` (
  `id` int(11) NOT NULL,
  `nombre` varchar(100) NOT NULL,
  `apellidos` varchar(100) NOT NULL,
  `correo` varchar(100) NOT NULL,
  `contrasena` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `administrador` (`id`, `nombre`, `apellidos`, `correo`, `contrasena`) VALUES
(1, 'Admin1', 'admon', 'admin@hotmail.com', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220');

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

--
-- Estructura de tabla para la tabla `ci_rango`
--

CREATE TABLE `ci_rango` (
  `id` int(11) NOT NULL,
  `id_rango_ci` int(11) NOT NULL,
  `id_ci` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `ci_rango` (`id`, `id_rango_ci`, `id_ci`) VALUES
(1, 1, 123),
(2, 2, 98),
(3, 2, 99),
(4, 2, 100),
(5, 2, 101),
(6, 2, 102),
(7, 2, 103),
(8, 2, 104),
(9, 2, 105),
(10, 2, 106),
(11, 2, 107),
(12, 2, 108),
(13, 2, 109),
(14, 2, 110),
(15, 2, 111),
(16, 2, 112),
(17, 2, 113),
(18, 2, 114),
(19, 2, 115),
(20, 2, 117),
(21, 2, 118),
(22, 2, 119),
(23, 2, 120),
(24, 2, 121),
(25, 2, 122),
(26, 3, 28),
(27, 3, 29),
(28, 3, 30),
(29, 3, 31),
(30, 3, 32),
(31, 3, 33),
(32, 3, 34),
(33, 3, 35),
(34, 3, 36),
(35, 3, 37),
(36, 3, 38),
(37, 3, 39),
(38, 3, 39),
(39, 3, 40),
(40, 3, 41),
(41, 3, 42),
(42, 3, 43),
(43, 3, 44),
(44, 3, 45),
(45, 3, 46),
(46, 3, 47),
(47, 3, 48),
(48, 3, 49),
(49, 3, 50),
(50, 3, 51),
(51, 3, 52),
(52, 3, 53),
(53, 3, 54),
(54, 3, 55),
(55, 3, 56),
(56, 3, 57),
(57, 3, 58),
(58, 3, 59),
(59, 3, 60),
(60, 3, 61),
(61, 3, 62),
(62, 3, 63),
(63, 3, 64),
(64, 3, 65),
(65, 3, 66),
(66, 3, 67),
(67, 3, 68),
(68, 3, 69),
(69, 3, 70),
(70, 3, 71),
(71, 3, 72),
(72, 3, 73),
(73, 3, 75),
(74, 3, 76),
(75, 3, 77),
(76, 3, 78),
(77, 3, 79),
(78, 3, 80),
(79, 3, 81),
(80, 3, 82),
(81, 3, 83),
(82, 3, 84),
(83, 3, 85),
(84, 3, 86),
(85, 3, 87),
(86, 3, 88),
(87, 3, 89),
(88, 3, 90),
(89, 3, 91),
(90, 3, 92),
(91, 3, 93),
(92, 3, 94),
(93, 3, 95),
(94, 3, 96),
(95, 3, 97),
(121, 4, 1),
(122, 4, 2),
(123, 4, 5),
(124, 4, 6),
(125, 4, 7),
(126, 4, 8),
(127, 4, 9),
(128, 4, 10),
(129, 4, 11),
(130, 4, 12),
(131, 4, 13),
(132, 4, 14),
(133, 4, 15),
(134, 4, 16),
(135, 4, 17),
(136, 4, 18),
(137, 4, 19),
(138, 4, 20),
(139, 4, 21),
(140, 4, 22);

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

--
-- Estructura de tabla para la tabla `c_i`
--

CREATE TABLE `c_i` (
  `id` int(11) NOT NULL,
  `punto` int(11) NOT NULL,
  `punto_CI` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `c_i` (`id`, `punto`, `punto_CI`) VALUES
(1, 67, '80'),
(2, 68, '80'),
(3, 70, '81'),
(4, 71, '81'),
(5, 72, '82'),
(6, 73, '82'),
(7, 74, '82'),
(8, 75, '83'),
(9, 76, '83'),
(10, 77, '84'),
(11, 78, '84'),
(12, 79, '84'),
(13, 80, '84'),
(14, 81, '85'),
(15, 82, '85'),
(16, 83, '86'),
(17, 84, '86'),
(18, 85, '86'),
(19, 86, '87'),
(20, 87, '88'),
(21, 88, '88'),
(22, 89, '88'),
(23, 90, '88'),
(24, 91, '89'),
(25, 92, '89'),
(26, 93, '89'),
(27, 93, '89'),
(28, 94, '90'),
(29, 95, '90'),
(30, 96, '90'),
(31, 97, '91'),
(32, 98, '91'),
(33, 99, '91'),
(34, 100, '92'),
(35, 101, '92'),
(36, 102, '92'),
(37, 103, '93'),
(38, 104, '93'),
(39, 105, '94'),
(40, 106, '94'),
(41, 107, '95'),
(42, 108, '95'),
(43, 109, '95'),
(44, 110, '96'),
(45, 111, '96'),
(46, 112, '96'),
(47, 113, '96'),
(48, 114, '97'),
(49, 115, '97'),
(50, 116, '97'),
(51, 117, '98'),
(52, 118, '98'),
(53, 119, '98'),
(54, 120, '99'),
(55, 121, '99'),
(56, 122, '99'),
(57, 123, '99'),
(58, 124, '100'),
(59, 125, '100'),
(60, 126, '101'),
(61, 127, '101'),
(62, 128, '101'),
(63, 129, '101'),
(64, 130, '102'),
(65, 131, '102'),
(66, 132, '102'),
(67, 133, '102'),
(68, 134, '103'),
(69, 135, '103'),
(70, 136, '103'),
(71, 137, '103'),
(72, 138, '104'),
(73, 139, '104'),
(74, 140, '104'),
(75, 141, '104'),
(76, 142, '105'),
(77, 143, '105'),
(78, 144, '105'),
(79, 145, '105'),
(80, 146, '106'),
(81, 147, '107'),
(82, 148, '107'),
(83, 149, '107'),
(84, 150, '107'),
(85, 151, '107'),
(86, 152, '107'),
(87, 153, '107'),
(88, 154, '108'),
(89, 154, '108'),
(90, 155, '108'),
(91, 156, '108'),
(92, 157, '108'),
(93, 158, '109'),
(94, 159, '109'),
(95, 160, '110'),
(96, 161, '110'),
(97, 162, '110'),
(98, 163, '111'),
(99, 164, '111'),
(100, 165, '111'),
(101, 166, '111'),
(102, 167, '112'),
(103, 168, '113'),
(104, 169, '113'),
(105, 170, '113'),
(106, 171, '114'),
(107, 172, '114'),
(108, 173, '114'),
(109, 174, '115'),
(110, 175, '115'),
(111, 176, '116'),
(112, 177, '116'),
(113, 178, '117'),
(114, 179, '117'),
(115, 178, '117'),
(116, 179, '117'),
(117, 180, '117'),
(118, 181, '118'),
(119, 182, '118'),
(120, 183, '118'),
(121, 184, '119'),
(122, 185, '119'),
(123, 186, '120');

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

--
-- Estructura de tabla para la tabla `preguntas`
--

CREATE TABLE `preguntas` (
  `id` int(11) NOT NULL,
  `pregunta` varchar(350) NOT NULL,
  `segmento_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `preguntas` (`id`, `pregunta`, `segmento_id`) VALUES
(5, 'La gasolina se extrae de:', 1),
(6, 'Una tonelada tiene: ', 1),
(7, 'La mayoría de nuestras exportaciones salen por: ', 1),
(8, 'El nervio óptico sirve para:', 1),
(9, 'El café es una especie de:', 1),
(10, 'El jamón es carne de: ', 1),
(11, 'La laringe está en:', 1),
(14, 'La guillotina causa:', 1),
(15, 'La grúa se usa para:', 1),
(16, 'Una figura de seis lados se llama:', 1),
(17, 'El kilowatt mide:', 1),
(18, 'La pauta se usa en:', 1),
(19, 'Las esmeraldas son:', 1),
(20, 'El metro es aproximadamente igual a:', 1),
(21, 'Las esponjas se obtienen de:', 1),
(22, 'Fraude es un termino usado en:', 1),
(23, 'Si la tierra estuviera más cerca del sol:', 2),
(34, 'Los rayos de una rueda están frecuentemente hechos de nogal ¿Por qué?', 2),
(35, 'Un tren se detiene con más dificultad que un automóvil ¿Por qué?', 2),
(36, 'El dicho: \"A golpecitos se derriba un roble\" quiere decir:', 2),
(37, 'El dicho: \"Una olla vigilada nunca hierve\" quiere decir:', 2),
(38, 'El dicho: \"Siembre pasto mientras haya sol\" quiere decir:', 2),
(39, 'El dicho: \"Zapatero a tus zapatos\" quiere decir:', 2),
(40, 'El dicho: \"La cuña para que apriete tiene que ser del mismo palo\" quiere decir:', 2),
(41, 'Un acorazado de acero flota porque:', 2),
(42, 'Las plumas de las alas ayudan al pájaro a volar porque:', 2),
(43, 'El dicho \"Una golondrina no hace verano\" quiere decir:', 2),
(44, 'Salado - Dulce', 3),
(45, 'Alegrarse - Regocijarse', 3),
(46, 'Mayor - Menor', 3),
(47, 'Sentarse - Pararse', 3),
(48, 'Desperdiciar - Aprovechar', 3),
(49, 'Conceder - Negar', 3),
(50, 'Tónico - Estimulante', 3),
(51, 'Rebajar - Denigrar', 3),
(52, 'Prohibir - Permitir', 3),
(53, 'Osado - Audaz', 3),
(54, 'Arrebatido - Pruedente', 3),
(55, 'Obtuso - Agudo', 3),
(56, 'Inepto - Experto', 3),
(57, 'Esquivar - Rehuir', 3),
(58, 'Rebelarse - Someterse', 3),
(59, 'Monotonía - Variedad', 3),
(60, 'Confrontar - Consolar', 3),
(61, 'Expeler - Retener', 3),
(62, 'Dócil - Sumiso', 3),
(63, 'Transitorio - Permanente', 3),
(64, 'Seguridad - Riesgo', 3),
(65, 'Aprobar - Objetar', 3),
(66, 'Expeler - Arrojar', 3),
(67, 'Engaño - Impostura', 3),
(68, 'Mitigar - Apaciguar', 3),
(69, 'Incitar - Aplacar', 3),
(70, 'Reverencia - Veneración', 3),
(71, 'Sobriedad - Frugalidad', 3),
(72, 'Aumentar - Menguar', 3),
(73, 'Iniciar - Instigar', 3),
(74, 'Un circulo tiene siempre: ', 4),
(75, 'Un pájaro tiene siempre:', 4),
(76, 'La música tiene siempre:', 4),
(77, 'Un banquete tiene siempre:', 4),
(78, 'Un caballo tiene siempre:', 4),
(79, 'Un juego tiene siempre:', 4),
(80, 'Un objeto tiene siempre:', 4),
(81, 'Una conversación tiene siempre:', 4),
(82, 'Una deuda implica siempre:', 4),
(83, 'Un ciudadano tiene siempre:', 4),
(84, 'Un museo tiene siempre:', 4),
(85, 'Un compromiso implica siempre:', 4),
(86, 'Un bosque tiene siempre:', 4),
(87, 'Los obstáculos tienen siempre:', 4),
(88, 'El aborrecimiento tiene siempre:', 4),
(89, 'Una revista tiene siempre:', 4),
(90, 'La controversia implica siempre:', 4),
(91, 'Un barco tiene siempre:', 4),
(104, 'A 2 por 5 pesos. ¿Cuántos lápices pueden comprarse con 50 pesos?', 5),
(105, '¿Cuántas horas tardará un automóvil en recorrer 660 kilómetros a la velocidad de 60 kilómetros por hora?', 5),
(106, 'Si un hombre gana $200 diarios y gasta $140. ¿Cuántos días tardará en ahorrar $3,000?', 5),
(107, 'Si dos pasteles cuestan $60, ¿Cuántos pesos cuesta la sexta parte de un pastel?', 5),
(108, '¿Cuántas veces más es 2x3x4x6, que 3x4?', 5),
(109, '¿Cuánto es el 16% de $120?', 5),
(110, 'El cuatro por ciento de $1,000 es igual al ocho por ciento ¿De qué cantidad?', 5),
(111, 'La capacidad de un refrigerador rectangular es de 48 metros cúbicos, si tiene seis metros de largo por cuatro de ancho ¿Cuál es la altura?', 5),
(112, 'SI 7 hombres hacen un pozo de 40 metros en 2 días, ¿Cuántos hombres se necesitan para hacerlo en medio día?', 5),
(113, 'A tiene $180; B tiene 2/3 de lo que tiene A, y C 1/2 de lo que tiene B, ¿Cuánto tienen todos juntos?', 5),
(114, 'Si un hombre corre 10 metros en 10 segundos, ¿Cuántos metros correrá como promedio 1/5 de segundo?', 5),
(115, 'Un hombre gasta 1/4 de su sueldo en casa y alimentos, y 4/8 en otros gastos, ¿Qué tanto por ciento de su sueldo ahorra?', 5),
(116, '¿La higiene es esencial para la salud?', 6),
(117, '¿Los taquígrafos usan el microscopio?', 6),
(118, '¿Los tiranos son justos con sus inferiores?', 6),
(119, '¿Las personas desamparadas están sujetas con frecuencia a caridad?', 6),
(120, '¿Las personas venerables son por lo común respetadas?', 6),
(121, '¿Es el escorbuto un medicamento?', 6),
(122, '¿Es la amonestación una clase de instrumento musical?', 6),
(123, '¿Son los colores opacos preferidos para las banderas nacionales?', 6),
(124, '¿Las cosas misteriosas son a veces pavorosas?', 6),
(125, '¿Personas conscientes cometen alguna vez errores?', 6),
(126, '¿Son carnívoros los carneros?', 6),
(127, '¿Se dan asignaturas a los caballos?', 6),
(128, '¿Las cartas anónimas llevan alguna vez firma de quien las escribe?', 6),
(129, '¿Son discontinuos los sonidos intermitentes?', 6),
(130, '¿Las enfermedades estimulan el buen juicio?', 6),
(131, '¿Son siempre perversos los hechos premeditados?', 6),
(132, '¿El contacto social tiende a reducir la timidez?', 6),
(133, '¿Son enfermas las personas que tienen  mal caracter?', 6),
(134, '¿Se caracteriza generalmente el rencor por la persistencia?', 6),
(135, '¿Meticuloso quiere decir lo mismo que cuidadoso?', 6),
(136, 'Abrigo es a usar como pan es a:', 7),
(137, 'Semana es a mes como mes es a:', 7),
(138, 'León es a animal como rosa es a:', 7),
(139, 'Libertad es a independencia como cautiverio es a:', 7),
(140, 'Decir es a dijo como estar es a:', 7),
(141, 'Lunes es a martes como viernes es a:', 7),
(142, 'Plomo es a pesado como corcho es a:', 7),
(143, 'Éxito es a alegría como fracaso es a:', 7),
(144, 'Gato es a tigre como perro es a:', 7),
(145, '4 es a 16 como 5 es a:', 7),
(146, 'Llorar es a reír como triste es a:', 7),
(147, 'Veneno es a muerte como aliento es a:', 7),
(148, '1 es a 3 como 9 es a:', 7),
(149, 'Alimento es a hambre como agua es a:', 7),
(150, 'Aquí es a allí como este es a:', 7),
(151, 'Tigre es a pelo como trucha es a:', 7),
(152, 'Pervertido es a depravado como incorrupto es a:', 7),
(153, 'B es a D como segundo es a:', 7),
(154, 'Estado es a gobernador como ejército es a:', 7),
(155, 'Sujeto es a predicado como nombre es a:', 7),
(156, 'con crecen los niños edad la', 8),
(157, 'buena mar beber el para agua de es', 8),
(158, 'lo es paz la guerra opuesto de la a', 8),
(159, 'caballos automóvil un que caminan los despacio más ', 8),
(160, 'consejo a veces es buen seguir un difícil', 8),
(161, 'cuatrocientas todos páginas contienen libros los', 8),
(162, 'crecen las que fresas el más roble', 8),
(163, 'verdadera comparada no puede amistad ser', 8),
(164, 'envidia las perjudiciales gula  son y la', 8),
(165, 'nunca acciones premiadas las deben buenas ser', 8),
(166, 'exteriores engañan nunca apariencias las nos', 8),
(167, 'nunca es hombre las que acciones demuestran un lo', 8),
(168, 'ciertas siempre muerte de causa clase enfermedades', 8),
(169, 'odio indeseables aversión sentimientos el son y la', 8),
(170, 'frecuentemente por juzgar podemos acciones hombres nosotros sus a los', 8),
(171, 'una es sábana sarapes tan nunca los calientes como', 8),
(172, 'nunca que descuidados los tropiezan son', 8),
(173, '1', 9),
(174, '2', 9),
(175, '3', 9),
(176, '4', 9),
(177, '5', 9),
(178, '6', 9),
(179, '7', 9),
(180, '8', 9),
(181, '9', 9),
(182, '10', 9),
(183, '11', 9),
(184, '12', 9),
(185, '13', 9),
(186, '14', 9),
(187, '15', 9),
(188, '16', 9),
(189, '17', 9),
(190, '18', 9),
(191, 'Primero  8  7  6  5  4  3', 10),
(192, 'Segundo  3  8  13  18  23  28', 10),
(193, 'Tercero  1  2  4  8  16  32', 10),
(194, 'Cuarto  8  8  6  6  4  4', 10),
(195, 'Quinto  11 1/4   12   12 1/4   12 1/2   12 3/4', 10),
(196, 'Sexto  8  9  12  13  16  17', 10),
(197, 'Séptimo  16  8  4  2  1  1/2', 10),
(198, 'Octavo  31.3  40.3  49.3  58.3  67.3  76.3', 10),
(199, 'Noveno  3  5  4  6  5  7', 10),
(200, 'Décimo  7  11  15  16  20  24  25  29', 10),
(201, 'Undécimo   1/25   1/5   1   5', 10);

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

--
-- Estructura de tabla para la tabla `rango`
--

CREATE TABLE `rango` (
  `id_rango` int(11) NOT NULL,
  `nombre` varchar(30) NOT NULL,
  `min` int(11) NOT NULL,
  `max` int(11) NOT NULL,
  `segmento_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `rango` (`id_rango`, `nombre`, `min`, `max`, `segmento_id`) VALUES
(1, 'Excelente', 16, 16, 1),
(2, 'Superior', 15, 15, 1),
(3, 'Superior Término Medio', 14, 14, 1),
(4, 'Término Medio', 12, 13, 1),
(5, 'Inferior Término Medio', 10, 11, 1),
(6, 'Inferior', -16, 9, 1),
(7, 'Deficiente', 0, 7, 1),
(8, 'Excelente', 22, 22, 2),
(9, 'Superior', 20, 20, 2),
(10, 'Superior Término Medio', 18, 18, 2),
(11, 'Término Medio', 12, 16, 2),
(12, 'Inferior Término Medio', 10, 11, 2),
(13, 'Inferior', 8, 8, 2),
(14, 'Deficiente', -22, 6, 2),
(15, 'Excelente', 29, 30, 3),
(16, 'Superior', 27, 28, 3),
(17, 'Superior Término Medio', 23, 26, 3),
(18, 'Término Medio', 14, 22, 3),
(19, 'Inferior Término Medio', 12, 13, 3),
(20, 'Inferior', 8, 11, 3),
(21, 'Deficiente', -30, 7, 3),
(22, 'Excelente', 18, 18, 4),
(23, 'Superior', 16, 17, 4),
(24, 'Superior Término Medio', 14, 15, 4),
(25, 'Término Medio', 10, 13, 4),
(26, 'Inferior Término Medio', 7, 9, 4),
(27, 'Inferior', 6, 6, 4),
(28, 'Deficiente', -18, 5, 4),
(29, 'Excelente', 24, 24, 5),
(30, 'Superior', 22, 22, 5),
(31, 'Superior Término Medio', 18, 20, 5),
(32, 'Término Medio', 10, 16, 5),
(33, 'Inferior Término Medio', 8, 8, 5),
(34, 'Inferior', 6, 6, 5),
(35, 'Deficiente', -24, 4, 5),
(36, 'Excelente', 20, 20, 6),
(37, 'Superior', 18, 19, 6),
(38, 'Superior Término Medio', 16, 17, 6),
(39, 'Término Medio', 9, 15, 6),
(40, 'Inferior Término Medio', 6, 8, 6),
(41, 'Inferior', 5, 5, 6),
(42, 'Deficiente', -20, 4, 6),
(43, 'Excelente', 19, 20, 7),
(44, 'Superior', 18, 18, 7),
(45, 'Superior Término Medio', 16, 17, 7),
(46, 'Término Medio', 9, 15, 7),
(47, 'Inferior Término Medio', 6, 8, 7),
(48, 'Inferior', 5, 5, 7),
(49, 'Deficiente', -20, 4, 7),
(50, 'Excelente', 17, 17, 8),
(51, 'Superior', 15, 16, 8),
(53, 'Superior Término Medio', 13, 14, 8),
(54, 'Término Medio', 8, 12, 8),
(55, 'Inferior Término Medio', 7, 7, 8),
(56, 'Inferior', 6, 6, 8),
(57, 'Deficiente', -17, 5, 8),
(58, 'Excelente', 18, 18, 9),
(59, 'Superior', 16, 17, 9),
(60, 'Superior Término Medio', 15, 15, 9),
(61, 'Término Medio', 9, 14, 9),
(62, 'Inferior Término Medio', 8, 8, 9),
(63, 'Inferior', 6, 7, 9),
(64, 'Deficiente', -18, 5, 9),
(65, 'Excelente', 20, 22, 10),
(66, 'Superior', 18, 18, 10),
(67, 'Superior Término Medio', 16, 16, 10),
(68, 'Término Medio', 10, 14, 10),
(69, 'Inferior Término Medio', 8, 8, 10),
(70, 'Inferior', 6, 6, 10),
(71, 'Deficiente', -22, 5, 10);

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

--
-- Estructura de tabla para la tabla `rango_ci`
--

CREATE TABLE `rango_ci` (
  `id` int(11) NOT NULL,
  `max` int(11) NOT NULL,
  `min` int(11) NOT NULL,
  `rango` varchar(25) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `rango_ci` (`id`, `max`, `min`, `rango`) VALUES
(1, 300, 120, 'Inteligencia Sobresalient'),
(2, 120, 111, 'Inteligencia Superior'),
(3, 110, 90, 'Inteligencia  Normal'),
(4, 89, 80, 'Inteligencia Limítrofe'),
(5, 79, 70, 'Debilidad Mental Superfic'),
(6, 69, 50, 'Debilidad Mental Mediana');

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

--
-- Estructura de tabla para la tabla `respuestas`
--

CREATE TABLE `respuestas` (
  `id` int(11) NOT NULL,
  `valor` varchar(100) NOT NULL,
  `puntos` int(11) NOT NULL,
  `id_pregunta` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `respuestas` (`id`, `valor`, `puntos`, `id_pregunta`) VALUES
(1, 'Granos', -1, 5),
(2, 'Pretróleo', 1, 5),
(3, 'Trementina', -1, 5),
(4, 'Semillas', -1, 5),
(5, '1,000 kg.', 1, 6),
(6, '2,000 kg.', -1, 6),
(7, '3,000 kg.', -1, 6),
(8, '4, 000 kg.', -1, 6),
(9, 'Mazatlán', -1, 7),
(10, 'Acapulco', -1, 7),
(11, 'Progreso', -1, 7),
(12, 'Veracruz', 1, 7),
(13, 'Ver', 1, 8),
(14, 'Oir', -1, 8),
(15, 'Probar', -1, 8),
(16, 'Sentir', -1, 8),
(17, 'Corteza', -1, 9),
(18, 'Fruto', 1, 9),
(19, 'Hojas', -1, 9),
(20, 'Raíz', -1, 9),
(21, 'Carnero', -1, 10),
(22, 'Vaca', -1, 10),
(23, 'Gallina', -1, 10),
(24, 'Cerdo', 1, 10),
(25, 'Abdomen', -1, 11),
(26, 'Cabeza', -1, 11),
(27, 'Garganta', 1, 11),
(28, 'Espalda', -1, 11),
(29, 'Muerte', 1, 14),
(30, 'Enfermedad', -1, 14),
(31, 'Fiebre', -1, 14),
(32, 'Malestar', -1, 14),
(33, 'Perforar', -1, 15),
(34, 'Cortar', -1, 15),
(35, 'Levantar', 1, 15),
(36, 'Exprimir', -1, 15),
(41, 'Pentágono ', -1, 16),
(42, 'Paralelogramo', -1, 16),
(43, 'Hexágono', 1, 16),
(44, 'Trapecio', -1, 16),
(45, 'Lluvia', -1, 17),
(46, 'Viento', -1, 17),
(47, 'Electricidad', 1, 17),
(48, 'Presión', 1, 17),
(49, 'Agricultura', -1, 18),
(50, 'Música', 1, 18),
(51, 'Fotografía', -1, 18),
(52, 'Estenografía', -1, 18),
(53, 'Azules', -1, 19),
(54, 'Verdes', 1, 19),
(55, 'Rojas', -1, 19),
(56, 'Amarillas', -1, 19),
(57, 'Pie', -1, 20),
(58, 'Pulgada', 1, 20),
(59, 'Yarda', -1, 20),
(60, 'Milla', -1, 20),
(61, 'Animales', 1, 21),
(62, 'Yerbas', -1, 21),
(63, 'Bosques', -1, 21),
(64, 'Minas', -1, 21),
(65, 'Medicina', -1, 22),
(66, 'Teología', -1, 22),
(67, 'Leyes', 1, 22),
(68, 'Pedagogía', -1, 22),
(69, 'Las estrellas desaparecerían', -1, 23),
(70, 'Los meses serían más largos', -1, 23),
(71, 'La tierra estaría más caliente', 1, 23),
(120, 'El nogal es fuerte', 1, 34),
(121, 'Se corta fácilmente', -1, 34),
(122, 'Sus frenos son buenos', -1, 34),
(123, 'Tiene más ruedas', -1, 35),
(124, 'Es más pesado', 1, 35),
(125, 'Sus frenos no son buenos', -1, 35),
(126, 'Que los robles son débiles', -1, 36),
(127, 'Que son mejores los golpes pequeños', -1, 36),
(128, 'Que el esfuerzo constante logra resultados sorprendentes', 1, 36),
(129, 'Que no debemos vigilarla cuando está en el fuego', -1, 37),
(130, 'Que tarda en hervir', -1, 37),
(131, 'Que el tiempo se alarga cuando esperamos algo', 1, 37),
(132, 'Que el pasto se siembra en el verano', -1, 38),
(133, 'Que debemos aprovechar nuesras oportunidades', 1, 38),
(134, 'Que el pasto no debe cortarse en la noche', -1, 38),
(135, 'Que un zapatero no debe abandonar sus zapatos', -1, 39),
(136, 'Que los zapateros no deben estar de ociosos', -1, 39),
(137, 'Que debemos trabajar en lo que podemos hacer mejor', 1, 39),
(138, 'Que el palo sirve para apretar', -1, 40),
(139, 'Que las cuñas siempre son de madera', -1, 40),
(140, 'Nos exigen más las personas que nos conocen', 1, 40),
(141, 'La máquina lo hace flotar', -1, 41),
(142, 'Porque tiene grandes espacios huecos', 1, 41),
(143, 'Contiene algo de madera', -1, 41),
(144, 'Las alas ofrecen una amplia superficie ligera', 1, 42),
(145, 'Mantienen el aire fuera del cuerpo', -1, 42),
(146, 'Disminuye su peso', -1, 42),
(147, 'Que las golondrinas regresan', -1, 43),
(148, 'Que un simple dato no es suficiente', 1, 43),
(149, 'Que los pájaros se agregan a nuestros placeres de ', -1, 43),
(150, 'Igual', -1, 44),
(151, 'Opuesto', 1, 44),
(152, 'Igual', 1, 45),
(153, 'Opuesto', -1, 45),
(154, 'Igual', -1, 46),
(155, 'Opuesto', 1, 46),
(156, 'Igual', -1, 47),
(157, 'Opuesto', 1, 47),
(158, 'Igual', -1, 48),
(159, 'Opuesto', 1, 48),
(160, 'Igual', -1, 49),
(161, 'Opuesto', 1, 49),
(162, 'Igual', 1, 50),
(163, 'Opuesto', -1, 50),
(164, 'Igual', 1, 51),
(165, 'Opuesto', -1, 51),
(166, 'Igual', -1, 52),
(167, 'Opuesto', 1, 52),
(168, 'Igual', 1, 53),
(169, 'Opuesto', -1, 53),
(170, 'Igual', -1, 54),
(171, 'Opuesto', 1, 54),
(172, 'Igual', -1, 55),
(173, 'Opuesto', 1, 55),
(174, 'Igual', -1, 56),
(175, 'Opuesto', 1, 56),
(176, 'Igual', 1, 57),
(177, 'Opuesto', -1, 57),
(178, 'Igual', -1, 58),
(179, 'Opuesto', 1, 58),
(180, 'Igual', -1, 59),
(181, 'Opuesto', 1, 59),
(182, 'Igual', 1, 60),
(183, 'Opuesto', -1, 60),
(184, 'Igual', -1, 61),
(185, 'Opuesto', 1, 61),
(186, 'Igual', 1, 62),
(187, 'Opuesto', -1, 62),
(188, 'Igual', -1, 63),
(189, 'Opuesto', 1, 63),
(190, 'Igual', -1, 64),
(191, 'Opuesto', 1, 64),
(192, 'Igual', -1, 65),
(193, 'Opuesto', 1, 65),
(194, 'Igual', 1, 66),
(195, 'Opuesto', -1, 66),
(196, 'Igual', 1, 67),
(197, 'Opuesto', -1, 67),
(198, 'Igual', -1, 68),
(199, 'Opuesto', 1, 68),
(200, 'Igual', -1, 69),
(201, 'Opuesto', 1, 69),
(202, 'Igual', 1, 70),
(203, 'Opuesto', -1, 70),
(204, 'Igual', 1, 71),
(205, 'Opuesto', -1, 71),
(206, 'Igual', -1, 72),
(207, 'Opuesto', 1, 72),
(208, 'Igual', 1, 73),
(209, 'Opuesto', -1, 73),
(494, 'Altura', -1, 74),
(495, 'Circunferencia', 1, 74),
(496, 'Latitud', -1, 74),
(497, 'Longitud', -1, 74),
(498, 'Radio', 1, 74),
(499, 'Huesos', 1, 75),
(500, 'Huevos', -1, 75),
(501, 'Pico', 1, 75),
(502, 'Nido', -1, 75),
(503, 'Canto', -1, 75),
(504, 'Oyente', -1, 76),
(505, 'Piano', -1, 76),
(506, 'Ritmo', 1, 76),
(507, 'Sonido', 1, 76),
(508, 'Violín', -1, 76),
(509, 'Alimentos', 1, 77),
(510, ' Músicos', -1, 77),
(511, 'Personas', 1, 77),
(512, 'Discurso', -1, 77),
(513, 'Anfitrión', -1, 77),
(514, 'Arnés', -1, 78),
(515, 'Cascos', 1, 78),
(516, 'Herraduras', -1, 78),
(517, 'Establo', -1, 78),
(518, 'Cola', 1, 78),
(519, 'Cartas', -1, 79),
(520, 'Multas', -1, 79),
(521, 'Jugadores', 1, 79),
(522, 'Castigos', -1, 79),
(523, 'Reglas', 1, 79),
(524, 'Calor', -1, 80),
(525, 'Tamaño', 1, 80),
(526, 'Sabor', -1, 80),
(527, 'Valor', -1, 80),
(528, 'Peso', 1, 80),
(529, 'Acuerdos', -1, 81),
(530, 'Personas', 1, 81),
(531, 'Preguntas', -1, 81),
(532, 'Ingenio', -1, 81),
(533, 'Palabras', 1, 81),
(534, 'Acreedor', 1, 82),
(535, 'Deudor', 1, 82),
(536, 'Interés', -1, 82),
(537, 'Hipoteca', -1, 82),
(538, 'Pago', -1, 82),
(539, 'País', 1, 83),
(540, 'Ocupación', -1, 83),
(541, 'Derecho', 1, 83),
(542, 'Propiedad', -1, 83),
(543, 'Voto', -1, 83),
(544, 'Animales', -1, 84),
(545, 'Orden', 1, 84),
(546, 'Colecciones', 1, 84),
(547, 'Minerales', -1, 84),
(548, 'Visitantes', -1, 84),
(549, 'Obligación', 1, 85),
(550, 'Acuerdo', 1, 85),
(551, 'Amistad', -1, 85),
(552, 'Respeto', -1, 85),
(553, 'Satisfacción', -1, 85),
(554, 'Animales', -1, 86),
(555, 'Flores', -1, 86),
(556, 'Sombras', 1, 86),
(557, 'Maleza', -1, 86),
(558, 'Árboles', 1, 86),
(559, 'Dificultad', 1, 87),
(560, 'Desaliento', -1, 87),
(561, 'Fracaso', -1, 87),
(562, 'Impedimento', -1, 87),
(563, 'Estímulo', 1, 87),
(631, 'Desaliento', -1, 87),
(636, 'Desagrado', 1, 88),
(637, 'Temor', -1, 88),
(638, 'Ira', -1, 88),
(639, 'Timidez', -1, 88),
(640, 'Anuncios', -1, 89),
(641, 'Papel', 1, 89),
(642, 'Fotografías', -1, 89),
(643, 'Grabados', -1, 89),
(644, 'Impresión', 1, 89),
(645, 'Argumentos', 1, 90),
(646, 'Desacuerdo', 1, 90),
(647, 'Aversión', -1, 90),
(648, 'Público', -1, 90),
(649, 'Resumen', -1, 90),
(650, 'Maquinaria', -1, 91),
(651, 'Cañones', -1, 91),
(652, 'Quilla', 1, 91),
(653, 'Timón', 1, 91),
(654, 'Velas', -1, 91),
(655, '20', 1, 104),
(656, '11', 1, 105),
(657, '50', 1, 106),
(658, '5', 1, 107),
(659, '12', 1, 108),
(660, '19.2', 1, 109),
(661, '500', 1, 110),
(662, '2', 1, 111),
(663, '28', 1, 112),
(664, '360', 1, 113),
(665, '2', 1, 114),
(666, '25', 1, 115),
(667, 'Si', 1, 116),
(668, 'No', -1, 116),
(669, 'Si', -1, 117),
(670, 'No', 1, 117),
(671, 'Si', -1, 118),
(672, 'No', 1, 118),
(673, 'Si', 1, 119),
(674, 'No', -1, 119),
(675, 'Si', 1, 120),
(676, 'No', -1, 120),
(677, 'Si', -1, 121),
(678, 'No', 1, 121),
(679, 'Si', -1, 122),
(680, 'No', 1, 122),
(681, 'Si', -1, 123),
(682, 'No', 1, 123),
(683, 'Si', 1, 124),
(684, 'No', -1, 124),
(685, 'Si', 1, 125),
(686, 'No', -1, 125),
(687, 'Si', -1, 126),
(688, 'No', 1, 126),
(689, 'Si', -1, 127),
(690, 'No', 1, 127),
(691, 'Si', -1, 128),
(692, 'No', 1, 128),
(693, 'Si', 1, 129),
(694, 'No', -1, 129),
(695, 'Si', -1, 130),
(696, 'No', 1, 130),
(697, 'Si', -1, 131),
(698, 'No', 1, 131),
(699, 'Si', 1, 132),
(700, 'No', -1, 132),
(701, 'Si', -1, 133),
(702, 'No', 1, 133),
(703, 'Si', 1, 134),
(704, 'No', -1, 134),
(705, 'Si', 1, 135),
(706, 'No', -1, 135),
(707, 'Comer', 1, 136),
(708, 'Hambre', -1, 136),
(709, 'Agua', -1, 136),
(710, 'Cocinar', -1, 136),
(711, 'Año', 1, 137),
(712, 'Hora', -1, 137),
(713, 'Minuto', -1, 137),
(714, 'Siglo', -1, 137),
(715, 'Olor', -1, 138),
(716, 'Hoja', -1, 138),
(717, 'Planta', 1, 138),
(718, 'Espina', -1, 138),
(719, 'Negro', -1, 139),
(720, 'Esclavitud', 1, 139),
(721, 'Libre', -1, 139),
(722, 'Sufrir', -1, 139),
(723, 'Cantar', -1, 140),
(724, 'Estuvo', 1, 140),
(725, 'Hablando', -1, 140),
(726, 'Canto', -1, 140),
(727, 'Semana', -1, 141),
(728, 'Jueves', -1, 141),
(729, 'Día', 1, 141),
(730, 'Sábado', -1, 141),
(731, 'Botella', -1, 142),
(732, 'Peso', -1, 142),
(733, 'Ligero', -1, 142),
(734, 'Flotar', 1, 142),
(735, 'Tristeza', 1, 143),
(736, 'Suerte', -1, 143),
(737, 'Fracasar', -1, 143),
(738, 'Trabajo', -1, 143),
(739, 'Lobo', 1, 144),
(740, 'Ladrido', -1, 144),
(741, 'Mordida', -1, 144),
(742, 'Agarrar', -1, 144),
(743, '7', -1, 145),
(744, '45', -1, 145),
(745, '35', -1, 145),
(746, '25', 1, 145),
(747, 'Muerte', -1, 146),
(748, 'Alegre', 1, 146),
(749, 'Mortaja', -1, 146),
(750, 'Doctor', -1, 146),
(751, 'Comer', -1, 147),
(752, 'Pájaro', -1, 147),
(753, 'Vida', 1, 147),
(754, 'Malo', -1, 147),
(755, '18', -1, 148),
(756, '27', -1, 148),
(757, '36', -1, 148),
(758, '45', 1, 148),
(759, 'Beber', -1, 149),
(760, 'Claro', -1, 149),
(761, 'Sed', 1, 149),
(762, 'Puro', -1, 149),
(763, 'Estos', -1, 150),
(764, 'Aquel', -1, 150),
(765, 'Ese', 1, 150),
(766, 'Entonces', -1, 150),
(767, 'Agua', -1, 151),
(768, 'Pez', -1, 151),
(769, 'Escama', 1, 151),
(770, 'Nadar', -1, 151),
(771, 'Patría', -1, 152),
(772, 'Honrado', 1, 152),
(773, 'Canción', -1, 152),
(774, 'Estudio', -1, 152),
(775, 'Tercero', -1, 153),
(776, 'Último', -1, 153),
(777, 'Cuarto', 1, 153),
(778, 'Posterior', -1, 153),
(779, 'Marina', -1, 154),
(780, 'Soldado', -1, 154),
(781, 'General', 1, 154),
(782, 'Sargento', -1, 154),
(783, 'Pronombre', -1, 155),
(784, 'Adverbio', -1, 155),
(785, 'Verbo', -1, 155),
(786, 'Adjetivo', 1, 155),
(787, 'Verdadero', 1, 156),
(788, 'Falso', -1, 156),
(789, 'Verdadero', -1, 157),
(790, 'Falso', 1, 157),
(791, 'Verdadero', 1, 158),
(792, 'Falso', -1, 158),
(793, 'Verdadero', 1, 159),
(794, 'Falso', -1, 159),
(795, 'Verdadero', 1, 160),
(796, 'Falso', -1, 160),
(797, 'Verdadero', -1, 161),
(798, 'Falso', 1, 161),
(799, 'Verdadero', -1, 162),
(800, 'Falso', 1, 162),
(801, 'Verdadero', 1, 163),
(802, 'Falso', -1, 163),
(803, 'Verdadero', 1, 164),
(804, 'Falso', -1, 164),
(805, 'Verdadero', -1, 165),
(806, 'Falso', 1, 165),
(807, 'Verdadero', -1, 166),
(808, 'Falso', 1, 166),
(809, 'Verdadero', -1, 167),
(810, 'Falso', 1, 167),
(811, 'Verdadero', 1, 168),
(812, 'Falso', -1, 168),
(813, 'Verdadero', 1, 169),
(814, 'Falso', -1, 169),
(815, 'Verdadero', 1, 170),
(816, 'Falso', -1, 170),
(817, 'Verdadero', 1, 171),
(818, 'Falso', -1, 171),
(819, 'Verdadero', -1, 172),
(820, 'Falso', 1, 172),
(821, 'Saltar', -1, 173),
(822, 'Correr', -1, 173),
(823, 'Brincar', -1, 173),
(824, 'Pararse', 1, 173),
(825, 'Caminar', -1, 173),
(826, 'Monarquía', -1, 174),
(827, 'Comunista', -1, 174),
(828, 'Demócrata', -1, 174),
(829, 'Anarquía', -1, 174),
(830, 'Católico', 1, 174),
(831, 'Muerte', -1, 175),
(832, 'Duelo', -1, 175),
(833, 'Paseo', 1, 175),
(834, 'Pobreza', -1, 175),
(835, 'Tristeza', -1, 175),
(836, 'Carpintero', 1, 176),
(837, 'Doctor', -1, 176),
(838, 'Abogado', -1, 176),
(839, 'Ingeniero', -1, 176),
(840, 'Profesor', -1, 176),
(841, 'Cama', -1, 177),
(842, 'Silla', -1, 177),
(843, 'Plato', 1, 177),
(844, 'Sofá', -1, 177),
(845, 'Mesa', -1, 177),
(846, 'Francisco', -1, 178),
(847, 'Santiago', -1, 178),
(848, 'Juan', -1, 178),
(849, 'Sara', 1, 178),
(850, 'Mesa', -1, 178),
(851, 'Duro', -1, 179),
(852, 'Juan', -1, 179),
(853, 'Liso', -1, 179),
(854, 'Suave', -1, 179),
(855, 'Dulce', 1, 179),
(856, 'Digestión', 1, 180),
(857, 'Oído', -1, 180),
(858, 'Vista', -1, 180),
(859, 'Olfato', -1, 180),
(860, 'Tacto', -1, 180),
(861, 'Automóvil', -1, 181),
(862, 'Bicicleta', -1, 181),
(863, 'Guayin', -1, 181),
(864, 'Telégrafo', 1, 181),
(865, 'Tren', -1, 181),
(866, 'Abajo', -1, 182),
(867, 'Acá', -1, 182),
(868, 'Reciente', 1, 182),
(869, 'Arriba', -1, 182),
(870, 'Allá', -1, 182),
(871, 'Hidalgo', -1, 183),
(872, 'Morelos', -1, 183),
(873, 'Bravo', -1, 183),
(874, 'Matamoros', -1, 183),
(875, 'Bolivar', 1, 183),
(876, 'Danés', -1, 184),
(877, 'Galgo', -1, 184),
(878, 'Lino', -1, 184),
(879, 'Buldog', -1, 184),
(880, 'Pequines', 1, 184),
(881, 'Leghorn', 1, 184),
(882, 'Tela', 1, 185),
(883, 'Algodón', -1, 185),
(884, 'Lino', -1, 185),
(885, 'Seda', -1, 185),
(886, 'Lana', -1, 185),
(887, 'Ira', -1, 186),
(888, 'Odio', -1, 186),
(889, 'Alegría', -1, 186),
(890, 'Piedad', -1, 186),
(891, 'Razonamiento', 1, 186),
(892, 'Edison', -1, 187),
(893, 'Franklin', -1, 187),
(894, 'Macorni', -1, 187),
(895, 'Fulton', -1, 187),
(896, 'Shakespeare', 1, 187),
(897, 'Mariposa', 1, 188),
(898, 'Halcón', -1, 188),
(899, 'Avestruz', -1, 188),
(900, 'Petirrojo', -1, 188),
(901, 'Golodrina', -1, 188),
(902, 'Dar', -1, 189),
(903, 'Prestar', -1, 189),
(904, 'Perder', -1, 189),
(905, 'Ahorrar', 1, 189),
(906, 'Derrochar', -1, 189),
(907, 'Australia', -1, 190),
(908, 'Cuba', -1, 190),
(909, 'Córcega', -1, 190),
(910, 'Irlanda', -1, 190),
(911, 'España', 1, 190),
(912, '2', 1, 191),
(913, '1', 1, 191),
(914, '33', 1, 192),
(915, '38', 1, 192),
(916, '64', 1, 193),
(917, '128', 1, 193),
(918, '2', 1, 194),
(919, '2', 1, 194),
(920, '13', 1, 195),
(921, '13 1/4', 1, 195),
(922, '20', 1, 196),
(923, '21', 1, 196),
(924, '1/4', 1, 197),
(925, '1/8', 1, 197),
(926, '85.3', 1, 198),
(927, '84.3', 1, 198),
(928, '6', 1, 199),
(929, '8', 1, 199),
(930, '33', 1, 200),
(931, '34', 1, 200),
(932, '25', 1, 201),
(933, '125', 1, 201);

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

--
-- Estructura de tabla para la tabla `resp_usuario`
--

CREATE TABLE `resp_usuario` (
  `id` int(11) NOT NULL,
  `respuesta` int(30) NOT NULL,
  `id_usuario` int(11) NOT NULL,
  `id_pregunta` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `resp_usuario` (`id`, `respuesta`, `id_usuario`, `id_pregunta`) VALUES
(1, 1, 23, 5),
(2, 1, 23, 6),
(3, 1, 23, 7),
(4, 1, 23, 8),
(5, 1, 23, 9),
(6, 1, 23, 10),
(7, 1, 23, 11),
(8, 1, 23, 14),
(9, 1, 23, 15),
(10, 1, 23, 16),
(11, 1, 23, 17),
(12, 1, 23, 18),
(13, 1, 23, 19),
(14, -1, 23, 20),
(15, 1, 23, 21),
(16, 1, 23, 22),
(17, 1, 23, 23),
(18, 1, 23, 34),
(19, 1, 23, 35),
(20, 1, 23, 36),
(21, 1, 23, 37),
(22, 1, 23, 38),
(23, 1, 23, 39),
(24, 1, 23, 40),
(25, 1, 23, 41),
(26, 1, 23, 42),
(27, 1, 23, 43),
(28, 1, 23, 44),
(29, 1, 23, 45),
(30, 1, 23, 46),
(31, 1, 23, 47),
(32, 1, 23, 48),
(33, 1, 23, 49),
(34, 1, 23, 50),
(35, 1, 23, 51),
(36, 1, 23, 52),
(37, 1, 23, 53),
(38, 1, 23, 54),
(39, 1, 23, 55),
(40, 1, 23, 56),
(41, 1, 23, 57),
(42, 1, 23, 58),
(43, 1, 23, 59),
(44, -1, 23, 60),
(45, 1, 23, 61),
(46, 1, 23, 62),
(47, 1, 23, 63),
(48, 1, 23, 64),
(49, 1, 23, 65),
(50, 1, 23, 66),
(51, 1, 23, 67),
(52, 1, 23, 68),
(53, 1, 23, 69),
(54, 1, 23, 70),
(55, -1, 23, 71),
(56, 1, 23, 72),
(57, 1, 23, 73),
(58, 1, 23, 44),
(59, 1, 23, 45),
(60, 1, 23, 46),
(61, 1, 23, 47),
(62, 1, 23, 48),
(63, 1, 23, 49),
(64, 1, 23, 50),
(65, 1, 23, 51),
(66, 1, 23, 52),
(67, 1, 23, 53),
(68, 1, 23, 54),
(69, 1, 23, 55),
(70, 1, 23, 56),
(71, 1, 23, 57),
(72, 1, 23, 58),
(73, 1, 23, 59),
(74, -1, 23, 60),
(75, 1, 23, 61),
(76, 1, 23, 62),
(77, 1, 23, 63),
(78, 1, 23, 64),
(79, 1, 23, 65),
(80, 1, 23, 66),
(81, 1, 23, 67),
(82, 1, 23, 68),
(83, 1, 23, 69),
(84, 1, 23, 70),
(85, -1, 23, 71),
(86, 1, 23, 72),
(87, 1, 23, 73),
(88, 1, 23, 44),
(89, 1, 23, 45),
(90, 1, 23, 46),
(91, 1, 23, 47),
(92, 1, 23, 48),
(93, 1, 23, 49),
(94, 1, 23, 50),
(95, 1, 23, 51),
(96, 1, 23, 52),
(97, 1, 23, 53),
(98, 1, 23, 54),
(99, 1, 23, 55),
(100, 1, 23, 56),
(101, 1, 23, 57),
(102, 1, 23, 58),
(103, 1, 23, 59),
(104, -1, 23, 60),
(105, 1, 23, 61),
(106, 1, 23, 62),
(107, 1, 23, 63),
(108, 1, 23, 64),
(109, 1, 23, 65),
(110, 1, 23, 66),
(111, 1, 23, 67),
(112, 1, 23, 68),
(113, 1, 23, 69),
(114, 1, 23, 70),
(115, -1, 23, 71),
(116, 1, 23, 72),
(117, 1, 23, 73),
(118, 0, 23, 44),
(119, 0, 23, 45),
(120, 0, 23, 46),
(121, 0, 23, 47),
(122, 0, 23, 48),
(123, 0, 23, 49),
(124, 0, 23, 50),
(125, 0, 23, 51),
(126, 0, 23, 52),
(127, 0, 23, 53),
(128, 0, 23, 54),
(129, 0, 23, 55),
(130, 0, 23, 56),
(131, 0, 23, 57),
(132, 0, 23, 58),
(133, 0, 23, 59),
(134, 0, 23, 60),
(135, 0, 23, 61),
(136, 0, 23, 62),
(137, 0, 23, 63),
(138, 0, 23, 64),
(139, 0, 23, 65),
(140, 0, 23, 66),
(141, 0, 23, 67),
(142, 0, 23, 68),
(143, 0, 23, 69),
(144, 0, 23, 70),
(145, 0, 23, 71),
(146, 0, 23, 72),
(147, 0, 23, 73),
(148, 0, 23, 44),
(149, 0, 23, 45),
(150, 0, 23, 46),
(151, 0, 23, 47),
(152, 0, 23, 48),
(153, 0, 23, 49),
(154, 0, 23, 50),
(155, 0, 23, 51),
(156, 0, 23, 52),
(157, 0, 23, 53),
(158, 0, 23, 54),
(159, 0, 23, 55),
(160, 0, 23, 56),
(161, 0, 23, 57),
(162, 0, 23, 58),
(163, 0, 23, 59),
(164, 0, 23, 60),
(165, 0, 23, 61),
(166, 0, 23, 62),
(167, 0, 23, 63),
(168, 0, 23, 64),
(169, 0, 23, 65),
(170, 0, 23, 66),
(171, 0, 23, 67),
(172, 0, 23, 68),
(173, 0, 23, 69),
(174, 0, 23, 70),
(175, 0, 23, 71),
(176, 0, 23, 72),
(177, 0, 23, 73),
(178, 0, 23, 44),
(179, 0, 23, 45),
(180, 0, 23, 46),
(181, 0, 23, 47),
(182, 0, 23, 48),
(183, 0, 23, 49),
(184, 0, 23, 50),
(185, 0, 23, 51),
(186, 0, 23, 52),
(187, 0, 23, 53),
(188, 0, 23, 54),
(189, 0, 23, 55),
(190, 0, 23, 56),
(191, 0, 23, 57),
(192, 0, 23, 58),
(193, 0, 23, 59),
(194, 0, 23, 60),
(195, 0, 23, 61),
(196, 0, 23, 62),
(197, 0, 23, 63),
(198, 0, 23, 64),
(199, 0, 23, 65),
(200, 0, 23, 66),
(201, 0, 23, 67),
(202, 0, 23, 68),
(203, 0, 23, 69),
(204, 0, 23, 70),
(205, 0, 23, 71),
(206, 0, 23, 72),
(207, 0, 23, 73),
(208, 1, 24, 5),
(209, 1, 24, 6),
(210, 1, 24, 7),
(211, 1, 24, 8),
(212, 1, 24, 9),
(213, 1, 24, 10),
(214, 1, 24, 11),
(215, 1, 24, 14),
(216, 1, 24, 15),
(217, 1, 24, 16),
(218, 1, 24, 17),
(219, 1, 24, 18),
(220, 1, 24, 19),
(221, -1, 24, 20),
(222, 1, 24, 21),
(223, 1, 24, 22),
(224, 1, 24, 23),
(225, 1, 24, 34),
(226, 1, 24, 35),
(227, 1, 24, 36),
(228, 1, 24, 37),
(229, 1, 24, 38),
(230, 1, 24, 39),
(231, 1, 24, 40),
(232, 1, 24, 41),
(233, 1, 24, 42),
(234, 1, 24, 43),
(235, 1, 24, 44),
(236, 1, 24, 45),
(237, 1, 24, 46),
(238, 1, 24, 47),
(239, 1, 24, 48),
(240, 1, 24, 49),
(241, 1, 24, 50),
(242, 1, 24, 51),
(243, 1, 24, 52),
(244, 1, 24, 53),
(245, 1, 24, 54),
(246, 1, 24, 55),
(247, 1, 24, 56),
(248, 1, 24, 57),
(249, 1, 24, 58),
(250, 1, 24, 59),
(251, 1, 24, 60),
(252, 1, 24, 61),
(253, 1, 24, 62),
(254, 1, 24, 63),
(255, 1, 24, 64),
(256, 1, 24, 65),
(257, 1, 24, 66),
(258, 1, 24, 67),
(259, 1, 24, 68),
(260, 1, 24, 69),
(261, 1, 24, 70),
(262, -1, 24, 71),
(263, 1, 24, 72),
(264, 1, 24, 73),
(265, 1, 24, 44),
(266, 1, 24, 45),
(267, 1, 24, 46),
(268, 1, 24, 47),
(269, 1, 24, 48),
(270, 1, 24, 49),
(271, 1, 24, 50),
(272, 1, 24, 51),
(273, 1, 24, 52),
(274, 1, 24, 53),
(275, 1, 24, 54),
(276, 1, 24, 55),
(277, 1, 24, 56),
(278, 1, 24, 57),
(279, 1, 24, 58),
(280, 1, 24, 59),
(281, 1, 24, 60),
(282, 1, 24, 61),
(283, 1, 24, 62),
(284, 1, 24, 63),
(285, 1, 24, 64),
(286, 1, 24, 65),
(287, 1, 24, 66),
(288, 1, 24, 67),
(289, 1, 24, 68),
(290, 1, 24, 69),
(291, 1, 24, 70),
(292, -1, 24, 71),
(293, 1, 24, 72),
(294, 1, 24, 73),
(295, 0, 24, 44),
(296, 0, 24, 45),
(297, 0, 24, 46),
(298, 0, 24, 47),
(299, 0, 24, 48),
(300, 0, 24, 49),
(301, 0, 24, 50),
(302, 0, 24, 51),
(303, 0, 24, 52),
(304, 0, 24, 53),
(305, 0, 24, 54),
(306, 0, 24, 55),
(307, 0, 24, 56),
(308, 0, 24, 57),
(309, 0, 24, 58),
(310, 0, 24, 59),
(311, 0, 24, 60),
(312, 0, 24, 61),
(313, 0, 24, 62),
(314, 0, 24, 63),
(315, 0, 24, 64),
(316, 0, 24, 65),
(317, 0, 24, 66),
(318, 0, 24, 67),
(319, 0, 24, 68),
(320, 0, 24, 69),
(321, 0, 24, 70),
(322, 0, 24, 71),
(323, 0, 24, 72),
(324, 0, 24, 73),
(325, 0, 24, 74),
(326, -1, 24, 75),
(327, -1, 24, 76),
(328, -1, 24, 77),
(329, 0, 24, 78),
(330, -1, 24, 79),
(331, 0, 24, 80),
(332, 0, 24, 81),
(333, 0, 24, 82),
(334, -1, 24, 83),
(335, 0, 24, 84),
(336, 0, 24, 85),
(337, -1, 24, 86),
(338, -1, 24, 87),
(339, 0, 24, 88),
(340, 0, 24, 89),
(341, 0, 24, 90),
(342, -1, 24, 91),
(343, 0, 24, 44),
(344, 0, 24, 45),
(345, 0, 24, 46),
(346, 0, 24, 47),
(347, 0, 24, 48),
(348, 0, 24, 49),
(349, 0, 24, 50),
(350, 0, 24, 51),
(351, 0, 24, 52),
(352, 0, 24, 53),
(353, 0, 24, 54),
(354, 0, 24, 55),
(355, 0, 24, 56),
(356, 0, 24, 57),
(357, 0, 24, 58),
(358, 0, 24, 59),
(359, 0, 24, 60),
(360, 0, 24, 61),
(361, 0, 24, 62),
(362, 0, 24, 63),
(363, 0, 24, 64),
(364, 0, 24, 65),
(365, 0, 24, 66),
(366, 0, 24, 67),
(367, 0, 24, 68),
(368, 0, 24, 69),
(369, 0, 24, 70),
(370, 0, 24, 71),
(371, 0, 24, 72),
(372, 0, 24, 73),
(373, 0, 24, 44),
(374, 0, 24, 45),
(375, 0, 24, 46),
(376, 0, 24, 47),
(377, 0, 24, 48),
(378, 0, 24, 49),
(379, 0, 24, 50),
(380, 0, 24, 51),
(381, 0, 24, 52),
(382, 0, 24, 53),
(383, 0, 24, 54),
(384, 0, 24, 55),
(385, 0, 24, 56),
(386, 0, 24, 57),
(387, 0, 24, 58),
(388, 0, 24, 59),
(389, 0, 24, 60),
(390, 0, 24, 61),
(391, 0, 24, 62),
(392, 0, 24, 63),
(393, 0, 24, 64),
(394, 0, 24, 65),
(395, 0, 24, 66),
(396, 0, 24, 67),
(397, 0, 24, 68),
(398, 0, 24, 69),
(399, 0, 24, 70),
(400, 0, 24, 71),
(401, 0, 24, 72),
(402, 0, 24, 73),
(403, 1, 24, 74),
(404, 0, 24, 75),
(405, 0, 24, 76),
(406, 1, 24, 77),
(407, 0, 24, 78),
(408, -1, 24, 79),
(409, 0, 24, 80),
(410, 0, 24, 81),
(411, 0, 24, 82),
(412, -1, 24, 83),
(413, 0, 24, 84),
(414, 0, 24, 85),
(415, -1, 24, 86),
(416, -1, 24, 87),
(417, 0, 24, 88),
(418, 0, 24, 89),
(419, 0, 24, 90),
(420, -1, 24, 91),
(421, 1, 24, 74),
(422, 0, 24, 75),
(423, 0, 24, 76),
(424, 1, 24, 77),
(425, 0, 24, 78),
(426, -1, 24, 79),
(427, 0, 24, 80),
(428, 0, 24, 81),
(429, 0, 24, 82),
(430, -1, 24, 83),
(431, 0, 24, 84),
(432, 0, 24, 85),
(433, -1, 24, 86),
(434, -1, 24, 87),
(435, 0, 24, 88),
(436, 0, 24, 89),
(437, 0, 24, 90),
(438, -1, 24, 91),
(439, 0, 24, 44),
(440, 0, 24, 45),
(441, 0, 24, 46),
(442, 0, 24, 47),
(443, 0, 24, 48),
(444, 0, 24, 49),
(445, 0, 24, 50),
(446, 0, 24, 51),
(447, 0, 24, 52),
(448, 0, 24, 53),
(449, 0, 24, 54),
(450, 0, 24, 55),
(451, 0, 24, 56),
(452, 0, 24, 57),
(453, 0, 24, 58),
(454, 0, 24, 59),
(455, 0, 24, 60),
(456, 0, 24, 61),
(457, 0, 24, 62),
(458, 0, 24, 63),
(459, 0, 24, 64),
(460, 0, 24, 65),
(461, 0, 24, 66),
(462, 0, 24, 67),
(463, 0, 24, 68),
(464, 0, 24, 69),
(465, 0, 24, 70),
(466, 0, 24, 71),
(467, 0, 24, 72),
(468, 0, 24, 73),
(469, 1, 24, 74),
(470, 0, 24, 75),
(471, 0, 24, 76),
(472, 1, 24, 77),
(473, 0, 24, 78),
(474, -1, 24, 79),
(475, 0, 24, 80),
(476, 1, 24, 81),
(477, 0, 24, 82),
(478, 1, 24, 83),
(479, 0, 24, 84),
(480, 0, 24, 85),
(481, 0, 24, 86),
(482, -1, 24, 87),
(483, 0, 24, 88),
(484, 0, 24, 89),
(485, 0, 24, 90),
(486, -1, 24, 91),
(487, 1, 24, 74),
(488, 0, 24, 75),
(489, 0, 24, 76),
(490, 1, 24, 77),
(491, 0, 24, 78),
(492, -1, 24, 79),
(493, 0, 24, 80),
(494, 1, 24, 81),
(495, 0, 24, 82),
(496, 1, 24, 83),
(497, 0, 24, 84),
(498, 0, 24, 85),
(499, 0, 24, 86),
(500, -1, 24, 87),
(501, 0, 24, 88),
(502, 0, 24, 89),
(503, 0, 24, 90),
(504, -1, 24, 91),
(505, 1, 24, 74),
(506, 0, 24, 75),
(507, 0, 24, 76),
(508, 1, 24, 77),
(509, 0, 24, 78),
(510, 0, 24, 79),
(511, 0, 24, 80),
(512, 1, 24, 81),
(513, 0, 24, 82),
(514, 1, 24, 83),
(515, 0, 24, 84),
(516, 0, 24, 85),
(517, 0, 24, 86),
(518, 0, 24, 87),
(519, 0, 24, 88),
(520, 0, 24, 89),
(521, 0, 24, 90),
(522, 0, 24, 91),
(523, 1, 24, 74),
(524, 0, 24, 75),
(525, 0, 24, 76),
(526, 1, 24, 77),
(527, 0, 24, 78),
(528, 0, 24, 79),
(529, 0, 24, 80),
(530, 1, 24, 81),
(531, 0, 24, 82),
(532, 1, 24, 83),
(533, 0, 24, 84),
(534, 0, 24, 85),
(535, 0, 24, 86),
(536, 0, 24, 87),
(537, 0, 24, 88),
(538, 0, 24, 89),
(539, 0, 24, 90),
(540, 0, 24, 91),
(541, 1, 24, 74),
(542, 0, 24, 75),
(543, 0, 24, 76),
(544, 1, 24, 77),
(545, 0, 24, 78),
(546, 0, 24, 79),
(547, 0, 24, 80),
(548, 1, 24, 81),
(549, 0, 24, 82),
(550, 1, 24, 83),
(551, 0, 24, 84),
(552, 0, 24, 85),
(553, 0, 24, 86),
(554, 0, 24, 87),
(555, 0, 24, 88),
(556, 0, 24, 89),
(557, 0, 24, 90),
(558, 0, 24, 91),
(559, 1, 24, 74),
(560, 0, 24, 75),
(561, 0, 24, 76),
(562, 1, 24, 77),
(563, 0, 24, 78),
(564, 0, 24, 79),
(565, 0, 24, 80),
(566, 1, 24, 81),
(567, 0, 24, 82),
(568, 1, 24, 83),
(569, 0, 24, 84),
(570, 0, 24, 85),
(571, 0, 24, 86),
(572, 0, 24, 87),
(573, 0, 24, 88),
(574, 0, 24, 89),
(575, 0, 24, 90),
(576, 0, 24, 91),
(577, 0, 24, 74),
(578, 0, 24, 75),
(579, 0, 24, 76),
(580, 0, 24, 77),
(581, 0, 24, 78),
(582, 0, 24, 79),
(583, 0, 24, 80),
(584, 0, 24, 81),
(585, 0, 24, 82),
(586, 0, 24, 83),
(587, 0, 24, 84),
(588, 0, 24, 85),
(589, 0, 24, 86),
(590, 0, 24, 87),
(591, 0, 24, 88),
(592, 0, 24, 89),
(593, 0, 24, 90),
(594, 0, 24, 91),
(595, 0, 24, 74),
(596, 0, 24, 75),
(597, 0, 24, 76),
(598, 0, 24, 77),
(599, 0, 24, 78),
(600, 0, 24, 79),
(601, 0, 24, 80),
(602, 0, 24, 81),
(603, 0, 24, 82),
(604, 0, 24, 83),
(605, 0, 24, 84),
(606, 0, 24, 85),
(607, 0, 24, 86),
(608, 0, 24, 87),
(609, 0, 24, 88),
(610, 0, 24, 89),
(611, 0, 24, 90),
(612, 0, 24, 91),
(613, 0, 24, 74),
(614, 0, 24, 75),
(615, 0, 24, 76),
(616, 0, 24, 77),
(617, 0, 24, 78),
(618, 0, 24, 79),
(619, 0, 24, 80),
(620, 0, 24, 81),
(621, 0, 24, 82),
(622, 0, 24, 83),
(623, 0, 24, 84),
(624, 0, 24, 85),
(625, 0, 24, 86),
(626, 0, 24, 87),
(627, 0, 24, 88),
(628, 0, 24, 89),
(629, 0, 24, 90),
(630, 0, 24, 91),
(631, -1, 24, 104),
(632, -1, 24, 105),
(633, -1, 24, 106),
(634, -1, 24, 107),
(635, -1, 24, 108),
(636, -1, 24, 109),
(637, -1, 24, 110),
(638, -1, 24, 111),
(639, -1, 24, 112),
(640, -1, 24, 113),
(641, -1, 24, 114),
(642, -1, 24, 115),
(643, -1, 24, 104),
(644, -1, 24, 105),
(645, -1, 24, 106),
(646, -1, 24, 107),
(647, -1, 24, 108),
(648, -1, 24, 109),
(649, -1, 24, 110),
(650, -1, 24, 111),
(651, -1, 24, 112),
(652, -1, 24, 113),
(653, -1, 24, 114),
(654, -1, 24, 115),
(655, -1, 24, 104),
(656, -1, 24, 105),
(657, -1, 24, 106),
(658, -1, 24, 107),
(659, -1, 24, 108),
(660, -1, 24, 109),
(661, -1, 24, 110),
(662, -1, 24, 111),
(663, -1, 24, 112),
(664, -1, 24, 113),
(665, -1, 24, 114),
(666, -1, 24, 115),
(667, 0, 24, 74),
(668, 0, 24, 75),
(669, 0, 24, 76),
(670, 0, 24, 77),
(671, 0, 24, 78),
(672, 0, 24, 79),
(673, 0, 24, 80),
(674, 0, 24, 81),
(675, 0, 24, 82),
(676, 0, 24, 83),
(677, 0, 24, 84),
(678, 0, 24, 85),
(679, 0, 24, 86),
(680, 0, 24, 87),
(681, 0, 24, 88),
(682, 0, 24, 89),
(683, 0, 24, 90),
(684, 0, 24, 91),
(685, 0, 24, 74),
(686, 0, 24, 75),
(687, 0, 24, 76),
(688, 0, 24, 77),
(689, 0, 24, 78),
(690, 0, 24, 79),
(691, 0, 24, 80),
(692, 0, 24, 81),
(693, 0, 24, 82),
(694, 0, 24, 83),
(695, 0, 24, 84),
(696, 0, 24, 85),
(697, 0, 24, 86),
(698, 0, 24, 87),
(699, 0, 24, 88),
(700, 0, 24, 89),
(701, 0, 24, 90),
(702, 0, 24, 91),
(703, -1, 24, 104),
(704, -1, 24, 105),
(705, -1, 24, 106),
(706, -1, 24, 107),
(707, -1, 24, 108),
(708, -1, 24, 109),
(709, -1, 24, 110),
(710, -1, 24, 111),
(711, -1, 24, 112),
(712, -1, 24, 113),
(713, -1, 24, 114),
(714, -1, 24, 115),
(715, -1, 24, 104),
(716, -1, 24, 105),
(717, -1, 24, 106),
(718, -1, 24, 107),
(719, -1, 24, 108),
(720, -1, 24, 109),
(721, -1, 24, 110),
(722, -1, 24, 111),
(723, -1, 24, 112),
(724, -1, 24, 113),
(725, -1, 24, 114),
(726, -1, 24, 115),
(727, -1, 24, 104),
(728, -1, 24, 105),
(729, -1, 24, 106),
(730, -1, 24, 107),
(731, -1, 24, 108),
(732, -1, 24, 109),
(733, -1, 24, 110),
(734, -1, 24, 111),
(735, -1, 24, 112),
(736, -1, 24, 113),
(737, -1, 24, 114),
(738, -1, 24, 115),
(739, -1, 24, 104),
(740, -1, 24, 105),
(741, -1, 24, 106),
(742, -1, 24, 107),
(743, -1, 24, 108),
(744, -1, 24, 109),
(745, -1, 24, 110),
(746, -1, 24, 111),
(747, -1, 24, 112),
(748, -1, 24, 113),
(749, -1, 24, 114),
(750, -1, 24, 115),
(751, -1, 24, 104),
(752, -1, 24, 105),
(753, -1, 24, 106),
(754, -1, 24, 107),
(755, -1, 24, 108),
(756, -1, 24, 109),
(757, -1, 24, 110),
(758, -1, 24, 111),
(759, -1, 24, 112),
(760, -1, 24, 113),
(761, -1, 24, 114),
(762, -1, 24, 115),
(763, -1, 24, 104),
(764, -1, 24, 105),
(765, -1, 24, 106),
(766, -1, 24, 107),
(767, -1, 24, 108),
(768, -1, 24, 109),
(769, -1, 24, 110),
(770, -1, 24, 111),
(771, -1, 24, 112),
(772, -1, 24, 113),
(773, -1, 24, 114),
(774, -1, 24, 115),
(775, 1, 24, 104),
(776, 1, 24, 105),
(777, 1, 24, 106),
(778, 1, 24, 107),
(779, 1, 24, 108),
(780, 1, 24, 109),
(781, 1, 24, 110),
(782, 1, 24, 111),
(783, 1, 24, 112),
(784, -1, 24, 113),
(785, -1, 24, 114),
(786, 1, 24, 115),
(787, 1, 24, 104),
(788, 1, 24, 105),
(789, 1, 24, 106),
(790, 1, 24, 107),
(791, 1, 24, 108),
(792, 1, 24, 109),
(793, 1, 24, 110),
(794, 1, 24, 111),
(795, 1, 24, 112),
(796, -1, 24, 113),
(797, -1, 24, 114),
(798, 1, 24, 115),
(799, 1, 24, 104),
(800, 1, 24, 105),
(801, 1, 24, 106),
(802, 1, 24, 107),
(803, 1, 24, 108),
(804, 1, 24, 109),
(805, 1, 24, 110),
(806, 1, 24, 111),
(807, 1, 24, 112),
(808, -1, 24, 113),
(809, -1, 24, 114),
(810, 1, 24, 115),
(811, 0, 24, 104),
(812, 0, 24, 105),
(813, 0, 24, 106),
(814, 0, 24, 107),
(815, 0, 24, 108),
(816, 0, 24, 109),
(817, 0, 24, 110),
(818, 0, 24, 111),
(819, 0, 24, 112),
(820, 0, 24, 113),
(821, 0, 24, 114),
(822, 0, 24, 115),
(823, 0, 24, 104),
(824, 0, 24, 105),
(825, 0, 24, 106),
(826, 0, 24, 107),
(827, 0, 24, 108),
(828, 0, 24, 109),
(829, 0, 24, 110),
(830, 0, 24, 111),
(831, 0, 24, 112),
(832, 0, 24, 113),
(833, 0, 24, 114),
(834, 0, 24, 115),
(835, 0, 24, 104),
(836, 0, 24, 105),
(837, 0, 24, 106),
(838, 0, 24, 107),
(839, 0, 24, 108),
(840, 0, 24, 109),
(841, 0, 24, 110),
(842, 0, 24, 111),
(843, 0, 24, 112),
(844, 0, 24, 113),
(845, 0, 24, 114),
(846, 0, 24, 115),
(847, 0, 24, 104),
(848, 0, 24, 105),
(849, 0, 24, 106),
(850, 0, 24, 107),
(851, 0, 24, 108),
(852, 0, 24, 109),
(853, 0, 24, 110),
(854, 0, 24, 111),
(855, 0, 24, 112),
(856, 0, 24, 113),
(857, 0, 24, 114),
(858, 0, 24, 115),
(859, 0, 24, 104),
(860, 0, 24, 105),
(861, 0, 24, 106),
(862, 0, 24, 107),
(863, 0, 24, 108),
(864, 0, 24, 109),
(865, 0, 24, 110),
(866, 0, 24, 111),
(867, 0, 24, 112),
(868, 0, 24, 113),
(869, 0, 24, 114),
(870, 0, 24, 115),
(871, 0, 24, 104),
(872, 0, 24, 105),
(873, 0, 24, 106),
(874, 0, 24, 107),
(875, 0, 24, 108),
(876, 0, 24, 109),
(877, 0, 24, 110),
(878, 0, 24, 111),
(879, 0, 24, 112),
(880, 0, 24, 113),
(881, 0, 24, 114),
(882, 0, 24, 115),
(883, 0, 24, 104),
(884, 0, 24, 105),
(885, 0, 24, 106),
(886, 0, 24, 107),
(887, 0, 24, 108),
(888, 0, 24, 109),
(889, 0, 24, 110),
(890, 0, 24, 111),
(891, 0, 24, 112),
(892, 0, 24, 113),
(893, 0, 24, 114),
(894, 0, 24, 115),
(895, 0, 24, 104),
(896, 0, 24, 105),
(897, 0, 24, 106),
(898, 0, 24, 107),
(899, 0, 24, 108),
(900, 0, 24, 109),
(901, 0, 24, 110),
(902, 0, 24, 111),
(903, 0, 24, 112),
(904, 0, 24, 113),
(905, 0, 24, 114),
(906, 0, 24, 115),
(907, 0, 24, 104),
(908, 0, 24, 105),
(909, 0, 24, 106),
(910, 0, 24, 107),
(911, 0, 24, 108),
(912, 0, 24, 109),
(913, 0, 24, 110),
(914, 0, 24, 111),
(915, 0, 24, 112),
(916, 0, 24, 113),
(917, 0, 24, 114),
(918, 0, 24, 115),
(919, 0, 24, 74),
(920, 0, 24, 75),
(921, 0, 24, 76),
(922, 0, 24, 77),
(923, 0, 24, 78),
(924, 0, 24, 79),
(925, 0, 24, 80),
(926, 0, 24, 81),
(927, 0, 24, 82),
(928, 0, 24, 83),
(929, 0, 24, 84),
(930, 0, 24, 85),
(931, 0, 24, 86),
(932, 0, 24, 87),
(933, 0, 24, 88),
(934, 0, 24, 89),
(935, 0, 24, 90),
(936, 0, 24, 91),
(937, 1, 24, 104),
(938, 1, 24, 105),
(939, 1, 24, 106),
(940, 1, 24, 107),
(941, 1, 24, 108),
(942, 1, 24, 109),
(943, 1, 24, 110),
(944, 1, 24, 111),
(945, 1, 24, 112),
(946, -1, 24, 113),
(947, -1, 24, 114),
(948, 1, 24, 115),
(949, 1, 24, 104),
(950, 1, 24, 105),
(951, 1, 24, 106),
(952, 1, 24, 107),
(953, 1, 24, 108),
(954, 1, 24, 109),
(955, 1, 24, 110),
(956, 1, 24, 111),
(957, 1, 24, 112),
(958, -1, 24, 113),
(959, -1, 24, 114),
(960, 1, 24, 115),
(961, 1, 24, 104),
(962, 1, 24, 105),
(963, 1, 24, 106),
(964, 1, 24, 107),
(965, 1, 24, 108),
(966, 1, 24, 109),
(967, 1, 24, 110),
(968, 1, 24, 111),
(969, 1, 24, 112),
(970, -1, 24, 113),
(971, -1, 24, 114),
(972, 1, 24, 115),
(973, 1, 24, 104),
(974, 1, 24, 105),
(975, 1, 24, 106),
(976, 1, 24, 107),
(977, 1, 24, 108),
(978, 1, 24, 109),
(979, 1, 24, 110),
(980, 1, 24, 111),
(981, 1, 24, 112),
(982, -1, 24, 113),
(983, -1, 24, 114),
(984, 1, 24, 115),
(985, 1, 24, 104),
(986, 1, 24, 105),
(987, 1, 24, 106),
(988, 1, 24, 107),
(989, 1, 24, 108),
(990, 1, 24, 109),
(991, 1, 24, 110),
(992, 1, 24, 111),
(993, 1, 24, 112),
(994, -1, 24, 113),
(995, -1, 24, 114),
(996, 1, 24, 115),
(997, 0, 24, 104),
(998, 0, 24, 105),
(999, 0, 24, 106),
(1000, 0, 24, 107),
(1001, 0, 24, 108),
(1002, 0, 24, 109),
(1003, 0, 24, 110),
(1004, 0, 24, 111),
(1005, 0, 24, 112),
(1006, 0, 24, 113),
(1007, 0, 24, 114),
(1008, 0, 24, 115),
(1009, 1, 24, 116),
(1010, 1, 24, 117),
(1011, 0, 24, 118),
(1012, -1, 24, 119),
(1013, 1, 24, 120),
(1014, 1, 24, 121),
(1015, 1, 24, 122),
(1016, 1, 24, 123),
(1017, -1, 24, 124),
(1018, 1, 24, 125),
(1019, 1, 24, 126),
(1020, 1, 24, 127),
(1021, 1, 24, 128),
(1022, -1, 24, 129),
(1023, 1, 24, 130),
(1024, 1, 24, 131),
(1025, -1, 24, 132),
(1026, 1, 24, 133),
(1027, 1, 24, 134),
(1028, 1, 24, 135),
(1029, 0, 24, 104),
(1030, 0, 24, 105),
(1031, 0, 24, 106),
(1032, 0, 24, 107),
(1033, 0, 24, 108),
(1034, 0, 24, 109),
(1035, 0, 24, 110),
(1036, 0, 24, 111),
(1037, 0, 24, 112),
(1038, 0, 24, 113),
(1039, 0, 24, 114),
(1040, 0, 24, 115),
(1041, 0, 24, 104),
(1042, 0, 24, 105),
(1043, 0, 24, 106),
(1044, 0, 24, 107),
(1045, 0, 24, 108),
(1046, 0, 24, 109),
(1047, 0, 24, 110),
(1048, 0, 24, 111),
(1049, 0, 24, 112),
(1050, 0, 24, 113),
(1051, 0, 24, 114),
(1052, 0, 24, 115),
(1053, 1, 24, 116),
(1054, 1, 24, 117),
(1055, 0, 24, 118),
(1056, 0, 24, 119),
(1057, 1, 24, 120),
(1058, 1, 24, 121),
(1059, 1, 24, 122),
(1060, 1, 24, 123),
(1061, 1, 24, 124),
(1062, 1, 24, 125),
(1063, 1, 24, 126),
(1064, 1, 24, 127),
(1065, 1, 24, 128),
(1066, 0, 24, 129),
(1067, 1, 24, 130),
(1068, 1, 24, 131),
(1069, 1, 24, 132),
(1070, 1, 24, 133),
(1071, 1, 24, 134),
(1072, 1, 24, 135),
(1073, 0, 24, 104),
(1074, 0, 24, 105),
(1075, 0, 24, 106),
(1076, 0, 24, 107),
(1077, 0, 24, 108),
(1078, 0, 24, 109),
(1079, 0, 24, 110),
(1080, 0, 24, 111),
(1081, 0, 24, 112),
(1082, 0, 24, 113),
(1083, 0, 24, 114),
(1084, 0, 24, 115),
(1085, 0, 24, 116),
(1086, 0, 24, 117),
(1087, 0, 24, 118),
(1088, 0, 24, 119),
(1089, 0, 24, 120),
(1090, 0, 24, 121),
(1091, 0, 24, 122),
(1092, 0, 24, 123),
(1093, 0, 24, 124),
(1094, 0, 24, 125),
(1095, 0, 24, 126),
(1096, 0, 24, 127),
(1097, 0, 24, 128),
(1098, 0, 24, 129),
(1099, 0, 24, 130),
(1100, 0, 24, 131),
(1101, 0, 24, 132),
(1102, 0, 24, 133),
(1103, 0, 24, 134),
(1104, 0, 24, 135),
(1105, 1, 24, 136),
(1106, 1, 24, 137),
(1107, 1, 24, 138),
(1108, 1, 24, 139),
(1109, 1, 24, 140),
(1110, 0, 24, 141),
(1111, 0, 24, 142),
(1112, 1, 24, 143),
(1113, 1, 24, 144),
(1114, 1, 24, 145),
(1115, 1, 24, 146),
(1116, 1, 24, 147),
(1117, 0, 24, 148),
(1118, 1, 24, 149),
(1119, 1, 24, 150),
(1120, 1, 24, 151),
(1121, 1, 24, 152),
(1122, 1, 24, 153),
(1123, 1, 24, 154),
(1124, 0, 24, 155),
(1125, 0, 24, 116),
(1126, 0, 24, 117),
(1127, 0, 24, 118),
(1128, 0, 24, 119),
(1129, 0, 24, 120),
(1130, 0, 24, 121),
(1131, 0, 24, 122),
(1132, 0, 24, 123),
(1133, 0, 24, 124),
(1134, 0, 24, 125),
(1135, 0, 24, 126),
(1136, 0, 24, 127),
(1137, 0, 24, 128),
(1138, 0, 24, 129),
(1139, 0, 24, 130),
(1140, 0, 24, 131),
(1141, 0, 24, 132),
(1142, 0, 24, 133),
(1143, 0, 24, 134),
(1144, 0, 24, 135),
(1145, 1, 24, 136),
(1146, 1, 24, 137),
(1147, 1, 24, 138),
(1148, 1, 24, 139),
(1149, 1, 24, 140),
(1150, 0, 24, 141),
(1151, 0, 24, 142),
(1152, 1, 24, 143),
(1153, 1, 24, 144),
(1154, 1, 24, 145),
(1155, 1, 24, 146),
(1156, 1, 24, 147),
(1157, 0, 24, 148),
(1158, 1, 24, 149),
(1159, 1, 24, 150),
(1160, 1, 24, 151),
(1161, 1, 24, 152),
(1162, 1, 24, 153),
(1163, 1, 24, 154),
(1164, 0, 24, 155),
(1165, 0, 24, 116),
(1166, 0, 24, 117),
(1167, 0, 24, 118),
(1168, 0, 24, 119),
(1169, 0, 24, 120),
(1170, 0, 24, 121),
(1171, 0, 24, 122),
(1172, 0, 24, 123),
(1173, 0, 24, 124),
(1174, 0, 24, 125),
(1175, 0, 24, 126),
(1176, 0, 24, 127),
(1177, 0, 24, 128),
(1178, 0, 24, 129),
(1179, 0, 24, 130),
(1180, 0, 24, 131),
(1181, 0, 24, 132),
(1182, 0, 24, 133),
(1183, 0, 24, 134),
(1184, 0, 24, 135),
(1185, 1, 24, 136),
(1186, 1, 24, 137),
(1187, 1, 24, 138),
(1188, 1, 24, 139),
(1189, 1, 24, 140),
(1190, 0, 24, 141),
(1191, 0, 24, 142),
(1192, 1, 24, 143),
(1193, 1, 24, 144),
(1194, 0, 24, 145),
(1195, 0, 24, 146),
(1196, 1, 24, 147),
(1197, 0, 24, 148),
(1198, 1, 24, 149),
(1199, 1, 24, 150),
(1200, 1, 24, 151),
(1201, 1, 24, 152),
(1202, 1, 24, 153),
(1203, 1, 24, 154),
(1204, 0, 24, 155),
(1205, 0, 24, 136),
(1206, 0, 24, 137),
(1207, 0, 24, 138),
(1208, 0, 24, 139),
(1209, 0, 24, 140),
(1210, 0, 24, 141),
(1211, 0, 24, 142),
(1212, 0, 24, 143),
(1213, 0, 24, 144),
(1214, 0, 24, 145),
(1215, 0, 24, 146),
(1216, 0, 24, 147),
(1217, 0, 24, 148),
(1218, 0, 24, 149),
(1219, 0, 24, 150),
(1220, 0, 24, 151),
(1221, 0, 24, 152),
(1222, 0, 24, 153),
(1223, 0, 24, 154),
(1224, 0, 24, 155),
(1225, 1, 24, 156),
(1226, 1, 24, 157),
(1227, 1, 24, 158),
(1228, 1, 24, 159),
(1229, 1, 24, 160),
(1230, -1, 24, 161),
(1231, 1, 24, 162),
(1232, 1, 24, 163),
(1233, 1, 24, 164),
(1234, 1, 24, 165),
(1235, -1, 24, 166),
(1236, -1, 24, 167),
(1237, -1, 24, 168),
(1238, 1, 24, 169),
(1239, 1, 24, 170),
(1240, 1, 24, 171),
(1241, -1, 24, 172),
(1242, 0, 24, 136),
(1243, 0, 24, 137),
(1244, 0, 24, 138),
(1245, 0, 24, 139),
(1246, 0, 24, 140),
(1247, 0, 24, 141),
(1248, 0, 24, 142),
(1249, 0, 24, 143),
(1250, 0, 24, 144),
(1251, 0, 24, 145),
(1252, 0, 24, 146),
(1253, 0, 24, 147),
(1254, 0, 24, 148),
(1255, 0, 24, 149),
(1256, 0, 24, 150),
(1257, 0, 24, 151),
(1258, 0, 24, 152),
(1259, 0, 24, 153),
(1260, 0, 24, 154),
(1261, 0, 24, 155),
(1262, 1, 24, 156),
(1263, 1, 24, 157),
(1264, 1, 24, 158),
(1265, -1, 24, 159),
(1266, -1, 24, 160),
(1267, 1, 24, 161),
(1268, 1, 24, 162),
(1269, -1, 24, 163),
(1270, -1, 24, 164),
(1271, 1, 24, 165),
(1272, 1, 24, 166),
(1273, 1, 24, 167),
(1274, -1, 24, 168),
(1275, -1, 24, 169),
(1276, -1, 24, 170),
(1277, -1, 24, 171),
(1278, -1, 24, 172),
(1279, 0, 24, 136),
(1280, 0, 24, 137),
(1281, 0, 24, 138),
(1282, 0, 24, 139),
(1283, 0, 24, 140),
(1284, 0, 24, 141),
(1285, 0, 24, 142),
(1286, 0, 24, 143),
(1287, 0, 24, 144),
(1288, 0, 24, 145),
(1289, 0, 24, 146),
(1290, 0, 24, 147),
(1291, 0, 24, 148),
(1292, 0, 24, 149),
(1293, 0, 24, 150),
(1294, 0, 24, 151),
(1295, 0, 24, 152),
(1296, 0, 24, 153),
(1297, 0, 24, 154),
(1298, 0, 24, 155),
(1299, 1, 24, 156),
(1300, 1, 24, 157),
(1301, 1, 24, 158),
(1302, -1, 24, 159),
(1303, -1, 24, 160),
(1304, 1, 24, 161),
(1305, 1, 24, 162),
(1306, -1, 24, 163),
(1307, -1, 24, 164),
(1308, 1, 24, 165),
(1309, 1, 24, 166),
(1310, 1, 24, 167),
(1311, -1, 24, 168),
(1312, -1, 24, 169),
(1313, -1, 24, 170),
(1314, -1, 24, 171),
(1315, -1, 24, 172),
(1316, 1, 24, 156),
(1317, 1, 24, 157),
(1318, 1, 24, 158),
(1319, -1, 24, 159),
(1320, -1, 24, 160),
(1321, 1, 24, 161),
(1322, 1, 24, 162),
(1323, -1, 24, 163),
(1324, -1, 24, 164),
(1325, 1, 24, 165),
(1326, 1, 24, 166),
(1327, 1, 24, 167),
(1328, -1, 24, 168),
(1329, -1, 24, 169),
(1330, -1, 24, 170),
(1331, -1, 24, 171),
(1332, -1, 24, 172),
(1333, 0, 24, 136),
(1334, 0, 24, 137),
(1335, 0, 24, 138),
(1336, 0, 24, 139),
(1337, 0, 24, 140),
(1338, 0, 24, 141),
(1339, 0, 24, 142),
(1340, 0, 24, 143),
(1341, 0, 24, 144),
(1342, 0, 24, 145),
(1343, 0, 24, 146),
(1344, 0, 24, 147),
(1345, 0, 24, 148),
(1346, 0, 24, 149),
(1347, 0, 24, 150),
(1348, 0, 24, 151),
(1349, 0, 24, 152),
(1350, 0, 24, 153),
(1351, 0, 24, 154),
(1352, 0, 24, 155),
(1353, 0, 24, 136),
(1354, 0, 24, 137),
(1355, 0, 24, 138),
(1356, 0, 24, 139),
(1357, 0, 24, 140),
(1358, 0, 24, 141),
(1359, 0, 24, 142),
(1360, 0, 24, 143),
(1361, 0, 24, 144),
(1362, 0, 24, 145),
(1363, 0, 24, 146),
(1364, 0, 24, 147),
(1365, 0, 24, 148),
(1366, 0, 24, 149),
(1367, 0, 24, 150),
(1368, 0, 24, 151),
(1369, 0, 24, 152),
(1370, 0, 24, 153),
(1371, 0, 24, 154),
(1372, 0, 24, 155),
(1373, 1, 24, 156),
(1374, 1, 24, 157),
(1375, 1, 24, 158),
(1376, 1, 24, 159),
(1377, 1, 24, 160),
(1378, 1, 24, 161),
(1379, 1, 24, 162),
(1380, 1, 24, 163),
(1381, 1, 24, 164),
(1382, 1, 24, 165),
(1383, 1, 24, 166),
(1384, -1, 24, 167),
(1385, 1, 24, 168),
(1386, 1, 24, 169),
(1387, 1, 24, 170),
(1388, 1, 24, 171),
(1389, 1, 24, 172),
(1390, 0, 24, 156),
(1391, 0, 24, 157),
(1392, 0, 24, 158),
(1393, 0, 24, 159),
(1394, 0, 24, 160),
(1395, 0, 24, 161),
(1396, 0, 24, 162),
(1397, 0, 24, 163),
(1398, 0, 24, 164),
(1399, 0, 24, 165),
(1400, 0, 24, 166),
(1401, 0, 24, 167),
(1402, 0, 24, 168),
(1403, 0, 24, 169),
(1404, 0, 24, 170),
(1405, 0, 24, 171),
(1406, 0, 24, 172),
(1407, 0, 24, 116),
(1408, 0, 24, 117),
(1409, 0, 24, 118),
(1410, 0, 24, 119),
(1411, 0, 24, 120),
(1412, 0, 24, 121),
(1413, 0, 24, 122),
(1414, 0, 24, 123),
(1415, 0, 24, 124),
(1416, 0, 24, 125),
(1417, 0, 24, 126),
(1418, 0, 24, 127),
(1419, 0, 24, 128),
(1420, 0, 24, 129),
(1421, 0, 24, 130),
(1422, 0, 24, 131),
(1423, 0, 24, 132),
(1424, 0, 24, 133),
(1425, 0, 24, 134),
(1426, 0, 24, 135),
(1427, 0, 24, 156),
(1428, 0, 24, 157),
(1429, 0, 24, 158),
(1430, 0, 24, 159),
(1431, 0, 24, 160),
(1432, 0, 24, 161),
(1433, 0, 24, 162),
(1434, 0, 24, 163),
(1435, 0, 24, 164),
(1436, 0, 24, 165),
(1437, 0, 24, 166),
(1438, 0, 24, 167),
(1439, 0, 24, 168),
(1440, 0, 24, 169),
(1441, 0, 24, 170),
(1442, 0, 24, 171),
(1443, 0, 24, 172),
(1444, 0, 24, 173),
(1445, 0, 24, 174),
(1446, 1, 24, 175),
(1447, 1, 24, 176),
(1448, 1, 24, 177),
(1449, 0, 24, 178),
(1450, 0, 24, 179),
(1451, 1, 24, 180),
(1452, 1, 24, 181),
(1453, 1, 24, 182),
(1454, 1, 24, 183),
(1455, 0, 24, 184),
(1456, 1, 24, 185),
(1457, 1, 24, 186),
(1458, 1, 24, 187),
(1459, 1, 24, 188),
(1460, 0, 24, 189),
(1461, 1, 24, 190),
(1462, 0, 24, 173),
(1463, 0, 24, 174),
(1464, 1, 24, 175),
(1465, 1, 24, 176),
(1466, 1, 24, 177),
(1467, 0, 24, 178),
(1468, 0, 24, 179),
(1469, 1, 24, 180),
(1470, 1, 24, 181),
(1471, 1, 24, 182),
(1472, 1, 24, 183),
(1473, 0, 24, 184),
(1474, 1, 24, 185),
(1475, 1, 24, 186),
(1476, 1, 24, 187),
(1477, 1, 24, 188),
(1478, 0, 24, 189),
(1479, 1, 24, 190),
(1480, 0, 24, 173),
(1481, 0, 24, 174),
(1482, 0, 24, 175),
(1483, 0, 24, 176),
(1484, 0, 24, 177),
(1485, 0, 24, 178),
(1486, 0, 24, 179),
(1487, 0, 24, 180),
(1488, 0, 24, 181),
(1489, 0, 24, 182),
(1490, 0, 24, 183),
(1491, 0, 24, 184),
(1492, 0, 24, 185),
(1493, 0, 24, 186),
(1494, 0, 24, 187),
(1495, 0, 24, 188),
(1496, 0, 24, 189),
(1497, 0, 24, 190),
(1498, 0, 24, 173),
(1499, 0, 24, 174),
(1500, 0, 24, 175),
(1501, 0, 24, 176),
(1502, 0, 24, 177),
(1503, 0, 24, 178),
(1504, 0, 24, 179),
(1505, 0, 24, 180),
(1506, 0, 24, 181),
(1507, 0, 24, 182),
(1508, 0, 24, 183),
(1509, 0, 24, 184),
(1510, 0, 24, 185),
(1511, 0, 24, 186),
(1512, 0, 24, 187),
(1513, 0, 24, 188),
(1514, 0, 24, 189),
(1515, 0, 24, 190),
(1516, 0, 24, 173),
(1517, 0, 24, 174),
(1518, 0, 24, 175),
(1519, 0, 24, 176),
(1520, 0, 24, 177),
(1521, 0, 24, 178),
(1522, 0, 24, 179),
(1523, 0, 24, 180),
(1524, 0, 24, 181),
(1525, 0, 24, 182),
(1526, 0, 24, 183),
(1527, 0, 24, 184),
(1528, 0, 24, 185),
(1529, 0, 24, 186),
(1530, 0, 24, 187),
(1531, 0, 24, 188),
(1532, 0, 24, 189),
(1533, 0, 24, 190),
(1534, 0, 24, 173),
(1535, 0, 24, 174),
(1536, 0, 24, 175),
(1537, 0, 24, 176),
(1538, 0, 24, 177),
(1539, 0, 24, 178),
(1540, 0, 24, 179),
(1541, 0, 24, 180),
(1542, 0, 24, 181),
(1543, 0, 24, 182),
(1544, 0, 24, 183),
(1545, 0, 24, 184),
(1546, 0, 24, 185),
(1547, 0, 24, 186),
(1548, 0, 24, 187),
(1549, 0, 24, 188),
(1550, 0, 24, 189),
(1551, 0, 24, 190),
(1552, 1, 24, 191),
(1553, 1, 24, 192),
(1554, 1, 24, 193),
(1555, 1, 24, 194),
(1556, 1, 24, 195),
(1557, 1, 24, 196),
(1558, 1, 24, 197),
(1559, 0, 24, 198),
(1560, 1, 24, 199),
(1561, 0, 24, 200),
(1562, 0, 24, 201),
(1563, 0, 24, 191),
(1564, 0, 24, 192),
(1565, 0, 24, 193),
(1566, 0, 24, 194),
(1567, 0, 24, 195),
(1568, 0, 24, 196),
(1569, 0, 24, 197),
(1570, 0, 24, 198),
(1571, 0, 24, 199),
(1572, 0, 24, 200),
(1573, 0, 24, 201),
(1574, -1, 25, 5),
(1575, 1, 25, 6),
(1576, -1, 25, 7),
(1577, -1, 25, 8),
(1578, 1, 25, 9),
(1579, -1, 25, 10),
(1580, 1, 25, 11),
(1581, 1, 25, 14),
(1582, -1, 25, 15),
(1583, 1, 25, 16),
(1584, 1, 25, 17),
(1585, -1, 25, 18),
(1586, 1, 25, 19),
(1587, -1, 25, 20),
(1588, -1, 25, 21),
(1589, -1, 25, 22),
(1590, -1, 25, 23),
(1591, -1, 25, 34),
(1592, -1, 25, 35),
(1593, -1, 25, 36),
(1594, -1, 25, 37),
(1595, 1, 25, 38),
(1596, -1, 25, 39),
(1597, 1, 25, 40),
(1598, -1, 25, 41),
(1599, -1, 25, 42),
(1600, -1, 25, 43),
(1601, 1, 25, 44),
(1602, -1, 25, 45),
(1603, 1, 25, 46),
(1604, 1, 25, 47),
(1605, 1, 25, 48),
(1606, 1, 25, 49),
(1607, -1, 25, 50),
(1608, -1, 25, 51),
(1609, 1, 25, 52),
(1610, -1, 25, 53),
(1611, -1, 25, 54),
(1612, 1, 25, 55),
(1613, 1, 25, 56),
(1614, 0, 25, 57),
(1615, 1, 25, 58),
(1616, 1, 25, 59),
(1617, 0, 25, 60),
(1618, 1, 25, 61),
(1619, 0, 25, 62),
(1620, 0, 25, 63),
(1621, 0, 25, 64),
(1622, 0, 25, 65),
(1623, 0, 25, 66),
(1624, 0, 25, 67),
(1625, -1, 25, 68),
(1626, 0, 25, 69),
(1627, 0, 25, 70),
(1628, 1, 25, 71),
(1629, 0, 25, 72),
(1630, -1, 25, 73),
(1631, 0, 25, 74),
(1632, 1, 25, 75),
(1633, 0, 25, 76),
(1634, 1, 25, 77),
(1635, 0, 25, 78),
(1636, 0, 25, 79),
(1637, 0, 25, 80),
(1638, 0, 25, 81),
(1639, 0, 25, 82),
(1640, 0, 25, 83),
(1641, 0, 25, 84),
(1642, 0, 25, 85),
(1643, 0, 25, 86),
(1644, 0, 25, 87),
(1645, 0, 25, 88),
(1646, 0, 25, 89),
(1647, 0, 25, 90),
(1648, 0, 25, 91),
(1649, 1, 25, 104),
(1650, -1, 25, 105),
(1651, -1, 25, 106),
(1652, -1, 25, 107),
(1653, 0, 25, 108),
(1654, 0, 25, 109),
(1655, -1, 25, 110),
(1656, 1, 25, 111),
(1657, -1, 25, 112),
(1658, -1, 25, 113),
(1659, -1, 25, 114),
(1660, 0, 25, 115),
(1661, 1, 25, 116),
(1662, 1, 25, 117),
(1663, 0, 25, 118),
(1664, 0, 25, 119),
(1665, 1, 25, 120),
(1666, 1, 25, 121),
(1667, 0, 25, 122),
(1668, 1, 25, 123),
(1669, 0, 25, 124),
(1670, 0, 25, 125),
(1671, 0, 25, 126),
(1672, 1, 25, 127),
(1673, 0, 25, 128),
(1674, 0, 25, 129),
(1675, 0, 25, 130),
(1676, 1, 25, 131),
(1677, 1, 25, 132),
(1678, 1, 25, 133),
(1679, 0, 25, 134),
(1680, 0, 25, 135),
(1681, 0, 25, 136),
(1682, 0, 25, 137),
(1683, 0, 25, 138),
(1684, 0, 25, 139),
(1685, 0, 25, 140),
(1686, 0, 25, 141),
(1687, 0, 25, 142),
(1688, 0, 25, 143),
(1689, 0, 25, 144),
(1690, 0, 25, 145),
(1691, 0, 25, 146),
(1692, 0, 25, 147),
(1693, 0, 25, 148),
(1694, 0, 25, 149),
(1695, 0, 25, 150),
(1696, 0, 25, 151),
(1697, 0, 25, 152),
(1698, 0, 25, 153),
(1699, 0, 25, 154),
(1700, 0, 25, 155),
(1701, 0, 25, 156),
(1702, 0, 25, 157),
(1703, 0, 25, 158),
(1704, 0, 25, 159),
(1705, 0, 25, 160),
(1706, 0, 25, 161),
(1707, 0, 25, 162),
(1708, 0, 25, 163),
(1709, 0, 25, 164),
(1710, 0, 25, 165),
(1711, 0, 25, 166),
(1712, 0, 25, 167),
(1713, 0, 25, 168),
(1714, 0, 25, 169),
(1715, 0, 25, 170),
(1716, 0, 25, 171),
(1717, 0, 25, 172),
(1718, 0, 25, 173),
(1719, 0, 25, 174),
(1720, 0, 25, 175),
(1721, 0, 25, 176),
(1722, 0, 25, 177),
(1723, 0, 25, 178),
(1724, 0, 25, 179),
(1725, 0, 25, 180),
(1726, 0, 25, 181),
(1727, 0, 25, 182),
(1728, 0, 25, 183),
(1729, 0, 25, 184),
(1730, 0, 25, 185),
(1731, 0, 25, 186),
(1732, 0, 25, 187),
(1733, 0, 25, 188),
(1734, 0, 25, 189),
(1735, 0, 25, 190),
(1736, 0, 25, 191),
(1737, 0, 25, 192),
(1738, 0, 25, 193),
(1739, 0, 25, 194),
(1740, 0, 25, 195),
(1741, 0, 25, 196),
(1742, 0, 25, 197),
(1743, 0, 25, 198),
(1744, 0, 25, 199),
(1745, 0, 25, 200),
(1746, 0, 25, 201),
(1747, 0, 26, 5),
(1748, 0, 26, 6),
(1749, 0, 26, 7),
(1750, 0, 26, 8),
(1751, 0, 26, 9),
(1752, 0, 26, 10),
(1753, -1, 26, 11),
(1754, 0, 26, 14),
(1755, 0, 26, 15),
(1756, 0, 26, 16),
(1757, 0, 26, 17),
(1758, 0, 26, 18),
(1759, 0, 26, 19),
(1760, 0, 26, 20),
(1761, 0, 26, 21),
(1762, 0, 26, 22),
(1763, 0, 26, 23),
(1764, 0, 26, 34),
(1765, 0, 26, 35),
(1766, 0, 26, 36),
(1767, -1, 26, 37),
(1768, 0, 26, 38),
(1769, 0, 26, 39),
(1770, 0, 26, 40),
(1771, 0, 26, 41),
(1772, 0, 26, 42),
(1773, 0, 26, 43),
(1774, 0, 26, 44),
(1775, 0, 26, 45),
(1776, 0, 26, 46),
(1777, 0, 26, 47),
(1778, 0, 26, 48),
(1779, 0, 26, 49),
(1780, 0, 26, 50),
(1781, 0, 26, 51),
(1782, 0, 26, 52),
(1783, 0, 26, 53),
(1784, 0, 26, 54),
(1785, 0, 26, 55),
(1786, 0, 26, 56),
(1787, 0, 26, 57),
(1788, 0, 26, 58),
(1789, 0, 26, 59),
(1790, 0, 26, 60),
(1791, 0, 26, 61),
(1792, 0, 26, 62),
(1793, 0, 26, 63),
(1794, 0, 26, 64),
(1795, 0, 26, 65),
(1796, 0, 26, 66),
(1797, 0, 26, 67),
(1798, 0, 26, 68),
(1799, 0, 26, 69),
(1800, 0, 26, 70),
(1801, 0, 26, 71),
(1802, 0, 26, 72),
(1803, 0, 26, 73),
(1804, 0, 26, 74),
(1805, 0, 26, 75),
(1806, 0, 26, 76),
(1807, 0, 26, 77),
(1808, 0, 26, 78),
(1809, 0, 26, 79),
(1810, 0, 26, 80),
(1811, 0, 26, 81),
(1812, 0, 26, 82),
(1813, 0, 26, 83),
(1814, 0, 26, 84),
(1815, 0, 26, 85),
(1816, 0, 26, 86),
(1817, 0, 26, 87),
(1818, 0, 26, 88),
(1819, 0, 26, 89),
(1820, 0, 26, 90),
(1821, 0, 26, 91),
(1822, 0, 26, 44),
(1823, 0, 26, 45),
(1824, 0, 26, 46),
(1825, 0, 26, 47),
(1826, 0, 26, 48),
(1827, 0, 26, 49),
(1828, 0, 26, 50),
(1829, 0, 26, 51),
(1830, 0, 26, 52),
(1831, 0, 26, 53),
(1832, 0, 26, 54),
(1833, 0, 26, 55),
(1834, 0, 26, 56),
(1835, 0, 26, 57),
(1836, 0, 26, 58),
(1837, 0, 26, 59),
(1838, 0, 26, 60),
(1839, 0, 26, 61),
(1840, 0, 26, 62),
(1841, 0, 26, 63),
(1842, 0, 26, 64),
(1843, 0, 26, 65),
(1844, 0, 26, 66),
(1845, 0, 26, 67),
(1846, 0, 26, 68),
(1847, 0, 26, 69),
(1848, 0, 26, 70),
(1849, 0, 26, 71),
(1850, 0, 26, 72),
(1851, 0, 26, 73),
(1852, 0, 26, 74),
(1853, 0, 26, 75),
(1854, 0, 26, 76),
(1855, 0, 26, 77),
(1856, 0, 26, 78),
(1857, 0, 26, 79),
(1858, 0, 26, 80),
(1859, 0, 26, 81),
(1860, 0, 26, 82),
(1861, 0, 26, 83),
(1862, 0, 26, 84),
(1863, 0, 26, 85),
(1864, 0, 26, 86),
(1865, 0, 26, 87),
(1866, 0, 26, 88),
(1867, 0, 26, 89),
(1868, 0, 26, 90),
(1869, 0, 26, 91),
(1870, 0, 26, 104),
(1871, 0, 26, 105),
(1872, 0, 26, 106),
(1873, 0, 26, 107),
(1874, 0, 26, 108),
(1875, 0, 26, 109),
(1876, 0, 26, 110),
(1877, 0, 26, 111),
(1878, 0, 26, 112),
(1879, 0, 26, 113),
(1880, 0, 26, 114),
(1881, 0, 26, 115),
(1882, 0, 26, 104),
(1883, 0, 26, 105),
(1884, 0, 26, 106),
(1885, 0, 26, 107),
(1886, 0, 26, 108),
(1887, 0, 26, 109),
(1888, 0, 26, 110),
(1889, 0, 26, 111),
(1890, 0, 26, 112),
(1891, 0, 26, 113),
(1892, 0, 26, 114),
(1893, 0, 26, 115),
(1894, 0, 26, 116),
(1895, 0, 26, 117),
(1896, 0, 26, 118),
(1897, 0, 26, 119),
(1898, 0, 26, 120),
(1899, 0, 26, 121),
(1900, 0, 26, 122),
(1901, 0, 26, 123),
(1902, 0, 26, 124),
(1903, 0, 26, 125),
(1904, 0, 26, 126),
(1905, 0, 26, 127),
(1906, 0, 26, 128),
(1907, 0, 26, 129),
(1908, 0, 26, 130),
(1909, 0, 26, 131),
(1910, 0, 26, 132),
(1911, 0, 26, 133),
(1912, 0, 26, 134),
(1913, 0, 26, 135),
(1914, 0, 26, 136),
(1915, 0, 26, 137),
(1916, 0, 26, 138),
(1917, 0, 26, 139),
(1918, 0, 26, 140),
(1919, 0, 26, 141),
(1920, 0, 26, 142),
(1921, 0, 26, 143),
(1922, 0, 26, 144),
(1923, 0, 26, 145),
(1924, 0, 26, 146),
(1925, 0, 26, 147),
(1926, 0, 26, 148),
(1927, 0, 26, 149),
(1928, 0, 26, 150),
(1929, 0, 26, 151),
(1930, 0, 26, 152),
(1931, 0, 26, 153),
(1932, 0, 26, 154),
(1933, 0, 26, 155),
(1934, 0, 26, 156),
(1935, 0, 26, 157),
(1936, 0, 26, 158),
(1937, 0, 26, 159),
(1938, 0, 26, 160),
(1939, 0, 26, 161),
(1940, 0, 26, 162),
(1941, 0, 26, 163),
(1942, 0, 26, 164),
(1943, 0, 26, 165),
(1944, 0, 26, 166),
(1945, 0, 26, 167),
(1946, 0, 26, 168),
(1947, 0, 26, 169),
(1948, 0, 26, 170),
(1949, 0, 26, 171),
(1950, 0, 26, 172),
(1951, 0, 26, 173),
(1952, 0, 26, 174),
(1953, 0, 26, 175),
(1954, 0, 26, 176),
(1955, 0, 26, 177),
(1956, 0, 26, 178),
(1957, 0, 26, 179),
(1958, 0, 26, 180),
(1959, 0, 26, 181),
(1960, 0, 26, 182),
(1961, 0, 26, 183),
(1962, 0, 26, 184),
(1963, 0, 26, 185),
(1964, 0, 26, 186),
(1965, 0, 26, 187),
(1966, 0, 26, 188),
(1967, 0, 26, 189),
(1968, 0, 26, 190),
(1969, 0, 26, 191),
(1970, 0, 26, 192),
(1971, 0, 26, 193),
(1972, 0, 26, 194),
(1973, 0, 26, 195),
(1974, 0, 26, 196),
(1975, 0, 26, 197),
(1976, 0, 26, 198),
(1977, 0, 26, 199),
(1978, 0, 26, 200),
(1979, 0, 26, 201);

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

--
-- Estructura de tabla para la tabla `resultados`
--

CREATE TABLE `resultados` (
  `id` int(11) NOT NULL,
  `puntos` int(11) NOT NULL,
  `id_usuario` int(11) NOT NULL,
  `id_total_seg` int(11) NOT NULL,
  `ci_id` int(11) NOT NULL,
  `ci_rango_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Estructura de tabla para la tabla `segmentos`
--

CREATE TABLE `segmentos` (
  `id` int(11) NOT NULL,
  `segmento` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `segmentos` (`id`, `segmento`) VALUES
(1, 'SERIE I'),
(2, 'SERIE II'),
(3, 'SERIE III'),
(4, 'SERIE IV'),
(5, 'SERIE V'),
(6, 'SERIE VI'),
(7, 'SERIE VII'),
(8, 'SERIE VIII'),
(9, 'SERIE IX'),
(10, 'SERIE X');

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

--
-- Estructura de tabla para la tabla `total_segmento`
--

CREATE TABLE `total_segmento` (
  `id` int(11) NOT NULL,
  `puntos` int(11) NOT NULL,
  `id_usuario` int(11) NOT NULL,
  `id_rango` int(11) NOT NULL,
  `id_segmento` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `total_segmento` (`id`, `puntos`, `id_usuario`, `id_rango`, `id_segmento`) VALUES
(1, 16, 23, 1, 1),
(2, 11, 23, 12, 2),
(3, 30, 23, 15, 3),
(17, 4, 24, 28, 4),
(25, 16, 24, 33, 5),
(28, 19, 24, 37, 6),
(34, 16, 24, 45, 7),
(40, 17, 24, 50, 8),
(50, 12, 24, 61, 9),
(56, 16, 24, 69, 10),
(58, 16, 25, 1, 1),
(59, 11, 25, 12, 2),
(60, 19, 25, 18, 3),
(61, 2, 25, 28, 4),
(62, -10, 25, 35, 5),
(63, 9, 25, 39, 6),
(64, 0, 25, 49, 7),
(65, 0, 25, 57, 8),
(66, 0, 25, 64, 9),
(67, 0, 25, 71, 10),
(68, 1, 26, 6, 1),
(69, 1, 26, 14, 2),
(70, 0, 26, 21, 3),
(71, 0, 26, 28, 4),
(72, 0, 26, 21, 3),
(73, 0, 26, 28, 4),
(74, 0, 26, 35, 5),
(75, 0, 26, 35, 5),
(76, 0, 26, 42, 6),
(77, 0, 26, 49, 7),
(78, 0, 26, 57, 8),
(79, 0, 26, 64, 9),
(80, 0, 26, 71, 10);

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

--
-- Estructura de tabla para la tabla `usuarios`
--

CREATE TABLE `usuarios` (
  `id` int(11) NOT NULL,
  `nombre` varchar(100) DEFAULT NULL,
  `apellidos` varchar(100) DEFAULT NULL,
  `edad` int(11) DEFAULT NULL,
  `sexo` varchar(10) DEFAULT NULL,
  `estado` varchar(100) DEFAULT NULL,
  `correo` varchar(100) DEFAULT NULL,
  `telefono` double NOT NULL,
  `curp` varchar(18) DEFAULT NULL,
  `curriculum` varchar(255) DEFAULT NULL,
  `ine` varchar(255) DEFAULT NULL,
  `contrasena` varchar(500) NOT NULL,
  `vacante_id` int(11) DEFAULT NULL,
  `estatus` varchar(15) DEFAULT NULL,
  `test` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `usuarios` (`id`, `nombre`, `apellidos`, `edad`, `sexo`, `estado`, `correo`, `telefono`, `curp`, `curriculum`, `ine`, `contrasena`, `vacante_id`, `estatus`, `test`) VALUES
(23, 'XOCHITL ARAMIS', 'DELGADO MONROY', 23, 'M', 'MN', 'aramis_de.mo@hotmail.com', 4433709024, 'DEMX960401MMNLNC08', 'INEDEMX960401MMNLNC08', 'CVDEMX960401MMNLNC08', '4433709024', 1, 'ACEPTADO', 1),
(24, 'LUIS ANTONIO', 'RESCALA ALVAREZ', 27, 'H', 'MN', 'luis.rescala@gmail.com', 4431835407, 'REAL920328HMNSLS02', 'INEREAL920328HMNSLS02', 'CVREAL920328HMNSLS02', '4431835407', 1, 'RECHAZADO', 1),
(25, 'MONSERRAT', 'DELGADO SANCHEZ', 30, 'M', 'GR', 'mon@hotmail.com', 443131559, 'DESM890324MGRLNN04', 'INEDESM890324MGRLNN04', 'CVDESM890324MGRLNN04', '0443131559', 0, NULL, 1),
(26, 'MIGUEL ANGEL', 'DE BLAS SOLORIO', 22, 'H', 'MN', 'miguel@hotmail.com', 1234567890, 'BASM961120HMNLLG06', 'INEBASM961120HMNLLG06', 'CVBASM961120HMNLLG06', '1234567890\'', 2, NULL, 1);

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

--
-- Estructura de tabla para la tabla `vacante`
--

CREATE TABLE `vacante` (
  `id` int(11) NOT NULL,
  `vacante` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `vacante` (`id`, `vacante`) VALUES
(0, 'Desarrollador Back-End'),
(1, 'Desarrollador Front-End'),
(2, 'Diseñador Gráfico'),
(3, 'Coordinador de Logistica');

--
-- Índices para tablas volcadas
--

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

--
-- Indices de la tabla `ci_rango`
--
ALTER TABLE `ci_rango`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_rango_ci` (`id_rango_ci`),
  ADD KEY `is_ci` (`id_ci`);

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

--
-- Indices de la tabla `preguntas`
--
ALTER TABLE `preguntas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `segmento_id` (`segmento_id`);

--
-- Indices de la tabla `rango`
--
ALTER TABLE `rango`
  ADD PRIMARY KEY (`id_rango`),
  ADD KEY `segmento_id` (`segmento_id`);

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

--
-- Indices de la tabla `respuestas`
--
ALTER TABLE `respuestas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_pregunta` (`id_pregunta`);

--
-- Indices de la tabla `resp_usuario`
--
ALTER TABLE `resp_usuario`
  ADD PRIMARY KEY (`id`),
  ADD KEY `id_usuario` (`id_usuario`),
  ADD KEY `id_pregunta` (`id_pregunta`);

--
-- Indices de la tabla `resultados`
--
ALTER TABLE `resultados`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDusuario` (`id_usuario`),
  ADD KEY `ci_rango_id` (`ci_rango_id`),
  ADD KEY `ci_id` (`ci_id`),
  ADD KEY `id_total_seg` (`id_total_seg`);

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

--
-- Indices de la tabla `total_segmento`
--
ALTER TABLE `total_segmento`
  ADD PRIMARY KEY (`id`),
  ADD KEY `usuario_id` (`id_usuario`),
  ADD KEY `id_rango` (`id_rango`),
  ADD KEY `id_segmento` (`id_segmento`);

--
-- Indices de la tabla `usuarios`
--
ALTER TABLE `usuarios`
  ADD PRIMARY KEY (`id`),
  ADD KEY `vacante_id` (`vacante_id`);

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

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `administrador`
--
ALTER TABLE `administrador`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `ci_rango`
--
ALTER TABLE `ci_rango`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;

--
-- AUTO_INCREMENT de la tabla `c_i`
--
ALTER TABLE `c_i`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=124;

--
-- AUTO_INCREMENT de la tabla `preguntas`
--
ALTER TABLE `preguntas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=202;

--
-- AUTO_INCREMENT de la tabla `rango`
--
ALTER TABLE `rango`
  MODIFY `id_rango` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=72;

--
-- AUTO_INCREMENT de la tabla `rango_ci`
--
ALTER TABLE `rango_ci`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de la tabla `respuestas`
--
ALTER TABLE `respuestas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=934;

--
-- AUTO_INCREMENT de la tabla `resp_usuario`
--
ALTER TABLE `resp_usuario`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1980;

--
-- AUTO_INCREMENT de la tabla `resultados`
--
ALTER TABLE `resultados`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `segmentos`
--
ALTER TABLE `segmentos`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT de la tabla `total_segmento`
--
ALTER TABLE `total_segmento`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=81;

--
-- AUTO_INCREMENT de la tabla `usuarios`
--
ALTER TABLE `usuarios`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `ci_rango`
--
ALTER TABLE `ci_rango`
  ADD CONSTRAINT `id_rango_ci` FOREIGN KEY (`id_rango_ci`) REFERENCES `rango_ci` (`id`),
  ADD CONSTRAINT `is_ci` FOREIGN KEY (`id_ci`) REFERENCES `c_i` (`id`);

--
-- Filtros para la tabla `preguntas`
--
ALTER TABLE `preguntas`
  ADD CONSTRAINT `segmento_id` FOREIGN KEY (`segmento_id`) REFERENCES `segmentos` (`id`);

--
-- Filtros para la tabla `respuestas`
--
ALTER TABLE `respuestas`
  ADD CONSTRAINT `id_pregunta` FOREIGN KEY (`id_pregunta`) REFERENCES `preguntas` (`id`);

--
-- Filtros para la tabla `resp_usuario`
--
ALTER TABLE `resp_usuario`
  ADD CONSTRAINT `id_usuario` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id`),
  ADD CONSTRAINT `resp_usuario_ibfk_1` FOREIGN KEY (`id_pregunta`) REFERENCES `preguntas` (`id`);

--
-- Filtros para la tabla `resultados`
--
ALTER TABLE `resultados`
  ADD CONSTRAINT `IDusuario` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id`),
  ADD CONSTRAINT `ci_id` FOREIGN KEY (`ci_id`) REFERENCES `usuarios` (`id`),
  ADD CONSTRAINT `ci_rango_id` FOREIGN KEY (`ci_rango_id`) REFERENCES `usuarios` (`id`);

--
-- Filtros para la tabla `total_segmento`
--
ALTER TABLE `total_segmento`
  ADD CONSTRAINT `id_rango` FOREIGN KEY (`id_rango`) REFERENCES `rango` (`id_rango`),
  ADD CONSTRAINT `usuario_id` FOREIGN KEY (`id_usuario`) REFERENCES `usuarios` (`id`);

--
-- Filtros para la tabla `usuarios`
--
ALTER TABLE `usuarios`
  ADD CONSTRAINT `vacante_id` FOREIGN KEY (`vacante_id`) REFERENCES `vacante` (`id`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;