schema: add ttrss_feeds.always_display_enclosures

2 files changed, 12 insertions, 0 deletions

diff --git a/schema/versions/mysql/57.sql b/schema/versions/mysql/57.sql
new file mode 100644
index 000000000..27a66d5b7
--- /dev/null
+++ b/schema/versions/mysql/57.sql
@@ -0,0 +1,6 @@
+alter table ttrss_feeds add column always_display_enclosures boolean;
+update ttrss_feeds set always_display_enclosures = false;
+alter table ttrss_feeds change always_display_enclosures always_display_enclosures boolean not null;
+alter table ttrss_feeds alter column always_display_enclosures set default false;
+
+update ttrss_version set schema_version = 57;
diff --git a/schema/versions/pgsql/57.sql b/schema/versions/pgsql/57.sql
new file mode 100644
index 000000000..3dd7898b9
--- /dev/null
+++ b/schema/versions/pgsql/57.sql
@@ -0,0 +1,6 @@
+alter table ttrss_feeds add column always_display_enclosures boolean;
+update ttrss_feeds set always_display_enclosures = false;
+alter table ttrss_feeds alter column always_display_enclosures set not null;
+alter table ttrss_feeds alter column always_display_enclosures set default false;
+
+update ttrss_version set schema_version = 57;