-- phpMyAdmin SQL Dump
-- version 5.1.1deb5ubuntu1
-- https://www.phpmyadmin.net/
--
-- Hôte : localhost:3306
-- Généré le : mer. 26 mars 2025 à 18:21
-- Version du serveur : 8.0.41-0ubuntu0.22.04.1
-- Version de PHP : 8.1.2-1ubuntu2.20

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 */;

--
-- Base de données : `service.temperature`
--

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

--
-- Structure de la table `temperature`
--

CREATE TABLE `temperature` (
  `id` int NOT NULL,
  `moment` timestamp NOT NULL,
  `mesure` double NOT NULL,
  `capture` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Déchargement des données de la table `temperature`
--

INSERT INTO `temperature` (`id`, `moment`, `mesure`, `capture`) VALUES
(1, '2025-03-05 08:22:38', 5.5, ''),
(2, '2025-03-05 08:22:38', 7, ''),
(3, '2025-03-05 08:22:38', 10, ''),
(4, '2025-03-05 14:39:51', 4, NULL),
(5, '2025-03-18 16:57:47', 6, NULL),
(6, '2025-03-20 11:30:21', 4, NULL),
(7, '2025-03-20 12:05:16', 8, NULL),
(8, '2025-03-25 18:24:08', 35.92, NULL),
(9, '2025-03-25 18:24:08', -36.37, NULL),
(10, '2025-03-25 18:24:08', -35.92, NULL),
(11, '2025-03-25 18:24:08', -36.37, NULL),
(12, '2025-03-25 18:24:08', -35.92, NULL),
(13, '2025-03-25 18:24:08', -36.37, NULL),
(14, '2025-03-25 18:24:08', -35.92, NULL),
(15, '2025-03-25 18:24:09', -35.92, NULL),
(16, '2025-03-25 18:24:09', -36.37, NULL),
(17, '2025-03-25 18:24:09', -36.37, NULL),
(18, '2025-03-25 18:24:09', -36.37, NULL),
(19, '2025-03-25 18:24:09', -36.84, NULL),
(20, '2025-03-25 18:24:09', -36.84, NULL),
(21, '2025-03-25 18:24:09', -36.84, NULL),
(22, '2025-03-25 18:24:09', -36.37, NULL),
(23, '2025-03-25 18:24:09', -36.37, NULL),
(24, '2025-03-25 18:24:09', -35.92, NULL),
(25, '2025-03-25 18:24:09', -36.37, NULL),
(26, '2025-03-25 18:24:09', -35.92, NULL),
(27, '2025-03-25 18:24:09', -36.37, NULL),
(28, '2025-03-25 18:24:09', -35.92, NULL),
(29, '2025-03-25 18:24:09', -36.37, NULL),
(30, '2025-03-25 18:24:09', -35.92, NULL),
(31, '2025-03-25 18:24:09', -35.92, NULL),
(32, '2025-03-25 18:24:09', -36.37, NULL),
(33, '2025-03-25 18:24:09', -36.37, NULL),
(34, '2025-03-25 18:24:09', -36.37, NULL),
(35, '2025-03-25 18:24:10', -36.84, NULL),
(36, '2025-03-25 18:24:10', -36.84, NULL),
(37, '2025-03-25 18:24:10', -36.84, NULL),
(38, '2025-03-25 18:24:10', -36.37, NULL),
(39, '2025-03-25 18:24:10', -36.37, NULL),
(40, '2025-03-25 18:24:10', -35.92, NULL),
(41, '2025-03-25 18:24:10', -36.37, NULL),
(42, '2025-03-25 18:24:10', -36.37, NULL),
(43, '2025-03-25 18:24:11', -36.37, NULL),
(44, '2025-03-25 18:24:11', -35.92, NULL),
(45, '2025-03-25 18:24:12', -36.37, NULL),
(46, '2025-03-25 18:24:12', -36.37, NULL),
(47, '2025-03-25 18:24:13', -36.37, NULL),
(48, '2025-03-25 18:24:13', -36.37, NULL),
(49, '2025-03-25 18:24:14', -36.37, NULL),
(50, '2025-03-25 18:24:14', -36.84, NULL),
(51, '2025-03-25 18:24:15', -35.92, NULL),
(52, '2025-03-25 18:24:15', -36.37, NULL),
(53, '2025-03-25 18:24:16', -35.92, NULL),
(54, '2025-03-25 18:24:16', -36.37, NULL),
(55, '2025-03-25 18:24:17', -35.92, NULL),
(56, '2025-03-25 18:24:17', -36.37, NULL),
(57, '2025-03-25 18:24:18', -36.37, NULL),
(58, '2025-03-25 18:24:18', -36.37, NULL),
(59, '2025-03-25 18:24:19', -35.92, NULL),
(60, '2025-03-25 18:24:19', -36.37, NULL),
(61, '2025-03-25 18:24:20', -36.37, NULL),
(62, '2025-03-25 18:24:20', -35.92, NULL),
(63, '2025-03-25 18:24:21', -35.92, NULL),
(64, '2025-03-25 18:24:21', -35.92, NULL),
(65, '2025-03-25 18:24:22', -36.37, NULL),
(66, '2025-03-25 18:24:22', -36.37, NULL),
(67, '2025-03-25 18:24:23', -36.37, NULL),
(68, '2025-03-25 18:24:23', -36.37, NULL),
(69, '2025-03-25 18:24:24', -36.37, NULL),
(70, '2025-03-25 18:24:24', -36.37, NULL),
(71, '2025-03-25 18:24:25', -36.37, NULL),
(72, '2025-03-25 18:24:25', -36.37, NULL),
(73, '2025-03-25 18:24:26', -36.84, NULL),
(74, '2025-03-25 18:24:26', -36.37, NULL),
(75, '2025-03-25 18:24:27', -36.37, NULL),
(76, '2025-03-25 18:24:27', -35.92, NULL),
(77, '2025-03-25 18:24:28', -36.84, NULL),
(78, '2025-03-25 18:24:28', -36.37, NULL),
(79, '2025-03-25 18:24:29', -36.84, NULL),
(80, '2025-03-25 18:24:29', -36.37, NULL),
(81, '2025-03-25 18:24:30', -36.37, NULL),
(82, '2025-03-25 18:24:30', -35.92, NULL),
(83, '2025-03-25 18:24:31', -36.37, NULL),
(84, '2025-03-25 18:24:31', -36.37, NULL),
(85, '2025-03-25 18:24:32', -36.37, NULL),
(86, '2025-03-25 18:24:32', -35.92, NULL),
(87, '2025-03-25 18:24:33', -36.37, NULL),
(88, '2025-03-25 18:24:33', -36.37, NULL),
(89, '2025-03-25 18:24:34', -35.92, NULL),
(90, '2025-03-25 18:24:34', -36.37, NULL),
(91, '2025-03-25 18:24:35', -35.92, NULL),
(92, '2025-03-25 18:24:35', -36.37, NULL),
(93, '2025-03-25 18:24:36', -36.37, NULL),
(94, '2025-03-25 18:24:36', -36.37, NULL),
(95, '2025-03-25 18:24:37', -35.92, NULL),
(96, '2025-03-25 18:24:37', -36.37, NULL),
(97, '2025-03-25 18:24:38', -36.37, NULL),
(98, '2025-03-25 18:24:38', -36.37, NULL),
(99, '2025-03-25 18:24:39', -35.92, NULL),
(100, '2025-03-25 18:24:39', -36.37, NULL),
(101, '2025-03-25 18:24:40', -36.84, NULL),
(102, '2025-03-25 18:24:40', -36.37, NULL),
(103, '2025-03-25 18:24:41', -36.84, NULL),
(104, '2025-03-25 18:24:41', -36.37, NULL),
(105, '2025-03-25 18:24:42', -35.92, NULL),
(106, '2025-03-25 18:24:42', -36.37, NULL),
(107, '2025-03-25 18:24:43', -36.84, NULL),
(108, '2025-03-25 18:24:43', -36.37, NULL),
(109, '2025-03-25 18:24:44', -36.37, NULL),
(110, '2025-03-25 18:24:44', -35.92, NULL),
(111, '2025-03-25 18:24:45', -36.84, NULL),
(112, '2025-03-25 18:24:45', -36.37, NULL),
(113, '2025-03-25 18:24:46', -36.37, NULL),
(114, '2025-03-25 18:24:46', -36.37, NULL),
(115, '2025-03-25 18:24:47', -36.37, NULL),
(116, '2025-03-25 18:24:47', -36.84, NULL),
(117, '2025-03-25 18:24:48', -36.84, NULL),
(118, '2025-03-25 18:24:48', -36.37, NULL),
(119, '2025-03-25 18:24:49', -36.37, NULL),
(120, '2025-03-25 18:24:49', -36.84, NULL),
(121, '2025-03-25 18:24:50', -36.84, NULL),
(122, '2025-03-25 18:24:50', -36.37, NULL),
(123, '2025-03-25 18:24:51', -36.37, NULL),
(124, '2025-03-25 18:24:51', -36.37, NULL),
(125, '2025-03-25 18:24:52', -36.84, NULL),
(126, '2025-03-25 18:24:52', -36.37, NULL),
(127, '2025-03-25 18:24:53', -36.37, NULL),
(128, '2025-03-25 18:24:53', -36.37, NULL),
(129, '2025-03-25 18:24:54', -36.37, NULL),
(130, '2025-03-25 18:24:54', -36.37, NULL),
(131, '2025-03-25 18:24:55', -36.84, NULL),
(132, '2025-03-25 18:24:55', -36.84, NULL),
(133, '2025-03-25 18:24:56', -36.37, NULL),
(134, '2025-03-25 18:24:56', -36.37, NULL),
(135, '2025-03-25 18:24:57', -36.37, NULL),
(136, '2025-03-25 18:24:57', -36.84, NULL),
(137, '2025-03-25 18:24:58', -36.37, NULL),
(138, '2025-03-25 18:24:58', -36.84, NULL),
(139, '2025-03-25 18:24:59', -36.37, NULL),
(140, '2025-03-25 18:24:59', -36.37, NULL),
(141, '2025-03-25 18:25:00', -36.37, NULL),
(142, '2025-03-25 18:25:00', -36.37, NULL),
(143, '2025-03-25 18:25:01', -36.84, NULL),
(144, '2025-03-25 18:25:01', -36.84, NULL),
(145, '2025-03-25 18:25:02', -36.37, NULL),
(146, '2025-03-25 18:25:02', -36.37, NULL),
(147, '2025-03-25 18:25:03', -36.37, NULL),
(148, '2025-03-26 17:51:31', 30, NULL),
(149, '2025-03-26 17:51:31', 22, NULL),
(150, '2025-03-26 17:51:31', 27, NULL);

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `temperature`
--
ALTER TABLE `temperature`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `temperature`
--
ALTER TABLE `temperature`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=151;
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 */;
