-- drop table soil_monitor;

create table soil_monitor(
    id              integer     not null primary key autoincrement,
    bt_device       integer     not null references bt_device(id),
    last_value      integer,
    warning_level   integer     not null
);
