-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Waktu pembuatan: 22 Okt 2022 pada 06.34
-- Versi server: 10.4.25-MariaDB
-- Versi PHP: 8.1.10

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),
(29, 'mcom', 'suryadin.mcom@gmail.com', NULL, '$2y$10$3jv0eOB5zTZAXlnoJw7lSO11qgBj8ybkoMp/WFgJmFPrGezjqI1wG', NULL, '2022-10-17 05:05:29', '2022-10-17 05:11:15', '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=30;

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