-- phpMyAdmin SQL Dump
-- version 4.8.4
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 12-03-2019 a las 12:04:57
-- Versión del servidor: 5.7.25-0ubuntu0.16.04.2
-- Versión de PHP: 7.1.14

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


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

--
-- Base de datos: `madrugon_tienda`
--

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

--
-- Estructura de tabla para la tabla `tbl_categorias`
--

CREATE TABLE `tbl_categorias` (
  `nodo` int(11) NOT NULL COMMENT 'nodo dependiente',
  `opcion` int(11) NOT NULL COMMENT 'opcion de trabajo',
  `descripcion` varchar(2000) COLLATE utf8_spanish_ci NOT NULL COMMENT 'descripcion de la categoria',
  `imagen` varchar(2000) COLLATE utf8_spanish_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_categorias` (`nodo`, `opcion`, `descripcion`, `imagen`) VALUES
(0, 1, 'Mujeres', 'images/Mujeres.jpg'),
(1, 2, 'Jeans', NULL),
(0, 3, 'Tecnologia', 'images/Tecnologia.jpg'),
(0, 4, 'belleza', 'images/belleza.jpg'),
(3, 5, 'celular', NULL),
(1, 7, 'ZAPATILLAS', NULL),
(0, 8, 'Hogar ', 'images/Hogar .jpg'),
(8, 9, 'sofa', NULL);

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

--
-- Estructura de tabla para la tabla `tbl_ciudad`
--

CREATE TABLE `tbl_ciudad` (
  `id` int(11) NOT NULL COMMENT 'id de la ciudad',
  `id_pais` int(11) NOT NULL COMMENT 'id del pais',
  `id_departamento` int(11) NOT NULL COMMENT 'id del departamento',
  `nombre` varchar(100) COLLATE utf8_spanish_ci NOT NULL COMMENT 'nombre de la ciudad',
  `codigo_dane` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_ciudad` (`id`, `id_pais`, `id_departamento`, `nombre`, `codigo_dane`) VALUES
(1, 42, 1, 'MEDELLIN', 5001),
(2, 42, 1, 'ABEJORRAL', 5002),
(3, 42, 1, 'ABRIAQUI', 5004),
(4, 42, 1, 'ALEJANDRIA', 5021),
(5, 42, 1, 'AMAGA', 5030),
(6, 42, 1, 'AMALFI', 5031),
(7, 42, 1, 'ANDES', 5034),
(8, 42, 1, 'ANGELOPOLIS', 5036),
(9, 42, 1, 'ANGOSTURA', 5038),
(10, 42, 1, 'ANORI', 5040),
(11, 42, 1, 'SANTAFE DE ANTIOQUIA', 5042),
(12, 42, 1, 'ANZA', 5044),
(13, 42, 1, 'APARTADO', 5045),
(14, 42, 1, 'ARBOLETES', 5051),
(15, 42, 1, 'ARGELIA', 5055),
(16, 42, 1, 'ARMENIA', 5059),
(17, 42, 1, 'BARBOSA', 5079),
(18, 42, 1, 'BELMIRA', 5086),
(19, 42, 1, 'BELLO', 5088),
(20, 42, 1, 'BETANIA', 5091),
(21, 42, 1, 'BETULIA', 5093),
(22, 42, 1, 'CIUDAD BOLIVAR', 5101),
(23, 42, 1, 'BRICEÑO', 5107),
(24, 42, 1, 'BURITICA', 5113),
(25, 42, 1, 'CACERES', 5120),
(26, 42, 1, 'CAICEDO', 5125),
(27, 42, 1, 'CALDAS', 5129),
(28, 42, 1, 'CAMPAMENTO', 5134),
(29, 42, 1, 'CAÑASGORDAS', 5138),
(30, 42, 1, 'CARACOLI', 5142),
(31, 42, 1, 'CARAMANTA', 5145),
(32, 42, 1, 'CAREPA', 5147),
(33, 42, 1, 'EL CARMEN DE VIBORAL', 5148),
(34, 42, 1, 'CAROLINA', 5150),
(35, 42, 1, 'CAUCASIA', 5154),
(36, 42, 1, 'CHIGORODO', 5172),
(37, 42, 1, 'CISNEROS', 5190),
(38, 42, 1, 'COCORNA', 5197),
(39, 42, 1, 'CONCEPCION', 5206),
(40, 42, 1, 'CONCORDIA', 5209),
(41, 42, 1, 'COPACABANA', 5212),
(42, 42, 1, 'DABEIBA', 5234),
(43, 42, 1, 'DON MATIAS', 5237),
(44, 42, 1, 'EBEJICO', 5240),
(45, 42, 1, 'EL BAGRE', 5250),
(46, 42, 1, 'ENTRERRIOS', 5264),
(47, 42, 1, 'ENVIGADO', 5266),
(48, 42, 1, 'FREDONIA', 5282),
(49, 42, 1, 'FRONTINO', 5284),
(50, 42, 1, 'GIRALDO', 5306),
(51, 42, 1, 'GIRARDOTA', 5308),
(52, 42, 1, 'GOMEZ PLATA', 5310),
(53, 42, 1, 'GRANADA', 5313),
(54, 42, 1, 'GUADALUPE', 5315),
(55, 42, 1, 'GUARNE', 5318),
(56, 42, 1, 'GUATAPE', 5321),
(57, 42, 1, 'HELICONIA', 5347),
(58, 42, 1, 'HISPANIA', 5353),
(59, 42, 1, 'ITAGUI', 5360),
(60, 42, 1, 'ITUANGO', 5361),
(61, 42, 1, 'JARDIN', 5364),
(62, 42, 1, 'JERICO', 5368),
(63, 42, 1, 'LA CEJA', 5376),
(64, 42, 1, 'LA ESTRELLA', 5380),
(65, 42, 1, 'LA PINTADA', 5390),
(66, 42, 1, 'LA UNION', 5400),
(67, 42, 1, 'LIBORINA', 5411),
(68, 42, 1, 'MACEO', 5425),
(69, 42, 1, 'MARINILLA', 5440),
(70, 42, 1, 'MONTEBELLO', 5467),
(71, 42, 1, 'MURINDO', 5475),
(72, 42, 1, 'MUTATA', 5480),
(73, 42, 1, 'NARIÑO', 5483),
(74, 42, 1, 'NECOCLI', 5490),
(75, 42, 1, 'NECHI', 5495),
(76, 42, 1, 'OLAYA', 5501),
(77, 42, 1, 'PEÐOL', 5541),
(78, 42, 1, 'PEQUE', 5543),
(79, 42, 1, 'PUEBLORRICO', 5576),
(80, 42, 1, 'PUERTO BERRIO', 5579),
(81, 42, 1, 'PUERTO NARE', 5585),
(82, 42, 1, 'PUERTO TRIUNFO', 5591),
(83, 42, 1, 'REMEDIOS', 5604),
(84, 42, 1, 'RETIRO', 5607),
(85, 42, 1, 'RIONEGRO', 5615),
(86, 42, 1, 'SABANALARGA', 5628),
(87, 42, 1, 'SABANETA', 5631),
(88, 42, 1, 'SALGAR', 5642),
(89, 42, 1, 'SAN ANDRES DE CUERQUIA', 5647),
(90, 42, 1, 'SAN CARLOS', 5649),
(91, 42, 1, 'SAN FRANCISCO', 5652),
(92, 42, 1, 'SAN JERONIMO', 5656),
(93, 42, 1, 'SAN JOSE DE LA MONTAÑA', 5658),
(94, 42, 1, 'SAN JUAN DE URABA', 5659),
(95, 42, 1, 'SAN LUIS', 5660),
(96, 42, 1, 'SAN PEDRO', 5664),
(97, 42, 1, 'SAN PEDRO DE URABA', 5665),
(98, 42, 1, 'SAN RAFAEL', 5667),
(99, 42, 1, 'SAN ROQUE', 5670),
(100, 42, 1, 'SAN VICENTE', 5674),
(101, 42, 1, 'SANTA BARBARA', 5679),
(102, 42, 1, 'SANTA ROSA DE OSOS', 5686),
(103, 42, 1, 'SANTO DOMINGO', 5690),
(104, 42, 1, 'EL SANTUARIO', 5697),
(105, 42, 1, 'SEGOVIA', 5736),
(106, 42, 1, 'SONSON', 5756),
(107, 42, 1, 'SOPETRAN', 5761),
(108, 42, 1, 'TAMESIS', 5789),
(109, 42, 1, 'TARAZA', 5790),
(110, 42, 1, 'TARSO', 5792),
(111, 42, 1, 'TITIRIBI', 5809),
(112, 42, 1, 'TOLEDO', 5819),
(113, 42, 1, 'TURBO', 5837),
(114, 42, 1, 'URAMITA', 5842),
(115, 42, 1, 'URRAO', 5847),
(116, 42, 1, 'VALDIVIA', 5854),
(117, 42, 1, 'VALPARAISO', 5856),
(118, 42, 1, 'VEGACHI', 5858),
(119, 42, 1, 'VENECIA', 5861),
(120, 42, 1, 'VIGIA DEL FUERTE', 5873),
(121, 42, 1, 'YALI', 5885),
(122, 42, 1, 'YARUMAL', 5887),
(123, 42, 1, 'YOLOMBO', 5890),
(124, 42, 1, 'YONDO', 5893),
(125, 42, 1, 'ZARAGOZA', 5895),
(126, 42, 2, 'BARRANQUILLA', 8001),
(127, 42, 2, 'BARANOA', 8078),
(128, 42, 2, 'CAMPO DE LA CRUZ', 8137),
(129, 42, 2, 'CANDELARIA', 8141),
(130, 42, 2, 'GALAPA', 8296),
(131, 42, 2, 'JUAN DE ACOSTA', 8372),
(132, 42, 2, 'LURUACO', 8421),
(133, 42, 2, 'MALAMBO', 8433),
(134, 42, 2, 'MANATI', 8436),
(135, 42, 2, 'PALMAR DE VARELA', 8520),
(136, 42, 2, 'PIOJO', 8549),
(137, 42, 2, 'POLONUEVO', 8558),
(138, 42, 2, 'PONEDERA', 8560),
(139, 42, 2, 'PUERTO COLOMBIA', 8573),
(140, 42, 2, 'REPELON', 8606),
(141, 42, 2, 'SABANAGRANDE', 8634),
(142, 42, 2, 'SABANALARGA', 8638),
(143, 42, 2, 'SANTA LUCIA', 8675),
(144, 42, 2, 'SANTO TOMAS', 8685),
(145, 42, 2, 'SOLEDAD', 8758),
(146, 42, 2, 'SUAN', 8770),
(147, 42, 2, 'TUBARA', 8832),
(148, 42, 2, 'USIACURI', 8849),
(149, 42, 3, 'BOGOTA, D.C.', 11001),
(150, 42, 4, 'CARTAGENA', 13001),
(151, 42, 4, 'ACHI', 13006),
(152, 42, 4, 'ALTOS DEL ROSARIO', 13030),
(153, 42, 4, 'ARENAL', 13042),
(154, 42, 4, 'ARJONA', 13052),
(155, 42, 4, 'ARROYOHONDO', 13062),
(156, 42, 4, 'BARRANCO DE LOBA', 13074),
(157, 42, 4, 'CALAMAR', 13140),
(158, 42, 4, 'CANTAGALLO', 13160),
(159, 42, 4, 'CICUCO', 13188),
(160, 42, 4, 'CORDOBA', 13212),
(161, 42, 4, 'CLEMENCIA', 13222),
(162, 42, 4, 'EL CARMEN DE BOLIVAR', 13244),
(163, 42, 4, 'EL GUAMO', 13248),
(164, 42, 4, 'EL PEÑON', 13268),
(165, 42, 4, 'HATILLO DE LOBA', 13300),
(166, 42, 4, 'MAGANGUE', 13430),
(167, 42, 4, 'MAHATES', 13433),
(168, 42, 4, 'MARGARITA', 13440),
(169, 42, 4, 'MARIA LA BAJA', 13442),
(170, 42, 4, 'MONTECRISTO', 13458),
(171, 42, 4, 'MOMPOS', 13468),
(172, 42, 4, 'NOROSI', 13490),
(173, 42, 4, 'MORALES', 13473),
(174, 42, 4, 'PINILLOS', 13549),
(175, 42, 4, 'REGIDOR', 13580),
(176, 42, 4, 'RIO VIEJO', 13600),
(177, 42, 4, 'SAN CRISTOBAL', 13620),
(178, 42, 4, 'SAN ESTANISLAO', 13647),
(179, 42, 4, 'SAN FERNANDO', 13650),
(180, 42, 4, 'SAN JACINTO', 13654),
(181, 42, 4, 'SAN JACINTO DEL CAUCA', 13655),
(182, 42, 4, 'SAN JUAN NEPOMUCENO', 13657),
(183, 42, 4, 'SAN MARTIN DE LOBA', 13667),
(184, 42, 4, 'SAN PABLO', 13670),
(185, 42, 4, 'SANTA CATALINA', 13673),
(186, 42, 4, 'SANTA ROSA', 13683),
(187, 42, 4, 'SANTA ROSA DEL SUR', 13688),
(188, 42, 4, 'SIMITI', 13744),
(189, 42, 4, 'SOPLAVIENTO', 13760),
(190, 42, 4, 'TALAIGUA NUEVO', 13780),
(191, 42, 4, 'TIQUISIO', 13810),
(192, 42, 4, 'TURBACO', 13836),
(193, 42, 4, 'TURBANA', 13838),
(194, 42, 4, 'VILLANUEVA', 13873),
(195, 42, 4, 'ZAMBRANO', 13894),
(196, 42, 5, 'TUNJA', 15001),
(197, 42, 5, 'ALMEIDA', 15022),
(198, 42, 5, 'AQUITANIA', 15047),
(199, 42, 5, 'ARCABUCO', 15051),
(200, 42, 5, 'BELEN', 15087),
(201, 42, 5, 'BERBEO', 15090),
(202, 42, 5, 'BETEITIVA', 15092),
(203, 42, 5, 'BOAVITA', 15097),
(204, 42, 5, 'BOYACA', 15104),
(205, 42, 5, 'BRICEÑO', 15106),
(206, 42, 5, 'BUENAVISTA', 15109),
(207, 42, 5, 'BUSBANZA', 15114),
(208, 42, 5, 'CALDAS', 15131),
(209, 42, 5, 'CAMPOHERMOSO', 15135),
(210, 42, 5, 'CERINZA', 15162),
(211, 42, 5, 'CHINAVITA', 15172),
(212, 42, 5, 'CHIQUINQUIRA', 15176),
(213, 42, 5, 'CHISCAS', 15180),
(214, 42, 5, 'CHITA', 15183),
(215, 42, 5, 'CHITARAQUE', 15185),
(216, 42, 5, 'CHIVATA', 15187),
(217, 42, 5, 'CIENEGA', 15189),
(218, 42, 5, 'COMBITA', 15204),
(219, 42, 5, 'COPER', 15212),
(220, 42, 5, 'CORRALES', 15215),
(221, 42, 5, 'COVARACHIA', 15218),
(222, 42, 5, 'CUBARA', 15223),
(223, 42, 5, 'CUCAITA', 15224),
(224, 42, 5, 'CUITIVA', 15226),
(225, 42, 5, 'CHIQUIZA', 15232),
(226, 42, 5, 'CHIVOR', 15236),
(227, 42, 5, 'DUITAMA', 15238),
(228, 42, 5, 'EL COCUY', 15244),
(229, 42, 5, 'EL ESPINO', 15248),
(230, 42, 5, 'FIRAVITOBA', 15272),
(231, 42, 5, 'FLORESTA', 15276),
(232, 42, 5, 'GACHANTIVA', 15293),
(233, 42, 5, 'GAMEZA', 15296),
(234, 42, 5, 'GARAGOA', 15299),
(235, 42, 5, 'GUACAMAYAS', 15317),
(236, 42, 5, 'GUATEQUE', 15322),
(237, 42, 5, 'GUAYATA', 15325),
(238, 42, 5, 'GsICAN', 15332),
(239, 42, 5, 'IZA', 15362),
(240, 42, 5, 'JENESANO', 15367),
(241, 42, 5, 'JERICO', 15368),
(242, 42, 5, 'LABRANZAGRANDE', 15377),
(243, 42, 5, 'LA CAPILLA', 15380),
(244, 42, 5, 'LA VICTORIA', 15401),
(245, 42, 5, 'LA UVITA', 15403),
(246, 42, 5, 'VILLA DE LEYVA', 15407),
(247, 42, 5, 'MACANAL', 15425),
(248, 42, 5, 'MARIPI', 15442),
(249, 42, 5, 'MIRAFLORES', 15455),
(250, 42, 5, 'MONGUA', 15464),
(251, 42, 5, 'MONGUI', 15466),
(252, 42, 5, 'MONIQUIRA', 15469),
(253, 42, 5, 'MOTAVITA', 15476),
(254, 42, 5, 'MUZO', 15480),
(255, 42, 5, 'NOBSA', 15491),
(256, 42, 5, 'NUEVO COLON', 15494),
(257, 42, 5, 'OICATA', 15500),
(258, 42, 5, 'OTANCHE', 15507),
(259, 42, 5, 'PACHAVITA', 15511),
(260, 42, 5, 'PAEZ', 15514),
(261, 42, 5, 'PAIPA', 15516),
(262, 42, 5, 'PAJARITO', 15518),
(263, 42, 5, 'PANQUEBA', 15522),
(264, 42, 5, 'PAUNA', 15531),
(265, 42, 5, 'PAYA', 15533),
(266, 42, 5, 'PAZ DE RIO', 15537),
(267, 42, 5, 'PESCA', 15542),
(268, 42, 5, 'PISBA', 15550),
(269, 42, 5, 'PUERTO BOYACA', 15572),
(270, 42, 5, 'QUIPAMA', 15580),
(271, 42, 5, 'RAMIRIQUI', 15599),
(272, 42, 5, 'RAQUIRA', 15600),
(273, 42, 5, 'RONDON', 15621),
(274, 42, 5, 'SABOYA', 15632),
(275, 42, 5, 'SACHICA', 15638),
(276, 42, 5, 'SAMACA', 15646),
(277, 42, 5, 'SAN EDUARDO', 15660),
(278, 42, 5, 'SAN JOSE DE PARE', 15664),
(279, 42, 5, 'SAN LUIS DE GACENO', 15667),
(280, 42, 5, 'SAN MATEO', 15673),
(281, 42, 5, 'SAN MIGUEL DE SEMA', 15676),
(282, 42, 5, 'SAN PABLO DE BORBUR', 15681),
(283, 42, 5, 'SANTANA', 15686),
(284, 42, 5, 'SANTA MARIA', 15690),
(285, 42, 5, 'SANTA ROSA DE VITERBO', 15693),
(286, 42, 5, 'SANTA SOFIA', 15696),
(287, 42, 5, 'SATIVANORTE', 15720),
(288, 42, 5, 'SATIVASUR', 15723),
(289, 42, 5, 'SIACHOQUE', 15740),
(290, 42, 5, 'SOATA', 15753),
(291, 42, 5, 'SOCOTA', 15755),
(292, 42, 5, 'SOCHA', 15757),
(293, 42, 5, 'SOGAMOSO', 15759),
(294, 42, 5, 'SOMONDOCO', 15761),
(295, 42, 5, 'SORA', 15762),
(296, 42, 5, 'SOTAQUIRA', 15763),
(297, 42, 5, 'SORACA', 15764),
(298, 42, 5, 'SUSACON', 15774),
(299, 42, 5, 'SUTAMARCHAN', 15776),
(300, 42, 5, 'SUTATENZA', 15778),
(301, 42, 5, 'TASCO', 15790),
(302, 42, 5, 'TENZA', 15798),
(303, 42, 5, 'TIBANA', 15804),
(304, 42, 5, 'TIBASOSA', 15806),
(305, 42, 5, 'TINJACA', 15808),
(306, 42, 5, 'TIPACOQUE', 15810),
(307, 42, 5, 'TOCA', 15814),
(308, 42, 5, 'TOGsI', 15816),
(309, 42, 5, 'TOPAGA', 15820),
(310, 42, 5, 'TOTA', 15822),
(311, 42, 5, 'TUNUNGUA', 15832),
(312, 42, 5, 'TURMEQUE', 15835),
(313, 42, 5, 'TUTA', 15837),
(314, 42, 5, 'TUTAZA', 15839),
(315, 42, 5, 'UMBITA', 15842),
(316, 42, 5, 'VENTAQUEMADA', 15861),
(317, 42, 5, 'VIRACACHA', 15879),
(318, 42, 5, 'ZETAQUIRA', 15897),
(319, 42, 6, 'MANIZALES', 17001),
(320, 42, 6, 'AGUADAS', 17013),
(321, 42, 6, 'ANSERMA', 17042),
(322, 42, 6, 'ARANZAZU', 17050),
(323, 42, 6, 'BELALCAZAR', 17088),
(324, 42, 6, 'CHINCHINA', 17174),
(325, 42, 6, 'FILADELFIA', 17272),
(326, 42, 6, 'LA DORADA', 17380),
(327, 42, 6, 'LA MERCED', 17388),
(328, 42, 6, 'MANZANARES', 17433),
(329, 42, 6, 'MARMATO', 17442),
(330, 42, 6, 'MARQUETALIA', 17444),
(331, 42, 6, 'MARULANDA', 17446),
(332, 42, 6, 'NEIRA', 17486),
(333, 42, 6, 'NORCASIA', 17495),
(334, 42, 6, 'PACORA', 17513),
(335, 42, 6, 'PALESTINA', 17524),
(336, 42, 6, 'PENSILVANIA', 17541),
(337, 42, 6, 'RIOSUCIO', 17614),
(338, 42, 6, 'RISARALDA', 17616),
(339, 42, 6, 'SALAMINA', 17653),
(340, 42, 6, 'SAMANA', 17662),
(341, 42, 6, 'SAN JOSE', 17665),
(342, 42, 6, 'SUPIA', 17777),
(343, 42, 6, 'VICTORIA', 17867),
(344, 42, 6, 'VILLAMARIA', 17873),
(345, 42, 6, 'VITERBO', 17877),
(346, 42, 7, 'FLORENCIA', 18001),
(347, 42, 7, 'ALBANIA', 18029),
(348, 42, 7, 'BELEN DE LOS ANDAQUIES', 18094),
(349, 42, 7, 'CARTAGENA DEL CHAIRA', 18150),
(350, 42, 7, 'CURILLO', 18205),
(351, 42, 7, 'EL DONCELLO', 18247),
(352, 42, 7, 'EL PAUJIL', 18256),
(353, 42, 7, 'LA MONTAÑITA', 18410),
(354, 42, 7, 'MILAN', 18460),
(355, 42, 7, 'MORELIA', 18479),
(356, 42, 7, 'PUERTO RICO', 18592),
(357, 42, 7, 'SAN JOSE DEL FRAGUA', 18610),
(358, 42, 7, 'SAN VICENTE DEL CAGUAN', 18753),
(359, 42, 7, 'SOLANO', 18756),
(360, 42, 7, 'SOLITA', 18785),
(361, 42, 7, 'VALPARAISO', 18860),
(362, 42, 8, 'POPAYAN', 19001),
(363, 42, 8, 'ALMAGUER', 19022),
(364, 42, 8, 'ARGELIA', 19050),
(365, 42, 8, 'BALBOA', 19075),
(366, 42, 8, 'BOLIVAR', 19100),
(367, 42, 8, 'BUENOS AIRES', 19110),
(368, 42, 8, 'CAJIBIO', 19130),
(369, 42, 8, 'CALDONO', 19137),
(370, 42, 8, 'CALOTO', 19142),
(371, 42, 8, 'CORINTO', 19212),
(372, 42, 8, 'EL TAMBO', 19256),
(373, 42, 8, 'FLORENCIA', 19290),
(374, 42, 8, 'GUACHENE', 19300),
(375, 42, 8, 'GUAPI', 19318),
(376, 42, 8, 'INZA', 19355),
(377, 42, 8, 'JAMBALO', 19364),
(378, 42, 8, 'LA SIERRA', 19392),
(379, 42, 8, 'LA VEGA', 19397),
(380, 42, 8, 'LOPEZ', 19418),
(381, 42, 8, 'MERCADERES', 19450),
(382, 42, 8, 'MIRANDA', 19455),
(383, 42, 8, 'MORALES', 19473),
(384, 42, 8, 'PADILLA', 19513),
(385, 42, 8, 'PAEZ', 19517),
(386, 42, 8, 'PATIA', 19532),
(387, 42, 8, 'PIAMONTE', 19533),
(388, 42, 8, 'PIENDAMO', 19548),
(389, 42, 8, 'PUERTO TEJADA', 19573),
(390, 42, 8, 'PURACE', 19585),
(391, 42, 8, 'ROSAS', 19622),
(392, 42, 8, 'SAN SEBASTIAN', 19693),
(393, 42, 8, 'SANTANDER DE QUILICHAO', 19698),
(394, 42, 8, 'SANTA ROSA', 19701),
(395, 42, 8, 'SILVIA', 19743),
(396, 42, 8, 'SOTARA', 19760),
(397, 42, 8, 'SUAREZ', 19780),
(398, 42, 8, 'SUCRE', 19785),
(399, 42, 8, 'TIMBIO', 19807),
(400, 42, 8, 'TIMBIQUI', 19809),
(401, 42, 8, 'TORIBIO', 19821),
(402, 42, 8, 'TOTORO', 19824),
(403, 42, 8, 'VILLA RICA', 19845),
(404, 42, 9, 'VALLEDUPAR', 20001),
(405, 42, 9, 'AGUACHICA', 20011),
(406, 42, 9, 'AGUSTIN CODAZZI', 20013),
(407, 42, 9, 'ASTREA', 20032),
(408, 42, 9, 'BECERRIL', 20045),
(409, 42, 9, 'BOSCONIA', 20060),
(410, 42, 9, 'CHIMICHAGUA', 20175),
(411, 42, 9, 'CHIRIGUANA', 20178),
(412, 42, 9, 'CURUMANI', 20228),
(413, 42, 9, 'EL COPEY', 20238),
(414, 42, 9, 'EL PASO', 20250),
(415, 42, 9, 'GAMARRA', 20295),
(416, 42, 9, 'GONZALEZ', 20310),
(417, 42, 9, 'LA GLORIA', 20383),
(418, 42, 9, 'LA JAGUA DE IBIRICO', 20400),
(419, 42, 9, 'MANAURE', 20443),
(420, 42, 9, 'PAILITAS', 20517),
(421, 42, 9, 'PELAYA', 20550),
(422, 42, 9, 'PUEBLO BELLO', 20570),
(423, 42, 9, 'RIO DE ORO', 20614),
(424, 42, 9, 'LA PAZ', 20621),
(425, 42, 9, 'SAN ALBERTO', 20710),
(426, 42, 9, 'SAN DIEGO', 20750),
(427, 42, 9, 'SAN MARTIN', 20770),
(428, 42, 9, 'TAMALAMEQUE', 20787),
(429, 42, 10, 'MONTERIA', 23001),
(430, 42, 10, 'AYAPEL', 23068),
(431, 42, 10, 'BUENAVISTA', 23079),
(432, 42, 10, 'CANALETE', 23090),
(433, 42, 10, 'CERETE', 23162),
(434, 42, 10, 'CHIMA', 23168),
(435, 42, 10, 'CHINU', 23182),
(436, 42, 10, 'CIENAGA DE ORO', 23189),
(437, 42, 10, 'COTORRA', 23300),
(438, 42, 10, 'LA APARTADA', 23350),
(439, 42, 10, 'LORICA', 23417),
(440, 42, 10, 'LOS CORDOBAS', 23419),
(441, 42, 10, 'MOMIL', 23464),
(442, 42, 10, 'MONTELIBANO', 23466),
(443, 42, 10, 'MOÑITOS', 23500),
(444, 42, 10, 'PLANETA RICA', 23555),
(445, 42, 10, 'PUEBLO NUEVO', 23570),
(446, 42, 10, 'PUERTO ESCONDIDO', 23574),
(447, 42, 10, 'PUERTO LIBERTADOR', 23580),
(448, 42, 10, 'PURISIMA', 23586),
(449, 42, 10, 'SAHAGUN', 23660),
(450, 42, 10, 'SAN ANDRES SOTAVENTO', 23670),
(451, 42, 10, 'SAN ANTERO', 23672),
(452, 42, 10, 'SAN BERNARDO DEL VIENTO', 23675),
(453, 42, 10, 'SAN CARLOS', 23678),
(454, 42, 10, 'SAN PELAYO', 23686),
(455, 42, 10, 'TIERRALTA', 23807),
(456, 42, 10, 'VALENCIA', 23855),
(457, 42, 11, 'AGUA DE DIOS', 25001),
(458, 42, 11, 'ALBAN', 25019),
(459, 42, 11, 'ANAPOIMA', 25035),
(460, 42, 11, 'ANOLAIMA', 25040),
(461, 42, 11, 'ARBELAEZ', 25053),
(462, 42, 11, 'BELTRAN', 25086),
(463, 42, 11, 'BITUIMA', 25095),
(464, 42, 11, 'BOJACA', 25099),
(465, 42, 11, 'CABRERA', 25120),
(466, 42, 11, 'CACHIPAY', 25123),
(467, 42, 11, 'CAJICA', 25126),
(468, 42, 11, 'CAPARRAPI', 25148),
(469, 42, 11, 'CAQUEZA', 25151),
(470, 42, 11, 'CARMEN DE CARUPA', 25154),
(471, 42, 11, 'CHAGUANI', 25168),
(472, 42, 11, 'CHIA', 25175),
(473, 42, 11, 'CHIPAQUE', 25178),
(474, 42, 11, 'CHOACHI', 25181),
(475, 42, 11, 'CHOCONTA', 25183),
(476, 42, 11, 'COGUA', 25200),
(477, 42, 11, 'COTA', 25214),
(478, 42, 11, 'CUCUNUBA', 25224),
(479, 42, 11, 'EL COLEGIO', 25245),
(480, 42, 11, 'EL PEÑON', 25258),
(481, 42, 11, 'EL ROSAL', 25260),
(482, 42, 11, 'FACATATIVA', 25269),
(483, 42, 11, 'FOMEQUE', 25279),
(484, 42, 11, 'FOSCA', 25281),
(485, 42, 11, 'FUNZA', 25286),
(486, 42, 11, 'FUQUENE', 25288),
(487, 42, 11, 'FUSAGASUGA', 25290),
(488, 42, 11, 'GACHALA', 25293),
(489, 42, 11, 'GACHANCIPA', 25295),
(490, 42, 11, 'GACHETA', 25297),
(491, 42, 11, 'GAMA', 25299),
(492, 42, 11, 'GIRARDOT', 25307),
(493, 42, 11, 'GRANADA', 25312),
(494, 42, 11, 'GUACHETA', 25317),
(495, 42, 11, 'GUADUAS', 25320),
(496, 42, 11, 'GUASCA', 25322),
(497, 42, 11, 'GUATAQUI', 25324),
(498, 42, 11, 'GUATAVITA', 25326),
(499, 42, 11, 'GUAYABAL DE SIQUIMA', 25328),
(500, 42, 11, 'GUAYABETAL', 25335),
(501, 42, 11, 'GUTIERREZ', 25339),
(502, 42, 11, 'JERUSALEN', 25368),
(503, 42, 11, 'JUNIN', 25372),
(504, 42, 11, 'LA CALERA', 25377),
(505, 42, 11, 'LA MESA', 25386),
(506, 42, 11, 'LA PALMA', 25394),
(507, 42, 11, 'LA PEÑA', 25398),
(508, 42, 11, 'LA VEGA', 25402),
(509, 42, 11, 'LENGUAZAQUE', 25407),
(510, 42, 11, 'MACHETA', 25426),
(511, 42, 11, 'MADRID', 25430),
(512, 42, 11, 'MANTA', 25436),
(513, 42, 11, 'MEDINA', 25438),
(514, 42, 11, 'MOSQUERA', 25473),
(515, 42, 11, 'NARIÑO', 25483),
(516, 42, 11, 'NEMOCON', 25486),
(517, 42, 11, 'NILO', 25488),
(518, 42, 11, 'NIMAIMA', 25489),
(519, 42, 11, 'NOCAIMA', 25491),
(520, 42, 11, 'VENECIA', 25506),
(521, 42, 11, 'PACHO', 25513),
(522, 42, 11, 'PAIME', 25518),
(523, 42, 11, 'PANDI', 25524),
(524, 42, 11, 'PARATEBUENO', 25530),
(525, 42, 11, 'PASCA', 25535),
(526, 42, 11, 'PUERTO SALGAR', 25572),
(527, 42, 11, 'PULI', 25580),
(528, 42, 11, 'QUEBRADANEGRA', 25592),
(529, 42, 11, 'QUETAME', 25594),
(530, 42, 11, 'QUIPILE', 25596),
(531, 42, 11, 'APULO', 25599),
(532, 42, 11, 'RICAURTE', 25612),
(533, 42, 11, 'SAN ANTONIO DEL TEQUENDAMA', 25645),
(534, 42, 11, 'SAN BERNARDO', 25649),
(535, 42, 11, 'SAN CAYETANO', 25653),
(536, 42, 11, 'SAN FRANCISCO', 25658),
(537, 42, 11, 'SAN JUAN DE RIO SECO', 25662),
(538, 42, 11, 'SASAIMA', 25718),
(539, 42, 11, 'SESQUILE', 25736),
(540, 42, 11, 'SIBATE', 25740),
(541, 42, 11, 'SILVANIA', 25743),
(542, 42, 11, 'SIMIJACA', 25745),
(543, 42, 11, 'SOACHA', 25754),
(544, 42, 11, 'SOPO', 25758),
(545, 42, 11, 'SUBACHOQUE', 25769),
(546, 42, 11, 'SUESCA', 25772),
(547, 42, 11, 'SUPATA', 25777),
(548, 42, 11, 'SUSA', 25779),
(549, 42, 11, 'SUTATAUSA', 25781),
(550, 42, 11, 'TABIO', 25785),
(551, 42, 11, 'TAUSA', 25793),
(552, 42, 11, 'TENA', 25797),
(553, 42, 11, 'TENJO', 25799),
(554, 42, 11, 'TIBACUY', 25805),
(555, 42, 11, 'TIBIRITA', 25807),
(556, 42, 11, 'TOCAIMA', 25815),
(557, 42, 11, 'TOCANCIPA', 25817),
(558, 42, 11, 'TOPAIPI', 25823),
(559, 42, 11, 'UBALA', 25839),
(560, 42, 11, 'UBAQUE', 25841),
(561, 42, 11, 'VILLA DE SAN DIEGO DE UBATE', 25843),
(562, 42, 11, 'UNE', 25845),
(563, 42, 11, 'UTICA', 25851),
(564, 42, 11, 'VERGARA', 25862),
(565, 42, 11, 'VIANI', 25867),
(566, 42, 11, 'VILLAGOMEZ', 25871),
(567, 42, 11, 'VILLAPINZON', 25873),
(568, 42, 11, 'VILLETA', 25875),
(569, 42, 11, 'VIOTA', 25878),
(570, 42, 11, 'YACOPI', 25885),
(571, 42, 11, 'ZIPACON', 25898),
(572, 42, 11, 'ZIPAQUIRA', 25899),
(573, 42, 12, 'QUIBDO', 27001),
(574, 42, 12, 'ACANDI', 27006),
(575, 42, 12, 'ALTO BAUDO', 27025),
(576, 42, 12, 'ATRATO', 27050),
(577, 42, 12, 'BAGADO', 27073),
(578, 42, 12, 'BAHIA SOLANO', 27075),
(579, 42, 12, 'BAJO BAUDO', 27077),
(580, 42, 12, 'BOJAYA', 27099),
(581, 42, 12, 'EL CANTON DEL SAN PABLO', 27135),
(582, 42, 12, 'CARMEN DEL DARIEN', 27150),
(583, 42, 12, 'CERTEGUI', 27160),
(584, 42, 12, 'CONDOTO', 27205),
(585, 42, 12, 'EL CARMEN DE ATRATO', 27245),
(586, 42, 12, 'EL LITORAL DEL SAN JUAN', 27250),
(587, 42, 12, 'ISTMINA', 27361),
(588, 42, 12, 'JURADO', 27372),
(589, 42, 12, 'LLORO', 27413),
(590, 42, 12, 'MEDIO ATRATO', 27425),
(591, 42, 12, 'MEDIO BAUDO', 27430),
(592, 42, 12, 'MEDIO SAN JUAN', 27450),
(593, 42, 12, 'NOVITA', 27491),
(594, 42, 12, 'NUQUI', 27495),
(595, 42, 12, 'RIO IRO', 27580),
(596, 42, 12, 'RIO QUITO', 27600),
(597, 42, 12, 'RIOSUCIO', 27615),
(598, 42, 12, 'SAN JOSE DEL PALMAR', 27660),
(599, 42, 12, 'SIPI', 27745),
(600, 42, 12, 'TADO', 27787),
(601, 42, 12, 'UNGUIA', 27800),
(602, 42, 12, 'UNION PANAMERICANA', 27810),
(603, 42, 13, 'NEIVA', 41001),
(604, 42, 13, 'ACEVEDO', 41006),
(605, 42, 13, 'AGRADO', 41013),
(606, 42, 13, 'AIPE', 41016),
(607, 42, 13, 'ALGECIRAS', 41020),
(608, 42, 13, 'ALTAMIRA', 41026),
(609, 42, 13, 'BARAYA', 41078),
(610, 42, 13, 'CAMPOALEGRE', 41132),
(611, 42, 13, 'COLOMBIA', 41206),
(612, 42, 13, 'ELIAS', 41244),
(613, 42, 13, 'GARZON', 41298),
(614, 42, 13, 'GIGANTE', 41306),
(615, 42, 13, 'GUADALUPE', 41319),
(616, 42, 13, 'HOBO', 41349),
(617, 42, 13, 'IQUIRA', 41357),
(618, 42, 13, 'ISNOS', 41359),
(619, 42, 13, 'LA ARGENTINA', 41378),
(620, 42, 13, 'LA PLATA', 41396),
(621, 42, 13, 'NATAGA', 41483),
(622, 42, 13, 'OPORAPA', 41503),
(623, 42, 13, 'PAICOL', 41518),
(624, 42, 13, 'PALERMO', 41524),
(625, 42, 13, 'PALESTINA', 41530),
(626, 42, 13, 'PITAL', 41548),
(627, 42, 13, 'PITALITO', 41551),
(628, 42, 13, 'RIVERA', 41615),
(629, 42, 13, 'SALADOBLANCO', 41660),
(630, 42, 13, 'SAN AGUSTIN', 41668),
(631, 42, 13, 'SANTA MARIA', 41676),
(632, 42, 13, 'SUAZA', 41770),
(633, 42, 13, 'TARQUI', 41791),
(634, 42, 13, 'TESALIA', 41797),
(635, 42, 13, 'TELLO', 41799),
(636, 42, 13, 'TERUEL', 41801),
(637, 42, 13, 'TIMANA', 41807),
(638, 42, 13, 'VILLAVIEJA', 41872),
(639, 42, 13, 'YAGUARA', 41885),
(640, 42, 14, 'RIOHACHA', 44001),
(641, 42, 14, 'ALBANIA', 44035),
(642, 42, 14, 'BARRANCAS', 44078),
(643, 42, 14, 'DIBULLA', 44090),
(644, 42, 14, 'DISTRACCION', 44098),
(645, 42, 14, 'EL MOLINO', 44110),
(646, 42, 14, 'FONSECA', 44279),
(647, 42, 14, 'HATONUEVO', 44378),
(648, 42, 14, 'LA JAGUA DEL PILAR', 44420),
(649, 42, 14, 'MAICAO', 44430),
(650, 42, 14, 'MANAURE', 44560),
(651, 42, 14, 'SAN JUAN DEL CESAR', 44650),
(652, 42, 14, 'URIBIA', 44847),
(653, 42, 14, 'URUMITA', 44855),
(654, 42, 14, 'VILLANUEVA', 44874),
(655, 42, 15, 'SANTA MARTA', 47001),
(656, 42, 15, 'ALGARROBO', 47030),
(657, 42, 15, 'ARACATACA', 47053),
(658, 42, 15, 'ARIGUANI', 47058),
(659, 42, 15, 'CERRO SAN ANTONIO', 47161),
(660, 42, 15, 'CHIBOLO', 47170),
(661, 42, 15, 'CIENAGA', 47189),
(662, 42, 15, 'CONCORDIA', 47205),
(663, 42, 15, 'EL BANCO', 47245),
(664, 42, 15, 'EL PIÑON', 47258),
(665, 42, 15, 'EL RETEN', 47268),
(666, 42, 15, 'FUNDACION', 47288),
(667, 42, 15, 'GUAMAL', 47318),
(668, 42, 15, 'NUEVA GRANADA', 47460),
(669, 42, 15, 'PEDRAZA', 47541),
(670, 42, 15, 'PIJIÑO DEL CARMEN', 47545),
(671, 42, 15, 'PIVIJAY', 47551),
(672, 42, 15, 'PLATO', 47555),
(673, 42, 15, 'PUEBLOVIEJO', 47570),
(674, 42, 15, 'REMOLINO', 47605),
(675, 42, 15, 'SABANAS DE SAN ANGEL', 47660),
(676, 42, 15, 'SALAMINA', 47675),
(677, 42, 15, 'SAN SEBASTIAN DE BUENAVISTA', 47692),
(678, 42, 15, 'SAN ZENON', 47703),
(679, 42, 15, 'SANTA ANA', 47707),
(680, 42, 15, 'SANTA BARBARA DE PINTO', 47720),
(681, 42, 15, 'SITIONUEVO', 47745),
(682, 42, 15, 'TENERIFE', 47798),
(683, 42, 15, 'ZAPAYAN', 47960),
(684, 42, 15, 'ZONA BANANERA', 47980),
(685, 42, 16, 'VILLAVICENCIO', 50001),
(686, 42, 16, 'ACACIAS', 50006),
(687, 42, 16, 'BARRANCA DE UPIA', 50110),
(688, 42, 16, 'CABUYARO', 50124),
(689, 42, 16, 'CASTILLA LA NUEVA', 50150),
(690, 42, 16, 'CUBARRAL', 50223),
(691, 42, 16, 'CUMARAL', 50226),
(692, 42, 16, 'EL CALVARIO', 50245),
(693, 42, 16, 'EL CASTILLO', 50251),
(694, 42, 16, 'EL DORADO', 50270),
(695, 42, 16, 'FUENTE DE ORO', 50287),
(696, 42, 16, 'GRANADA', 50313),
(697, 42, 16, 'GUAMAL', 50318),
(698, 42, 16, 'MAPIRIPAN', 50325),
(699, 42, 16, 'MESETAS', 50330),
(700, 42, 16, 'LA MACARENA', 50350),
(701, 42, 16, 'URIBE', 50370),
(702, 42, 16, 'LEJANIAS', 50400),
(703, 42, 16, 'PUERTO CONCORDIA', 50450),
(704, 42, 16, 'PUERTO GAITAN', 50568),
(705, 42, 16, 'PUERTO LOPEZ', 50573),
(706, 42, 16, 'PUERTO LLERAS', 50577),
(707, 42, 16, 'PUERTO RICO', 50590),
(708, 42, 16, 'RESTREPO', 50606),
(709, 42, 16, 'SAN CARLOS DE GUAROA', 50680),
(710, 42, 16, 'SAN JUAN DE ARAMA', 50683),
(711, 42, 16, 'SAN JUANITO', 50686),
(712, 42, 16, 'SAN MARTIN', 50689),
(713, 42, 16, 'VISTAHERMOSA', 50711),
(714, 42, 17, 'PASTO', 52001),
(715, 42, 17, 'ALBAN', 52019),
(716, 42, 17, 'ALDANA', 52022),
(717, 42, 17, 'ANCUYA', 52036),
(718, 42, 17, 'ARBOLEDA', 52051),
(719, 42, 17, 'BARBACOAS', 52079),
(720, 42, 17, 'BELEN', 52083),
(721, 42, 17, 'BUESACO', 52110),
(722, 42, 17, 'COLON', 52203),
(723, 42, 17, 'CONSACA', 52207),
(724, 42, 17, 'CONTADERO', 52210),
(725, 42, 17, 'CORDOBA', 52215),
(726, 42, 17, 'CUASPUD', 52224),
(727, 42, 17, 'CUMBAL', 52227),
(728, 42, 17, 'CUMBITARA', 52233),
(729, 42, 17, 'CHACHAGsI', 52240),
(730, 42, 17, 'EL CHARCO', 52250),
(731, 42, 17, 'EL PEÑOL', 52254),
(732, 42, 17, 'EL ROSARIO', 52256),
(733, 42, 17, 'EL TABLON DE GOMEZ', 52258),
(734, 42, 17, 'EL TAMBO', 52260),
(735, 42, 17, 'FUNES', 52287),
(736, 42, 17, 'GUACHUCAL', 52317),
(737, 42, 17, 'GUAITARILLA', 52320),
(738, 42, 17, 'GUALMATAN', 52323),
(739, 42, 17, 'ILES', 52352),
(740, 42, 17, 'IMUES', 52354),
(741, 42, 17, 'IPIALES', 52356),
(742, 42, 17, 'LA CRUZ', 52378),
(743, 42, 17, 'LA FLORIDA', 52381),
(744, 42, 17, 'LA LLANADA', 52385),
(745, 42, 17, 'LA TOLA', 52390),
(746, 42, 17, 'LA UNION', 52399),
(747, 42, 17, 'LEIVA', 52405),
(748, 42, 17, 'LINARES', 52411),
(749, 42, 17, 'LOS ANDES', 52418),
(750, 42, 17, 'MAGsI', 52427),
(751, 42, 17, 'MALLAMA', 52435),
(752, 42, 17, 'MOSQUERA', 52473),
(753, 42, 17, 'NARIÑO', 52480),
(754, 42, 17, 'OLAYA HERRERA', 52490),
(755, 42, 17, 'OSPINA', 52506),
(756, 42, 17, 'FRANCISCO PIZARRO', 52520),
(757, 42, 17, 'POLICARPA', 52540),
(758, 42, 17, 'POTOSI', 52560),
(759, 42, 17, 'PROVIDENCIA', 52565),
(760, 42, 17, 'PUERRES', 52573),
(761, 42, 17, 'PUPIALES', 52585),
(762, 42, 17, 'RICAURTE', 52612),
(763, 42, 17, 'ROBERTO PAYAN', 52621),
(764, 42, 17, 'SAMANIEGO', 52678),
(765, 42, 17, 'SANDONA', 52683),
(766, 42, 17, 'SAN BERNARDO', 52685),
(767, 42, 17, 'SAN LORENZO', 52687),
(768, 42, 17, 'SAN PABLO', 52693),
(769, 42, 17, 'SAN PEDRO DE CARTAGO', 52694),
(770, 42, 17, 'SANTA BARBARA', 52696),
(771, 42, 17, 'SANTACRUZ', 52699),
(772, 42, 17, 'SAPUYES', 52720),
(773, 42, 17, 'TAMINANGO', 52786),
(774, 42, 17, 'TANGUA', 52788),
(775, 42, 17, 'SAN ANDRES DE TUMACO', 52835),
(776, 42, 17, 'TUQUERRES', 52838),
(777, 42, 17, 'YACUANQUER', 52885),
(778, 42, 18, 'CUCUTA', 54001),
(779, 42, 18, 'ABREGO', 54003),
(780, 42, 18, 'ARBOLEDAS', 54051),
(781, 42, 18, 'BOCHALEMA', 54099),
(782, 42, 18, 'BUCARASICA', 54109),
(783, 42, 18, 'CACOTA', 54125),
(784, 42, 18, 'CACHIRA', 54128),
(785, 42, 18, 'CHINACOTA', 54172),
(786, 42, 18, 'CHITAGA', 54174),
(787, 42, 18, 'CONVENCION', 54206),
(788, 42, 18, 'CUCUTILLA', 54223),
(789, 42, 18, 'DURANIA', 54239),
(790, 42, 18, 'EL CARMEN', 54245),
(791, 42, 18, 'EL TARRA', 54250),
(792, 42, 18, 'EL ZULIA', 54261),
(793, 42, 18, 'GRAMALOTE', 54313),
(794, 42, 18, 'HACARI', 54344),
(795, 42, 18, 'HERRAN', 54347),
(796, 42, 18, 'LABATECA', 54377),
(797, 42, 18, 'LA ESPERANZA', 54385),
(798, 42, 18, 'LA PLAYA', 54398),
(799, 42, 18, 'LOS PATIOS', 54405),
(800, 42, 18, 'LOURDES', 54418),
(801, 42, 18, 'MUTISCUA', 54480),
(802, 42, 18, 'OCAÑA', 54498),
(803, 42, 18, 'PAMPLONA', 54518),
(804, 42, 18, 'PAMPLONITA', 54520),
(805, 42, 18, 'PUERTO SANTANDER', 54553),
(806, 42, 18, 'RAGONVALIA', 54599),
(807, 42, 18, 'SALAZAR', 54660),
(808, 42, 18, 'SAN CALIXTO', 54670),
(809, 42, 18, 'SAN CAYETANO', 54673),
(810, 42, 18, 'SANTIAGO', 54680),
(811, 42, 18, 'SARDINATA', 54720),
(812, 42, 18, 'SILOS', 54743),
(813, 42, 18, 'TEORAMA', 54800),
(814, 42, 18, 'TIBU', 54810),
(815, 42, 18, 'TOLEDO', 54820),
(816, 42, 18, 'VILLA CARO', 54871),
(817, 42, 18, 'VILLA DEL ROSARIO', 54874),
(818, 42, 19, 'ARMENIA', 63001),
(819, 42, 19, 'BUENAVISTA', 63111),
(820, 42, 19, 'CALARCA', 63130),
(821, 42, 19, 'CIRCASIA', 63190),
(822, 42, 19, 'CORDOBA', 63212),
(823, 42, 19, 'FILANDIA', 63272),
(824, 42, 19, 'GENOVA', 63302),
(825, 42, 19, 'LA TEBAIDA', 63401),
(826, 42, 19, 'MONTENEGRO', 63470),
(827, 42, 19, 'PIJAO', 63548),
(828, 42, 19, 'QUIMBAYA', 63594),
(829, 42, 19, 'SALENTO', 63690),
(830, 42, 20, 'PEREIRA', 66001),
(831, 42, 20, 'APIA', 66045),
(832, 42, 20, 'BALBOA', 66075),
(833, 42, 20, 'BELEN DE UMBRIA', 66088),
(834, 42, 20, 'DOSQUEBRADAS', 66170),
(835, 42, 20, 'GUATICA', 66318),
(836, 42, 20, 'LA CELIA', 66383),
(837, 42, 20, 'LA VIRGINIA', 66400),
(838, 42, 20, 'MARSELLA', 66440),
(839, 42, 20, 'MISTRATO', 66456),
(840, 42, 20, 'PUEBLO RICO', 66572),
(841, 42, 20, 'QUINCHIA', 66594),
(842, 42, 20, 'SANTA ROSA DE CABAL', 66682),
(843, 42, 20, 'SANTUARIO', 66687),
(844, 42, 21, 'BUCARAMANGA', 68001),
(845, 42, 21, 'AGUADA', 68013),
(846, 42, 21, 'ALBANIA', 68020),
(847, 42, 21, 'ARATOCA', 68051),
(848, 42, 21, 'BARBOSA', 68077),
(849, 42, 21, 'BARICHARA', 68079),
(850, 42, 21, 'BARRANCABERMEJA', 68081),
(851, 42, 21, 'BETULIA', 68092),
(852, 42, 21, 'BOLIVAR', 68101),
(853, 42, 21, 'CABRERA', 68121),
(854, 42, 21, 'CALIFORNIA', 68132),
(855, 42, 21, 'CAPITANEJO', 68147),
(856, 42, 21, 'CARCASI', 68152),
(857, 42, 21, 'CEPITA', 68160),
(858, 42, 21, 'CERRITO', 68162),
(859, 42, 21, 'CHARALA', 68167),
(860, 42, 21, 'CHARTA', 68169),
(861, 42, 21, 'CHIMA', 68176),
(862, 42, 21, 'CHIPATA', 68179),
(863, 42, 21, 'CIMITARRA', 68190),
(864, 42, 21, 'CONCEPCION', 68207),
(865, 42, 21, 'CONFINES', 68209),
(866, 42, 21, 'CONTRATACION', 68211),
(867, 42, 21, 'COROMORO', 68217),
(868, 42, 21, 'CURITI', 68229),
(869, 42, 21, 'EL CARMEN DE CHUCURI', 68235),
(870, 42, 21, 'EL GUACAMAYO', 68245),
(871, 42, 21, 'EL PEÑON', 68250),
(872, 42, 21, 'EL PLAYON', 68255),
(873, 42, 21, 'ENCINO', 68264),
(874, 42, 21, 'ENCISO', 68266),
(875, 42, 21, 'FLORIAN', 68271),
(876, 42, 21, 'FLORIDABLANCA', 68276),
(877, 42, 21, 'GALAN', 68296),
(878, 42, 21, 'GAMBITA', 68298),
(879, 42, 21, 'GIRON', 68307),
(880, 42, 21, 'GUACA', 68318),
(881, 42, 21, 'GUADALUPE', 68320),
(882, 42, 21, 'GUAPOTA', 68322),
(883, 42, 21, 'GUAVATA', 68324),
(884, 42, 21, 'GsEPSA', 68327),
(885, 42, 21, 'HATO', 68344),
(886, 42, 21, 'JESUS MARIA', 68368),
(887, 42, 21, 'JORDAN', 68370),
(888, 42, 21, 'LA BELLEZA', 68377),
(889, 42, 21, 'LANDAZURI', 68385),
(890, 42, 21, 'LA PAZ', 68397),
(891, 42, 21, 'LEBRIJA', 68406),
(892, 42, 21, 'LOS SANTOS', 68418),
(893, 42, 21, 'MACARAVITA', 68425),
(894, 42, 21, 'MALAGA', 68432),
(895, 42, 21, 'MATANZA', 68444),
(896, 42, 21, 'MOGOTES', 68464),
(897, 42, 21, 'MOLAGAVITA', 68468),
(898, 42, 21, 'OCAMONTE', 68498),
(899, 42, 21, 'OIBA', 68500),
(900, 42, 21, 'ONZAGA', 68502),
(901, 42, 21, 'PALMAR', 68522),
(902, 42, 21, 'PALMAS DEL SOCORRO', 68524),
(903, 42, 21, 'PARAMO', 68533),
(904, 42, 21, 'PIEDECUESTA', 68547),
(905, 42, 21, 'PINCHOTE', 68549),
(906, 42, 21, 'PUENTE NACIONAL', 68572),
(907, 42, 21, 'PUERTO PARRA', 68573),
(908, 42, 21, 'PUERTO WILCHES', 68575),
(909, 42, 21, 'RIONEGRO', 68615),
(910, 42, 21, 'SABANA DE TORRES', 68655),
(911, 42, 21, 'SAN ANDRES', 68669),
(912, 42, 21, 'SAN BENITO', 68673),
(913, 42, 21, 'SAN GIL', 68679),
(914, 42, 21, 'SAN JOAQUIN', 68682),
(915, 42, 21, 'SAN JOSE DE MIRANDA', 68684),
(916, 42, 21, 'SAN MIGUEL', 68686),
(917, 42, 21, 'SAN VICENTE DE CHUCURI', 68689),
(918, 42, 21, 'SANTA BARBARA', 68705),
(919, 42, 21, 'SANTA HELENA DEL OPON', 68720),
(920, 42, 21, 'SIMACOTA', 68745),
(921, 42, 21, 'SOCORRO', 68755),
(922, 42, 21, 'SUAITA', 68770),
(923, 42, 21, 'SUCRE', 68773),
(924, 42, 21, 'SURATA', 68780),
(925, 42, 21, 'TONA', 68820),
(926, 42, 21, 'VALLE DE SAN JOSE', 68855),
(927, 42, 21, 'VELEZ', 68861),
(928, 42, 21, 'VETAS', 68867),
(929, 42, 21, 'VILLANUEVA', 68872),
(930, 42, 21, 'ZAPATOCA', 68895),
(931, 42, 22, 'SINCELEJO', 70001),
(932, 42, 22, 'BUENAVISTA', 70110),
(933, 42, 22, 'CAIMITO', 70124),
(934, 42, 22, 'COLOSO', 70204),
(935, 42, 22, 'COROZAL', 70215),
(936, 42, 22, 'COVEÑAS', 70221),
(937, 42, 22, 'CHALAN', 70230),
(938, 42, 22, 'EL ROBLE', 70233),
(939, 42, 22, 'GALERAS', 70235),
(940, 42, 22, 'GUARANDA', 70265),
(941, 42, 22, 'LA UNION', 70400),
(942, 42, 22, 'LOS PALMITOS', 70418),
(943, 42, 22, 'MAJAGUAL', 70429),
(944, 42, 22, 'MORROA', 70473),
(945, 42, 22, 'OVEJAS', 70508),
(946, 42, 22, 'PALMITO', 70523),
(947, 42, 22, 'SAMPUES', 70670),
(948, 42, 22, 'SAN BENITO ABAD', 70678),
(949, 42, 22, 'SAN JUAN DE BETULIA', 70702),
(950, 42, 22, 'SAN MARCOS', 70708),
(951, 42, 22, 'SAN ONOFRE', 70713),
(952, 42, 22, 'SAN PEDRO', 70717),
(953, 42, 22, 'SAN LUIS DE SINCE', 70742),
(954, 42, 22, 'SUCRE', 70771),
(955, 42, 22, 'SANTIAGO DE TOLU', 70820),
(956, 42, 22, 'TOLU VIEJO', 70823),
(957, 42, 23, 'IBAGUE', 73001),
(958, 42, 23, 'ALPUJARRA', 73024),
(959, 42, 23, 'ALVARADO', 73026),
(960, 42, 23, 'AMBALEMA', 73030),
(961, 42, 23, 'ANZOATEGUI', 73043),
(962, 42, 23, 'ARMERO', 73055),
(963, 42, 23, 'ATACO', 73067),
(964, 42, 23, 'CAJAMARCA', 73124),
(965, 42, 23, 'CARMEN DE APICALA', 73148),
(966, 42, 23, 'CASABIANCA', 73152),
(967, 42, 23, 'CHAPARRAL', 73168),
(968, 42, 23, 'COELLO', 73200),
(969, 42, 23, 'COYAIMA', 73217),
(970, 42, 23, 'CUNDAY', 73226),
(971, 42, 23, 'DOLORES', 73236),
(972, 42, 23, 'ESPINAL', 73268),
(973, 42, 23, 'FALAN', 73270),
(974, 42, 23, 'FLANDES', 73275),
(975, 42, 23, 'FRESNO', 73283),
(976, 42, 23, 'GUAMO', 73319),
(977, 42, 23, 'HERVEO', 73347),
(978, 42, 23, 'HONDA', 73349),
(979, 42, 23, 'ICONONZO', 73352),
(980, 42, 23, 'LERIDA', 73408),
(981, 42, 23, 'LIBANO', 73411),
(982, 42, 23, 'MARIQUITA', 73443),
(983, 42, 23, 'MELGAR', 73449),
(984, 42, 23, 'MURILLO', 73461),
(985, 42, 23, 'NATAGAIMA', 73483),
(986, 42, 23, 'ORTEGA', 73504),
(987, 42, 23, 'PALOCABILDO', 73520),
(988, 42, 23, 'PIEDRAS', 73547),
(989, 42, 23, 'PLANADAS', 73555),
(990, 42, 23, 'PRADO', 73563),
(991, 42, 23, 'PURIFICACION', 73585),
(992, 42, 23, 'RIOBLANCO', 73616),
(993, 42, 23, 'RONCESVALLES', 73622),
(994, 42, 23, 'ROVIRA', 73624),
(995, 42, 23, 'SALDAÑA', 73671),
(996, 42, 23, 'SAN ANTONIO', 73675),
(997, 42, 23, 'SAN LUIS', 73678),
(998, 42, 23, 'SANTA ISABEL', 73686),
(999, 42, 23, 'SUAREZ', 73770),
(1000, 42, 23, 'VALLE DE SAN JUAN', 73854),
(1001, 42, 23, 'VENADILLO', 73861),
(1002, 42, 23, 'VILLAHERMOSA', 73870),
(1003, 42, 23, 'VILLARRICA', 73873),
(1004, 42, 24, 'CALI', 76001),
(1005, 42, 24, 'ALCALA', 76020),
(1006, 42, 24, 'ANDALUCIA', 76036),
(1007, 42, 24, 'ANSERMANUEVO', 76041),
(1008, 42, 24, 'ARGELIA', 76054),
(1009, 42, 24, 'BOLIVAR', 76100),
(1010, 42, 24, 'BUENAVENTURA', 76109),
(1011, 42, 24, 'GUADALAJARA DE BUGA', 76111),
(1012, 42, 24, 'BUGALAGRANDE', 76113),
(1013, 42, 24, 'CAICEDONIA', 76122),
(1014, 42, 24, 'CALIMA', 76126),
(1015, 42, 24, 'CANDELARIA', 76130),
(1016, 42, 24, 'CARTAGO', 76147),
(1017, 42, 24, 'DAGUA', 76233),
(1018, 42, 24, 'EL AGUILA', 76243),
(1019, 42, 24, 'EL CAIRO', 76246),
(1020, 42, 24, 'EL CERRITO', 76248),
(1021, 42, 24, 'EL DOVIO', 76250),
(1022, 42, 24, 'FLORIDA', 76275),
(1023, 42, 24, 'GINEBRA', 76306),
(1024, 42, 24, 'GUACARI', 76318),
(1025, 42, 24, 'JAMUNDI', 76364),
(1026, 42, 24, 'LA CUMBRE', 76377),
(1027, 42, 24, 'LA UNION', 76400),
(1028, 42, 24, 'LA VICTORIA', 76403),
(1029, 42, 24, 'OBANDO', 76497),
(1030, 42, 24, 'PALMIRA', 76520),
(1031, 42, 24, 'PRADERA', 76563),
(1032, 42, 24, 'RESTREPO', 76606),
(1033, 42, 24, 'RIOFRIO', 76616),
(1034, 42, 24, 'ROLDANILLO', 76622),
(1035, 42, 24, 'SAN PEDRO', 76670),
(1036, 42, 24, 'SEVILLA', 76736),
(1037, 42, 24, 'TORO', 76823),
(1038, 42, 24, 'TRUJILLO', 76828),
(1039, 42, 24, 'TULUA', 76834),
(1040, 42, 24, 'ULLOA', 76845),
(1041, 42, 24, 'VERSALLES', 76863),
(1042, 42, 24, 'VIJES', 76869),
(1043, 42, 24, 'YOTOCO', 76890),
(1044, 42, 24, 'YUMBO', 76892),
(1045, 42, 24, 'ZARZAL', 76895),
(1046, 42, 25, 'ARAUCA', 81001),
(1047, 42, 25, 'ARAUQUITA', 81065),
(1048, 42, 25, 'CRAVO NORTE', 81220),
(1049, 42, 25, 'FORTUL', 81300),
(1050, 42, 25, 'PUERTO RONDON', 81591),
(1051, 42, 25, 'SARAVENA', 81736),
(1052, 42, 25, 'TAME', 81794),
(1053, 42, 26, 'YOPAL', 85001),
(1054, 42, 26, 'AGUAZUL', 85010),
(1055, 42, 26, 'CHAMEZA', 85015),
(1056, 42, 26, 'HATO COROZAL', 85125),
(1057, 42, 26, 'LA SALINA', 85136),
(1058, 42, 26, 'MANI', 85139),
(1059, 42, 26, 'MONTERREY', 85162),
(1060, 42, 26, 'NUNCHIA', 85225),
(1061, 42, 26, 'OROCUE', 85230),
(1062, 42, 26, 'PAZ DE ARIPORO', 85250),
(1063, 42, 26, 'PORE', 85263),
(1064, 42, 26, 'RECETOR', 85279),
(1065, 42, 26, 'SABANALARGA', 85300),
(1066, 42, 26, 'SACAMA', 85315),
(1067, 42, 26, 'SAN LUIS DE PALENQUE', 85325),
(1068, 42, 26, 'TAMARA', 85400),
(1069, 42, 26, 'TAURAMENA', 85410),
(1070, 42, 26, 'TRINIDAD', 85430),
(1071, 42, 26, 'VILLANUEVA', 85440),
(1072, 42, 27, 'MOCOA', 86001),
(1073, 42, 27, 'COLON', 86219),
(1074, 42, 27, 'ORITO', 86320),
(1075, 42, 27, 'PUERTO ASIS', 86568),
(1076, 42, 27, 'PUERTO CAICEDO', 86569),
(1077, 42, 27, 'PUERTO GUZMAN', 86571),
(1078, 42, 27, 'LEGUIZAMO', 86573),
(1079, 42, 27, 'SIBUNDOY', 86749),
(1080, 42, 27, 'SAN FRANCISCO', 86755),
(1081, 42, 27, 'SAN MIGUEL', 86757),
(1082, 42, 27, 'SANTIAGO', 86760),
(1083, 42, 27, 'VALLE DEL GUAMUEZ', 86865),
(1084, 42, 27, 'VILLAGARZON', 86885),
(1085, 42, 28, 'SAN ANDRES', 88001),
(1086, 42, 28, 'PROVIDENCIA', 88564),
(1087, 42, 29, 'LETICIA', 91001),
(1088, 42, 29, 'EL ENCANTO', 91263),
(1089, 42, 29, 'LA CHORRERA', 91405),
(1090, 42, 29, 'LA PEDRERA', 91407),
(1091, 42, 29, 'LA VICTORIA', 91430),
(1092, 42, 29, 'MIRITI - PARANA', 91460),
(1093, 42, 29, 'PUERTO ALEGRIA', 91530),
(1094, 42, 29, 'PUERTO ARICA', 91536),
(1095, 42, 29, 'PUERTO NARIÑO', 91540),
(1096, 42, 29, 'PUERTO SANTANDER', 91669),
(1097, 42, 29, 'TARAPACA', 91798),
(1098, 42, 30, 'INIRIDA', 94001),
(1099, 42, 30, 'BARRANCO MINAS', 94343),
(1100, 42, 30, 'MAPIRIPANA', 94663),
(1101, 42, 30, 'SAN FELIPE', 94883),
(1102, 42, 30, 'PUERTO COLOMBIA', 94884),
(1103, 42, 30, 'LA GUADALUPE', 94885),
(1104, 42, 30, 'CACAHUAL', 94886),
(1105, 42, 30, 'PANA PANA', 94887),
(1106, 42, 30, 'MORICHAL', 94888),
(1107, 42, 31, 'SAN JOSE DEL GUAVIARE', 95001),
(1108, 42, 31, 'CALAMAR', 95015),
(1109, 42, 31, 'EL RETORNO', 95025),
(1110, 42, 31, 'MIRAFLORES', 95200),
(1111, 42, 32, 'MITU', 97001),
(1112, 42, 32, 'CARURU', 97161),
(1113, 42, 32, 'PACOA', 97511),
(1114, 42, 32, 'TARAIRA', 97666),
(1115, 42, 32, 'PAPUNAUA', 97777),
(1116, 42, 32, 'YAVARATE', 97889),
(1117, 42, 33, 'PUERTO CARREÑO', 99001),
(1118, 42, 33, 'LA PRIMAVERA', 99524),
(1119, 42, 33, 'SANTA ROSALIA', 99624),
(1120, 42, 33, 'CUMARIBO', 99773),
(1123, 232, 43, 'BARCELONA', 245),
(1124, 15, 38, 'Buenos Aires', 11),
(1125, 232, 42, 'CASTELLON', 1125);

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

--
-- Estructura de tabla para la tabla `tbl_comisiones`
--

CREATE TABLE `tbl_comisiones` (
  `id` int(11) NOT NULL COMMENT 'id de la tabla',
  `id_vendedor` int(11) NOT NULL COMMENT 'id del vendedor',
  `id_venta` int(11) NOT NULL COMMENT 'id de venta ',
  `vl_comision` int(11) NOT NULL COMMENT 'valor de la comision',
  `saldo` int(11) DEFAULT NULL COMMENT 'saldo de pendiente a favor del vendedor',
  `estado` varchar(50) COLLATE utf8_spanish_ci NOT NULL COMMENT 'estado de la comision'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

--
-- Estructura de tabla para la tabla `tbl_datoscomplementarios`
--

CREATE TABLE `tbl_datoscomplementarios` (
  `id` int(11) NOT NULL COMMENT 'id de la tabla',
  `id_usuario` int(11) NOT NULL COMMENT 'id de usuario ',
  `descripcion` varchar(1000) COLLATE utf8_spanish_ci NOT NULL COMMENT 'descripcion de los datos',
  `logo` varchar(1000) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'logo en caso de ser empresa',
  `foto` varchar(1000) COLLATE utf8_spanish_ci NOT NULL COMMENT 'foto del parfil'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

--
-- Estructura de tabla para la tabla `tbl_departamento`
--

CREATE TABLE `tbl_departamento` (
  `id` int(11) NOT NULL COMMENT 'id del departamento',
  `id_pais` int(11) NOT NULL COMMENT 'id de pais',
  `nombre` varchar(100) COLLATE utf8_spanish_ci NOT NULL COMMENT 'nombre del departamento'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_departamento` (`id`, `id_pais`, `nombre`) VALUES
(1, 42, 'ANTIOQUIA'),
(2, 42, 'ATLANTICO'),
(3, 42, 'BOGOTA'),
(4, 42, 'BOLIVAR'),
(5, 42, 'BOYACA'),
(6, 42, 'CALDAS'),
(7, 42, 'CAQUETA'),
(8, 42, 'CAUCA'),
(9, 42, 'CESAR'),
(10, 42, 'CORDOBA'),
(11, 42, 'CUNDINAMARCA'),
(12, 42, 'CHOCO'),
(13, 42, 'HUILA'),
(14, 42, 'LA GUAJIRA'),
(15, 42, 'MAGDALENA'),
(16, 42, 'META'),
(17, 42, 'NARIÑO'),
(18, 42, 'N. DE SANTANDER'),
(19, 42, 'QUINDIO'),
(20, 42, 'RISARALDA'),
(21, 42, 'SANTANDER'),
(22, 42, 'SUCRE'),
(23, 42, 'TOLIMA'),
(24, 42, 'VALLE DEL CAUCA'),
(25, 42, 'ARAUCA'),
(26, 42, 'CASANARE'),
(27, 42, 'PUTUMAYO'),
(28, 42, 'SAN ANDRES'),
(29, 42, 'AMAZONAS'),
(30, 42, 'GUAINIA'),
(31, 42, 'GUAVIARE'),
(32, 42, 'VAUPES'),
(33, 42, 'VICHADA'),
(37, 232, 'BARCELONA'),
(38, 15, 'CAPITAL FEDERAL'),
(42, 232, 'VALENCIA'),
(43, 232, 'CATALUÑA');

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

--
-- Estructura de tabla para la tabla `tbl_detallesvesntas`
--

CREATE TABLE `tbl_detallesvesntas` (
  `id` int(11) NOT NULL,
  `id_venta` int(11) NOT NULL,
  `id_producto` int(11) NOT NULL,
  `cant` int(11) NOT NULL,
  `id_color` int(11) NOT NULL,
  `id_empresa` int(11) NOT NULL,
  `estado_entrega` int(11) NOT NULL,
  `valor` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `tbl_detallesvesntas` (`id`, `id_venta`, `id_producto`, `cant`, `id_color`, `id_empresa`, `estado_entrega`, `valor`) VALUES
(1, 1, 1, 5, 1, 3, 1, 175000),
(2, 1, 1, 1, 1, 3, 1, 35000),
(3, 2, 1, 1, 1, 3, 1, 35000),
(4, 1, 3, 1, 4, 56, 2, 170),
(5, 2, 3, 1, 4, 56, 2, 170),
(6, 1, 5, 1, 7, 56, 2, 200000),
(7, 2, 5, 1, 7, 56, 2, 200000),
(8, 3, 5, 1, 7, 56, 2, 200000),
(9, 4, 5, 1, 7, 56, 2, 200000),
(10, 1, 5, 1, 7, 56, 1, 200000),
(11, 2, 5, 1, 7, 56, 1, 200000),
(12, 3, 5, 1, 7, 56, 1, 200000),
(13, 4, 5, 1, 7, 56, 1, 200000),
(14, 5, 5, 1, 7, 56, 1, 200000);

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

--
-- Estructura de tabla para la tabla `tbl_entidades`
--

CREATE TABLE `tbl_entidades` (
  `id` int(11) NOT NULL,
  `nombre` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `tbl_entidades` (`id`, `nombre`) VALUES
(1, 'Bancolombia'),
(2, 'Davivienda'),
(3, 'Efecty');

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

--
-- Estructura de tabla para la tabla `tbl_estado_pago`
--

CREATE TABLE `tbl_estado_pago` (
  `id` int(11) NOT NULL COMMENT 'id de la tabla',
  `estado` varchar(200) COLLATE utf8_spanish_ci NOT NULL COMMENT 'estado del pago',
  `medio` varchar(200) COLLATE utf8_spanish_ci NOT NULL COMMENT 'medio de pago'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_estado_pago` (`id`, `estado`, `medio`) VALUES
(1, 'Aprobado', 'Billetera'),
(2, 'Rechazado', 'Billetera'),
(3, 'Aprobado', 'Tarjeta'),
(4, 'Rechazado', 'Tarjeta'),
(5, 'Aprobado', 'Paypal'),
(6, 'Rechazado', 'Paypal'),
(7, 'Aprobado', 'Contraentrega'),
(8, 'Rechazado', 'Contraentrega'),
(9, 'Aprobado', 'Nequi'),
(10, 'Rechazado', 'Nequi'),
(11, 'Aprobado', 'PayU'),
(12, 'Rechazado', 'PayU');

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

--
-- Estructura de tabla para la tabla `tbl_estado_pedido`
--

CREATE TABLE `tbl_estado_pedido` (
  `id` int(11) NOT NULL COMMENT 'id del estado',
  `estado` varchar(200) COLLATE utf8_spanish_ci NOT NULL COMMENT 'descripcion del estado'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_estado_pedido` (`id`, `estado`) VALUES
(1, 'Pendiente'),
(2, 'Alistado'),
(3, 'Enviado'),
(4, 'Entregado');

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

--
-- Estructura de tabla para la tabla `tbl_favoritos`
--

CREATE TABLE `tbl_favoritos` (
  `id` int(11) NOT NULL COMMENT 'id de la tabla',
  `id_produto` int(11) NOT NULL COMMENT 'id del producto',
  `id_usuario` int(11) NOT NULL COMMENT 'id del usuario al que le gusta el producto',
  `fecha` datetime NOT NULL COMMENT 'fecha de creacion'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_favoritos` (`id`, `id_produto`, `id_usuario`, `fecha`) VALUES
(1, 1, 64, '2019-01-17 12:21:24');

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

--
-- Estructura de tabla para la tabla `tbl_ganancias`
--

CREATE TABLE `tbl_ganancias` (
  `id` int(11) NOT NULL,
  `id_usuario` int(11) DEFAULT NULL,
  `valor_comision` int(11) DEFAULT NULL,
  `egreso` int(11) DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `tbl_ganancias` (`id`, `id_usuario`, `valor_comision`, `egreso`) VALUES
(1, 5, NULL, 2),
(2, 1, 96625, 0),
(3, 1, 13346, 0),
(4, 1, 13346, 0),
(5, 1, 69000, 0),
(6, 1, 69000, 0);

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

--
-- Estructura de tabla para la tabla `tbl_marcador`
--

CREATE TABLE `tbl_marcador` (
  `id` int(11) NOT NULL COMMENT 'id de la tabla',
  `nombre` varchar(50) COLLATE utf8_spanish_ci NOT NULL COMMENT 'palabra clave o marcador para los productos'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

--
-- Estructura de tabla para la tabla `tbl_menuadmin`
--

CREATE TABLE `tbl_menuadmin` (
  `Menu` int(11) NOT NULL,
  `Submenu` int(11) NOT NULL,
  `perfil` varchar(50) DEFAULT NULL,
  `Nombre` varchar(50) DEFAULT NULL,
  `Link` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `tbl_menuadmin` (`Menu`, `Submenu`, `perfil`, `Nombre`, `Link`) VALUES
(0, 1, '1,2,3', 'Productos', '#'),
(0, 2, '1,2,3', 'Ventas', 'Ventas.php'),
(0, 3, '1', 'Usuarios', 'usuarios.php'),
(0, 4, '1,2,3,6', 'Entregas', 'entregas.php'),
(0, 5, '1,2,3,4,5,6', 'Administrar Cuenta', 'administrar.php'),
(1, 6, '1,2,3', 'Categorias', 'categorias.php'),
(1, 7, '1,2,3', 'SubCategorias', 'subcategorias.php'),
(1, 8, '1,2,3', 'Ver Productos', 'productos.php'),
(1, 9, '1', 'Aprobar Productos', 'Apruebaproductos.php'),
(5, 10, '1', 'Administrar Cuenta', 'administrar.php'),
(5, 11, '1', 'Configurar Porcentajes', 'porcentajes.php'),
(4, 12, '6', 'Ver productos listos', 'entregas.php'),
(4, 13, '1,6', 'Ver productos por entregar', 'tentrega.php'),
(5, 14, '1,2,3,4,5,6', 'Ver ganacias', 'ganancias.php'),
(5, 15, '1', 'Aprobar Trasnferencia', 'atranferencia.php'),
(1, 16, '1,2', 'Promocionar Productos', 'promocionar.php'),
(4, 17, '1', 'Entregas', 'entregas.php');

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

--
-- Estructura de tabla para la tabla `tbl_multimediaproducto`
--

CREATE TABLE `tbl_multimediaproducto` (
  `id` int(11) NOT NULL COMMENT 'id de la tabla',
  `id_producto` int(11) NOT NULL COMMENT 'id del producto con el cual se relaciona la multimedia',
  `url` varchar(1000) COLLATE utf8_spanish_ci NOT NULL COMMENT 'url del la multimedia',
  `tipo` varchar(500) COLLATE utf8_spanish_ci NOT NULL COMMENT 'que tipo de multimedia es (imagen o video) ',
  `color` varchar(20) COLLATE utf8_spanish_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_multimediaproducto` (`id`, `id_producto`, `url`, `tipo`, `color`) VALUES
(1, 1, 'images/1i1.jpg', 'imagen', '#004080'),
(2, 1, 'images/1i2.jpg', 'imagen', '#0000ff'),
(3, 1, 'ZNNYMxQQgRE', 'video', '#0080ff'),
(4, 3, 'images/3i4.jpg', 'imagen', '#000000'),
(5, 3, 'images/3i5.jpg', 'imagen', '#ff0080'),
(6, 4, 'images/4i6.jpg', 'imagen', '#ff80ff'),
(7, 5, 'images/5i7.jpg', 'imagen', '#c0c0c0');

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

--
-- Estructura de tabla para la tabla `tbl_pais`
--

CREATE TABLE `tbl_pais` (
  `id` int(11) NOT NULL COMMENT 'id del pais',
  `nombre` varchar(100) COLLATE utf8_spanish_ci NOT NULL COMMENT 'nombre del pais'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_pais` (`id`, `nombre`) VALUES
(1, 'AFGANISTAN'),
(2, 'ALBANIA'),
(3, 'ALEMANIA'),
(4, 'ARMENIA'),
(5, 'ARUBA'),
(6, 'BOSNIA-HERZEGOVINA'),
(7, 'BURKINA FASSO'),
(8, 'ANDORRA'),
(9, 'ANGOLA'),
(10, 'ANGUILLA'),
(11, 'ANTIGUA Y BARBUDA'),
(12, 'ANTILLAS HOLANDESAS'),
(13, 'ARABIA SAUDITA'),
(14, 'ARGELIA'),
(15, 'ARGENTINA'),
(16, 'AUSTRALIA'),
(17, 'AUSTRIA'),
(18, 'AZERBAIJAN'),
(19, 'BAHAMAS'),
(20, 'BAHREIN'),
(21, 'BANGLADESH'),
(22, 'BARBADOS'),
(23, 'BELGICA'),
(24, 'BELICE'),
(25, 'BERMUDAS'),
(26, 'BELARUS'),
(27, 'BIRMANIA (MYANMAR)'),
(28, 'BOLIVIA'),
(29, 'BOTSWANA'),
(30, 'BRASIL'),
(31, 'BRUNEI DARUSSALAM'),
(32, 'BULGARIA'),
(33, 'BURUNDI'),
(34, 'BUTAN'),
(35, 'CABO VERDE'),
(36, 'CAIMAN, ISLAS'),
(37, 'CAMBOYA (KAMPUCHEA)'),
(38, 'CAMERUN, REPUBLICA UNIDA DEL'),
(39, 'CANADA'),
(40, 'SANTA SEDE'),
(41, 'COCOS (KEELING), ISLAS'),
(42, 'COLOMBIA'),
(43, 'COMORAS'),
(44, 'CONGO'),
(45, 'COOK, ISLAS'),
(46, 'COREA (NORTE), REPUBLICA POPULAR DEMOCRATICA DE'),
(47, 'COREA (SUR), REPUBLICA DE'),
(48, 'COSTA DE MARFIL'),
(49, 'COSTA RICA'),
(50, 'CROACIA'),
(51, 'CUBA'),
(52, 'CHAD'),
(53, 'CHILE'),
(54, 'CHINA'),
(55, 'TAIWAN (FORMOSA)'),
(56, 'CHIPRE'),
(57, 'BENIN'),
(58, 'DINAMARCA'),
(59, 'DOMINICA'),
(60, 'ECUADOR'),
(61, 'EGIPTO'),
(62, 'EL SALVADOR'),
(63, 'ERITREA'),
(64, 'EMIRATOS ARABES UNIDOS'),
(65, 'ESPA'),
(66, 'ESLOVAQUIA'),
(67, 'ESLOVENIA'),
(68, 'ESTADOS UNIDOS'),
(69, 'ESTONIA'),
(70, 'ETIOPIA'),
(71, 'FEROE, ISLAS'),
(72, 'FILIPINAS'),
(73, 'FINLANDIA'),
(74, 'FRANCIA'),
(75, 'GABON'),
(76, 'GAMBIA'),
(77, 'GEORGIA'),
(78, 'GHANA'),
(79, 'GIBRALTAR'),
(80, 'GRANADA'),
(81, 'GRECIA'),
(82, 'GROENLANDIA'),
(83, 'GUADALUPE'),
(84, 'GUAM'),
(85, 'GUATEMALA'),
(86, 'GUAYANA FRANCESA'),
(87, 'GUINEA'),
(88, 'GUINEA ECUATORIAL'),
(89, 'GUINEA-BISSAU'),
(90, 'GUAYANA'),
(91, 'HAITI'),
(92, 'HONDURAS'),
(93, 'HONG KONG'),
(94, 'HUNGRIA'),
(95, 'INDIA'),
(96, 'INDONESIA'),
(97, 'IRAK'),
(98, 'IRAN, REPUBLICA ISLAMICA DEL'),
(99, 'IRLANDA (EIRE)'),
(100, 'ISLANDIA'),
(101, 'ISRAEL'),
(102, 'ITALIA'),
(103, 'JAMAICA'),
(104, 'JAPON'),
(105, 'JORDANIA'),
(106, 'KASAJSTAN'),
(107, 'KENIA'),
(108, 'KIRIBATI'),
(109, 'KIRGUIZISTAN'),
(110, 'KUWAIT'),
(111, 'LAOS, REPUBLICA POPULAR DEMOCRATICA DE'),
(112, 'LESOTHO'),
(113, 'LETONIA'),
(114, 'LIBANO'),
(115, 'LIBERIA'),
(116, 'LIBIA (INCLUYE FEZZAN)'),
(117, 'LIECHTENSTEIN'),
(118, 'LITUANIA'),
(119, 'LUXEMBURGO'),
(120, 'MACAO'),
(121, 'MACEDONIA'),
(122, 'MADAGASCAR'),
(123, 'MALAYSIA'),
(124, 'MALAWI'),
(125, 'MALDIVAS'),
(126, 'MALI'),
(127, 'MALTA'),
(128, 'MARIANAS DEL NORTE, ISLAS'),
(129, 'MARSHALL, ISLAS'),
(130, 'MARRUECOS'),
(131, 'MARTINICA'),
(132, 'MAURICIO'),
(133, 'MAURITANIA'),
(134, 'MEXICO'),
(135, 'MICRONESIA, ESTADOS FEDERADOS DE'),
(136, 'MOLDAVIA'),
(137, 'MONGOLIA'),
(138, 'MONACO'),
(139, 'MONSERRAT, ISLA'),
(140, 'MOZAMBIQUE'),
(141, 'NAMIBIA'),
(142, 'NAURU'),
(143, 'NAVIDAD (CHRISTMAS), ISLAS'),
(144, 'NEPAL'),
(145, 'NICARAGUA'),
(146, 'NIGER'),
(147, 'NIGERIA'),
(148, 'NIUE, ISLA'),
(149, 'NORFOLK, ISLA'),
(150, 'NORUEGA'),
(151, 'NUEVA CALEDONIA'),
(152, 'PAPUASIA NUEVA GUINEA'),
(153, 'NUEVA ZELANDIA'),
(154, 'VANUATU'),
(155, 'OMAN'),
(156, 'PACIFICO, ISLAS (USA)'),
(157, 'PAISES BAJOS (HOLANDA)'),
(158, 'PAKISTAN'),
(159, 'PALAU, ISLAS'),
(160, 'PANAMA'),
(161, 'PARAGUAY'),
(162, 'PERU'),
(163, 'PITCAIRN, ISLA'),
(164, 'POLINESIA FRANCESA'),
(165, 'POLONIA'),
(166, 'PORTUGAL'),
(167, 'PUERTO RICO'),
(168, 'QATAR'),
(169, 'REINO UNIDO'),
(170, 'REPUBLICA CENTROAFRICANA'),
(171, 'REPUBLICA CHECA'),
(172, 'REPUBLICA DOMINICANA'),
(173, 'REUNION'),
(174, 'ZIMBABWE'),
(175, 'RUMANIA'),
(176, 'RUANDA'),
(177, 'RUSIA'),
(178, 'SALOMON, ISLAS'),
(179, 'SAHARA OCCIDENTAL'),
(180, 'SAMOA'),
(181, 'SAMOA NORTEAMERICANA'),
(182, 'SAN CRISTOBAL Y NIEVES'),
(183, 'SAN MARINO'),
(184, 'SAN PEDRO Y MIGUELON'),
(185, 'SAN VICENTE Y LAS GRANADINAS'),
(186, 'SANTA ELENA'),
(187, 'SANTA LUCIA'),
(188, 'SANTO TOME Y PRINCIPE'),
(189, 'SENEGAL'),
(190, 'SEYCHELLES'),
(191, 'SIERRA LEONA'),
(192, 'SINGAPUR'),
(193, 'SIRIA, REPUBLICA ARABE DE'),
(194, 'SOMALIA'),
(195, 'SRI LANKA'),
(196, 'SUDAFRICA, REPUBLICA DE'),
(197, 'SUDAN'),
(198, 'SUECIA'),
(199, 'SUIZA'),
(200, 'SURINAM'),
(201, 'SWAZILANDIA'),
(202, 'TADJIKISTAN'),
(203, 'TAILANDIA'),
(204, 'TANZANIA, REPUBLICA UNIDA DE'),
(205, 'DJIBOUTI'),
(206, 'TERRITORIO BRITANICO DEL OCEANO INDICO'),
(207, 'TIMOR DEL ESTE'),
(208, 'TOGO'),
(209, 'TOKELAU'),
(210, 'TONGA'),
(211, 'TRINIDAD Y TOBAGO'),
(212, 'TUNICIA'),
(213, 'TURCAS Y CAICOS, ISLAS'),
(214, 'TURKMENISTAN'),
(215, 'TURQUIA'),
(216, 'TUVALU'),
(217, 'UCRANIA'),
(218, 'UGANDA'),
(219, 'URUGUAY'),
(220, 'UZBEKISTAN'),
(221, 'VENEZUELA'),
(222, 'VIET NAM'),
(223, 'VIRGENES, ISLAS (BRITANICAS)'),
(224, 'VIRGENES, ISLAS (NORTEAMERICANAS)'),
(225, 'FIJI'),
(226, 'WALLIS Y FORTUNA, ISLAS'),
(227, 'YEMEN'),
(228, 'YUGOSLAVIA'),
(229, 'ZAIRE'),
(230, 'ZAMBIA'),
(231, 'ZONA NEUTRAL PALESTINA'),
(232, 'ESPAÑA');

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

--
-- Estructura de tabla para la tabla `tbl_pedidos`
--

CREATE TABLE `tbl_pedidos` (
  `id` int(11) NOT NULL COMMENT 'id de la tabla',
  `id_venta` int(11) NOT NULL COMMENT 'id de la venta ',
  `id_usuario` int(11) NOT NULL COMMENT 'id del usuario que compro',
  `estado` int(11) NOT NULL COMMENT 'id del estado',
  `id_mensajero` int(11) NOT NULL COMMENT 'id del mensajero',
  `fecha_entrega` datetime NOT NULL COMMENT 'fecha en la que se entrega el pedido'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

--
-- Estructura de tabla para la tabla `tbl_perfiles`
--

CREATE TABLE `tbl_perfiles` (
  `id` int(11) NOT NULL COMMENT 'id de la tabla',
  `nombre` varchar(50) COLLATE utf8_spanish_ci NOT NULL COMMENT 'nombre del perfil',
  `permisos` varchar(60) COLLATE utf8_spanish_ci NOT NULL COMMENT 'accesos del perfil'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_perfiles` (`id`, `nombre`, `permisos`) VALUES
(1, 'Admin', 'All'),
(2, 'Empresa Pro', 'Promocionar,Empresa,Vendedorpro,Cliente'),
(3, 'Empresa', 'Empresa,VendedorPro,Cliente'),
(4, 'Vendedor Pro', 'VendedorPro, Cliente'),
(5, 'Vendedor', 'Vendedor,Cliente'),
(6, 'Distribuidor', 'Distri,Vendedor Free, Cliente'),
(7, 'Cliente', 'Cliente');

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

--
-- Estructura de tabla para la tabla `tbl_procentajes`
--

CREATE TABLE `tbl_procentajes` (
  `id` int(11) NOT NULL,
  `perfil` int(11) DEFAULT NULL,
  `porcentaje` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `tbl_procentajes` (`id`, `perfil`, `porcentaje`) VALUES
(2, 1, 50),
(3, 2, 20),
(4, 3, 15),
(5, 4, 20),
(6, 5, 15),
(7, 6, 5);

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

--
-- Estructura de tabla para la tabla `tbl_producto`
--

CREATE TABLE `tbl_producto` (
  `id` int(11) NOT NULL COMMENT 'id de la tabla',
  `nodo` int(11) NOT NULL COMMENT 'nodo de la categoria',
  `opcion` int(11) NOT NULL COMMENT 'opcion de la categoria',
  `nombre` varchar(1000) COLLATE utf8_spanish_ci NOT NULL COMMENT 'nombre del producto',
  `referencia` varchar(1000) COLLATE utf8_spanish_ci NOT NULL COMMENT 'referencia del producto',
  `caracteristicas` text COLLATE utf8_spanish_ci NOT NULL COMMENT 'caracteristicas del producto (todas las que necesite)',
  `talla` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'talla del producto',
  `genero` varchar(50) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'genero del producto',
  `precio_empresa` int(11) NOT NULL COMMENT 'precio en que lo ofrece la empresa a la plataforma',
  `precio_publico` int(11) NOT NULL COMMENT 'precio al publico del producto',
  `cantidad` int(11) NOT NULL COMMENT 'cantidad existente',
  `id_empresa` int(11) NOT NULL COMMENT 'id de la empresa',
  `marcadores` varchar(5000) COLLATE utf8_spanish_ci NOT NULL COMMENT 'marcadores o palabras clave',
  `estado` varchar(200) COLLATE utf8_spanish_ci DEFAULT NULL,
  `Promocion` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_producto` (`id`, `nodo`, `opcion`, `nombre`, `referencia`, `caracteristicas`, `talla`, `genero`, `precio_empresa`, `precio_publico`, `cantidad`, `id_empresa`, `marcadores`, `estado`, `Promocion`) VALUES
(1, 1, 2, 'jean azul', 'pantalon ti´po jean color azul ', 'qweqweqweqweqweweqwe', '23', 'femenino', 25000, 35000, 5, 3, '1', 'Aprobado', 1),
(2, 1, 2, 'Pantalon de pruebas', '12', 'ok\r\nok\r\nok\r\nok\r\nok', 'L', 'F', 1000, 1500, 100, 33, 'b,b,b', 'Aprobado', NULL),
(3, 3, 2, 'computador', 'acer', 'con pc, mouse y teclado ', 'd', 'computador ', 160, 170, -1, 56, 'd', 'Aprobado', NULL),
(4, 1, 7, 'TENIS ', 'ADIDAS ', 'zapatillas ', 'd', 'computador ', 250, 320000, 5, 56, 'd', 'Aprobado', NULL),
(5, 8, 9, 'sala', 'hj', 'sofá hogar', 'unica', 'h', 100000, 200000, 7, 56, '2', 'Aprobado', NULL);

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

--
-- Estructura de tabla para la tabla `tbl_temp_ventas`
--

CREATE TABLE `tbl_temp_ventas` (
  `id` int(11) NOT NULL,
  `id_ss` varchar(2000) DEFAULT NULL,
  `id_producto` int(11) DEFAULT NULL,
  `id_color` int(11) DEFAULT NULL,
  `cant` int(11) DEFAULT NULL,
  `talla` varchar(20) DEFAULT NULL,
  `fecha` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `tbl_temp_ventas` (`id`, `id_ss`, `id_producto`, `id_color`, `cant`, `talla`, `fecha`) VALUES
(1, 'k565rjmd9cnchqo4pcnbrp01j0', 1, 0, 1, NULL, '2018-10-18 17:18:07'),
(2, 'uaiq170pf6n6k4o8d7abl9k956', 1, 1, 1, NULL, '2018-11-08 11:29:10'),
(3, 'uaiq170pf6n6k4o8d7abl9k956', 1, 1, 1, NULL, '2018-11-08 11:31:57'),
(4, 'uaiq170pf6n6k4o8d7abl9k956', 1, 1, 1, NULL, '2018-11-08 11:32:01'),
(5, 'uaiq170pf6n6k4o8d7abl9k956', 1, 1, 1, NULL, '2018-11-08 11:32:03'),
(6, 'uaiq170pf6n6k4o8d7abl9k956', 1, 1, 1, NULL, '2018-11-08 11:32:05'),
(7, 'uaiq170pf6n6k4o8d7abl9k956', 1, 1, 1, NULL, '2018-11-08 11:32:07'),
(8, 'uaiq170pf6n6k4o8d7abl9k956', 1, 1, 1, NULL, '2018-11-08 11:32:10'),
(9, 'b3su9tgqvqcvr56g1sblg4kkg3', 1, 2, 2, NULL, '2018-11-27 09:57:43'),
(10, 'pfsnlk20i5bi2cg2iqfkkm0kh3', 1, 1, 1, NULL, '2018-11-30 10:35:37'),
(11, '4a8bkga52scjk8m6nfqhs6b4r3', 1, 1, 1, NULL, '2018-12-03 15:40:21'),
(12, 'ohlljji6pcsbhopqnc8059req0', 1, 1, 1, NULL, '2018-12-05 11:11:40'),
(13, 'l8tmn5q56ap33i0abh9pt81o61', 1, 1, 1, NULL, '2018-12-14 15:07:46'),
(14, 'qq9kn1ci79snkf0oj2mtmcrph3', 3, 4, 1, NULL, '2018-12-17 13:13:16'),
(20, 'jte2an5mk2va26mvpmet6d41j5', 5, 7, 1, NULL, '2018-12-20 10:54:13'),
(21, '5hpst5d1p92njjiqg8qmtv0au7', 2, 0, 1, NULL, '2018-12-20 11:10:05'),
(22, 'ps74ncegalhn49vetqn31b2mu5', 4, 0, 1, NULL, '2019-01-14 12:06:49'),
(25, 'r2r168tukkj577k5gk7fng6hs1', 1, 1, 1, NULL, '2019-01-22 14:24:12');

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

--
-- Estructura de tabla para la tabla `tbl_tranferencias`
--

CREATE TABLE `tbl_tranferencias` (
  `id` int(11) NOT NULL,
  `id_usuario` int(11) DEFAULT NULL,
  `valor` int(11) DEFAULT NULL,
  `entidad` varchar(200) DEFAULT NULL,
  `numero_cuenta` bigint(20) DEFAULT NULL,
  `fecha_solicitud` date DEFAULT NULL,
  `fecha_aprobacion` date DEFAULT NULL,
  `estado` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `tbl_tranferencias` (`id`, `id_usuario`, `valor`, `entidad`, `numero_cuenta`, `fecha_solicitud`, `fecha_aprobacion`, `estado`) VALUES
(1, 0, 300000, 'Davivienda', 900321768, '2018-09-04', NULL, 'Rechazado'),
(2, 0, 300000, 'Efecty', 1019037040, '2018-09-04', NULL, 'Rechazado'),
(3, 0, 300000, 'Davivienda', 90123012312, '2018-09-04', NULL, 'Rechazado'),
(4, 31, 300000, 'Bancolombia', 900123787123, '2018-09-04', NULL, 'Rechazado'),
(5, 58, 5000, 'Bancolombia', 5555555, '2018-09-19', NULL, 'Aprobado'),
(6, 5, 2, 'Efecty', 567890, '2018-09-26', NULL, 'Aprobado');

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

--
-- Estructura de tabla para la tabla `tbl_usuarios`
--

CREATE TABLE `tbl_usuarios` (
  `id` int(11) NOT NULL COMMENT 'id de la tabla',
  `documento` int(11) NOT NULL COMMENT 'documento de identidad de usuario',
  `Nombres` varchar(1000) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'nombre del usuario',
  `Apellidos` varchar(1000) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'apellidos del usuario',
  `Razon_social` varchar(1000) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'razon social en caso de ser empresa',
  `direccion` varchar(500) COLLATE utf8_spanish_ci NOT NULL COMMENT 'direccion donde se ubica el usario',
  `telefono` varchar(300) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'telefono fijo del usuario',
  `celular` varchar(300) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'calular del usuario',
  `pais` int(11) NOT NULL COMMENT 'codigo del pais ',
  `departamento` int(11) NOT NULL COMMENT 'codigo del departamento',
  `ciudad` int(11) NOT NULL COMMENT 'codigo de la ciudad',
  `email` varchar(500) COLLATE utf8_spanish_ci DEFAULT NULL COMMENT 'email del usuario',
  `contrasenia` varchar(500) COLLATE utf8_spanish_ci NOT NULL COMMENT 'contraseña para ingreso a la plataforma',
  `cod_promocional` varchar(500) COLLATE utf8_spanish_ci NOT NULL COMMENT 'codigo promocional autogenerado 4  iniciales del nombre- 4 numeros de documento y id de la tabla',
  `perfil` int(11) NOT NULL COMMENT 'id del perfil en la plataforma',
  `estado` int(11) NOT NULL COMMENT 'estado del usuario',
  `imagen` text COLLATE utf8_spanish_ci,
  `cod_empresa` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_usuarios` (`id`, `documento`, `Nombres`, `Apellidos`, `Razon_social`, `direccion`, `telefono`, `celular`, `pais`, `departamento`, `ciudad`, `email`, `contrasenia`, `cod_promocional`, `perfil`, `estado`, `imagen`, `cod_empresa`) VALUES
(1, 123456789, 'admin', 'admin', '', 'centro madrugon', '3210009933', '3123000123', 42, 3, 149, 'admin@admin.com', '$P$JFpn5v0kjYsybnSS3UJkP83x4hsxQ80', '123ADM1', 1, 1, NULL, NULL),
(55, 0, NULL, NULL, 'William', '', NULL, NULL, 0, 0, 0, 'sthewcolgamer@gmail.com', '$P$JfiGa/ch92pGd6mUkBT4lWTxmAuJTJ/', '1', 3, 1, NULL, NULL),
(56, 0, NULL, NULL, 'Juli perez', '', NULL, NULL, 0, 0, 0, 'Juliperez12@hotmail.com', '$P$JtxeeXa.2s1v26yYOlE.Q0mHO3prvf/', '1', 3, 1, NULL, NULL),
(57, 78806123, 'andres', 'caballero', NULL, 'cra 69d #1-60 sur', '', '', 0, 0, 0, 'andr_caballero@hotmail.com', '$P$JuFknpen2WmnmkH6n/jY4.hl9yeWR3/', '1', 7, 1, NULL, NULL),
(58, 0, NULL, NULL, 'Juli perez', '', NULL, NULL, 0, 0, 0, 'Juliperez12@hotmail.com', '$P$JfsUqr8rPxKhpUTCDlzUwPOye1Kuwl/', '1', 3, 0, NULL, NULL),
(59, 0, 'karen', 'perez', NULL, '', NULL, NULL, 0, 0, 0, 'karenkpi@live.com', '$P$JHJGHx2PfFc5iFGhZX10vFXFj0.dEx1', '1', 5, 1, NULL, NULL),
(60, 0, 'oscar', 'gualteros', NULL, '', NULL, NULL, 0, 0, 0, 'oscarec01@gmail.com', 'skladjalskdjklññllkke12323###())((///33334))', '', 1, 1, 'https://lh6.googleusercontent.com/-DdywjfDuyaM/AAAAAAAAAAI/AAAAAAAAAb8/Z1I2V64Ezys/photo.jpg?sz=200', NULL),
(61, 0, 'Sebastian', 'Cortes', NULL, '', NULL, NULL, 0, 0, 0, 'sebaacoes@gmail.com', 'skladjalskdjklññllkke12323###())((///33334))', '', 7, 0, 'https://graph.facebook.com/478890005966812/picture?width=150&height=150', NULL),
(62, 0, 'andres felipe', 'caballero gonzalez', NULL, '', NULL, NULL, 0, 0, 0, 'andr_caballero@hotmail.com', '$P$J7dqigu72YM8rhOS0KQqXDCDZ1vFYo.', '1', 5, 0, NULL, NULL),
(63, 0, 'miguel angel', 'ruiz ', NULL, '', NULL, NULL, 0, 0, 0, 'andr_caballero@hotmail.com', '$P$JHQBAHgmew43Q/BildXzTQ5x5p74lG0', '1', 7, 0, NULL, NULL),
(64, 0, 'JULI ', 'perez', NULL, '', NULL, NULL, 0, 0, 0, 'julieths.perezd@gmail.com', '$P$JfRVSV52Hbicx0GiT3eMdZxJBQQjZy1', '1', 7, 1, NULL, NULL);

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

--
-- Estructura de tabla para la tabla `tbl_usuarios_social`
--

CREATE TABLE `tbl_usuarios_social` (
  `id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `social_id` text,
  `service` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `tbl_usuarios_social` (`id`, `user_id`, `social_id`, `service`) VALUES
(12, 21, '10156615028563810', 'Facebook'),
(13, 10, '1320221758113585', 'Facebook'),
(14, 31, '110188687769860936073', 'Google'),
(15, 21, '169600039', 'Twitter'),
(16, 34, '10155815204807215', 'Facebook'),
(17, 11, '105802568059650015090', 'Google'),
(18, 35, '10155815204807215', 'Facebook'),
(19, 36, '10155815204807215', 'Facebook'),
(20, 12, '1035197988170342400', 'Twitter'),
(21, 56, '10155815204807215', 'Facebook'),
(22, 57, '115236757743086373180', 'Google'),
(23, 58, '10210135380180605', 'Facebook'),
(24, 3, '110188687769860936073', 'Google'),
(25, 5, '2203523759895826', 'Facebook'),
(26, 6, '114745129494213', 'Facebook'),
(27, 10, '10156615028563810', 'Facebook'),
(28, 10, '169600039', 'Twitter'),
(29, 16, '10210135380180605', 'Facebook'),
(30, 60, '110188687769860936073', 'Google'),
(31, 61, '478890005966812', 'Facebook'),
(32, 59, '2203523759895826', 'Facebook'),
(33, 56, '333776264', 'Twitter');

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

--
-- Estructura de tabla para la tabla `tbl_ventas`
--

CREATE TABLE `tbl_ventas` (
  `id` int(11) NOT NULL COMMENT 'id de la tabla',
  `id_usuario` int(11) NOT NULL COMMENT 'id del usuario',
  `id_se` varchar(200) COLLATE utf8_spanish_ci NOT NULL,
  `precio_total` int(11) NOT NULL COMMENT 'precio total del producto',
  `cod_vend` varchar(200) COLLATE utf8_spanish_ci NOT NULL COMMENT 'id del vendedor',
  `estado_pago` int(11) NOT NULL COMMENT 'estado del pago',
  `tp_envio` int(11) DEFAULT NULL,
  `fecha_pedido` date NOT NULL COMMENT 'fecha del pedido',
  `fecha_aprobacion` date NOT NULL COMMENT 'fecha de aprobacion del pedido',
  `id_mensajero` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

INSERT INTO `tbl_ventas` (`id`, `id_usuario`, `id_se`, `precio_total`, `cod_vend`, `estado_pago`, `tp_envio`, `fecha_pedido`, `fecha_aprobacion`, `id_mensajero`) VALUES
(1, 3, 'k9d4r7dr16jm4mod7pvl3dbot7', 218250, '', 4, 2, '2018-10-01', '2018-10-01', NULL),
(2, 60, 'ir08922o47hmodftp0m1pk9eh4', 51852, '', 5, 2, '2018-12-18', '2018-12-18', NULL),
(3, 57, 'ir08922o47hmodftp0m1pk9eh4', 51852, '', 6, 2, '2018-12-18', '2018-12-18', NULL),
(4, 57, 'ir08922o47hmodftp0m1pk9eh4', 238000, '', 5, 1, '2018-12-18', '2018-12-18', NULL),
(5, 64, 'f12q4i12bp3i3iqmui72cj6rd7', 238000, '', 1, 1, '2019-01-24', '2019-01-24', NULL);

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

--
-- Estructura de tabla para la tabla `tokens`
--

CREATE TABLE `tokens` (
  `id` int(11) NOT NULL,
  `email` varchar(300) NOT NULL,
  `token` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `tokens` (`id`, `email`, `token`) VALUES
(10, 'sthewcolgamer@gmail.com', '102ab2815ffbe01b988097b6c5902d0e'),
(11, 'william.matiz@hotmail.com', '9b411cc8c92e5d384a6fa08b3ca55552'),
(12, 'william.matiz@hotmail.com', '467cc9b0fce70c8adf71a9640bc9c776'),
(13, 'sthewcolgamer@gmail.com', '5db3cc54be1afc0ff318e49f908aa71c'),
(14, 'sthewcolgamer@gmail.com', 'bbfb90ea572cbe0d627bd533a33564cf'),
(15, 'sthewcolgamer@gmail.com', '41124322eca9d8b8814aa56f454d53b2'),
(16, 'william.matiz@hotmail.com', '2e2d15e70bbf5e44c338bfc05b5e37fb'),
(17, 'william.matiz@hotmail.com', 'c1fd416ec96b3a58abffd1a48bbfa05d'),
(18, 'sthewcolgamer@gmail.com', 'bc3eb6160242b2c04576da4710b7b60a'),
(19, 'sthewcolgamer@gmail.com', 'b8ec81342df919a1898b6f02d7dca3ab'),
(20, 'Juliperez12@hotmail.com', '6b6ec879ce1ff3efab0de62e6d01be86'),
(21, 'andr_caballero@hotmail.com', '7540116bfdeeefb950002afed286f925'),
(22, 'Juliperez12@hotmail.com', '2a018c72f39c8eeebd46a28663bbc75b'),
(23, 'karenkpi@live.com', 'c6ee078dd7346f710a903d415d9d7c99'),
(24, 'andr_caballero@hotmail.com', '918be12a23f9a26505b2fc6a0283f323'),
(25, 'andr_caballero@hotmail.com', '9b89f79e61db4665e1083924c6163555'),
(26, 'julieths.perezd@gmail.com', '908c7dde632f821f6c7eb99529e96cbb');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `tbl_categorias`
--
ALTER TABLE `tbl_categorias`
  ADD PRIMARY KEY (`opcion`);

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

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

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

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

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

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

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

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

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

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

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

--
-- Indices de la tabla `tbl_menuadmin`
--
ALTER TABLE `tbl_menuadmin`
  ADD PRIMARY KEY (`Submenu`);

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `tbl_ciudad`
--
ALTER TABLE `tbl_ciudad`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id de la ciudad', AUTO_INCREMENT=1126;

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

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

--
-- AUTO_INCREMENT de la tabla `tbl_departamento`
--
ALTER TABLE `tbl_departamento`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id del departamento', AUTO_INCREMENT=44;

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

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

--
-- AUTO_INCREMENT de la tabla `tbl_estado_pago`
--
ALTER TABLE `tbl_estado_pago`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id de la tabla', AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT de la tabla `tbl_estado_pedido`
--
ALTER TABLE `tbl_estado_pedido`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id del estado', AUTO_INCREMENT=5;

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

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

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

--
-- AUTO_INCREMENT de la tabla `tbl_multimediaproducto`
--
ALTER TABLE `tbl_multimediaproducto`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id de la tabla', AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT de la tabla `tbl_pais`
--
ALTER TABLE `tbl_pais`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id del pais', AUTO_INCREMENT=233;

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

--
-- AUTO_INCREMENT de la tabla `tbl_perfiles`
--
ALTER TABLE `tbl_perfiles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id de la tabla', AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT de la tabla `tbl_producto`
--
ALTER TABLE `tbl_producto`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id de la tabla', AUTO_INCREMENT=6;

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

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

--
-- AUTO_INCREMENT de la tabla `tbl_usuarios`
--
ALTER TABLE `tbl_usuarios`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id de la tabla', AUTO_INCREMENT=65;

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

--
-- AUTO_INCREMENT de la tabla `tbl_ventas`
--
ALTER TABLE `tbl_ventas`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id de la tabla', AUTO_INCREMENT=6;

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

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