-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 11, 2026 at 05:45 AM
-- Server version: 10.11.16-MariaDB
-- PHP Version: 8.4.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 */;

--
-- Database: `nwrbcpcmisbeesit_staging_db`
--

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

--
-- Table structure for table `regions`
--

-- CREATE TABLE `regions` (
--  `id` bigint(20) UNSIGNED NOT NULL,
--  `code` varchar(255) DEFAULT NULL,
--  `name` varchar(255) DEFAULT NULL,
--  `region_name` varchar(255) DEFAULT NULL,
--  `island_group_code` varchar(255) DEFAULT NULL,
--  `psgc_10_digit_code` varchar(255) DEFAULT NULL,
--  `created_at` timestamp NULL DEFAULT NULL,
--  `updated_at` timestamp NULL DEFAULT NULL
-- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`id`, `code`, `name`, `region_name`, `island_group_code`, `psgc_10_digit_code`, `created_at`, `updated_at`) VALUES
(1, '0100000000', 'Region I (Ilocos Region)', 'Region I (Ilocos Region)', NULL, '0100000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(2, '0200000000', 'Region II (Cagayan Valley)', 'Region II (Cagayan Valley)', NULL, '0200000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(3, '0300000000', 'Region III (Central Luzon)', 'Region III (Central Luzon)', NULL, '0300000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(4, '0400000000', 'Region IV-A (CALABARZON)', 'Region IV-A (CALABARZON)', NULL, '0400000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(5, '1700000000', 'MIMAROPA Region', 'MIMAROPA Region', NULL, '1700000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(6, '0500000000', 'Region V (Bicol Region)', 'Region V (Bicol Region)', NULL, '0500000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(7, '0600000000', 'Region VI (Western Visayas)', 'Region VI (Western Visayas)', NULL, '0600000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(8, '0700000000', 'Region VII (Central Visayas)', 'Region VII (Central Visayas)', NULL, '0700000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(9, '0800000000', 'Region VIII (Eastern Visayas)', 'Region VIII (Eastern Visayas)', NULL, '0800000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(10, '0900000000', 'Region IX (Zamboanga Peninsula)', 'Region IX (Zamboanga Peninsula)', NULL, '0900000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(11, '1000000000', 'Region X (Northern Mindanao)', 'Region X (Northern Mindanao)', NULL, '1000000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(12, '1100000000', 'Region XI (Davao Region)', 'Region XI (Davao Region)', NULL, '1100000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(13, '1200000000', 'Region XII (SOCCSKSARGEN)', 'Region XII (SOCCSKSARGEN)', NULL, '1200000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(14, '1300000000', 'National Capital Region (NCR)', 'National Capital Region (NCR)', NULL, '1300000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(15, '1400000000', 'Cordillera Administrative Region (CAR)', 'Cordillera Administrative Region (CAR)', NULL, '1400000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(16, '1600000000', 'Region XIII (Caraga)', 'Region XIII (Caraga)', NULL, '1600000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55'),
(17, '1900000000', 'Bangsamoro Autonomous Region In Muslim Mindanao (BARMM)', 'Bangsamoro Autonomous Region In Muslim Mindanao (BARMM)', NULL, '1900000000', '2025-12-18 05:47:55', '2025-12-18 05:47:55');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `regions`
--
-- ALTER TABLE `regions`
--  ADD PRIMARY KEY (`id`),
--  ADD UNIQUE KEY `regions_code_unique` (`code`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `regions`
--
ALTER TABLE `regions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
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 */;