diff options
author | Andrew Dolgov <[email protected]> | 2010-11-10 11:45:28 +0300 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2010-11-10 11:45:28 +0300 |
commit | 90ef9c7da3de2c5800a82d911cd18ca1cf1850e2 (patch) | |
tree | bc236f43b6cdc2a9c2fea269ff443487a0ddbe36 | |
parent | bfa0e7921d81a925c68bdc9e0f0e24bd55cacbf7 (diff) |
schema: wrap upgrade scripts in transaction blocks
-rw-r--r-- | schema/versions/mysql/71.sql | 4 | ||||
-rw-r--r-- | schema/versions/mysql/72.sql | 4 | ||||
-rw-r--r-- | schema/versions/pgsql/71.sql | 4 | ||||
-rw-r--r-- | schema/versions/pgsql/72.sql | 4 |
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; |