]>
Commit | Line | Data |
---|---|---|
7da377ca | 1 | alter table ttrss_feeds add column hidden bool; |
7da377ca | 2 | update ttrss_feeds set hidden = false; |
60a2080f | 3 | alter table ttrss_feeds change hidden hidden bool not null; |
7da377ca AD |
4 | alter table ttrss_feeds alter column hidden set default false; |
5 | ||
32be4b10 AD |
6 | alter table ttrss_users add column email_digest bool; |
7 | update ttrss_users set email_digest = false; | |
8 | alter table ttrss_users change email_digest email_digest bool not null; | |
9 | alter table ttrss_users alter column email_digest set default false; | |
10 | ||
11 | alter table ttrss_users add column last_digest_sent datetime; | |
12 | update ttrss_users set last_digest_sent = false; | |
13 | alter table ttrss_users alter column last_digest_sent set default null; | |
14 | ||
4fd52ba4 AD |
15 | alter table ttrss_filters add column enabled bool; |
16 | update ttrss_filters set enabled = true; | |
17 | alter table ttrss_filters change enabled enabled bool not null; | |
18 | alter table ttrss_filters alter column enabled set default true; | |
19 | ||
52c61bf8 AD |
20 | insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('MARK_UNREAD_ON_UPDATE', 1, 'false', 'Set articles as unread on update',3); |
21 | ||
d6e5706d AD |
22 | insert into ttrss_prefs (pref_name,type_id,def_value,short_desc,section_id) values('REVERSE_HEADLINES', 1, 'false', 'Reverse headline order (oldest first)',2); |
23 | ||
53c98a9a AD |
24 | update ttrss_prefs SET section_id = 3 WHERE pref_name = 'ENABLE_SEARCH_TOOLBAR'; |
25 | update ttrss_prefs SET section_id = 3 WHERE pref_name = 'ENABLE_FEED_ICONS'; | |
26 | update ttrss_prefs SET section_id = 3 WHERE pref_name = 'EXTENDED_FEEDLIST'; | |
27 | ||
52c61bf8 AD |
28 | update ttrss_version set schema_version = 9; |
29 |