From 05b209dd724acddc9e4c4575817565c15a2fb6b5 Mon Sep 17 00:00:00 2001 From: Damyan Ivanov Date: Mon, 18 Mar 2019 11:12:36 +0200 Subject: [PATCH] remove all data belonging to previously deleted accounts --- app/src/main/res/raw/sql_20.sql | 4 ++++ 1 file changed, 4 insertions(+) create mode 100644 app/src/main/res/raw/sql_20.sql 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 -- 2.39.5