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

begin;

alter table ttrss_user_entries add column label_cache text;
update ttrss_user_entries set label_cache = '';
alter table ttrss_user_entries change label_cache label_cache text not null;

update ttrss_version set schema_version = 74;

commit;
Commit	Line	Data
c011b36b AD	1	begin;
	2
	3	alter table ttrss_user_entries add column label_cache text;
	4	update ttrss_user_entries set label_cache = '';
	5	alter table ttrss_user_entries change label_cache label_cache text not null;
	6
	7	update ttrss_version set schema_version = 74;
	8
	9	commit;