-- 
-- Estructura de tabla para la tabla `Autorizar`
-- 

CREATE TABLE `Autorizar` (
  `No` int(6) NOT NULL AUTO_INCREMENT,
  `Fecha` date NOT NULL,
  `Cédula` varchar(15) NOT NULL,
  `Ciudad` varchar(25) NOT NULL,
  `Tarifa` int(10) NOT NULL,
  `Os` int(10) NOT NULL,
  PRIMARY KEY (`No`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

-- 
-- Volcar la base de datos para la tabla `Autorizar`
-- 

INSERT INTO `Autorizar` (`No`, `Fecha`, `Cédula`, `Ciudad`, `Tarifa`, `Os`) VALUES (1, '0000-00-00', '54543', 'Bogota', 434, 434324),
(2, '0000-00-00', '', '', 0, 0),
(3, '0000-00-00', '', '', 0, 0);

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

-- 
-- Estructura de tabla para la tabla `Barrio`
-- 

CREATE TABLE `Barrio` (
  `No` int(4) NOT NULL AUTO_INCREMENT,
  `Barrio` varchar(35) NOT NULL,
  `Localidad` varchar(35) NOT NULL,
  `Ciudad` varchar(35) NOT NULL,
  KEY `No` (`No`)
) ENGINE=MyISAM AUTO_INCREMENT=304 DEFAULT CHARSET=utf8 AUTO_INCREMENT=304 ;

-- 
-- Volcar la base de datos para la tabla `Barrio`
-- 

INSERT INTO `Barrio` (`No`, `Barrio`, `Localidad`, `Ciudad`) VALUES (1, 'acropolis', '', ''),
(2, 'aguas calientes', '', ''),
(3, 'alabanza', '', ''),
(4, 'alhambra', '', ''),
(5, 'almonacid', '', ''),
(6, 'altos de chozica', '', ''),
(7, 'antonio granados', '', ''),
(8, 'aures', '', ''),
(9, 'aures', '', ''),
(10, 'babuy', '', ''),
(11, 'bella vista', '', ''),
(12, 'britalia', '', ''),
(13, 'calatrava', '', ''),
(14, 'calatrava 1', '', ''),
(15, 'calima norte', '', ''),
(16, 'campanella', '', ''),
(17, 'campania', '', ''),
(18, 'canodromo', '', ''),
(19, 'cantagallo', '', ''),
(20, 'carmen norte', '', ''),
(21, 'casablanca', '', ''),
(22, 'catalejo', '', ''),
(23, 'centro suba', '', ''),
(24, 'centro suba', '', ''),
(25, 'cerros de santa ines', '', ''),
(26, 'ciudad hunza', '', ''),
(27, 'ciudad jardin', '', ''),
(28, 'ciudad jardin norte', '', ''),
(29, 'club el rancho', '', ''),
(30, 'club hipico pinares', '', ''),
(31, 'club los lagartos', '', ''),
(32, 'colina campestre', '', ''),
(33, 'córdoba', '', ''),
(34, 'cordoba niza', '', ''),
(35, 'costa azul', '', ''),
(36, 'costa rica', '', ''),
(37, 'covadonga', '', ''),
(38, 'daeomar', '', ''),
(39, 'don jose', '', ''),
(40, 'el arrayán', '', ''),
(41, 'el balcon', '', ''),
(42, 'el batán', '', ''),
(43, 'el chircal', '', ''),
(44, 'el delirio', '', ''),
(45, 'el diamante', '', ''),
(46, 'el diamante', '', ''),
(47, 'el eden', '', ''),
(48, 'el imperio', '', ''),
(49, 'el jurá', '', ''),
(50, 'el libertador', '', ''),
(51, 'el pinar de suba', '', ''),
(52, 'el poblado', '', ''),
(53, 'el prado ', '', ''),
(54, 'el recreo de los frailes', '', ''),
(55, 'el refugio', '', ''),
(56, 'el resguardo', '', ''),
(57, 'el rincon', '', ''),
(58, 'el rubí', '', ''),
(59, 'el salitre', '', ''),
(60, 'el solar', '', ''),
(61, 'el tesoro', '', ''),
(62, 'el triunfo I y II', '', ''),
(63, 'escuela de carabineros', '', ''),
(64, 'estoril', '', ''),
(65, 'floresta norte', '', ''),
(66, 'gilmar', '', ''),
(67, 'gloria lara de echeverry', '', ''),
(68, 'granada norte', '', ''),
(69, 'hacienda casa blanca', '', ''),
(70, 'hacienda córdoba', '', ''),
(71, 'hacienda el cortijo', '', ''),
(72, 'iberia', '', ''),
(73, 'ilarco', '', ''),
(74, 'inmaculada concepción', '', ''),
(75, 'java I', '', ''),
(76, 'java II', '', ''),
(77, 'julio flores', '', ''),
(78, 'la alborada', '', ''),
(79, 'la aurora', '', ''),
(80, 'la campiña', '', ''),
(81, 'la carolina', '', ''),
(82, 'la chucua norte IyII', '', ''),
(83, 'la conejera', '', ''),
(84, 'la esperanza', '', ''),
(85, 'la estanzuela', '', ''),
(86, 'la floresta', '', ''),
(87, 'la floresta', '', ''),
(88, 'la gran britalia', '', ''),
(89, 'la manuelita', '', ''),
(90, 'la palma nueva', '', ''),
(91, 'la pampa', '', ''),
(92, 'la pradera suba', '', ''),
(93, 'la victoria norte', '', ''),
(94, 'las flores', '', ''),
(95, 'las flores norte', '', ''),
(96, 'las terrazas', '', ''),
(97, 'las villas', '', ''),
(98, 'las villas', '', ''),
(99, 'los alcaparros de suba', '', ''),
(100, 'los duraznos', '', ''),
(101, 'los lagartos', '', ''),
(102, 'los naranjos', '', ''),
(103, 'los naranjos', '', ''),
(104, 'los sauces', '', ''),
(105, 'malibú', '', ''),
(106, 'margaritas', '', ''),
(107, 'martinei', '', ''),
(108, 'mazuren', '', ''),
(109, 'miraflores', '', ''),
(110, 'mirandelo', '', ''),
(111, 'mónaco', '', ''),
(112, 'mónaco el rubí', '', ''),
(113, 'morato', '', ''),
(114, 'morato', '', ''),
(115, 'navetas', '', ''),
(116, 'niza', '', ''),
(117, 'niza 9', '', ''),
(118, 'niza norte', '', ''),
(119, 'niza sur', '', ''),
(120, 'noroccidental', '', ''),
(121, 'nueva britalia', '', ''),
(122, 'nueva britalia', '', ''),
(123, 'nueva tibabuyes', '', ''),
(124, 'nueva zelandia norte', '', ''),
(125, 'nueva zelandia sur', '', ''),
(126, 'nuevo monterrey', '', ''),
(127, 'nuevo rey', '', ''),
(128, 'palmas II', '', ''),
(129, 'pasadena', '', ''),
(130, 'pijao de oro', '', ''),
(131, 'pinares', '', ''),
(132, 'pontevedra', '', ''),
(133, 'potosí', '', ''),
(134, 'pradera de suba', '', ''),
(135, 'prado jardín', '', ''),
(136, 'prado norte', '', ''),
(137, 'prado pizon', '', ''),
(138, 'prado sur', '', ''),
(139, 'prado veraniego', '', ''),
(140, 'puente largo', '', ''),
(141, 'rincon de las villas ', '', ''),
(142, 'rincon de suba', '', ''),
(143, 'rincón de suba', '', ''),
(144, 'rio manso', '', ''),
(145, 'san alfonso', '', ''),
(146, 'san cipriano ', '', ''),
(147, 'san felipe ', '', ''),
(148, 'san fernando', '', ''),
(149, 'san jorge', '', ''),
(150, 'san jorge', '', ''),
(151, 'san josé bavaria', '', ''),
(152, 'san jose spring', '', ''),
(153, 'san lorenzo de escorial', '', ''),
(154, 'san nicolas', '', ''),
(155, 'san pedro', '', ''),
(156, 'san roque', '', ''),
(157, 'san vicente', '', ''),
(158, 'santa ana', '', ''),
(159, 'santa bárbara', '', ''),
(160, 'santa catalina', '', ''),
(161, 'santa helena', '', ''),
(162, 'santa margarita', '', ''),
(163, 'santa rosa', '', ''),
(164, 'santiago bis', '', ''),
(165, 'spring', '', ''),
(166, 'suba', '', ''),
(167, 'tercer puente', '', ''),
(168, 'teusacá ', '', ''),
(169, 'tibabuyes', '', ''),
(170, 'tibabuyes universal', '', ''),
(171, 'tierra linda', '', ''),
(172, 'tuna alta', '', ''),
(173, 'tuna baja', '', ''),
(174, 'urbanización el poa', '', ''),
(175, 'villa campestre', '', ''),
(176, 'villa catalina', '', ''),
(177, 'villa del prado', '', ''),
(178, 'villa elisa', '', ''),
(179, 'villa lucía', '', ''),
(180, 'villa manzur', '', ''),
(181, 'villa maría', '', ''),
(182, 'villa moreno', '', ''),
(183, 'villa susana', '', ''),
(184, 'villa vista', '', ''),
(185, '11 de noviembre', '', ''),
(186, '12 de octubre', '', ''),
(187, '7 de agosto', '', ''),
(188, 'alcazares norte', '', ''),
(189, 'baquero', '', ''),
(190, 'benjamin herrera', '', ''),
(191, 'cafam', '', ''),
(192, 'colombia', '', ''),
(193, 'el rosario', '', ''),
(194, 'entre rios', '', ''),
(195, 'gaitan', '', ''),
(196, 'jorge eliecer gaitan', '', ''),
(197, 'jose j. Vargas', '', ''),
(198, 'juan XXIII', '', ''),
(199, 'la aurora', '', ''),
(200, 'la castellana', '', ''),
(201, 'la concepcion', '', ''),
(202, 'la esperanza', '', ''),
(203, 'la libertad', '', ''),
(204, 'la merced norte', '', ''),
(205, 'la paz', '', ''),
(206, 'los alcazares', '', ''),
(207, 'los andes', '', ''),
(208, 'mendiguaca', '', ''),
(209, 'metropolis', '', ''),
(210, 'modelo', '', ''),
(211, 'muequeta', '', ''),
(212, 'patria', '', ''),
(213, 'polo club', '', ''),
(214, 'popular', '', ''),
(215, 'quinta mutis', '', ''),
(216, 'rafael uribe uribe', '', ''),
(217, 'rincon de los andes', '', ''),
(218, 'rincon del salitre', '', ''),
(219, 'rionegro', '', ''),
(220, 'san felipe', '', ''),
(221, 'san fernando', '', ''),
(222, 'san fernando', '', ''),
(223, 'san martin', '', ''),
(224, 'san miguel', '', ''),
(225, 'santa sofia', '', ''),
(226, 'simon bolivar', '', ''),
(227, 'viscaya', '', ''),
(228, 'acevedo tejada', '', ''),
(229, 'alfonso lopez', '', ''),
(230, 'armenia', '', ''),
(231, 'belalcazar', '', ''),
(232, 'can', '', ''),
(233, 'centro nariño', '', ''),
(234, 'chapinero sur occidental', '', ''),
(235, 'ciudad universitaria', '', ''),
(236, 'conjunto residencial el greco', '', ''),
(237, 'corferias', '', ''),
(238, 'el campin', '', ''),
(239, 'el divino salvador', '', ''),
(240, 'el quirinal', '', ''),
(241, 'el recuerdo', '', ''),
(242, 'el salitre', '', ''),
(243, 'el tejada', '', ''),
(244, 'fundar', '', ''),
(245, 'gran america', '', ''),
(246, 'la esmeralda', '', ''),
(247, 'la estrella', '', ''),
(248, 'la magdalena', '', ''),
(249, 'la soledad', '', ''),
(250, 'la soledad', '', ''),
(251, 'las americas', '', ''),
(252, 'nicolas de federman', '', ''),
(253, 'nuevo campin', '', ''),
(254, 'pablo VI', '', ''),
(255, 'pablo VI-II', '', ''),
(256, 'palermo quesada', '', ''),
(257, 'palermo quesada', '', ''),
(258, 'quinta paredes', '', ''),
(259, 'rafael nuñez', '', ''),
(260, 'san luis', '', ''),
(261, 'santa teresita', '', ''),
(262, 'sears(galerias)', '', ''),
(263, 'templete eucaristico', '', ''),
(264, 'teusaquillo', '', ''),
(265, 'colseguros', '', ''),
(266, 'eduardo santos', '', ''),
(267, 'el liston', '', ''),
(268, 'el progreso', '', ''),
(269, 'el vergel', '', ''),
(270, 'la estanzuela', '', ''),
(271, 'la favorita', '', ''),
(272, 'la florida', '', ''),
(273, 'la pepita', '', ''),
(274, 'la sabana', '', ''),
(275, 'paloquemao', '', ''),
(276, 'panamericano', '', ''),
(277, 'ricaurte', '', ''),
(278, 'samper mendoza', '', ''),
(279, 'san fason', '', ''),
(280, 'san victorino', '', ''),
(281, 'santa isabel', '', ''),
(282, 'santa isabel sur', '', ''),
(283, 'santafe ', '', ''),
(284, 'usatama', '', ''),
(285, 'veraguas', '', ''),
(286, 'voto nacional', '', ''),
(287, 'caracas', '', ''),
(288, 'ciudad berna', '', ''),
(289, 'ciudad jardin', '', ''),
(290, 'eduardo frei', '', ''),
(291, 'la fragua', '', ''),
(292, 'la fraguita', '', ''),
(293, 'luna park', '', ''),
(294, 'policarpa', '', ''),
(295, 'restrepo a', '', ''),
(296, 'restrepo b', '', ''),
(297, 'san antonio', '', ''),
(298, 'san jorge central', '', ''),
(299, 'santa catalina', '', ''),
(300, 'santader sur', '', ''),
(301, 'sena', '', ''),
(302, 'sevilla', '', ''),
(303, 'villa mayor', '', '');

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

-- 
-- Estructura de tabla para la tabla `Ciudad`
-- 

CREATE TABLE `Ciudad` (
  `No` int(5) NOT NULL,
  `Ciudad` varchar(35) NOT NULL,
  `Depto` varchar(35) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Ciudad`
-- 

INSERT INTO `Ciudad` (`No`, `Ciudad`, `Depto`) VALUES (1, 'Bogotá', 'Cundinamaraca'),
(2, 'Municipios', 'Cundinamaraca');

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

-- 
-- Estructura de tabla para la tabla `CiudadC`
-- 

CREATE TABLE `CiudadC` (
  `No` int(5) NOT NULL,
  `Ciudad` varchar(35) NOT NULL,
  `Depto` varchar(35) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `CiudadC`
-- 

INSERT INTO `CiudadC` (`No`, `Ciudad`, `Depto`) VALUES (1, 'Bogotá', 'Distrito Capital'),
(2, 'Medellín', 'Antioquia'),
(3, 'Cali', 'Valle del Cauca'),
(4, 'Barranquilla', 'Atlántico'),
(5, 'Cartagena', 'Bolívar'),
(6, 'Cúcuta', 'Norte de Santander'),
(7, 'Bucaramanga', 'Santander'),
(8, 'Soledad', 'Atlántico'),
(9, 'Ibagué', 'Tolima'),
(10, 'Pereira', 'Risaralda'),
(11, 'Santa Marta', 'Magdalena'),
(12, 'Soacha', 'Cundinamarca'),
(13, 'San Juan de Pasto', 'Nariño'),
(14, 'Montería', 'Córdoba'),
(15, 'Villavicencio', 'Meta'),
(16, 'Manizales', 'Caldas'),
(17, 'Bello', 'Antioquia'),
(18, 'Valledupar', 'Cesar'),
(19, 'Neiva', 'Huila'),
(20, 'Buenaventura', 'Valle del Cauca'),
(21, 'Palmira', 'Valle del Cauca'),
(22, 'Armenia', 'Quindío'),
(23, 'Popayán', 'Cauca'),
(24, 'Floridablanca', 'Santander'),
(25, 'Sincelejo', 'Sucre'),
(26, 'Itagüí', 'Antioquia'),
(27, 'Ocaña', 'Norte de Santander'),
(28, 'Tuluá', 'Valle del Cauca'),
(29, 'Barrancabermeja', 'Santander'),
(30, 'Dosquebradas', 'Risaralda'),
(31, 'Envigado', 'Antioquia'),
(32, 'Riohacha', 'La Guajira'),
(33, 'Cartago', 'Valle del Cauca'),
(34, 'Guadalajara de Buga', 'Valle del Cauca'),
(35, 'Tunja', 'Boyacá'),
(36, 'Florencia', 'Caquetá'),
(37, 'Villa del Rosario', 'Norte de Santander'),
(38, 'Apartadó', 'Antioquia'),
(39, 'Tumaco', 'Nariño'),
(40, 'Maicao', 'La Guajira'),
(41, 'Turbo', 'Antioquia'),
(42, 'Magangué', 'Bolívar'),
(43, 'Uribia', 'La Guajira'),
(44, 'Piedecuesta', 'Santander'),
(45, 'Sogamoso', 'Boyacá'),
(46, 'Quibdó', 'Chocó'),
(47, 'Santa Cruz de Lorica', 'Córdoba'),
(48, 'Ipiales', 'Nariño'),
(49, 'Fusagasugá', 'Cundinamarca'),
(50, 'Facatativá', 'Cundinamarca'),
(51, 'Duitama', 'Boyacá'),
(52, 'Yopal', 'Casanare'),
(53, 'Pitalito', 'Huila'),
(54, 'Ciénaga', 'Magdalena'),
(55, 'Zipaquirá', 'Cundinamarca'),
(56, 'Malambo', 'Atlántico'),
(57, 'Rionegro', 'Antioquia'),
(58, 'Chía', 'Cundinamarca'),
(59, 'Girardot', 'Cundinamarca'),
(60, 'Jamundí', 'Valle del Cauca'),
(61, 'Yumbo', 'Valle del Cauca'),
(62, 'Sahagún', 'Córdoba'),
(63, 'Caucasia', 'Antioquia'),
(64, 'Sabanalarga', 'Atlántico'),
(65, 'Cereté', 'Córdoba'),
(66, 'Aguachica', 'Cesar'),
(67, 'Santander de Quilichao', 'Cauca'),
(68, 'Tierralta', 'Córdoba'),
(69, 'Espinal', 'Tolima'),
(70, 'Arauca', 'Arauca'),
(71, 'Calarcá', 'Quindío'),
(72, 'Montelíbano', 'Córdoba'),
(73, 'La Dorada', 'Caldas'),
(74, 'Candelaria', 'Valle del Cauca'),
(75, 'Santa Rosa de Cabal', 'Risaralda'),
(76, 'San Juan Girón', 'Santander (Colombia)'),
(77, 'Garzón', 'Huila'),
(78, 'Caldas', 'Antioquia'),
(79, 'Carmen de Bolívar', 'Bolívar'),
(80, 'Manaure', 'La Guajira'),
(81, 'Los Patios', 'Norte de Santander'),
(82, 'San Andrés', 'Archipiélago de San Andrés'),
(83, 'Mosquera', 'Cundinamarca'),
(84, 'San Andrés de Sotavento', 'Córdoba'),
(85, 'Turbaco', 'Bolívar'),
(86, 'Madrid', 'Cundinamarca'),
(87, 'Planeta Rica', 'Córdoba'),
(88, 'Funza', 'Cundinamarca'),
(89, 'Copacabana', 'Antioquia'),
(90, 'Arjona', 'Bolívar'),
(91, 'Chigorodó', 'Antioquia'),
(92, 'Corozal', 'Sucre'),
(93, 'Zona Bananera', 'Magdalena'),
(94, 'Fundación', 'Magdalena'),
(95, 'San Vicente del Caguán', 'Caquetá'),
(96, 'Florida', 'Valle del Cauca'),
(97, 'Chiquinquirá', 'Boyacá'),
(98, 'Puerto Asís', 'Putumayo'),
(99, 'El Banco', 'Magdalena'),
(100, 'El Cerrito', 'Valle del Cauca'),
(101, 'Riosucio', 'Caldas'),
(102, 'Acacías', 'Meta'),
(103, 'San José del Guaviare', 'Guaviare'),
(104, 'Agustín Codazzi', 'Cesar'),
(105, 'Chinchiná', 'Caldas'),
(106, 'Pamplona', 'Norte de Santander'),
(107, 'Ciénaga de Oro', 'Córdoba'),
(108, 'La Estrella', 'Antioquia'),
(109, 'La Plata', 'Huila'),
(110, 'Baranoa', 'Atlántico'),
(111, 'San Marcos', 'Sucre'),
(112, 'Samaniego', 'Nariño'),
(113, 'Puerto Boyacá', 'Boyacá'),
(114, 'Granada', 'Meta'),
(115, 'Plato', 'Magdalena'),
(116, 'Pradera', 'Valle del Cauca'),
(117, 'Necoclí', 'Antioquia'),
(118, 'Sevilla', 'Valle del Cauca'),
(119, 'Tame', 'Arauca'),
(120, 'Chaparral', 'Tolima'),
(121, 'San Onofre', 'Sucre'),
(122, 'Villamaría', 'Caldas'),
(123, 'La Ceja', 'Antioquia'),
(124, 'El Bagre', 'Antioquia'),
(125, 'El Tambo', 'Cauca'),
(126, 'Marinilla', 'Antioquia'),
(127, 'María La Baja', 'Bolívar'),
(128, 'Cajicá', 'Cundinamarca'),
(129, 'Valle del Guamuez', 'Putumayo'),
(130, 'Sabaneta', 'Antioquia'),
(131, 'Puerto Tejada', 'Cauca'),
(132, 'Bolívar', 'Cauca'),
(133, 'Orito', 'Putumayo'),
(134, 'San Gil', 'Santander'),
(135, 'Chinú', 'Córdoba'),
(136, 'Carepa', 'Antioquia'),
(137, 'Saravena', 'Arauca'),
(138, 'Girardota', 'Antioquia'),
(139, 'Ayapel', 'Córdoba'),
(140, 'Barbosa', 'Antioquia'),
(141, 'Líbano', 'Tolima'),
(142, 'Andes', 'Antioquia'),
(143, 'Santa Cruz de Mompox', 'Bolívar'),
(144, 'Túquerres', 'Nariño'),
(145, 'Yarumal', 'Antioquia'),
(146, 'El Carmen de Viboral', 'Antioquia'),
(147, 'Zarzal', 'Valle del Cauca'),
(148, 'Montenegro', 'Quindío'),
(149, 'Guarne', 'Antioquia'),
(150, 'San Pelayo', 'Córdoba'),
(151, 'Puerto Berrío', 'Antioquia'),
(152, 'Urrao', 'Antioquia'),
(153, 'Sonsón', 'Antioquia'),
(154, 'La Vega', 'Cauca'),
(155, 'Leticia', 'Amazonas'),
(156, 'Caloto', 'Cauca'),
(157, 'Arauquita', 'Arauca'),
(158, 'Sampués', 'Sucre'),
(159, 'Ubaté', 'Cundinamarca'),
(160, 'Pivijay', 'Magdalena'),
(161, 'Piendamó', 'Cauca'),
(162, 'Mocoa', 'Putumayo'),
(163, 'Aracataca', 'Magdalena'),
(164, 'Dagua', 'Valle del Cauca'),
(165, 'Puerto Libertador', 'Córdoba'),
(166, 'Anserma', 'Caldas'),
(167, 'Segovia', 'Antioquia'),
(168, 'Guamo', 'Tolima'),
(169, 'Tibú', 'Norte de Santander'),
(170, 'Cajibío', 'Cauca'),
(171, 'Roldanillo', 'Valle del Cauca'),
(172, 'Abrego', 'Norte de Santander'),
(173, 'Valencia', 'Córdoba'),
(174, 'Cimitarra', 'Santander'),
(175, 'Quimbaya', 'Quindío'),
(176, 'Santa Rosa del Sur', 'Bolívar'),
(177, 'Ortega', 'Tolima'),
(178, 'San Juan del Cesar', 'La Guajira'),
(179, 'La Tebaida', 'Quindío'),
(180, 'Quinchía', 'Risaralda'),
(181, 'San Vicente de Chucurí', 'Santander'),
(182, 'Miranda', 'Cauca'),
(183, 'Patía', 'Cauca'),
(184, 'Tarazá', 'Antioquia'),
(185, 'Mariquita', 'Tolima'),
(186, 'Melgar', 'Tolima'),
(187, 'San Juan Nepomuceno', 'Bolívar'),
(188, 'Puerto Rico', 'Caquetá'),
(189, 'Campoalegre', 'Huila'),
(190, 'Galapa', 'Atlántico'),
(191, 'Guaduas', 'Cundinamarca'),
(192, 'Guacarí', 'Valle del Cauca'),
(193, 'Páez', 'Cauca'),
(194, 'La Unión', 'Valle del Cauca'),
(195, 'Sibaté', 'Cundinamarca'),
(196, 'Majagual', 'Sucre'),
(197, 'Pueblo Nuevo', 'Córdoba'),
(198, 'Puerto Wilches', 'Santander'),
(199, 'San Bernardo del Viento', 'Córdoba'),
(200, 'Fresno', 'Tolima'),
(201, 'La Virginia', 'Risaralda'),
(202, 'Ariguaní', 'Magdalena'),
(203, 'Santa Rosa de Osos', 'Antioquia'),
(204, 'Cumbal', 'Nariño'),
(205, 'Chimichagua', 'Cesar'),
(206, 'Lebrija', 'Santander'),
(207, 'Silvia', 'Cauca'),
(208, 'Caicedonia', 'Valle del Cauca'),
(209, 'Caldono', 'Cauca'),
(210, 'Bosconia', 'Cesar'),
(211, 'Arboletes', 'Antioquia'),
(212, 'San Luis de Sincé', 'Sucre'),
(213, 'Barbacoas', 'Nariño'),
(214, 'Timbío', 'Cauca'),
(215, 'San Agustín', 'Huila'),
(216, 'Planadas', 'Tolima'),
(217, 'Rionegro', 'Santander'),
(218, 'Socorro', 'Santander'),
(219, 'Alto Baudó', 'Chocó'),
(220, 'Cáceres', 'Antioquia'),
(221, 'Puerto López', 'Meta'),
(222, 'San Pedro de Urabá', 'Antioquia'),
(223, 'Cumaribo', 'Vichada'),
(224, 'Cartagena del Chairá', 'Caquetá'),
(225, 'Guapi', 'Cauca'),
(226, 'Mitú', 'Vaupés'),
(227, 'Aguazul', 'Casanare'),
(228, 'Corinto', 'Cauca'),
(229, 'Ciudad Bolívar', 'Antioquia'),
(230, 'Gigante', 'Huila'),
(231, 'Neira', 'Caldas'),
(232, 'Tolú', 'Sucre'),
(233, 'Coyaima', 'Tolima'),
(234, 'Flandes', 'Tolima'),
(235, 'La Unión', 'Nariño'),
(236, 'Purificación', 'Tolima'),
(237, 'Puerto Colombia', 'Atlántico'),
(238, 'Paipa', 'Boyacá'),
(239, 'Belén de Umbría', 'Risaralda'),
(240, 'Curumaní', 'Cesar'),
(241, 'Circasia', 'Quindío'),
(242, 'Olaya Herrera', 'Nariño'),
(243, 'Honda', 'Tolima'),
(244, 'Palermo', 'Huila'),
(245, 'La Mesa', 'Cundinamarca'),
(246, 'Amagá', 'Antioquia'),
(247, 'Paz de Ariporo', 'Casanare'),
(248, 'San Pablo', 'Bolívar'),
(249, 'Inzá', 'Cauca'),
(250, 'Buenos Aires', 'Cauca'),
(251, 'Zaragoza', 'Antioquia'),
(252, 'Sitionuevo', 'Magdalena'),
(253, 'Fonseca', 'La Guajira'),
(254, 'Toribio', 'Cauca'),
(255, 'Pensilvania', 'Caldas'),
(256, 'Acevedo', 'Huila'),
(257, 'Barrancas', 'La Guajira'),
(258, 'El Santuario', 'Antioquia'),
(259, 'San Antero', 'Córdoba'),
(260, 'Barbosa', 'Santander'),
(261, 'El Charco', 'Nariño'),
(262, 'Samaná', 'Caldas'),
(263, 'Rioblanco', 'Tolima'),
(264, 'Guamal', 'Magdalena'),
(265, 'Pacho', 'Cundinamarca'),
(266, 'Sabanagrande', 'Atlántico'),
(267, 'Sandoná', 'Nariño'),
(268, 'Manzanares', 'Caldas'),
(269, 'Ituango', 'Antioquia'),
(270, 'Puebloviejo', 'Magdalena'),
(271, 'El Copey', 'Cesar'),
(272, 'Supía', 'Caldas'),
(273, 'Argelia', 'Cauca'),
(274, 'Morales', 'Cauca'),
(275, 'Villeta', 'Cundinamarca'),
(276, 'Aguadas', 'Caldas'),
(277, 'La Macarena', 'Meta'),
(278, 'Tocancipá', 'Cundinamarca'),
(279, 'Dabeiba', 'Antioquia'),
(280, 'Santo Tomás', 'Atlántico'),
(281, 'La Calera', 'Cundinamarca'),
(282, 'Isnos', 'Huila'),
(283, 'Palmar de Varela', 'Atlántico'),
(284, 'Istmina', 'Chocó'),
(285, 'San Carlos', 'Córdoba'),
(286, 'Balboa', 'Cauca'),
(287, 'Moñitos', 'Córdoba'),
(288, 'Santa Bárbara', 'Antioquia'),
(289, 'Luruaco', 'Atlántico'),
(290, 'Villanueva', 'La Guajira'),
(291, 'Algeciras', 'Huila'),
(292, 'Santa Ana', 'Magdalena'),
(293, 'Natagaima', 'Tolima'),
(294, 'San Benito Abad', 'Sucre'),
(295, 'Mahates', 'Bolívar'),
(296, 'Santa Fe de Antioquia', 'Antioquia'),
(297, 'Repelón', 'Atlántico'),
(298, 'Pinillos', 'Bolívar'),
(299, 'Remedios', 'Antioquia'),
(300, 'Sardinata', 'Norte de Santander'),
(301, 'Fredonia', 'Antioquia'),
(302, 'Puerto Guzmán', 'Putumayo'),
(303, 'Sucre', 'Sucre'),
(304, 'Buesaco', 'Nariño'),
(305, 'La Montañita', 'Caquetá'),
(306, 'Chiriguaná', 'Cesar'),
(307, 'La Jagua de Ibirico', 'Cesar'),
(308, 'San Pedro', 'Antioquia'),
(309, 'Ataco', 'Tolima'),
(310, 'La Paz', 'Cesar'),
(311, 'Moniquirá', 'Boyacá'),
(312, 'Fortul', 'Arauca'),
(313, 'San Miguel', 'Putumayo'),
(314, 'Villanueva', 'Casanare'),
(315, 'Dibulla', 'La Guajira'),
(316, 'Puerto Escondido', 'Córdoba'),
(317, 'Rovira', 'Tolima'),
(318, 'Ovejas', 'Sucre'),
(319, 'Bugalagrande', 'Valle del Cauca'),
(320, 'San Jacinto', 'Bolívar'),
(321, 'El Doncello', 'Caquetá'),
(322, 'Marsella', 'Risaralda'),
(323, 'Concordia', 'Antioquia'),
(324, 'Silvania', 'Cundinamarca'),
(325, 'San Martín', 'Meta'),
(326, 'Sopó', 'Cundinamarca'),
(327, 'Río Viejo', 'Bolívar'),
(328, 'Vista Hermosa', 'Meta'),
(329, 'Medio Atrato', 'Chocó'),
(330, 'San Juan de Urabá', 'Antioquia'),
(331, 'Timbiquí', 'Cauca'),
(332, 'Tabio', 'Cundinamarca'),
(333, 'Albania', 'La Guajira'),
(334, 'El Paso', 'Cesar'),
(335, 'Villagarzón', 'Putumayo'),
(336, 'Calamar', 'Bolívar'),
(337, 'Ansermanuevo', 'Valle del Cauca'),
(338, 'Santacruz', 'Nariño'),
(339, 'Nechí', 'Antioquia'),
(340, 'Amalfi', 'Antioquia'),
(341, 'Almaguer', 'Cauca'),
(342, 'El Colegio', 'Cundinamarca'),
(343, 'El Zulia', 'Norte de Santander'),
(344, 'Salamina', 'Caldas'),
(345, 'Abejorral', 'Antioquia'),
(346, 'Frontino', 'Antioquia'),
(347, 'Yolombó', 'Antioquia'),
(348, 'Timaná', 'Huila'),
(349, 'San Alberto', 'Cesar'),
(350, 'Cota', 'Cundinamarca'),
(351, 'Cajamarca', 'Tolima'),
(352, 'Aipe', 'Huila'),
(353, 'Sabana de Torres', 'Santander'),
(354, 'Vélez', 'Santander'),
(355, 'Achí', 'Bolívar'),
(356, 'Chocontá', 'Cundinamarca'),
(357, 'Lérida', 'Tolima'),
(358, 'San Vicente', 'Antioquia'),
(359, 'Solano', 'Caquetá'),
(360, 'López', 'Cauca'),
(361, 'Los Palmitos', 'Sucre'),
(362, 'Albán', 'Nariño'),
(363, 'Ginebra', 'Valle del Cauca'),
(364, 'San Luis', 'Tolima'),
(365, 'Suárez', 'Cauca'),
(366, 'Campo de La Cruz', 'Atlántico'),
(367, 'El Retorno', 'Guaviare'),
(368, 'Buenavista', 'Córdoba'),
(369, 'Tolú Viejo', 'Sucre'),
(370, 'Ponedera', 'Atlántico'),
(371, 'El Retén', 'Magdalena'),
(372, 'Tiquisio', 'Bolívar'),
(373, 'Venadillo', 'Tolima'),
(374, 'Málaga', 'Santander'),
(375, 'Trujillo', 'Valle del Cauca'),
(376, 'Morales', 'Bolívar'),
(377, 'Tenjo', 'Cundinamarca'),
(378, 'Simití', 'Bolívar'),
(379, 'Pupiales', 'Nariño'),
(380, 'San Lorenzo', 'Nariño'),
(381, 'Astrea', 'Cesar'),
(382, 'Cogua', 'Cundinamarca'),
(383, 'Salgar', 'Antioquia'),
(384, 'Santa Rosa', 'Bolívar'),
(385, 'San Roque', 'Antioquia'),
(386, 'Andalucía', 'Valle del Cauca'),
(387, 'San Pablo', 'Nariño'),
(388, 'El Carmen de Chucurí', 'Santander'),
(389, 'Tadó', 'Chocó'),
(390, 'Palestina', 'Caldas'),
(391, 'Inírida', 'Guainía'),
(392, 'La Unión', 'Antioquia'),
(393, 'Los Córdobas', 'Córdoba'),
(394, 'Mercaderes', 'Cauca'),
(395, 'Don Matías', 'Antioquia'),
(396, 'El Paujil', 'Caquetá'),
(397, 'La Cruz', 'Nariño'),
(398, 'Samacá', 'Boyacá'),
(399, 'Guadalupe', 'Huila'),
(400, 'Villanueva', 'Bolívar'),
(401, 'Alcalá', 'Valle del Cauca'),
(402, 'Teorama', 'Norte de Santander'),
(403, 'Apía', 'Risaralda'),
(404, 'Totoró', 'Cauca'),
(405, 'Riofrío', 'Valle del Cauca'),
(406, 'Puerto Rico', 'Meta'),
(407, 'Canalete', 'Córdoba'),
(408, 'San Martín', 'Cesar'),
(409, 'Puerto Gaitán', 'Meta'),
(410, 'Galeras', 'Sucre'),
(411, 'Valdivia', 'Antioquia'),
(412, 'Toledo', 'Norte de Santander'),
(413, 'San Sebastián de Buenavista', 'Magdalena'),
(414, 'Pueblo Bello', 'Cesar'),
(415, 'Taminango', 'Nariño'),
(416, 'Tocaima', 'Cundinamarca'),
(417, 'El Piñon', 'Magdalena'),
(418, 'Retiro', 'Antioquia'),
(419, 'Montecristo', 'Bolívar'),
(420, 'Roberto Payán', 'Nariño'),
(421, 'Guachucal', 'Nariño'),
(422, 'Cañasgordas', 'Antioquia'),
(423, 'Betulia', 'Antioquia'),
(424, 'Puerto Nare', 'Antioquia'),
(425, 'Rivera', 'Huila'),
(426, 'Convención', 'Norte de Santander'),
(427, 'Aquitania', 'Boyacá'),
(428, 'Cumaral', 'Meta'),
(429, 'Villapinzón', 'Cundinamarca'),
(430, 'Pelaya', 'Cesar'),
(431, 'Garagoa', 'Boyacá'),
(432, 'Caparrapí', 'Cundinamarca'),
(433, 'Chibolo', 'Magdalena'),
(434, 'Caqueza', 'Cundinamarca'),
(435, 'Mutatá1', 'Antioquia'),
(436, 'Anzoátegui', 'Tolima'),
(437, 'San Pedro', 'Sucre'),
(438, 'Yacopí', 'Cundinamarca'),
(439, 'Magüi', 'Nariño'),
(440, 'Támesis', 'Antioquia'),
(441, 'Hatonuevo', 'La Guajira'),
(442, 'El Carmen', 'Norte de Santander'),
(443, 'Bajo Baudó', 'Chocó'),
(444, 'Los Andes', 'Nariño'),
(445, 'Puerto Triunfo', 'Antioquia'),
(446, 'Peñol', 'Antioquia'),
(447, 'Tauramena', 'Casanare'),
(448, 'Nueva Granada', 'Magdalena'),
(449, 'Leguízamo', 'Putumayo'),
(450, 'Puerto Concordia', 'Meta'),
(451, 'Tarqui', 'Huila'),
(452, 'Toro', 'Valle del Cauca'),
(453, 'Pailitas', 'Cesar'),
(454, 'San Carlos', 'Antioquia'),
(455, 'Restrepo', 'Valle del Cauca'),
(456, 'San Pedro', 'Valle del Cauca'),
(457, 'Guática', 'Risaralda'),
(458, 'Sotara', 'Cauca'),
(459, 'Nariño', 'Antioquia'),
(460, 'Yotoco', 'Valle del Cauca'),
(461, 'Puerto Salgar', 'Cundinamarca'),
(462, 'Guaranda', 'Sucre'),
(463, 'Calima', 'Valle del Cauca'),
(464, 'Santuario', 'Risaralda'),
(465, 'Arenal', 'Bolívar'),
(466, 'Bolívar', 'Valle del Cauca'),
(467, 'Santa Bárbara', 'Nariño'),
(468, 'San Antonio', 'Tolima'),
(469, 'San Estanislao', 'Bolívar'),
(470, 'Pácora', 'Caldas'),
(471, 'Nobsa', 'Boyacá'),
(472, 'Landázuri', 'Santander'),
(473, 'Mistrató', 'Risaralda'),
(474, 'Barranco de Loba', 'Bolívar'),
(475, 'Cocorná', 'Antioquia'),
(476, 'Cotorra', 'Córdoba'),
(477, 'Yondó', 'Antioquia'),
(478, 'Anorí', 'Antioquia'),
(479, 'Saldaña', 'Tolima'),
(480, 'Puracé', 'Cauca'),
(481, 'Ricaurte', 'Nariño'),
(482, 'Sabanas de San Angel', 'Magdalena'),
(483, 'Marquetalia', 'Caldas'),
(484, 'Chinácota', 'Norte de Santander'),
(485, 'Purísima', 'Córdoba'),
(486, 'Jambaló', 'Cauca'),
(487, 'La Gloria', 'Cesar'),
(488, 'Juan de Acosta', 'Atlántico'),
(489, 'Unguía', 'Chocó'),
(490, 'Puente Nacional', 'Santander'),
(491, 'Gamarra', 'Cesar'),
(492, 'Jardín', 'Antioquia'),
(493, 'Río de Oro', 'Cesar'),
(494, 'Ventaquemada', 'Boyacá'),
(495, 'Obando', 'Valle del Cauca'),
(496, 'Suaza', 'Huila'),
(497, 'Villa Rica', 'Cauca'),
(498, 'Riosucio1', 'Chocó'),
(499, 'San Bernardo', 'Nariño'),
(500, 'San Martín de Loba', 'Bolívar'),
(501, 'Suesca', 'Cundinamarca'),
(502, 'Puerto Caicedo', 'Putumayo'),
(503, 'Nilo', 'Cundinamarca'),
(504, 'El Tambo', 'Nariño'),
(505, 'La Victoria', 'Valle del Cauca'),
(506, 'Pijiño del Carmen', 'Magdalena'),
(507, 'Momil', 'Córdoba'),
(508, 'Tamalameque', 'Cesar'),
(509, 'Bolívar', 'Santander'),
(510, 'El Tablón de Gómez', 'Nariño'),
(511, 'Becerril', 'Cesar'),
(512, 'Belén de Bajirá', 'Chocó[1] [2]'),
(513, 'Polonuevo', 'Atlántico'),
(514, 'San José del Fragua', 'Caquetá'),
(515, 'Manatí', 'Atlántico'),
(516, 'Policarpa', 'Nariño'),
(517, 'San Diego', 'Cesar'),
(518, 'Guaitarilla', 'Nariño'),
(519, 'Chimá', 'Córdoba'),
(520, 'Viotá', 'Cundinamarca'),
(521, 'Tello', 'Huila'),
(522, 'San Rafael', 'Antioquia'),
(523, 'El Rosal', 'Cundinamarca'),
(524, 'Córdoba', 'Nariño'),
(525, 'Turbaná', 'Bolívar'),
(526, 'Venecia', 'Antioquia'),
(527, 'Sopetrán', 'Antioquia'),
(528, 'Urumita', 'La Guajira'),
(529, 'Titiribí', 'Antioquia'),
(530, 'Anolaima', 'Cundinamarca'),
(531, 'Puerto Carreño', 'Vichada'),
(532, 'Sibundoy', 'Putumayo'),
(533, 'La Vega', 'Cundinamarca'),
(534, 'Santa Rosa de Viterbo', 'Boyacá'),
(535, 'Mapiripán', 'Meta'),
(536, 'Viterbo', 'Caldas'),
(537, 'Potosí', 'Nariño'),
(538, 'El Playón', 'Santander'),
(539, 'Córdoba', 'Bolívar'),
(540, 'Condoto', 'Chocó'),
(541, 'Armero', 'Tolima'),
(542, 'Subachoque', 'Cundinamarca'),
(543, 'Medio San Juan', 'Chocó'),
(544, 'Cómbita', 'Boyacá'),
(545, 'San Fernando', 'Bolívar'),
(546, 'Saboyá', 'Boyacá'),
(547, 'Filandia', 'Quindío'),
(548, 'Morroa', 'Sucre'),
(549, 'El Pital', 'Huila'),
(550, 'San Sebastián', 'Cauca'),
(551, 'Aranzazu', 'Caldas'),
(552, 'Chachagüí', 'Nariño'),
(553, 'Jericó', 'Antioquia'),
(554, 'Monterrey', 'Casanare'),
(555, 'Filadelfia', 'Caldas'),
(556, 'La Apartada', 'Córdoba'),
(557, 'Rosas', 'Cauca'),
(558, 'Tibasosa', 'Boyacá'),
(559, 'San Calixto', 'Norte de Santander'),
(560, 'Tenerife', 'Magdalena'),
(561, 'Ráquira', 'Boyacá'),
(562, 'Angostura', 'Antioquia'),
(563, 'Ebéjico', 'Antioquia'),
(564, 'Uribe', 'Meta'),
(565, 'Guasca', 'Cundinamarca'),
(566, 'Santa Lucía', 'Atlántico'),
(567, 'San Juan de Betulia', 'Sucre'),
(568, 'San Antonio del Tequendama', 'Cundinamarca'),
(569, 'Litoral de San Juan', 'Chocó'),
(570, 'Fómeque', 'Cundinamarca'),
(571, 'Santa Catalina', 'Bolívar'),
(572, 'Candelaria', 'Atlántico'),
(573, 'Villa de Leyva', 'Boyacá'),
(574, 'Mosquera', 'Nariño'),
(575, 'Pueblo Rico', 'Risaralda'),
(576, 'Distracción', 'La Guajira'),
(577, 'Ubalá', 'Cundinamarca'),
(578, 'Belalcázar', 'Caldas'),
(579, 'Carmen del Atrato', 'Chocó'),
(580, 'Agua de Dios', 'Cundinamarca'),
(581, 'Linares', 'Nariño'),
(582, 'Arbeláez', 'Cundinamarca'),
(583, 'Leiva', 'Nariño'),
(584, 'Algarrobo', 'Magdalena'),
(585, 'Medio Baudó', 'Chocó'),
(586, 'Clemencia', 'Bolívar'),
(587, 'Providencia', 'Nariño'),
(588, 'Icononzo', 'Tolima'),
(589, 'San Jerónimo', 'Antioquia'),
(590, 'La Argentina', 'Huila'),
(591, 'Santo Domingo', 'Antioquia'),
(592, 'Guachetá', 'Cundinamarca'),
(593, 'Anapoima', 'Cundinamarca'),
(594, 'Milán', 'Caquetá'),
(595, 'Trinidad', 'Casanare'),
(596, 'Hatillo de Loba', 'Bolívar'),
(597, 'Curití', 'Santander'),
(598, 'Cumbitara', 'Nariño'),
(599, 'La Florida', 'Nariño'),
(600, 'Charalá', 'Santander'),
(601, 'El Rosario', 'Nariño'),
(602, 'Palmito', 'Sucre'),
(603, 'Altos del Rosario', 'Bolívar'),
(604, 'Coveñas', 'Sucre'),
(605, 'Manaure', 'Cesar'),
(606, 'Miraflores', 'Guaviare'),
(607, 'Nemocón', 'Cundinamarca'),
(608, 'Vegachí', 'Antioquia'),
(609, 'Gómez Plata', 'Antioquia'),
(610, 'Villahermosa', 'Tolima'),
(611, 'Calamar', 'Guaviare'),
(612, 'Maní', 'Casanare'),
(613, 'Colombia', 'Huila'),
(614, 'Choachí', 'Cundinamarca'),
(615, 'Pasca', 'Cundinamarca'),
(616, 'La Cumbre', 'Valle del Cauca'),
(617, 'Curillo', 'Caquetá'),
(618, 'Zambrano', 'Bolívar'),
(619, 'Santa Bárbara de Pinto', 'Magdalena'),
(620, 'Valparaíso', 'Caquetá'),
(621, 'Cicuco', 'Bolívar'),
(622, 'Talaigua Nuevo', 'Bolívar'),
(623, 'Belén de Los Andaquies', 'Caquetá'),
(624, 'Fuente de oro', 'Meta'),
(625, 'Caimito', 'Sucre'),
(626, 'Francisco Pizarro', 'Nariño'),
(627, 'Simijaca', 'Cundinamarca'),
(628, 'San Luis', 'Antioquia'),
(629, 'Oiba', 'Santander'),
(630, 'Los Santos', 'Santander'),
(631, 'Suaita', 'Santander'),
(632, 'La Esperanza', 'Norte de Santander'),
(633, 'Mogotes', 'Santander'),
(634, 'La Sierra', 'Cauca'),
(635, 'San Jacinto del Cauca', 'Bolívar'),
(636, 'San Pablo de Borbur', 'Boyacá'),
(637, 'Tubará', 'Atlántico'),
(638, 'Tangua', 'Nariño'),
(639, 'Gachancipá', 'Cundinamarca'),
(640, 'Chita', 'Boyacá'),
(641, 'Ramiriquí', 'Boyacá'),
(642, 'Oporapa', 'Huila'),
(643, 'El Tarra', 'Norte de Santander'),
(644, 'Mesetas', 'Meta'),
(645, 'Cunday', 'Tolima'),
(646, 'El Águila', 'Valle del Cauca'),
(647, 'Risaralda', 'Caldas'),
(648, 'Puerto Lleras', 'Meta'),
(649, 'Iquira', 'Huila'),
(650, 'Cachirá', 'Norte de Santander'),
(651, 'La Primavera', 'Vichada'),
(652, 'Toca', 'Boyacá'),
(653, 'Otanche', 'Boyacá'),
(654, 'Acandí', 'Chocó'),
(655, 'Gachetá', 'Cundinamarca'),
(656, 'La Unión', 'Sucre'),
(657, 'Pauna', 'Boyacá'),
(658, 'San Bernardo', 'Cundinamarca'),
(659, 'Socotá', 'Boyacá'),
(660, 'Consaca', 'Nariño'),
(661, 'Palestina', 'Huila'),
(662, 'Lloró', 'Chocó'),
(663, 'Betania', 'Antioquia'),
(664, 'Concordia', 'Magdalena'),
(665, 'Muzo', 'Boyacá'),
(666, 'Saladoblanco', 'Huila'),
(667, 'Santa María', 'Huila'),
(668, 'Sasaima', 'Cundinamarca'),
(669, 'Chitagá', 'Norte de Santander'),
(670, 'Restrepo', 'Meta'),
(671, 'Guateque', 'Boyacá'),
(672, 'Hacarí', 'Norte de Santander'),
(673, 'Umbita', 'Boyacá'),
(674, 'Argelia', 'Antioquia'),
(675, 'Hato Corozal', 'Casanare'),
(676, 'Cachipay', 'Cundinamarca'),
(677, 'Yacuanquer', 'Nariño'),
(678, 'Bojaya', 'Chocó'),
(679, 'La Palma', 'Cundinamarca'),
(680, 'Medina', 'Cundinamarca'),
(681, 'Sesquilé', 'Cundinamarca'),
(682, 'San Juan de Río Seco', 'Cundinamarca'),
(683, 'Granada', 'Antioquia'),
(684, 'Vijes', 'Valle del Cauca'),
(685, 'San Andrés', 'Santander'),
(686, 'Susa', 'Cundinamarca'),
(687, 'Lenguazaque', 'Cundinamarca'),
(688, 'Pesca', 'Boyacá'),
(689, 'Tibaná', 'Boyacá'),
(690, 'Suan', 'Atlántico'),
(691, 'Campamento', 'Antioquia'),
(692, 'Cisneros', 'Antioquia'),
(693, 'Miraflores', 'Boyacá'),
(694, 'Colón', 'Nariño'),
(695, 'Génova', 'Quindío'),
(696, 'Peque', 'Antioquia'),
(697, 'Palocabildo', 'Tolima'),
(698, 'Santa Rosa', 'Cauca'),
(699, 'Lejanías', 'Meta'),
(700, 'El Dovio', 'Valle del Cauca'),
(701, 'Cértegui', 'Chocó'),
(702, 'Liborina', 'Antioquia'),
(703, 'Salazar', 'Norte de Santander'),
(704, 'Zapatoca', 'Santander'),
(705, 'El Roble', 'Sucre'),
(706, 'Margarita', 'Bolívar'),
(707, 'El Cairo', 'Valle del Cauca'),
(708, 'Soatá', 'Boyacá'),
(709, 'Mallama', 'Nariño'),
(710, 'Falan', 'Tolima'),
(711, 'Arboledas', 'Norte de Santander'),
(712, 'Sucre', 'Santander'),
(713, 'González', 'Cesar'),
(714, 'San Juan de Arama', 'Meta'),
(715, 'Santiago', 'Putumayo'),
(716, 'Baraya', 'Huila'),
(717, 'Victoria', 'Caldas'),
(718, 'Dolores', 'Tolima'),
(719, 'Herveo', 'Tolima'),
(720, 'Solita', 'Caquetá'),
(721, 'Bahía Solano', 'Chocó'),
(722, 'Belén', 'Boyacá'),
(723, 'Coello', 'Tolima'),
(724, 'Ancuyá', 'Nariño'),
(725, 'Tuta', 'Boyacá'),
(726, 'Puerres', 'Nariño'),
(727, 'Alvarado', 'Tolima'),
(728, 'Sotaquirá', 'Boyacá'),
(729, 'Buenavista', 'Sucre'),
(730, 'Sucre', 'Cauca'),
(731, 'Simacota', 'Santander'),
(732, 'San Zenón', 'Magdalena'),
(733, 'Guamal', 'Meta'),
(734, 'Siachoque', 'Boyacá'),
(735, 'Bojacá', 'Cundinamarca'),
(736, 'Tesalia', 'Huila'),
(737, 'Usiacurí', 'Atlántico'),
(738, 'Arroyohondo', 'Bolívar'),
(739, 'Regidor', 'Bolívar'),
(740, 'Boavita', 'Boyacá'),
(741, 'Quípama', 'Boyacá'),
(742, 'Briceño', 'Antioquia'),
(743, 'La Celia', 'Risaralda'),
(744, 'Prado', 'Tolima'),
(745, 'Remolino', 'Magdalena'),
(746, 'Puerto Santander', 'Norte de Santander'),
(747, 'Zapayán', 'Magdalena'),
(748, 'Carmen de Carupa', 'Cundinamarca'),
(749, 'Agrado', 'Huila'),
(750, 'La Belleza', 'Santander'),
(751, 'Marmato', 'Caldas'),
(752, 'Bagadó', 'Chocó'),
(753, 'Junín', 'Cundinamarca'),
(754, 'Entrerrios', 'Antioquia'),
(755, 'Cucutilla', 'Norte de Santander'),
(756, 'Nunchía', 'Casanare'),
(757, 'La Tola', 'Nariño'),
(758, 'Salamina', 'Magdalena'),
(759, 'Chipaque', 'Cundinamarca'),
(760, 'La Playa', 'Norte de Santander'),
(761, 'Aratoca', 'Santander'),
(762, 'Carmen de Apicalá', 'Tolima'),
(763, 'Padilla', 'Cauca'),
(764, 'Cerro San Antonio', 'Magdalena'),
(765, 'Uramita', 'Antioquia'),
(766, 'San Francisco', 'Cundinamarca'),
(767, 'Pueblorrico', 'Antioquia'),
(768, 'Soplaviento', 'Bolívar'),
(769, 'Versalles', 'Valle del Cauca'),
(770, 'Teruel', 'Huila'),
(771, 'Ospina', 'Nariño'),
(772, 'Quipile', 'Cundinamarca'),
(773, 'Sabanalarga', 'Antioquia'),
(774, 'Unión Panamericana', 'Chocó'),
(775, 'Ricaurte', 'Cundinamarca'),
(776, 'Cuaspud', 'Nariño'),
(777, 'Río Iro', 'Chocó'),
(778, 'Pedraza', 'Magdalena'),
(779, 'Une', 'Cundinamarca'),
(780, 'Pore', 'Casanare'),
(781, 'Maripí', 'Boyacá'),
(782, 'Río Quito', 'Chocó'),
(783, 'Güicán', 'Boyacá'),
(784, 'Nóvita', 'Chocó'),
(785, 'Yaguará', 'Huila'),
(786, 'Santana', 'Boyacá'),
(787, 'Iles', 'Nariño'),
(788, 'El Guamo', 'Bolívar'),
(789, 'Apulo', 'Cundinamarca'),
(790, 'Cantagallo', 'Bolívar'),
(791, 'El Peñón', 'Bolívar'),
(792, 'Yalí', 'Antioquia'),
(793, 'Nocaima', 'Cundinamarca'),
(794, 'Vergara', 'Cundinamarca'),
(795, 'Orocué', 'Casanare'),
(796, 'Tausa', 'Cundinamarca'),
(797, 'Caicedo', 'Antioquia'),
(798, 'Ambalema', 'Tolima'),
(799, 'Barichara', 'Santander'),
(800, 'Angelópolis', 'Antioquia'),
(801, 'Maceo', 'Antioquia'),
(802, 'Nuquí', 'Chocó'),
(803, 'Socha', 'Boyacá'),
(804, 'Turmequé', 'Boyacá'),
(805, 'San José', 'Caldas'),
(806, 'Tena', 'Cundinamarca'),
(807, 'Atrato', 'Chocó'),
(808, 'Montebello', 'Antioquia'),
(809, 'Imués', 'Nariño'),
(810, 'Sapuyes', 'Nariño'),
(811, 'Arboleda', 'Nariño'),
(812, 'Jenesano', 'Boyacá'),
(813, 'Paratebueno', 'Cundinamarca'),
(814, 'Anza', 'Antioquia'),
(815, 'San Luis de Palenque', 'Casanare'),
(816, 'Coromoro', 'Santander'),
(817, 'Villavieja', 'Huila'),
(818, 'San Andrés de Cuerquía', 'Antioquia'),
(819, 'El Molino', 'La Guajira'),
(820, 'Salento', 'Quindío'),
(821, 'Tarso', 'Antioquia'),
(822, 'Támara', 'Casanare'),
(823, 'Piamonte', 'Cauca'),
(824, 'Castilla la Nueva', 'Meta'),
(825, 'La Pintada', 'Antioquia'),
(826, 'San Pedro de Cartago', 'Nariño'),
(827, 'Cucunubá', 'Cundinamarca'),
(828, 'Funes', 'Nariño'),
(829, 'La Peña', 'Cundinamarca'),
(830, 'Puerto Nariño', 'Amazonas'),
(831, 'Villanueva', 'Santander'),
(832, 'Buriticá', 'Antioquia'),
(833, 'Tasco', 'Boyacá'),
(834, 'Guaca', 'Santander'),
(835, 'Casabianca', 'Tolima'),
(836, 'Norcasia', 'Caldas'),
(837, 'Ubaque', 'Cundinamarca'),
(838, 'Granada', 'Cundinamarca'),
(839, 'El Castillo', 'Meta'),
(840, 'El Peñol', 'Nariño'),
(841, 'Aldana', 'Nariño'),
(842, 'Macheta', 'Cundinamarca'),
(843, 'San Francisco', 'Putumayo'),
(844, 'Ragonvalia', 'Norte de Santander'),
(845, 'Motavita', 'Boyacá'),
(846, 'La Merced', 'Caldas'),
(847, 'Chitaraque', 'Boyacá'),
(848, 'Argelia', 'Valle del Cauca'),
(849, 'Tona', 'Santander'),
(850, 'Guatavita', 'Cundinamarca'),
(851, 'Pijao', 'Quindío'),
(852, 'Contadero', 'Nariño'),
(853, 'Heliconia', 'Antioquia'),
(854, 'Fosca', 'Cundinamarca'),
(855, 'Cubará', 'Boyacá'),
(856, 'San Carlos de Guaroa', 'Meta'),
(857, 'Belén', 'Nariño'),
(858, 'Bochalema', 'Norte de Santander'),
(859, 'Quetame', 'Cundinamarca'),
(860, 'Santa Isabel', 'Tolima'),
(861, 'San Cristóbal', 'Bolívar'),
(862, 'Hobo', 'Huila'),
(863, 'La Llanada', 'Nariño'),
(864, 'Puerto Parra', 'Santander'),
(865, 'San Francisco', 'Antioquia'),
(866, 'Albania', 'Caquetá'),
(867, 'San Luis de Gaceno', 'Boyacá'),
(868, 'Florián', 'Santander'),
(869, 'Guayatá', 'Boyacá'),
(870, 'Balboa', 'Risaralda'),
(871, 'Gramalote', 'Norte de Santander'),
(872, 'Valparaíso', 'Antioquia'),
(873, 'Cerrito', 'Santander'),
(874, 'Firavitoba', 'Boyacá'),
(875, 'Roncesvalles', 'Tolima'),
(876, 'Guadalupe', 'Antioquia'),
(877, 'Villarrica', 'Tolima'),
(878, 'Coloso', 'Sucre'),
(879, 'El Cantón del San Pablo', 'Chocó'),
(880, 'Belmira', 'Antioquia'),
(881, 'Valle de San Juan', 'Tolima'),
(882, 'Capitanejo', 'Santander'),
(883, 'Sutamarchán', 'Boyacá'),
(884, 'Nuevo Colón', 'Boyacá'),
(885, 'Chíquiza', 'Boyacá'),
(886, 'Florencia', 'Cauca'),
(887, 'Albán', 'Cundinamarca'),
(888, 'Soracá', 'Boyacá'),
(889, 'Gachalá', 'Cundinamarca'),
(890, 'Concepción', 'Santander'),
(891, 'Buenavista', 'Boyacá'),
(892, 'Labateca', 'Norte de Santander'),
(893, 'Matanza', 'Santander'),
(894, 'Guatapé', 'Antioquia'),
(895, 'Nátaga', 'Huila'),
(896, 'Molagavita', 'Santander'),
(897, 'Ulloa', 'Valle del Cauca'),
(898, 'San José de Pare', 'Boyacá'),
(899, 'Onzaga', 'Santander'),
(900, 'Toledo', 'Antioquia'),
(901, 'Tota', 'Boyacá'),
(902, 'Gualmatán', 'Nariño'),
(903, 'Gámeza', 'Boyacá'),
(904, 'La Paz', 'Santander'),
(905, 'El Peñón', 'Santander'),
(906, 'Guadalupe', 'Santander'),
(907, 'El Cocuy', 'Boyacá'),
(908, 'Nimaima', 'Cundinamarca'),
(909, 'Caramanta', 'Antioquia'),
(910, 'Vigía del Fuerte', 'Antioquia'),
(911, 'Paime', 'Cundinamarca'),
(912, 'Pandi', 'Cundinamarca'),
(913, 'Córdoba', 'Quindío'),
(914, 'Piedras', 'Tolima'),
(915, 'Chiscas', 'Boyacá'),
(916, 'Betulia', 'Santander'),
(917, 'Labranzagrande', 'Boyacá'),
(918, 'Valle de San José', 'Santander'),
(919, 'Silos', 'Norte de Santander'),
(920, 'San Cayetano', 'Cundinamarca'),
(921, 'Mongua', 'Boyacá'),
(922, 'Paz de Río', 'Boyacá'),
(923, 'Ciénega', 'Boyacá'),
(924, 'Togüí', 'Boyacá'),
(925, 'Fúquene', 'Cundinamarca'),
(926, 'Paicol', 'Huila'),
(927, 'Carcasí', 'Santander'),
(928, 'Arcabuco', 'Boyacá'),
(929, 'Armenia', 'Antioquia'),
(930, 'Alpujarra', 'Tolima'),
(931, 'Zetaquira', 'Boyacá'),
(932, 'Gambita', 'Santander'),
(933, 'Colón', 'Putumayo'),
(934, 'Cubarral', 'Meta'),
(935, 'Chipatá', 'Santander'),
(936, 'Carmen del Darien', 'Chocó'),
(937, 'Murillo', 'Tolima'),
(938, 'Boyacá', 'Boyacá'),
(939, 'San José del Palmar', 'Chocó'),
(940, 'Chivatá', 'Boyacá'),
(941, 'Villa Caro', 'Norte de Santander'),
(942, 'Piojó', 'Atlántico'),
(943, 'Zipacón', 'Cundinamarca'),
(944, 'Monguí', 'Boyacá'),
(945, 'Ocamonte', 'Santander'),
(946, 'El Peñón', 'Cundinamarca'),
(947, 'Supatá', 'Cundinamarca'),
(948, 'tica', 'Cundinamarca'),
(949, 'Providencia', 'Archipiélago de San Andrés'),
(950, 'Floresta', 'Boyacá'),
(951, 'Caracolí', 'Antioquia'),
(952, 'San José de Miranda', 'Santander'),
(953, 'Tibacuy', 'Cundinamarca'),
(954, 'Hispania', 'Antioquia'),
(955, 'Topaipí', 'Cundinamarca'),
(956, 'Pamplonita', 'Norte de Santander'),
(957, 'San Mateo', 'Boyacá'),
(958, 'Guayabetal', 'Cundinamarca'),
(959, 'Sutatausa', 'Cundinamarca'),
(960, 'Jericó', 'Boyacá'),
(961, 'Macanal', 'Boyacá'),
(962, 'Quebradanegra', 'Cundinamarca'),
(963, 'Cabrera', 'Cundinamarca'),
(964, 'Tenza', 'Boyacá'),
(965, 'Santa María', 'Boyacá'),
(966, 'Manta', 'Cundinamarca'),
(967, 'San Miguel de Sema', 'Boyacá'),
(968, 'Cucaita', 'Boyacá'),
(969, 'Sutatenza', 'Boyacá'),
(970, 'Bucarasica', 'Norte de Santander'),
(971, 'Suárez', 'Tolima'),
(972, 'Concepción', 'Antioquia'),
(973, 'Herrán', 'Norte de Santander'),
(974, 'San Cayetano', 'Norte de Santander'),
(975, 'Albania', 'Santander'),
(976, 'Santa Helena del Opón', 'Santander'),
(977, 'Pacoa', 'Vaupés'),
(978, 'Pinchote', 'Santander'),
(979, 'Guavatá', 'Santander'),
(980, 'Barranco Minas', 'Guainía'),
(981, 'El Encanto', 'Amazonas'),
(982, 'Somondoco', 'Boyacá'),
(983, 'Cerinza', 'Boyacá'),
(984, 'Duranía', 'Norte de Santander'),
(985, 'Güepsa', 'Santander'),
(986, 'Coper', 'Boyacá'),
(987, 'Giraldo', 'Antioquia'),
(988, 'Chalán', 'Sucre'),
(989, 'Nariño', 'Nariño'),
(990, 'Vianí', 'Cundinamarca'),
(991, 'Chaguaní', 'Cundinamarca'),
(992, 'Campohermoso', 'Boyacá'),
(993, 'Caldas', 'Boyacá'),
(994, 'Contratación', 'Santander'),
(995, 'El Espino', 'Boyacá'),
(996, 'Enciso', 'Santander'),
(997, 'Carolina', 'Antioquia'),
(998, 'Puerto Rondón', 'Arauca'),
(999, 'Venecia', 'Cundinamarca'),
(1000, 'Mutiscua', 'Norte de Santander'),
(1001, 'San Benito', 'Santander'),
(1002, 'Gama', 'Cundinamarca'),
(1003, 'Sáchica', 'Boyacá'),
(1004, 'Tipacoque', 'Boyacá'),
(1005, 'Alejandría', 'Antioquia'),
(1006, 'Tarapacá', 'Amazonas'),
(1007, 'Puerto Colombia', 'Guainía'),
(1008, 'Chinavita', 'Boyacá'),
(1009, 'Murindó', 'Antioquia'),
(1010, 'Morelia', 'Caquetá'),
(1011, 'La Pedrera', 'Amazonas'),
(1012, 'Susacón', 'Boyacá'),
(1013, 'Tópaga', 'Boyacá'),
(1014, 'Páramo', 'Santander'),
(1015, 'Suratá', 'Santander'),
(1016, 'Cravo Norte', 'Arauca'),
(1017, 'Cabuyaro', 'Meta'),
(1018, 'Guayabal de Siquima', 'Cundinamarca'),
(1019, 'La Uvita', 'Boyacá'),
(1020, 'Juradó', 'Chocó'),
(1021, 'Altamira', 'Huila'),
(1022, 'Marulanda', 'Caldas'),
(1023, 'Gutiérrez', 'Cundinamarca'),
(1024, 'Sipí', 'Chocó'),
(1025, 'Viracachá', 'Boyacá'),
(1026, 'Jesús María', 'Santander'),
(1027, 'Lourdes', 'Norte de Santander'),
(1028, 'Sabanalarga', 'Casanare'),
(1029, 'Páez', 'Boyacá'),
(1030, 'Chima', 'Santander'),
(1031, 'Elías', 'Huila'),
(1032, 'La Chorrera', 'Amazonas'),
(1033, 'Covarachía', 'Boyacá'),
(1034, 'El Dorado', 'Meta'),
(1035, 'Santa Rosalía', 'Vichada'),
(1036, 'Caruru', 'Vaupés'),
(1037, 'Barranca de Upía', 'Meta'),
(1038, 'La Capilla', 'Boyacá'),
(1039, 'Charta', 'Santander'),
(1040, 'Santa Sofía', 'Boyacá'),
(1041, 'San José de La Montaña', 'Antioquia'),
(1042, 'Pachavita', 'Boyacá'),
(1043, 'Buenavista', 'Quindío'),
(1044, 'Gachantivá', 'Boyacá'),
(1045, 'Mapiripana', 'Guainía'),
(1046, 'Tibirita', 'Cundinamarca'),
(1047, 'Rondón', 'Boyacá'),
(1048, 'Galán', 'Santander'),
(1049, 'Sora', 'Boyacá'),
(1050, 'San Joaquín', 'Santander'),
(1051, 'Pulí', 'Cundinamarca'),
(1052, 'Tinjacá', 'Boyacá'),
(1053, 'Olaya', 'Antioquia'),
(1054, 'Palmar', 'Santander'),
(1055, 'Oicatá', 'Boyacá'),
(1056, 'Sativanorte', 'Boyacá'),
(1057, 'Confines', 'Santander'),
(1058, 'Macaravita', 'Santander'),
(1059, 'Briceño', 'Boyacá'),
(1060, 'Jerusalén', 'Cundinamarca'),
(1061, 'La Jagua del Pilar', 'La Guajira'),
(1062, 'Encino', 'Santander'),
(1063, 'Abriaquí', 'Antioquia'),
(1064, 'San Miguel', 'Santander'),
(1065, 'Santiago', 'Norte de Santander'),
(1066, 'Bituima', 'Cundinamarca'),
(1067, 'Paya', 'Boyacá'),
(1068, 'Recetor', 'Casanare'),
(1069, 'Cácota', 'Norte de Santander'),
(1070, 'Corrales', 'Boyacá'),
(1071, 'Guataquí', 'Cundinamarca'),
(1072, 'Betéitiva', 'Boyacá'),
(1073, 'Palmas del Socorro', 'Santander'),
(1074, 'Pajarito', 'Boyacá'),
(1075, 'Hato', 'Santander'),
(1076, 'Puerto Santander', 'Amazonas'),
(1077, 'Vetas', 'Santander'),
(1078, 'Santa Bárbara', 'Santander'),
(1079, 'El Guacamayo', 'Santander'),
(1080, 'Almeida', 'Boyacá'),
(1081, 'El Calvario', 'Meta'),
(1082, 'Guapotá', 'Santander'),
(1083, 'Tutazá', 'Boyacá'),
(1084, 'Chivor', 'Boyacá'),
(1085, 'Pana Pana', 'Guainía'),
(1086, 'Villagómez', 'Cundinamarca'),
(1087, 'Guacamayas', 'Boyacá'),
(1088, 'Aguada', 'Santander'),
(1089, 'Iza', 'Boyacá'),
(1090, 'Nariño', 'Cundinamarca'),
(1091, 'Cepitá', 'Santander'),
(1092, 'Cuítiva', 'Boyacá'),
(1093, 'Beltrán', 'Cundinamarca'),
(1094, 'San Eduardo', 'Boyacá'),
(1095, 'Cabrera', 'Santander'),
(1096, 'Berbeo', 'Boyacá'),
(1097, 'San Juanito', 'Meta'),
(1098, 'Panqueba', 'Boyacá'),
(1099, 'Chameza', 'Casanare'),
(1100, 'California', 'Santander'),
(1101, 'Sácama', 'Casanare'),
(1102, 'La Victoria', 'Boyacá'),
(1103, 'Miriti - Paraná', 'Amazonas'),
(1104, 'Tununguá', 'Boyacá'),
(1105, 'Cacahual', 'Guainía'),
(1106, 'Pisba', 'Boyacá'),
(1107, 'Puerto Arica', 'Amazonas'),
(1108, 'San Felipe', 'Guainía'),
(1109, 'Sativasur', 'Boyacá'),
(1110, 'La Salina', 'Casanare'),
(1111, 'Puerto Alegría', 'Amazonas'),
(1112, 'Yavaraté', 'Vaupés'),
(1113, 'Jordán', 'Santander'),
(1114, 'Taraira', 'Vaupés'),
(1115, 'La Victoria', 'Amazonas'),
(1116, 'Busbanzá', 'Boyacá'),
(1117, 'Papunaua', 'Vaupés'),
(1118, 'Morichal', 'Guainía'),
(1119, 'La Guadalupe', 'Guainía');

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

-- 
-- Estructura de tabla para la tabla `Clientes`
-- 

CREATE TABLE `Clientes` (
  `No` int(4) NOT NULL,
  `Nombre` varchar(50) NOT NULL,
  `Nit` varchar(20) NOT NULL,
  `Contacto` varchar(50) NOT NULL,
  `Teléfono` varchar(15) NOT NULL,
  `Fax` varchar(15) NOT NULL,
  `Celular1` varchar(15) NOT NULL,
  `Celular2` varchar(15) NOT NULL,
  `Dirección` varchar(50) NOT NULL,
  `Email` varchar(100) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Clientes`
-- 


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

-- 
-- Estructura de tabla para la tabla `Color`
-- 

CREATE TABLE `Color` (
  `No` int(4) NOT NULL AUTO_INCREMENT,
  `Detalle` varchar(60) NOT NULL,
  `Pri` varchar(10) NOT NULL,
  `Npri` varchar(10) NOT NULL,
  `Fon` varchar(10) NOT NULL,
  `Vfon` varchar(10) NOT NULL,
  `Bor` varchar(10) NOT NULL,
  `Vbor` varchar(10) NOT NULL,
  `Fue` varchar(2) NOT NULL,
  `Vfue` varchar(10) NOT NULL,
  PRIMARY KEY (`No`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 AUTO_INCREMENT=21 ;

-- 
-- Volcar la base de datos para la tabla `Color`
-- 

INSERT INTO `Color` (`No`, `Detalle`, `Pri`, `Npri`, `Fon`, `Vfon`, `Bor`, `Vbor`, `Fue`, `Vfue`) VALUES (1, 'color matizante', 'rojo', 'negro', 'morado', 'cafe', 'naranja', 'azul', '1', 'blanco'),
(2, 'amarillo', 'Negro', 'blanco', 'rojo', 'gris', 'azul', 'morado', '2', 'verde'),
(9, 'cafe', 'negro', 'blanco', 'gris', 'beige', 'azul', 'rojo', '9', 'amarillo'),
(12, 'verde', 'morado', 'azul', 'rosado', 'negro', 'blanco', 'naranja', '12', 'amarillio'),
(3, 'cafe', 'negro', 'blanco', 'gris', 'beige', 'azul', 'rojo', '3', 'amarillo'),
(4, 'verde', 'morado', 'azul', 'rosado', 'negro', 'blanco', 'naranja', '4', 'amarillio'),
(11, 'amarillo', 'verde', 'blanco', 'negro', 'azul', 'rosado', 'naranja', '11', 'rojo'),
(13, 'rojo', 'naranja', 'verde', 'azul', 'amarillo', 'negro', 'violeta', '13', 'beige'),
(5, 'amarillo', 'verde', 'blanco', 'negro', 'azul', 'rosado', 'naranja', '5', 'rojo'),
(6, 'rojo', 'naranja', 'verde', 'azul', 'amarillo', 'negro', 'violeta', '6', 'beige'),
(14, 'blanco', 'negro', 'azul', 'naranja', 'amarillo', 'rojo', 'verde', '14', 'gris'),
(10, 'amarillo', 'negro', 'azul', 'verde', 'blanco', 'gris', 'beige', '10', 'morado'),
(15, 'blanco', 'negro', 'azul', 'naranja', 'amarillo', 'rojo', 'verde', '15', 'gris'),
(17, 'amarillo', 'negro', 'azul', 'verde', 'blanco', 'gris', 'beige', '17', 'morado'),
(16, 'blanco', 'negro', 'azul', 'naranja', 'amarillo', 'rojo', 'verde', '16', 'gris'),
(18, 'amarillo', 'negro', 'azul', 'verde', 'blanco', 'gris', 'beige', '18', 'morado'),
(19, 'blanco', 'negro', 'azul', 'naranja', 'amarillo', 'rojo', 'verde', '19', 'gris'),
(20, 'amarillo', 'negro', 'azul', 'verde', 'blanco', 'gris', 'beige', '20', 'morado'),
(7, 'blanco', 'negro', 'azul', 'naranja', 'amarillo', 'rojo', 'verde', '7', 'gris'),
(8, 'amarillo', 'negro', 'azul', 'verde', 'blanco', 'gris', 'beige', '8', 'morado');

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

-- 
-- Estructura de tabla para la tabla `Contactos`
-- 

CREATE TABLE `Contactos` (
  `No` int(10) NOT NULL AUTO_INCREMENT,
  `correo` varchar(48) NOT NULL,
  `nombres` varchar(50) NOT NULL,
  `apellidos` varchar(50) NOT NULL,
  `telefonos` varchar(15) NOT NULL,
  `celular` varchar(15) NOT NULL,
  `mensaje` text NOT NULL,
  `fecha` datetime NOT NULL,
  PRIMARY KEY (`No`)
) ENGINE=MyISAM AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;

-- 
-- Volcar la base de datos para la tabla `Contactos`
-- 

INSERT INTO `Contactos` (`No`, `correo`, `nombres`, `apellidos`, `telefonos`, `celular`, `mensaje`, `fecha`) VALUES (26, 'fdg', 'gfd', '', 'gfdgfdg', '', 'Contacto desde el formualrio de la página Web:  gfdg', '0000-00-00 00:00:00'),
(27, 'gfdgfdgdfgfdgfd', 'fgdgfdgfdg', '', 'gfdgfdgdfgdf', '', 'Contacto desde el formualrio de la página Web:  gfdgdfgdfgdfg dfgf gfd g', '0000-00-00 00:00:00'),
(28, 'gfdgfdgdfgfdgfd', 'fgdgfdgfdg', '', 'gfdgfdgdfgdf', '', 'Contacto desde el formualrio de la página Web:  gfdgdfgdfgdfg dfgf gfd g gfdgfdgfd', '0000-00-00 00:00:00');

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

-- 
-- Estructura de tabla para la tabla `Control`
-- 

CREATE TABLE `Control` (
  `No` int(5) NOT NULL AUTO_INCREMENT,
  `Gestor` varchar(15) NOT NULL,
  `Fecha` datetime NOT NULL,
  `Acción` varchar(50) NOT NULL,
  `Empresa` varchar(20) NOT NULL,
  PRIMARY KEY (`No`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Volcar la base de datos para la tabla `Control`
-- 


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

-- 
-- Estructura de tabla para la tabla `Cuenta`
-- 

CREATE TABLE `Cuenta` (
  `No` int(8) NOT NULL,
  `No_Sesión` varchar(12) NOT NULL,
  `Paciente` varchar(40) NOT NULL,
  `Servicio` varchar(30) NOT NULL,
  `Valoru` varchar(15) NOT NULL,
  `Valort` varchar(15) NOT NULL,
  `Cod_Tarifa` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Cuenta`
-- 


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

-- 
-- Estructura de tabla para la tabla `Cuenta2`
-- 

CREATE TABLE `Cuenta2` (
  `No` int(8) NOT NULL,
  `No_Autoriz` varchar(12) NOT NULL,
  `Paciente` varchar(35) NOT NULL,
  `Cod_Tarifa` varchar(15) NOT NULL,
  `Detalle` varchar(40) NOT NULL,
  `Horas` int(8) NOT NULL,
  `Valor` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Cuenta2`
-- 


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

-- 
-- Estructura de tabla para la tabla `Depto`
-- 

CREATE TABLE `Depto` (
  `No` int(5) NOT NULL,
  `Depto` varchar(35) NOT NULL,
  `País` varchar(35) NOT NULL,
  `Capital` varchar(35) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Depto`
-- 

INSERT INTO `Depto` (`No`, `Depto`, `País`, `Capital`) VALUES (1, 'Distrito Capital', 'Bogotá D.C.', ''),
(2, 'Amazonas', 'Leticia', ''),
(3, 'Antioquia', 'Medellín', ''),
(4, 'Arauca', 'Arauca', ''),
(5, 'Atlántico', 'Barranquilla', ''),
(6, 'Bolívar', 'Cartagena de Indias', ''),
(7, 'Boyacá', 'Tunja', ''),
(8, 'Caldas', 'Manizales', ''),
(9, 'Caquetá', 'Florencia', ''),
(10, 'Casanare', 'Yopal', ''),
(11, 'Cauca', 'Popayán', ''),
(12, 'Cesar', 'Valledupar', ''),
(13, 'Chocó', 'Quibdó', ''),
(14, 'Córdoba', 'Montería', ''),
(15, 'Cundinamarca', 'Bogotá', ''),
(16, 'Guainía', 'Puerto Inírida', ''),
(17, 'Guaviare', 'San José del Guaviare', ''),
(18, 'Huila', 'Neiva', ''),
(19, 'La Guajira', 'Riohacha', ''),
(20, 'Magdalena', 'Santa Marta', ''),
(21, 'Meta', 'Villavicencio', ''),
(22, 'Nariño', 'San Juan de Pasto', ''),
(23, 'Norte de Santander', 'Cúcuta', ''),
(24, 'Putumayo', 'Mocoa', ''),
(25, 'Quindío', 'Armenia', ''),
(26, 'Risaralda', 'Pereira', ''),
(27, 'San Andrés y Providencia', 'San Andrés', ''),
(28, 'Santander', 'Bucaramanga', ''),
(29, 'Sucre', 'Sincelejo', ''),
(30, 'Tolima', 'Ibagué', ''),
(31, 'Valle del Cauca', 'Cali', ''),
(32, 'Vaupés', 'Mitú', ''),
(33, 'Vichada', 'Puerto Carreño', '');

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

-- 
-- Estructura de tabla para la tabla `Detalle`
-- 

CREATE TABLE `Detalle` (
  `No` int(8) NOT NULL,
  `Consec` int(2) NOT NULL,
  `Requerimiento` varchar(70) NOT NULL,
  `Efectuado` int(1) NOT NULL,
  `Profesional` varchar(40) NOT NULL,
  `No_Cesiones` int(5) NOT NULL,
  `Tiempo` varchar(20) NOT NULL,
  `Fecha` date NOT NULL,
  `Cod_req` varchar(25) NOT NULL,
  `Cod_prof` varchar(12) NOT NULL,
  `Asignado` int(1) NOT NULL,
  `FechaE` datetime NOT NULL,
  `FechaE2` datetime NOT NULL,
  `Observa` text NOT NULL,
  `Subdividido` int(1) NOT NULL,
  `F_Gestión` int(2) NOT NULL,
  `Fallida` int(1) NOT NULL,
  `Tarifa` int(10) NOT NULL,
  `Entidad` varchar(30) NOT NULL,
  `Paciente` varchar(45) NOT NULL,
  `Cédula` varchar(45) NOT NULL,
  `Dirección` varchar(20) NOT NULL,
  `No_Autoriz` varchar(15) NOT NULL,
  `Vr_Copago` int(10) NOT NULL,
  `Eventos` text NOT NULL,
  `Turnos` int(1) NOT NULL,
  `Ces_Rea` int(3) NOT NULL,
  `Facturada` int(1) NOT NULL,
  `Tarificada` int(1) NOT NULL,
  `Especial` int(2) NOT NULL,
  `Teléfono` varchar(20) NOT NULL,
  KEY `No` (`No`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Detalle`
-- 

INSERT INTO `Detalle` (`No`, `Consec`, `Requerimiento`, `Efectuado`, `Profesional`, `No_Cesiones`, `Tiempo`, `Fecha`, `Cod_req`, `Cod_prof`, `Asignado`, `FechaE`, `FechaE2`, `Observa`, `Subdividido`, `F_Gestión`, `Fallida`, `Tarifa`, `Entidad`, `Paciente`, `Cédula`, `Dirección`, `No_Autoriz`, `Vr_Copago`, `Eventos`, `Turnos`, `Ces_Rea`, `Facturada`, `Tarificada`, `Especial`, `Teléfono`) VALUES (2465, 2, 'Terapia Respiratoria', 0, '', 8, '31', '2011-05-05', '06-93940001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'ALIANSALUD', 'DAMASO CRUZ GONZALEZ', '317480', 'CARRERA 55 No 151-69', '2811409462', 0, '', 0, 0, 0, 0, 0, ''),
(2465, 3, 'Terapia física', 0, '', 12, '31', '2011-05-05', '06-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'ALIANSALUD', 'DAMASO CRUZ GONZALEZ', '317480', 'CARRERA 55 No 151-69', '2811409462', 0, '', 0, 0, 0, 0, 0, ''),
(2433, 1, 'Terapia Respiratoria', 0, 'NIEBLES  GUTIERREZ  AURA  ADRIANA', 8, '31', '2011-05-04', '04-93940001', '52824228', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 23000, 'COMPENSAR', 'CARLOTA SALAZAR CRUZ', '20265119', 'CALLE 42G No 78L-35 ', '11109116234065', 2600, '', 0, 0, 0, 0, 0, ''),
(2434, 1, 'Terapia Respiratoria', 0, '', 26, '31', '2011-05-04', '04-93940001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 23000, 'COMPENSAR', 'JOSE ERASMO MARTINEZ RIOS', '219386', 'CARRERA 79D No 38C-4', '111221162430916', 0, '', 0, 0, 0, 0, 0, ''),
(2439, 1, 'Terapia física', 0, 'CELIS LANCHEROS NUBIA MARLENE', 1, '1', '2011-05-04', '04-89021101', '52422101', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'OLGA CULMA CALDERON', '41685842', 'TRANSVERSAL 5R No 48', '11108216356568', 0, '', 0, 0, 0, 0, 0, ''),
(2438, 1, 'Terapia física', 0, 'VELASQUEZ PEÑA AMERICA DELFINA', 4, '31', '2011-05-04', '04-89021101', '55300014', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'CARLOTA SALAZAR CRUZ', '20265119', 'CALLE 42G No 78L-35 ', '111091162341013', 2400, '', 0, 0, 0, 0, 0, ''),
(2437, 1, 'Terapia física', 0, '', 10, '31', '2011-05-04', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'JAIME ACERO ORTEGA', '44816', 'CARRERA 52 No 45A-14', '88888-80438089', 55000, '', 0, 0, 0, 0, 0, ''),
(2436, 1, 'Terapia Ocupacional', 0, 'MONTEALEGRE PASTRANA YULIETH', 4, '31', '2011-05-04', '04-93830001', '52165575', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'CARLOTA SALAZAR CRUZ', '20265119', 'CALLE 42G No 78L-35 ', '11109116234121', 2400, '', 0, 0, 0, 0, 0, ''),
(2440, 1, 'Terapia física', 0, 'LOPEZ SACRISTAN JOHANNA MARCELA', 6, '31', '2011-05-04', '04-89021101', '52368730', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'CLARA ALCIRA SARMIENTO', '41629303', 'AVENIDA CALLE 20 SUR', '11109116251965', 0, '', 0, 0, 0, 0, 0, ''),
(2441, 1, 'Terapia física', 0, '', 10, '31', '2011-05-04', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'JORGE ENRIQUE PINZON', '2191298', 'CARRERA 69M No 68-36', '11118216344825', 2400, '', 0, 0, 0, 0, 0, ''),
(2442, 1, 'Terapia física', 0, 'VILLAMAR QUIROS FREDY GIOVANY', 8, '31', '2011-05-04', '04-89021101', '218193', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'EVANGELISTA BARRIOS CASTRO', '5911', 'CARRERA 123 No 130C-', '11117216337648', 2400, '', 0, 0, 0, 0, 0, ''),
(2444, 1, 'Terapia del Lenguaje', 0, 'FORERO PINZON DIANA', 8, '31', '2011-05-04', '04-93700001', '53053711', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'EVANGELISTA BARRIOS CASTRO', '5911', 'CARRERA 123 No 130C-', '111172163376207', 2400, '', 0, 0, 0, 0, 0, ''),
(2443, 1, 'Terapia Ocupacional', 0, '', 12, '31', '2011-05-04', '04-93830001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'JOSE ERASMO MARTINEZ RIOS', '219386', 'CARRERA 79D No 38C-4', '11122116243144', 0, '', 0, 0, 0, 0, 0, ''),
(2445, 1, 'Terapia del Lenguaje', 0, '', 12, '31', '2011-05-04', '04-93700001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'JOSE ERASMO MARTINEZ RIOS', '219386', 'CARRERA 79D No 38C-4', '111221162431325', 0, '', 0, 0, 0, 0, 0, ''),
(2446, 1, 'Terapia física', 0, '', 12, '31', '2011-05-04', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'JOSE ERASMO MARTINEZ RIOS', '219386', 'CARRERA 79D No 38C-4', '111221162431103', 0, '', 0, 0, 0, 0, 0, ''),
(2447, 1, 'Terapia del Lenguaje', 0, '', 15, '31', '2011-05-04', '04-93700001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'LEIDY JOHANA RODRIGUE', '1030561358', 'CARRERA 49 BIS No 11', '11119191544421', 0, '', 0, 0, 0, 0, 0, ''),
(2448, 1, 'Terapia Ocupacional', 0, '', 15, '31', '2011-05-04', '04-93830001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'LEIDY JOHANA RODRIGUE', '1030561358', 'CARRERA 49 BIS No 11', '111191915438669', 0, '', 0, 0, 0, 0, 0, ''),
(2449, 1, 'Terapia física', 0, '', 15, '31', '2011-05-04', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'LEIDY JOHANA RODRIGUE', '1030561358', 'CARRERA 49 BIS No 11', '111191915438422', 0, '', 0, 0, 0, 0, 0, ''),
(2450, 1, 'ACTIVIDAD PUNTUAL DE ENFERMERÍA', 0, '', 31, '31', '2011-05-04', '04-890105', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 23000, 'COMPENSAR', 'MERCEDES NIETO VDA DE CASTRO', '20063229', 'CALLE 67A BIS No 65A', '11119118744979', 0, '', 0, 0, 0, 0, 0, ''),
(2451, 1, 'AUXILIAR ENFERMERIA 24 HORAS DIARIAS', 0, '', 30, '31', '2011-05-04', '04-89010502-1-7000', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 109400, 'COMPENSAR', 'GENOVEVA MUÑOS RIVEROS', '20233673', 'TRANSVERSAL 39B No 2', '11122938237470', 0, '', 0, 0, 0, 0, 0, ''),
(2452, 1, 'Terapia Respiratoria', 0, '', 10, '31', '2011-05-04', '04-93940001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 23000, 'COMPENSAR', 'SOLEDAD MARIA LEON DE PARRA', '20406200', 'CALLE 58 No 35A-60 A', '111232163468842', 0, '', 0, 0, 0, 0, 0, ''),
(2453, 1, 'Terapia física', 0, '', 10, '31', '2011-05-04', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'PEDRO CRISTANCHO MARIN', '19417702', 'CALLE 25 No 68C-50 I', '11122116263449', 0, '', 0, 0, 0, 0, 0, ''),
(2454, 1, '', 0, '', 15, '31', '2011-05-04', '', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 0, 'ALICO COLOMBIA', 'DIANA JASMIN COLORADO', '52825082', 'CALLE 51 SUR  No 2D-', '88888-80438085', 119, '', 0, 0, 0, 0, 0, ''),
(2464, 1, 'CONSULTA MEDICA GENERAL', 0, '', 1, '31', '2011-05-05', '06-890101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 42000, 'ALIANSALUD', 'DAMASO CRUZ GONZALEZ', '317480', 'CARRERA 55 No 151-69', '2811409465', 0, '', 0, 0, 0, 0, 0, ''),
(2455, 1, 'Terapia física', 0, '', 8, '31', '2011-05-04', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'DANIEL BARRAGAN ZIPAMOCHA', '4037252', 'CARRERA 3 No 13-13 E', '11123116243356', 0, '', 0, 0, 0, 0, 0, ''),
(2456, 1, 'Terapia Respiratoria', 0, '', 20, '31', '2011-05-04', '04-93940001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 23000, 'COMPENSAR', 'ANA BELEN RICARDO DE MARTINEZ', '21005603', 'CALLE 12 SUR No 14A-', '11124191524880', 0, '', 0, 0, 0, 0, 0, ''),
(2457, 1, 'Terapia Respiratoria', 0, '', 1, '1', '2011-05-04', '04-93940001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 23000, 'COMPENSAR', 'ANA ELVIA RODRIGUEZ DE GALEANO', '20056520', 'CALLE 1D BIS No 27A-', '11105216361673', 2400, '', 0, 0, 0, 0, 0, ''),
(2458, 1, 'Terapia física', 0, '', 6, '31', '2011-05-04', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'HERMELINDA JAIMES DE ARIZA', '28419392', 'CALLE 95A SUR No 1-1', '11123116253856', 2400, '', 0, 0, 0, 0, 0, ''),
(2459, 1, 'Terapia física', 0, '', 12, '31', '2011-05-04', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'SEVERO ORTEGON CORDOBA', '2271871', 'CARRERA 77 C No 63D-', '11124191536191', 0, '', 0, 0, 0, 0, 0, ''),
(2465, 1, 'Terapia del Lenguaje', 0, '', 10, '31', '2011-05-05', '06-93700001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'ALIANSALUD', 'DAMASO CRUZ GONZALEZ', '317480', 'CARRERA 55 No 151-69', '2811409462', 0, '', 0, 0, 0, 0, 0, ''),
(2460, 1, 'Terapia física', 0, '', 8, '31', '2011-05-05', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'CAMILO RODRIGUEZ TORRES', '80770253', 'CARRERA 69 No 64A-24', '11088191531890', 4700, '', 0, 0, 0, 0, 0, ''),
(2461, 1, 'Terapia física', 0, '', 20, '31', '2011-05-05', '06-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'ALIANSALUD', 'RUTH MARIN DE GOME', '20068088', 'CALLE 64 Nº7-62 APT ', '2811412418', 0, '', 0, 0, 0, 0, 0, ''),
(2462, 1, 'CONSULTA MEDICA GENERAL', 0, '', 1, '31', '2011-05-05', '06-890101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 42000, 'ALIANSALUD', 'LAURA ALEJANDRA MORALES CASTAÑEDA', '', 'TRANSVERSAL 3H No 69', '2811408794', 0, '', 0, 0, 0, 0, 0, ''),
(2463, 1, 'CONSULTA MEDICA GENERAL', 0, '', 1, '31', '2011-05-05', '04-890101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 47250, 'COMPENSAR', 'LUIS ERNESTO CASTAÑEDA', '5804864', 'CARRERA 70C No 80-48', '11125444332685', 2100, '', 0, 0, 0, 0, 0, ''),
(2466, 1, 'Terapia física', 0, '', 10, '31', '2011-05-05', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'JOHANN FELIPE LANCHEROS CHAVEZ', '1029285397', 'DIAGONAL 47 SUR No 1', '111221162665123', 2400, '', 0, 0, 0, 0, 0, ''),
(2467, 1, 'Terapia Ocupacional', 0, '', 10, '31', '2011-05-05', '04-93830001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'JOHANN FELIPE LANCHEROS CHAVEZ', '1029285397', 'DIAGONAL 47 SUR No 1', '111221162665270', 2400, '', 0, 0, 0, 0, 0, ''),
(2468, 1, 'Terapia Ocupacional', 0, '', 0, '', '2011-05-05', '04-93830001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'JOSEPH SANTIAGO LANCHEROS CHAVEZ', '1029285396', 'DIAGONAL 47 SUR No 1', '111221162662727', 2400, '', 0, 0, 0, 0, 0, ''),
(2469, 1, 'Terapia física', 0, '', 10, '31', '2011-05-05', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'JOSEPH SANTIAGO LANCHEROS CHAVEZ', '1029285396', 'DIAGONAL 47 SUR No 1', '111221162663249', 2400, '', 0, 0, 0, 0, 0, ''),
(2470, 1, 'Terapia del Lenguaje', 0, '', 10, '30', '2011-05-05', '04-93700001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, 0, 0, 0, 0, ''),
(2470, 2, 'Terapia física', 0, '', 10, '30', '2011-05-05', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, 0, 0, 0, 0, ''),
(2470, 3, 'Terapia Ocupacional', 0, 'CHAPARRO ROJAS  CARMEN ELIANA', 10, '30', '2011-05-05', '04-93830001', '52267679', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, 0, 0, 0, 0, ''),
(2470, 4, 'Terapia del Lenguaje', 0, '', 10, '30', '2011-05-05', '04-93700001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, 0, 0, 0, 0, ''),
(2470, 5, 'Terapia física', 0, '', 10, '30', '2011-05-05', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, 0, 0, 0, 0, ''),
(2471, 1, 'Terapia del Lenguaje', 0, '', 25, '31', '2011-05-05', '06-01-93700001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 34000, 'ALIANSALUD', 'NATALIA PAOLA MONTES RUBIO', '1193031528', 'DIAGONAL 3 No 9-02 C', '2741028600', 0, '', 0, 0, 0, 0, 0, ''),
(2471, 2, 'Terapia física', 0, '', 20, '31', '2011-05-05', '06-01-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 34000, 'ALIANSALUD', 'NATALIA PAOLA MONTES RUBIO', '1193031528', 'DIAGONAL 3 No 9-02 C', '2741028600', 0, '', 0, 0, 0, 0, 0, ''),
(2471, 3, 'Terapia Ocupacional', 0, '', 20, '31', '2011-05-05', '06-01-93830001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 34000, 'ALIANSALUD', 'NATALIA PAOLA MONTES RUBIO', '1193031528', 'DIAGONAL 3 No 9-02 C', '2741028600', 0, '', 0, 0, 0, 0, 0, ''),
(2472, 1, 'Terapia Respiratoria', 0, '', 30, '31', '2011-05-05', '06-93940001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'ALIANSALUD', 'ANA ELVIRA FRANCO DE RINCON', '20097694', 'CALLE 141 No 49-63', '2121364150', 0, '', 0, 0, 0, 0, 0, ''),
(2473, 1, 'Terapia del Lenguaje', 0, '', 4, '31', '2011-05-05', '06-93700001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'ALIANSALUD', 'ANA ELVIRA FRANCO DE RINCON', '20097694', 'CALLE 141 No 49-63', '2811412299', 0, '', 0, 0, 0, 0, 0, ''),
(2435, 1, 'Terapia del Lenguaje', 0, '', 20, '31', '2011-05-05', '06-93700001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'ALIANSALUD', 'LAURA ALEJANDRA MORALES CASTAÑEDA', '32834303', 'TRANSVERSAL 3H No 69', '2811408799', 0, '', 0, 0, 0, 0, 0, ''),
(2435, 2, 'Terapia física', 0, '', 20, '31', '2011-05-05', '06-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'ALIANSALUD', 'LAURA ALEJANDRA MORALES CASTAÑEDA', '32834303', 'TRANSVERSAL 3H No 69', '2811408799', 0, '', 0, 0, 0, 0, 0, ''),
(2435, 3, 'Terapia Respiratoria', 0, '', 12, '31', '2011-05-05', '06-93940001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'ALIANSALUD', 'LAURA ALEJANDRA MORALES CASTAÑEDA', '32834303', 'TRANSVERSAL 3H No 69', '2811408799', 0, '', 0, 0, 0, 0, 0, ''),
(2435, 4, 'Terapia Ocupacional', 0, '', 20, '31', '2011-05-05', '06-93830001', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'ALIANSALUD', 'LAURA ALEJANDRA MORALES CASTAÑEDA', '32834303', 'TRANSVERSAL 3H No 69', '2811408799', 0, '', 0, 0, 0, 0, 0, ''),
(2474, 1, 'Terapia física', 0, '', 10, '31', '2011-05-06', '06-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'ALIANSALUD', 'BEATRIZ AMALIA SANCHEZ RUBIO', '20103673', 'CALLE 149 No 4-59 MO', '2811412224', 0, '', 0, 0, 0, 0, 0, ''),
(2475, 1, 'CONSULTA MEDICA GENERAL', 0, '', 1, '31', '2011-05-06', '04-890101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 47250, 'COMPENSAR', 'ELVIA TULIA OSPINA', '24427830', 'CALLE 63 No 37-59', '11125216341', 8300, '', 0, 0, 0, 0, 0, ''),
(2476, 1, 'Terapia física', 0, '', 10, '31', '2011-05-06', '04-89021101', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 20500, 'COMPENSAR', 'MARIA DARY MALDONADO', '20524838', 'CALLE 21 No 91-50 AP', '', 0, '', 0, 0, 0, 0, 0, '');

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

-- 
-- Estructura de tabla para la tabla `Detalle2`
-- 

CREATE TABLE `Detalle2` (
  `No` int(8) NOT NULL,
  `Consec` int(2) NOT NULL,
  `Consec2` int(2) NOT NULL,
  `Requerimiento` varchar(70) NOT NULL,
  `Efectuado` int(1) NOT NULL,
  `Profesional` varchar(40) NOT NULL,
  `No_Cesiones` int(5) NOT NULL,
  `Tiempo` varchar(20) NOT NULL,
  `Fecha` date NOT NULL,
  `Cod_req` varchar(25) NOT NULL,
  `Cod_prof` varchar(12) NOT NULL,
  `Asignado` int(1) NOT NULL,
  `FechaE` datetime NOT NULL,
  `FechaE2` datetime NOT NULL,
  `Observa` text NOT NULL,
  `Subdividido` int(1) NOT NULL,
  `F_Gestión` int(2) NOT NULL,
  `Fallida` int(1) NOT NULL,
  `Tarifa` int(10) NOT NULL,
  `Entidad` varchar(30) NOT NULL,
  `Paciente` varchar(45) NOT NULL,
  `Cédula` varchar(45) NOT NULL,
  `Dirección` varchar(20) NOT NULL,
  `No_Autoriz` varchar(15) NOT NULL,
  `Vr_Copago` int(10) NOT NULL,
  `Eventos` text NOT NULL,
  `Turnos` int(1) NOT NULL,
  `Facturada` int(1) NOT NULL,
  `Tarificada` int(1) NOT NULL,
  `Teléfono` varchar(20) NOT NULL,
  KEY `No` (`No`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Detalle2`
-- 


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

-- 
-- Estructura de tabla para la tabla `Detalle3`
-- 

CREATE TABLE `Detalle3` (
  `Noe` int(10) NOT NULL AUTO_INCREMENT,
  `No_Cesión` int(2) NOT NULL,
  `No` int(8) NOT NULL,
  `Consec` int(2) NOT NULL,
  `Consec2` int(2) NOT NULL,
  `Requerimiento` varchar(70) NOT NULL,
  `Efectuado` int(1) NOT NULL,
  `Profesional` varchar(40) NOT NULL,
  `No_Cesiones` int(5) NOT NULL,
  `Tiempo` varchar(20) NOT NULL,
  `Fecha` date NOT NULL,
  `Cod_req` varchar(25) NOT NULL,
  `Cod_prof` varchar(12) NOT NULL,
  `Asignado` int(1) NOT NULL,
  `FechaE` datetime NOT NULL,
  `FechaE2` datetime NOT NULL,
  `Observa` text NOT NULL,
  `Subdividido` int(1) NOT NULL,
  `F_Gestión` int(2) NOT NULL,
  `Fallida` int(1) NOT NULL,
  `Tarifa` int(10) NOT NULL,
  `Entidad` varchar(30) NOT NULL,
  `Paciente` varchar(45) NOT NULL,
  `Cédula` varchar(45) NOT NULL,
  `Dirección` varchar(20) NOT NULL,
  `No_Autoriz` varchar(15) NOT NULL,
  `Vr_Copago` int(10) NOT NULL,
  `Eventos` text NOT NULL,
  `Turnos` int(1) NOT NULL,
  `Sistema` text NOT NULL,
  `Cod_Tarifa` varchar(15) NOT NULL,
  `Fechat` datetime NOT NULL,
  `Facturada` int(1) NOT NULL,
  `Tarificada` int(1) NOT NULL,
  `Teléfono` varchar(20) NOT NULL,
  KEY `Noe` (`Noe`)
) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 AUTO_INCREMENT=15 ;

-- 
-- Volcar la base de datos para la tabla `Detalle3`
-- 

INSERT INTO `Detalle3` (`Noe`, `No_Cesión`, `No`, `Consec`, `Consec2`, `Requerimiento`, `Efectuado`, `Profesional`, `No_Cesiones`, `Tiempo`, `Fecha`, `Cod_req`, `Cod_prof`, `Asignado`, `FechaE`, `FechaE2`, `Observa`, `Subdividido`, `F_Gestión`, `Fallida`, `Tarifa`, `Entidad`, `Paciente`, `Cédula`, `Dirección`, `No_Autoriz`, `Vr_Copago`, `Eventos`, `Turnos`, `Sistema`, `Cod_Tarifa`, `Fechat`, `Facturada`, `Tarificada`, `Teléfono`) VALUES (1, 1, 2436, 1, 0, 'Terapia Ocupacional', 0, 'MONTEALEGRE PASTRANA YULIETH', 4, '31', '2011-05-04', '04-93830001', '52165575', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'COMPENSAR', 'CARLOTA SALAZAR CRUZ', '20265119', 'CALLE 42G No 78L-35 ', '11109116234121', 2400, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '2642243'),
(2, 2, 2436, 1, 0, 'Terapia Ocupacional', 0, 'MONTEALEGRE PASTRANA YULIETH', 4, '31', '2011-05-04', '04-93830001', '52165575', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'COMPENSAR', 'CARLOTA SALAZAR CRUZ', '20265119', 'CALLE 42G No 78L-35 ', '11109116234121', 2400, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '2642243'),
(3, 3, 2436, 1, 0, 'Terapia Ocupacional', 0, 'MONTEALEGRE PASTRANA YULIETH', 4, '31', '2011-05-04', '04-93830001', '52165575', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'COMPENSAR', 'CARLOTA SALAZAR CRUZ', '20265119', 'CALLE 42G No 78L-35 ', '11109116234121', 2400, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '2642243'),
(4, 4, 2436, 1, 0, 'Terapia Ocupacional', 0, 'MONTEALEGRE PASTRANA YULIETH', 4, '31', '2011-05-04', '04-93830001', '52165575', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 22000, 'COMPENSAR', 'CARLOTA SALAZAR CRUZ', '20265119', 'CALLE 42G No 78L-35 ', '11109116234121', 2400, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '2642243'),
(5, 1, 2470, 3, 0, 'Terapia Ocupacional', 1, 'CHAPARRO ROJAS  CARMEN ELIANA', 10, '30', '2011-05-05', '04-93830001', '52267679', 1, '0000-00-00 00:00:00', '2011-05-03 00:00:00', '', 0, 0, 0, 34000, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '7868678'),
(6, 2, 2470, 3, 0, 'Terapia Ocupacional', 1, 'CHAPARRO ROJAS  CARMEN ELIANA', 10, '30', '2011-05-05', '04-93830001', '52267679', 1, '0000-00-00 00:00:00', '2011-05-06 00:00:00', '', 0, 0, 0, 34000, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '7868678'),
(7, 3, 2470, 3, 0, 'Terapia Ocupacional', 1, 'CHAPARRO ROJAS  CARMEN ELIANA', 10, '30', '2011-05-05', '04-93830001', '52267679', 1, '0000-00-00 00:00:00', '2011-05-05 00:00:00', '', 0, 0, 0, 34000, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '7868678'),
(8, 4, 2470, 3, 0, 'Terapia Ocupacional', 1, 'CHAPARRO ROJAS  CARMEN ELIANA', 10, '30', '2011-05-05', '04-93830001', '52267679', 1, '0000-00-00 00:00:00', '2011-05-10 00:00:00', '', 0, 0, 0, 34000, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '7868678'),
(9, 5, 2470, 3, 0, 'Terapia Ocupacional', 1, 'CHAPARRO ROJAS  CARMEN ELIANA', 10, '30', '2011-05-05', '04-93830001', '52267679', 1, '0000-00-00 00:00:00', '2011-05-06 00:00:00', '', 0, 0, 0, 34000, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '7868678'),
(10, 6, 2470, 3, 0, 'Terapia Ocupacional', 1, 'CHAPARRO ROJAS  CARMEN ELIANA', 10, '30', '2011-05-05', '04-93830001', '52267679', 1, '0000-00-00 00:00:00', '2011-05-10 00:00:00', '', 0, 0, 0, 34000, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '7868678'),
(11, 7, 2470, 3, 0, 'Terapia Ocupacional', 0, 'CHAPARRO ROJAS  CARMEN ELIANA', 10, '30', '2011-05-05', '04-93830001', '52267679', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 34000, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '7868678'),
(12, 8, 2470, 3, 0, 'Terapia Ocupacional', 0, 'CHAPARRO ROJAS  CARMEN ELIANA', 10, '30', '2011-05-05', '04-93830001', '52267679', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 34000, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '7868678'),
(13, 9, 2470, 3, 0, 'Terapia Ocupacional', 0, 'CHAPARRO ROJAS  CARMEN ELIANA', 10, '30', '2011-05-05', '04-93830001', '52267679', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 34000, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '7868678'),
(14, 10, 2470, 3, 0, 'Terapia Ocupacional', 0, 'CHAPARRO ROJAS  CARMEN ELIANA', 10, '30', '2011-05-05', '04-93830001', '52267679', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '', 0, 0, 0, 34000, 'COMPENSAR', 'hjghgjhgjhg', '876868', 'jhgjgjhg', '76567700099900', 0, '', 0, '', '', '0000-00-00 00:00:00', 0, 0, '7868678');

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

-- 
-- Estructura de tabla para la tabla `Detalle4`
-- 

CREATE TABLE `Detalle4` (
  `Noe2` int(10) NOT NULL,
  `Noe` int(10) NOT NULL AUTO_INCREMENT,
  `No_Cesión` int(2) NOT NULL,
  `No` int(8) NOT NULL,
  `Consec` int(2) NOT NULL,
  `Consec2` int(2) NOT NULL,
  `Requerimiento` varchar(70) NOT NULL,
  `Efectuado` int(1) NOT NULL,
  `Profesional` varchar(40) NOT NULL,
  `No_Cesiones` int(5) NOT NULL,
  `Tiempo` varchar(20) NOT NULL,
  `Fecha` date NOT NULL,
  `Cod_req` varchar(25) NOT NULL,
  `Cod_prof` varchar(12) NOT NULL,
  `Asignado` int(1) NOT NULL,
  `FechaE` datetime NOT NULL,
  `FechaE2` datetime NOT NULL,
  `Observa` text NOT NULL,
  `Subdividido` int(1) NOT NULL,
  `F_Gestión` int(2) NOT NULL,
  `Fallida` int(1) NOT NULL,
  `Tarifa` int(10) NOT NULL,
  `Entidad` varchar(30) NOT NULL,
  `Paciente` varchar(45) NOT NULL,
  `Cédula` varchar(45) NOT NULL,
  `Dirección` varchar(20) NOT NULL,
  `No_Autoriz` varchar(15) NOT NULL,
  `Vr_Copago` int(10) NOT NULL,
  `Eventos` text NOT NULL,
  `Turnos` int(1) NOT NULL,
  `Cod_Tarifa` varchar(15) NOT NULL,
  `Fechat` datetime NOT NULL,
  `Sistema` text NOT NULL,
  `Horas` int(11) NOT NULL,
  `Tarifa1` int(11) NOT NULL,
  `Facturada` int(11) NOT NULL,
  `Tarificada` int(1) NOT NULL,
  `Teléfono` varchar(20) NOT NULL,
  KEY `Noe` (`Noe`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Volcar la base de datos para la tabla `Detalle4`
-- 


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

-- 
-- Estructura de tabla para la tabla `Dosis`
-- 

CREATE TABLE `Dosis` (
  `No` int(5) NOT NULL,
  `Còdigo` varchar(15) NOT NULL,
  `Nombre` varchar(35) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Dosis`
-- 


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

-- 
-- Estructura de tabla para la tabla `Empresas`
-- 

CREATE TABLE `Empresas` (
  `No` int(4) NOT NULL,
  `Nombre` varchar(40) NOT NULL,
  `Valor` int(10) NOT NULL,
  `Total` int(10) NOT NULL,
  `Nom` varchar(40) NOT NULL,
  `Dir` varchar(50) NOT NULL,
  `Tel` varchar(20) NOT NULL,
  `Nit` varchar(12) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Empresas`
-- 

INSERT INTO `Empresas` (`No`, `Nombre`, `Valor`, `Total`, `Nom`, `Dir`, `Tel`, `Nit`) VALUES (2, 'SANITAS', 0, 0, '', '', '', ''),
(3, 'UNISALUD', 0, 0, '', '', '', ''),
(4, 'COMPENSAR', 0, 0, 'Compensar S.A.', 'Cra 23 No 45-66', '2 34 54 67 ', ''),
(5, 'SOLEC', 0, 0, '', '', '', ''),
(6, 'ALIANSALUD', 0, 0, '', '', '', ''),
(8, 'LIBERTY', 0, 0, '', '', '', ''),
(9, 'ARP COLMENA', 0, 0, '', '', '', ''),
(10, 'ALICO COLOMBIA', 0, 0, '', '', '', ''),
(11, 'SOLSALUD', 0, 0, '', '', '', ''),
(12, 'SAN IGNACIO', 0, 0, '', '', '', ''),
(13, 'POSITIVA', 0, 0, '', '', '', '');

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

-- 
-- Estructura de tabla para la tabla `Enfermera`
-- 

CREATE TABLE `Enfermera` (
  `No` int(10) NOT NULL AUTO_INCREMENT,
  `Os` int(10) NOT NULL,
  `Fechai` datetime NOT NULL,
  `Fechaf` datetime NOT NULL,
  `Tipo` varchar(40) NOT NULL,
  `No_Ces` int(4) NOT NULL,
  `Observa` text NOT NULL,
  `Cod_req` varchar(12) NOT NULL,
  PRIMARY KEY (`No`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- 
-- Volcar la base de datos para la tabla `Enfermera`
-- 


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

-- 
-- Estructura de tabla para la tabla `Entidad`
-- 

CREATE TABLE `Entidad` (
  `No` int(10) NOT NULL AUTO_INCREMENT,
  `Entidad` varchar(20) NOT NULL,
  `Código` varchar(15) NOT NULL,
  `Nombre` varchar(50) NOT NULL,
  `Servicio` varchar(100) NOT NULL,
  `T_Pac` int(10) NOT NULL,
  `T_Pos` int(10) NOT NULL,
  `Fusa` int(10) NOT NULL,
  KEY `No` (`No`)
) ENGINE=MyISAM AUTO_INCREMENT=735 DEFAULT CHARSET=utf8 AUTO_INCREMENT=735 ;

-- 
-- Volcar la base de datos para la tabla `Entidad`
-- 

INSERT INTO `Entidad` (`No`, `Entidad`, `Código`, `Nombre`, `Servicio`, `T_Pac`, `T_Pos`, `Fusa`) VALUES (1, '', '', 'FAMISANAR ', '', 0, 0, 0),
(2, 'Entidad', 'Codigo', 'TARIFAS', 'TARIFAS PAC', 0, 0, 0),
(1, 'FAMISANAR ', '6546', 'ALQUILER DIARIO DE PULSOXIMETRO', ' $ 11,646 ', 0, 0, 0),
(2, 'FAMISANAR ', '65654', 'ALQUILER SUCCIONADOR DIARIO', ' $ 5,594 ', 0, 0, 0),
(3, 'FAMISANAR', '654', 'APLICACIÓN MEDICAMENTOS PARENTERAL 1 DOSIS', '$ 25,757', 0, 0, 0),
(4, 'FAMISANAR', '6546', 'APLICACIÓN MEDICAMENTOS PARENTERAL 2 DOSIS', '$ 49,203', 0, 0, 0),
(5, 'vcxvcxv', 'ddddd', 'vfggCCXZ CZX ccc', 'fdfdsfds', 0, 0, 0),
(6, 'FAvvvvvv', 'fdfdsfdsfdsfds', 'gfgfdgdfg MEDICAMENTOS PARENTERAL 4 DOSIS', 'fdf CXZC', 0, 0, 0),
(7, 'FAMISANAR', '434234', 'APLICACIÓN MEDICAMENTOS PARENTERAL 5 DOSIS', '4324324324', 43432, 43, 44444),
(8, 'FAMISANAR', '54655', 'APLICACIÓN MEDICAMENTOS PARENTERAL 6  O MAS DOSIS', '$ 110,000', 0, 0, 0),
(9, 'FAMISANAR', '', 'ASISTENCIA ENFERMERIA PROFESIONAL (VISITA PUNTUAL)', '$ 23,988', 0, 0, 0),
(10, 'FAMISANAR', '', 'AUXILIAR DE ENFERMERIA 3 HORAS', '$ 21,955', 0, 0, 0),
(11, 'FAMISANAR', '', 'AUXILIAR DE ENFERMERIA 6 HORAS NOCTURNO FESTIVO', 'N.A', 0, 0, 0),
(12, 'FAMISANAR', '', 'AUXILIAR DE ENFERMERIA 6 HORAS', '$ 28,560', 0, 0, 0),
(13, 'FAMISANAR', '', 'AUXILIAR DE ENFERMERIA POR 12 HORAS', '$ 50,270', 0, 0, 0),
(14, 'FAMISANAR', '', 'AUXILIAR DE ENFERMERIA POR 12 HORAS NOCTURNA', '$ 56,430', 0, 0, 0),
(15, 'FAMISANAR', '', 'AUXILIAR DE ENFERMERIA POR 24 HORAS /ORDINARIO', '$ 106,700', 0, 0, 0),
(16, 'FAMISANAR', '', 'AUXILIAR DE ENFERMERIA POR 24 HORAS / FESTIVOS', 'N.A', 0, 0, 0),
(17, 'FAMISANAR', '', 'AUXILIAR DE ENFERMERIA POR 8 HORAS', '$ 38,201', 0, 0, 0),
(18, 'FAMISANAR', '', 'AUXILIAR DE ENFERMERIA POR 8 HORAS NOCTURNO/FESTIV', '$ 42,060', 0, 0, 0),
(19, 'FAMISANAR', '', 'CONSULTA MEDICA ESPECIALIZADA DOMICILIARIA PROGRAM', '$ 63,600', 0, 0, 0),
(20, 'FAMISANAR', '', 'CONSULTA MEDICINA GENERAL DOMICILIARIA PROGRAMADA', '$ 40,877', 0, 0, 0),
(21, 'FAMISANAR', '', 'CURACION ALTA COMPLEJIDAD', '$ 53,785', 0, 0, 0),
(22, 'FAMISANAR', '', 'CURACION BAJA COMPLEJIDAD', '$ 22,590', 0, 0, 0),
(23, 'FAMISANAR', '', 'CURACION MEDICNA COMPLEJIDAD', '$ 33,347', 0, 0, 0),
(24, 'FAMISANAR', '', 'EQUIPO PATROL CON BOLSA O PUNZON PARA BOMBA ENTERA', '$ 41,000', 0, 0, 0),
(25, 'FAMISANAR', '', 'EQUIPO SET PARA BOMBA DE INFUSION', '$ 28,721', 0, 0, 0),
(26, 'FAMISANAR', '', 'INSERCION DE CATETER URINARIO', '$ 38,276', 0, 0, 0),
(27, 'FAMISANAR', '', 'INSUMOS CURACION ALTA COMPLEJIDAD', '$ 35,498', 0, 0, 0),
(28, 'FAMISANAR', '', 'INSUMOS CURACION MEDIANA COMPLEJIDAD', '$ 13,984', 0, 0, 0),
(29, 'FAMISANAR', '', 'INSUMOS PACIENTES CON GASTROSTOMIA POR DIA', '$ 3,679', 0, 0, 0),
(30, 'FAMISANAR', '', 'INSUMOS PACIENTES CON TRAQUEOSTOMIA POR DIA', '$ 5,024', 0, 0, 0),
(31, 'FAMISANAR', '', 'INSUMOS PACIENTES PARA CATETERISMO VESICAL DIA', '$ 20,438', 0, 0, 0),
(32, 'FAMISANAR', '', 'INSUMOS POR DOSIS DE MEDICAMENTO PARENTERAL', '$ 5,500', 0, 0, 0),
(33, 'FAMISANAR', '', 'SESION NUTRICION', '$ 30,120', 0, 0, 0),
(34, 'FAMISANAR', '', 'SESION PSICOLOGIA', '$ 27,968', 0, 0, 0),
(35, 'FAMISANAR', '', 'TERAPIA DE LENGUAJE POR SESION', '$ 19,363', 0, 0, 0),
(36, 'FAMISANAR', '', 'TERAPIA DE LENGUAJE POR SESION/NOCHE', 'N.A', 0, 0, 0),
(37, 'FAMISANAR', '', 'TERAPIA FÍSICA POR SESION', '$ 19,363', 0, 0, 0),
(38, 'FAMISANAR', '', 'TERAPIA FÍSICA POR SESION/NOCHE', 'N.A', 0, 0, 0),
(39, 'FAMISANAR', '', 'TERAPIA OCUPACIONAL POR SESION', '$ 19,363', 0, 0, 0),
(40, 'FAMISANAR', '', 'TERAPIA OCUPACIONAL POR SESION/NOCHE', 'N.A', 0, 0, 0),
(41, 'FAMISANAR', '', 'TERAPIA RESPIRATORIA CON SUCCION POR SESION', '$ 30,120', 0, 0, 0),
(42, 'FAMISANAR', '', 'TERAPIA RESPIRATORIA POR SESION', '$ 22,590', 0, 0, 0),
(43, 'FAMISANAR', '', 'TERAPIA RESPIRATORIA POR SESION/NOCHE', 'N.A', 0, 0, 0),
(44, 'FAMISANAR', '', 'GLUCOMETRIA', 'N.A', 0, 0, 0),
(45, 'FAMISANAR', '', 'PULSO-OXIMETRIA', 'N.A', 0, 0, 0),
(46, 'FAMISANAR', '', 'HOSPITALIZACION UNIDAD 30 DIAS', 'N.A', 0, 0, 0),
(47, 'FAMISANAR', '', 'HOSPITALIZACION UNIDAD 1 DIA', 'N.A', 0, 0, 0),
(48, '', '', '', '', 0, 0, 0),
(49, '', '', '', '', 0, 0, 0),
(50, '', '', '', '', 0, 0, 0),
(51, '', '', '', '', 0, 0, 0),
(52, '', '', '', '', 0, 0, 0),
(53, '', '', '', '', 0, 0, 0),
(54, '', '', '', '', 0, 0, 0),
(55, '', '', '', '', 0, 0, 0),
(56, '', '', '', '', 0, 0, 0),
(57, '', '', '', '', 0, 0, 0),
(58, '', '', '', '', 0, 0, 0),
(59, '', '', '', '', 0, 0, 0),
(60, '', '', '', '', 0, 0, 0),
(61, '', '', '', '', 0, 0, 0),
(62, '', '', '', '', 0, 0, 0),
(63, '', '', '', '', 0, 0, 0),
(64, '', '', '', '', 0, 0, 0),
(65, '', '', '', '', 0, 0, 0),
(66, '', '', '', '', 0, 0, 0),
(67, '', '', '', '', 0, 0, 0),
(68, '', '', '', '', 0, 0, 0),
(69, '', '', '', '', 0, 0, 0),
(70, '', '', '', '', 0, 0, 0),
(71, '', '', '', '', 0, 0, 0),
(72, '', '', '', '', 0, 0, 0),
(73, '', '', '', '', 0, 0, 0),
(74, '', '', '', '', 0, 0, 0),
(75, '', '', '', '', 0, 0, 0),
(76, '', '', '', '', 0, 0, 0),
(77, '', '', '', '', 0, 0, 0),
(78, '', '', '', '', 0, 0, 0),
(79, '', '', '', '', 0, 0, 0),
(80, '', '', '', '', 0, 0, 0),
(81, '', '', '', '', 0, 0, 0),
(82, '', '', '', '', 0, 0, 0),
(83, '', '', '', '', 0, 0, 0),
(84, '', '', '', '', 0, 0, 0),
(85, '', '', '', '', 0, 0, 0),
(86, '', '', '', '', 0, 0, 0),
(87, '', '', '', '', 0, 0, 0),
(88, '', '', '', '', 0, 0, 0),
(89, '', '', '', '', 0, 0, 0),
(90, '', '', '', '', 0, 0, 0),
(91, '', '', '', '', 0, 0, 0),
(92, '', '', '', '', 0, 0, 0),
(93, '', '', '', '', 0, 0, 0),
(94, '', '', '', '', 0, 0, 0),
(95, '', '', '', '', 0, 0, 0),
(96, '', '', '', '', 0, 0, 0),
(97, '', '', '', '', 0, 0, 0),
(98, '', '', '', '', 0, 0, 0),
(99, '', '', '', '', 0, 0, 0),
(100, '', '', '', '', 0, 0, 0),
(101, '', '', '', '', 0, 0, 0),
(102, '', '', '', '', 0, 0, 0),
(103, '', '', '', '', 0, 0, 0),
(104, '', '', '', '', 0, 0, 0),
(105, '', '', '', '', 0, 0, 0),
(106, '', '', '', '', 0, 0, 0),
(107, '', '', '', '', 0, 0, 0),
(108, '', '', '', '', 0, 0, 0),
(109, '', '', '', '', 0, 0, 0),
(110, '', '', '', '', 0, 0, 0),
(111, '', '', '', '', 0, 0, 0),
(112, '', '', '', '', 0, 0, 0),
(113, '', '', '', '', 0, 0, 0),
(114, '', '', '', '', 0, 0, 0),
(115, '', '', '', '', 0, 0, 0),
(116, '', '', '', '', 0, 0, 0),
(117, '', '', '', '', 0, 0, 0),
(118, '', '', '', '', 0, 0, 0),
(119, '', '', '', '', 0, 0, 0),
(120, '', '', '', '', 0, 0, 0),
(121, '', '', '', '', 0, 0, 0),
(122, '', '', '', '', 0, 0, 0),
(123, '', '', '', '', 0, 0, 0),
(124, '', '', '', '', 0, 0, 0),
(125, '', '', '', '', 0, 0, 0),
(126, '', '', '', '', 0, 0, 0),
(127, '', '', '', '', 0, 0, 0),
(128, '', '', '', '', 0, 0, 0),
(129, '', '', '', '', 0, 0, 0),
(130, '', '', '', '', 0, 0, 0),
(131, '', '', '', '', 0, 0, 0),
(132, '', '', '', '', 0, 0, 0),
(133, '', '', '', '', 0, 0, 0),
(134, '', '', '', '', 0, 0, 0),
(135, '', '', '', '', 0, 0, 0),
(136, '', '', '', '', 0, 0, 0),
(137, '', '', '', '', 0, 0, 0),
(138, '', '', '', '', 0, 0, 0),
(139, '', '', '', '', 0, 0, 0),
(140, '', '', '', '', 0, 0, 0),
(141, '', '', '', '', 0, 0, 0),
(142, '', '', '', '', 0, 0, 0),
(143, '', '', '', '', 0, 0, 0),
(144, '', '', '', '', 0, 0, 0),
(145, '', '', '', '', 0, 0, 0),
(146, '', '', '', '', 0, 0, 0),
(147, '', '', '', '', 0, 0, 0),
(148, '', '', '', '', 0, 0, 0),
(149, '', '', '', '', 0, 0, 0),
(150, '', '', '', '', 0, 0, 0),
(151, '', '', '', '', 0, 0, 0),
(152, '', '', '', '', 0, 0, 0),
(153, '', '', '', '', 0, 0, 0),
(154, '', '', '', '', 0, 0, 0),
(155, '', '', '', '', 0, 0, 0),
(156, '', '', '', '', 0, 0, 0),
(157, '', '', '', '', 0, 0, 0),
(158, '', '', '', '', 0, 0, 0),
(159, '', '', '', '', 0, 0, 0),
(160, '', '', '', '', 0, 0, 0),
(161, '', '', '', '', 0, 0, 0),
(162, '', '', '', '', 0, 0, 0),
(163, '', '', '', '', 0, 0, 0),
(164, '', '', '', '', 0, 0, 0),
(165, '', '', '', '', 0, 0, 0),
(166, '', '', '', '', 0, 0, 0),
(167, '', '', '', '', 0, 0, 0),
(168, '', '', '', '', 0, 0, 0),
(169, '', '', '', '', 0, 0, 0),
(170, '', '', '', '', 0, 0, 0),
(171, '', '', '', '', 0, 0, 0),
(172, '', '', '', '', 0, 0, 0),
(173, '', '', '', '', 0, 0, 0),
(174, '', '', '', '', 0, 0, 0),
(175, '', '', '', '', 0, 0, 0),
(176, '', '', '', '', 0, 0, 0),
(177, '', '', '', '', 0, 0, 0),
(178, '', '', '', '', 0, 0, 0),
(179, '', '', '', '', 0, 0, 0),
(180, '', '', '', '', 0, 0, 0),
(181, '', '', '', '', 0, 0, 0),
(182, '', '', '', '', 0, 0, 0),
(183, '', '', '', '', 0, 0, 0),
(184, '', '', '', '', 0, 0, 0),
(185, '', '', '', '', 0, 0, 0),
(186, '', '', '', '', 0, 0, 0),
(187, '', '', '', '', 0, 0, 0),
(188, '', '', '', '', 0, 0, 0),
(189, '', '', '', '', 0, 0, 0),
(190, '', '', '', '', 0, 0, 0),
(191, '', '', '', '', 0, 0, 0),
(192, '', '', '', '', 0, 0, 0),
(193, '', '', '', '', 0, 0, 0),
(194, '', '', '', '', 0, 0, 0),
(195, '', '', '', '', 0, 0, 0),
(196, '', '', '', '', 0, 0, 0),
(197, '', '', '', '', 0, 0, 0),
(198, '', '', '', '', 0, 0, 0),
(199, '', '', '', '', 0, 0, 0),
(200, '', '', '', '', 0, 0, 0),
(201, '', '', '', '', 0, 0, 0),
(202, '', '', '', '', 0, 0, 0),
(203, '', '', '', '', 0, 0, 0),
(204, '', '', '', '', 0, 0, 0),
(205, '', '', '', '', 0, 0, 0),
(206, '', '', '', '', 0, 0, 0),
(207, '', '', '', '', 0, 0, 0),
(208, '', '', '', '', 0, 0, 0),
(209, '', '', '', '', 0, 0, 0),
(210, '', '', '', '', 0, 0, 0),
(211, '', '', '', '', 0, 0, 0),
(212, '', '', '', '', 0, 0, 0),
(213, '', '', '', '', 0, 0, 0),
(214, '', '', '', '', 0, 0, 0),
(215, '', '', '', '', 0, 0, 0),
(216, '', '', '', '', 0, 0, 0),
(217, '', '', '', '', 0, 0, 0),
(218, '', '', '', '', 0, 0, 0),
(219, '', '', '', '', 0, 0, 0),
(220, '', '', '', '', 0, 0, 0),
(221, '', '', '', '', 0, 0, 0),
(222, '', '', '', '', 0, 0, 0),
(223, '', '', '', '', 0, 0, 0),
(224, '', '', '', '', 0, 0, 0),
(225, '', '', '', '', 0, 0, 0),
(226, '', '', '', '', 0, 0, 0),
(227, '', '', '', '', 0, 0, 0),
(228, '', '', '', '', 0, 0, 0),
(229, '', '', '', '', 0, 0, 0),
(230, '', '', '', '', 0, 0, 0),
(231, '', '', '', '', 0, 0, 0),
(232, '', '', '', '', 0, 0, 0),
(233, '', '', '', '', 0, 0, 0),
(234, '', '', '', '', 0, 0, 0),
(235, '', '', '', '', 0, 0, 0),
(236, '', '', '', '', 0, 0, 0),
(237, '', '', '', '', 0, 0, 0),
(238, '', '', '', '', 0, 0, 0),
(239, '', '', '', '', 0, 0, 0),
(240, '', '', '', '', 0, 0, 0),
(241, '', '', '', '', 0, 0, 0),
(242, '', '', '', '', 0, 0, 0),
(243, '', '', '', '', 0, 0, 0),
(244, '', '', '', '', 0, 0, 0),
(245, '', '', '', '', 0, 0, 0),
(246, '', '', '', '', 0, 0, 0),
(247, '', '', '', '', 0, 0, 0),
(248, '', '', '', '', 0, 0, 0),
(249, '', '', '', '', 0, 0, 0),
(250, '', '', '', '', 0, 0, 0),
(251, '', '', '', '', 0, 0, 0),
(252, '', '', '', '', 0, 0, 0),
(253, '', '', '', '', 0, 0, 0),
(254, '', '', '', '', 0, 0, 0),
(255, '', '', '', '', 0, 0, 0),
(256, '', '', '', '', 0, 0, 0),
(257, '', '', '', '', 0, 0, 0),
(258, '', '', '', '', 0, 0, 0),
(259, '', '', '', '', 0, 0, 0),
(260, '', '', '', '', 0, 0, 0),
(261, '', '', '', '', 0, 0, 0),
(262, '', '', '', '', 0, 0, 0),
(263, '', '', '', '', 0, 0, 0),
(264, '', '', '', '', 0, 0, 0),
(265, '', '', '', '', 0, 0, 0),
(266, '', '', '', '', 0, 0, 0),
(267, '', '', '', '', 0, 0, 0),
(268, '', '', '', '', 0, 0, 0),
(269, '', '', '', '', 0, 0, 0),
(270, '', '', '', '', 0, 0, 0),
(271, '', '', '', '', 0, 0, 0),
(272, '', '', '', '', 0, 0, 0),
(273, '', '', '', '', 0, 0, 0),
(274, '', '', '', '', 0, 0, 0),
(275, '', '', '', '', 0, 0, 0),
(276, '', '', '', '', 0, 0, 0),
(277, '', '', '', '', 0, 0, 0),
(278, '', '', '', '', 0, 0, 0),
(279, '', '', '', '', 0, 0, 0),
(280, '', '', '', '', 0, 0, 0),
(281, '', '', '', '', 0, 0, 0),
(282, '', '', '', '', 0, 0, 0),
(283, '', '', '', '', 0, 0, 0),
(284, '', '', '', '', 0, 0, 0),
(285, '', '', '', '', 0, 0, 0),
(286, '', '', '', '', 0, 0, 0),
(287, '', '', '', '', 0, 0, 0),
(288, '', '', '', '', 0, 0, 0),
(289, '', '', '', '', 0, 0, 0),
(290, '', '', '', '', 0, 0, 0),
(291, '', '', '', '', 0, 0, 0),
(292, '', '', '', '', 0, 0, 0),
(293, '', '', '', '', 0, 0, 0),
(294, '', '', '', '', 0, 0, 0),
(295, '', '', '', '', 0, 0, 0),
(296, '', '', '', '', 0, 0, 0),
(297, '', '', '', '', 0, 0, 0),
(298, '', '', '', '', 0, 0, 0),
(299, '', '', '', '', 0, 0, 0),
(300, '', '', '', '', 0, 0, 0),
(301, '', '', '', '', 0, 0, 0),
(302, '', '', '', '', 0, 0, 0),
(303, '', '', '', '', 0, 0, 0),
(304, '', '', '', '', 0, 0, 0),
(305, '', '', '', '', 0, 0, 0),
(306, '', '', '', '', 0, 0, 0),
(307, '', '', '', '', 0, 0, 0),
(308, '', '', '', '', 0, 0, 0),
(309, '', '', '', '', 0, 0, 0),
(310, '', '', '', '', 0, 0, 0),
(311, '', '', '', '', 0, 0, 0),
(312, '', '', '', '', 0, 0, 0),
(313, '', '', '', '', 0, 0, 0),
(314, '', '', '', '', 0, 0, 0),
(315, '', '', '', '', 0, 0, 0),
(316, '', '', '', '', 0, 0, 0),
(317, '', '', '', '', 0, 0, 0),
(318, '', '', '', '', 0, 0, 0),
(319, '', '', '', '', 0, 0, 0),
(320, '', '', '', '', 0, 0, 0),
(321, '', '', '', '', 0, 0, 0),
(322, '', '', '', '', 0, 0, 0),
(323, '', '', '', '', 0, 0, 0),
(324, '', '', '', '', 0, 0, 0),
(325, '', '', '', '', 0, 0, 0),
(326, '', '', '', '', 0, 0, 0),
(327, '', '', '', '', 0, 0, 0),
(328, '', '', '', '', 0, 0, 0),
(329, '', '', '', '', 0, 0, 0),
(330, '', '', '', '', 0, 0, 0),
(331, '', '', '', '', 0, 0, 0),
(332, '', '', '', '', 0, 0, 0),
(333, '', '', '', '', 0, 0, 0),
(334, '', '', '', '', 0, 0, 0),
(335, '', '', '', '', 0, 0, 0),
(336, '', '', '', '', 0, 0, 0),
(337, '', '', '', '', 0, 0, 0),
(338, '', '', '', '', 0, 0, 0),
(339, '', '', '', '', 0, 0, 0),
(340, '', '', '', '', 0, 0, 0),
(341, '', '', '', '', 0, 0, 0),
(342, '', '', '', '', 0, 0, 0),
(343, '', '', '', '', 0, 0, 0),
(344, '', '', '', '', 0, 0, 0),
(345, '', '', '', '', 0, 0, 0),
(346, '', '', '', '', 0, 0, 0),
(347, '', '', '', '', 0, 0, 0),
(348, '', '', '', '', 0, 0, 0),
(349, '', '', '', '', 0, 0, 0),
(350, '', '', '', '', 0, 0, 0),
(351, '', '', '', '', 0, 0, 0),
(352, '', '', '', '', 0, 0, 0),
(353, '', '', '', '', 0, 0, 0),
(354, '', '', '', '', 0, 0, 0),
(355, '', '', '', '', 0, 0, 0),
(356, '', '', '', '', 0, 0, 0),
(357, '', '', '', '', 0, 0, 0),
(358, '', '', '', '', 0, 0, 0),
(359, '', '', '', '', 0, 0, 0),
(360, '', '', '', '', 0, 0, 0),
(361, '', '', '', '', 0, 0, 0),
(362, '', '', '', '', 0, 0, 0),
(363, '', '', '', '', 0, 0, 0),
(364, '', '', '', '', 0, 0, 0),
(365, '', '', '', '', 0, 0, 0),
(366, '', '', '', '', 0, 0, 0),
(367, '', '', '', '', 0, 0, 0),
(368, '', '', '', '', 0, 0, 0),
(369, '', '', '', '', 0, 0, 0),
(370, '', '', '', '', 0, 0, 0),
(371, '', '', '', '', 0, 0, 0),
(372, '', '', '', '', 0, 0, 0),
(373, '', '', '', '', 0, 0, 0),
(374, '', '', '', '', 0, 0, 0),
(375, '', '', '', '', 0, 0, 0),
(376, '', '', '', '', 0, 0, 0),
(377, '', '', '', '', 0, 0, 0),
(378, '', '', '', '', 0, 0, 0),
(379, '', '', '', '', 0, 0, 0),
(380, '', '', '', '', 0, 0, 0),
(381, '', '', '', '', 0, 0, 0),
(382, '', '', '', '', 0, 0, 0),
(383, '', '', '', '', 0, 0, 0),
(384, '', '', '', '', 0, 0, 0),
(385, '', '', '', '', 0, 0, 0),
(386, '', '', '', '', 0, 0, 0),
(387, '', '', '', '', 0, 0, 0),
(388, '', '', '', '', 0, 0, 0),
(389, '', '', '', '', 0, 0, 0),
(390, '', '', '', '', 0, 0, 0),
(391, '', '', '', '', 0, 0, 0),
(392, '', '', '', '', 0, 0, 0),
(393, '', '', '', '', 0, 0, 0),
(394, '', '', '', '', 0, 0, 0),
(395, '', '', '', '', 0, 0, 0),
(396, '', '', '', '', 0, 0, 0),
(397, '', '', '', '', 0, 0, 0),
(398, '', '', '', '', 0, 0, 0),
(399, '', '', '', '', 0, 0, 0),
(400, '', '', '', '', 0, 0, 0),
(401, '', '', '', '', 0, 0, 0),
(402, '', '', '', '', 0, 0, 0),
(403, '', '', '', '', 0, 0, 0),
(404, '', '', '', '', 0, 0, 0),
(405, '', '', '', '', 0, 0, 0),
(406, '', '', '', '', 0, 0, 0),
(407, '', '', '', '', 0, 0, 0),
(408, '', '', '', '', 0, 0, 0),
(409, '', '', '', '', 0, 0, 0),
(410, '', '', '', '', 0, 0, 0),
(411, '', '', '', '', 0, 0, 0),
(412, '', '', '', '', 0, 0, 0),
(413, '', '', '', '', 0, 0, 0),
(414, '', '', '', '', 0, 0, 0),
(415, '', '', '', '', 0, 0, 0),
(416, '', '', '', '', 0, 0, 0),
(417, '', '', '', '', 0, 0, 0),
(418, '', '', '', '', 0, 0, 0),
(419, '', '', '', '', 0, 0, 0),
(420, '', '', '', '', 0, 0, 0),
(421, '', '', '', '', 0, 0, 0),
(422, '', '', '', '', 0, 0, 0),
(423, '', '', '', '', 0, 0, 0),
(424, '', '', '', '', 0, 0, 0),
(425, '', '', '', '', 0, 0, 0),
(426, '', '', '', '', 0, 0, 0),
(427, '', '', '', '', 0, 0, 0),
(428, '', '', '', '', 0, 0, 0),
(429, '', '', '', '', 0, 0, 0),
(430, '', '', '', '', 0, 0, 0),
(431, '', '', '', '', 0, 0, 0),
(432, '', '', '', '', 0, 0, 0),
(433, '', '', '', '', 0, 0, 0),
(434, '', '', '', '', 0, 0, 0),
(435, '', '', '', '', 0, 0, 0),
(436, '', '', '', '', 0, 0, 0),
(437, '', '', '', '', 0, 0, 0),
(438, '', '', '', '', 0, 0, 0),
(439, '', '', '', '', 0, 0, 0),
(440, '', '', '', '', 0, 0, 0),
(441, '', '', '', '', 0, 0, 0),
(442, '', '', '', '', 0, 0, 0),
(443, '', '', '', '', 0, 0, 0),
(444, '', '', '', '', 0, 0, 0),
(445, '', '', '', '', 0, 0, 0),
(446, '', '', '', '', 0, 0, 0),
(447, '', '', '', '', 0, 0, 0),
(448, '', '', '', '', 0, 0, 0),
(449, '', '', '', '', 0, 0, 0),
(450, '', '', '', '', 0, 0, 0),
(451, '', '', '', '', 0, 0, 0),
(452, '', '', '', '', 0, 0, 0),
(453, '', '', '', '', 0, 0, 0),
(454, '', '', '', '', 0, 0, 0),
(455, '', '', '', '', 0, 0, 0),
(456, '', '', '', '', 0, 0, 0),
(457, '', '', '', '', 0, 0, 0),
(458, '', '', '', '', 0, 0, 0),
(459, '', '', '', '', 0, 0, 0),
(460, '', '', '', '', 0, 0, 0),
(461, '', '', '', '', 0, 0, 0),
(462, '', '', '', '', 0, 0, 0),
(463, '', '', '', '', 0, 0, 0),
(464, '', '', '', '', 0, 0, 0),
(465, '', '', '', '', 0, 0, 0),
(466, '', '', '', '', 0, 0, 0),
(467, '', '', '', '', 0, 0, 0),
(468, '', '', '', '', 0, 0, 0),
(469, '', '', '', '', 0, 0, 0),
(470, '', '', '', '', 0, 0, 0),
(471, '', '', '', '', 0, 0, 0),
(472, '', '', '', '', 0, 0, 0),
(473, '', '', '', '', 0, 0, 0),
(474, '', '', '', '', 0, 0, 0),
(475, '', '', '', '', 0, 0, 0),
(476, '', '', '', '', 0, 0, 0),
(477, '', '', '', '', 0, 0, 0),
(478, '', '', '', '', 0, 0, 0),
(479, '', '', '', '', 0, 0, 0),
(480, '', '', '', '', 0, 0, 0),
(481, '', '', '', '', 0, 0, 0),
(482, '', '', '', '', 0, 0, 0),
(483, '', '', '', '', 0, 0, 0),
(484, '', '', '', '', 0, 0, 0),
(485, '', '', '', '', 0, 0, 0),
(486, '', '', '', '', 0, 0, 0),
(487, '', '', '', '', 0, 0, 0),
(488, '', '', '', '', 0, 0, 0),
(489, '', '', '', '', 0, 0, 0),
(490, '', '', '', '', 0, 0, 0),
(491, '', '', '', '', 0, 0, 0),
(492, '', '', '', '', 0, 0, 0),
(493, '', '', '', '', 0, 0, 0),
(494, '', '', '', '', 0, 0, 0),
(495, '', '', '', '', 0, 0, 0),
(496, '', '', '', '', 0, 0, 0),
(497, '', '', '', '', 0, 0, 0),
(498, '', '', '', '', 0, 0, 0),
(499, '', '', '', '', 0, 0, 0),
(500, '', '', '', '', 0, 0, 0),
(501, '', '', '', '', 0, 0, 0),
(502, '', '', '', '', 0, 0, 0),
(503, '', '', '', '', 0, 0, 0),
(504, '', '', '', '', 0, 0, 0),
(505, '', '', '', '', 0, 0, 0),
(506, '', '', '', '', 0, 0, 0),
(507, '', '', '', '', 0, 0, 0),
(508, '', '', '', '', 0, 0, 0),
(509, '', '', '', '', 0, 0, 0),
(510, '', '', '', '', 0, 0, 0),
(511, '', '', '', '', 0, 0, 0),
(512, '', '', '', '', 0, 0, 0),
(513, '', '', '', '', 0, 0, 0),
(514, '', '', '', '', 0, 0, 0),
(515, '', '', '', '', 0, 0, 0),
(516, '', '', '', '', 0, 0, 0),
(517, '', '', '', '', 0, 0, 0),
(518, '', '', '', '', 0, 0, 0),
(519, '', '', '', '', 0, 0, 0),
(520, '', '', '', '', 0, 0, 0),
(521, '', '', '', '', 0, 0, 0),
(522, '', '', '', '', 0, 0, 0),
(523, '', '', '', '', 0, 0, 0),
(524, '', '', '', '', 0, 0, 0),
(525, '', '', '', '', 0, 0, 0),
(526, '', '', '', '', 0, 0, 0),
(527, '', '', '', '', 0, 0, 0),
(528, '', '', '', '', 0, 0, 0),
(529, '', '', '', '', 0, 0, 0),
(530, '', '', '', '', 0, 0, 0),
(531, '', '', '', '', 0, 0, 0),
(532, '', '', '', '', 0, 0, 0),
(533, '', '', '', '', 0, 0, 0),
(534, '', '', '', '', 0, 0, 0),
(535, '', '', '', '', 0, 0, 0),
(536, '', '', '', '', 0, 0, 0),
(537, '', '', '', '', 0, 0, 0),
(538, '', '', '', '', 0, 0, 0),
(539, '', '', '', '', 0, 0, 0),
(540, '', '', '', '', 0, 0, 0),
(541, '', '', '', '', 0, 0, 0),
(542, '', '', '', '', 0, 0, 0),
(543, '', '', '', '', 0, 0, 0),
(544, '', '', '', '', 0, 0, 0),
(545, '', '', '', '', 0, 0, 0),
(546, '', '', '', '', 0, 0, 0),
(547, '', '', '', '', 0, 0, 0),
(548, '', '', '', '', 0, 0, 0),
(549, '', '', '', '', 0, 0, 0),
(550, '', '', '', '', 0, 0, 0),
(551, '', '', '', '', 0, 0, 0),
(552, '', '', '', '', 0, 0, 0),
(553, '', '', '', '', 0, 0, 0),
(554, '', '', '', '', 0, 0, 0),
(555, '', '', '', '', 0, 0, 0),
(556, '', '', '', '', 0, 0, 0),
(557, '', '', '', '', 0, 0, 0),
(558, '', '', '', '', 0, 0, 0),
(559, '', '', '', '', 0, 0, 0),
(560, '', '', '', '', 0, 0, 0),
(561, '', '', '', '', 0, 0, 0),
(562, '', '', '', '', 0, 0, 0),
(563, '', '', '', '', 0, 0, 0),
(564, '', '', '', '', 0, 0, 0),
(565, '', '', '', '', 0, 0, 0),
(566, '', '', '', '', 0, 0, 0),
(567, '', '', '', '', 0, 0, 0),
(568, '', '', '', '', 0, 0, 0),
(569, '', '', '', '', 0, 0, 0),
(570, '', '', '', '', 0, 0, 0),
(571, '', '', '', '', 0, 0, 0),
(572, '', '', '', '', 0, 0, 0),
(573, '', '', '', '', 0, 0, 0),
(574, '', '', '', '', 0, 0, 0),
(575, '', '', '', '', 0, 0, 0),
(576, '', '', '', '', 0, 0, 0),
(577, '', '', '', '', 0, 0, 0),
(578, '', '', '', '', 0, 0, 0),
(579, '', '', '', '', 0, 0, 0),
(580, '', '', '', '', 0, 0, 0),
(581, '', '', '', '', 0, 0, 0),
(582, '', '', '', '', 0, 0, 0),
(583, '', '', '', '', 0, 0, 0),
(584, '', '', '', '', 0, 0, 0),
(585, '', '', '', '', 0, 0, 0),
(586, '', '', '', '', 0, 0, 0),
(587, '', '', '', '', 0, 0, 0),
(588, '', '', '', '', 0, 0, 0),
(589, '', '', '', '', 0, 0, 0),
(590, '', '', '', '', 0, 0, 0),
(591, '', '', '', '', 0, 0, 0),
(592, '', '', '', '', 0, 0, 0),
(593, '', '', '', '', 0, 0, 0),
(594, '', '', '', '', 0, 0, 0),
(595, '', '', '', '', 0, 0, 0),
(596, '', '', '', '', 0, 0, 0),
(597, '', '', '', '', 0, 0, 0),
(598, '', '', '', '', 0, 0, 0),
(599, '', '', '', '', 0, 0, 0),
(600, '', '', '', '', 0, 0, 0),
(601, '', '', '', '', 0, 0, 0),
(602, '', '', '', '', 0, 0, 0),
(603, '', '', '', '', 0, 0, 0),
(604, '', '', '', '', 0, 0, 0),
(605, '', '', '', '', 0, 0, 0),
(606, '', '', '', '', 0, 0, 0),
(607, '', '', '', '', 0, 0, 0),
(608, '', '', '', '', 0, 0, 0),
(609, '', '', '', '', 0, 0, 0),
(610, '', '', '', '', 0, 0, 0),
(611, '', '', '', '', 0, 0, 0),
(612, '', '', '', '', 0, 0, 0),
(613, '', '', '', '', 0, 0, 0),
(614, '', '', '', '', 0, 0, 0),
(615, '', '', '', '', 0, 0, 0),
(616, '', '', '', '', 0, 0, 0),
(617, '', '', '', '', 0, 0, 0),
(618, '', '', '', '', 0, 0, 0),
(619, '', '', '', '', 0, 0, 0),
(620, '', '', '', '', 0, 0, 0),
(621, '', '', '', '', 0, 0, 0),
(622, '', '', '', '', 0, 0, 0),
(623, '', '', '', '', 0, 0, 0),
(624, '', '', '', '', 0, 0, 0),
(625, '', '', '', '', 0, 0, 0),
(626, '', '', '', '', 0, 0, 0),
(627, '', '', '', '', 0, 0, 0),
(628, '', '', '', '', 0, 0, 0),
(629, '', '', '', '', 0, 0, 0),
(630, '', '', '', '', 0, 0, 0),
(631, '', '', '', '', 0, 0, 0),
(632, '', '', '', '', 0, 0, 0),
(633, '', '', '', '', 0, 0, 0),
(634, '', '', '', '', 0, 0, 0),
(635, '', '', '', '', 0, 0, 0),
(636, '', '', '', '', 0, 0, 0),
(637, '', '', '', '', 0, 0, 0),
(638, '', '', '', '', 0, 0, 0),
(639, '', '', '', '', 0, 0, 0),
(640, '', '', '', '', 0, 0, 0),
(641, '', '', '', '', 0, 0, 0),
(642, '', '', '', '', 0, 0, 0),
(643, '', '', '', '', 0, 0, 0),
(644, '', '', '', '', 0, 0, 0),
(645, '', '', '', '', 0, 0, 0),
(646, '', '', '', '', 0, 0, 0),
(647, '', '', '', '', 0, 0, 0),
(648, '', '', '', '', 0, 0, 0),
(649, '', '', '', '', 0, 0, 0),
(650, '', '', '', '', 0, 0, 0),
(651, '', '', '', '', 0, 0, 0),
(652, '', '', '', '', 0, 0, 0),
(653, '', '', '', '', 0, 0, 0),
(654, '', '', '', '', 0, 0, 0),
(655, '', '', '', '', 0, 0, 0),
(656, '', '', '', '', 0, 0, 0),
(657, '', '', '', '', 0, 0, 0),
(658, '', '', '', '', 0, 0, 0),
(659, '', '', '', '', 0, 0, 0),
(660, '', '', '', '', 0, 0, 0),
(661, '', '', '', '', 0, 0, 0),
(662, '', '', '', '', 0, 0, 0),
(663, '', '', '', '', 0, 0, 0),
(664, '', '', '', '', 0, 0, 0),
(665, '', '', '', '', 0, 0, 0),
(666, '', '', '', '', 0, 0, 0),
(667, '', '', '', '', 0, 0, 0),
(668, '', '', '', '', 0, 0, 0),
(669, '', '', '', '', 0, 0, 0),
(670, '', '', '', '', 0, 0, 0),
(671, '', '', '', '', 0, 0, 0),
(672, '', '', '', '', 0, 0, 0),
(673, '', '', '', '', 0, 0, 0),
(674, '', '', '', '', 0, 0, 0),
(675, '', '', '', '', 0, 0, 0),
(676, '', '', '', '', 0, 0, 0),
(677, '', '', '', '', 0, 0, 0),
(678, '', '', '', '', 0, 0, 0),
(679, '', '', '', '', 0, 0, 0),
(680, '', '', '', '', 0, 0, 0),
(681, '', '', '', '', 0, 0, 0),
(682, '', '', '', '', 0, 0, 0),
(683, '', '', '', '', 0, 0, 0),
(684, '', '', '', '', 0, 0, 0),
(685, '', '', '', '', 0, 0, 0),
(686, '', '', '', '', 0, 0, 0),
(687, '', '', '', '', 0, 0, 0),
(688, '', '', '', '', 0, 0, 0),
(689, '', '', '', '', 0, 0, 0),
(690, '', '', '', '', 0, 0, 0),
(691, '', '', '', '', 0, 0, 0),
(692, '', '', '', '', 0, 0, 0),
(693, '', '', '', '', 0, 0, 0),
(694, '', '', '', '', 0, 0, 0),
(695, '', '', '', '', 0, 0, 0),
(696, '', '', '', '', 0, 0, 0),
(697, '', '', '', '', 0, 0, 0),
(698, '', '', '', '', 0, 0, 0),
(699, '', '', '', '', 0, 0, 0),
(700, '', '', '', '', 0, 0, 0),
(701, '', '', '', '', 0, 0, 0),
(702, '', '', '', '', 0, 0, 0),
(703, '', '', '', '', 0, 0, 0),
(704, '', '', '', '', 0, 0, 0),
(705, '', '', '', '', 0, 0, 0),
(706, '', '', '', '', 0, 0, 0),
(707, '', '', '', '', 0, 0, 0),
(708, '', '', '', '', 0, 0, 0),
(709, '', '', '', '', 0, 0, 0),
(710, '', '', '', '', 0, 0, 0),
(711, '', '', '', '', 0, 0, 0),
(712, '', '', '', '', 0, 0, 0),
(713, '', '', '', '', 0, 0, 0),
(714, '', '', '', '', 0, 0, 0),
(715, '', '', '', '', 0, 0, 0),
(716, '', '', '', '', 0, 0, 0),
(717, '', '', '', '', 0, 0, 0),
(718, '', '', '', '', 0, 0, 0),
(719, '', '', '', '', 0, 0, 0),
(720, '', '', '', '', 0, 0, 0),
(721, '', '', '', '', 0, 0, 0),
(722, '', '', '', '', 0, 0, 0),
(723, '', '', '', '', 0, 0, 0),
(724, '', '', '', '', 0, 0, 0),
(725, '', '', '', '', 0, 0, 0),
(726, '', '', '', '', 0, 0, 0),
(727, '', '', '', '', 0, 0, 0),
(728, '', '', '', '', 0, 0, 0),
(729, '', '', '', '', 0, 0, 0),
(730, '', '', '', '', 0, 0, 0),
(731, '', '', '', '', 0, 0, 0),
(732, '', '', '', '', 0, 0, 0),
(733, '', '', '', '', 0, 0, 0),
(734, '', '', '', '', 0, 0, 0);

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

-- 
-- Estructura de tabla para la tabla `Entradas`
-- 

CREATE TABLE `Entradas` (
  `No` int(5) NOT NULL,
  `Còdigo` varchar(15) NOT NULL,
  `Lote` varchar(12) NOT NULL,
  `Fechae` date NOT NULL,
  `Documento` varchar(12) NOT NULL,
  `Cantidad` int(10) NOT NULL,
  `Costo` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Entradas`
-- 


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

-- 
-- Estructura de tabla para la tabla `Equivale`
-- 

CREATE TABLE `Equivale` (
  `No` int(10) NOT NULL AUTO_INCREMENT,
  `Buscar` varchar(60) NOT NULL,
  `Regresa` varchar(60) NOT NULL,
  PRIMARY KEY (`No`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

-- 
-- Volcar la base de datos para la tabla `Equivale`
-- 

INSERT INTO `Equivale` (`No`, `Buscar`, `Regresa`) VALUES (1, 'Aplicacion Medicamentos Parenterales', 'ENF2DOS'),
(2, 'VISITA MED', 'OKENF12H'),
(3, 'Servicio Enf 24 Horas', 'ENFSER24'),
(4, 'T. FISICA', 'OK_T.FIS.ENFSER32H');

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

-- 
-- Estructura de tabla para la tabla `Factura`
-- 

CREATE TABLE `Factura` (
  `No` int(8) NOT NULL,
  `No2` int(7) NOT NULL,
  `Cantidad` varchar(4) NOT NULL,
  `Detalle` varchar(120) NOT NULL,
  `Valoru` varchar(12) NOT NULL,
  `Valor` varchar(12) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Factura`
-- 

INSERT INTO `Factura` (`No`, `No2`, `Cantidad`, `Detalle`, `Valoru`, `Valor`) VALUES (2408, 1, '7', '(168 Horas.)  AUXILIAR ENFERMERIA 24 HORAS general', '98.000', '686.000'),
(2408, 1, '2', '(48 Horas.)  AUXILIAR ENFERMERIA 24 HORAS general', '118.000', '236.000'),
(2408, 1, '', '', '', ''),
(2408, 1, '', '', '', ''),
(2408, 2, '4', 'Terapia física', '22.000', '88.000'),
(2408, 2, '', '', '', ''),
(2408, 2, '', '', '', ''),
(2408, 2, '', '', '', ''),
(2408, 2, '', '', '', ''),
(2408, 2, '', 'Paciente: Eleonor tibabulles ', '', ''),
(2408, 2, '', 'Autorizacion: 9000000765 ', '', ''),
(2408, 2, '', '', '', ''),
(2408, 2, '', '', '', '');

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

-- 
-- Estructura de tabla para la tabla `Factura2`
-- 

CREATE TABLE `Factura2` (
  `No` int(8) NOT NULL,
  `Cantidad` int(4) NOT NULL,
  `Detalle` varchar(120) NOT NULL,
  `Valoru` int(10) NOT NULL,
  `Valor` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- 
-- Volcar la base de datos para la tabla `Factura2`
-- 


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

-- 
-- Estructura de tabla para la tabla `Fallida`
-- 

CREATE TABLE `Fallida` (
  `No` int(8) NOT NULL AUTO_INCREMENT,
  `Consec` int(2) NOT NULL,
  `Consec2` int(2) NOT NULL,
  `Requerimiento` varchar(10) NOT NULL,
  `Efectuado` int(1) NOT NULL,
  `Profesional` varchar(40) NOT NULL,
  `No_Cesiones` int(5) NOT NULL,
  `Tiempo` varchar(20) NOT NULL,
  `Fecha` date NOT NULL,
  `Cod_req` varchar(12) NOT NULL,
  `Cod_prof` varchar(12) NOT NULL,
  `Asignado` int(1) NOT NULL,
  `FechaE` datetime NOT NULL,
  `Fechae2` datetime NOT NULL,
  `Observa` text NOT NULL,
  `Subdividido` int(1) NOT NULL,
  `FechaR` datetime NOT NULL,
  `Usuario` varchar(30) NOT NULL,
  `Tipo` int(2) NOT NULL,
  `No_Cesión` int(2) NOT NULL,
  `Noe` int(8) NOT NULL,
  `Eventos` text NOT NULL,
  KEY `No` (`No`)
) ENGINE=MyISAM AUTO_INCREMENT=2471 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2471 ;