]>
git.wh0rd.org - tt-rss.git/blob - schema/versions/pgsql/3.sql
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;
20 alter table ttrss_feeds
add column auth_login
varchar(250);
21 alter table ttrss_feeds
add column auth_pass
varchar(250);
23 update ttrss_feeds
set auth_login
= '';
24 update ttrss_feeds
set auth_pass
= '';
26 alter table ttrss_feeds
alter column auth_login
set not null;
27 alter table ttrss_feeds
alter column auth_login
set default '';
29 alter table ttrss_feeds
alter column auth_pass
set not null;
30 alter table ttrss_feeds
alter column auth_pass
set default '';
32 alter table ttrss_users
add column email
varchar(250);
34 update ttrss_users
set email
= '';
36 alter table ttrss_users
alter column email
set not null;
37 alter table ttrss_users
alter column email
set default '';
39 insert into ttrss_prefs (pref_name
,type_id
,def_value
,short_desc
,section_id
) values('ENABLE_SEARCH_TOOLBAR', 1, 'false', 'Enable search toolbar',2);
41 update ttrss_version
set schema_version
= 3;