-- drop table bt_device; create table bt_device( id integer not null primary key autoincrement, address char(17) not null unique, first_seen timestamp not null, last_seen timestamp not null );