From 479ae397be60069ac6cb11e4507136dff01d65da Mon Sep 17 00:00:00 2001 From: Damyan Ivanov Date: Mon, 22 Mar 2021 07:54:11 +0200 Subject: [PATCH] fix migration of transaction_accounts (attempt #N) --- app/src/main/res/raw/db_59.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/app/src/main/res/raw/db_59.sql b/app/src/main/res/raw/db_59.sql index 115f3ce9..27ad83b2 100644 --- a/app/src/main/res/raw/db_59.sql +++ b/app/src/main/res/raw/db_59.sql @@ -155,8 +155,8 @@ insert into transaction_accounts_new(transaction_id, order_no, account_name, currency, amount, comment, generation) select t.id, ta.order_no, ta.account_name, ta.currency, ta.amount, ta.comment, ta.generation from transaction_accounts ta -join profiles p in ta.profile=p.deprecated_uuid -join transactions t on ta.transaction_id = t.ledger_id and t.profile_id=p.id; +join profiles p on ta.profile=p.deprecated_uuid +join transactions_new t on ta.transaction_id = t.ledger_id and t.profile_id=p.id; drop table transaction_accounts; alter table transaction_accounts_new rename to transaction_accounts; -- 2.39.2