-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `webgis_bajobarat`
--

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

--
-- Table structure for table `desas`
--

CREATE TABLE `desas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama_desa` varchar(255) NOT NULL,
  `kecamatan` varchar(255) DEFAULT NULL,
  `jumlah_penduduk` int(11) NOT NULL DEFAULT 0,
  `jumlah_kk` int(11) NOT NULL DEFAULT 0,
  `laki_laki` int(11) NOT NULL DEFAULT 0,
  `perempuan` int(11) NOT NULL DEFAULT 0,
  `balita` int(11) NOT NULL DEFAULT 0,
  `lansia` int(11) NOT NULL DEFAULT 0,
  `desil_1` int(11) NOT NULL DEFAULT 0,
  `desil_2` int(11) NOT NULL DEFAULT 0,
  `desil_3` int(11) NOT NULL DEFAULT 0,
  `desil_4` int(11) NOT NULL DEFAULT 0,
  `mesjid` int(11) NOT NULL DEFAULT 0,
  `sekolah` int(11) NOT NULL DEFAULT 0,
  `posyandu` int(11) NOT NULL DEFAULT 0,
  `postu_puskesmas` int(11) NOT NULL DEFAULT 0,
  `kantor_desa` int(11) NOT NULL DEFAULT 0,
  `pengetahuan_longsor` tinyint(1) NOT NULL DEFAULT 0,
  `jalur_evakuasi` tinyint(1) NOT NULL DEFAULT 0,
  `tempat_evakuasi` tinyint(1) NOT NULL DEFAULT 0,
  `tim_penanggulangan` tinyint(1) NOT NULL DEFAULT 0,
  `sosialisasi_bencana` tinyint(1) NOT NULL DEFAULT 0,
  `dana_bencana` tinyint(1) NOT NULL DEFAULT 0,
  `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 `desas`
--

INSERT INTO `desas` (`id`, `nama_desa`, `kecamatan`, `jumlah_penduduk`, `jumlah_kk`, `laki_laki`, `perempuan`, `balita`, `lansia`, `desil_1`, `desil_2`, `desil_3`, `desil_4`, `mesjid`, `sekolah`, `posyandu`, `postu_puskesmas`, `kantor_desa`, `pengetahuan_longsor`, `jalur_evakuasi`, `tempat_evakuasi`, `tim_penanggulangan`, `sosialisasi_bencana`, `dana_bencana`, `created_at`, `updated_at`) VALUES
(2, 'Bonelemo Barat', NULL, 500, 80, 300, 200, 50, 70, 10, 20, 30, 40, 1, 2, 6, 3, 1, 1, 1, 1, 1, 1, 1, '2026-08-02 00:16:01', '2026-08-02 00:33:42'),
(3, 'Bonelemo', 'Bajo Barat', 400, 50, 200, 200, 30, 90, 20, 30, 20, 10, 2, 3, 5, 6, 1, 1, 1, 0, 0, 1, 1, '2026-08-02 00:20:21', '2026-08-02 00:33:07'),
(4, 'Bonelemo Utara', 'Bajo Barat', 600, 300, 300, 300, 60, 20, 20, 10, 20, 10, 3, 2, 5, 8, 1, 0, 1, 1, 1, 1, 0, '2026-08-02 00:35:18', '2026-08-02 00:35:18');

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

--
-- Table structure for table `failed_jobs`
--

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

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

--
-- Table structure for table `migrations`
--

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

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2019_08_19_000000_create_failed_jobs_table', 1),
(4, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2026_08_02_065416_create_desas_table', 1);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `desas`
--
ALTER TABLE `desas`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `desas`
--
ALTER TABLE `desas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

