summaryrefslogtreecommitdiff
path: root/schema/versions/mysql/72.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2010-11-10 11:45:28 +0300
committerAndrew Dolgov <[email protected]>2010-11-10 11:45:28 +0300
commit90ef9c7da3de2c5800a82d911cd18ca1cf1850e2 (patch)
treebc236f43b6cdc2a9c2fea269ff443487a0ddbe36 /schema/versions/mysql/72.sql
parentbfa0e7921d81a925c68bdc9e0f0e24bd55cacbf7 (diff)
schema: wrap upgrade scripts in transaction blocks
Diffstat (limited to 'schema/versions/mysql/72.sql')
-rw-r--r--schema/versions/mysql/72.sql4
1 files changed, 4 insertions, 0 deletions
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;