text: -- phpMyAdmin SQL Dump
  -- version 4.8.3
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Generation Time: Feb 05, 2019 at 08:12 PM
  -- Server version: 10.1.37-MariaDB
  -- PHP Version: 7.2.12
  
  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`
  --
  
  -- --------------------------------------------------------
  
  --
  -- 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
  (4, '2019_02_04_194704_create_table_kelas', 1),
  (5, '2019_02_05_073254_create_table_siswa', 1),
  (6, '2019_02_05_104733_create_table_user', 1),
  (7, '2019_02_05_171422_add_foto_table_siswa', 2);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `table_kelas`
  --
  
  CREATE TABLE `table_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 `table_kelas`
  --
  
  INSERT INTO `table_kelas` (`id_kelas`, `nama_kelas`, `jurusan`, `created_at`, `updated_at`) VALUES
  (1, 'IS-9', 'IF', '2019-02-05 04:54:49', '2019-02-05 06:44:40'),
  (2, 'IS-8', 'Sistem Informasi', '2019-02-05 04:54:56', '2019-02-05 04:54:56'),
  (4, 'IS-12', 'Sistem Informasi', '2019-02-05 04:55:10', '2019-02-05 04:55:10');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `table_siswa`
  --
  
  CREATE TABLE `table_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_tlp` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `id_kelas` varchar(255) COLLATE utf8mb4_unicode_ci 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 `table_siswa`
  --
  
  INSERT INTO `table_siswa` (`nis`, `nama_lengkap`, `jenis_kelamin`, `alamat`, `no_tlp`, `id_kelas`, `created_at`, `updated_at`, `foto`) VALUES
  (123123, 'badu', 'L', 'werwerw', '456456456', '4', '2019-02-05 09:49:48', '2019-02-05 10:52:41', '123123.jpg'),
  (252353, 'sdgdfsdgs', 'L', 'aaweweq', '4534534543', '4', '2019-02-05 12:06:38', '2019-02-05 12:06:38', '252353.jpg'),
  (1293791, 'ererwer', 'L', 'werwersdfsd', '45645645', '1', '2019-02-05 07:26:46', '2019-02-05 07:28:25', ''),
  (10515115, 'Irman Ramadhan', 'L', 'Bandung', '087725657897', '1', '2019-02-05 10:51:29', '2019-02-05 10:51:29', '10515115.jpg'),
  (12312312, 'dasdasd', 'L', 'asdasda', '45645', '2', '2019-02-05 12:05:49', '2019-02-05 12:05:49', '12312312.jpg');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `table_user`
  --
  
  CREATE TABLE `table_user` (
    `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 `table_user`
  --
  
  INSERT INTO `table_user` (`id_login`, `nama_user`, `username`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (1, 'Admin', 'admin', '$2y$10$M7wsVFdz3QNVCs3LyxzagexAZZifT.stgNYXvvACsSDlVddFwu8P6', 'X2Hygkr01OyFCCdmuhtuYyHWigMd388M0aUzBc6MX4diLKmz665H3eryZBly', '2019-02-05 04:26:48', '2019-02-05 04:26:48');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indexes for table `table_kelas`
  --
  ALTER TABLE `table_kelas`
    ADD PRIMARY KEY (`id_kelas`);
  
  --
  -- Indexes for table `table_siswa`
  --
  ALTER TABLE `table_siswa`
    ADD PRIMARY KEY (`nis`);
  
  --
  -- Indexes for table `table_user`
  --
  ALTER TABLE `table_user`
    ADD PRIMARY KEY (`id_login`);
  
  --
  -- AUTO_INCREMENT for dumped tables
  --
  
  --
  -- AUTO_INCREMENT for table `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
  
  --
  -- AUTO_INCREMENT for table `table_kelas`
  --
  ALTER TABLE `table_kelas`
    MODIFY `id_kelas` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT for table `table_user`
  --
  ALTER TABLE `table_user`
    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 */;
  