text: -- phpMyAdmin SQL Dump
  -- version 5.0.3
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Feb 03, 2021 at 05:34 PM
  -- Server version: 10.4.14-MariaDB
  -- PHP Version: 7.2.34
  
  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: `pmi`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `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;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `jadwal`
  --
  
  CREATE TABLE `jadwal` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `kd_pegawai` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
    `jadwal` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `token` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `jadwal`
  --
  
  INSERT INTO `jadwal` (`id`, `kd_pegawai`, `jadwal`, `created_at`, `updated_at`, `token`) VALUES
  (4, 'PMI0006', 'Wisnu215', '2021-02-03 08:18:51', '2021-02-03 08:18:51', NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `karyawan`
  --
  
  CREATE TABLE `karyawan` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `kd_pegawai` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
    `nama_lengkap` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `jenis_kelamin` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
    `divisi` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `token` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `karyawan`
  --
  
  INSERT INTO `karyawan` (`id`, `kd_pegawai`, `nama_lengkap`, `jenis_kelamin`, `divisi`, `created_at`, `updated_at`, `email`, `token`) VALUES
  (1, 'PMI0001', 'Rangga Tirtayana', 'Laki-laki', 'IT', '2021-01-23 15:01:58', '2021-01-23 15:10:34', NULL, NULL),
  (2, 'PMI0002', 'Abdul Fahmi', 'Laki-laki', 'Dokter Bedah', '2021-01-23 15:02:32', '2021-01-23 15:02:32', NULL, NULL),
  (3, 'PMI0003', 'Lutfi Herlambang', 'Laki-laki', 'Dokter Sarap', '2021-01-23 15:02:48', '2021-01-23 15:02:48', NULL, NULL),
  (4, 'PMI0004', 'Yanuar Anggarsyah', 'Laki-laki', 'Dokter Anak', '2021-01-23 15:03:19', '2021-01-23 15:03:19', NULL, NULL),
  (6, 'PMI0006', 'boyenmines4', 'Perempuan', 'penghangat', '2021-01-23 19:47:46', '2021-02-03 09:32:39', 'boyen@gmail.com', 'eEZ1TQe28XHww4pD91ksPe:APA91bFfprGn-FLGW1MSODX3cMpPnmhn3xRprTr-Hj7vHcKxPzlNEQnJyMUfq8gS8Brexmz-85lBFFSl3ui_3gdBYNgw7xWqT62K8skTdACerfvcG1kiveLQiAqreyqH6u6Fz4iufGv9');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `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 for table `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_01_23_160643_create_peserta_table', 1),
  (5, '2021_01_23_213139_create_karyawan_table', 2),
  (6, '2021_01_25_065706_create_jadwal_table', 3);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `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;
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `peserta`
  --
  
  CREATE TABLE `peserta` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `nis` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
    `nama_lengkap` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
    `kelas` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
    `alamat` text 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 for table `peserta`
  --
  
  INSERT INTO `peserta` (`id`, `nis`, `nama_lengkap`, `kelas`, `alamat`, `created_at`, `updated_at`) VALUES
  (4, '1234244', 'sdvcdsvsd', 'XII RPL', 'sdertytfdxcd', '2021-01-23 11:07:35', '2021-01-23 14:23:53'),
  (5, '876543', 'qazswsxdedcrfv', 'XII RPL', 'mnbvcxzasdfgtrewqwertyui', '2021-01-23 11:25:00', '2021-01-23 11:25:00');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `users`
  --
  
  CREATE TABLE `users` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `username` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `level` enum('admin','pembimbing_sekolah','peserta') COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `remember_token` text COLLATE utf8mb4_unicode_ci DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `username`, `password`, `level`, `created_at`, `updated_at`, `email`, `remember_token`) VALUES
  (1, 'Rangga', 'rangga', '$2y$10$IiWWD4Rk7ziwgSz8/Bya2uWOM5MIzKk2q8QPNNYy2Btn50UKGNcbK', 'admin', NULL, NULL, NULL, NULL),
  (2, 'Wisnu Alipudin', NULL, '$2y$10$mhqRjXREyJjbvzhMo4kJI.w7JlOjH2rQOjgKWoGbLsUYxtT0jRJlm', 'admin', '2021-02-02 08:56:45', '2021-02-02 08:56:45', 'wisnualipudin@gmail.com', NULL),
  (3, 'aci', NULL, '$2y$10$ciWwMz4mgWxsLrEWvCppOeJJB52R2yY8hu.9rE178djkWaqOSSku6', 'admin', '2021-02-02 09:09:47', '2021-02-02 09:09:47', 'aci@215.com', NULL);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `jadwal`
  --
  ALTER TABLE `jadwal`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `karyawan`
  --
  ALTER TABLE `karyawan`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `password_resets`
  --
  ALTER TABLE `password_resets`
    ADD KEY `password_resets_email_index` (`email`);
  
  --
  -- Indexes for table `peserta`
  --
  ALTER TABLE `peserta`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `users`
  --
  ALTER TABLE `users`
    ADD PRIMARY KEY (`id`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT for table `jadwal`
  --
  ALTER TABLE `jadwal`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `karyawan`
  --
  ALTER TABLE `karyawan`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `peserta`
  --
  ALTER TABLE `peserta`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT for table `users`
  --
  ALTER TABLE `users`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  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 */;
  