-- 
-- 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', '', '');

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