]>
git.wh0rd.org - tt-rss.git/blob - schema/obsolete/upgrade-1.2.2-1.2.3-pgsql.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');
4 alter table ttrss_feeds
add column include_in_digest
boolean;
5 update ttrss_feeds
set include_in_digest
= true;
6 alter table ttrss_feeds
alter column include_in_digest
set not null;
7 alter table ttrss_feeds
alter column include_in_digest
set default true;
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);
11 update ttrss_version
set schema_version
= 10;