X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fsql_20.sql;fp=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fsql_20.sql;h=0485520252f4d6b928bd4499b2a001de46127142;hb=05b209dd724acddc9e4c4575817565c15a2fb6b5;hp=0000000000000000000000000000000000000000;hpb=0b812fde751e862323d8bdb66e34f00543e9d742;p=mobile-ledger.git

diff --git a/app/src/main/res/raw/sql_20.sql b/app/src/main/res/raw/sql_20.sql
new file mode 100644
index 00000000..04855202
--- /dev/null
+++ b/app/src/main/res/raw/sql_20.sql
@@ -0,0 +1,4 @@
+delete from accounts where not exists (select 1 from profiles where uuid = profile);
+delete from account_values where not exists (select 1 from profiles where uuid = profile);
+delete from transactions where not exists (select 1 from profiles where uuid = profile);
+delete from transaction_accounts where not exists (select 1 from profiles where uuid = profile);
\ No newline at end of file