]>
Commit | Line | Data |
---|---|---|
fecd57c8 AD |
1 | begin; |
2 | ||
3 | alter table ttrss_feeds add column parent_feed integer; | |
4 | alter table ttrss_feeds add foreign key (parent_feed) references ttrss_feeds(id) on delete set null; | |
5 | ||
6 | alter table ttrss_feeds add column private bool; | |
7 | ||
8 | update ttrss_feeds set private = false; | |
9 | ||
10 | alter table ttrss_feeds change private private bool not null; | |
11 | alter table ttrss_feeds alter column private set default 0; | |
12 | ||
13 | insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('HIDE_READ_FEEDS', 1, 'false', 'Hide feeds with no unread messages',2); | |
14 | ||
15 | update ttrss_version set schema_version = 4; | |
16 | ||
17 | commit; |