X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fdb_62.sql;fp=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fdb_62.sql;h=279400d660851be6c60f157037741ee40bfb7d40;hp=6ac5f7c1a0e2205d3939e301a42a9a40231e8711;hb=6feef1914b603d426eadd5ade48d7f2e434d8395;hpb=e3b4323496082b3675b96e646e9db1938bd7069a 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