From e9f3d47100fd5f61342af0a6f8e1abbe3bea9093 Mon Sep 17 00:00:00 2001
From: Luiz Gustavo Monteiro <luizgu_mreis@hotmail.com>
Date: Sun, 26 Oct 2025 14:36:11 -0300
Subject: Added database model

---
 database/init_scripts/create_table.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)

(limited to 'database/init_scripts/create_table.sql')

diff --git a/database/init_scripts/create_table.sql b/database/init_scripts/create_table.sql
index 8ee801a..ae5b3d1 100644
--- a/database/init_scripts/create_table.sql
+++ b/database/init_scripts/create_table.sql
@@ -1,3 +1,18 @@
+create table if not exists station (
+   id                integer,
+   name              varchar(100),
+   locationid        int null,
+   installation_date date
+);
+
+create table if not exists climameasures (
+   stationname  varchar(255),
+   measurevalue int null,
+   unit         float null,
+   currenttime  timestamp default current_timestamp
+);
+
+
 create table if not exists climameasures (
    stationname  varchar(255),
    measurevalue int null,
-- 
cgit v1.2.3

