[tt-rss.git] / schema / versions / pgsql / 43.sql

alter table ttrss_labels rename column sql_exp to sql_exp_old;
alter table ttrss_labels add column sql_exp text;
update ttrss_labels set sql_exp = sql_exp_old;
alter table ttrss_labels alter column sql_exp set not null;
alter table ttrss_labels drop column sql_exp_old;

update ttrss_version set schema_version = 43;
Commit	Line	Data
f7f939b2 AD	1	alter table ttrss_labels rename column sql_exp to sql_exp_old;
	2	alter table ttrss_labels add column sql_exp text;
	3	update ttrss_labels set sql_exp = sql_exp_old;
	4	alter table ttrss_labels alter column sql_exp set not null;
	5	alter table ttrss_labels drop column sql_exp_old;
	6
	7	update ttrss_version set schema_version = 43;