]>
git.wh0rd.org - tt-rss.git/blob - schema/upgrade-1.1-1.1.1-pgsql.sql
33b28271a5175798126508c357c112160db6a45c
3 alter table ttrss_entries
add column num_comments
integer;
5 update ttrss_entries
set num_comments
= 0;
7 alter table ttrss_entries
alter column num_comments
set not null;
8 alter table ttrss_entries
alter column num_comments
set default 0;
10 insert into ttrss_prefs (pref_name
,type_id
,def_value
,short_desc
,section_id
,help_text
) values('COMBINED_DISPLAY_MODE', 1, 'false', 'Combined feed display',2,
11 'Display expanded list of feed articles, instead of separate displays for headlines and article content');
13 alter table ttrss_feed_categories
add column collapsed
boolean;
15 update ttrss_feed_categories
set collapsed
= false;
17 alter table ttrss_feed_categories
alter column collapsed
set not null;
18 alter table ttrss_feed_categories
alter column collapsed
set default false;