-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Waktu pembuatan: 07 Agu 2024 pada 12.41
-- Versi server: 10.4.22-MariaDB
-- Versi PHP: 7.4.26

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

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

--
-- Struktur dari tabel `data_sensor`
--

CREATE TABLE `data_sensor` (
  `id` int(11) NOT NULL,
  `suhu` varchar(255) NOT NULL,
  `kelembapan` varchar(255) NOT NULL,
  `pH` varchar(255) NOT NULL,
  `waktu` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data untuk tabel `data_sensor`
--

INSERT INTO `data_sensor` (`id`, `suhu`, `kelembapan`, `pH`, `waktu`) VALUES
(1, '25.12', '66', '6.00', '2024-07-15 01:35:20'),
(2, '25.12', '66', '6.00', '2024-07-15 01:35:27'),
(3, '25.06', '65', '6.00', '2024-07-15 01:35:29'),
(4, '25.12', '67', '6.00', '2024-07-15 01:35:34'),
(5, '25.12', '65', '6.00', '2024-07-15 01:35:34'),
(6, '25.12', '65', '6.00', '2024-07-15 01:35:40'),
(7, '25.12', '65', '6.00', '2024-07-15 01:35:47'),
(8, '25.12', '65', '6.00', '2024-07-15 01:35:53'),
(9, '25.12', '65', '6.00', '2024-07-15 01:35:59'),
(10, '25.12', '65', '6.00', '2024-07-15 01:36:05'),
(11, '25.12', '65', '6.00', '2024-07-15 01:36:11'),
(12, '25.12', '65', '6.00', '2024-07-15 01:36:18'),
(13, '25.12', '65', '6.00', '2024-07-15 01:36:24'),
(14, '25.06', '65', '6.00', '2024-07-15 01:36:34'),
(15, '25.19', '65', '6.00', '2024-07-16 02:40:13'),
(16, '25.25', '65', '6.00', '2024-07-16 02:40:20'),
(17, '25.19', '65', '6.00', '2024-07-16 02:40:27'),
(18, '25.19', '65', '6.00', '2024-07-16 02:40:33'),
(19, '25.19', '65', '7.00', '2024-07-16 02:40:39'),
(20, '25.25', '65', '7.00', '2024-07-16 02:40:45'),
(21, '25.19', '65', '7.00', '2024-07-16 02:40:51'),
(22, '25.19', '65', '7.00', '2024-07-16 02:40:57'),
(23, '25.44', '60', '7.00', '2024-07-17 04:13:03'),
(24, '25.44', '60', '7.00', '2024-07-17 04:13:09'),
(25, '25.50', '60', '7.00', '2024-07-17 04:13:15'),
(26, '25.44', '60', '7.00', '2024-07-17 04:13:21'),
(27, '25.50', '60', '7.00', '2024-07-17 04:13:27'),
(28, '25.50', '60', '7.00', '2024-07-17 04:13:32'),
(29, '25.44', '60', '7.00', '2024-07-17 04:13:38'),
(30, '25.50', '60', '7.00', '2024-07-17 04:13:44'),
(31, '25.50', '59', '7.00', '2024-07-17 04:13:51'),
(32, '25.50', '59', '7.00', '2024-07-17 04:13:57'),
(33, '25.50', '59', '7.00', '2024-07-17 04:14:03'),
(34, '25.50', '59', '7.00', '2024-07-17 04:14:09'),
(35, '25.50', '59', '7.00', '2024-07-17 04:14:14'),
(36, '25.50', '59', '7.00', '2024-07-17 04:14:21'),
(37, '25.50', '59', '7.00', '2024-07-17 04:14:26'),
(38, '25.50', '59', '7.00', '2024-07-17 04:14:32'),
(39, '26.44', '64', '6.00', '2024-07-18 08:43:04'),
(40, '26.44', '63', '7.00', '2024-07-18 08:43:10'),
(41, '26.44', '63', '7.00', '2024-07-18 08:43:16'),
(42, '26.44', '63', '7.00', '2024-07-18 08:43:23'),
(43, '26.44', '63', '7.00', '2024-07-18 08:43:29'),
(44, '26.44', '63', '7.00', '2024-07-18 08:43:35'),
(45, '26.44', '63', '7.00', '2024-07-18 08:43:41'),
(46, '26.44', '63', '7.00', '2024-07-18 08:43:47'),
(47, '26.44', '63', '7.00', '2024-07-18 08:43:54'),
(48, '26.62', '65', '6.00', '2024-07-19 10:10:14'),
(49, '26.62', '64', '6.00', '2024-07-19 10:10:29'),
(50, '26.62', '64', '6.00', '2024-07-19 10:10:32'),
(51, '26.62', '64', '6.00', '2024-07-19 10:10:41'),
(52, '26.62', '63', '6.00', '2024-07-19 10:10:50'),
(55, '25.50', '64', '7.00', '2024-07-20 00:12:36'),
(56, '25.50', '65', '6.5', '2024-07-20 01:19:42'),
(57, '25.50', '64', '7.00', '2024-07-20 00:12:47'),
(58, '25.50', '64', '7.00', '2024-07-20 00:12:54'),
(59, '25.50', '64', '7.00', '2024-07-20 00:13:00'),
(60, '25.50', '67', '7.00', '2024-07-21 01:21:19'),
(61, '25.56', '68', '7.00', '2024-07-21 01:21:25'),
(62, '25.50', '68', '7.00', '2024-07-21 01:21:32'),
(63, '25.50', '67', '7.00', '2024-07-21 01:21:38');

--
-- Indexes for dumped tables
--

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

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `data_sensor`
--
ALTER TABLE `data_sensor`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;
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 */;