-- 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 );