-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 07 Bulan Mei 2025 pada 09.16
-- Versi server: 10.4.25-MariaDB
-- Versi PHP: 7.4.30

START TRANSACTION;



--
-- Database: `lapormaswapres4`
--

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

--
-- Struktur dari tabel `admins`
--

CREATE TABLE `admins` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `username` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8mb4_unicode_ci 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 untuk tabel `admins`
--

INSERT INTO `admins` (`id`, `username`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'admin', '$2y$12$DtpQ7ptS2/sxUn.vb6DYEuRJdxl3yC30HiLjHWnyczjuMVZRDXM.G', NULL, '2025-03-17 16:44:40', '2025-03-17 16:44:40');

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

--
-- Struktur dari tabel `autoshutdown`
--

CREATE TABLE `autoshutdown` (
  `jam` varchar(2) DEFAULT NULL,
  `menit` varchar(2) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data untuk tabel `autoshutdown`
--

INSERT INTO `autoshutdown` (`jam`, `menit`) VALUES
('16', '00'),
('16', '00');

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

--
-- Struktur dari tabel `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `cache`
--

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('lapor_mas_wapres_cache_all_date_availability_cache_keys', 'a:21:{i:0;s:24:\"date_availability_2025_5\";i:1;s:24:\"date_availability_2025_6\";i:2;s:24:\"date_availability_2025_7\";i:3;s:24:\"date_availability_2025_8\";i:4;s:24:\"date_availability_2025_9\";i:5;s:25:\"date_availability_2025_10\";i:6;s:25:\"date_availability_2025_11\";i:7;s:25:\"date_availability_2025_12\";i:8;s:24:\"date_availability_2026_1\";i:9;s:24:\"date_availability_2026_2\";i:10;s:24:\"date_availability_2026_3\";i:11;s:24:\"date_availability_2026_4\";i:12;s:24:\"date_availability_2026_5\";i:13;s:24:\"date_availability_2026_6\";i:14;s:24:\"date_availability_2026_7\";i:15;s:24:\"date_availability_2026_8\";i:16;s:24:\"date_availability_2026_9\";i:17;s:25:\"date_availability_2026_10\";i:18;s:24:\"date_availability_2025_4\";i:19;s:24:\"date_availability_2025_3\";i:20;s:24:\"date_availability_2025_2\";}', 1746597061),
('lapor_mas_wapres_cache_app_cache_version', 'i:1746584705;', 1746627906),
('lapor_mas_wapres_cache_date_availability_2025_10', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:10;s:4:\"year\";i:2025;s:15:\"available_dates\";a:23:{i:0;s:10:\"2025-10-01\";i:1;s:10:\"2025-10-02\";i:2;s:10:\"2025-10-03\";i:3;s:10:\"2025-10-06\";i:4;s:10:\"2025-10-07\";i:5;s:10:\"2025-10-08\";i:6;s:10:\"2025-10-09\";i:7;s:10:\"2025-10-10\";i:8;s:10:\"2025-10-13\";i:9;s:10:\"2025-10-14\";i:10;s:10:\"2025-10-15\";i:11;s:10:\"2025-10-16\";i:12;s:10:\"2025-10-17\";i:13;s:10:\"2025-10-20\";i:14;s:10:\"2025-10-21\";i:15;s:10:\"2025-10-22\";i:16;s:10:\"2025-10-23\";i:17;s:10:\"2025-10-24\";i:18;s:10:\"2025-10-27\";i:19;s:10:\"2025-10-28\";i:20;s:10:\"2025-10-29\";i:21;s:10:\"2025-10-30\";i:22;s:10:\"2025-10-31\";}s:17:\"unavailable_dates\";a:8:{i:0;s:10:\"2025-10-04\";i:1;s:10:\"2025-10-05\";i:2;s:10:\"2025-10-11\";i:3;s:10:\"2025-10-12\";i:4;s:10:\"2025-10-18\";i:5;s:10:\"2025-10-19\";i:6;s:10:\"2025-10-25\";i:7;s:10:\"2025-10-26\";}}', 1746532250),
('lapor_mas_wapres_cache_date_availability_2025_11', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:11;s:4:\"year\";i:2025;s:15:\"available_dates\";a:20:{i:0;s:10:\"2025-11-03\";i:1;s:10:\"2025-11-04\";i:2;s:10:\"2025-11-05\";i:3;s:10:\"2025-11-06\";i:4;s:10:\"2025-11-07\";i:5;s:10:\"2025-11-10\";i:6;s:10:\"2025-11-11\";i:7;s:10:\"2025-11-12\";i:8;s:10:\"2025-11-13\";i:9;s:10:\"2025-11-14\";i:10;s:10:\"2025-11-17\";i:11;s:10:\"2025-11-18\";i:12;s:10:\"2025-11-19\";i:13;s:10:\"2025-11-20\";i:14;s:10:\"2025-11-21\";i:15;s:10:\"2025-11-24\";i:16;s:10:\"2025-11-25\";i:17;s:10:\"2025-11-26\";i:18;s:10:\"2025-11-27\";i:19;s:10:\"2025-11-28\";}s:17:\"unavailable_dates\";a:10:{i:0;s:10:\"2025-11-01\";i:1;s:10:\"2025-11-02\";i:2;s:10:\"2025-11-08\";i:3;s:10:\"2025-11-09\";i:4;s:10:\"2025-11-15\";i:5;s:10:\"2025-11-16\";i:6;s:10:\"2025-11-22\";i:7;s:10:\"2025-11-23\";i:8;s:10:\"2025-11-29\";i:9;s:10:\"2025-11-30\";}}', 1746532251),
('lapor_mas_wapres_cache_date_availability_2025_12', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:12;s:4:\"year\";i:2025;s:15:\"available_dates\";a:21:{i:0;s:10:\"2025-12-01\";i:1;s:10:\"2025-12-02\";i:2;s:10:\"2025-12-03\";i:3;s:10:\"2025-12-04\";i:4;s:10:\"2025-12-05\";i:5;s:10:\"2025-12-08\";i:6;s:10:\"2025-12-09\";i:7;s:10:\"2025-12-10\";i:8;s:10:\"2025-12-11\";i:9;s:10:\"2025-12-12\";i:10;s:10:\"2025-12-15\";i:11;s:10:\"2025-12-16\";i:12;s:10:\"2025-12-17\";i:13;s:10:\"2025-12-18\";i:14;s:10:\"2025-12-19\";i:15;s:10:\"2025-12-22\";i:16;s:10:\"2025-12-23\";i:17;s:10:\"2025-12-24\";i:18;s:10:\"2025-12-25\";i:19;s:10:\"2025-12-26\";i:20;s:10:\"2025-12-29\";}s:17:\"unavailable_dates\";a:10:{i:0;s:10:\"2025-12-06\";i:1;s:10:\"2025-12-07\";i:2;s:10:\"2025-12-13\";i:3;s:10:\"2025-12-14\";i:4;s:10:\"2025-12-20\";i:5;s:10:\"2025-12-21\";i:6;s:10:\"2025-12-27\";i:7;s:10:\"2025-12-28\";i:8;s:10:\"2025-12-30\";i:9;s:10:\"2025-12-31\";}}', 1746532251),
('lapor_mas_wapres_cache_date_availability_2025_2', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:2;s:4:\"year\";i:2025;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:28:{i:0;s:10:\"2025-02-01\";i:1;s:10:\"2025-02-02\";i:2;s:10:\"2025-02-03\";i:3;s:10:\"2025-02-04\";i:4;s:10:\"2025-02-05\";i:5;s:10:\"2025-02-06\";i:6;s:10:\"2025-02-07\";i:7;s:10:\"2025-02-08\";i:8;s:10:\"2025-02-09\";i:9;s:10:\"2025-02-10\";i:10;s:10:\"2025-02-11\";i:11;s:10:\"2025-02-12\";i:12;s:10:\"2025-02-13\";i:13;s:10:\"2025-02-14\";i:14;s:10:\"2025-02-15\";i:15;s:10:\"2025-02-16\";i:16;s:10:\"2025-02-17\";i:17;s:10:\"2025-02-18\";i:18;s:10:\"2025-02-19\";i:19;s:10:\"2025-02-20\";i:20;s:10:\"2025-02-21\";i:21;s:10:\"2025-02-22\";i:22;s:10:\"2025-02-23\";i:23;s:10:\"2025-02-24\";i:24;s:10:\"2025-02-25\";i:25;s:10:\"2025-02-26\";i:26;s:10:\"2025-02-27\";i:27;s:10:\"2025-02-28\";}}', 1746532261),
('lapor_mas_wapres_cache_date_availability_2025_3', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:3;s:4:\"year\";i:2025;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:1:{i:0;s:10:\"2025-03-28\";}}', 1746532261),
('lapor_mas_wapres_cache_date_availability_2025_4', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:4;s:4:\"year\";i:2025;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:30:{i:0;s:10:\"2025-04-01\";i:1;s:10:\"2025-04-02\";i:2;s:10:\"2025-04-03\";i:3;s:10:\"2025-04-04\";i:4;s:10:\"2025-04-05\";i:5;s:10:\"2025-04-06\";i:6;s:10:\"2025-04-07\";i:7;s:10:\"2025-04-08\";i:8;s:10:\"2025-04-09\";i:9;s:10:\"2025-04-10\";i:10;s:10:\"2025-04-11\";i:11;s:10:\"2025-04-12\";i:12;s:10:\"2025-04-13\";i:13;s:10:\"2025-04-14\";i:14;s:10:\"2025-04-15\";i:15;s:10:\"2025-04-16\";i:16;s:10:\"2025-04-17\";i:17;s:10:\"2025-04-18\";i:18;s:10:\"2025-04-19\";i:19;s:10:\"2025-04-20\";i:20;s:10:\"2025-04-21\";i:21;s:10:\"2025-04-22\";i:22;s:10:\"2025-04-23\";i:23;s:10:\"2025-04-24\";i:24;s:10:\"2025-04-25\";i:25;s:10:\"2025-04-26\";i:26;s:10:\"2025-04-27\";i:27;s:10:\"2025-04-28\";i:28;s:10:\"2025-04-29\";i:29;s:10:\"2025-04-30\";}}', 1746532260),
('lapor_mas_wapres_cache_date_availability_2025_5', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:5;s:4:\"year\";i:2025;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:31:{i:0;s:10:\"2025-05-01\";i:1;s:10:\"2025-05-02\";i:2;s:10:\"2025-05-03\";i:3;s:10:\"2025-05-04\";i:4;s:10:\"2025-05-05\";i:5;s:10:\"2025-05-06\";i:6;s:10:\"2025-05-07\";i:7;s:10:\"2025-05-08\";i:8;s:10:\"2025-05-09\";i:9;s:10:\"2025-05-10\";i:10;s:10:\"2025-05-11\";i:11;s:10:\"2025-05-12\";i:12;s:10:\"2025-05-13\";i:13;s:10:\"2025-05-14\";i:14;s:10:\"2025-05-15\";i:15;s:10:\"2025-05-16\";i:16;s:10:\"2025-05-17\";i:17;s:10:\"2025-05-18\";i:18;s:10:\"2025-05-19\";i:19;s:10:\"2025-05-20\";i:20;s:10:\"2025-05-21\";i:21;s:10:\"2025-05-22\";i:22;s:10:\"2025-05-23\";i:23;s:10:\"2025-05-24\";i:24;s:10:\"2025-05-25\";i:25;s:10:\"2025-05-26\";i:26;s:10:\"2025-05-27\";i:27;s:10:\"2025-05-28\";i:28;s:10:\"2025-05-29\";i:29;s:10:\"2025-05-30\";i:30;s:10:\"2025-05-31\";}}', 1746606306),
('lapor_mas_wapres_cache_date_availability_2025_6', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:6;s:4:\"year\";i:2025;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:30:{i:0;s:10:\"2025-06-01\";i:1;s:10:\"2025-06-02\";i:2;s:10:\"2025-06-03\";i:3;s:10:\"2025-06-04\";i:4;s:10:\"2025-06-05\";i:5;s:10:\"2025-06-06\";i:6;s:10:\"2025-06-07\";i:7;s:10:\"2025-06-08\";i:8;s:10:\"2025-06-09\";i:9;s:10:\"2025-06-10\";i:10;s:10:\"2025-06-11\";i:11;s:10:\"2025-06-12\";i:12;s:10:\"2025-06-13\";i:13;s:10:\"2025-06-14\";i:14;s:10:\"2025-06-15\";i:15;s:10:\"2025-06-16\";i:16;s:10:\"2025-06-17\";i:17;s:10:\"2025-06-18\";i:18;s:10:\"2025-06-19\";i:19;s:10:\"2025-06-20\";i:20;s:10:\"2025-06-21\";i:21;s:10:\"2025-06-22\";i:22;s:10:\"2025-06-23\";i:23;s:10:\"2025-06-24\";i:24;s:10:\"2025-06-25\";i:25;s:10:\"2025-06-26\";i:26;s:10:\"2025-06-27\";i:27;s:10:\"2025-06-28\";i:28;s:10:\"2025-06-29\";i:29;s:10:\"2025-06-30\";}}', 1746606306),
('lapor_mas_wapres_cache_date_availability_2025_7', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:7;s:4:\"year\";i:2025;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:31:{i:0;s:10:\"2025-07-01\";i:1;s:10:\"2025-07-02\";i:2;s:10:\"2025-07-03\";i:3;s:10:\"2025-07-04\";i:4;s:10:\"2025-07-05\";i:5;s:10:\"2025-07-06\";i:6;s:10:\"2025-07-07\";i:7;s:10:\"2025-07-08\";i:8;s:10:\"2025-07-09\";i:9;s:10:\"2025-07-10\";i:10;s:10:\"2025-07-11\";i:11;s:10:\"2025-07-12\";i:12;s:10:\"2025-07-13\";i:13;s:10:\"2025-07-14\";i:14;s:10:\"2025-07-15\";i:15;s:10:\"2025-07-16\";i:16;s:10:\"2025-07-17\";i:17;s:10:\"2025-07-18\";i:18;s:10:\"2025-07-19\";i:19;s:10:\"2025-07-20\";i:20;s:10:\"2025-07-21\";i:21;s:10:\"2025-07-22\";i:22;s:10:\"2025-07-23\";i:23;s:10:\"2025-07-24\";i:24;s:10:\"2025-07-25\";i:25;s:10:\"2025-07-26\";i:26;s:10:\"2025-07-27\";i:27;s:10:\"2025-07-28\";i:28;s:10:\"2025-07-29\";i:29;s:10:\"2025-07-30\";i:30;s:10:\"2025-07-31\";}}', 1746606306),
('lapor_mas_wapres_cache_date_availability_2025_8', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:8;s:4:\"year\";i:2025;s:15:\"available_dates\";a:21:{i:0;s:10:\"2025-08-01\";i:1;s:10:\"2025-08-04\";i:2;s:10:\"2025-08-05\";i:3;s:10:\"2025-08-06\";i:4;s:10:\"2025-08-07\";i:5;s:10:\"2025-08-08\";i:6;s:10:\"2025-08-11\";i:7;s:10:\"2025-08-12\";i:8;s:10:\"2025-08-13\";i:9;s:10:\"2025-08-14\";i:10;s:10:\"2025-08-15\";i:11;s:10:\"2025-08-18\";i:12;s:10:\"2025-08-19\";i:13;s:10:\"2025-08-20\";i:14;s:10:\"2025-08-21\";i:15;s:10:\"2025-08-22\";i:16;s:10:\"2025-08-25\";i:17;s:10:\"2025-08-26\";i:18;s:10:\"2025-08-27\";i:19;s:10:\"2025-08-28\";i:20;s:10:\"2025-08-29\";}s:17:\"unavailable_dates\";a:10:{i:0;s:10:\"2025-08-02\";i:1;s:10:\"2025-08-03\";i:2;s:10:\"2025-08-09\";i:3;s:10:\"2025-08-10\";i:4;s:10:\"2025-08-16\";i:5;s:10:\"2025-08-17\";i:6;s:10:\"2025-08-23\";i:7;s:10:\"2025-08-24\";i:8;s:10:\"2025-08-30\";i:9;s:10:\"2025-08-31\";}}', 1746606307),
('lapor_mas_wapres_cache_date_availability_2025_9', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:9;s:4:\"year\";i:2025;s:15:\"available_dates\";a:22:{i:0;s:10:\"2025-09-01\";i:1;s:10:\"2025-09-02\";i:2;s:10:\"2025-09-03\";i:3;s:10:\"2025-09-04\";i:4;s:10:\"2025-09-05\";i:5;s:10:\"2025-09-08\";i:6;s:10:\"2025-09-09\";i:7;s:10:\"2025-09-10\";i:8;s:10:\"2025-09-11\";i:9;s:10:\"2025-09-12\";i:10;s:10:\"2025-09-15\";i:11;s:10:\"2025-09-16\";i:12;s:10:\"2025-09-17\";i:13;s:10:\"2025-09-18\";i:14;s:10:\"2025-09-19\";i:15;s:10:\"2025-09-22\";i:16;s:10:\"2025-09-23\";i:17;s:10:\"2025-09-24\";i:18;s:10:\"2025-09-25\";i:19;s:10:\"2025-09-26\";i:20;s:10:\"2025-09-29\";i:21;s:10:\"2025-09-30\";}s:17:\"unavailable_dates\";a:8:{i:0;s:10:\"2025-09-06\";i:1;s:10:\"2025-09-07\";i:2;s:10:\"2025-09-13\";i:3;s:10:\"2025-09-14\";i:4;s:10:\"2025-09-20\";i:5;s:10:\"2025-09-21\";i:6;s:10:\"2025-09-27\";i:7;s:10:\"2025-09-28\";}}', 1746606308),
('lapor_mas_wapres_cache_date_availability_2026_1', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:1;s:4:\"year\";i:2026;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:31:{i:0;s:10:\"2026-01-01\";i:1;s:10:\"2026-01-02\";i:2;s:10:\"2026-01-03\";i:3;s:10:\"2026-01-04\";i:4;s:10:\"2026-01-05\";i:5;s:10:\"2026-01-06\";i:6;s:10:\"2026-01-07\";i:7;s:10:\"2026-01-08\";i:8;s:10:\"2026-01-09\";i:9;s:10:\"2026-01-10\";i:10;s:10:\"2026-01-11\";i:11;s:10:\"2026-01-12\";i:12;s:10:\"2026-01-13\";i:13;s:10:\"2026-01-14\";i:14;s:10:\"2026-01-15\";i:15;s:10:\"2026-01-16\";i:16;s:10:\"2026-01-17\";i:17;s:10:\"2026-01-18\";i:18;s:10:\"2026-01-19\";i:19;s:10:\"2026-01-20\";i:20;s:10:\"2026-01-21\";i:21;s:10:\"2026-01-22\";i:22;s:10:\"2026-01-23\";i:23;s:10:\"2026-01-24\";i:24;s:10:\"2026-01-25\";i:25;s:10:\"2026-01-26\";i:26;s:10:\"2026-01-27\";i:27;s:10:\"2026-01-28\";i:28;s:10:\"2026-01-29\";i:29;s:10:\"2026-01-30\";i:30;s:10:\"2026-01-31\";}}', 1746532252),
('lapor_mas_wapres_cache_date_availability_2026_10', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:10;s:4:\"year\";i:2026;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:31:{i:0;s:10:\"2026-10-01\";i:1;s:10:\"2026-10-02\";i:2;s:10:\"2026-10-03\";i:3;s:10:\"2026-10-04\";i:4;s:10:\"2026-10-05\";i:5;s:10:\"2026-10-06\";i:6;s:10:\"2026-10-07\";i:7;s:10:\"2026-10-08\";i:8;s:10:\"2026-10-09\";i:9;s:10:\"2026-10-10\";i:10;s:10:\"2026-10-11\";i:11;s:10:\"2026-10-12\";i:12;s:10:\"2026-10-13\";i:13;s:10:\"2026-10-14\";i:14;s:10:\"2026-10-15\";i:15;s:10:\"2026-10-16\";i:16;s:10:\"2026-10-17\";i:17;s:10:\"2026-10-18\";i:18;s:10:\"2026-10-19\";i:19;s:10:\"2026-10-20\";i:20;s:10:\"2026-10-21\";i:21;s:10:\"2026-10-22\";i:22;s:10:\"2026-10-23\";i:23;s:10:\"2026-10-24\";i:24;s:10:\"2026-10-25\";i:25;s:10:\"2026-10-26\";i:26;s:10:\"2026-10-27\";i:27;s:10:\"2026-10-28\";i:28;s:10:\"2026-10-29\";i:29;s:10:\"2026-10-30\";i:30;s:10:\"2026-10-31\";}}', 1746532256),
('lapor_mas_wapres_cache_date_availability_2026_2', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:2;s:4:\"year\";i:2026;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:28:{i:0;s:10:\"2026-02-01\";i:1;s:10:\"2026-02-02\";i:2;s:10:\"2026-02-03\";i:3;s:10:\"2026-02-04\";i:4;s:10:\"2026-02-05\";i:5;s:10:\"2026-02-06\";i:6;s:10:\"2026-02-07\";i:7;s:10:\"2026-02-08\";i:8;s:10:\"2026-02-09\";i:9;s:10:\"2026-02-10\";i:10;s:10:\"2026-02-11\";i:11;s:10:\"2026-02-12\";i:12;s:10:\"2026-02-13\";i:13;s:10:\"2026-02-14\";i:14;s:10:\"2026-02-15\";i:15;s:10:\"2026-02-16\";i:16;s:10:\"2026-02-17\";i:17;s:10:\"2026-02-18\";i:18;s:10:\"2026-02-19\";i:19;s:10:\"2026-02-20\";i:20;s:10:\"2026-02-21\";i:21;s:10:\"2026-02-22\";i:22;s:10:\"2026-02-23\";i:23;s:10:\"2026-02-24\";i:24;s:10:\"2026-02-25\";i:25;s:10:\"2026-02-26\";i:26;s:10:\"2026-02-27\";i:27;s:10:\"2026-02-28\";}}', 1746532252),
('lapor_mas_wapres_cache_date_availability_2026_3', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:3;s:4:\"year\";i:2026;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:31:{i:0;s:10:\"2026-03-01\";i:1;s:10:\"2026-03-02\";i:2;s:10:\"2026-03-03\";i:3;s:10:\"2026-03-04\";i:4;s:10:\"2026-03-05\";i:5;s:10:\"2026-03-06\";i:6;s:10:\"2026-03-07\";i:7;s:10:\"2026-03-08\";i:8;s:10:\"2026-03-09\";i:9;s:10:\"2026-03-10\";i:10;s:10:\"2026-03-11\";i:11;s:10:\"2026-03-12\";i:12;s:10:\"2026-03-13\";i:13;s:10:\"2026-03-14\";i:14;s:10:\"2026-03-15\";i:15;s:10:\"2026-03-16\";i:16;s:10:\"2026-03-17\";i:17;s:10:\"2026-03-18\";i:18;s:10:\"2026-03-19\";i:19;s:10:\"2026-03-20\";i:20;s:10:\"2026-03-21\";i:21;s:10:\"2026-03-22\";i:22;s:10:\"2026-03-23\";i:23;s:10:\"2026-03-24\";i:24;s:10:\"2026-03-25\";i:25;s:10:\"2026-03-26\";i:26;s:10:\"2026-03-27\";i:27;s:10:\"2026-03-28\";i:28;s:10:\"2026-03-29\";i:29;s:10:\"2026-03-30\";i:30;s:10:\"2026-03-31\";}}', 1746532252),
('lapor_mas_wapres_cache_date_availability_2026_4', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:4;s:4:\"year\";i:2026;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:30:{i:0;s:10:\"2026-04-01\";i:1;s:10:\"2026-04-02\";i:2;s:10:\"2026-04-03\";i:3;s:10:\"2026-04-04\";i:4;s:10:\"2026-04-05\";i:5;s:10:\"2026-04-06\";i:6;s:10:\"2026-04-07\";i:7;s:10:\"2026-04-08\";i:8;s:10:\"2026-04-09\";i:9;s:10:\"2026-04-10\";i:10;s:10:\"2026-04-11\";i:11;s:10:\"2026-04-12\";i:12;s:10:\"2026-04-13\";i:13;s:10:\"2026-04-14\";i:14;s:10:\"2026-04-15\";i:15;s:10:\"2026-04-16\";i:16;s:10:\"2026-04-17\";i:17;s:10:\"2026-04-18\";i:18;s:10:\"2026-04-19\";i:19;s:10:\"2026-04-20\";i:20;s:10:\"2026-04-21\";i:21;s:10:\"2026-04-22\";i:22;s:10:\"2026-04-23\";i:23;s:10:\"2026-04-24\";i:24;s:10:\"2026-04-25\";i:25;s:10:\"2026-04-26\";i:26;s:10:\"2026-04-27\";i:27;s:10:\"2026-04-28\";i:28;s:10:\"2026-04-29\";i:29;s:10:\"2026-04-30\";}}', 1746532253),
('lapor_mas_wapres_cache_date_availability_2026_5', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:5;s:4:\"year\";i:2026;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:31:{i:0;s:10:\"2026-05-01\";i:1;s:10:\"2026-05-02\";i:2;s:10:\"2026-05-03\";i:3;s:10:\"2026-05-04\";i:4;s:10:\"2026-05-05\";i:5;s:10:\"2026-05-06\";i:6;s:10:\"2026-05-07\";i:7;s:10:\"2026-05-08\";i:8;s:10:\"2026-05-09\";i:9;s:10:\"2026-05-10\";i:10;s:10:\"2026-05-11\";i:11;s:10:\"2026-05-12\";i:12;s:10:\"2026-05-13\";i:13;s:10:\"2026-05-14\";i:14;s:10:\"2026-05-15\";i:15;s:10:\"2026-05-16\";i:16;s:10:\"2026-05-17\";i:17;s:10:\"2026-05-18\";i:18;s:10:\"2026-05-19\";i:19;s:10:\"2026-05-20\";i:20;s:10:\"2026-05-21\";i:21;s:10:\"2026-05-22\";i:22;s:10:\"2026-05-23\";i:23;s:10:\"2026-05-24\";i:24;s:10:\"2026-05-25\";i:25;s:10:\"2026-05-26\";i:26;s:10:\"2026-05-27\";i:27;s:10:\"2026-05-28\";i:28;s:10:\"2026-05-29\";i:29;s:10:\"2026-05-30\";i:30;s:10:\"2026-05-31\";}}', 1746532253),
('lapor_mas_wapres_cache_date_availability_2026_6', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:6;s:4:\"year\";i:2026;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:30:{i:0;s:10:\"2026-06-01\";i:1;s:10:\"2026-06-02\";i:2;s:10:\"2026-06-03\";i:3;s:10:\"2026-06-04\";i:4;s:10:\"2026-06-05\";i:5;s:10:\"2026-06-06\";i:6;s:10:\"2026-06-07\";i:7;s:10:\"2026-06-08\";i:8;s:10:\"2026-06-09\";i:9;s:10:\"2026-06-10\";i:10;s:10:\"2026-06-11\";i:11;s:10:\"2026-06-12\";i:12;s:10:\"2026-06-13\";i:13;s:10:\"2026-06-14\";i:14;s:10:\"2026-06-15\";i:15;s:10:\"2026-06-16\";i:16;s:10:\"2026-06-17\";i:17;s:10:\"2026-06-18\";i:18;s:10:\"2026-06-19\";i:19;s:10:\"2026-06-20\";i:20;s:10:\"2026-06-21\";i:21;s:10:\"2026-06-22\";i:22;s:10:\"2026-06-23\";i:23;s:10:\"2026-06-24\";i:24;s:10:\"2026-06-25\";i:25;s:10:\"2026-06-26\";i:26;s:10:\"2026-06-27\";i:27;s:10:\"2026-06-28\";i:28;s:10:\"2026-06-29\";i:29;s:10:\"2026-06-30\";}}', 1746532253),
('lapor_mas_wapres_cache_date_availability_2026_7', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:7;s:4:\"year\";i:2026;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:31:{i:0;s:10:\"2026-07-01\";i:1;s:10:\"2026-07-02\";i:2;s:10:\"2026-07-03\";i:3;s:10:\"2026-07-04\";i:4;s:10:\"2026-07-05\";i:5;s:10:\"2026-07-06\";i:6;s:10:\"2026-07-07\";i:7;s:10:\"2026-07-08\";i:8;s:10:\"2026-07-09\";i:9;s:10:\"2026-07-10\";i:10;s:10:\"2026-07-11\";i:11;s:10:\"2026-07-12\";i:12;s:10:\"2026-07-13\";i:13;s:10:\"2026-07-14\";i:14;s:10:\"2026-07-15\";i:15;s:10:\"2026-07-16\";i:16;s:10:\"2026-07-17\";i:17;s:10:\"2026-07-18\";i:18;s:10:\"2026-07-19\";i:19;s:10:\"2026-07-20\";i:20;s:10:\"2026-07-21\";i:21;s:10:\"2026-07-22\";i:22;s:10:\"2026-07-23\";i:23;s:10:\"2026-07-24\";i:24;s:10:\"2026-07-25\";i:25;s:10:\"2026-07-26\";i:26;s:10:\"2026-07-27\";i:27;s:10:\"2026-07-28\";i:28;s:10:\"2026-07-29\";i:29;s:10:\"2026-07-30\";i:30;s:10:\"2026-07-31\";}}', 1746532254),
('lapor_mas_wapres_cache_date_availability_2026_8', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:8;s:4:\"year\";i:2026;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:31:{i:0;s:10:\"2026-08-01\";i:1;s:10:\"2026-08-02\";i:2;s:10:\"2026-08-03\";i:3;s:10:\"2026-08-04\";i:4;s:10:\"2026-08-05\";i:5;s:10:\"2026-08-06\";i:6;s:10:\"2026-08-07\";i:7;s:10:\"2026-08-08\";i:8;s:10:\"2026-08-09\";i:9;s:10:\"2026-08-10\";i:10;s:10:\"2026-08-11\";i:11;s:10:\"2026-08-12\";i:12;s:10:\"2026-08-13\";i:13;s:10:\"2026-08-14\";i:14;s:10:\"2026-08-15\";i:15;s:10:\"2026-08-16\";i:16;s:10:\"2026-08-17\";i:17;s:10:\"2026-08-18\";i:18;s:10:\"2026-08-19\";i:19;s:10:\"2026-08-20\";i:20;s:10:\"2026-08-21\";i:21;s:10:\"2026-08-22\";i:22;s:10:\"2026-08-23\";i:23;s:10:\"2026-08-24\";i:24;s:10:\"2026-08-25\";i:25;s:10:\"2026-08-26\";i:26;s:10:\"2026-08-27\";i:27;s:10:\"2026-08-28\";i:28;s:10:\"2026-08-29\";i:29;s:10:\"2026-08-30\";i:30;s:10:\"2026-08-31\";}}', 1746532256),
('lapor_mas_wapres_cache_date_availability_2026_9', 'a:5:{s:7:\"success\";b:1;s:5:\"month\";i:9;s:4:\"year\";i:2026;s:15:\"available_dates\";a:0:{}s:17:\"unavailable_dates\";a:30:{i:0;s:10:\"2026-09-01\";i:1;s:10:\"2026-09-02\";i:2;s:10:\"2026-09-03\";i:3;s:10:\"2026-09-04\";i:4;s:10:\"2026-09-05\";i:5;s:10:\"2026-09-06\";i:6;s:10:\"2026-09-07\";i:7;s:10:\"2026-09-08\";i:8;s:10:\"2026-09-09\";i:9;s:10:\"2026-09-10\";i:10;s:10:\"2026-09-11\";i:11;s:10:\"2026-09-12\";i:12;s:10:\"2026-09-13\";i:13;s:10:\"2026-09-14\";i:14;s:10:\"2026-09-15\";i:15;s:10:\"2026-09-16\";i:16;s:10:\"2026-09-17\";i:17;s:10:\"2026-09-18\";i:18;s:10:\"2026-09-19\";i:19;s:10:\"2026-09-20\";i:20;s:10:\"2026-09-21\";i:21;s:10:\"2026-09-22\";i:22;s:10:\"2026-09-23\";i:23;s:10:\"2026-09-24\";i:24;s:10:\"2026-09-25\";i:25;s:10:\"2026-09-26\";i:26;s:10:\"2026-09-27\";i:27;s:10:\"2026-09-28\";i:28;s:10:\"2026-09-29\";i:29;s:10:\"2026-09-30\";}}', 1746532256);

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

--
-- Struktur dari tabel `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `owner` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `customer`
--

CREATE TABLE `customer` (
  `id` bigint(20) NOT NULL DEFAULT 0,
  `nomorantrian` varchar(10) NOT NULL,
  `waktudatang` datetime NOT NULL,
  `callid` tinyint(3) NOT NULL DEFAULT 0,
  `id_online` bigint(20) NOT NULL DEFAULT 0,
  `booking_code` varchar(255) DEFAULT '-',
  `name` varchar(50) DEFAULT NULL,
  `gender` enum('L','P') NOT NULL DEFAULT 'L',
  `nik` varchar(16) DEFAULT NULL,
  `no_kk` varchar(16) DEFAULT NULL '',
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `topic` varchar(255) DEFAULT NULL,
  `priority` tinyint(3) NOT NULL DEFAULT 0,
  `pendamping` varchar(255) DEFAULT NULL,
  `ktp_image` longtext DEFAULT NULL,
  `loket` tinyint(3) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Struktur dari tabel `failed_jobs`
--

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

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

--
-- Struktur dari tabel `holidays`
--

CREATE TABLE `holidays` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `date` date NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `description` varchar(255) 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;

--
-- Dumping data untuk tabel `holidays`
--

INSERT INTO `holidays` (`id`, `date`, `start_date`, `end_date`, `description`, `created_at`, `updated_at`) VALUES
(1, '2025-03-28', '2025-03-28', '2025-03-28', 'haro raya', '2025-03-26 04:33:37', '2025-03-26 04:33:37');

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

--
-- Struktur dari tabel `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `options` mediumtext COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Struktur dari tabel `limitantrian`
--

CREATE TABLE `limitantrian` (
  `online` int(11) NOT NULL DEFAULT 500,
  `lokal` int(11) NOT NULL DEFAULT 500
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data untuk tabel `limitantrian`
--

INSERT INTO `limitantrian` (`online`, `lokal`) VALUES
(500, 500),
(500, 500);

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

--
-- Struktur dari tabel `migrations`
--

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

--
-- Dumping data untuk tabel `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2024_11_20_120613_create_registrations_table', 1),
(5, '2024_11_20_121937_create_admins_table', 1),
(6, '2024_11_20_133853_create_settings_table', 1),
(7, '2024_11_20_143831_update_registrations_table_nullable_email', 1),
(8, '2024_11_20_152037_create_holidays_table', 1),
(9, '2024_11_20_170204_add_max_date_to_settings_table', 1),
(10, '2024_12_04_101606_create_quotas_table', 1),
(11, '2024_03_18_155400_add_gender_and_kk_to_registrations', 2),
(12, '2025_04_16_204410_modify_ktp_image_column', 3);

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

--
-- Struktur dari tabel `paramdisplaykecilcounter`
--

CREATE TABLE `paramdisplaykecilcounter` (
  `namafont` varchar(50) NOT NULL DEFAULT '',
  `jenisfont` int(11) NOT NULL DEFAULT 0,
  `ukuranfont` int(11) NOT NULL DEFAULT 0,
  `warnafont` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data untuk tabel `paramdisplaykecilcounter`
--

INSERT INTO `paramdisplaykecilcounter` (`namafont`, `jenisfont`, `ukuranfont`, `warnafont`) VALUES
('Arial', 1, 20, '0,0,0'),
('Arial', 1, 20, '0,0,0');

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

--
-- Struktur dari tabel `paramdisplaykecilnomor`
--

CREATE TABLE `paramdisplaykecilnomor` (
  `namafont` varchar(50) DEFAULT NULL,
  `jenisfont` int(11) NOT NULL DEFAULT 0,
  `ukuranfont` int(11) NOT NULL DEFAULT 0,
  `warnafont` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data untuk tabel `paramdisplaykecilnomor`
--

INSERT INTO `paramdisplaykecilnomor` (`namafont`, `jenisfont`, `ukuranfont`, `warnafont`) VALUES
('Arial', 1, 35, '0,0,0'),
('Arial', 1, 35, '0,0,0');

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

--
-- Struktur dari tabel `paramdisplayutamacounter`
--

CREATE TABLE `paramdisplayutamacounter` (
  `namafont` varchar(50) DEFAULT NULL,
  `jenisfont` int(11) DEFAULT NULL,
  `ukuranfont` int(11) DEFAULT NULL,
  `warnafont` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data untuk tabel `paramdisplayutamacounter`
--

INSERT INTO `paramdisplayutamacounter` (`namafont`, `jenisfont`, `ukuranfont`, `warnafont`) VALUES
('Arial', 1, 48, '0,0,0'),
('Arial', 1, 48, '0,0,0');

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

--
-- Struktur dari tabel `paramdisplayutamanomor`
--

CREATE TABLE `paramdisplayutamanomor` (
  `namafont` varchar(50) DEFAULT NULL,
  `jenisfont` int(11) NOT NULL DEFAULT 0,
  `ukuranfont` int(11) NOT NULL DEFAULT 0,
  `warnafont` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data untuk tabel `paramdisplayutamanomor`
--

INSERT INTO `paramdisplayutamanomor` (`namafont`, `jenisfont`, `ukuranfont`, `warnafont`) VALUES
('Arial', 1, 85, '0,0,0'),
('Arial', 1, 85, '0,0,0');

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

--
-- Struktur dari tabel `paramjam`
--

CREATE TABLE `paramjam` (
  `namafont` varchar(50) NOT NULL DEFAULT '',
  `jenisfont` int(11) NOT NULL DEFAULT 0,
  `ukuranfont` int(11) NOT NULL DEFAULT 0,
  `warnafont` varchar(50) NOT NULL DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data untuk tabel `paramjam`
--

INSERT INTO `paramjam` (`namafont`, `jenisfont`, `ukuranfont`, `warnafont`) VALUES
('Calibri', 1, 36, '0,0,0'),
('Calibri', 1, 36, '0,0,0');

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

--
-- Struktur dari tabel `paramscrolltext`
--

CREATE TABLE `paramscrolltext` (
  `namafont` varchar(50) NOT NULL DEFAULT '',
  `jenisfont` int(11) NOT NULL DEFAULT 0,
  `ukuranfont` int(11) NOT NULL DEFAULT 0,
  `warnafont` varchar(50) NOT NULL DEFAULT '',
  `textgap` int(11) NOT NULL DEFAULT 0,
  `delay` int(11) DEFAULT NULL,
  `speed` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data untuk tabel `paramscrolltext`
--

INSERT INTO `paramscrolltext` (`namafont`, `jenisfont`, `ukuranfont`, `warnafont`, `textgap`, `delay`, `speed`, `type`) VALUES
('Arial', 1, 36, '255,255,255', 25, 3907, 5, 1),
('Arial', 1, 36, '255,255,255', 25, 3907, 5, 1);

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

--
-- Struktur dari tabel `paramsound`
--

CREATE TABLE `paramsound` (
  `volumevideo` int(11) DEFAULT NULL,
  `volumesound` int(11) DEFAULT NULL,
  `sound` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data untuk tabel `paramsound`
--

INSERT INTO `paramsound` (`volumevideo`, `volumesound`, `sound`) VALUES
(50, 5, 0),
(50, 5, 0);

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

--
-- Struktur dari tabel `registrations`
--

CREATE TABLE `registrations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `booking_code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `gender` enum('L','P') COLLATE utf8mb4_unicode_ci NOT NULL,
  `nik` varchar(16) COLLATE utf8mb4_unicode_ci NOT NULL,
  `no_kk` varchar(16) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `topic` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `priority` tinyint(1) NOT NULL DEFAULT 0,
  `pendamping` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ktp_image` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `visit_date` date NOT NULL,
  `visit_time` varchar(255) 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;

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

--
-- Struktur dari tabel `scrolltext`
--

CREATE TABLE `scrolltext` (
  `urutan` int(11) DEFAULT NULL,
  `isitext` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data untuk tabel `scrolltext`
--

INSERT INTO `scrolltext` (`urutan`, `isitext`) VALUES
(1, 'Selamat Datang'),
(2, 'Silahkan Menunggu Nomor Anda Dipanggil'),
(1, 'Selamat Datang'),
(2, 'Silahkan Menunggu Nomor Anda Dipanggil');

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

--
-- Struktur dari tabel `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_agent` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('9o4kGWbJtBdLSZcdmet1qcYkX2tWpTkiDAd3FDme', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36 Edg/136.0.0.0', 'YTozOntzOjY6Il90b2tlbiI7czo0MDoiOFVSQVlMb1JNaExHeXZoYlM3enFQb1RUZVNzMGZwc3ZlM0tkTXFHYiI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6ODk6Imh0dHA6Ly9sb2NhbGhvc3Q6ODAwMC9jaGVjay1xdW90YXMvMjAyNS0wOC0wMT90aW1lcz0wOCUzQTAwJTJDMDklM0EwMCUyQzEwJTNBMDAlMkMxMSUzQTAwIjt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', 1746584710),
('mwhTszsIT5MdCkgIGrl9JyySKhATYKFKQ66frrPU', NULL, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/136.0.0.0 Safari/537.36 Edg/136.0.0.0', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiNjB1aDd6MTU5ZHdvNGZmUDBjWUcxS1dsVGpMY2pleE1FSWd1SmUwaCI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzY6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9nZXQtdGltZS1zbG90cyI7fXM6NjoiX2ZsYXNoIjthOjI6e3M6Mzoib2xkIjthOjA6e31zOjM6Im5ldyI7YTowOnt9fXM6NTI6ImxvZ2luX2FkbWluXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1746585536);

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

--
-- Struktur dari tabel `settings`
--

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `max_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `settings`
--

INSERT INTO `settings` (`id`, `key`, `value`, `created_at`, `updated_at`, `max_date`) VALUES
(1, 'registration_start_date', '2025-08-01', NULL, '2025-05-06 04:17:56', NULL),
(2, 'registration_end_date', '2025-12-30', NULL, '2025-05-06 04:03:52', NULL);

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

--
-- Struktur dari tabel `time_slots`
--

CREATE TABLE `time_slots` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `time` varchar(255) NOT NULL,
  `quota` int(11) DEFAULT 15,
  `is_active` tinyint(1) DEFAULT 1,
  `label` varchar(255) DEFAULT NULL,
  `display_order` int(11) DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `time_slots`
--

INSERT INTO `time_slots` (`id`, `time`, `quota`, `is_active`, `label`, `display_order`, `created_at`, `updated_at`) VALUES
(2, '09:00', 14, 1, 'pagi', 1, '2025-04-16 04:17:18', '2025-05-06 05:25:01'),
(3, '10:00', 14, 1, 'Siang', 2, '2025-04-25 02:11:36', '2025-05-06 05:25:01'),
(4, '11:00', 14, 1, 'siang', 3, '2025-04-25 02:11:56', '2025-05-06 05:25:01'),
(5, '08:00', 14, 1, 'pagi', 0, '2025-05-05 09:09:20', '2025-05-06 05:25:01');

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

--
-- Struktur dari tabel `transaksi`
--

CREATE TABLE `transaksi` (
  `id` bigint(20) NOT NULL DEFAULT 0,
  `nomorantrian` varchar(10) NOT NULL,
  `waktudatang` datetime NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `id_online` bigint(20) NOT NULL DEFAULT 0,
  `booking_code` varchar(255) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `gender` enum('L','P') NOT NULL DEFAULT 'L',
  `nik` varchar(16) DEFAULT NULL,
  `no_kk` varchar(16) DEFAULT NULL '',
  `phone` varchar(20) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `address` text DEFAULT NULL,
  `topic` varchar(255) DEFAULT NULL,
  `priority` tinyint(4) NOT NULL DEFAULT 0,
  `pendamping` varchar(255) DEFAULT NULL,
  `ktp_image` longtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

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

--
-- Struktur dari tabel `user`
--

CREATE TABLE `user` (
  `iduser` varchar(50) NOT NULL DEFAULT '',
  `password` varchar(50) DEFAULT NULL,
  `level` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;

--
-- Dumping data untuk tabel `user`
--

INSERT INTO `user` (`iduser`, `password`, `level`) VALUES
('admin', '21232f297a57a5a743894a0e4a801fc3', 'Admin');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_username_unique` (`username`);

--
-- Indeks untuk tabel `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indeks untuk tabel `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

--
-- Indeks untuk tabel `customer`
--
ALTER TABLE `customer`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `holidays`
--
ALTER TABLE `holidays`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

--
-- Indeks untuk tabel `job_batches`
--
ALTER TABLE `job_batches`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `limitantrian`
--
ALTER TABLE `limitantrian`
  ADD KEY `online` (`online`);

--
-- Indeks untuk tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `registrations`
--
ALTER TABLE `registrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

--
-- Indeks untuk tabel `time_slots`
--
ALTER TABLE `time_slots`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `transaksi`
--
ALTER TABLE `transaksi`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `user`
--
ALTER TABLE `user`
  ADD PRIMARY KEY (`iduser`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `admins`
--
ALTER TABLE `admins`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT untuk tabel `holidays`
--
ALTER TABLE `holidays`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT untuk tabel `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT untuk tabel `registrations`
--
ALTER TABLE `registrations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `time_slots`
--
ALTER TABLE `time_slots`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
COMMIT;

