]>
git.wh0rd.org - tt-rss.git/blob - schema/versions/pgsql/9.sql
3 alter table ttrss_feeds
add column hidden
boolean ;
4 update ttrss_feeds
set hidden
= false ;
5 alter table ttrss_feeds
alter column hidden
set not null ;
6 alter table ttrss_feeds
alter column hidden
set default false ;
8 alter table ttrss_users
add column email_digest
boolean ;
9 update ttrss_users
set email_digest
= false ;
10 alter table ttrss_users
alter column email_digest
set not null ;
11 alter table ttrss_users
alter column email_digest
set default false ;
13 alter table ttrss_users
add column last_digest_sent
timestamp ;
14 update ttrss_users
set last_digest_sent
= NULL ;
15 alter table ttrss_users
alter column last_digest_sent
set default NULL ;
17 alter table ttrss_filters
add column enabled
boolean ;
18 update ttrss_filters
set enabled
= true ;
19 alter table ttrss_filters
alter column enabled
set not null ;
20 alter table ttrss_filters
alter column enabled
set default true ;
22 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 );
24 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 );
26 update ttrss_prefs
SET section_id
= 3 WHERE pref_name
= 'ENABLE_SEARCH_TOOLBAR' ;
27 update ttrss_prefs
SET section_id
= 3 WHERE pref_name
= 'ENABLE_FEED_ICONS' ;
28 update ttrss_prefs
SET section_id
= 3 WHERE pref_name
= 'EXTENDED_FEEDLIST' ;
30 update ttrss_version
set schema_version
= 9 ;