let SQL revision files control the transaction

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

diff --git a/app/src/main/res/raw/sql_49.sql b/app/src/main/res/raw/sql_49.sql
index 3d7ba4972acddbbef17cc8da4bd1e28e0e31e26e..549c4a48800638b6a911f2af3bf06b75fdb1987d 100644 (file)
--- a/app/src/main/res/raw/sql_49.sql
+++ b/app/src/main/res/raw/sql_49.sql
@@ -1,4 +1,4 @@
--- Copyright © 2020 Damyan Ivanov.
+-- Copyright © 2021 Damyan Ivanov.
 -- This file is part of MoLe.
 -- MoLe is free software: you can distribute it and/or modify it
 -- under the term of the GNU General Public License as published by
@@ -15,9 +15,13 @@
 
 pragma foreign_keys=off;
 
+BEGIN TRANSACTION;
+
 create table currencies_new(id integer not null primary key, name varchar not null, position varchar not null, has_gap integer not null);
 insert into currencies_new(id, name, position, has_gap) select id, name, position, has_gap from currencies;
 
 drop table currencies;
 
 alter table currencies_new rename to currencies;
+
+COMMIT TRANSACTION;
\ No newline at end of file