rendered paste body-- phpMyAdmin SQL Dump-- version 5.2.1-- https://www.phpmyadmin.net/---- Host: 127.0.0.1-- Tempo de geração: 02/09/2026 às 01:45-- Versão do servidor: 10.4.32-MariaDB-- Versão do PHP: 8.2.12-- Original em: github.com/Xirgola/MedidorTemperaturaUmidade/blob/main/estacao_meteo.sqlSET 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 */;---- Banco de dados: `estacao_meteo`---- ------------------------------------------------------------ Estrutura para tabela `leituras`--CREATE TABLE `leituras` ( `id` int(11) NOT NULL, `temperatura` decimal(5,2) NOT NULL, `umidade` decimal(5,2) NOT NULL, `status` varchar(20) NOT NULL, `criado_em` timestamp NOT NULL DEFAULT current_timestamp()) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;---- Despejando dados para a tabela `leituras`--INSERT INTO `leituras` (`id`, `temperatura`, `umidade`, `status`, `criado_em`) VALUES(1, 24.10, 71.00, 'ALERTA', '2026-09-01 23:13:22'),(2, 24.10, 69.00, 'ALERTA', '2026-09-01 23:13:52'),(3, 23.80, 69.00, 'ALERTA', '2026-09-01 23:14:23'),(4, 23.80, 69.00, 'ALERTA', '2026-09-01 23:14:53'),(5, 23.80, 71.00, 'ALERTA', '2026-09-01 23:15:24'),(6, 24.20, 85.00, 'ALERTA', '2026-09-01 23:15:54'),(7, 25.30, 79.00, 'ALERTA', '2026-09-01 23:16:25'),(8, 25.30, 73.00, 'ALERTA', '2026-09-01 23:16:55'),(9, 24.80, 72.00, 'ALERTA', '2026-09-01 23:17:26'),(10, 24.80, 73.00, 'ALERTA', '2026-09-01 23:17:56'),(11, 24.80, 73.00, 'ALERTA', '2026-09-01 23:18:27'),(12, 24.50, 73.00, 'ALERTA', '2026-09-01 23:18:58'),(13, 24.50, 73.00, 'ALERTA', '2026-09-01 23:19:28'),(14, 24.50, 75.00, 'ALERTA', '2026-09-01 23:19:59'),(15, 24.50, 76.00, 'ALERTA', '2026-09-01 23:20:29'),(16, 24.50, 73.00, 'ALERTA', '2026-09-01 23:21:00'),(17, 24.50, 72.00, 'ALERTA', '2026-09-01 23:21:30'),(18, 24.10, 71.00, 'ALERTA', '2026-09-01 23:22:01'),(19, 24.10, 71.00, 'ALERTA', '2026-09-01 23:22:31'),(20, 24.10, 71.00, 'ALERTA', '2026-09-01 23:23:02'),(21, 23.80, 71.00, 'ALERTA', '2026-09-01 23:23:33'),(22, 23.80, 70.00, 'ALERTA', '2026-09-01 23:24:03'),(23, 23.40, 73.00, 'ALERTA', '2026-09-01 23:29:51'),(24, 23.80, 73.00, 'ALERTA', '2026-09-01 23:30:21'),(25, 24.10, 81.00, 'ALERTA', '2026-09-01 23:30:52'),(26, 24.10, 78.00, 'ALERTA', '2026-09-01 23:31:22'),(27, 24.10, 76.00, 'ALERTA', '2026-09-01 23:31:53'),(28, 24.10, 76.00, 'ALERTA', '2026-09-01 23:32:23'),(29, 24.10, 76.00, 'ALERTA', '2026-09-01 23:32:54'),(30, 24.10, 76.00, 'ALERTA', '2026-09-01 23:33:25'),(31, 24.10, 76.00, 'ALERTA', '2026-09-01 23:33:55'),(32, 24.10, 76.00, 'ALERTA', '2026-09-01 23:34:26'),(33, 24.10, 76.00, 'ALERTA', '2026-09-01 23:34:56'),(34, 24.10, 74.00, 'ALERTA', '2026-09-01 23:35:27'),(35, 24.10, 72.00, 'ALERTA', '2026-09-01 23:35:57'),(36, 23.80, 72.00, 'ALERTA', '2026-09-01 23:36:28'),(37, 23.80, 72.00, 'ALERTA', '2026-09-01 23:36:58'),(38, 24.10, 73.00, 'ALERTA', '2026-09-01 23:37:29'),(39, 24.10, 73.00, 'ALERTA', '2026-09-01 23:38:00'),(40, 23.80, 72.00, 'ALERTA', '2026-09-01 23:38:30'),(41, 23.80, 71.00, 'ALERTA', '2026-09-01 23:39:01'),(42, 23.80, 72.00, 'ALERTA', '2026-09-01 23:39:31'),(43, 23.60, 73.00, 'ALERTA', '2026-09-01 23:40:02'),(44, 23.80, 74.00, 'ALERTA', '2026-09-01 23:40:32'),(45, 23.80, 74.00, 'ALERTA', '2026-09-01 23:41:03'),(46, 23.80, 74.00, 'ALERTA', '2026-09-01 23:41:34'),(47, 23.80, 74.00, 'ALERTA', '2026-09-01 23:42:04'),(48, 23.80, 77.00, 'ALERTA', '2026-09-01 23:42:35'),(49, 23.80, 78.00, 'ALERTA', '2026-09-01 23:43:05'),(50, 24.10, 78.00, 'ALERTA', '2026-09-01 23:43:36'),(51, 24.10, 79.00, 'ALERTA', '2026-09-01 23:44:06'),(52, 24.10, 77.00, 'ALERTA', '2026-09-01 23:44:37'),(53, 24.10, 77.00, 'ALERTA', '2026-09-01 23:45:07');---- Índices para tabelas despejadas------ Índices de tabela `leituras`--ALTER TABLE `leituras` ADD PRIMARY KEY (`id`);---- AUTO_INCREMENT para tabelas despejadas------ AUTO_INCREMENT de tabela `leituras`--ALTER TABLE `leituras` MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;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 */;