summaryrefslogtreecommitdiff
path: root/database/init_scripts/create_table.sql
diff options
context:
space:
mode:
authorMatheus <matheus.guedes.mg.m@gmail.com>2025-10-21 00:11:39 -0300
committerMatheus <matheus.guedes.mg.m@gmail.com>2025-10-21 00:11:39 -0300
commitba5f30be9f69d18cbb3ffe2d00ba9cf287b77f43 (patch)
treec12b2ee5bea9387acc4aae1ddb4d20259d70ac46 /database/init_scripts/create_table.sql
parent96961e5dd15ec76e69c64ab7f3c31f6f22346e8c (diff)
fix:criação automática de tabelas
Diffstat (limited to 'database/init_scripts/create_table.sql')
-rw-r--r--database/init_scripts/create_table.sql6
1 files changed, 6 insertions, 0 deletions
diff --git a/database/init_scripts/create_table.sql b/database/init_scripts/create_table.sql
new file mode 100644
index 0000000..8ee801a
--- /dev/null
+++ b/database/init_scripts/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