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