-- 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;



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

--
-- 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 `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 `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;

--
-- 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`);

--
-- 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;

