← retour au collage›Modifier / dupliquer

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

#2jezsxDqJ2public / publicnouvelle version

anonyme créé 6 days ago Expire dans 19 hours 4.4 KB syntaxe: sql

Vos changements créent un nouveau collage lié à celui-ci — l’original reste intact.

nouvelle version Vos changements créent un nouveau collage lié à celui-ci — l’original reste intact.

Visibilité Fil public Accès public

Note de changement (facultatif)

Ce collage sera affiché dans le fil public. Changez la visibilité si vous voulez seulement le partager par lien.

Annuler

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