let SQL revision files control the transaction

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

diff --git a/app/src/main/res/raw/sql_15.sql b/app/src/main/res/raw/sql_15.sql
index 8ce967c55d07c6ec3877c587493db6cca1c809fe..d134676c3f16a932a2a2fe6fd647693ae8b78bc6 100644 (file)
--- a/app/src/main/res/raw/sql_15.sql
+++ b/app/src/main/res/raw/sql_15.sql
@@ -13,6 +13,8 @@
 -- You should have received a copy of the GNU General Public License
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 
+BEGIN TRANSACTION;
+
 delete from options where profile is null and name='last_scrape';
 create table new_options(profile varchar not null, name varchar not null, value varchar);
 
@@ -23,3 +25,5 @@ create table options(profile varchar not null, name varchar not null, value varc
 create unique index un_options on options(profile,name);
 insert into options(profile,name,value) select profile,name,value from new_options;
 drop table new_options;
+
+COMMIT TRANSACTION;
\ No newline at end of file