-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: May 11, 2026 at 04:20 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 `provinces`
--

-- CREATE TABLE `provinces` (
--  `id` bigint(20) UNSIGNED NOT NULL,
--  `code` varchar(255) NOT NULL,
--  `name` varchar(255) DEFAULT NULL,
--  `region_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 `provinces`
--

INSERT INTO `provinces` (`id`, `code`, `name`, `region_code`, `island_group_code`, `psgc_10_digit_code`, `created_at`, `updated_at`) VALUES
(1, '0102800000', 'Ilocos Norte', '0100000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(2, '0102900000', 'Ilocos Sur', '0100000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(3, '0103300000', 'La Union', '0100000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(4, '0105500000', 'Pangasinan', '0100000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(5, '0200900000', 'Batanes', '0200000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(6, '0201500000', 'Cagayan', '0200000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(7, '0203100000', 'Isabela', '0200000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(8, '0205000000', 'Nueva Vizcaya', '0200000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(9, '0205700000', 'Quirino', '0200000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(10, '0300800000', 'Bataan', '0300000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(11, '0301400000', 'Bulacan', '0300000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(12, '0304900000', 'Nueva Ecija', '0300000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(13, '0305400000', 'Pampanga', '0300000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(14, '0306900000', 'Tarlac', '0300000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(15, '0307100000', 'Zambales', '0300000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(16, '0307700000', 'Aurora', '0300000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(17, '0401000000', 'Batangas', '0400000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(18, '0402100000', 'Cavite', '0400000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(19, '0403400000', 'Laguna', '0400000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(20, '0405600000', 'Quezon', '0400000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(21, '0405800000', 'Rizal', '0400000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(22, '1704000000', 'Marinduque', '1700000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(23, '1705100000', 'Occidental Mindoro', '1700000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(24, '1705200000', 'Oriental Mindoro', '1700000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(25, '1705300000', 'Palawan', '1700000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(26, '1705900000', 'Romblon', '1700000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(27, '0500500000', 'Albay', '0500000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(28, '0501600000', 'Camarines Norte', '0500000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(29, '0501700000', 'Camarines Sur', '0500000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(30, '0502000000', 'Catanduanes', '0500000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(31, '0504100000', 'Masbate', '0500000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(32, '0506200000', 'Sorsogon', '0500000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(33, '0600400000', 'Aklan', '0600000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(34, '0600600000', 'Antique', '0600000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(35, '0601900000', 'Capiz', '0600000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(36, '0603000000', 'Iloilo', '0600000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(37, '0604500000', 'Negros Occidental', '0600000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(38, '0607900000', 'Guimaras', '0600000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(39, '0701200000', 'Bohol', '0700000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(40, '0702200000', 'Cebu', '0700000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(41, '0704600000', 'Negros Oriental', '0700000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(42, '0706100000', 'Siquijor', '0700000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(43, '0802600000', 'Eastern Samar', '0800000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(44, '0803700000', 'Leyte', '0800000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(45, '0804800000', 'Northern Samar', '0800000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(46, '0806000000', 'Samar', '0800000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(47, '0806400000', 'Southern Leyte', '0800000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(48, '0807800000', 'Biliran', '0800000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(49, '0907200000', 'Zamboanga del Norte', '0900000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(50, '0907300000', 'Zamboanga del Sur', '0900000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(51, '0908300000', 'Zamboanga Sibugay', '0900000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(52, '1001300000', 'Bukidnon', '1000000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(53, '1001800000', 'Camiguin', '1000000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(54, '1003500000', 'Lanao del Norte', '1000000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(55, '1004200000', 'Misamis Occidental', '1000000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(56, '1004300000', 'Misamis Oriental', '1000000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(57, '1102300000', 'Davao del Norte', '1100000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(58, '1102400000', 'Davao del Sur', '1100000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(59, '1102500000', 'Davao Oriental', '1100000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(60, '1108200000', 'Davao de Oro', '1100000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(61, '1108600000', 'Davao Occidental', '1100000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(62, '1204700000', 'Cotabato', '1200000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(63, '1206300000', 'South Cotabato', '1200000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(64, '1206500000', 'Sultan Kudarat', '1200000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(65, '1208000000', 'Sarangani', '1200000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(66, '1400100000', 'Abra', '1400000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(67, '1401100000', 'Benguet', '1400000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(68, '1402700000', 'Ifugao', '1400000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(69, '1403200000', 'Kalinga', '1400000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(70, '1404400000', 'Mountain Province', '1400000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(71, '1408100000', 'Apayao', '1400000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(72, '1600200000', 'Agusan del Norte', '1600000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(73, '1600300000', 'Agusan del Sur', '1600000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(74, '1606700000', 'Surigao del Norte', '1600000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(75, '1606800000', 'Surigao del Sur', '1600000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(76, '1608500000', 'Dinagat Islands', '1600000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(77, '1900700000', 'Basilan', '1900000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(78, '1903600000', 'Lanao del Sur', '1900000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(79, '1906600000', 'Sulu', '1900000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(80, '1907000000', 'Tawi-Tawi', '1900000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(81, '1908700000', 'Maguindanao del Norte', '1900000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20'),
(82, '1908800000', 'Maguindanao del Sur', '1900000000', NULL, NULL, '2026-01-05 23:27:20', '2026-01-05 23:27:20');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT for dumped tables
--

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