diff options
Diffstat (limited to 'schema/versions/mysql/19.sql')
| -rw-r--r-- | schema/versions/mysql/19.sql | 5 |
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; |