[tt-rss.git] / schema / upgrade-1.2.4-1.2.6-pgsql.sql

begin;

alter table ttrss_filters add column action_param varchar(200);

update ttrss_filters set action_param = '';

alter table ttrss_filters alter column action_param set not null;
alter table ttrss_filters alter column action_param set default '';

insert into ttrss_filter_actions (id,name,description) values (4, 'tag', 
		'Assign tags');

update ttrss_version set schema_version = 12;

commit;
Commit	Line	Data
9ebaec05 AD	1	begin;
	2
	3	alter table ttrss_filters add column action_param varchar(200);
	4
	5	update ttrss_filters set action_param = '';
	6
	7	alter table ttrss_filters alter column action_param set not null;
	8	alter table ttrss_filters alter column action_param set default '';
	9
7cb9311b	10	insert into ttrss_filter_actions (id,name,description) values (4, 'tag',
de07b5ee	11	'Assign tags');
7cb9311b	12
9ebaec05 AD	13	update ttrss_version set schema_version = 12;
	14
	15	commit;