schema: add cache_images feed option

2 files changed, 10 insertions, 0 deletions

diff --git a/schema/versions/mysql/22.sql b/schema/versions/mysql/22.sql
index 568a4391f..7b4457887 100644
--- a/schema/versions/mysql/22.sql
+++ b/schema/versions/mysql/22.sql
@@ -1,3 +1,8 @@
 create index ttrss_entries_date_entered_index on ttrss_entries(date_entered);
 
+alter table ttrss_feeds add column cache_images bool;
+update ttrss_feeds set cache_images = false;
+alter table ttrss_feeds change cache_images cache_images bool not null;
+alter table ttrss_feeds alter column cache_images set default false;
+
 update ttrss_version set schema_version = 22;
diff --git a/schema/versions/pgsql/22.sql b/schema/versions/pgsql/22.sql
index 568a4391f..96e67e4a0 100644
--- a/schema/versions/pgsql/22.sql
+++ b/schema/versions/pgsql/22.sql
@@ -1,3 +1,8 @@
 create index ttrss_entries_date_entered_index on ttrss_entries(date_entered);
 
+alter table ttrss_feeds add column cache_images boolean;
+update ttrss_feeds set cache_images = false;
+alter table ttrss_feeds alter column cache_images set not null;
+alter table ttrss_feeds alter column cache_images set default false;
+
 update ttrss_version set schema_version = 22;