-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Waktu pembuatan: 30 Bulan Mei 2024 pada 14.17
-- Versi server: 10.4.32-MariaDB
-- Versi PHP: 8.2.12

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: `coba`
--

-- --------------------------------------------------------

--
-- Struktur dari tabel `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur dari tabel `kebuns`
--

CREATE TABLE `kebuns` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `location` text NOT NULL,
  `deskripsi` text NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `blynk_token` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `kebuns`
--

INSERT INTO `kebuns` (`id`, `name`, `location`, `deskripsi`, `user_id`, `created_at`, `updated_at`, `blynk_token`) VALUES
(1, 'kebun cabai', 'F7XX+RVM, Bayatrejo, Wringinpitu, Kec. Tegaldlimo, Kabupaten Banyuwangi, Jawa Timur 68484', '1 hektar tanaman cabai', 3, '2024-05-22 13:49:39', '2024-05-25 10:56:22', 'RNaMXFNk49F3kqabvu-FZ8_0A4E7qECG'),
(4, 'kebun cabai 2', 'sabrang', 'kkkk', 3, '2024-05-22 15:25:29', '2024-05-22 15:25:29', '0QsM_PxN7blv9Zn1Rnroft8uxdJ7zCHR'),
(7, 'kebun terong', 'patrang', '1 pot tanaman terong', 2, '2024-05-23 04:25:09', '2024-05-28 11:44:14', NULL),
(10, 'Penyiraman 2', 'qwer', 'qwer', 2, '2024-05-23 04:30:30', '2024-05-23 04:30:30', NULL),
(11, 'Penyiraman 3', 'hhh', 'hhh', 2, '2024-05-23 04:31:17', '2024-05-23 04:31:17', NULL),
(13, 'kebun cabai 4', 'patrang', '1234', 3, '2024-05-25 06:34:50', '2024-05-25 06:34:50', NULL),
(14, 'ggg', 'bb', 'mmm', 2, '2024-05-25 15:05:48', '2024-05-25 15:05:48', NULL);

-- --------------------------------------------------------

--
-- Struktur dari tabel `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) 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),
(5, '2023_07_21_151455_create_monitorings_table', 1),
(6, '2023_08_17_041316_create_controls_table', 1),
(8, '2024_05_20_203055_create_schedules_table', 3),
(9, '2024_05_22_093428_create_kebuns_table', 4),
(17, '2014_10_12_100000_create_password_reset_tokens_table', 5),
(18, '2019_08_19_000000_create_failed_jobs_table', 5),
(19, '2019_12_14_000001_create_personal_access_tokens_table', 5),
(20, '2024_05_22_194102_create_users_table', 5),
(21, '2024_05_22_194153_create_kebuns_table', 5),
(22, '2024_05_22_194310_create_Sensors_table', 6),
(23, '2024_05_04_040607_add_captcha_to_users_table', 7),
(24, '2024_05_23_171526_add_blynk_token_to_kebuns_table', 8),
(25, '2024_05_28_155442_add_is_admin_to_users_table', 9),
(26, '2024_05_28_155935_add_is_admin_to_users_table', 10);

-- --------------------------------------------------------

--
-- Struktur dari tabel `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur dari tabel `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Struktur dari tabel `sensors`
--

CREATE TABLE `sensors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `calibrated_moisture` double(8,2) NOT NULL,
  `buzzer_state` tinyint(1) NOT NULL,
  `relay_state` tinyint(1) NOT NULL,
  `kebun_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `sensors`
--

INSERT INTO `sensors` (`id`, `calibrated_moisture`, `buzzer_state`, `relay_state`, `kebun_id`, `created_at`) VALUES
(1, 56.00, 1, 1, 1, '2024-05-22 15:20:17'),
(2, 52.00, 1, 1, 4, '2024-05-22 15:20:46'),
(4, 26.00, 1, 1, 1, '2024-05-23 15:50:03'),
(6, 50.50, 0, 0, 1, '2024-05-22 18:13:55'),
(10, 50.50, 0, 0, 4, '2024-05-22 18:19:58'),
(11, 9.00, 1, 0, 1, '2024-05-23 02:52:25'),
(12, 8.00, 1, 0, 1, '2024-05-23 02:53:31'),
(13, 8.00, 1, 0, 1, '2024-05-23 02:54:24'),
(14, 7.00, 1, 0, 1, '2024-05-23 02:55:25'),
(15, 7.00, 0, 0, 1, '2024-05-23 02:56:29'),
(16, 6.00, 1, 0, 1, '2024-05-23 02:58:27'),
(17, 6.00, 1, 0, 1, '2024-05-23 02:59:32'),
(18, 6.00, 0, 0, 1, '2024-05-23 03:00:31'),
(19, 5.00, 0, 0, 1, '2024-05-23 03:01:34'),
(20, 5.00, 0, 0, 1, '2024-05-23 03:02:28'),
(21, 5.00, 0, 0, 1, '2024-05-23 03:03:30'),
(22, 5.00, 0, 0, 1, '2024-05-23 03:04:29'),
(23, 6.00, 0, 0, 1, '2024-05-23 03:05:30'),
(24, 6.00, 0, 0, 1, '2024-05-23 03:06:35'),
(25, 5.00, 0, 0, 1, '2024-05-23 03:07:31'),
(26, 5.00, 0, 0, 1, '2024-05-23 03:08:31'),
(27, 5.00, 0, 0, 1, '2024-05-23 03:09:31'),
(28, 6.00, 0, 0, 1, '2024-05-23 03:10:32'),
(29, 6.00, 0, 0, 1, '2024-05-23 03:11:32'),
(30, 5.00, 0, 0, 1, '2024-05-23 03:12:33'),
(31, 6.00, 0, 0, 1, '2024-05-23 03:13:34'),
(32, 6.00, 0, 0, 1, '2024-05-23 03:14:34'),
(33, 6.00, 0, 0, 1, '2024-05-23 03:15:34'),
(34, 7.00, 0, 0, 1, '2024-05-23 03:16:34'),
(35, 7.00, 0, 0, 1, '2024-05-23 03:17:35'),
(36, 6.00, 0, 0, 1, '2024-05-23 03:18:36'),
(37, 7.00, 0, 0, 1, '2024-05-23 03:19:35'),
(38, 6.00, 0, 0, 1, '2024-05-23 03:20:36'),
(39, 6.00, 0, 0, 1, '2024-05-23 03:21:38'),
(40, 5.00, 0, 0, 1, '2024-05-23 03:22:37'),
(41, 5.00, 0, 0, 1, '2024-05-23 03:23:37'),
(42, 6.00, 0, 0, 1, '2024-05-23 03:24:38'),
(43, 8.00, 0, 0, 1, '2024-05-23 03:25:41'),
(44, 7.00, 0, 0, 1, '2024-05-23 03:26:39'),
(45, 7.00, 0, 0, 1, '2024-05-23 03:27:40'),
(46, 8.00, 0, 0, 1, '2024-05-23 03:28:40'),
(47, 7.00, 0, 0, 1, '2024-05-23 03:29:41'),
(48, 6.00, 0, 0, 1, '2024-05-23 03:30:42'),
(49, 7.00, 0, 0, 1, '2024-05-23 03:31:42'),
(50, 6.00, 0, 0, 1, '2024-05-23 03:32:43'),
(51, 8.00, 0, 0, 1, '2024-05-23 03:33:43'),
(52, 8.00, 0, 0, 1, '2024-05-23 03:34:44'),
(53, 8.00, 0, 0, 1, '2024-05-23 03:35:45'),
(54, 8.00, 0, 0, 1, '2024-05-23 03:36:45'),
(55, 6.00, 0, 0, 1, '2024-05-23 03:37:46'),
(56, 8.00, 0, 0, 1, '2024-05-23 03:38:46'),
(57, 6.00, 0, 0, 1, '2024-05-23 03:39:47'),
(58, 6.00, 0, 0, 1, '2024-05-23 03:40:47'),
(59, 7.00, 0, 0, 1, '2024-05-23 03:42:17'),
(60, 7.00, 0, 0, 1, '2024-05-23 03:43:17'),
(61, 6.00, 0, 0, 1, '2024-05-23 03:44:17'),
(62, 7.00, 0, 0, 1, '2024-05-23 03:45:18'),
(63, 2.00, 0, 0, 1, '2024-05-23 03:54:57'),
(64, 1.00, 0, 0, 1, '2024-05-23 03:55:57'),
(65, 2.00, 0, 0, 1, '2024-05-23 03:56:57'),
(66, 2.00, 0, 0, 1, '2024-05-23 03:57:58'),
(67, 20.00, 0, 0, 1, '2024-05-23 03:59:16'),
(68, 20.00, 0, 1, 1, '2024-05-23 04:00:17'),
(69, 16.00, 0, 0, 1, '2024-05-23 11:04:34'),
(70, 11.00, 0, 0, 1, '2024-05-23 15:45:26'),
(71, 16.00, 0, 0, 1, '2024-05-23 15:46:23'),
(72, 15.00, 0, 0, 1, '2024-05-23 15:47:24'),
(73, 11.00, 0, 0, 4, '2024-05-23 17:56:03'),
(74, 21.00, 1, 0, 4, '2024-05-23 17:57:04'),
(75, 18.00, 0, 0, 4, '2024-05-24 06:03:40'),
(76, 16.00, 0, 0, 4, '2024-05-24 06:04:39'),
(77, 14.00, 0, 0, 4, '2024-05-24 06:05:40'),
(78, 13.00, 0, 0, 4, '2024-05-24 06:07:20'),
(79, 12.00, 0, 0, 4, '2024-05-24 06:08:21'),
(80, 9.00, 0, 0, 4, '2024-05-24 06:21:49'),
(81, 9.00, 0, 0, 4, '2024-05-24 06:22:49'),
(82, 6.00, 1, 0, 4, '2024-05-24 06:36:21'),
(83, 7.00, 1, 0, 4, '2024-05-24 06:37:21'),
(84, 7.00, 1, 0, 4, '2024-05-24 06:38:22'),
(85, 5.00, 1, 0, 4, '2024-05-24 06:39:23'),
(86, 4.00, 1, 0, 4, '2024-05-24 06:40:22'),
(87, 8.00, 0, 0, 4, '2024-05-24 06:46:09'),
(88, 4.00, 1, 0, 4, '2024-05-24 06:47:06'),
(89, 5.00, 0, 0, 4, '2024-05-24 06:48:07'),
(90, 3.00, 0, 0, 4, '2024-05-24 06:49:07'),
(91, 4.00, 0, 0, 4, '2024-05-24 06:50:07'),
(92, 5.00, 0, 0, 4, '2024-05-24 06:51:08'),
(93, 4.00, 0, 0, 4, '2024-05-24 06:52:08'),
(94, 3.00, 0, 0, 4, '2024-05-24 06:53:09'),
(95, 4.00, 0, 0, 4, '2024-05-24 06:54:10'),
(96, 3.00, 0, 0, 4, '2024-05-24 06:55:10'),
(97, 4.00, 1, 1, 4, '2024-05-24 07:00:13'),
(98, 5.00, 0, 1, 4, '2024-05-24 07:01:13'),
(99, 3.00, 0, 0, 4, '2024-05-24 07:02:13'),
(100, 5.00, 0, 0, 4, '2024-05-24 07:03:13'),
(101, 5.00, 0, 0, 4, '2024-05-24 07:04:14'),
(102, 25.00, 0, 0, 4, '2024-05-24 07:09:51'),
(103, 22.00, 0, 0, 4, '2024-05-24 07:10:51'),
(104, 20.00, 0, 0, 4, '2024-05-24 07:11:51'),
(105, 17.00, 0, 0, 4, '2024-05-24 07:12:52'),
(106, 17.00, 0, 0, 4, '2024-05-24 07:13:53'),
(107, 16.00, 0, 0, 4, '2024-05-24 07:15:57'),
(108, 15.00, 0, 0, 4, '2024-05-24 07:16:55'),
(109, 16.00, 0, 0, 4, '2024-05-24 07:17:56'),
(110, 17.00, 0, 0, 4, '2024-05-24 07:18:56'),
(111, 16.00, 0, 0, 4, '2024-05-24 07:19:57'),
(112, 14.00, 0, 0, 4, '2024-05-24 07:20:58'),
(113, 14.00, 0, 0, 4, '2024-05-24 07:21:58'),
(114, 14.00, 0, 0, 4, '2024-05-24 07:22:58'),
(115, 14.00, 0, 0, 4, '2024-05-24 07:23:59'),
(116, 15.00, 0, 0, 4, '2024-05-24 07:24:59'),
(117, 15.00, 1, 0, 4, '2024-05-24 07:26:00'),
(118, 16.00, 1, 0, 4, '2024-05-24 07:27:00'),
(119, 16.00, 1, 0, 4, '2024-05-24 07:28:01'),
(120, 17.00, 1, 0, 4, '2024-05-24 07:29:02'),
(121, 16.00, 0, 1, 4, '2024-05-24 07:30:02'),
(122, 17.00, 0, 1, 4, '2024-05-24 07:32:03'),
(123, 17.00, 0, 1, 4, '2024-05-24 07:33:02'),
(124, 17.00, 0, 1, 4, '2024-05-24 07:34:03'),
(125, 17.00, 0, 1, 4, '2024-05-24 07:35:04'),
(126, 17.00, 0, 1, 4, '2024-05-24 07:36:04'),
(127, 16.00, 0, 0, 4, '2024-05-24 07:37:06'),
(128, 16.00, 0, 0, 4, '2024-05-24 07:38:07'),
(129, 17.00, 0, 0, 4, '2024-05-24 07:39:07'),
(130, 16.00, 0, 0, 4, '2024-05-24 07:40:08'),
(131, 16.00, 0, 1, 4, '2024-05-24 07:41:08'),
(132, 17.00, 0, 1, 4, '2024-05-24 07:42:09'),
(133, 18.00, 0, 1, 4, '2024-05-24 07:43:09'),
(134, 17.00, 0, 0, 4, '2024-05-24 07:44:10'),
(135, 19.00, 0, 0, 4, '2024-05-24 07:45:10'),
(136, 11.00, 0, 0, 4, '2024-05-24 07:46:11'),
(137, 12.00, 0, 0, 4, '2024-05-24 07:47:10'),
(138, 12.00, 0, 0, 4, '2024-05-24 07:48:11'),
(139, 11.00, 0, 1, 4, '2024-05-24 07:49:13'),
(140, 15.00, 0, 0, 4, '2024-05-24 07:52:43'),
(141, 14.00, 0, 1, 4, '2024-05-24 07:53:44'),
(142, 13.00, 0, 0, 4, '2024-05-24 07:54:44'),
(143, 13.00, 0, 0, 4, '2024-05-24 07:55:45'),
(144, 14.00, 0, 0, 4, '2024-05-24 07:56:47'),
(145, 14.00, 0, 0, 4, '2024-05-24 07:57:46'),
(146, 14.00, 0, 0, 4, '2024-05-24 07:58:47'),
(147, 14.00, 0, 0, 4, '2024-05-24 07:59:48'),
(148, 16.00, 0, 0, 4, '2024-05-24 08:00:48'),
(149, 15.00, 0, 0, 4, '2024-05-24 08:01:51'),
(150, 15.00, 0, 0, 4, '2024-05-24 08:02:49'),
(151, 15.00, 0, 0, 4, '2024-05-24 08:03:50'),
(152, 16.00, 0, 0, 4, '2024-05-24 08:04:50'),
(153, 16.00, 0, 0, 4, '2024-05-24 08:05:51'),
(154, 16.00, 0, 0, 4, '2024-05-24 08:06:52'),
(155, 16.00, 0, 0, 4, '2024-05-24 08:07:52'),
(156, 16.00, 0, 0, 4, '2024-05-24 08:08:53'),
(157, 16.00, 0, 0, 4, '2024-05-24 08:09:54'),
(158, 16.00, 0, 0, 4, '2024-05-24 08:10:55'),
(159, 15.00, 0, 0, 4, '2024-05-24 08:11:57'),
(160, 15.00, 0, 0, 4, '2024-05-24 08:12:56'),
(161, 15.00, 0, 0, 4, '2024-05-24 08:13:56'),
(162, 17.00, 0, 0, 4, '2024-05-24 08:14:57'),
(163, 16.00, 0, 0, 4, '2024-05-24 08:15:57'),
(164, 15.00, 0, 0, 4, '2024-05-24 08:16:58'),
(165, 15.00, 0, 0, 4, '2024-05-24 08:17:58'),
(166, 16.00, 0, 0, 4, '2024-05-24 08:18:59'),
(167, 15.00, 0, 0, 4, '2024-05-24 08:19:59'),
(168, 18.00, 0, 0, 4, '2024-05-24 08:20:59'),
(169, 16.00, 0, 0, 4, '2024-05-24 08:22:00'),
(170, 15.00, 0, 0, 4, '2024-05-24 08:23:00'),
(171, 15.00, 0, 0, 4, '2024-05-24 08:24:01'),
(172, 15.00, 0, 0, 4, '2024-05-24 08:25:02'),
(173, 16.00, 0, 0, 4, '2024-05-24 08:26:02'),
(174, 16.00, 0, 0, 4, '2024-05-24 08:27:03'),
(175, 17.00, 0, 0, 4, '2024-05-24 08:28:03'),
(176, 16.00, 0, 0, 4, '2024-05-24 08:29:07'),
(177, 16.00, 0, 0, 4, '2024-05-24 08:30:04'),
(178, 17.00, 0, 0, 4, '2024-05-24 08:31:05'),
(179, 16.00, 0, 0, 4, '2024-05-24 08:32:04'),
(180, 17.00, 0, 0, 4, '2024-05-24 08:33:07'),
(181, 17.00, 0, 0, 4, '2024-05-24 08:34:06'),
(182, 16.00, 0, 0, 4, '2024-05-24 08:35:06'),
(183, 17.00, 0, 0, 4, '2024-05-24 08:36:07'),
(184, 18.00, 0, 0, 4, '2024-05-24 08:37:06'),
(185, 17.00, 0, 0, 4, '2024-05-24 08:38:07'),
(186, 17.00, 0, 0, 4, '2024-05-24 08:39:08'),
(187, 18.00, 0, 0, 4, '2024-05-24 08:40:09'),
(188, 16.00, 0, 0, 4, '2024-05-24 08:41:10'),
(189, 15.00, 0, 0, 4, '2024-05-24 08:42:10'),
(190, 15.00, 0, 0, 4, '2024-05-24 08:43:13'),
(191, 16.00, 0, 0, 4, '2024-05-24 08:44:16'),
(192, 16.00, 0, 0, 4, '2024-05-24 08:45:12'),
(193, 15.00, 0, 0, 4, '2024-05-24 08:46:12'),
(194, 17.00, 0, 0, 4, '2024-05-24 08:47:12'),
(195, 16.00, 0, 0, 4, '2024-05-24 08:48:13'),
(196, 16.00, 0, 0, 4, '2024-05-24 08:49:14'),
(197, 16.00, 0, 0, 4, '2024-05-24 08:50:15'),
(198, 16.00, 0, 0, 4, '2024-05-24 08:51:15'),
(199, 15.00, 0, 0, 4, '2024-05-24 08:52:16'),
(200, 16.00, 0, 0, 4, '2024-05-24 08:53:17'),
(201, 16.00, 0, 0, 4, '2024-05-24 08:54:17'),
(202, 16.00, 0, 0, 4, '2024-05-24 08:55:18'),
(203, 16.00, 0, 0, 4, '2024-05-24 08:56:19'),
(204, 16.00, 0, 0, 4, '2024-05-24 08:57:19'),
(205, 17.00, 0, 0, 4, '2024-05-24 08:58:19'),
(206, 15.00, 0, 0, 4, '2024-05-24 08:59:20'),
(207, 16.00, 0, 0, 4, '2024-05-24 09:00:20'),
(208, 16.00, 0, 0, 4, '2024-05-24 09:01:21'),
(209, 16.00, 0, 0, 4, '2024-05-24 09:02:21'),
(210, 16.00, 0, 0, 4, '2024-05-24 09:03:22'),
(211, 25.00, 0, 0, 4, '2024-05-24 09:17:37'),
(212, 19.00, 1, 0, 4, '2024-05-24 09:18:37'),
(213, 15.00, 1, 0, 4, '2024-05-24 09:19:38'),
(214, 16.00, 1, 0, 4, '2024-05-24 09:20:39'),
(215, 16.00, 1, 0, 4, '2024-05-24 09:21:39'),
(216, 14.00, 0, 0, 4, '2024-05-24 09:22:40'),
(217, 16.00, 1, 0, 4, '2024-05-24 09:23:40'),
(218, 16.00, 1, 0, 4, '2024-05-24 09:24:41'),
(219, 15.00, 1, 0, 4, '2024-05-24 09:25:41'),
(220, 16.00, 1, 0, 4, '2024-05-24 09:26:42'),
(221, 15.00, 1, 0, 4, '2024-05-24 09:27:42'),
(222, 15.00, 0, 0, 4, '2024-05-24 09:28:43'),
(223, 15.00, 1, 0, 4, '2024-05-24 09:29:43'),
(224, 15.00, 1, 0, 4, '2024-05-24 09:30:43'),
(225, 14.00, 1, 0, 4, '2024-05-24 09:31:44'),
(226, 14.00, 1, 0, 4, '2024-05-24 09:32:45'),
(227, 13.00, 1, 0, 4, '2024-05-24 09:33:46'),
(228, 14.00, 0, 0, 4, '2024-05-24 09:34:46'),
(229, 13.00, 1, 0, 4, '2024-05-24 09:35:47'),
(230, 12.00, 1, 0, 4, '2024-05-24 09:47:07'),
(231, 6.00, 1, 0, 4, '2024-05-24 09:48:07'),
(232, 6.00, 1, 0, 4, '2024-05-24 09:49:08'),
(233, 8.00, 1, 0, 4, '2024-05-24 09:50:08'),
(234, 7.00, 1, 0, 4, '2024-05-24 09:51:09'),
(235, 6.00, 0, 0, 4, '2024-05-24 09:52:10'),
(236, 5.00, 1, 0, 4, '2024-05-24 09:53:09'),
(237, 6.00, 1, 0, 4, '2024-05-24 09:54:10'),
(238, 6.00, 1, 0, 4, '2024-05-24 09:55:11'),
(239, 7.00, 1, 0, 4, '2024-05-24 09:56:11'),
(240, 6.00, 1, 0, 4, '2024-05-24 09:57:12'),
(241, 9.00, 0, 0, 4, '2024-05-24 09:58:13'),
(242, 7.00, 1, 0, 4, '2024-05-24 09:59:14'),
(243, 5.00, 0, 0, 4, '2024-05-27 11:10:38'),
(244, 92.00, 1, 0, 4, '2024-05-27 11:11:39'),
(245, 100.00, 1, 0, 4, '2024-05-27 11:12:39'),
(246, 90.00, 1, 0, 4, '2024-05-27 11:13:39'),
(247, 93.00, 1, 0, 4, '2024-05-27 11:14:40'),
(248, 100.00, 1, 0, 4, '2024-05-27 11:15:40'),
(291, 100.00, 0, 0, 1, '2024-05-27 12:37:38'),
(292, 100.00, 1, 0, 1, '2024-05-27 12:38:40'),
(293, 100.00, 1, 0, 1, '2024-05-27 12:39:38'),
(294, 96.00, 0, 0, 1, '2024-05-27 12:55:00'),
(295, 100.00, 1, 1, 1, '2024-05-27 12:56:00'),
(296, 100.00, 1, 1, 1, '2024-05-27 12:57:02'),
(297, 100.00, 1, 1, 1, '2024-05-27 12:58:02'),
(298, 9.00, 0, 0, 1, '2024-05-27 15:17:01'),
(299, 43.00, 0, 0, 1, '2024-05-27 15:20:09'),
(300, 25.00, 0, 0, 1, '2024-05-27 15:30:46'),
(301, 25.00, 0, 0, 1, '2024-05-27 15:35:57');

-- --------------------------------------------------------

--
-- Struktur dari tabel `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `username` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `captcha` int(11) DEFAULT NULL,
  `is_admin` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data untuk tabel `users`
--

INSERT INTO `users` (`id`, `name`, `username`, `email`, `email_verified_at`, `password`, `remember_token`, `created_at`, `updated_at`, `captcha`, `is_admin`) VALUES
(1, 'Admin', 'Admin', 'admin@gmail.com', NULL, '$2y$10$qbR5zyb7qRjoxxLbS7mBnO5UDTsMLstznYvAMbq7fNSDrBoBd4Mei', NULL, '2024-05-22 12:55:03', '2024-05-22 12:55:03', NULL, 1),
(2, 'lutfi', 'lutfi', 'eboost31@gmail.com', NULL, '$2y$10$orB4ZYndbdyPoY4rnsC0W.yfVXr7eqsJNq7yxoXbeQaw0E0wjfV52', NULL, '2024-05-23 04:03:44', '2024-05-23 04:03:44', NULL, 0),
(3, 'Nelsen Ardiansah', 'Nelsena59', 'nelsena59@gmail.com', NULL, '$2y$10$yeys0.kq21oCoRqDSYswnudq0iGloWXX6PtfeyYKn9.mWIINkqkVa', NULL, '2024-05-29 09:40:26', '2024-05-29 09:40:26', NULL, 0);

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indeks untuk tabel `kebuns`
--
ALTER TABLE `kebuns`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kebuns_user_id_foreign` (`user_id`);

--
-- Indeks untuk tabel `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indeks untuk tabel `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indeks untuk tabel `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indeks untuk tabel `sensors`
--
ALTER TABLE `sensors`
  ADD PRIMARY KEY (`id`),
  ADD KEY `kebun_id` (`kebun_id`);

--
-- Indeks untuk tabel `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_username_unique` (`username`),
  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 `kebuns`
--
ALTER TABLE `kebuns`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT untuk tabel `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT untuk tabel `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT untuk tabel `sensors`
--
ALTER TABLE `sensors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=302;

--
-- AUTO_INCREMENT untuk tabel `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- Ketidakleluasaan untuk tabel pelimpahan (Dumped Tables)
--

--
-- Ketidakleluasaan untuk tabel `kebuns`
--
ALTER TABLE `kebuns`
  ADD CONSTRAINT `kebuns_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Ketidakleluasaan untuk tabel `sensors`
--
ALTER TABLE `sensors`
  ADD CONSTRAINT `sensors_kebun_id_foreign` FOREIGN KEY (`kebun_id`) REFERENCES `kebuns` (`id`) ON DELETE CASCADE;
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 */;
