]> git.ktnx.net Git - mobile-ledger-staging.git/blobdiff - app/src/main/res/raw/sql_30.sql
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
@@ -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