]>
Commit | Line | Data |
---|---|---|
eb40e11b AD |
1 | begin; |
2 | ||
3 | alter table ttrss_entries add column num_comments integer; | |
4 | ||
5 | update ttrss_entries set num_comments = 0; | |
6 | ||
7 | alter table ttrss_entries alter column num_comments set not null; | |
8 | alter table ttrss_entries alter column num_comments set default 0; | |
9 | ||
30ccc2f1 AD |
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'); | |
386cbf27 | 12 | |
28bcadff AD |
13 | alter table ttrss_feed_categories add column collapsed boolean; |
14 | ||
15 | update ttrss_feed_categories set collapsed = false; | |
16 | ||
17 | alter table ttrss_feed_categories alter column collapsed set not null; | |
18 | alter table ttrss_feed_categories alter column collapsed set default false; | |
19 | ||
e93a3c96 AD |
20 | alter table ttrss_feeds add column auth_login varchar(250); |
21 | alter table ttrss_feeds add column auth_pass varchar(250); | |
22 | ||
23 | update ttrss_feeds set auth_login = ''; | |
24 | update ttrss_feeds set auth_pass = ''; | |
25 | ||
26 | alter table ttrss_feeds alter column auth_login set not null; | |
27 | alter table ttrss_feeds alter column auth_login set default ''; | |
28 | ||
29 | alter table ttrss_feeds alter column auth_pass set not null; | |
30 | alter table ttrss_feeds alter column auth_pass set default ''; | |
31 | ||
8629e09d AD |
32 | alter table ttrss_users add column email varchar(250); |
33 | ||
34 | update ttrss_users set email = ''; | |
35 | ||
36 | alter table ttrss_users alter column email set not null; | |
37 | alter table ttrss_users alter column email set default ''; | |
38 | ||
eb40e11b | 39 | commit; |