[tt-rss.git] / schema / versions / mysql / 106.sql

begin;

update ttrss_prefs set short_desc = 'Do not embed images in articles' where pref_name = 'STRIP_IMAGES';

alter table ttrss_feeds add column hide_images bool;
update ttrss_feeds set hide_images = false;
alter table ttrss_feeds change hide_images hide_images bool not null;
alter table ttrss_feeds alter column hide_images set default false;

update ttrss_version set schema_version = 106;

commit;
Commit	Line	Data
bfd61d3f AD	1	begin;
	2
	3	update ttrss_prefs set short_desc = 'Do not embed images in articles' where pref_name = 'STRIP_IMAGES';
	4
	5	alter table ttrss_feeds add column hide_images bool;
	6	update ttrss_feeds set hide_images = false;
	7	alter table ttrss_feeds change hide_images hide_images bool not null;
	8	alter table ttrss_feeds alter column hide_images set default false;
	9
	10	update ttrss_version set schema_version = 106;
	11
	12	commit;