diff options
Diffstat (limited to 'schema/versions')
-rw-r--r-- | schema/versions/mysql/72.sql | 5 | ||||
-rw-r--r-- | schema/versions/pgsql/72.sql | 5 |
2 files changed, 10 insertions, 0 deletions
diff --git a/schema/versions/mysql/72.sql b/schema/versions/mysql/72.sql new file mode 100644 index 000000000..c9b74bae2 --- /dev/null +++ b/schema/versions/mysql/72.sql @@ -0,0 +1,5 @@ +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; diff --git a/schema/versions/pgsql/72.sql b/schema/versions/pgsql/72.sql new file mode 100644 index 000000000..7b260b3d1 --- /dev/null +++ b/schema/versions/pgsql/72.sql @@ -0,0 +1,5 @@ +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; |