

CREATE TABLE `llx_c_departamentos` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `country_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8_spanish_ci NOT NULL,
  `code` char(191) COLLATE utf8_spanish_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_spanish_ci;

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

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

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `llx_c_departamentos`
--
ALTER TABLE `llx_c_departamentos`
  ADD PRIMARY KEY (`id`),
  ADD KEY `llx_c_departamentos_country_id_foreign` (`country_id`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

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

--
-- Restricciones para tablas volcadas
--

--
-- Filtros para la tabla `llx_c_departamentos`
--
ALTER TABLE `llx_c_departamentos`
  ADD CONSTRAINT `llx_c_departamentos_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE;
COMMIT;

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