database/create_table.sql


1
2
3
4
5
6

create table if not exists climameasures (
   stationname  varchar(255),
   measurevalue int null,
   unit         float null,
   currenttime  timestamp default current_timestamp
);