-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 02 Agu 2024 pada 08.31
-- Versi server: 10.4.28-MariaDB
-- Versi PHP: 8.2.4

START TRANSACTION;



--
-- Database: `ramp_check_db`
--

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

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

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

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

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

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

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

--
-- Struktur dari tabel `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;

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

--
-- Struktur dari tabel `forms`
--

CREATE TABLE `forms` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pemohon_instansi` varchar(255) NOT NULL,
  `alamat` varchar(255) NOT NULL,
  `kecamatan` varchar(255) NOT NULL,
  `penanggung_jawab` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `no_hp_wa` varchar(255) NOT NULL,
  `tgl_rencana_keberangkatan` date NOT NULL,
  `jumlah_kendaraan` int(11) NOT NULL,
  `nama_po` varchar(255) NOT NULL,
  `lokasi_ramp_check` varchar(255) NOT NULL,
  `keterangan` text DEFAULT NULL,
  `file_lampiran` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `application_number` varchar(255) DEFAULT NULL,
  `no_pengajuan` varchar(255) DEFAULT NULL,
  `status` enum('SEDANG DIPROSES','SUDAH DISETUJUI') NOT NULL DEFAULT 'SEDANG DIPROSES'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `forms`
--

INSERT INTO `forms` (`id`, `pemohon_instansi`, `alamat`, `kecamatan`, `penanggung_jawab`, `email`, `no_hp_wa`, `tgl_rencana_keberangkatan`, `jumlah_kendaraan`, `nama_po`, `lokasi_ramp_check`, `keterangan`, `file_lampiran`, `created_at`, `updated_at`, `application_number`, `no_pengajuan`, `status`) VALUES
(1, 'Zay', 'uyikykiykij', 'titititit', 'ititititit', 'itoitiotoiTO@gmail.com', '236521896415', '2024-07-30', 1, 'adwads', 'awdasdawf', 'awdawdasfawdfafcs', 'lampiran/XUCUmqIHEmgiwSWnqTOhOgS7P2HvUCFUbv3CVOBU.pdf', '2024-07-29 22:30:47', '2024-07-29 22:30:47', NULL, NULL, 'SEDANG DIPROSES'),
(2, 'daadsada', 'asdsadsa', 'dsadasdas', 'dasdasdsa', 'jankerss.25@gmail.com', '624589494949', '2024-07-31', 2, 'awdasdawdawd', 'awdasdawdawd', 'sadasdasda', 'lampiran/pK7D6QOwvPDwQgGczxv4rhUHsAbT8gsa6VWRJogN.pdf', '2024-07-30 18:44:32', '2024-07-30 18:44:32', NULL, NULL, 'SEDANG DIPROSES'),
(3, 'Zayyan2', 'ajwdoajdopada', 'wdaawdawd', 'awdaasxa', 'zayyan@example.com', '6249846161', '2024-07-31', 2, 'awdasdawdawd', 'dsadaszxzc', 'dasadada', 'lampiran/AKTAMNXkfvsy7ZBg0FPIxiY8TCXw1Rx7Ij4gppt9.pdf', '2024-07-30 18:46:07', '2024-07-30 18:46:07', NULL, NULL, 'SEDANG DIPROSES'),
(4, 'Zayyan2333', 'asdada', 'asdsada', 'asdasdsa', 'jankerss.25@gmail.com', '6258458415', '2024-07-31', 4, 'asdad', 'adasda', 'dsadsa', 'lampiran/lOUvQYzuY4HlCkllMAd9VclVzbGiiSEXAOaUU2cq.pdf', '2024-07-30 20:00:36', '2024-07-30 20:00:36', NULL, NULL, 'SEDANG DIPROSES'),
(5, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/DL9rkotnPvrkSRjsjJH6HNwXKwlw2eRz1wkPENBw.pdf', '2024-07-30 21:13:07', '2024-07-30 21:13:07', NULL, NULL, 'SEDANG DIPROSES'),
(6, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/bgzaJd2qQ3MZhUAbW9KSnzwCv5UtmvDTEdLixL77.pdf', '2024-07-30 21:14:52', '2024-07-30 21:14:52', NULL, NULL, 'SEDANG DIPROSES'),
(7, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/MPYHmjZQUga6qHXVGwDFNZQOCbn0J7v8XOIvSYNA.pdf', '2024-07-30 21:15:01', '2024-07-30 21:15:01', NULL, NULL, 'SEDANG DIPROSES'),
(8, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/3Ih8POff00mhbqh3EHbePMMD7QDnPWzTEpQIEHr5.pdf', '2024-07-30 21:15:47', '2024-07-30 21:15:47', NULL, NULL, 'SEDANG DIPROSES'),
(9, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/ZJLYEFybclBITrznkNUEdSMaDRDyVe8sLkihZmaL.pdf', '2024-07-30 21:16:08', '2024-07-30 21:16:08', NULL, NULL, 'SEDANG DIPROSES'),
(10, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/t0fNx5qmWFYEwBFypeAXGK9jIfGYoM55rWLidzZE.pdf', '2024-07-30 21:17:38', '2024-07-30 21:17:38', NULL, NULL, 'SEDANG DIPROSES'),
(11, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/tNTuoiAB8ZKNTfFvrW5qrWM3G88rqUXj7C71G4Hy.pdf', '2024-07-30 21:17:52', '2024-07-30 21:17:52', NULL, NULL, 'SEDANG DIPROSES'),
(12, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/VjASCzyeT19NILDzB0v86wHP8DQ7fCYihE2xkmRk.pdf', '2024-07-30 21:17:57', '2024-07-30 21:17:57', NULL, NULL, 'SEDANG DIPROSES'),
(13, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/V9sxVx1sU2iGioWkzW9Xwn3ls8rxXmS7LpUp8vHJ.pdf', '2024-07-30 21:18:12', '2024-07-30 21:18:12', NULL, NULL, 'SEDANG DIPROSES'),
(14, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/lxpbIqgjWeDBS0IoyYUrzDjN7bmckJKgJHZk87pT.pdf', '2024-07-30 21:18:24', '2024-07-30 21:18:24', NULL, NULL, 'SEDANG DIPROSES'),
(15, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/c384RXoVMVLtmbSDFr7RsTZoIBZMnQztu5ShCYf4.pdf', '2024-07-30 21:19:18', '2024-07-30 21:19:18', NULL, NULL, 'SEDANG DIPROSES'),
(16, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/eXBSo47oxJKURFEjLZB5HPffGDefdpP58mclPsKx.pdf', '2024-07-30 21:19:30', '2024-07-30 21:19:30', NULL, NULL, 'SEDANG DIPROSES'),
(17, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/Yd5nbnlfPsr4Xy0zHBmkmQjXxVV5XuMYx5KmdExK.pdf', '2024-07-30 21:19:48', '2024-07-30 21:19:48', NULL, NULL, 'SEDANG DIPROSES'),
(18, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/CXB3HcN4wZwqtzJ7T3FLoTOgClqIrj3NqA87M82U.pdf', '2024-07-30 21:19:55', '2024-07-30 21:19:55', NULL, NULL, 'SEDANG DIPROSES'),
(19, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/lauILJIBNikxlL0VNebeleTjvLRzgnaIpZsqDmWM.pdf', '2024-07-30 21:20:21', '2024-07-30 21:20:21', NULL, NULL, 'SEDANG DIPROSES'),
(20, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/b1lGccHi9u1r5MTFgi7XcoqUk3mEK33TblTv2rOX.pdf', '2024-07-30 21:20:31', '2024-07-30 21:20:31', NULL, NULL, 'SEDANG DIPROSES'),
(21, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/AGkqbdLdgxt3v7fnKo8nmRUUTPzaoJ3laQ6gwctM.pdf', '2024-07-30 21:20:47', '2024-07-30 21:20:47', NULL, NULL, 'SEDANG DIPROSES'),
(22, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/ryqUspONxzA66H5bRzcnRgXZssy1QXY3q5udAPzv.pdf', '2024-07-30 21:22:02', '2024-07-30 21:22:02', NULL, NULL, 'SEDANG DIPROSES'),
(23, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/9TV6cP9YQly3H3EIQCaey8OUVKdI1cR723oN2GKm.pdf', '2024-07-30 21:22:30', '2024-07-30 21:22:30', NULL, NULL, 'SEDANG DIPROSES'),
(24, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/v8rc8FDxGUDZnqnmln2waP8LEC5h0U3oOPc3MVpz.pdf', '2024-07-30 21:22:40', '2024-07-30 21:22:40', NULL, NULL, 'SEDANG DIPROSES'),
(25, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'jankerss.25@gmail.com', '624864242424', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/ikjMw2ELEHEeokJVGHa7U64nUrsBSF3DnqWQAlrB.pdf', '2024-07-30 21:26:18', '2024-07-30 21:26:18', NULL, NULL, 'SEDANG DIPROSES'),
(26, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'awdasdawdawd@gmail.com', '624589494949', '2024-07-31', 2, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'lampiran/9EyhnHDXKBXWkFk6EXoVw39GnQ4r5Rqmb8DYwk6j.pdf', '2024-07-30 21:27:00', '2024-07-30 21:27:00', NULL, NULL, 'SEDANG DIPROSES'),
(27, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'awdasdawdawd@gmail.com', '624589494949', '2024-07-31', 2, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'lampiran/yjCyCggPecJg4UM57HlpMsHBaZahgZ3FSHR3jU19.pdf', '2024-07-30 21:27:17', '2024-07-30 21:27:17', NULL, NULL, 'SEDANG DIPROSES'),
(28, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'awdasdawdawd@gmail.com', '624589494949', '2024-07-31', 2, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'lampiran/n7HxNoINGuKRsAgLAf60mV1M38dSktjlFHQ4NrGJ.pdf', '2024-07-30 21:27:32', '2024-07-30 21:27:32', NULL, NULL, 'SEDANG DIPROSES'),
(29, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'awdasdawdawd@gmail.com', '624589494949', '2024-07-31', 2, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'lampiran/HzfkX8O6FDIVI8mJgBIwCzOVSuJI7urjuoUqHvqI.pdf', '2024-07-30 21:28:34', '2024-07-30 21:28:34', NULL, NULL, 'SEDANG DIPROSES'),
(30, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'awdasdawdawd@gmail.com', '624589494949', '2024-07-31', 2, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'lampiran/TC3mUSWbvjTLx9hakCE4xGsq48KeQbX7oM2Yc1Ow.pdf', '2024-07-30 21:32:05', '2024-07-30 21:32:05', NULL, NULL, 'SEDANG DIPROSES'),
(31, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'awdasdawdawd@gmail.com', '624589494949', '2024-07-31', 2, 'fsafsafsa', 'fsafsafsa', 'fsafsafsa', 'lampiran/kEU4h8Sk84ViuzEJe0KDT6kjV6bEOO1lvwOEbZh2.pdf', '2024-07-30 21:32:14', '2024-07-30 21:32:14', NULL, NULL, 'SEDANG DIPROSES'),
(32, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'brilliantazayyanusa@gmail.com', '624589494949', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', NULL, '2024-07-30 21:38:43', '2024-07-30 21:38:43', NULL, NULL, 'SEDANG DIPROSES'),
(33, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'brilliantazayyanusa@gmail.com', '624589494949', '2024-07-31', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/ivlMza7Abko33o67SPlou9Lb7nru0s8PiLEO20Zq.pdf', '2024-07-30 21:39:20', '2024-07-30 21:39:20', NULL, NULL, 'SEDANG DIPROSES'),
(34, 'figo', 'figo', 'figo', 'figo', 'figo@gmail.com', '624589494949', '2024-07-31', 2, 'figo', 'figo', 'figo', 'lampiran/m4GnsJokSNLZekCLgvfEgguGdCYm8tW8fg0wLAbf.pdf', '2024-07-30 22:28:27', '2024-07-30 22:28:27', NULL, NULL, 'SEDANG DIPROSES'),
(35, 'figo', 'figo', 'figo', 'figo', 'figo@gmail.com', '624589494949', '2024-07-31', 2, 'figo', 'figo', 'figo', 'lampiran/4novihEAUdNrMcO14b6e2LZhVOYU3WEiyLogOdAE.pdf', '2024-07-30 22:32:35', '2024-07-30 22:32:35', NULL, NULL, 'SEDANG DIPROSES'),
(36, 'tesform', 'tesform', 'tesform', 'tesform', 'tesform@gmail.com', '6284176515214', '2024-08-01', 2, 'tesform', 'tesform', 'tesform', 'lampiran/HIUdFnjdNbcasWkGl5ALHTCqOcT3JinfqYbxd7CL.pdf', '2024-07-31 21:15:03', '2024-07-31 21:15:03', NULL, NULL, 'SEDANG DIPROSES'),
(37, 'tesfa233', 'tesfa2', 'tesfa2', 'tesfa2', 'tesfa2@gmail.com', '624864242424', '2024-08-01', 2, 'tesfa2', 'tesfa2', 'tesfa2', 'lampiran/mQDyYZKDsbCmYk14C6VvYNgpC0woSykXbTWlfcgz.pdf', '2024-07-31 21:29:06', '2024-07-31 22:23:08', NULL, 'PGJ-Q7IKIM4M', 'SEDANG DIPROSES'),
(38, 'pentul', 'pentul', 'pentul', 'pentul', 'pentul@mail.com', '624864242424', '2024-08-01', 1, 'pentul', 'pentul', 'pentul', 'lampiran/G5oFbVCOuKLFwzzgrOzi5hive8nJ0GSuK5DxSedi.pdf', '2024-07-31 22:25:57', '2024-07-31 22:25:57', NULL, 'PGJ-GQRKZOLQ', 'SEDANG DIPROSES'),
(39, 'pentul2', 'pentul2', 'pentul2', 'pentul2', 'pentul2@gmail.com', '624589494949', '2024-08-01', 1, 'pentul2', 'pentul2', 'pentul2', 'lampiran/YDJAWp2YWf5ugasXFIskREFgdywCLY0p5nTkNAoB.pdf', '2024-07-31 22:31:06', '2024-07-31 22:52:48', NULL, 'PGJ-HIZK5NR7', 'SUDAH DISETUJUI'),
(40, 'Zayyan2325', 'Zayyan2325', 'Zayyan2325', 'Zayyan2325', 'Zayyan2325@gmail.com', '624864242424', '2024-08-01', 1, 'Zayyan2325', 'Zayyan2325', 'Zayyan2325', 'lampiran/3R6Jq9xmF4bvGa61zqlPMVUm0m4uZG6hoW1wInUn.pdf', '2024-07-31 22:34:31', '2024-07-31 22:34:31', NULL, 'PGJ-KVKQS1RY', 'SEDANG DIPROSES'),
(41, 'Zayyan2325', 'Zayyan2325', 'Zayyan2325', 'Zayyan2325', 'Zayyan2325@gmail.com', '624864242424', '2024-08-01', 1, 'Zayyan2325', 'Zayyan2325', 'Zayyan2325', 'lampiran/3DE8nZDn2YjKwOfSfNuqDyr5U6qSUEyxxJmZ2Xpj.pdf', '2024-07-31 22:35:08', '2024-07-31 22:35:08', NULL, 'PGJ-Z32B09ST', 'SEDANG DIPROSES'),
(42, 'figo25', 'figo25', 'figo25', 'figo25', 'figo25@gmail.com', '624589494949', '2024-08-01', 2, 'figo25', 'figo25', 'figo25', 'lampiran/caQby40godxMW6RjJ7ABeYIh28ByBnjjFsZMyAj2.pdf', '2024-07-31 22:37:34', '2024-07-31 22:37:34', NULL, 'PGJ-YZRGOFHQ', 'SEDANG DIPROSES'),
(43, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd@gmail.com', '624864242424', '2024-08-01', 2, 'wadasdawdasd', 'wadasdawdasd', 'wadasdawdasd', 'lampiran/Pk3WP85NV1mBpUtfPrBdTW7LfsgFrPZ2s8TyRHbk.pdf', '2024-07-31 22:55:32', '2024-07-31 22:56:41', NULL, 'PGJ-BSLPA7BV', 'SUDAH DISETUJUI'),
(44, 'Zayyan', 'Buring Oma View', 'KedungKandang', 'Zayyan B.', 'brilliantazayyanusa@gmail.com', '624589494949', '2024-08-05', 1, 'PT ZAY', 'Malang', 'Mobil Truk', 'lampiran/R5ICgrfg3PwiXkEM0IhfDbiT1sKztMWtKlWkJKtw.pdf', '2024-08-01 23:28:55', '2024-08-01 23:30:05', NULL, 'PGJ-NOS07K3W', 'SUDAH DISETUJUI');

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

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

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext 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) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext 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 `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 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_07_30_034513_create_forms_table', 1),
(5, '2024_07_30_035959_create_admins_table', 1),
(6, '2024_07_30_052430_create_forms_table', 2),
(7, '2024_07_30_055005_add_is_admin_to_users_table', 3),
(8, '2024_08_01_034255_add_application_number_and_status_to_forms_table', 4),
(9, '2024_08_01_040053_add_status_to_forms_table', 5),
(10, '2024_08_01_042052_add_status_and_no_pengajuan_to_forms_table', 6);

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

--
-- Struktur dari tabel `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext 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
('paYV81HqVTpqYkTTSFovHLPsDx2jLHIBoFNcqXzz', 4, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/127.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiT1g3c0gxV0hPSTZYbWpCOGVGWWd5OFpjUlAwZkZnUmZUbGRGZmdmSiI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzE6Imh0dHA6Ly8xMjcuMC4wLjE6ODAwMC9kYXNoYm9hcmQiO31zOjUwOiJsb2dpbl93ZWJfNTliYTM2YWRkYzJiMmY5NDAxNTgwZjAxNGM3ZjU4ZWE0ZTMwOTg5ZCI7aTo0O30=', 1722580249);

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

--
-- Struktur dari tabel `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `users`
--

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `is_admin`) VALUES
(1, 'Figo', 'admin@example.com', NULL, 'password', NULL, '2024-07-30 06:02:19', '2024-07-30 06:02:19', 1),
(4, 'Zayyan', 'zayyanz@example.com', NULL, '$2y$12$tYmgukGG5j7DjMxENzl7lOQ0UX5WBptpzZluUa5m70La4oIWph6KK', NULL, '2024-07-30 06:08:39', '2024-07-30 19:25:46', 1);

--
-- Indexes for dumped tables
--

--
-- 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 `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `forms`
--
ALTER TABLE `forms`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `forms_application_number_unique` (`application_number`),
  ADD UNIQUE KEY `forms_no_pengajuan_unique` (`no_pengajuan`);

--
-- 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 `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- 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 `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

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

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

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

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

