[tt-rss.git] / schema / upgrade-1.1.4-1.1.5-pgsql.sql

begin;

alter table ttrss_feeds add column rtl_content boolean;

update ttrss_feeds set rtl_content = false;

alter table ttrss_feeds alter column rtl_content set not null;
alter table ttrss_feeds alter column rtl_content set default false;

alter table ttrss_sessions drop column ip_address;

delete from ttrss_user_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';
delete from ttrss_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';

delete from ttrss_user_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';
delete from ttrss_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';

alter table ttrss_filters drop column description;

update ttrss_version set schema_version = 7;

commit;
Commit	Line	Data
70f6dbb1 AD	1	begin;
	2
	3	alter table ttrss_feeds add column rtl_content boolean;
	4
	5	update ttrss_feeds set rtl_content = false;
	6
	7	alter table ttrss_feeds alter column rtl_content set not null;
	8	alter table ttrss_feeds alter column rtl_content set default false;
	9
3b0f23de AD	10	alter table ttrss_sessions drop column ip_address;
3b0f23de AD	11
01b3e191 AD	12	delete from ttrss_user_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';
	13	delete from ttrss_prefs where pref_name = 'DISPLAY_FEEDLIST_ACTIONS';
	14
	15	delete from ttrss_user_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';
	16	delete from ttrss_prefs where pref_name = 'ENABLE_PREFS_CATCHUP_UNCATCHUP';
	17
	18	alter table ttrss_filters drop column description;
	19
70f6dbb1 AD	20	update ttrss_version set schema_version = 7;
	21
	22	commit;