]>
Commit | Line | Data |
---|---|---|
dbf4a4cf AD |
1 | begin; |
2 | ||
de99f500 AD |
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 | ||
5b35b4de AD |
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 | ||
7f123cda AD |
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 | ||
41765fef AD |
15 | update ttrss_version set schema_version = 4; |
16 | ||
dbf4a4cf | 17 | commit; |