1 files changed, 6 insertions, 0 deletions
diff --git a/database/create_table.sql b/database/create_table.sql
new file mode 100644
index 0000000..8ee801a
--- /dev/null
+++ b/database/create_table.sql
@@ -0,0 +1,6 @@
+create table if not exists climameasures (
+   stationname  varchar(255),
+   measurevalue int null,
+   unit         float null,
+   currenttime  timestamp default current_timestamp
+);
+\ No newline at end of file