text: -- phpMyAdmin SQL Dump
  -- version 5.0.2
  -- https://www.phpmyadmin.net/
  --
  -- Host: 127.0.0.1
  -- Waktu pembuatan: 31 Bulan Mei 2020 pada 16.29
  -- Versi server: 10.4.11-MariaDB
  -- Versi PHP: 7.4.6
  
  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_saw`
  --
  
  -- --------------------------------------------------------
  
  --
  -- 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_06_28_174820_create_role_table', 1),
  (4, '2019_06_28_174943_create_role_user_table', 1),
  (5, '2019_07_04_155617_create_setting_table', 2);
  
  -- --------------------------------------------------------
  
  --
  -- 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 `role`
  --
  
  CREATE TABLE `role` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `role` 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 `role`
  --
  
  INSERT INTO `role` (`id`, `role`, `created_at`, `updated_at`) VALUES
  (1, 'User', '2020-05-31 00:33:03', '2020-05-31 00:33:03'),
  (2, 'Administrator', '2020-05-31 00:33:03', '2020-05-31 00:33:03');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `role_user`
  --
  
  CREATE TABLE `role_user` (
    `user_id` int(10) UNSIGNED NOT NULL,
    `role_id` int(10) UNSIGNED 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 `role_user`
  --
  
  INSERT INTO `role_user` (`user_id`, `role_id`, `created_at`, `updated_at`) VALUES
  (1, 1, NULL, NULL),
  (1, 2, NULL, NULL),
  (2, 1, NULL, NULL),
  (2, 2, NULL, NULL);
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `setting`
  --
  
  CREATE TABLE `setting` (
    `id` bigint(20) UNSIGNED NOT NULL,
    `key` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
    `value` longtext 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 untuk tabel `setting`
  --
  
  INSERT INTO `setting` (`id`, `key`, `value`, `created_at`, `updated_at`) VALUES
  (1, 'c1', '{\"weight\":\"0.6\",\"is_cost\":\"0\"}', '2019-07-04 09:00:38', '2020-05-31 05:55:48'),
  (2, 'c2', '{\"weight\":\"0.2\",\"is_cost\":\"0\"}', '2019-07-04 09:00:38', '2020-05-31 05:50:00'),
  (3, 'c3', '{\"weight\":\"0.8\",\"is_cost\":\"0\"}', '2019-07-04 09:00:38', '2019-07-04 19:19:24'),
  (4, 'c4', '{\"weight\":\"0.6\",\"is_cost\":\"0\"}', '2019-07-04 09:00:38', '2019-07-10 18:55:08'),
  (5, 'c5', '{\"weight\":\"1\",\"is_cost\":\"0\"}', '2019-07-04 09:00:38', '2020-05-31 05:50:00'),
  (6, 'c6', '{\"weight\":\"1\",\"is_cost\":\"0\"}', '2019-07-31 09:00:38', '2020-05-31 05:50:00');
  
  -- --------------------------------------------------------
  
  --
  -- Struktur dari tabel `tanaman`
  --
  
  CREATE TABLE `tanaman` (
    `id` int(9) NOT NULL,
    `nama_tanaman` varchar(100) NOT NULL,
    `tekanan_udara` float DEFAULT NULL,
    `kecepatan_angin` float DEFAULT NULL,
    `kelembaban_udara` float DEFAULT NULL,
    `penyinaran_matahari` float DEFAULT NULL,
    `jumlah_curah_hujan` float DEFAULT NULL,
    `suhu` float DEFAULT NULL,
    `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
    `created_at` timestamp NOT NULL DEFAULT current_timestamp()
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  --
  -- Dumping data untuk tabel `tanaman`
  --
  
  INSERT INTO `tanaman` (`id`, `nama_tanaman`, `tekanan_udara`, `kecepatan_angin`, `kelembaban_udara`, `penyinaran_matahari`, `jumlah_curah_hujan`, `suhu`, `updated_at`, `created_at`) VALUES
  (1, 'Jagung', 1011.9, 11.9613, 80.3, 9.92, 0.926667, 27.2267, '2020-05-31 09:46:59', '2020-05-31 09:46:59'),
  (3, 'Padi', 1012.6, 13.32, 78.3333, 8.83333, 0.0103448, 26.0433, '2020-05-31 05:57:15', '2020-05-31 05:57:15'),
  (4, 'Ubi', 1012.7, 14.6323, 76.7931, 8.65, 0.110714, 25.7793, '2020-05-31 05:58:04', '2020-05-31 05:58:04');
  
  -- --------------------------------------------------------
  
  --
  -- 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;
  
  --
  -- Dumping data untuk tabel `users`
  --
  
  INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
  (2, 'admin', 'admin@admin.com', NULL, '$2y$10$qTKVKsO0z7qiIyM6rqkQReisIJICxleW8IfZG3cj/qMSlwuK7xI1.', NULL, '2020-05-31 00:33:03', '2020-05-31 00:33:03');
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- 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 `role`
  --
  ALTER TABLE `role`
    ADD PRIMARY KEY (`id`);
  
  --
  -- Indeks untuk tabel `role_user`
  --
  ALTER TABLE `role_user`
    ADD PRIMARY KEY (`user_id`,`role_id`);
  
  --
  -- Indeks untuk tabel `setting`
  --
  ALTER TABLE `setting`
    ADD PRIMARY KEY (`id`),
    ADD UNIQUE KEY `setting_key_unique` (`key`);
  
  --
  -- Indeks untuk tabel `tanaman`
  --
  ALTER TABLE `tanaman`
    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 `migrations`
  --
  ALTER TABLE `migrations`
    MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT untuk tabel `role`
  --
  ALTER TABLE `role`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  
  --
  -- AUTO_INCREMENT untuk tabel `setting`
  --
  ALTER TABLE `setting`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
  
  --
  -- AUTO_INCREMENT untuk tabel `tanaman`
  --
  ALTER TABLE `tanaman`
    MODIFY `id` int(9) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
  
  --
  -- AUTO_INCREMENT untuk tabel `users`
  --
  ALTER TABLE `users`
    MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  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 */;
  