schema/versions/pgsql/19.sql

   1 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('_PREFS_PUBLISH_KEY', 2, '', '', 1);
   2
   3 alter table ttrss_user_entries add column published boolean;
   4 update ttrss_user_entries set published = false;
   5 alter table ttrss_user_entries alter column published set not null;
   6 alter table ttrss_user_entries alter column published set default false;
   7
   8 insert into ttrss_filter_actions (id,name,description) values (5, 'publish',
   9         'Publish article');
  10
  11 update ttrss_version set schema_version = 19;