CREATE DATABASE environment;

USE environment;

CREATE TABLE environment_data (
    id INT AUTO_INCREMENT PRIMARY KEY,
    humidity FLOAT NOT NULL,
    temperature FLOAT NOT NULL,
    recorded_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
