]>
Commit | Line | Data |
---|---|---|
9382ca84 AD |
1 | begin; |
2 | ||
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; | |
7 | ||
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; | |
12 | ||
74b046a1 AD |
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; | |
9382ca84 | 17 | |
74b046a1 AD |
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'); |
19 | ||
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'); | |
9382ca84 | 21 | |
5ab9791f AD |
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; | |
26 | ||
dfa7bb2f | 27 | alter table ttrss_users drop foreign key ttrss_users_ibfk_1; |
9507ab7f | 28 | alter table ttrss_users drop column theme_id; |
dd034576 | 29 | |
9507ab7f AD |
30 | drop table ttrss_themes; |
31 | ||
9382ca84 AD |
32 | update ttrss_version set schema_version = 83; |
33 | ||
34 | commit; |