X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fdb_62.sql;h=6ac5f7c1a0e2205d3939e301a42a9a40231e8711;hp=c62609d8402bace3993488e6a50438a5e0a51ccb;hb=773a11b5e49058bf237345fbc9edb55523cbea3a;hpb=9c9c05d4e1ac40a7454e4d409817d07cf57a3aaa

diff --git a/app/src/main/res/raw/db_62.sql b/app/src/main/res/raw/db_62.sql
index c62609d8..6ac5f7c1 100644
--- a/app/src/main/res/raw/db_62.sql
+++ b/app/src/main/res/raw/db_62.sql
@@ -13,7 +13,7 @@
 -- You should have received a copy of the GNU General Public License
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 
--- migrate from revision 60 to revision 61
+-- migrate from revision 61 to revision 62
 
 -- pragmas need to be outside of transaction control
 -- foreign_keys is needed so that foreign key constraints are redirected
@@ -23,4 +23,7 @@ pragma foreign_keys = on;
 
 begin transaction;
 
+delete from currencies c
+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