3 alter table ttrss_feeds
add column mark_unread_on_update
boolean;
4 update ttrss_feeds
set mark_unread_on_update
= false;
5 alter table ttrss_feeds change mark_unread_on_update mark_unread_on_update
boolean not null;
6 alter table ttrss_feeds
alter column mark_unread_on_update
set default false;
8 alter table ttrss_feeds
add column strip_images
boolean;
9 update ttrss_feeds
set strip_images
= false;
10 alter table ttrss_feeds change strip_images strip_images
boolean not null;
11 alter table ttrss_feeds
alter column strip_images
set default false;
13 alter table ttrss_feeds
add column update_on_checksum_change
boolean;
14 update ttrss_feeds
set update_on_checksum_change
= false;
15 alter table ttrss_feeds change update_on_checksum_change update_on_checksum_change
boolean not null;
16 alter table ttrss_feeds
alter column update_on_checksum_change
set default false;
18 DELETE FROM ttrss_user_prefs
WHERE pref_name
IN ('HIDE_FEEDLIST', 'SYNC_COUNTERS', 'ENABLE_LABELS', 'ENABLE_SEARCH_TOOLBAR', 'ENABLE_FEED_ICONS', 'ENABLE_OFFLINE_READING', 'EXTENDED_FEEDLIST', 'OPEN_LINKS_IN_NEW_WINDOW', 'ENABLE_FLASH_PLAYER', 'HEADLINES_SMART_DATE', 'MARK_UNREAD_ON_UPDATE', 'UPDATE_POST_ON_CHECKSUM_CHANGE');
20 DELETE FROM ttrss_prefs
WHERE pref_name
IN ('HIDE_FEEDLIST', 'SYNC_COUNTERS', 'ENABLE_LABELS', 'ENABLE_SEARCH_TOOLBAR', 'ENABLE_FEED_ICONS', 'ENABLE_OFFLINE_READING', 'EXTENDED_FEEDLIST', 'OPEN_LINKS_IN_NEW_WINDOW', 'ENABLE_FLASH_PLAYER', 'HEADLINES_SMART_DATE', 'MARK_UNREAD_ON_UPDATE', 'UPDATE_POST_ON_CHECKSUM_CHANGE');
22 alter table ttrss_feeds
add column pubsub_state
integer;
23 update ttrss_feeds
set pubsub_state
= 0;
24 alter table ttrss_feeds change pubsub_state pubsub_state
integer not null;
25 alter table ttrss_feeds
alter column pubsub_state
set default 0;
27 update ttrss_version
set schema_version
= 83;