let SQL revision files control the transaction

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

diff --git a/app/src/main/res/raw/sql_40.sql b/app/src/main/res/raw/sql_40.sql
index b2168179ef98e2ddc5fed401e7a03975294b9e64..0d6d5da2a42183639d74ba79ec08859fef15cef1 100644 (file)
--- a/app/src/main/res/raw/sql_40.sql
+++ b/app/src/main/res/raw/sql_40.sql
@@ -13,5 +13,9 @@
 -- You should have received a copy of the GNU General Public License
 -- along with MoLe. If not, see <https://www.gnu.org/licenses/>.
 pragma foreign_keys=off;
+BEGIN TRANSACTION;
+
 delete from transaction_accounts where not exists (select 1 from accounts a where a.profile=transaction_accounts.profile and a.name=transaction_accounts.account_name);
 delete from transaction_accounts where not exists (select 1 from transactions t where t.profile=transaction_accounts.profile and t.id=transaction_accounts.transaction_id);
+
+COMMIT TRANSACTION;
\ No newline at end of file