-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3306
-- Tiempo de generación: 02-07-2026 a las 21:17:27
-- Versión del servidor: 5.7.33
-- Versión de PHP: 7.3.12

START TRANSACTION;



--
-- Base de datos: `sterling`
--

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

--
-- Estructura de tabla para la tabla `abonoscxc`
--

CREATE TABLE `abonoscxc` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nroFactura` double NOT NULL DEFAULT '0',
  `cedula` double NOT NULL DEFAULT '0',
  `cliente` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha` date NOT NULL,
  `abono` decimal(20,2) NOT NULL DEFAULT '0.00',
  `cajero` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forma` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `abonoscxp`
--

CREATE TABLE `abonoscxp` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nroFactura` double NOT NULL DEFAULT '0',
  `cedula` double NOT NULL DEFAULT '0',
  `proveedor` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha` date NOT NULL,
  `abono` decimal(20,2) NOT NULL DEFAULT '0.00',
  `cajero` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forma` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `activos`
--

CREATE TABLE `activos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cantidad` decimal(15,2) NOT NULL,
  `precio` decimal(15,2) NOT NULL,
  `clase` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `activos` (`id`, `name`, `cantidad`, `precio`, `clase`, `fecha`) VALUES
(1, 'Caja y bancos', 1.00, 5000.00, 'AC', '2024-07-26'),
(2, 'Cuentas por cobrar', 1.00, 10000.00, 'AC', '2024-07-26'),
(3, 'Inventarios', 1.00, 15000.00, 'AC', '2024-07-26'),
(4, 'Otros activos corrientes', 1.00, 2000.00, 'AC', '2024-07-26'),
(5, 'Propiedad, planta y equipo', 1.00, 50000.00, 'ANC', '2024-07-26'),
(6, 'Activos intangibles', 1.00, 5000.00, 'ANC', '2024-07-26'),
(7, 'Cuentas por Pagar', 1.00, 4000.00, 'PC', '2024-07-26'),
(8, 'Préstamos a Corto Plazo', 1.00, 3000.00, 'PC', '2024-07-26'),
(9, 'Otros Pasivos Corrientes', 1.00, 1000.00, 'PC', '2024-07-26'),
(10, 'Pasivos No Corrientes', 1.00, 1000.00, 'PNC', '2024-07-26'),
(11, 'Préstamos a Largo Plazo', 1.00, 15000.00, 'PNC', '2024-07-26'),
(12, 'Capital Social', 1.00, 55000.00, 'PTN', '2024-07-26'),
(13, 'Utilidades Retenidas', 1.00, 8000.00, 'PTN', '2024-07-26');

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

--
-- Estructura de tabla para la tabla `ajustes`
--

CREATE TABLE `ajustes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `fecha` date NOT NULL,
  `numero` double NOT NULL,
  `codigo` double NOT NULL,
  `nombre` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `unidad` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `stock` decimal(20,2) NOT NULL DEFAULT '0.00',
  `precio` decimal(20,2) NOT NULL DEFAULT '0.00',
  `entrada` decimal(20,2) NOT NULL DEFAULT '0.00',
  `Vtentrada` decimal(20,2) NOT NULL DEFAULT '0.00',
  `salida` decimal(20,2) NOT NULL DEFAULT '0.00',
  `Vtsalida` decimal(20,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `auditoria`
--

CREATE TABLE `auditoria` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `fecha` date NOT NULL,
  `numero` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `cardex`
--

CREATE TABLE `cardex` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sale_id` double NOT NULL DEFAULT '0',
  `entry_id` double NOT NULL DEFAULT '0',
  `codigo` double NOT NULL,
  `nombre` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `salidas` decimal(20,2) NOT NULL DEFAULT '0.00',
  `v_salida` decimal(20,2) NOT NULL DEFAULT '0.00',
  `entradas` decimal(20,2) NOT NULL DEFAULT '0.00',
  `v_entrada` decimal(20,2) NOT NULL DEFAULT '0.00',
  `stock` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `v_decompra` decimal(20,2) NOT NULL DEFAULT '0.00',
  `caja` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha` date NOT NULL,
  `motivo` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `hubicador` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `categorias`
--

CREATE TABLE `categorias` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categorias` (`id`, `name`, `state`, `created_at`, `updated_at`) VALUES
(1, 'Medicamentos', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(2, 'Inyectologia', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(3, 'Gaseosa', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(4, 'Servicios', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(5, 'Ingresos financieros', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(6, 'Intereses de deuda', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49');

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

--
-- Estructura de tabla para la tabla `cierre`
--

CREATE TABLE `cierre` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `fecha` date NOT NULL,
  `facturado` decimal(20,2) NOT NULL DEFAULT '0.00',
  `pos` decimal(20,2) NOT NULL DEFAULT '0.00',
  `recogio` decimal(20,2) NOT NULL DEFAULT '0.00',
  `efectivo` decimal(20,2) NOT NULL DEFAULT '0.00',
  `credito` decimal(20,2) NOT NULL DEFAULT '0.00',
  `transferencia` decimal(20,2) NOT NULL DEFAULT '0.00',
  `abonos` decimal(20,2) NOT NULL DEFAULT '0.00',
  `gastos` decimal(20,2) NOT NULL DEFAULT '0.00',
  `devolucion` decimal(20,2) NOT NULL DEFAULT '0.00',
  `resultado` decimal(20,2) NOT NULL DEFAULT '0.00',
  `caja` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `clients`
--

CREATE TABLE `clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `type_organizations` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_regimens` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_document_identification` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_liabilities` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dv` int(11) NOT NULL,
  `names` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `departamento` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `municipio` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `direction` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `clients` (`id`, `type_organizations`, `type_regimens`, `type_document_identification`, `type_liabilities`, `number`, `dv`, `names`, `departamento`, `municipio`, `telephone`, `direction`, `email`, `state`, `created_at`, `updated_at`) VALUES
(1, 'Persona Natural', 'No responsable de IVA', 'Cédula de ciudadania', 'No responsable', '222222222222', 7, 'Cliente POS', 'Huila', 'Neiva', '1111111111', 'CALLE 1 Nro 1 - 01', 'clientepos@gmail.com', '1', NULL, NULL);

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

--
-- Estructura de tabla para la tabla `cxc`
--

CREATE TABLE `cxc` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `idNroFactura` double NOT NULL DEFAULT '0',
  `nroFactura` double NOT NULL DEFAULT '0',
  `cedula` double NOT NULL DEFAULT '0',
  `cliente` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha` date NOT NULL,
  `valor` decimal(20,2) NOT NULL DEFAULT '0.00',
  `abono` decimal(20,2) NOT NULL DEFAULT '0.00',
  `saldo` decimal(20,2) NOT NULL DEFAULT '0.00',
  `cajero` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forma` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `municipio` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `cxc_excel`
--

CREATE TABLE `cxc_excel` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nroFactura` double NOT NULL DEFAULT '0',
  `cedula` double NOT NULL DEFAULT '0',
  `cliente` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha` date NOT NULL,
  `valor` decimal(20,2) NOT NULL DEFAULT '0.00',
  `abono` decimal(20,2) NOT NULL DEFAULT '0.00',
  `saldo` decimal(20,2) NOT NULL DEFAULT '0.00',
  `cajero` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forma` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `municipio` varchar(25) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `cxp`
--

CREATE TABLE `cxp` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `idNroFactura` double NOT NULL DEFAULT '0',
  `nroFactura` double NOT NULL DEFAULT '0',
  `cedula` double NOT NULL DEFAULT '0',
  `proveedor` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fecha` date NOT NULL,
  `valor` decimal(20,2) NOT NULL DEFAULT '0.00',
  `abono` decimal(20,2) NOT NULL DEFAULT '0.00',
  `saldo` decimal(20,2) NOT NULL DEFAULT '0.00',
  `cajero` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `forma` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(1) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `departamentos`
--

CREATE TABLE `departamentos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_id` double NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `departamentos` (`id`, `country_id`, `name`, `code`, `created_at`, `updated_at`) VALUES
(1, 46, 'Amazonas', '91', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(2, 46, 'Antioquia', '05', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(3, 46, 'Arauca', '81', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(4, 46, 'Atlántico', '08', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(5, 46, 'Bogotá', '11', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(6, 46, 'Bolívar', '13', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(7, 46, 'Boyacá', '15', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(8, 46, 'Caldas', '17', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(9, 46, 'Caquetá', '18', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(10, 46, 'Casanare', '85', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(11, 46, 'Cauca', '19', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(12, 46, 'Cesar', '20', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(13, 46, 'Chocó', '27', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(14, 46, 'Córdoba', '23', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(15, 46, 'Cundinamarca', '25', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(16, 46, 'Guainía', '94', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(17, 46, 'Guaviare', '95', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(18, 46, 'Huila', '41', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(19, 46, 'La Guajira', '44', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(20, 46, 'Magdalena', '47', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(21, 46, 'Meta', '50', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(22, 46, 'Nariño', '52', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(23, 46, 'Norte de Santander', '54', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(24, 46, 'Putumayo', '86', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(25, 46, 'Quindío', '63', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(26, 46, 'Risaralda', '66', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(27, 46, 'San Andrés y Providencia', '88', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(28, 46, 'Santander', '68', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(29, 46, 'Sucre', '70', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(30, 46, 'Tolima', '73', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(31, 46, 'Valle del Cauca', '76', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(32, 46, 'Vaupés', '97', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(33, 46, 'Vichada', '99', '2026-07-02 21:16:53', '2026-07-02 21:16:53');

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

--
-- Estructura de tabla para la tabla `detail_entries`
--

CREATE TABLE `detail_entries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nit` double NOT NULL,
  `empresa` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `factura` double NOT NULL,
  `caja` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `entry_id` double NOT NULL,
  `product_id` double NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` decimal(20,2) NOT NULL,
  `unit` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(20,2) NOT NULL,
  `tax` decimal(20,2) NOT NULL,
  `tax_value` decimal(20,2) NOT NULL,
  `neto_value` decimal(20,2) NOT NULL,
  `total_value` decimal(20,2) NOT NULL,
  `fechaInicio` date NOT NULL,
  `fechaFin` datetime NOT NULL,
  `categoria` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `vencimiento` date DEFAULT NULL,
  `hubicador` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `forma_pago` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `detail_sales`
--

CREATE TABLE `detail_sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nit` double NOT NULL,
  `sale_id` double NOT NULL,
  `factura` double NOT NULL,
  `caja` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` double NOT NULL,
  `codigo` double NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` decimal(20,2) NOT NULL,
  `unit` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(20,2) NOT NULL,
  `price_entry` decimal(20,2) NOT NULL,
  `gain` decimal(20,2) NOT NULL,
  `tax` decimal(20,2) NOT NULL,
  `tax_value` decimal(20,2) NOT NULL,
  `neto_value` decimal(20,2) NOT NULL,
  `total_value` decimal(20,2) NOT NULL,
  `categoria` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valorOriginal` decimal(20,2) NOT NULL,
  `descSinAtutorizacion` decimal(20,2) NOT NULL,
  `clasificacion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `disc_inventario` decimal(20,2) NOT NULL,
  `raya` int(11) NOT NULL DEFAULT '0',
  `totalraya` decimal(20,2) NOT NULL DEFAULT '0.00',
  `hubicador` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `forma_pago` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `porcentaje_desc` decimal(5,2) NOT NULL,
  `valor_desc` decimal(15,2) NOT NULL,
  `municipio` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fechaInicio` date NOT NULL,
  `fechaFin` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `detalle_documentos`
--

CREATE TABLE `detalle_documentos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sale_id` double NOT NULL,
  `factura` double NOT NULL,
  `caja` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` double NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` decimal(20,2) NOT NULL,
  `unit` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(20,2) NOT NULL,
  `price_entry` decimal(20,2) NOT NULL,
  `gain` decimal(20,2) NOT NULL,
  `tax` decimal(20,2) NOT NULL,
  `tax_value` decimal(20,2) NOT NULL,
  `neto_value` decimal(20,2) NOT NULL,
  `total_value` decimal(20,2) NOT NULL,
  `categoria` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descontar` decimal(20,2) NOT NULL,
  `valorOriginal` decimal(20,2) NOT NULL,
  `descSinAtutorizacion` decimal(20,2) NOT NULL,
  `clasificacion` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `disc_inventario` decimal(20,2) NOT NULL,
  `raya` int(11) NOT NULL DEFAULT '0',
  `fechaInicio` date NOT NULL,
  `fechaFin` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `detalle_pos`
--

CREATE TABLE `detalle_pos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nit` double NOT NULL,
  `sale_id` double NOT NULL,
  `factura` double NOT NULL,
  `caja` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` double NOT NULL,
  `codigo` double NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` decimal(20,2) NOT NULL,
  `unit` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(20,2) NOT NULL,
  `price_entry` decimal(20,2) NOT NULL,
  `gain` decimal(20,2) NOT NULL,
  `tax` decimal(20,2) NOT NULL,
  `tax_value` decimal(20,2) NOT NULL,
  `neto_value` decimal(20,2) NOT NULL,
  `total_value` decimal(20,2) NOT NULL,
  `categoria` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valorOriginal` decimal(20,2) NOT NULL,
  `descSinAtutorizacion` decimal(20,2) NOT NULL,
  `clasificacion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `disc_inventario` decimal(20,2) NOT NULL,
  `raya` int(11) NOT NULL DEFAULT '0',
  `totalraya` decimal(20,2) NOT NULL DEFAULT '0.00',
  `hubicador` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `forma_pago` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `porcentaje_desc` decimal(5,2) NOT NULL,
  `valor_desc` decimal(15,2) NOT NULL,
  `municipio` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fechaInicio` date NOT NULL,
  `fechaFin` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `documentos`
--

CREATE TABLE `documentos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `num_sale` double NOT NULL,
  `idCxC` double NOT NULL DEFAULT '0',
  `number` double NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `caja` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_voucher` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` decimal(20,2) NOT NULL,
  `total_iva` decimal(20,2) NOT NULL,
  `total_neto` decimal(20,2) NOT NULL,
  `fechaInicio` date NOT NULL,
  `fechaFin` datetime NOT NULL,
  `forma_pago` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pago` decimal(20,2) NOT NULL,
  `queda` decimal(20,2) NOT NULL,
  `state` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `json` longtext COLLATE utf8mb4_unicode_ci,
  `Estado_Json` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `numero` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uuid` longtext COLLATE utf8mb4_unicode_ci,
  `issue_date` date DEFAULT NULL,
  `pdfBase64Bytes` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `empleados`
--

CREATE TABLE `empleados` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tipodocumento` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `documento` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `primernombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `segundonombre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `primerapellido` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `segundoapellido` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `direccion` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telefono` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `municipio` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_worker_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `sub_type_worker` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_contract_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `salario` decimal(10,2) NOT NULL,
  `transporte` decimal(10,2) DEFAULT NULL,
  `fecha_contratacion` date NOT NULL,
  `payment_method` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `banco` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tipodecuenta` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `numerodecuenta` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `eps_deduction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `empresas`
--

CREATE TABLE `empresas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nit` double NOT NULL,
  `prefijo` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `prefijopos` varchar(5) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dv` int(11) NOT NULL,
  `direction` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `propietario` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `regimen` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `resolucion` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fechaResolucion` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `startDate` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `endDate` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `from` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `to` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `regmercantil` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `resopos` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fechaResolucionPos` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `startDatePos` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `endDatePos` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `fromPos` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `toPos` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `municipio` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `SoftwareID` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `default_voucher` enum('Pos','Factura') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Pos',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `empresas` (`id`, `name`, `nit`, `prefijo`, `prefijopos`, `dv`, `direction`, `telephone`, `email`, `propietario`, `regimen`, `resolucion`, `fechaResolucion`, `startDate`, `endDate`, `from`, `to`, `regmercantil`, `resopos`, `fechaResolucionPos`, `startDatePos`, `endDatePos`, `fromPos`, `toPos`, `municipio`, `token`, `SoftwareID`, `default_voucher`, `created_at`, `updated_at`) VALUES
(1, 'COMERCIALIZADORA DEL HUILA', 900125478, 'FAV', 'POS', 0, 'Calle 5 # 3 -58 Neiva - Huila', '31747895', 'nose@hotmail.com', 'MARGARITA  MONSALVE CRUZ', 'SIMPLIFICADO', '18760000001', '2021-01-01', '2021-01-01', '2021-01-01', '1', '1000', '11111', '18760000001', '2021-01-01', '2021-01-01', '2021-01-01', '1', '1000', 'Neiva', 'xxxxxxx', '43244jl2j34j2j3jjjjk34383f4sfsf', 'Pos', NULL, NULL);

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

--
-- Estructura de tabla para la tabla `entries`
--

CREATE TABLE `entries` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `request_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facture` double NOT NULL,
  `compra` double NOT NULL DEFAULT '0',
  `number` double NOT NULL,
  `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `caja` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_voucher` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` decimal(20,2) NOT NULL,
  `total_iva` decimal(20,2) NOT NULL,
  `total_neto` decimal(20,2) NOT NULL,
  `fechaInicio` date NOT NULL,
  `fechaFin` datetime NOT NULL,
  `forma_pago` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pago` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `queda` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `state` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `fechas`
--

CREATE TABLE `fechas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `fecha` datetime NOT NULL,
  `contador` int(11) NOT NULL DEFAULT '300'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `gastos`
--

CREATE TABLE `gastos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `fecha` date NOT NULL,
  `detalle` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valor` decimal(20,2) NOT NULL DEFAULT '0.00',
  `cajero` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `gastosoperativos`
--

CREATE TABLE `gastosoperativos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `fecha` date NOT NULL,
  `detalle` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `valor` decimal(20,2) NOT NULL DEFAULT '0.00',
  `cajero` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2016_06_01_000001_create_oauth_auth_codes_table', 1),
(4, '2016_06_01_000002_create_oauth_access_tokens_table', 1),
(5, '2016_06_01_000003_create_oauth_refresh_tokens_table', 1),
(6, '2016_06_01_000004_create_oauth_clients_table', 1),
(7, '2016_06_01_000005_create_oauth_personal_access_clients_table', 1),
(8, '2019_08_19_000000_create_failed_jobs_table', 1),
(9, '2020_03_04_152318_create_roles_table', 1),
(10, '2020_03_04_152424_create_role_user', 1),
(11, '2020_03_30_221348_create_permission_table', 1),
(12, '2020_03_31_001614_create_permission_role_table', 1),
(13, '2020_07_02_195851_categorias', 1),
(14, '2020_08_02_154524_products_table', 1),
(15, '2020_08_07_145901_create_clients_table', 1),
(16, '2020_08_30_154740_create_entries_table', 1),
(17, '2020_08_30_155425_create_detail_entries_table', 1),
(18, '2020_08_30_160052_create_sales_table', 1),
(19, '2020_08_30_160231_create_detail_sales_table', 1),
(20, '2021_05_02_203213_create_empresas_table', 1),
(21, '2021_05_11_205624_create_fechas_table', 1),
(22, '2021_10_14_150434_create_abonoscxc_table', 1),
(23, '2021_10_14_150514_create_abonoscxp_table', 1),
(24, '2021_10_23_164641_create_cxp_table', 1),
(25, '2021_11_07_222051_create_gastos_table', 1),
(26, '2021_12_23_180759_create_total_table', 1),
(27, '2022_01_26_232028_create_cxc_table', 1),
(28, '2022_01_29_225047_create_cardex_table', 1),
(29, '2022_02_15_125447_create_cierre_table', 1),
(30, '2022_06_06_143006_create_cxc_excel_table', 1),
(31, '2022_06_11_141633_create_municipios_table', 1),
(32, '2023_04_18_193111_create_pos_table', 1),
(33, '2023_04_18_193701_create_detalle_pos_table', 1),
(34, '2023_07_26_195322_create_documentos_table', 1),
(35, '2023_07_26_200907_create_detalle_documentos_table', 1),
(36, '2023_08_12_193208_create_porcategorias_table', 1),
(37, '2024_06_22_122544_create_departamentos_table', 1),
(38, '2024_07_13_004431_create_notas_nomina_table', 1),
(39, '2024_07_13_004431_create_notas_table', 1),
(40, '2024_07_22_192243_create_activos_table', 1),
(41, '2024_07_29_152949_create_pyg_table', 1),
(42, '2024_08_07_125602_create_nominas_table', 1),
(43, '2024_08_09_140709_create_empleados_table', 1),
(44, '2024_08_09_155557_create_gastosoperativos_table', 1),
(45, '2026_03_01_063203_create_ajustes_table', 1),
(46, '2026_03_01_144958_create_auditoria_table', 1);

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

--
-- Estructura de tabla para la tabla `modules`
--

CREATE TABLE `modules` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `modules` (`id`, `name`, `description`, `created_at`, `updated_at`) VALUES
(1, 'Roles', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(2, 'Users', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(3, 'Categorias', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(4, 'Units', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(5, 'Products', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(6, 'Prices', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(7, 'Clients', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(8, 'Providers', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(9, 'Entries', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(10, 'Sales', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(11, 'Regimes', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(12, 'Municipio', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(13, 'Departamento', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(14, 'Gastos', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(15, 'cxc', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(16, 'cxp', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(17, 'Empresas', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(18, 'cardex', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(19, 'corte', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(20, 'caja', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(21, 'reporteFactura', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(22, 'reporteDetalle', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(23, 'reporteCompra', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(24, 'reporteDetalleCompra', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(25, 'rotacion', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(26, 'cierre', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(27, 'pos', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(28, 'ActivoFijo', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(29, 'Nomina', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(30, 'Empleados', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(31, 'Ajustes', '', '2026-07-02 21:16:48', '2026-07-02 21:16:48');

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

--
-- Estructura de tabla para la tabla `municipios`
--

CREATE TABLE `municipios` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `department_id` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `municipios` (`id`, `department_id`, `name`, `code`, `created_at`, `updated_at`) VALUES
(1, '2', 'Medellín', '5001', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(2, '2', 'Abejorral', '5002', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(3, '2', 'Abriaquí', '5004', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(4, '2', 'Alejandría', '5021', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(5, '2', 'Amagá', '5030', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(6, '2', 'Amalfi', '5031', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(7, '2', 'Andes', '5034', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(8, '2', 'Angelópolis', '5036', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(9, '2', 'Angostura', '5038', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(10, '2', 'Anorí', '5040', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(11, '2', 'Santa Fé De Antioquia', '5042', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(12, '2', 'Anzá', '5044', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(13, '2', 'Apartadó', '5045', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(14, '2', 'Arboletes', '5051', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(15, '2', 'Argelia', '5055', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(16, '2', 'Armenia', '5059', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(17, '2', 'Barbosa', '5079', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(18, '2', 'Belmira', '5086', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(19, '2', 'Bello', '5088', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(20, '2', 'Betania', '5091', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(21, '2', 'Betulia', '5093', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(22, '2', 'Ciudad Bolívar ', '5101', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(23, '2', 'Briceño', '5107', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(24, '2', 'Buriticá', '5113', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(25, '2', 'Cáceres', '5120', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(26, '2', 'Caicedo', '5125', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(27, '2', 'Caldas', '5129', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(28, '2', 'Campamento', '5134', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(29, '2', 'Cañasgordas', '5138', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(30, '2', 'Caracolí', '5142', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(31, '2', 'Caramanta', '5145', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(32, '2', 'Carepa', '5147', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(33, '2', 'El Carmen De Viboral', '5148', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(34, '2', 'Carolina', '5150', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(35, '2', 'Caucasia', '5154', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(36, '2', 'Chigorodó', '5172', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(37, '2', 'Cisneros', '5190', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(38, '2', 'Cocorná', '5197', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(39, '2', 'Concepción', '5206', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(40, '2', 'Concordia', '5209', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(41, '2', 'Copacabana', '5212', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(42, '2', 'Dabeiba', '5234', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(43, '2', 'Donmatías', '5237', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(44, '2', 'Ebéjico', '5240', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(45, '2', 'El Bagre ', '5250', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(46, '2', 'Entrerríos', '5264', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(47, '2', 'Envigado', '5266', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(48, '2', 'Fredonia', '5282', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(49, '2', 'Frontino', '5284', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(50, '2', 'Giraldo', '5306', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(51, '2', 'Girardota', '5308', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(52, '2', 'Gómez Plata ', '5310', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(53, '2', 'Granada', '5313', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(54, '2', 'Guadalupe', '5315', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(55, '2', 'Guarne', '5318', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(56, '2', 'Guatapé', '5321', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(57, '2', 'Heliconia', '5347', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(58, '2', 'Hispania', '5353', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(59, '2', 'Itagüí', '5360', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(60, '2', 'Ituango', '5361', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(61, '2', 'Jardín', '5364', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(62, '2', 'Jericó', '5368', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(63, '2', 'La Ceja ', '5376', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(64, '2', 'La Estrella ', '5380', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(65, '2', 'La Pintada ', '5390', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(66, '2', 'La Unión ', '5400', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(67, '2', 'Liborina', '5411', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(68, '2', 'Maceo', '5425', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(69, '2', 'Marinilla', '5440', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(70, '2', 'Montebello', '5467', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(71, '2', 'Murindó', '5475', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(72, '2', 'Mutatá', '5480', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(73, '2', 'Nariño', '5483', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(74, '2', 'Necoclí', '5490', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(75, '2', 'Nechí', '5495', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(76, '2', 'Olaya', '5501', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(77, '2', 'Peñol', '5541', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(78, '2', 'Peque', '5543', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(79, '2', 'Pueblorrico', '5576', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(80, '2', 'Puerto Berrío ', '5579', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(81, '2', 'Puerto Nare ', '5585', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(82, '2', 'Puerto Triunfo ', '5591', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(83, '2', 'Remedios', '5604', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(84, '2', 'Retiro', '5607', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(85, '2', 'Rionegro', '5615', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(86, '2', 'Sabanalarga', '5628', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(87, '2', 'Sabaneta', '5631', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(88, '2', 'Salgar', '5642', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(89, '2', 'San Andrés De Cuerquía', '5647', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(90, '2', 'San Carlos ', '5649', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(91, '2', 'San Francisco ', '5652', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(92, '2', 'San Jerónimo ', '5656', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(93, '2', 'San José De La Montaña ', '5658', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(94, '2', 'San Juan De Urabá', '5659', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(95, '2', 'San Luis ', '5660', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(96, '2', 'San Pedro De Los Milagros ', '5664', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(97, '2', 'San Pedro De Urabá', '5665', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(98, '2', 'San Rafael ', '5667', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(99, '2', 'San Roque ', '5670', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(100, '2', 'San Vicente Ferrer', '5674', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(101, '2', 'Santa Bárbara ', '5679', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(102, '2', 'Santa Rosa De Osos', '5686', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(103, '2', 'Santo Domingo ', '5690', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(104, '2', 'El Santuario ', '5697', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(105, '2', 'Segovia', '5736', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(106, '2', 'Sonsón', '5756', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(107, '2', 'Sopetrán', '5761', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(108, '2', 'Támesis', '5789', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(109, '2', 'Tarazá', '5790', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(110, '2', 'Tarso', '5792', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(111, '2', 'Titiribí', '5809', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(112, '2', 'Toledo', '5819', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(113, '2', 'Turbo', '5837', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(114, '2', 'Uramita', '5842', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(115, '2', 'Urrao', '5847', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(116, '2', 'Valdivia', '5854', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(117, '2', 'Valparaíso', '5856', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(118, '2', 'Vegachí', '5858', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(119, '2', 'Venecia', '5861', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(120, '2', 'Vigía Del Fuerte', '5873', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(121, '2', 'Yalí', '5885', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(122, '2', 'Yarumal', '5887', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(123, '2', 'Yolombó', '5890', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(124, '2', 'Yondó', '5893', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(125, '2', 'Zaragoza', '5895', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(126, '4', 'Barranquilla', '8001', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(127, '4', 'Baranoa', '8078', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(128, '4', 'Campo De La Cruz', '8137', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(129, '4', 'Candelaria', '8141', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(130, '4', 'Galapa', '8296', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(131, '4', 'Juan De Acosta', '8372', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(132, '4', 'Luruaco', '8421', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(133, '4', 'Malambo', '8433', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(134, '4', 'Manatí', '8436', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(135, '4', 'Palmar De Varela', '8520', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(136, '4', 'Piojó', '8549', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(137, '4', 'Polonuevo', '8558', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(138, '4', 'Ponedera', '8560', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(139, '4', 'Puerto Colombia ', '8573', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(140, '4', 'Repelón', '8606', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(141, '4', 'Sabanagrande', '8634', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(142, '4', 'Sabanalarga', '8638', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(143, '4', 'Santa Lucía ', '8675', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(144, '4', 'Santo Tomás ', '8685', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(145, '4', 'Soledad', '8758', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(146, '4', 'Suan', '8770', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(147, '4', 'Tubará', '8832', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(148, '4', 'Usiacurí', '8849', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(149, '5', 'Bogotá, D.c.', '11001', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(150, '6', 'Cartagena De Indias', '13001', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(151, '6', 'Achí', '13006', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(152, '6', 'Altos Del Rosario', '13030', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(153, '6', 'Arenal', '13042', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(154, '6', 'Arjona', '13052', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(155, '6', 'Arroyohondo', '13062', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(156, '6', 'Barranco De Loba', '13074', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(157, '6', 'Calamar', '13140', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(158, '6', 'Cantagallo', '13160', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(159, '6', 'Cicuco', '13188', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(160, '6', 'Córdoba', '13212', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(161, '6', 'Clemencia', '13222', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(162, '6', 'El Carmen De Bolívar', '13244', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(163, '6', 'El Guamo ', '13248', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(164, '6', 'El Peñón ', '13268', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(165, '6', 'Hatillo De Loba', '13300', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(166, '6', 'Magangué', '13430', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(167, '6', 'Mahates', '13433', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(168, '6', 'Margarita', '13440', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(169, '6', 'María La Baja', '13442', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(170, '6', 'Montecristo', '13458', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(171, '6', 'Mompós', '13468', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(172, '6', 'Morales', '13473', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(173, '6', 'Norosí', '13490', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(174, '6', 'Pinillos', '13549', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(175, '6', 'Regidor', '13580', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(176, '6', 'Río Viejo ', '13600', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(177, '6', 'San Cristóbal ', '13620', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(178, '6', 'San Estanislao ', '13647', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(179, '6', 'San Fernando ', '13650', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(180, '6', 'San Jacinto ', '13654', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(181, '6', 'San Jacinto Del Cauca', '13655', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(182, '6', 'San Juan Nepomuceno', '13657', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(183, '6', 'San Martín De Loba', '13667', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(184, '6', 'San Pablo ', '13670', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(185, '6', 'Santa Catalina ', '13673', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(186, '6', 'Santa Rosa ', '13683', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(187, '6', 'Santa Rosa Del Sur', '13688', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(188, '6', 'Simití', '13744', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(189, '6', 'Soplaviento', '13760', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(190, '6', 'Talaigua Nuevo ', '13780', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(191, '6', 'Tiquisio', '13810', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(192, '6', 'Turbaco', '13836', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(193, '6', 'Turbaná', '13838', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(194, '6', 'Villanueva', '13873', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(195, '6', 'Zambrano', '13894', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(196, '7', 'Tunja', '15001', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(197, '7', 'Almeida', '15022', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(198, '7', 'Aquitania', '15047', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(199, '7', 'Arcabuco', '15051', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(200, '7', 'Belén', '15087', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(201, '7', 'Berbeo', '15090', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(202, '7', 'Betéitiva', '15092', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(203, '7', 'Boavita', '15097', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(204, '7', 'Boyacá', '15104', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(205, '7', 'Briceño', '15106', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(206, '7', 'Buenavista', '15109', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(207, '7', 'Busbanzá', '15114', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(208, '7', 'Caldas', '15131', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(209, '7', 'Campohermoso', '15135', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(210, '7', 'Cerinza', '15162', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(211, '7', 'Chinavita', '15172', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(212, '7', 'Chiquinquirá', '15176', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(213, '7', 'Chiscas', '15180', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(214, '7', 'Chita', '15183', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(215, '7', 'Chitaraque', '15185', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(216, '7', 'Chivatá', '15187', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(217, '7', 'Ciénega', '15189', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(218, '7', 'Cómbita', '15204', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(219, '7', 'Coper', '15212', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(220, '7', 'Corrales', '15215', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(221, '7', 'Covarachía', '15218', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(222, '7', 'Cubará', '15223', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(223, '7', 'Cucaita', '15224', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(224, '7', 'Cuítiva', '15226', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(225, '7', 'Chíquiza', '15232', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(226, '7', 'Chivor', '15236', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(227, '7', 'Duitama', '15238', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(228, '7', 'El Cocuy ', '15244', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(229, '7', 'El Espino ', '15248', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(230, '7', 'Firavitoba', '15272', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(231, '7', 'Floresta', '15276', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(232, '7', 'Gachantivá', '15293', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(233, '7', 'Gámeza', '15296', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(234, '7', 'Garagoa', '15299', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(235, '7', 'Guacamayas', '15317', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(236, '7', 'Guateque', '15322', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(237, '7', 'Guayatá', '15325', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(238, '7', 'Güicán De La Sierra', '15332', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(239, '7', 'Iza', '15362', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(240, '7', 'Jenesano', '15367', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(241, '7', 'Jericó', '15368', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(242, '7', 'Labranzagrande', '15377', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(243, '7', 'La Capilla ', '15380', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(244, '7', 'La Victoria ', '15401', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(245, '7', 'La Uvita ', '15403', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(246, '7', 'Villa De Leyva', '15407', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(247, '7', 'Macanal', '15425', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(248, '7', 'Maripí', '15442', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(249, '7', 'Miraflores', '15455', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(250, '7', 'Mongua', '15464', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(251, '7', 'Monguí', '15466', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(252, '7', 'Moniquirá', '15469', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(253, '7', 'Motavita', '15476', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(254, '7', 'Muzo', '15480', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(255, '7', 'Nobsa', '15491', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(256, '7', 'Nuevo Colón ', '15494', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(257, '7', 'Oicatá', '15500', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(258, '7', 'Otanche', '15507', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(259, '7', 'Pachavita', '15511', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(260, '7', 'Páez', '15514', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(261, '7', 'Paipa', '15516', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(262, '7', 'Pajarito', '15518', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(263, '7', 'Panqueba', '15522', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(264, '7', 'Pauna', '15531', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(265, '7', 'Paya', '15533', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(266, '7', 'Paz De Río', '15537', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(267, '7', 'Pesca', '15542', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(268, '7', 'Pisba', '15550', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(269, '7', 'Puerto Boyacá ', '15572', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(270, '7', 'Quípama', '15580', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(271, '7', 'Ramiriquí', '15599', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(272, '7', 'Ráquira', '15600', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(273, '7', 'Rondón', '15621', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(274, '7', 'Saboyá', '15632', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(275, '7', 'Sáchica', '15638', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(276, '7', 'Samacá', '15646', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(277, '7', 'San Eduardo ', '15660', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(278, '7', 'San José De Pare', '15664', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(279, '7', 'San Luis De Gaceno', '15667', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(280, '7', 'San Mateo ', '15673', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(281, '7', 'San Miguel De Sema', '15676', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(282, '7', 'San Pablo De Borbur', '15681', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(283, '7', 'Santana', '15686', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(284, '7', 'Santa María ', '15690', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(285, '7', 'Santa Rosa De Viterbo', '15693', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(286, '7', 'Santa Sofía ', '15696', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(287, '7', 'Sativanorte', '15720', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(288, '7', 'Sativasur', '15723', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(289, '7', 'Siachoque', '15740', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(290, '7', 'Soatá', '15753', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(291, '7', 'Socotá', '15755', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(292, '7', 'Socha', '15757', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(293, '7', 'Sogamoso', '15759', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(294, '7', 'Somondoco', '15761', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(295, '7', 'Sora', '15762', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(296, '7', 'Sotaquirá', '15763', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(297, '7', 'Soracá', '15764', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(298, '7', 'Susacón', '15774', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(299, '7', 'Sutamarchán', '15776', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(300, '7', 'Sutatenza', '15778', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(301, '7', 'Tasco', '15790', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(302, '7', 'Tenza', '15798', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(303, '7', 'Tibaná', '15804', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(304, '7', 'Tibasosa', '15806', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(305, '7', 'Tinjacá', '15808', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(306, '7', 'Tipacoque', '15810', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(307, '7', 'Toca', '15814', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(308, '7', 'Togüí', '15816', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(309, '7', 'Tópaga', '15820', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(310, '7', 'Tota', '15822', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(311, '7', 'Tununguá', '15832', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(312, '7', 'Turmequé', '15835', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(313, '7', 'Tuta', '15837', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(314, '7', 'Tutazá', '15839', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(315, '7', 'Úmbita', '15842', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(316, '7', 'Ventaquemada', '15861', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(317, '7', 'Viracachá', '15879', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(318, '7', 'Zetaquira', '15897', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(319, '8', 'Manizales', '17001', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(320, '8', 'Aguadas', '17013', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(321, '8', 'Anserma', '17042', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(322, '8', 'Aranzazu', '17050', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(323, '8', 'Belalcázar', '17088', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(324, '8', 'Chinchiná', '17174', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(325, '8', 'Filadelfia', '17272', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(326, '8', 'La Dorada ', '17380', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(327, '8', 'La Merced ', '17388', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(328, '8', 'Manzanares', '17433', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(329, '8', 'Marmato', '17442', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(330, '8', 'Marquetalia', '17444', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(331, '8', 'Marulanda', '17446', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(332, '8', 'Neira', '17486', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(333, '8', 'Norcasia', '17495', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(334, '8', 'Pácora', '17513', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(335, '8', 'Palestina', '17524', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(336, '8', 'Pensilvania', '17541', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(337, '8', 'Riosucio', '17614', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(338, '8', 'Risaralda', '17616', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(339, '8', 'Salamina', '17653', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(340, '8', 'Samaná', '17662', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(341, '8', 'San José ', '17665', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(342, '8', 'Supía', '17777', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(343, '8', 'Victoria', '17867', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(344, '8', 'Villamaría', '17873', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(345, '8', 'Viterbo', '17877', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(346, '9', 'Florencia', '18001', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(347, '9', 'Albania', '18029', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(348, '9', 'Belén De Los Andaquíes', '18094', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(349, '9', 'Cartagena Del Chairá', '18150', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(350, '9', 'Curillo', '18205', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(351, '9', 'El Doncello ', '18247', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(352, '9', 'El Paujíl ', '18256', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(353, '9', 'La Montañita ', '18410', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(354, '9', 'Milán', '18460', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(355, '9', 'Morelia', '18479', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(356, '9', 'Puerto Rico ', '18592', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(357, '9', 'San José Del Fragua', '18610', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(358, '9', 'San Vicente Del Caguán', '18753', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(359, '9', 'Solano', '18756', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(360, '9', 'Solita', '18785', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(361, '9', 'Valparaíso', '18860', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(362, '11', 'Popayán', '19001', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(363, '11', 'Almaguer', '19022', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(364, '11', 'Argelia', '19050', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(365, '11', 'Balboa', '19075', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(366, '11', 'Bolívar', '19100', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(367, '11', 'Buenos Aires ', '19110', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(368, '11', 'Cajibío', '19130', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(369, '11', 'Caldono', '19137', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(370, '11', 'Caloto', '19142', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(371, '11', 'Corinto', '19212', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(372, '11', 'El Tambo ', '19256', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(373, '11', 'Florencia', '19290', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(374, '11', 'Guachené', '19300', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(375, '11', 'Guapí', '19318', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(376, '11', 'Inzá', '19355', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(377, '11', 'Jambaló', '19364', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(378, '11', 'La Sierra ', '19392', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(379, '11', 'La Vega ', '19397', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(380, '11', 'López De Micay', '19418', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(381, '11', 'Mercaderes', '19450', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(382, '11', 'Miranda', '19455', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(383, '11', 'Morales', '19473', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(384, '11', 'Padilla', '19513', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(385, '11', 'Páez', '19517', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(386, '11', 'Patía', '19532', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(387, '11', 'Piamonte', '19533', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(388, '11', 'Piendamó - Tunía', '19548', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(389, '11', 'Puerto Tejada ', '19573', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(390, '11', 'Puracé', '19585', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(391, '11', 'Rosas', '19622', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(392, '11', 'San Sebastián ', '19693', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(393, '11', 'Santander De Quilichao', '19698', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(394, '11', 'Santa Rosa ', '19701', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(395, '11', 'Silvia', '19743', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(396, '11', 'Sotara', '19760', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(397, '11', 'Suárez', '19780', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(398, '11', 'Sucre', '19785', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(399, '11', 'Timbío', '19807', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(400, '11', 'Timbiquí', '19809', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(401, '11', 'Toribío', '19821', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(402, '11', 'Totoró', '19824', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(403, '11', 'Villa Rica ', '19845', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(404, '12', 'Valledupar', '20001', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(405, '12', 'Aguachica', '20011', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(406, '12', 'Agustín Codazzi ', '20013', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(407, '12', 'Astrea', '20032', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(408, '12', 'Becerril', '20045', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(409, '12', 'Bosconia', '20060', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(410, '12', 'Chimichagua', '20175', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(411, '12', 'Chiriguaná', '20178', '2026-07-02 21:16:50', '2026-07-02 21:16:50'),
(412, '12', 'Curumaní', '20228', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(413, '12', 'El Copey ', '20238', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(414, '12', 'El Paso ', '20250', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(415, '12', 'Gamarra', '20295', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(416, '12', 'González', '20310', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(417, '12', 'La Gloria ', '20383', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(418, '12', 'La Jagua De Ibirico', '20400', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(419, '12', 'Manaure Balcón Del Cesar', '20443', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(420, '12', 'Pailitas', '20517', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(421, '12', 'Pelaya', '20550', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(422, '12', 'Pueblo Bello ', '20570', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(423, '12', 'Río De Oro', '20614', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(424, '12', 'La Paz ', '20621', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(425, '12', 'San Alberto ', '20710', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(426, '12', 'San Diego ', '20750', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(427, '12', 'San Martín ', '20770', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(428, '12', 'Tamalameque', '20787', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(429, '14', 'Montería', '23001', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(430, '14', 'Ayapel', '23068', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(431, '14', 'Buenavista', '23079', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(432, '14', 'Canalete', '23090', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(433, '14', 'Cereté', '23162', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(434, '14', 'Chimá', '23168', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(435, '14', 'Chinú', '23182', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(436, '14', 'Ciénaga De Oro', '23189', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(437, '14', 'Cotorra', '23300', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(438, '14', 'La Apartada ', '23350', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(439, '14', 'Lorica', '23417', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(440, '14', 'Los Córdobas ', '23419', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(441, '14', 'Momil', '23464', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(442, '14', 'Montelíbano', '23466', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(443, '14', 'Moñitos', '23500', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(444, '14', 'Planeta Rica ', '23555', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(445, '14', 'Pueblo Nuevo ', '23570', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(446, '14', 'Puerto Escondido ', '23574', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(447, '14', 'Puerto Libertador ', '23580', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(448, '14', 'Purísima De La Concepción', '23586', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(449, '14', 'Sahagún', '23660', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(450, '14', 'San Andrés De Sotavento', '23670', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(451, '14', 'San Antero ', '23672', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(452, '14', 'San Bernardo Del Viento', '23675', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(453, '14', 'San Carlos ', '23678', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(454, '14', 'San José De Uré', '23682', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(455, '14', 'San Pelayo ', '23686', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(456, '14', 'Tierralta', '23807', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(457, '14', 'Tuchín', '23815', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(458, '14', 'Valencia', '23855', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(459, '15', 'Agua De Dios', '25001', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(460, '15', 'Albán', '25019', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(461, '15', 'Anapoima', '25035', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(462, '15', 'Anolaima', '25040', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(463, '15', 'Arbeláez', '25053', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(464, '15', 'Beltrán', '25086', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(465, '15', 'Bituima', '25095', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(466, '15', 'Bojacá', '25099', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(467, '15', 'Cabrera', '25120', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(468, '15', 'Cachipay', '25123', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(469, '15', 'Cajicá', '25126', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(470, '15', 'Caparrapí', '25148', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(471, '15', 'Cáqueza', '25151', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(472, '15', 'Carmen De Carupa', '25154', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(473, '15', 'Chaguaní', '25168', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(474, '15', 'Chía', '25175', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(475, '15', 'Chipaque', '25178', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(476, '15', 'Choachí', '25181', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(477, '15', 'Chocontá', '25183', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(478, '15', 'Cogua', '25200', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(479, '15', 'Cota', '25214', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(480, '15', 'Cucunubá', '25224', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(481, '15', 'El Colegio ', '25245', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(482, '15', 'El Peñón ', '25258', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(483, '15', 'El Rosal ', '25260', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(484, '15', 'Facatativá', '25269', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(485, '15', 'Fómeque', '25279', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(486, '15', 'Fosca', '25281', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(487, '15', 'Funza', '25286', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(488, '15', 'Fúquene', '25288', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(489, '15', 'Fusagasugá', '25290', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(490, '15', 'Gachalá', '25293', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(491, '15', 'Gachancipá', '25295', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(492, '15', 'Gachetá', '25297', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(493, '15', 'Gama', '25299', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(494, '15', 'Girardot', '25307', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(495, '15', 'Granada', '25312', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(496, '15', 'Guachetá', '25317', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(497, '15', 'Guaduas', '25320', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(498, '15', 'Guasca', '25322', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(499, '15', 'Guataquí', '25324', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(500, '15', 'Guatavita', '25326', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(501, '15', 'Guayabal De Síquima', '25328', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(502, '15', 'Guayabetal', '25335', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(503, '15', 'Gutiérrez', '25339', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(504, '15', 'Jerusalén', '25368', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(505, '15', 'Junín', '25372', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(506, '15', 'La Calera ', '25377', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(507, '15', 'La Mesa ', '25386', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(508, '15', 'La Palma ', '25394', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(509, '15', 'La Peña ', '25398', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(510, '15', 'La Vega ', '25402', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(511, '15', 'Lenguazaque', '25407', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(512, '15', 'Machetá', '25426', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(513, '15', 'Madrid', '25430', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(514, '15', 'Manta', '25436', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(515, '15', 'Medina', '25438', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(516, '15', 'Mosquera', '25473', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(517, '15', 'Nariño', '25483', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(518, '15', 'Nemocón', '25486', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(519, '15', 'Nilo', '25488', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(520, '15', 'Nimaima', '25489', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(521, '15', 'Nocaima', '25491', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(522, '15', 'Venecia', '25506', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(523, '15', 'Pacho', '25513', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(524, '15', 'Paime', '25518', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(525, '15', 'Pandi', '25524', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(526, '15', 'Paratebueno', '25530', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(527, '15', 'Pasca', '25535', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(528, '15', 'Puerto Salgar ', '25572', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(529, '15', 'Pulí', '25580', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(530, '15', 'Quebradanegra', '25592', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(531, '15', 'Quetame', '25594', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(532, '15', 'Quipile', '25596', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(533, '15', 'Apulo', '25599', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(534, '15', 'Ricaurte', '25612', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(535, '15', 'San Antonio Del Tequendama', '25645', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(536, '15', 'San Bernardo ', '25649', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(537, '15', 'San Cayetano ', '25653', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(538, '15', 'San Francisco ', '25658', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(539, '15', 'San Juan De Rioseco', '25662', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(540, '15', 'Sasaima', '25718', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(541, '15', 'Sesquilé', '25736', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(542, '15', 'Sibaté', '25740', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(543, '15', 'Silvania', '25743', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(544, '15', 'Simijaca', '25745', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(545, '15', 'Soacha', '25754', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(546, '15', 'Sopó', '25758', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(547, '15', 'Subachoque', '25769', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(548, '15', 'Suesca', '25772', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(549, '15', 'Supatá', '25777', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(550, '15', 'Susa', '25779', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(551, '15', 'Sutatausa', '25781', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(552, '15', 'Tabio', '25785', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(553, '15', 'Tausa', '25793', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(554, '15', 'Tena', '25797', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(555, '15', 'Tenjo', '25799', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(556, '15', 'Tibacuy', '25805', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(557, '15', 'Tibirita', '25807', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(558, '15', 'Tocaima', '25815', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(559, '15', 'Tocancipá', '25817', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(560, '15', 'Topaipí', '25823', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(561, '15', 'Ubalá', '25839', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(562, '15', 'Ubaque', '25841', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(563, '15', 'Villa De San Diego De Ubaté', '25843', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(564, '15', 'Une', '25845', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(565, '15', 'Útica', '25851', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(566, '15', 'Vergara', '25862', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(567, '15', 'Vianí', '25867', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(568, '15', 'Villagómez', '25871', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(569, '15', 'Villapinzón', '25873', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(570, '15', 'Villeta', '25875', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(571, '15', 'Viotá', '25878', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(572, '15', 'Yacopí', '25885', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(573, '15', 'Zipacón', '25898', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(574, '15', 'Zipaquirá', '25899', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(575, '13', 'Quibdó', '27001', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(576, '13', 'Acandí', '27006', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(577, '13', 'Alto Baudó ', '27025', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(578, '13', 'Atrato', '27050', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(579, '13', 'Bagadó', '27073', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(580, '13', 'Bahía Solano ', '27075', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(581, '13', 'Bajo Baudó ', '27077', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(582, '13', 'Bojayá', '27099', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(583, '13', 'El Cantón Del San Pablo ', '27135', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(584, '13', 'Carmen Del Darién', '27150', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(585, '13', 'Cértegui', '27160', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(586, '13', 'Condoto', '27205', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(587, '13', 'El Carmen De Atrato', '27245', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(588, '13', 'El Litoral Del San Juan ', '27250', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(589, '13', 'Istmina', '27361', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(590, '13', 'Juradó', '27372', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(591, '13', 'Lloró', '27413', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(592, '13', 'Medio Atrato ', '27425', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(593, '13', 'Medio Baudó ', '27430', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(594, '13', 'Medio San Juan', '27450', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(595, '13', 'Nóvita', '27491', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(596, '13', 'Nuquí', '27495', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(597, '13', 'Río Iró ', '27580', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(598, '13', 'Río Quito ', '27600', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(599, '13', 'Riosucio', '27615', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(600, '13', 'San José Del Palmar', '27660', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(601, '13', 'Sipí', '27745', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(602, '13', 'Tadó', '27787', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(603, '13', 'Unguía', '27800', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(604, '13', 'Unión Panamericana ', '27810', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(605, '18', 'Neiva', '41001', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(606, '18', 'Acevedo', '41006', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(607, '18', 'Agrado', '41013', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(608, '18', 'Aipe', '41016', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(609, '18', 'Algeciras', '41020', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(610, '18', 'Altamira', '41026', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(611, '18', 'Baraya', '41078', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(612, '18', 'Campoalegre', '41132', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(613, '18', 'Colombia', '41206', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(614, '18', 'Elías', '41244', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(615, '18', 'Garzón', '41298', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(616, '18', 'Gigante', '41306', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(617, '18', 'Guadalupe', '41319', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(618, '18', 'Hobo', '41349', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(619, '18', 'Íquira', '41357', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(620, '18', 'Isnos', '41359', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(621, '18', 'La Argentina ', '41378', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(622, '18', 'La Plata ', '41396', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(623, '18', 'Nátaga', '41483', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(624, '18', 'Oporapa', '41503', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(625, '18', 'Paicol', '41518', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(626, '18', 'Palermo', '41524', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(627, '18', 'Palestina', '41530', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(628, '18', 'Pital', '41548', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(629, '18', 'Pitalito', '41551', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(630, '18', 'Rivera', '41615', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(631, '18', 'Saladoblanco', '41660', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(632, '18', 'San Agustín ', '41668', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(633, '18', 'Santa María ', '41676', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(634, '18', 'Suaza', '41770', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(635, '18', 'Tarqui', '41791', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(636, '18', 'Tesalia', '41797', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(637, '18', 'Tello', '41799', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(638, '18', 'Teruel', '41801', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(639, '18', 'Timaná', '41807', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(640, '18', 'Villavieja', '41872', '2026-07-02 21:16:51', '2026-07-02 21:16:51');
INSERT INTO `municipios` (`id`, `department_id`, `name`, `code`, `created_at`, `updated_at`) VALUES
(641, '18', 'Yaguará', '41885', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(642, '19', 'Riohacha', '44001', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(643, '19', 'Albania', '44035', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(644, '19', 'Barrancas', '44078', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(645, '19', 'Dibulla', '44090', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(646, '19', 'Distracción', '44098', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(647, '19', 'El Molino ', '44110', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(648, '19', 'Fonseca', '44279', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(649, '19', 'Hatonuevo', '44378', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(650, '19', 'La Jagua Del Pilar', '44420', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(651, '19', 'Maicao', '44430', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(652, '19', 'Manaure', '44560', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(653, '19', 'San Juan Del Cesar', '44650', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(654, '19', 'Uribia', '44847', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(655, '19', 'Urumita', '44855', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(656, '19', 'Villanueva', '44874', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(657, '20', 'Santa Marta ', '47001', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(658, '20', 'Algarrobo', '47030', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(659, '20', 'Aracataca', '47053', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(660, '20', 'Ariguaní', '47058', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(661, '20', 'Cerro De San Antonio', '47161', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(662, '20', 'Chivolo', '47170', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(663, '20', 'Ciénaga', '47189', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(664, '20', 'Concordia', '47205', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(665, '20', 'El Banco ', '47245', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(666, '20', 'El Piñón ', '47258', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(667, '20', 'El Retén ', '47268', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(668, '20', 'Fundación', '47288', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(669, '20', 'Guamal', '47318', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(670, '20', 'Nueva Granada ', '47460', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(671, '20', 'Pedraza', '47541', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(672, '20', 'Pijiño Del Carmen', '47545', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(673, '20', 'Pivijay', '47551', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(674, '20', 'Plato', '47555', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(675, '20', 'Puebloviejo', '47570', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(676, '20', 'Remolino', '47605', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(677, '20', 'Sabanas De San Ángel', '47660', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(678, '20', 'Salamina', '47675', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(679, '20', 'San Sebastián De Buenavista', '47692', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(680, '20', 'San Zenón ', '47703', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(681, '20', 'Santa Ana ', '47707', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(682, '20', 'Santa Bárbara De Pinto', '47720', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(683, '20', 'Sitionuevo', '47745', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(684, '20', 'Tenerife', '47798', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(685, '20', 'Zapayán', '47960', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(686, '20', 'Zona Bananera ', '47980', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(687, '21', 'Villavicencio', '50001', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(688, '21', 'Acacías', '50006', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(689, '21', 'Barranca De Upía', '50110', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(690, '21', 'Cabuyaro', '50124', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(691, '21', 'Castilla La Nueva', '50150', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(692, '21', 'Cubarral', '50223', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(693, '21', 'Cumaral', '50226', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(694, '21', 'El Calvario ', '50245', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(695, '21', 'El Castillo ', '50251', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(696, '21', 'El Dorado ', '50270', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(697, '21', 'Fuente De Oro', '50287', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(698, '21', 'Granada', '50313', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(699, '21', 'Guamal', '50318', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(700, '21', 'Mapiripán', '50325', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(701, '21', 'Mesetas', '50330', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(702, '21', 'La Macarena ', '50350', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(703, '21', 'Uribe', '50370', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(704, '21', 'Lejanías', '50400', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(705, '21', 'Puerto Concordia ', '50450', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(706, '21', 'Puerto Gaitán ', '50568', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(707, '21', 'Puerto López ', '50573', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(708, '21', 'Puerto Lleras ', '50577', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(709, '21', 'Puerto Rico ', '50590', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(710, '21', 'Restrepo', '50606', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(711, '21', 'San Carlos De Guaroa', '50680', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(712, '21', 'San Juan De Arama', '50683', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(713, '21', 'San Juanito ', '50686', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(714, '21', 'San Martín ', '50689', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(715, '21', 'Vistahermosa', '50711', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(716, '22', 'Pasto', '52001', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(717, '22', 'Albán', '52019', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(718, '22', 'Aldana', '52022', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(719, '22', 'Ancuyá', '52036', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(720, '22', 'Arboleda', '52051', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(721, '22', 'Barbacoas', '52079', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(722, '22', 'Belén', '52083', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(723, '22', 'Buesaco', '52110', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(724, '22', 'Colón', '52203', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(725, '22', 'Consacá', '52207', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(726, '22', 'Contadero', '52210', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(727, '22', 'Córdoba', '52215', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(728, '22', 'Cuaspúd', '52224', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(729, '22', 'Cumbal', '52227', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(730, '22', 'Cumbitara', '52233', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(731, '22', 'Chachagüí', '52240', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(732, '22', 'El Charco ', '52250', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(733, '22', 'El Peñol ', '52254', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(734, '22', 'El Rosario ', '52256', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(735, '22', 'El Tablón De Gómez', '52258', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(736, '22', 'El Tambo ', '52260', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(737, '22', 'Funes', '52287', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(738, '22', 'Guachucal', '52317', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(739, '22', 'Guaitarilla', '52320', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(740, '22', 'Gualmatán', '52323', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(741, '22', 'Iles', '52352', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(742, '22', 'Imués', '52354', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(743, '22', 'Ipiales', '52356', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(744, '22', 'La Cruz ', '52378', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(745, '22', 'La Florida ', '52381', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(746, '22', 'La Llanada ', '52385', '2026-07-02 21:16:51', '2026-07-02 21:16:51'),
(747, '22', 'La Tola ', '52390', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(748, '22', 'La Unión ', '52399', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(749, '22', 'Leiva', '52405', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(750, '22', 'Linares', '52411', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(751, '22', 'Los Andes ', '52418', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(752, '22', 'Magüí', '52427', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(753, '22', 'Mallama', '52435', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(754, '22', 'Mosquera', '52473', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(755, '22', 'Nariño', '52480', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(756, '22', 'Olaya Herrera ', '52490', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(757, '22', 'Ospina', '52506', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(758, '22', 'Francisco Pizarro ', '52520', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(759, '22', 'Policarpa', '52540', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(760, '22', 'Potosí', '52560', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(761, '22', 'Providencia', '52565', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(762, '22', 'Puerres', '52573', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(763, '22', 'Pupiales', '52585', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(764, '22', 'Ricaurte', '52612', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(765, '22', 'Roberto Payán ', '52621', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(766, '22', 'Samaniego', '52678', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(767, '22', 'Sandoná', '52683', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(768, '22', 'San Bernardo ', '52685', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(769, '22', 'San Lorenzo ', '52687', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(770, '22', 'San Pablo ', '52693', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(771, '22', 'San Pedro De Cartago', '52694', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(772, '22', 'Santa Bárbara ', '52696', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(773, '22', 'Santacruz', '52699', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(774, '22', 'Sapuyes', '52720', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(775, '22', 'Taminango', '52786', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(776, '22', 'Tangua', '52788', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(777, '22', 'San Andrés De Tumaco', '52835', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(778, '22', 'Túquerres', '52838', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(779, '22', 'Yacuanquer', '52885', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(780, '23', 'San José De Cúcuta', '54001', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(781, '23', 'Ábrego', '54003', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(782, '23', 'Arboledas', '54051', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(783, '23', 'Bochalema', '54099', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(784, '23', 'Bucarasica', '54109', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(785, '23', 'Cácota', '54125', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(786, '23', 'Cáchira', '54128', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(787, '23', 'Chinácota', '54172', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(788, '23', 'Chitagá', '54174', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(789, '23', 'Convención', '54206', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(790, '23', 'Cucutilla', '54223', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(791, '23', 'Durania', '54239', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(792, '23', 'El Carmen ', '54245', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(793, '23', 'El Tarra ', '54250', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(794, '23', 'El Zulia ', '54261', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(795, '23', 'Gramalote', '54313', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(796, '23', 'Hacarí', '54344', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(797, '23', 'Herrán', '54347', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(798, '23', 'Labateca', '54377', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(799, '23', 'La Esperanza ', '54385', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(800, '23', 'La Playa ', '54398', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(801, '23', 'Los Patios ', '54405', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(802, '23', 'Lourdes', '54418', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(803, '23', 'Mutiscua', '54480', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(804, '23', 'Ocaña', '54498', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(805, '23', 'Pamplona', '54518', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(806, '23', 'Pamplonita', '54520', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(807, '23', 'Puerto Santander ', '54553', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(808, '23', 'Ragonvalia', '54599', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(809, '23', 'Salazar', '54660', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(810, '23', 'San Calixto ', '54670', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(811, '23', 'San Cayetano ', '54673', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(812, '23', 'Santiago', '54680', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(813, '23', 'Sardinata', '54720', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(814, '23', 'Silos', '54743', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(815, '23', 'Teorama', '54800', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(816, '23', 'Tibú', '54810', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(817, '23', 'Toledo', '54820', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(818, '23', 'Villa Caro ', '54871', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(819, '23', 'Villa Del Rosario', '54874', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(820, '25', 'Armenia', '63001', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(821, '25', 'Buenavista', '63111', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(822, '25', 'Calarcá', '63130', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(823, '25', 'Circasia', '63190', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(824, '25', 'Córdoba', '63212', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(825, '25', 'Filandia', '63272', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(826, '25', 'Génova', '63302', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(827, '25', 'La Tebaida ', '63401', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(828, '25', 'Montenegro', '63470', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(829, '25', 'Pijao', '63548', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(830, '25', 'Quimbaya', '63594', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(831, '25', 'Salento', '63690', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(832, '26', 'Pereira', '66001', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(833, '26', 'Apía', '66045', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(834, '26', 'Balboa', '66075', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(835, '26', 'Belén De Umbría', '66088', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(836, '26', 'Dosquebradas', '66170', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(837, '26', 'Guática', '66318', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(838, '26', 'La Celia ', '66383', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(839, '26', 'La Virginia ', '66400', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(840, '26', 'Marsella', '66440', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(841, '26', 'Mistrató', '66456', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(842, '26', 'Pueblo Rico ', '66572', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(843, '26', 'Quinchía', '66594', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(844, '26', 'Santa Rosa De Cabal', '66682', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(845, '26', 'Santuario', '66687', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(846, '28', 'Bucaramanga', '68001', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(847, '28', 'Aguada', '68013', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(848, '28', 'Albania', '68020', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(849, '28', 'Aratoca', '68051', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(850, '28', 'Barbosa', '68077', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(851, '28', 'Barichara', '68079', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(852, '28', 'Barrancabermeja', '68081', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(853, '28', 'Betulia', '68092', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(854, '28', 'Bolívar', '68101', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(855, '28', 'Cabrera', '68121', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(856, '28', 'California', '68132', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(857, '28', 'Capitanejo', '68147', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(858, '28', 'Carcasí', '68152', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(859, '28', 'Cepitá', '68160', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(860, '28', 'Cerrito', '68162', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(861, '28', 'Charalá', '68167', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(862, '28', 'Charta', '68169', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(863, '28', 'Chima', '68176', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(864, '28', 'Chipatá', '68179', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(865, '28', 'Cimitarra', '68190', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(866, '28', 'Concepción', '68207', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(867, '28', 'Confines', '68209', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(868, '28', 'Contratación', '68211', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(869, '28', 'Coromoro', '68217', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(870, '28', 'Curití', '68229', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(871, '28', 'El Carmen De Chucurí', '68235', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(872, '28', 'El Guacamayo ', '68245', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(873, '28', 'El Peñón ', '68250', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(874, '28', 'El Playón ', '68255', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(875, '28', 'Encino', '68264', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(876, '28', 'Enciso', '68266', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(877, '28', 'Florián', '68271', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(878, '28', 'Floridablanca', '68276', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(879, '28', 'Galán', '68296', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(880, '28', 'Gámbita', '68298', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(881, '28', 'Girón', '68307', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(882, '28', 'Guaca', '68318', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(883, '28', 'Guadalupe', '68320', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(884, '28', 'Guapotá', '68322', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(885, '28', 'Guavatá', '68324', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(886, '28', 'Güepsa', '68327', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(887, '28', 'Hato', '68344', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(888, '28', 'Jesús María ', '68368', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(889, '28', 'Jordán', '68370', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(890, '28', 'La Belleza ', '68377', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(891, '28', 'Landázuri', '68385', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(892, '28', 'La Paz ', '68397', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(893, '28', 'Lebrija', '68406', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(894, '28', 'Los Santos ', '68418', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(895, '28', 'Macaravita', '68425', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(896, '28', 'Málaga', '68432', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(897, '28', 'Matanza', '68444', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(898, '28', 'Mogotes', '68464', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(899, '28', 'Molagavita', '68468', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(900, '28', 'Ocamonte', '68498', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(901, '28', 'Oiba', '68500', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(902, '28', 'Onzaga', '68502', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(903, '28', 'Palmar', '68522', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(904, '28', 'Palmas Del Socorro', '68524', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(905, '28', 'Páramo', '68533', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(906, '28', 'Piedecuesta', '68547', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(907, '28', 'Pinchote', '68549', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(908, '28', 'Puente Nacional ', '68572', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(909, '28', 'Puerto Parra ', '68573', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(910, '28', 'Puerto Wilches ', '68575', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(911, '28', 'Rionegro', '68615', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(912, '28', 'Sabana De Torres', '68655', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(913, '28', 'San Andrés ', '68669', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(914, '28', 'San Benito ', '68673', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(915, '28', 'San Gil ', '68679', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(916, '28', 'San Joaquín ', '68682', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(917, '28', 'San José De Miranda', '68684', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(918, '28', 'San Miguel ', '68686', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(919, '28', 'San Vicente De Chucurí', '68689', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(920, '28', 'Santa Bárbara ', '68705', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(921, '28', 'Santa Helena Del Opón', '68720', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(922, '28', 'Simacota', '68745', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(923, '28', 'Socorro', '68755', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(924, '28', 'Suaita', '68770', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(925, '28', 'Sucre', '68773', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(926, '28', 'Suratá', '68780', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(927, '28', 'Tona', '68820', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(928, '28', 'Valle De San José', '68855', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(929, '28', 'Vélez', '68861', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(930, '28', 'Vetas', '68867', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(931, '28', 'Villanueva', '68872', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(932, '28', 'Zapatoca', '68895', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(933, '29', 'Sincelejo', '70001', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(934, '29', 'Buenavista', '70110', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(935, '29', 'Caimito', '70124', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(936, '29', 'Colosó', '70204', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(937, '29', 'Corozal', '70215', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(938, '29', 'Coveñas', '70221', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(939, '29', 'Chalán', '70230', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(940, '29', 'El Roble ', '70233', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(941, '29', 'Galeras', '70235', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(942, '29', 'Guaranda', '70265', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(943, '29', 'La Unión ', '70400', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(944, '29', 'Los Palmitos ', '70418', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(945, '29', 'Majagual', '70429', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(946, '29', 'Morroa', '70473', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(947, '29', 'Ovejas', '70508', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(948, '29', 'Palmito', '70523', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(949, '29', 'Sampués', '70670', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(950, '29', 'San Benito Abad', '70678', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(951, '29', 'San Juan De Betulia', '70702', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(952, '29', 'San Marcos ', '70708', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(953, '29', 'San Onofre ', '70713', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(954, '29', 'San Pedro ', '70717', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(955, '29', 'San Luis De Sincé', '70742', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(956, '29', 'Sucre', '70771', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(957, '29', 'Santiago De Tolú', '70820', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(958, '29', 'Tolú Viejo ', '70823', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(959, '30', 'Ibagué', '73001', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(960, '30', 'Alpujarra', '73024', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(961, '30', 'Alvarado', '73026', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(962, '30', 'Ambalema', '73030', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(963, '30', 'Anzoátegui', '73043', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(964, '30', 'Armero', '73055', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(965, '30', 'Ataco', '73067', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(966, '30', 'Cajamarca', '73124', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(967, '30', 'Carmen De Apicalá', '73148', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(968, '30', 'Casabianca', '73152', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(969, '30', 'Chaparral', '73168', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(970, '30', 'Coello', '73200', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(971, '30', 'Coyaima', '73217', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(972, '30', 'Cunday', '73226', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(973, '30', 'Dolores', '73236', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(974, '30', 'Espinal', '73268', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(975, '30', 'Falan', '73270', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(976, '30', 'Flandes', '73275', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(977, '30', 'Fresno', '73283', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(978, '30', 'Guamo', '73319', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(979, '30', 'Herveo', '73347', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(980, '30', 'Honda', '73349', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(981, '30', 'Icononzo', '73352', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(982, '30', 'Lérida', '73408', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(983, '30', 'Líbano', '73411', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(984, '30', 'San Sebastián De Mariquita', '73443', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(985, '30', 'Melgar', '73449', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(986, '30', 'Murillo', '73461', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(987, '30', 'Natagaima', '73483', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(988, '30', 'Ortega', '73504', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(989, '30', 'Palocabildo', '73520', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(990, '30', 'Piedras', '73547', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(991, '30', 'Planadas', '73555', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(992, '30', 'Prado', '73563', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(993, '30', 'Purificación', '73585', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(994, '30', 'Rioblanco', '73616', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(995, '30', 'Roncesvalles', '73622', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(996, '30', 'Rovira', '73624', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(997, '30', 'Saldaña', '73671', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(998, '30', 'San Antonio ', '73675', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(999, '30', 'San Luis ', '73678', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1000, '30', 'Santa Isabel ', '73686', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1001, '30', 'Suárez', '73770', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1002, '30', 'Valle De San Juan', '73854', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1003, '30', 'Venadillo', '73861', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1004, '30', 'Villahermosa', '73870', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1005, '30', 'Villarrica', '73873', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1006, '31', 'Cali', '76001', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1007, '31', 'Alcalá', '76020', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1008, '31', 'Andalucía', '76036', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1009, '31', 'Ansermanuevo', '76041', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1010, '31', 'Argelia', '76054', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1011, '31', 'Bolívar', '76100', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1012, '31', 'Buenaventura', '76109', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1013, '31', 'Guadalajara De Buga', '76111', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1014, '31', 'Bugalagrande', '76113', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1015, '31', 'Caicedonia', '76122', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1016, '31', 'Calima', '76126', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1017, '31', 'Candelaria', '76130', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1018, '31', 'Cartago', '76147', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1019, '31', 'Dagua', '76233', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1020, '31', 'El Águila ', '76243', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1021, '31', 'El Cairo ', '76246', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1022, '31', 'El Cerrito ', '76248', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1023, '31', 'El Dovio ', '76250', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1024, '31', 'Florida', '76275', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1025, '31', 'Ginebra', '76306', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1026, '31', 'Guacarí', '76318', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1027, '31', 'Jamundí', '76364', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1028, '31', 'La Cumbre ', '76377', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1029, '31', 'La Unión ', '76400', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1030, '31', 'La Victoria ', '76403', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1031, '31', 'Obando', '76497', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1032, '31', 'Palmira', '76520', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1033, '31', 'Pradera', '76563', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1034, '31', 'Restrepo', '76606', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1035, '31', 'Riofrío', '76616', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1036, '31', 'Roldanillo', '76622', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1037, '31', 'San Pedro ', '76670', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1038, '31', 'Sevilla', '76736', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1039, '31', 'Toro', '76823', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1040, '31', 'Trujillo', '76828', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1041, '31', 'Tuluá', '76834', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1042, '31', 'Ulloa', '76845', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1043, '31', 'Versalles', '76863', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1044, '31', 'Vijes', '76869', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1045, '31', 'Yotoco', '76890', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1046, '31', 'Yumbo', '76892', '2026-07-02 21:16:52', '2026-07-02 21:16:52'),
(1047, '31', 'Zarzal', '76895', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1048, '3', 'Arauca', '81001', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1049, '3', 'Arauquita', '81065', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1050, '3', 'Cravo Norte ', '81220', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1051, '3', 'Fortul', '81300', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1052, '3', 'Puerto Rondón ', '81591', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1053, '3', 'Saravena', '81736', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1054, '3', 'Tame', '81794', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1055, '10', 'Yopal', '85001', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1056, '10', 'Aguazul', '85010', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1057, '10', 'Chámeza', '85015', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1058, '10', 'Hato Corozal ', '85125', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1059, '10', 'La Salina ', '85136', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1060, '10', 'Maní', '85139', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1061, '10', 'Monterrey', '85162', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1062, '10', 'Nunchía', '85225', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1063, '10', 'Orocué', '85230', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1064, '10', 'Paz De Ariporo', '85250', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1065, '10', 'Pore', '85263', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1066, '10', 'Recetor', '85279', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1067, '10', 'Sabanalarga', '85300', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1068, '10', 'Sácama', '85315', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1069, '10', 'San Luis De Palenque', '85325', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1070, '10', 'Támara', '85400', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1071, '10', 'Tauramena', '85410', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1072, '10', 'Trinidad', '85430', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1073, '10', 'Villanueva', '85440', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1074, '24', 'Mocoa', '86001', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1075, '24', 'Colón', '86219', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1076, '24', 'Orito', '86320', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1077, '24', 'Puerto Asís ', '86568', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1078, '24', 'Puerto Caicedo ', '86569', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1079, '24', 'Puerto Guzmán ', '86571', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1080, '24', 'Puerto Leguízamo ', '86573', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1081, '24', 'Sibundoy', '86749', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1082, '24', 'San Francisco ', '86755', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1083, '24', 'San Miguel ', '86757', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1084, '24', 'Santiago', '86760', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1085, '24', 'Valle Del Guamuez', '86865', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1086, '24', 'Villagarzón', '86885', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1087, '27', 'San Andrés ', '88001', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1088, '27', 'Providencia', '88564', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1089, '1', 'Leticia', '91001', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1090, '1', 'El Encanto ', '91263', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1091, '1', 'La Chorrera ', '91405', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1092, '1', 'La Pedrera ', '91407', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1093, '1', 'La Victoria ', '91430', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1094, '1', 'Mirití - Paraná', '91460', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1095, '1', 'Puerto Alegría ', '91530', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1096, '1', 'Puerto Arica ', '91536', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1097, '1', 'Puerto Nariño ', '91540', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1098, '1', 'Puerto Santander ', '91669', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1099, '1', 'Tarapacá', '91798', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1100, '16', 'Inírida', '94001', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1101, '16', 'Barranco Minas ', '94343', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1102, '16', 'Mapiripana', '94663', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1103, '16', 'San Felipe ', '94883', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1104, '16', 'Puerto Colombia ', '94884', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1105, '16', 'La Guadalupe ', '94885', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1106, '16', 'Cacahual', '94886', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1107, '16', 'Pana Pana ', '94887', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1108, '16', 'Morichal', '94888', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1109, '17', 'San José Del Guaviare', '95001', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1110, '17', 'Calamar', '95015', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1111, '17', 'El Retorno ', '95025', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1112, '17', 'Miraflores', '95200', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1113, '32', 'Mitú', '97001', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1114, '32', 'Carurú', '97161', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1115, '32', 'Pacoa', '97511', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1116, '32', 'Taraira', '97666', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1117, '32', 'Papunahua', '97777', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1118, '32', 'Yavaraté', '97889', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1119, '33', 'Puerto Carreño ', '99001', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1120, '33', 'La Primavera ', '99524', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1121, '33', 'Santa Rosalía ', '99624', '2026-07-02 21:16:53', '2026-07-02 21:16:53'),
(1122, '33', 'Cumaribo', '99773', '2026-07-02 21:16:53', '2026-07-02 21:16:53');

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

--
-- Estructura de tabla para la tabla `nominas`
--

CREATE TABLE `nominas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `consecutive` int(11) NOT NULL,
  `uuid` longtext COLLATE utf8mb4_unicode_ci,
  `admision_date` date NOT NULL,
  `settlement_start_date` date NOT NULL,
  `settlement_end_date` date NOT NULL,
  `payroll_period_id` int(11) NOT NULL,
  `worked_time` decimal(10,2) NOT NULL,
  `issue_date` date DEFAULT NULL,
  `type_worker_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identification_number` double NOT NULL,
  `nombre` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `worked_days` double NOT NULL,
  `accrued_total` decimal(10,2) NOT NULL DEFAULT '859000.00',
  `salario` decimal(10,2) NOT NULL,
  `deductions_total` decimal(10,2) NOT NULL DEFAULT '120000.00',
  `json` longtext COLLATE utf8mb4_unicode_ci,
  `estate_Json` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `state_nota` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `nota_enviada` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `cune` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `notas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `num_sale` double NOT NULL,
  `numero` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `json` longtext COLLATE utf8mb4_unicode_ci,
  `state` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `uuid` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `notasnomina`
--

CREATE TABLE `notasnomina` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `num_sale` double NOT NULL,
  `numero` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `json` longtext COLLATE utf8mb4_unicode_ci,
  `state` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `cune` longtext COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Sterling Software Personal Access Client', 'SiEArCH52t8mJCGtQdpkXnZ9D1bL0K07U2l35pG9', 'http://localhost', 1, 0, 0, '2026-07-02 21:17:02', '2026-07-02 21:17:02'),
(2, NULL, 'Sterling Software Password Grant Client', 'UbVIJU8L6Odx4O8QCx5vnTyW7ZuyNIXu6W4ZcBvd', 'http://localhost', 0, 1, 0, '2026-07-02 21:17:02', '2026-07-02 21:17:02');

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

--
-- Estructura de tabla para la tabla `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2026-07-02 21:17:02', '2026-07-02 21:17:02');

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

--
-- Estructura de tabla para la tabla `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `permissions`
--

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` bigint(20) UNSIGNED NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` (`id`, `name`, `slug`, `module_id`, `description`, `created_at`, `updated_at`) VALUES
(1, 'browse roles', 'role.index', 1, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(2, 'Save roles', 'role.store', 1, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(3, 'Update roles', 'role.update', 1, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(4, 'browse users', 'users.index', 2, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(5, 'Save users', 'users.store', 2, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(6, 'Update users', 'users.update', 2, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(7, 'Disable users', 'users.disable', 2, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(8, 'Enable users', 'users.enable', 2, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(9, 'Navegar Categorias', 'categorias.index', 3, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(10, 'Actualizar Categorias', 'categorias.update', 3, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(11, 'Guardar Categorias', 'categorias.store', 3, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(12, 'Eliminar Categorias', 'categorias.delete', 3, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(13, 'Navegar en Unidades', 'units.index', 4, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(14, 'Actualizar Unidades', 'units.update', 4, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(15, 'Guardar Unidades', 'units.store', 4, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(16, 'Eliminar Unidades', 'units.delete', 4, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(17, 'Actualizar Productos', 'products.update', 5, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(18, 'Guradar Productos', 'products.store', 5, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(19, 'Eliminar Productos', 'products.delete', 5, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(20, 'Importar Productos', 'products.import', 5, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(21, 'Ver Stock', 'products.stock', 5, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(22, 'Navegar en Clientes', 'clients.index', 6, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(23, 'Actualizar Clientes', 'clients.update', 6, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(24, 'Guardar Clientes', 'clients.store', 6, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(25, 'Eliminar Clientes', 'clients.delete', 6, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(26, 'Nvegar en Provedores', 'providers.index', 7, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(27, 'Actualizar Provedores', 'providers.update', 7, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(28, 'Guardar Provedores', 'providers.store', 7, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(29, 'Eliminar  Provedores', 'providers.delete', 7, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(30, 'Navegar en Compras', 'entries.index', 8, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(31, 'Actualizar Comras', 'entries.update', 8, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(32, 'Guardar Compras', 'entries.store', 8, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(33, 'Eliminar Compras', 'entries.delete', 8, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(34, 'Comparador de Precios', 'entries.comparador', 8, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(35, 'Navegar en Factura', 'sales.index', 9, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(36, 'Actualizar Facturas', 'sales.update', 9, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(37, 'Guardar Facturas', 'sales.store', 9, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(38, 'Eliminar Facturas', 'sales.delete', 9, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(39, 'Arqueo factura', 'sales.arqueo', 9, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(40, 'Arqueo Pos', 'pos.arqueo', 9, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(41, 'Trazabilidad', 'sales.trazabilidad', 9, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(42, 'Browse Empresas', 'empresas.index', 10, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(43, 'Update Empresas', 'empresas.update', 10, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(44, 'Save Empresas', 'empresas.store', 10, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(45, 'Actualizar cxc', 'cxc.update', 11, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(46, 'Guardar cxc', 'cxc.store', 11, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(47, 'Actualizar cxp', 'cxp.update', 12, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(48, 'Guardar cxp', 'cxp.store', 12, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(49, 'Guardar Gastos', 'gastos.store', 13, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(50, 'Actualizar Gastos', 'gastos.update', 13, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(51, 'Guardar Cardex', 'cardex.store', 14, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(52, 'Actualizar Cardex', 'cardex.update', 14, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(53, 'Eliminar Cardex', 'cardex.delete', 14, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(54, 'Navegar Corte', 'corte.index', 15, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(55, 'Navegar Caja', 'caja.index', 16, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(56, 'Reporte Factura', 'reporteFactura.fecha', 17, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(57, 'Reporte Detalle', 'reporteDetalleFactura.fecha', 18, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(58, 'Navegar Reporte Compra', 'reporteCompra.fecha', 19, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(59, 'Navegar Reporte Detalle Compra', 'reporteDetalleCompra.fecha', 20, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(60, 'Navegar Cardex', 'cardex.fecha', 21, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(61, 'Navegar Rotacion', 'rotacion.fecha', 22, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(62, 'Guardar Cierre', 'cierre.store', 23, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(63, 'Guardar Pos', 'pos.store', 24, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(64, 'Update Pos', 'pos.update', 24, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(65, 'Navegar Empleados', 'empleados.index', 25, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(66, 'Navegar Balance', 'balance.index', 25, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(67, 'Navegar pyg', 'pyg.index', 25, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(68, 'Navegar Nomina', 'nomina.index', 25, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(69, 'Navegar Gast Operativos', 'operativo.index', 25, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(70, 'Corte  Factura', 'corteFactura.index', 26, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(71, 'Corte  Pos ', 'cortePos.index', 27, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(72, 'Navegar Reportes ', 'reportes.index', 28, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(73, 'Detalle Pos ', 'DetallePos.index', 29, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(74, 'Navegar en Ajuste', 'ajustes.index', 30, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(75, 'Actualizar Ajuste', 'ajustes.update', 30, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(76, 'Guardar Ajuste', 'ajustes.store', 30, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(77, 'Eliminar Ajuste', 'ajustes.delete', 30, '', '2026-07-02 21:16:48', '2026-07-02 21:16:48');

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

--
-- Estructura de tabla para la tabla `permission_role`
--

CREATE TABLE `permission_role` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permission_role` (`id`, `permission_id`, `role_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(2, 2, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(3, 3, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(4, 4, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(5, 5, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(6, 6, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(7, 7, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(8, 8, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(9, 9, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(10, 10, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(11, 11, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(12, 12, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(13, 13, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(14, 14, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(15, 15, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(16, 16, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(17, 17, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(18, 18, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(19, 19, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(20, 20, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(21, 21, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(22, 22, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(23, 23, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(24, 24, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(25, 25, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(26, 26, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(27, 27, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(28, 28, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(29, 29, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(30, 30, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(31, 31, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(32, 32, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(33, 33, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(34, 34, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(35, 35, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(36, 36, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(37, 37, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(38, 38, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(39, 39, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(40, 40, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(41, 41, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(42, 42, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(43, 43, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(44, 44, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(45, 45, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(46, 46, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(47, 47, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(48, 48, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(49, 49, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(50, 50, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(51, 51, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(52, 52, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(53, 53, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(54, 54, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(55, 55, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(56, 56, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(57, 57, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(58, 58, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(59, 59, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(60, 60, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(61, 61, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(62, 62, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(63, 63, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(64, 64, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(65, 65, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(66, 66, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(67, 67, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(68, 68, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(69, 69, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(70, 70, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(71, 71, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(72, 72, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(73, 73, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(74, 74, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(75, 75, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(76, 76, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(77, 77, 1, '2026-07-02 21:16:49', '2026-07-02 21:16:49');

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

--
-- Estructura de tabla para la tabla `porcategorias`
--

CREATE TABLE `porcategorias` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cantidad` int(11) NOT NULL,
  `total` varchar(15) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `pos`
--

CREATE TABLE `pos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `request_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_sale` double NOT NULL,
  `idCxC` int(11) NOT NULL DEFAULT '0',
  `number` double NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `caja` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_voucher` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` decimal(20,2) NOT NULL,
  `total_iva` decimal(20,2) NOT NULL,
  `total_neto` decimal(20,2) NOT NULL,
  `fechaInicio` date NOT NULL,
  `fechaFin` datetime NOT NULL,
  `forma_pago` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pago` decimal(20,2) NOT NULL DEFAULT '0.00',
  `queda` decimal(20,2) NOT NULL DEFAULT '0.00',
  `state` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `state_nota` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `json` longtext COLLATE utf8mb4_unicode_ci,
  `Estado_Json` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `numero` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uuid` varchar(350) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `issue_date` date DEFAULT NULL,
  `pdfBase64Bytes` longtext COLLATE utf8mb4_unicode_ci,
  `attachedDocumentBytes` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `products`
--

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `barcode` double NOT NULL,
  `localizacion` int(11) NOT NULL DEFAULT '1',
  `primera_medida` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Unidad',
  `segunda_medida` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Sin Datos',
  `tercera_medida` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Sin Datos',
  `stock` decimal(20,2) NOT NULL DEFAULT '0.00',
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `categoria` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(20,2) NOT NULL DEFAULT '0.00',
  `price_sale` decimal(20,2) NOT NULL DEFAULT '0.00',
  `segundo_price` decimal(20,2) NOT NULL DEFAULT '0.00',
  `tercer_price` decimal(20,2) NOT NULL DEFAULT '0.00',
  `des_primera_medida` decimal(8,2) NOT NULL DEFAULT '1.00',
  `des_segunda_medida` decimal(8,2) NOT NULL DEFAULT '0.00',
  `des_tercera_medida` decimal(8,2) NOT NULL DEFAULT '0.00',
  `tax` decimal(20,2) NOT NULL DEFAULT '0.00',
  `clasificacion` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `caracteristica` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `raya` int(11) NOT NULL DEFAULT '0',
  `caja` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'Admin',
  `state` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` (`id`, `barcode`, `localizacion`, `primera_medida`, `segunda_medida`, `tercera_medida`, `stock`, `name`, `categoria`, `price`, `price_sale`, `segundo_price`, `tercer_price`, `des_primera_medida`, `des_segunda_medida`, `des_tercera_medida`, `tax`, `clasificacion`, `caracteristica`, `raya`, `caja`, `state`) VALUES
(1, 1, 2, 'Unidad', 'Blister', 'Caja', 100.00, 'Tohallas', 'Medicamentos', 500.00, 1000.00, 10000.00, 50000.00, 1.00, 10.00, 50.00, 0.00, 'Excluido', 'Aseo', 0, 'Admin', '1'),
(2, 2, 2, 'Unidad', 'Blister', 'Caja', 100.00, 'Servicios', 'Servicios de inyectologia', 500.00, 1000.00, 10000.00, 50000.00, 1.00, 10.00, 50.00, 5.00, 'Gravado', 'Analgesico', 0, 'Admin', '1');

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

--
-- Estructura de tabla para la tabla `providers`
--

CREATE TABLE `providers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nit` double NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_representative` varchar(70) COLLATE utf8mb4_unicode_ci NOT NULL,
  `telephone` double NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `direction` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cuenta` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `providers` (`id`, `nit`, `name`, `name_representative`, `telephone`, `email`, `direction`, `cuenta`, `state`, `created_at`, `updated_at`) VALUES
(1, 1, 'Proveedor Uno', 'Sterling Diaz', 1234567890, 'proveedor@hotmail.com', 'Calle 5 # 10-47', '03174799625', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(2, 93343122, 'Ensayo del sistema', 'Sterling Diaz', 3174799625, 'sterling-diaz@hotmail.com', 'Calle 5 # 5-08 Yaguara', '03174799625', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49');

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

--
-- Estructura de tabla para la tabla `pyg`
--

CREATE TABLE `pyg` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(2500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valor` decimal(15,2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pyg` (`id`, `name`, `valor`) VALUES
(1, 'Ingresos', NULL),
(2, 'Ventas', NULL),
(3, 'Ingresos servicios', NULL),
(4, 'Total de Ingresos', NULL),
(5, 'Costos de Venta', NULL),
(6, 'Costo mercancias vendidas', NULL),
(7, 'Otros costos de de servicios', NULL),
(8, 'Total de Costo de Venta', NULL),
(9, 'Utilidad Bruta', NULL),
(10, 'Gasto de Operacion', NULL),
(11, 'Salarios', NULL),
(12, 'Alquiler', NULL),
(13, 'Servicios Públicos', NULL),
(14, 'Total de Gastos de Operación', NULL),
(15, 'Utilidad de Operación', NULL),
(16, 'Otros Ingresos y Gastos', NULL),
(17, 'Ingresos financieros', NULL),
(18, 'Otros Gastos', NULL),
(19, 'Intereses de deuda', NULL),
(20, 'Ganancias antes de Impuesto', NULL),
(21, 'Impuestos', NULL),
(22, 'Ganancias Neta', NULL);

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

--
-- Estructura de tabla para la tabla `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `slug`, `description`, `created_at`, `updated_at`) VALUES
(1, 'SuperAdmin', 'superadmin', 'Control total del sistema', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(2, 'Administrador', 'admin', 'Control del 80% de la aplicación', '2026-07-02 21:16:48', '2026-07-02 21:16:48'),
(3, 'Operario', 'opera', 'Control restringido', '2026-07-02 21:16:48', '2026-07-02 21:16:48');

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

--
-- Estructura de tabla para la tabla `role_user`
--

CREATE TABLE `role_user` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `role_user` (`id`, `role_id`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 1, 1, '2026-07-02 21:16:48', '2026-07-02 21:16:48');

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

--
-- Estructura de tabla para la tabla `sales`
--

CREATE TABLE `sales` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `request_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `num_sale` double NOT NULL,
  `idCxC` int(11) NOT NULL DEFAULT '0',
  `number` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(350) COLLATE utf8mb4_unicode_ci NOT NULL,
  `caja` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type_voucher` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total` decimal(20,2) NOT NULL,
  `total_iva` decimal(20,2) NOT NULL,
  `total_neto` decimal(20,2) NOT NULL,
  `fechaInicio` date NOT NULL,
  `fechaFin` datetime NOT NULL,
  `forma_pago` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `pago` decimal(20,2) NOT NULL DEFAULT '0.00',
  `queda` decimal(20,2) NOT NULL DEFAULT '0.00',
  `state` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `state_nota` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `nota_enviada` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `json` longtext COLLATE utf8mb4_unicode_ci,
  `Estado_Json` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `numero` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `uuid` varchar(350) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `taxes`
--

CREATE TABLE `taxes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tax` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `total`
--

CREATE TABLE `total` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `total` decimal(20,2) NOT NULL,
  `oparaciones` decimal(20,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `type_documents`
--

CREATE TABLE `type_documents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `dane` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(250) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Estructura de tabla para la tabla `units`
--

CREATE TABLE `units` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `units` (`id`, `name`, `state`, `created_at`, `updated_at`) VALUES
(1, 'Unidad', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(2, 'Sachet', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(3, 'Blister', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(4, 'Caja', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(5, 'Paca', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49'),
(6, 'Sin Datos', '1', '2026-07-02 21:16:49', '2026-07-02 21:16:49');

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

--
-- Estructura de tabla para la tabla `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `surname` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` int(11) NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `surname`, `email`, `email_verified_at`, `password`, `state`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Sterling', 'Diaz', 'admin', NULL, '$2y$10$xHHgV54YihVwuKCrZZDO8ekY.5H/p.jL5qE.d9/d8oyWZRq.yY.Sa', 1, NULL, '2026-07-02 21:16:48', '2026-07-02 21:16:48');

--
-- Índices para tablas volcadas
--

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

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

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

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

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

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

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

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

--
-- Indices de la tabla `clients`
--
ALTER TABLE `clients`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `clients_number_unique` (`number`);

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

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

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

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

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

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

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

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

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

--
-- Indices de la tabla `empleados`
--
ALTER TABLE `empleados`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `empleados_email_unique` (`email`);

--
-- Indices de la tabla `empresas`
--
ALTER TABLE `empresas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `empresas_email_unique` (`email`);

--
-- Indices de la tabla `entries`
--
ALTER TABLE `entries`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `entries_request_id_unique` (`request_id`);

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

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

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

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

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

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

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

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

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

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

--
-- Indices de la tabla `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);

--
-- Indices de la tabla `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

--
-- Indices de la tabla `oauth_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_user_id_index` (`user_id`);

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

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

--
-- Indices de la tabla `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

--
-- Indices de la tabla `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_slug_unique` (`slug`),
  ADD KEY `permissions_module_id_foreign` (`module_id`);

--
-- Indices de la tabla `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`id`),
  ADD KEY `permission_role_permission_id_index` (`permission_id`),
  ADD KEY `permission_role_role_id_index` (`role_id`);

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

--
-- Indices de la tabla `pos`
--
ALTER TABLE `pos`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `pos_num_sale_unique` (`num_sale`),
  ADD UNIQUE KEY `pos_request_id_unique` (`request_id`);

--
-- Indices de la tabla `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `products_barcode_unique` (`barcode`);

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

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

--
-- Indices de la tabla `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_unique` (`name`),
  ADD UNIQUE KEY `roles_slug_unique` (`slug`);

--
-- Indices de la tabla `role_user`
--
ALTER TABLE `role_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `role_user_role_id_index` (`role_id`),
  ADD KEY `role_user_user_id_index` (`user_id`);

--
-- Indices de la tabla `sales`
--
ALTER TABLE `sales`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `sales_num_sale_unique` (`num_sale`),
  ADD UNIQUE KEY `sales_request_id_unique` (`request_id`);

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

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

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

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

--
-- Indices de la tabla `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `abonoscxc`
--
ALTER TABLE `abonoscxc`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `abonoscxp`
--
ALTER TABLE `abonoscxp`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `activos`
--
ALTER TABLE `activos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT de la tabla `ajustes`
--
ALTER TABLE `ajustes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `auditoria`
--
ALTER TABLE `auditoria`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `cardex`
--
ALTER TABLE `cardex`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `categorias`
--
ALTER TABLE `categorias`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de la tabla `cierre`
--
ALTER TABLE `cierre`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `clients`
--
ALTER TABLE `clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `cxc`
--
ALTER TABLE `cxc`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `cxc_excel`
--
ALTER TABLE `cxc_excel`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `cxp`
--
ALTER TABLE `cxp`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `departamentos`
--
ALTER TABLE `departamentos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT de la tabla `detail_entries`
--
ALTER TABLE `detail_entries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `detail_sales`
--
ALTER TABLE `detail_sales`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `detalle_documentos`
--
ALTER TABLE `detalle_documentos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `detalle_pos`
--
ALTER TABLE `detalle_pos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `documentos`
--
ALTER TABLE `documentos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `empleados`
--
ALTER TABLE `empleados`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `empresas`
--
ALTER TABLE `empresas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `entries`
--
ALTER TABLE `entries`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `fechas`
--
ALTER TABLE `fechas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `gastos`
--
ALTER TABLE `gastos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `gastosoperativos`
--
ALTER TABLE `gastosoperativos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT de la tabla `modules`
--
ALTER TABLE `modules`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32;

--
-- AUTO_INCREMENT de la tabla `municipios`
--
ALTER TABLE `municipios`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1123;

--
-- AUTO_INCREMENT de la tabla `nominas`
--
ALTER TABLE `nominas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `notas`
--
ALTER TABLE `notas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `notasnomina`
--
ALTER TABLE `notasnomina`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `oauth_clients`
--
ALTER TABLE `oauth_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

--
-- AUTO_INCREMENT de la tabla `permission_role`
--
ALTER TABLE `permission_role`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

--
-- AUTO_INCREMENT de la tabla `porcategorias`
--
ALTER TABLE `porcategorias`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `pos`
--
ALTER TABLE `pos`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `providers`
--
ALTER TABLE `providers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT de la tabla `pyg`
--
ALTER TABLE `pyg`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;

--
-- AUTO_INCREMENT de la tabla `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT de la tabla `role_user`
--
ALTER TABLE `role_user`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT de la tabla `sales`
--
ALTER TABLE `sales`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `taxes`
--
ALTER TABLE `taxes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `total`
--
ALTER TABLE `total`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `type_documents`
--
ALTER TABLE `type_documents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT de la tabla `units`
--
ALTER TABLE `units`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT de la tabla `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `permissions`
--
ALTER TABLE `permissions`
  ADD CONSTRAINT `permissions_module_id_foreign` FOREIGN KEY (`module_id`) REFERENCES `modules` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `permission_role`
--
ALTER TABLE `permission_role`
  ADD CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Filtros para la tabla `role_user`
--
ALTER TABLE `role_user`
  ADD CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

