X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fsql_40.sql;h=b2168179ef98e2ddc5fed401e7a03975294b9e64;hp=18a350a0f084ec0b683f2314f8591de62019c7e9;hb=81277d1635a9b15fef1614a096d94f8772e40735;hpb=3ed17d6ccfa6aba1795d77ef24167fb9ef6a9ca1 diff --git a/app/src/main/res/raw/sql_40.sql b/app/src/main/res/raw/sql_40.sql index 18a350a0..b2168179 100644 --- a/app/src/main/res/raw/sql_40.sql +++ b/app/src/main/res/raw/sql_40.sql @@ -14,4 +14,4 @@ -- along with MoLe. If not, see . pragma foreign_keys=off; delete from transaction_accounts where not exists (select 1 from accounts a where a.profile=transaction_accounts.profile and a.name=transaction_accounts.account_name); -delete from transaction_accounts where not exists (select 1 from transactions t where t.profile=transaction_accounts.profile and t.id=transaction_accounts.transaction_id); \ No newline at end of file +delete from transaction_accounts where not exists (select 1 from transactions t where t.profile=transaction_accounts.profile and t.id=transaction_accounts.transaction_id);