-- phpMyAdmin SQL Dump -- version 5.1.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Waktu pembuatan: 12 Jan 2022 pada 10.54 -- Versi server: 10.4.21-MariaDB -- Versi PHP: 7.3.31 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: `db_spmi` -- -- -------------------------------------------------------- -- -- Struktur dari tabel `beritas` -- CREATE TABLE `beritas` ( `id` bigint(20) UNSIGNED NOT NULL, `judul` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `isi` text COLLATE utf8mb4_unicode_ci NOT NULL, `tanggal` datetime NOT NULL, `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_by` int(11) 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 `beritas` -- INSERT INTO `beritas` (`id`, `judul`, `isi`, `tanggal`, `thumbnail`, `created_by`, `created_at`, `updated_at`) VALUES (3, 'kegiatan 1', 'kegiatan 1', '2021-12-27 16:12:34', '1640621554 WhatsApp Image 2021-12-26 at 13.25.25 (3).jpg', 22, '2021-12-27 09:12:34', '2021-12-27 09:12:34'), (4, 'kegiatan 2', 'kegiatan 2', '2021-12-27 16:13:08', '1640621588 WhatsApp Image 2021-12-26 at 13.25.25 (4).jpg', 22, '2021-12-27 09:13:08', '2021-12-27 09:13:08'), (5, 'kegiatan 3', 'kegiatan 3', '2021-12-27 16:13:42', '1640621622 WhatsApp Image 2021-12-26 at 13.25.25 (1).jpg', 22, '2021-12-27 09:13:42', '2021-12-27 09:13:42'), (6, 'kegiatan 4', 'kegiatan 4', '2021-12-27 16:14:23', '1640621663 WhatsApp Image 2021-12-26 at 13.25.24.jpg', 22, '2021-12-27 09:14:23', '2021-12-27 09:14:23'), (7, 'hari ini sedang sidang', 'yang di sidang darma dengan ahmad surajaya', '2021-12-28 04:12:49', '1640664769 WhatsApp Image 2021-12-26 at 13.25.25.jpg', 27, '2021-12-27 21:12:49', '2021-12-27 21:12:49'); -- -------------------------------------------------------- -- -- Struktur dari tabel `documents` -- CREATE TABLE `documents` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `name_file` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `remarks` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `documents` -- INSERT INTO `documents` (`id`, `name`, `name_file`, `remarks`, `created_at`, `updated_at`, `deleted_at`) VALUES (1, 'sad test sfsdf', 'sad test sfsdf.jpg', 'ad test sdfs', '2021-10-08 09:13:36', '2021-10-08 10:05:38', NULL), (2, 'sad', 'sad.png', 'ad', '2021-10-08 09:14:37', '2021-10-08 10:05:26', '2021-10-08 10:05:26'), (3, 'sdfsdf', 'sdfsdf.png', 'asd', '2021-10-08 09:19:46', '2021-10-08 09:19:46', NULL), (4, 'd', 'd.png', 'ad', '2021-10-08 09:22:05', '2021-10-08 09:48:31', '2021-10-08 09:48:31'), (5, 'sdf', 'sdf.png', 'sdf', '2021-10-08 09:22:52', '2021-10-08 09:22:52', NULL), (6, 'Update Status JKT', 'Update Status JKT.png', 'asd', '2021-10-08 09:24:41', '2021-10-08 09:24:41', NULL), (7, 'Update Status JKT', 'Update Status JKT.png', 'asd', '2021-10-08 09:25:27', '2021-10-08 09:25:27', NULL), (8, 'Update Status JKT', 'Update Status JKT.png', 'asd', '2021-10-08 09:26:03', '2021-10-08 09:26:03', NULL), (9, 'Update Status JKT', 'Update Status JKT.png', 'asd', '2021-10-08 09:26:14', '2021-10-08 09:26:14', NULL), (10, 'Administrator', 'Administrator.png', 'asd', '2021-10-08 09:26:35', '2021-10-08 09:48:24', '2021-10-08 09:48:24'); -- -------------------------------------------------------- -- -- Struktur dari tabel `dokumens` -- CREATE TABLE `dokumens` ( `id` bigint(20) UNSIGNED NOT NULL, `jenis_dokumen_id` bigint(20) UNSIGNED NOT NULL, `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `file` 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 `dokumens` -- INSERT INTO `dokumens` (`id`, `jenis_dokumen_id`, `nama`, `file`, `created_at`, `updated_at`) VALUES (11, 12, '2018 (1) Standar Pendidikan', '1640620037 2018 (1) Standar Pendidikan.pdf', '2021-12-27 08:47:17', '2021-12-27 08:47:17'), (12, 12, 'Laporan Monev Penelitian 2020', '1640620073 Laporan Monev Penelitian 2020.pdf', '2021-12-27 08:47:53', '2021-12-27 08:47:53'), (13, 13, '1. Manual Standar HASIL PENELITIAN', '1640620148 1. Manual Standar HASIL PENELITIAN.pdf', '2021-12-27 08:49:08', '2021-12-27 08:49:08'), (14, 13, '1. Manual Standar Kompetensi Lulusan', '1640620186 1. Manual Standar Kompetensi Lulusan.pdf', '2021-12-27 08:49:46', '2021-12-27 08:49:46'), (15, 15, '01 STANDAR KOMPETENSI LULUSAN SPMI UNMA 2018', '1640620376 01 STANDAR KOMPETENSI LULUSAN SPMI UNMA 2018.pdf', '2021-12-27 08:52:56', '2021-12-27 08:52:56'), (16, 15, '02 STANDAR ISI PEMBELAJARAN SPMI UNMA 2018', '1640620413 02 STANDAR ISI PEMBELAJARAN SPMI UNMA 2018.pdf', '2021-12-27 08:53:33', '2021-12-27 08:53:33'), (17, 16, '1. Form BA (UTS)', '1640620556 1. Form BA (UTS).pdf', '2021-12-27 08:55:56', '2021-12-27 08:55:56'), (19, 16, '2. Form BA (UAS)', '1640620640 2. Form BA (UAS).pdf', '2021-12-27 08:57:20', '2021-12-27 08:57:20'), (20, 17, 'kebijakan spmi unma 22 oktober 2018 OK', '1640620694 kebijakan spmi unma 22 oktober 2018 OK.pdf', '2021-12-27 08:58:14', '2021-12-27 08:58:14'), (21, 17, 'RTM', '1640620721 RTM.pdf', '2021-12-27 08:58:41', '2021-12-27 08:58:41'), (22, 18, '01 SOP VISI _ MISI', '1640620768 01 SOP VISI _ MISI.pdf', '2021-12-27 08:59:28', '2021-12-27 08:59:28'), (23, 18, '02 SOP PEMILIHAN DEKAN', '1640620801 02 SOP PEMILIHAN DEKAN.pdf', '2021-12-27 09:00:01', '2021-12-27 09:00:01'), (24, 18, '03 SOP PENDAFTARAN CALON MABA', '1640664698 03 SOP PENDAFTARAN CALON MABA.pdf', '2021-12-27 21:11:38', '2021-12-27 21:11:38'); -- -------------------------------------------------------- -- -- Struktur dari tabel `failed_jobs` -- CREATE TABLE `failed_jobs` ( `id` bigint(20) UNSIGNED 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 `jenis_dokumens_tables` -- CREATE TABLE `jenis_dokumens_tables` ( `id` bigint(20) UNSIGNED NOT NULL, `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `level` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `parent_id` int(11) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; -- -- Dumping data untuk tabel `jenis_dokumens_tables` -- INSERT INTO `jenis_dokumens_tables` (`id`, `nama`, `level`, `created_at`, `updated_at`, `parent_id`) VALUES (12, 'AMI- Kuisioner Pelayanan', NULL, '2021-12-26 21:04:58', '2021-12-26 21:04:58', NULL), (13, 'Dokumen Manual', NULL, '2021-12-27 08:39:10', '2021-12-27 08:39:10', NULL), (15, 'Dokumen Standar', NULL, '2021-12-27 08:42:05', '2021-12-27 08:42:05', NULL), (16, 'Formulir', NULL, '2021-12-27 08:42:32', '2021-12-27 08:42:32', NULL), (17, 'kebijakan SPMI unma dan RTM', NULL, '2021-12-27 08:43:14', '2021-12-27 08:43:14', NULL), (18, 'SOP', NULL, '2021-12-27 08:43:50', '2021-12-27 08:43:50', NULL); -- -------------------------------------------------------- -- -- 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, '2014_10_12_000000_create_users_table', 1), (2, '2014_10_12_100000_create_password_resets_table', 1), (3, '2019_08_19_000000_create_failed_jobs_table', 1), (4, '2021_10_08_124222_create_documents_table', 2), (5, '2021_10_08_163725_add_softdeleted_in_documents', 3), (6, '2019_12_14_000001_create_personal_access_tokens_table', 4), (7, '2021_11_11_031932_create_jenis_dokumens_tables', 5), (8, '2021_11_11_032520_drop_jenis_dokumens_table', 6), (9, '2021_11_11_032903_create_jenis_dokumens_tables', 7), (10, '2021_11_13_122649_create_dokumens_table', 8), (11, '2021_11_28_052213_create_beritas_table', 9), (12, '2021_11_28_092720_update_users_table', 10), (13, '2021_11_29_083255_update_jenis_dokumens_table', 11); -- -------------------------------------------------------- -- -- Struktur dari tabel `password_resets` -- CREATE TABLE `password_resets` ( `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(255) COLLATE utf8mb4_unicode_ci 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) COLLATE utf8mb4_unicode_ci NOT NULL, `tokenable_id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `token` varchar(64) COLLATE utf8mb4_unicode_ci NOT NULL, `abilities` text COLLATE utf8mb4_unicode_ci 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 `users` -- CREATE TABLE `users` ( `id` bigint(20) UNSIGNED NOT NULL, `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL, `email_verified_at` timestamp NULL DEFAULT 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, `level` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `status` int(11) DEFAULT NULL ) 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`, `level`, `status`) VALUES (2, 'Admin Admin', 'admin@lightbp.com', '2021-11-04 06:35:31', '$2y$10$O.nnJmeNdjW1IcpnHsaYoe5NqFf90mSMrKFythA7xmr.IWsu7uJd6', NULL, '2021-11-04 06:35:31', '2021-11-04 06:35:31', '', 1), (22, 'darma', 'darma@gmail.com', NULL, '$2y$10$zjRil6VbV9Ax4vNlw7lcFumpOlDE2uwLpiMY2d9IDHbtU0Sl0ybTa', NULL, '2021-12-26 21:39:01', '2021-12-26 21:39:01', '1', 1), (27, 'robi', 'robi@gmail.com', NULL, '$2y$10$HsRY.I7YTUSqZXa.9QBX5OvcOzAsxH.07Yy7JzMWMd1ov4rEXwfDG', NULL, '2021-12-27 21:09:02', '2021-12-27 21:09:02', '1', 1), (28, 'jae', 'jaemerah@gmail.com', NULL, '$2y$10$bS2hQsq7CdWbB5lyofwf5OwbCZxvXdp8CbB2Men4fp//dyS1y2Psm', NULL, '2021-12-27 21:14:25', '2021-12-27 21:15:40', 'guest', 1); -- -- Indexes for dumped tables -- -- -- Indeks untuk tabel `beritas` -- ALTER TABLE `beritas` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `documents` -- ALTER TABLE `documents` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `dokumens` -- ALTER TABLE `dokumens` ADD PRIMARY KEY (`id`), ADD KEY `dokumens_jenis_dokumen_id_foreign` (`jenis_dokumen_id`); -- -- Indeks untuk tabel `failed_jobs` -- ALTER TABLE `failed_jobs` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `jenis_dokumens_tables` -- ALTER TABLE `jenis_dokumens_tables` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `migrations` -- ALTER TABLE `migrations` ADD PRIMARY KEY (`id`); -- -- Indeks untuk tabel `password_resets` -- ALTER TABLE `password_resets` ADD KEY `password_resets_email_index` (`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 `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 `beritas` -- ALTER TABLE `beritas` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8; -- -- AUTO_INCREMENT untuk tabel `documents` -- ALTER TABLE `documents` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11; -- -- AUTO_INCREMENT untuk tabel `dokumens` -- ALTER TABLE `dokumens` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25; -- -- AUTO_INCREMENT untuk tabel `failed_jobs` -- ALTER TABLE `failed_jobs` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT; -- -- AUTO_INCREMENT untuk tabel `jenis_dokumens_tables` -- ALTER TABLE `jenis_dokumens_tables` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19; -- -- AUTO_INCREMENT untuk tabel `migrations` -- ALTER TABLE `migrations` MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14; -- -- 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 `users` -- ALTER TABLE `users` MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29; -- -- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables) -- -- -- Ketidakleluasaan untuk tabel `dokumens` -- ALTER TABLE `dokumens` ADD CONSTRAINT `dokumens_jenis_dokumen_id_foreign` FOREIGN KEY (`jenis_dokumen_id`) REFERENCES `jenis_dokumens_tables` (`id`) ON DELETE CASCADE; 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 */;