-- phpMyAdmin SQL Dump -- version 5.2.0 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Waktu pembuatan: 20 Okt 2023 pada 10.40 -- Versi server: 10.4.27-MariaDB -- Versi PHP: 8.2.0 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; START TRANSACTION; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8mb4 */; -- -- 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; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;