X-Git-Url: https://git.ktnx.net/?a=blobdiff_plain;ds=sidebyside;f=app%2Fsrc%2Fmain%2Fres%2Fraw%2Fsql_20.sql;h=7510b7dcba2741b41c2e43c793e8595ea63ddb97;hb=390a653a4424bd146f73bca3e421a0be252ee443;hp=8e2c1ecab389a9a8a4d812d2d147331ed584021a;hpb=81277d1635a9b15fef1614a096d94f8772e40735;p=mobile-ledger.git diff --git a/app/src/main/res/raw/sql_20.sql b/app/src/main/res/raw/sql_20.sql index 8e2c1eca..7510b7dc 100644 --- a/app/src/main/res/raw/sql_20.sql +++ b/app/src/main/res/raw/sql_20.sql @@ -13,7 +13,11 @@ -- You should have received a copy of the GNU General Public License -- along with MoLe. If not, see . +BEGIN TRANSACTION; + delete from accounts where not exists (select 1 from profiles where uuid = profile); delete from account_values where not exists (select 1 from profiles where uuid = profile); delete from transactions where not exists (select 1 from profiles where uuid = profile); delete from transaction_accounts where not exists (select 1 from profiles where uuid = profile); + +COMMIT TRANSACTION; \ No newline at end of file