aboutsummaryrefslogtreecommitdiff
path: root/app/src/main/assets/db/migration/sm/V001.001__sm_baseline.sql
diff options
context:
space:
mode:
Diffstat (limited to 'app/src/main/assets/db/migration/sm/V001.001__sm_baseline.sql')
-rw-r--r--app/src/main/assets/db/migration/sm/V001.001__sm_baseline.sql8
1 files changed, 8 insertions, 0 deletions
diff --git a/app/src/main/assets/db/migration/sm/V001.001__sm_baseline.sql b/app/src/main/assets/db/migration/sm/V001.001__sm_baseline.sql
new file mode 100644
index 0000000..61e8505
--- /dev/null
+++ b/app/src/main/assets/db/migration/sm/V001.001__sm_baseline.sql
@@ -0,0 +1,8 @@
+-- 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
+);