-- https://www.phpmyadmin.net/
--
-- Waktu pembuatan: 20 Okt 2023 pada 10.40
-- Versi server: 10.4.27-MariaDB
-- Versi PHP: 8.2.0

START TRANSACTION;



--
-- Database: `simonew`
--

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

--
-- Struktur dari tabel `daftar_anggota_prokers`
--

CREATE TABLE `daftar_anggota_prokers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama` varchar(255) NOT NULL,
  `sie` varchar(255) NOT NULL,
  `idProker` varchar(255) 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 `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 `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, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(3, '2014_10_12_100000_create_password_resets_table', 1),
(4, '2019_08_19_000000_create_failed_jobs_table', 1),
(5, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(6, '2023_05_29_191445_membuat_kolom_role', 1),
(7, '2023_05_29_204951_menambah_kolom_tabel_users', 1),
(8, '2023_05_30_080051_create_tugasprokers_table', 1),
(9, '2023_06_05_123712_create_programkerjas_table', 1),
(10, '2023_06_07_062513_create_okis_table', 1),
(11, '2023_06_07_143312_create_daftar_anggota_prokers_table', 1);

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

--
-- Struktur dari tabel `okis`
--

CREATE TABLE `okis` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `nama` varchar(255) 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 `okis`
--

INSERT INTO `okis` (`id`, `nama`, `created_at`, `updated_at`) VALUES
(1, 'BEM Polinema', '2023-10-20 00:58:21', '2023-10-20 00:58:21'),
(2, 'DPM Polinema', '2023-10-20 00:58:21', '2023-10-20 00:58:21'),
(3, 'HIMANIA (Administrasi Niaga)', '2023-10-20 00:58:21', '2023-10-20 00:58:21'),
(4, 'HMA (Akutansi)', '2023-10-20 00:58:22', '2023-10-20 00:58:22'),
(5, 'HME (Elektro)', '2023-10-20 00:58:22', '2023-10-20 00:58:22'),
(6, 'HMM (Mesin)', '2023-10-20 00:58:22', '2023-10-20 00:58:22'),
(7, 'HMTK (Teknik Kimia)', '2023-10-20 00:58:22', '2023-10-20 00:58:22'),
(8, 'HMS (Sipil)', '2023-10-20 00:58:22', '2023-10-20 00:58:22'),
(9, 'HMTI (Teknologi Informasi)', '2023-10-20 00:58:22', '2023-10-20 00:58:22'),
(10, 'BKM', '2023-10-20 00:58:23', '2023-10-20 00:58:23'),
(11, 'RISPOL', '2023-10-20 00:58:23', '2023-10-20 00:58:23'),
(12, 'KMK St. John Polinema', '2023-10-20 00:58:23', '2023-10-20 00:58:23'),
(13, 'KOMPEN', '2023-10-20 00:58:23', '2023-10-20 00:58:23'),
(14, 'OPA Ganendra Giri', '2023-10-20 00:58:23', '2023-10-20 00:58:23'),
(15, 'PASTI Polinema', '2023-10-20 00:58:23', '2023-10-20 00:58:23'),
(16, 'Pendidikan dan Penalaran Polinema', '2023-10-20 00:58:24', '2023-10-20 00:58:24'),
(17, 'Radio PLFM', '2023-10-20 00:58:24', '2023-10-20 00:58:24'),
(18, 'SATMENWA Polinema', '2023-10-20 00:58:24', '2023-10-20 00:58:24'),
(19, 'Seni Theatrisic', '2023-10-20 00:58:24', '2023-10-20 00:58:24'),
(20, 'Talitakum Polinema', '2023-10-20 00:58:24', '2023-10-20 00:58:24'),
(21, 'UKM Olahraga Polinema', '2023-10-20 00:58:24', '2023-10-20 00:58:24'),
(22, 'USMA Polinema', '2023-10-20 00:58:24', '2023-10-20 00:58:24');

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

--
-- Struktur dari tabel `password_resets`
--

CREATE TABLE `password_resets` (
  `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 `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 `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT 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 `programkerjas`
--

CREATE TABLE `programkerjas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `namaproker` varchar(255) DEFAULT NULL,
  `bidang` varchar(255) DEFAULT NULL,
  `tempat` varchar(255) DEFAULT NULL,
  `tanggalproker` date NOT NULL,
  `namaOki` varchar(255) 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 `programkerjas`
--

INSERT INTO `programkerjas` (`id`, `namaproker`, `bidang`, `tempat`, `tanggalproker`, `namaOki`, `created_at`, `updated_at`) VALUES
(1, 'Safari Dakwah', 'Syiar', 'Jatimulyo', '2023-05-25', 'RISPOL', '2023-10-20 00:58:18', '2023-10-20 00:58:18'),
(2, 'Sholawat Rutin', 'Sholawat', 'Masjid An-Nur', '2023-05-25', 'RISPOL', '2023-10-20 00:58:19', '2023-10-20 00:58:19'),
(3, 'Firma Ceria', 'Firma', 'Fakultas Teknik', '2023-05-25', 'RISPOL', '2023-10-20 00:58:19', '2023-10-20 00:58:19'),
(4, 'Donor Darah', 'Departemen Kesehatan', 'Aula Pertamina Polinema', '2023-06-28', 'BKM', '2023-10-20 00:58:19', '2023-10-20 00:58:19'),
(5, 'Pengajian Akbar', 'Syiar', 'Masjid An-Nur Polinema', '2023-07-15', 'RISPOL', '2023-10-20 00:58:19', '2023-10-20 00:58:19'),
(6, 'Pengabdian Masyarakat', 'Departemen Humas', 'Desa Sumberrejo', '2023-09-10', 'BKM', '2023-10-20 00:58:20', '2023-10-20 00:58:20'),
(7, 'Kesehatan Masyarakat', 'Departemen Kesehatan', 'Desa Sumberrejo', '2023-09-10', 'BKM', '2023-10-20 00:58:20', '2023-10-20 00:58:20'),
(8, 'Pertolongan Pertama I', 'Departemen Kesehatan', 'Gedung Teknik Mesin Lantai 4', '2023-08-22', 'BKM', '2023-10-20 00:58:20', '2023-10-20 00:58:20'),
(9, 'Pertolongan Pertama II', 'Departemen Kesehatan', 'Gedung Teknik Mesin Lantai 4', '2023-10-29', 'BKM', '2023-10-20 00:58:20', '2023-10-20 00:58:20');

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

--
-- Struktur dari tabel `tugasprokers`
--

CREATE TABLE `tugasprokers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `namatugas` varchar(255) DEFAULT NULL,
  `sie` varchar(255) DEFAULT NULL,
  `tenggatwaktu` date NOT NULL,
  `status` varchar(255) DEFAULT 'Belum Selesai',
  `evaluasi` varchar(255) DEFAULT NULL,
  `file` varchar(255) DEFAULT NULL,
  `idProker` varchar(255) 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 `tugasprokers`
--

INSERT INTO `tugasprokers` (`id`, `namatugas`, `sie`, `tenggatwaktu`, `status`, `evaluasi`, `file`, `idProker`, `created_at`, `updated_at`) VALUES
(1, 'Membuat Materi Dakwah', 'Sie Acara', '2023-07-25', 'Belum Selesai', NULL, NULL, '1', '2023-10-20 00:58:20', '2023-10-20 00:58:20'),
(2, 'Membuat Surat Undangan OKI', 'Sie PDD', '2023-07-25', 'Belum Selesai', NULL, NULL, '1', '2023-10-20 00:58:20', '2023-10-20 00:58:20'),
(3, 'Membuat Rundown Acara', 'Sie Acara', '2023-07-25', 'Belum Selesai', NULL, NULL, '1', '2023-10-20 00:58:21', '2023-10-20 00:58:21'),
(4, 'Membuat Rundown Acara', 'Sie Acara', '2023-05-20', 'Belum Selesai', NULL, NULL, '2', '2023-10-20 00:58:21', '2023-10-20 00:58:21');

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

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

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `role` enum('admin','user') NOT NULL DEFAULT 'user',
  `nim` int(11) DEFAULT NULL,
  `prodi` varchar(255) DEFAULT NULL,
  `jurusan` varchar(255) DEFAULT 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,
  `sie` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `namaOki` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `role`, `nim`, `prodi`, `jurusan`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `sie`, `image`, `namaOki`) VALUES
(1, 'Admin', 'admin', NULL, NULL, NULL, 'admin@gmail.com', '2023-10-20 00:58:10', '$2y$10$Gd3wpqU484QPBRqQPrkdR.Y5IOMlNq1hqk1n2/CrlP0ApRL57ic7e', NULL, '2023-10-20 00:58:11', '2023-10-20 00:58:11', NULL, NULL, NULL),
(2, 'BRIAN MOHAMAD SAFIUDIN', 'user', 2141720133, 'DIV Teknik Informatika', 'Teknologi Informasi', 'brian@gmail.com', '2023-10-20 00:58:11', '$2y$10$I8MK3Wh4hfF//IPJicpmt.uEPcMQnIQnjcRQpFQ0sJRA2mXFTIhKC', NULL, '2023-10-20 00:58:11', '2023-10-20 00:58:11', 'SIE Acara', 'public/users/DoNnC2wJFdrzEGMsK2BruEMXoScmdqFQAjvt2K5q.jpg', 'RISPOL'),
(3, 'MUHAMMAD BINTANG SHOLU FIRMANSYAH', 'user', 2141720101, 'DIV Teknik Informatika', 'Teknologi Informasi', 'sholu@gmail.com', '2023-10-20 00:58:11', '$2y$10$QGSr4.BbdaFjCSzZ8emBM.X2azUZ8rErYTbJCP3ARZxuxMTcvqpEK', NULL, '2023-10-20 00:58:11', '2023-10-20 00:58:11', 'SIE PDD', 'public/users/xP0HY4AmUu4Gie5SAXerabguaYD6Lq9ThYb0zjBh.jpg', 'RISPOL'),
(4, 'TRI JAGAD ARIYANI', 'user', 2141720049, 'DIV Teknik Informatika', 'Teknologi Informasi', 'yani@gmail.com', '2023-10-20 00:58:12', '$2y$10$HtRlCoZ.Fs3DnYYvgPc7Ge2gVNP.xmGkIzDnqZsF2gJByMbgzE0W6', NULL, '2023-10-20 00:58:12', '2023-10-20 00:58:12', 'SIE Dakwah', 'public/users/bR1veiLOpq20a0zZlER5oB6SGCkT7mNA2ryGfkq9.jpg', 'RISPOL'),
(5, 'FEBRYAN RIZKI HIDAYATULLAH', 'user', 2141720059, 'DIV Teknik Informatika', 'Teknologi Informasi', 'febryan@gmail.com', '2023-10-20 00:58:12', '$2y$10$vd/522joL3EtMLXu3dH3j./F8DweqqLuPCOJkqtXWl1YIPnzxC5lq', NULL, '2023-10-20 00:58:12', '2023-10-20 00:58:12', 'SIE Media Informasi', 'public/users/e3anqh1sOEHBnrA67lPBIXQaeSamp8CZJawQLUdk.jpg', 'RISPOL'),
(6, 'FADLILA AFIDA', 'user', 2141720130, 'DIV Teknik Informatika', 'Teknologi Informasi', 'fadlila@gmail.com', '2023-10-20 00:58:12', '$2y$10$RRDCtMjGtmB6hJq.BPr9GOoW98EXyhMXAn6KHxchnmcnR62rMC066', NULL, '2023-10-20 00:58:12', '2023-10-20 00:58:12', 'SIE Kesejahteraan Sosial', 'public/users/m1ZX2MOyPW5p7AIahhb2wXXxX6LYKb1UIM5BG1Pq.jpg', 'RISPOL'),
(7, 'ANISA NURUL AZIZAH', 'user', 2141720187, 'DIV Teknik Informatika', 'Teknologi Informasi', 'anisa@gmail.com', '2023-10-20 00:58:13', '$2y$10$70WXAxd6wznbG1aVocchJev/F/aTBItqw9vlf/lt6OB0d0VHn4GGm', NULL, '2023-10-20 00:58:13', '2023-10-20 00:58:13', NULL, NULL, 'BKM'),
(8, 'MUHAMAD ELKARIM', 'user', 2141720111, 'DIV Administrasi Bisnis', 'Akutansi', 'muhamad@gmail.com', '2023-10-20 00:58:14', '$2y$10$jdsc0HsnBY2pCPHT56x8hegQCYO50WgQMBlCTtHvXO2Mr/eEiPulK', NULL, '2023-10-20 00:58:14', '2023-10-20 00:58:14', NULL, NULL, 'BKM'),
(9, 'Juniar Al Farizi', 'user', 2141720115, 'DIV Manajemen Rekayasa Konstruksi', 'Teknik Sipil', 'juniar@gmail.com', '2023-10-20 00:58:15', '$2y$10$mMGWRHRCcOXkGeJKkottaun.Dsct9JTHv6kSi8u.89vNfcAwWUZaq', NULL, '2023-10-20 00:58:15', '2023-10-20 00:58:15', NULL, NULL, 'RISPOL'),
(10, 'Aisyah Nurul Hidayah', 'user', 2141720516, 'DIII Teknik Pertambangan', 'Teknik Sipil', 'aisyahnurul@gmail.com', '2023-10-20 00:58:15', '$2y$10$nA/ZE8SnPkU0U8J4UWf0E.FVggnVu.ZeIb5BaJ3VSzkh.oDX.KBhK', NULL, '2023-10-20 00:58:15', '2023-10-20 00:58:15', NULL, NULL, 'BKM'),
(11, 'Siti Triana', 'user', 2141720557, 'DIII Teknik Pertambangan', 'Teknik Sipil', 'siti@gmail.com', '2023-10-20 00:58:16', '$2y$10$axoo0uYzW6pTCAI5kNv7.O.PV751Z6bnpa.SNJdaLclDn8tO8Tz3G', NULL, '2023-10-20 00:58:16', '2023-10-20 00:58:16', NULL, NULL, 'RISPOL'),
(12, 'Rani Putri Rahmawati', 'user', 2141720184, 'DIV Teknologi Rekayasa Konstruksi Jalan dan Jembatan', 'Akutansi', 'rani@gmail.com', '2023-10-20 00:58:16', '$2y$10$oduKvSZnAsc6Q3jkmBFFeOoxiPuynNtR49NnQ31giMDVeHL3OLrhu', NULL, '2023-10-20 00:58:16', '2023-10-20 00:58:16', NULL, NULL, 'RISPOL'),
(13, 'Ryan Dwi Prasetyo', 'user', 2141720153, 'DIV Akuntansi Manajemen', 'Akutansi', 'ryandwi@gmail.com', '2023-10-20 00:58:17', '$2y$10$Tl/YGIrHJTtwNZ8Y/Taq0.Ob5vPR35Ed2qy8BDFrrKQBrBJ2JuqEq', NULL, '2023-10-20 00:58:17', '2023-10-20 00:58:17', NULL, NULL, 'BEM Polinema'),
(14, 'Bima Sakti Ramadhan', 'user', 2141720358, 'DIII Akuntansi', 'Akutansi', 'bimasakti@gmail.com', '2023-10-20 00:58:17', '$2y$10$Xhe1kZHQADEzA61JXwJ6IO6VQFc3oD1CDkHlISpbSQOp0TxRAGPPa', NULL, '2023-10-20 00:58:17', '2023-10-20 00:58:17', NULL, NULL, 'BEM Polinema'),
(15, 'Ridwan Kamil Surya', 'user', 2141720350, 'DIII Teknik Kimia', 'Teknik Kimia', 'ridwankamil@gmail.com', '2023-10-20 00:58:17', '$2y$10$rS91HyunoZOXsGCVJMzsNuZ3rbWgHuaWucI.SwJBZYofRnhFVvkSy', NULL, '2023-10-20 00:58:17', '2023-10-20 00:58:17', NULL, NULL, 'BEM Polinema'),
(16, 'Brian Immanuel Lumban Tobing', 'user', 2141720113, 'DIII Teknik Kimia', 'Teknik Kimia', 'brianlumban@gmail.com', '2023-10-20 00:58:18', '$2y$10$K9Px4sKj4WoIcIdb7f5nBOvcf7xFZQYmzF27wLVRBTIxx26ylGG/q', NULL, '2023-10-20 00:58:18', '2023-10-20 00:58:18', NULL, NULL, 'DPM Polinema'),
(17, 'Braman Setyo Nugroho', 'user', 2141720245, 'DIII Teknik Mesin', 'Teknik Mesin', 'bramansetyo@gmail.com', '2023-10-20 00:58:18', '$2y$10$yiQ2h8MG1ZwvdP0o.CSGoOLcNiIPVDkgEPXp5wUZ6rpv5acEx0oiW', NULL, '2023-10-20 00:58:18', '2023-10-20 00:58:18', NULL, NULL, 'DPM Polinema');

--
-- Indexes for dumped tables
--

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

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

--
-- Indeks untuk tabel `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

--
-- Indeks untuk tabel `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indeks untuk tabel `programkerjas`
--
ALTER TABLE `programkerjas`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `programkerjas_namaproker_unique` (`namaproker`);

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

--
-- Indeks untuk tabel `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`),
  ADD UNIQUE KEY `users_nim_unique` (`nim`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

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

--
-- AUTO_INCREMENT untuk tabel `failed_jobs`
--
ALTER TABLE `failed_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=12;

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

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

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

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

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

