X-Git-Url: https://git.ktnx.net/?p=mobile-ledger.git;a=blobdiff_plain;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fsql_49.sql;h=549c4a48800638b6a911f2af3bf06b75fdb1987d;hp=2852a8b892df1ed4ca865e6426be696774a9fa2c;hb=390a653a4424bd146f73bca3e421a0be252ee443;hpb=81277d1635a9b15fef1614a096d94f8772e40735 diff --git a/app/src/main/res/raw/sql_49.sql b/app/src/main/res/raw/sql_49.sql index 2852a8b8..549c4a48 100644 --- a/app/src/main/res/raw/sql_49.sql +++ b/app/src/main/res/raw/sql_49.sql @@ -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