summaryrefslogtreecommitdiff
path: root/database/create_table.sql
diff options
context:
space:
mode:
authorLuiz Gustavo Monteiro <luizgu_mreis@hotmail.com>2025-10-20 21:06:44 -0300
committerLuiz Gustavo Monteiro <luizgu_mreis@hotmail.com>2025-10-20 21:06:44 -0300
commit370d3014ebf95e0c422a3ea2b39d568d66eb326e (patch)
treeb008bca11ca270ec461051b9bc6a5c9c39a9cc9f /database/create_table.sql
parentea698a5c77702684fbebf89db9ba6f8071f2df5b (diff)
Postgres Conteiner Settings
Diffstat (limited to 'database/create_table.sql')
-rw-r--r--database/create_table.sql6
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