]> git.ktnx.net Git - mobile-ledger.git/blobdiff - app/src/main/res/raw/sql_49.sql
let SQL revision files control the transaction
[mobile-ledger.git] / app / src / main / res / raw / sql_49.sql
index 2852a8b892df1ed4ca865e6426be696774a9fa2c..549c4a48800638b6a911f2af3bf06b75fdb1987d 100644 (file)
 
 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