db 62: remove duplicate currency entries before creating unique index

[mobile-ledger.git] / app / src / main / res / raw / db_62.sql

diff --git a/app/src/main/res/raw/db_62.sql b/app/src/main/res/raw/db_62.sql
index c62609d8402bace3993488e6a50438a5e0a51ccb..6ac5f7c1a0e2205d3939e301a42a9a40231e8711 100644 (file)
--- 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