From 90ef9c7da3de2c5800a82d911cd18ca1cf1850e2 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 10 Nov 2010 11:45:28 +0300 Subject: schema: wrap upgrade scripts in transaction blocks --- schema/versions/mysql/71.sql | 4 ++++ schema/versions/mysql/72.sql | 4 ++++ schema/versions/pgsql/71.sql | 4 ++++ schema/versions/pgsql/72.sql | 4 ++++ 4 files changed, 16 insertions(+) (limited to 'schema') 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; -- cgit v1.2.3