diff options
Diffstat (limited to 'app/src/main/assets/db/migration/bt/V001.001__baseline.sql')
-rw-r--r-- | app/src/main/assets/db/migration/bt/V001.001__baseline.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/app/src/main/assets/db/migration/bt/V001.001__baseline.sql b/app/src/main/assets/db/migration/bt/V001.001__baseline.sql new file mode 100644 index 0000000..daf84be --- /dev/null +++ b/app/src/main/assets/db/migration/bt/V001.001__baseline.sql @@ -0,0 +1,8 @@ +-- 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 +); |