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

create index ttrss_entries_date_entered_index on ttrss_entries(date_entered);

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

update ttrss_version set schema_version = 22;
Commit	Line	Data
3c62b748 AD	1	create index ttrss_entries_date_entered_index on ttrss_entries(date_entered);
3c62b748 AD	2
fb67e2ba AD	3	alter table ttrss_feeds add column cache_images bool;
	4	update ttrss_feeds set cache_images = false;
	5	alter table ttrss_feeds change cache_images cache_images bool not null;
	6	alter table ttrss_feeds alter column cache_images set default false;
	7
3c62b748	8	update ttrss_version set schema_version = 22;