1 files changed, 15 insertions, 0 deletions
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,