schema/obsolete/upgrade-1.2.2-1.2.3-mysql.sql

   1 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id,help_text) values('DIGEST_ENABLE', 1, 'false', 'Enable e-mail digest',1,
   2 'This option enables sending daily digest of new (and unread) headlines on your configured e-mail address');
   3
   4 alter table ttrss_feeds add column include_in_digest bool;
   5 update ttrss_feeds set include_in_digest = true;
   6 alter table ttrss_feeds change include_in_digest include_in_digest bool not null;
   7 alter table ttrss_feeds alter column include_in_digest set default true;
   8
   9 insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('CONFIRM_FEED_CATCHUP', 1, 'true', 'Confirm marking feed as read',3);
  10
  11 update ttrss_version set schema_version = 10;
  12