]> git.wh0rd.org - tt-rss.git/blob - schema/versions/mysql/7.sql
add new-style schema versions and updater
[tt-rss.git] / schema / versions / mysql / 7.sql
1 alter table ttrss_feeds add column rtl_content bool;
2
3 update ttrss_feeds set rtl_content = false;
4
5 alter table ttrss_feeds change rtl_content rtl_content bool not null;
6 alter table ttrss_feeds alter column rtl_content set default false;
7
8 delete from ttrss_user_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';
9 delete from ttrss_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';
10
11 delete from ttrss_user_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';
12 delete from ttrss_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';
13
14 alter table ttrss_sessions drop column ip_address;
15
16 alter table ttrss_filters drop column description;
17
18 update ttrss_version set schema_version = 7;
19