schema: wrap upgrade scripts in transaction blocks

4 files changed, 16 insertions, 0 deletions

diff --git a/schema/versions/mysql/71.sql b/schema/versions/mysql/71.sql
index 50ac7820a..2061ada2b 100644
--- a/schema/versions/mysql/71.sql
+++ b/schema/versions/mysql/71.sql
@@ -1,3 +1,7 @@
+begin;
+
 insert into ttrss_filter_types (id,name,description) values (7, 'tag', 'Article Tags');
 
 update ttrss_version set schema_version = 71;
+
+commit;
diff --git a/schema/versions/mysql/72.sql b/schema/versions/mysql/72.sql
index c9b74bae2..2995afda3 100644
--- a/schema/versions/mysql/72.sql
+++ b/schema/versions/mysql/72.sql
@@ -1,5 +1,9 @@
+begin;
+
 alter table ttrss_user_entries add column tag_cache text;
 update ttrss_user_entries set tag_cache = '';
 alter table ttrss_user_entries change tag_cache tag_cache text not null;
 
 update ttrss_version set schema_version = 72;
+
+commit;
diff --git a/schema/versions/pgsql/71.sql b/schema/versions/pgsql/71.sql
index 50ac7820a..2061ada2b 100644
--- a/schema/versions/pgsql/71.sql
+++ b/schema/versions/pgsql/71.sql
@@ -1,3 +1,7 @@
+begin;
+
 insert into ttrss_filter_types (id,name,description) values (7, 'tag', 'Article Tags');
 
 update ttrss_version set schema_version = 71;
+
+commit;
diff --git a/schema/versions/pgsql/72.sql b/schema/versions/pgsql/72.sql
index 7b260b3d1..65e4d2e0a 100644
--- a/schema/versions/pgsql/72.sql
+++ b/schema/versions/pgsql/72.sql
@@ -1,5 +1,9 @@
+begin;
+
 alter table ttrss_user_entries add column tag_cache text;
 update ttrss_user_entries set tag_cache = '';
 alter table ttrss_user_entries alter column tag_cache set not null;
 
 update ttrss_version set schema_version = 72;
+
+commit;