text: -- phpMyAdmin SQL Dump
  -- version 4.8.4
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Feb 05, 2019 at 11:45 PM
  -- Server version: 10.1.37-MariaDB
  -- PHP Version: 7.3.1
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  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_laravel_siswa`
  --
  CREATE DATABASE IF NOT EXISTS `db_laravel_siswa` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
  USE `db_laravel_siswa`;
  
  -- --------------------------------------------------------
  
  --
  -- 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, '2019_02_05_001641_create_table_kelas', 1),
  (2, '2019_02_05_075914_create_table_siswa', 2),
  (3, '2019_02_05_091623_create_table_user', 3),
  (4, '2019_02_05_210919_add_foto_table_siswa', 4);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `t_kelas`
  --
  
  CREATE TABLE `t_kelas` (
    `id_kelas` int(10) UNSIGNED NOT NULL,
    `nama_kelas` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `jurusan` varchar(100) 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 `t_kelas`
  --
  
  INSERT INTO `t_kelas` (`id_kelas`, `nama_kelas`, `jurusan`, `created_at`, `updated_at`) VALUES
  (1, 'XII-RPL1', 'Rekayasa Perangkat Lunak', NULL, NULL),
  (2, 'XII-RPL2', 'Rekayasa Perangkat Lunak', NULL, NULL),
  (3, 'XII-RPL3', 'Rekayasa Perangkat Lunak', '2019-02-04 18:29:26', '2019-02-04 18:29:26'),
  (4, 'XII-MM', 'Multi Media', '2019-02-04 18:39:41', '2019-02-04 23:16:36');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `t_login`
  --
  
  CREATE TABLE `t_login` (
    `id_login` int(10) UNSIGNED NOT NULL,
    `nama_user` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `password` varchar(150) 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
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `t_login`
  --
  
  INSERT INTO `t_login` (`id_login`, `nama_user`, `username`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'Admin', 'admin', '$2y$10$hnaPZz4CK6Y42IwXj3hxBuoqKBw9YPotFe0ZPSZmE9X36Z94ZG8kK', 'gqJh3HHtfhBeWUs6wWTksM6MwDEKn8XAtuHSUiShf1ssTWQQzKObTNRjHdUj', '2019-02-05 02:24:15', '2019-02-05 02:24:15');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `t_siswa`
  --
  
  CREATE TABLE `t_siswa` (
    `nis` int(11) NOT NULL,
    `nama_lengkap` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
    `jenis_kelamin` varchar(1) COLLATE utf8mb4_unicode_ci NOT NULL,
    `alamat` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `no_telp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `id_kelas` int(11) NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `foto` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Dumping data for table `t_siswa`
  --
  
  INSERT INTO `t_siswa` (`nis`, `nama_lengkap`, `jenis_kelamin`, `alamat`, `no_telp`, `id_kelas`, `created_at`, `updated_at`, `foto`) VALUES
  (10515171, 'Wafaa Kamilah Maulani', 'P', 'Dipatiukur No.138', '081320601509', 4, '2019-02-05 01:47:39', '2019-02-05 14:56:37', '10515171.jpg');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `t_kelas`
  --
  ALTER TABLE `t_kelas`
    ADD PRIMARY KEY (`id_kelas`);
  
  --
  -- Indexes for table `t_login`
  --
  ALTER TABLE `t_login`
    ADD PRIMARY KEY (`id_login`);
  
  --
  -- Indexes for table `t_siswa`
  --
  ALTER TABLE `t_siswa`
    ADD PRIMARY KEY (`nis`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `t_kelas`
  --
  ALTER TABLE `t_kelas`
    MODIFY `id_kelas` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
  
  --
  -- AUTO_INCREMENT for table `t_login`
  --
  ALTER TABLE `t_login`
    MODIFY `id_login` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  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 */;
  