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

begin;

create table ttrss_labels2 (id serial not null primary key, 
	owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE,
	caption varchar(250) not null
);

create table ttrss_user_labels2 (
	label_id integer not null references ttrss_labels2(id) ON DELETE CASCADE,
	article_id integer not null references ttrss_entries(id) ON DELETE CASCADE
);

insert into ttrss_filter_actions (id,name,description) values (7, 'label', 
	'Assign label');

update ttrss_version set schema_version = 51;

commit;
Commit	Line	Data
ceb30ba4 AD	1	begin;
	2
	3	create table ttrss_labels2 (id serial not null primary key,
	4	owner_uid integer not null references ttrss_users(id) ON DELETE CASCADE,
	5	caption varchar(250) not null
	6	);
	7
	8	create table ttrss_user_labels2 (
	9	label_id integer not null references ttrss_labels2(id) ON DELETE CASCADE,
	10	article_id integer not null references ttrss_entries(id) ON DELETE CASCADE
	11	);
	12
	13	insert into ttrss_filter_actions (id,name,description) values (7, 'label',
	14	'Assign label');
	15
	16	update ttrss_version set schema_version = 51;
	17
	18	commit;