delete stray options of already removed profiles

[mobile-ledger-staging.git] / app / src / main / res / raw / sql_30.sql

diff --git a/app/src/main/res/raw/sql_30.sql b/app/src/main/res/raw/sql_30.sql
new file mode 100644 (file)
index 0000000..c82adf8
--- /dev/null
+++ b/app/src/main/res/raw/sql_30.sql
@@ -0,0 +1 @@
+delete from options where profile <> '-' and not exists (select 1 from profiles p where p.uuid=options.profile);
\ No newline at end of file