schema: add published column

1 files changed, 5 insertions, 0 deletions

diff --git a/schema/versions/mysql/19.sql b/schema/versions/mysql/19.sql
index 19bb4b25d..db4237da8 100644
--- a/schema/versions/mysql/19.sql
+++ b/schema/versions/mysql/19.sql
@@ -1,3 +1,8 @@
 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_PREFS_PUBLISH_KEY', 2, '', '', 1);
 
+alter table ttrss_user_entries add column published bool;
+update ttrss_user_entries set published = false;
+alter table ttrss_user_entries change published published bool not null;
+alter table ttrss_user_entries alter column published set default false;
+
 update ttrss_version set schema_version = 19;