-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost:3307
-- Tiempo de generación: 28-04-2025 a las 18:58:10
-- Versión del servidor: 8.0.30
-- Versión de PHP: 8.2.20

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


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

--
-- Base de datos: `fe`
--

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

--
-- Estructura de tabla para la tabla `mh_departamento`
--

CREATE TABLE `mh_departamento` (
  `id` bigint UNSIGNED NOT NULL,
  `codigo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `valor` varchar(255) CHARACTER SET utf8mb4 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 `mh_departamento`
--

INSERT INTO `mh_departamento` (`id`, `codigo`, `valor`, `created_at`, `updated_at`) VALUES
(1, '01', 'Ahuachapán', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(2, '02', 'Santa Ana', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(3, '03', 'Sonsonate', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(4, '04', 'Chalatenango', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(5, '05', 'La Libertad', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(6, '06', 'San Salvador', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(7, '07', 'Cuscatlán', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(8, '08', 'La Paz', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(9, '09', 'Cabañas', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(10, '10', 'San Vicente', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(11, '11', 'Usulután', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(12, '12', 'San Miguel', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(13, '13', 'Morazán', '2024-03-14 02:49:43', '2024-03-14 02:49:43'),
(14, '14', 'La Unión', '2024-03-14 02:49:43', '2024-03-14 02:49:43');

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `mh_departamento`
--
ALTER TABLE `mh_departamento`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `mh_departamento_codigo_unique` (`codigo`),
  ADD UNIQUE KEY `mh_departamento_valor_unique` (`valor`);

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `mh_departamento`
--
ALTER TABLE `mh_departamento`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
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 */;
