← 返回文本›编辑 / 分支

Evidência - Original em github.com/Xirgola/MedidorTemperaturaUmidade/blob/main/estacao_meteo.sql

#2jezsxDqJ2public / public新版本

匿名已创建 6 days ago 过期于 19 hours 4.4 KB 语法: sql

你的更改会创建一个链接到此文本的新文本 — 原始文本不变。

新版本 你的更改会创建一个链接到此文本的新文本 — 原始文本不变。

可见性公开动态访问 public

变更备注 (可选)

此文本会显示在公开动态中。如果只想通过链接分享，请更改可见性。

取消

-- 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.sql

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

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