1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25
| CREATE TABLE `SensorDataTHP` (
`id` int(6) UNSIGNED NOT NULL,
`sensor` varchar(30) NOT NULL,
`TEMP` decimal(6,2) DEFAULT NULL,
`HUM` decimal(6,2) DEFAULT NULL,
`PRES` decimal(6,2) DEFAULT NULL,
`TEMPR` decimal(6,2) DEFAULT NULL,
`reading_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Déchargement des données de la table `SensorDataTHP`
--
INSERT INTO `SensorDataTHP` (`id`, `sensor`, `TEMP`, `HUM`, `PRES`, `TEMPR`, `reading_time`) VALUES
(3, 'THP', 17.24, 66.41, 1014.15, 16.89, '2023-12-23 15:16:48'),
(4, 'THP', 17.28, 66.16, 1014.08, 16.89, '2023-12-23 15:18:51'),
(5, 'THP', 17.38, 65.99, 1014.07, 16.99, '2023-12-23 15:21:51'),
(6, 'THP', 17.23, 65.97, 1014.03, 16.99, '2023-12-23 15:22:21'),
(7, 'THP', 17.41, 65.68, 1014.05, 16.99, '2023-12-23 15:24:26'),
(8, 'THP', 17.48, 65.24, 1014.11, 17.09, '2023-12-23 15:26:28'),
(9, 'THP', 17.50, 65.04, 1014.11, 17.08, '2023-12-23 15:29:29'),
(10, 'THP', 25.00, 12.00, 15.00, 2.00, '2023-12-23 15:31:24'),
(11, 'THP', 17.52, 65.03, 1014.15, 17.08, '2023-12-23 15:31:31'),
(12, 'THP', 17.54, 64.83, 1014.19, 17.08, '2023-12-23 15:34:34'); |
Partager