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