text: -- phpMyAdmin SQL Dump
  -- version 4.9.0.1
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Waktu pembuatan: 23 Mar 2020 pada 05.56
  -- Versi server: 10.3.16-MariaDB
  -- Versi PHP: 7.3.7
  
  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: `laravel`
  --
  
  -- --------------------------------------------------------
  
  --
  -- 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 `material`
  --
  
  CREATE TABLE `material` (
    `id` int(11) NOT NULL,
    `nama` varchar(30) NOT NULL,
    `kode` varchar(10) NOT NULL,
    `ukuran` varchar(30) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data untuk tabel `material`
  --
  
  INSERT INTO `material` (`id`, `nama`, `kode`, `ukuran`) VALUES
  (1, 'Batu Bata', 'B001', '60 cm x 20 cm x 7,5 cm'),
  (2, 'Baja Ringan', 'B002', 'C75.75 x 6 M');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `materials`
  --
  
  CREATE TABLE `materials` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `nama` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `kode` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `deskripsi` 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 `materials`
  --
  
  INSERT INTO `materials` (`id`, `nama`, `kode`, `deskripsi`, `created_at`, `updated_at`) VALUES
  (1, 'Peredam Panas Atap', 'P001', '100 cm x 100 cm', '2020-03-18 15:22:50', NULL),
  (7, 'Keramik', 'K001', '1 dus', '2020-03-19 06:03:02', '2020-03-19 06:03:02'),
  (8, 'Semen Indo jaya', 'S002', '105 Kg', '2020-03-19 06:13:08', '2020-03-22 20:25:02');
  
  -- --------------------------------------------------------
  
  --
  -- 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
  (3, '2014_10_12_000000_create_users_table', 1),
  (4, '2019_08_19_000000_create_failed_jobs_table', 1),
  (5, '2020_03_18_150443_create_materials_table', 1);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `pegawai`
  --
  
  CREATE TABLE `pegawai` (
    `id` int(11) NOT NULL,
    `nama` varchar(50) NOT NULL,
    `jabatan` varchar(20) NOT NULL,
    `alamat` varchar(100) NOT NULL,
    `email` varchar(20) NOT NULL,
    `no_hp` varchar(12) NOT NULL,
    `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data untuk tabel `pegawai`
  --
  
  INSERT INTO `pegawai` (`id`, `nama`, `jabatan`, `alamat`, `email`, `no_hp`, `updated_at`, `created_at`) VALUES
  (1, 'Stepen', 'Pemilik Toko', 'JL.Ir.Suprapto RT01 RW01 Cirebon', 'stepen@gmail.com', '087123456123', '2020-03-23 04:07:02', '2020-03-23 04:07:02'),
  (2, 'Roni', 'Pelayan Toko', 'Jl. Melati RT09 RW01 Cirebon', 'roni@gmail.com', '083131123516', '2020-03-22 21:17:14', '2020-03-22 21:17:14'),
  (3, 'Richarad', 'Admin', 'Jl. Kenanga RT06 RW07 Tegal', 'rich@gmail.com', '087152341213', '2020-03-22 21:28:39', '2020-03-23 04:28:39');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `pelanggan`
  --
  
  CREATE TABLE `pelanggan` (
    `id` int(11) NOT NULL,
    `nama` varchar(50) NOT NULL,
    `alamat` varchar(100) NOT NULL,
    `email` varchar(30) NOT NULL,
    `no_hp` varchar(15) NOT NULL,
    `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data untuk tabel `pelanggan`
  --
  
  INSERT INTO `pelanggan` (`id`, `nama`, `alamat`, `email`, `no_hp`, `updated_at`, `created_at`) VALUES
  (1, 'Alifani', 'Jl. Muhari Rt007 Rw007 Tegal', 'alifani@gmail.com', '987654312', '2020-03-23 00:50:00', '2020-03-23 00:50:00'),
  (2, 'Amarulloh s', 'Jl. Ahmad Yani RT07 RW01 Slawi', 'amarulloh@gmail.com', '081234567890', '2020-03-22 18:45:28', '2020-03-23 01:45:28'),
  (3, 'Ilham', 'Jl. Merpati T01 RW02 Tegal', 'ilham@gmail.com', '087654321209', '2020-03-22 17:43:30', '2020-03-22 17:43:30'),
  (4, 'Labib', 'Jl. Werkudoro RT01 RW01 Tagal', 'labib@gmail.com', '098765432123', '2020-03-22 17:49:22', '2020-03-22 17:49:22'),
  (5, 'Tasya', 'Jl. Kartini RT01 RW02 Brebes', 'tasya@gmail.com', '087152436123', '2020-03-22 17:53:02', '2020-03-22 17:53:02'),
  (6, 'Kiki', 'Jl. Patimura RT02 RW02', 'kiki@gmail.com', '087812435612', '2020-03-22 17:55:19', '2020-03-22 17:55:19'),
  (7, 'Muzani', 'Jl. gendowor', 'muzani@gmail.com', '085612315172', '2020-03-22 17:56:16', '2020-03-22 17:56:16'),
  (10, 'Nur Ali', 'Jl. Mawar RT01 RW01 Jakarta', 'putri@gmail.com', '087812345678', '2020-03-22 21:26:29', '2020-03-23 04:26:29');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `supplier`
  --
  
  CREATE TABLE `supplier` (
    `id` int(11) NOT NULL,
    `nama` varchar(30) NOT NULL,
    `alamat` varchar(100) NOT NULL,
    `email` varchar(20) NOT NULL,
    `no_hp` varchar(12) NOT NULL,
    `jenis` varchar(20) NOT NULL,
    `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
    `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data untuk tabel `supplier`
  --
  
  INSERT INTO `supplier` (`id`, `nama`, `alamat`, `email`, `no_hp`, `jenis`, `created_at`, `updated_at`) VALUES
  (1, 'PT.Jay Abadi', 'Jl. Semeru RT01 RW02 Banten', 'jayaabadi@gmail.com', '+123678', 'Besi', '2020-03-23 03:23:55', '2020-03-23 03:23:05'),
  (3, 'PT. Anti Karat', 'Jl. Mataram RT07 RW09 Jogjakarta', 'antikarat@gmail.com', '087612341600', 'Besi', '2020-03-23 03:32:09', '2020-03-22 20:32:09');
  
  -- --------------------------------------------------------
  
  --
  -- 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
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indeks untuk tabel `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `material`
  --
  ALTER TABLE `material`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `materials`
  --
  ALTER TABLE `materials`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `migrations`
  --
  ALTER TABLE `migrations`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `pegawai`
  --
  ALTER TABLE `pegawai`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `pelanggan`
  --
  ALTER TABLE `pelanggan`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `supplier`
  --
  ALTER TABLE `supplier`
    ADD PRIMARY KEY (`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 `failed_jobs`
  --
  ALTER TABLE `failed_jobs`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  
  --
  -- AUTO_INCREMENT untuk tabel `material`
  --
  ALTER TABLE `material`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT untuk tabel `materials`
  --
  ALTER TABLE `materials`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;
  
  --
  -- AUTO_INCREMENT untuk tabel `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT untuk tabel `pegawai`
  --
  ALTER TABLE `pegawai`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT untuk tabel `pelanggan`
  --
  ALTER TABLE `pelanggan`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;
  
  --
  -- AUTO_INCREMENT untuk tabel `supplier`
  --
  ALTER TABLE `supplier`
    MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
  
  --
  -- AUTO_INCREMENT untuk tabel `users`
  --
  ALTER TABLE `users`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;
  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 */;
  