From 6feef1914b603d426eadd5ade48d7f2e434d8395 Mon Sep 17 00:00:00 2001 From: Damyan Ivanov Date: Thu, 23 Sep 2021 16:25:16 +0000 Subject: [PATCH] fix db_62.sql (SQL syntax error) --- app/src/main/res/raw/db_62.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/app/src/main/res/raw/db_62.sql b/app/src/main/res/raw/db_62.sql index 6ac5f7c1..279400d6 100644 --- a/app/src/main/res/raw/db_62.sql +++ b/app/src/main/res/raw/db_62.sql @@ -23,7 +23,7 @@ pragma foreign_keys = on; begin transaction; -delete from currencies c +delete from currencies where id not in (select min(id) from currencies group by name); create unique index currency_name_idx on currencies(name); \ No newline at end of file -- 2.39.2