From 10a1f28f7c532455a17a15b158f965fd1fea9d51 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Sun, 2 Jul 2017 20:59:24 +0300 Subject: schema: updates for new filter format (bump version to 131) --- schema/ttrss_schema_pgsql.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'schema/ttrss_schema_pgsql.sql') diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql index 237f1d3fb..6db73cd51 100644 --- a/schema/ttrss_schema_pgsql.sql +++ b/schema/ttrss_schema_pgsql.sql @@ -246,6 +246,7 @@ create table ttrss_filters2_rules(id serial not null primary key, filter_type integer not null references ttrss_filter_types(id), feed_id integer references ttrss_feeds(id) on delete cascade default null, cat_id integer references ttrss_feed_categories(id) on delete cascade default null, + match_on text, cat_filter boolean not null default false); create table ttrss_filters2_actions(id serial not null primary key, @@ -263,7 +264,7 @@ create index ttrss_tags_post_int_id_idx on ttrss_tags(post_int_id); create table ttrss_version (schema_version int not null); -insert into ttrss_version values (130); +insert into ttrss_version values (131); create table ttrss_enclosures (id serial not null primary key, content_url text not null, -- cgit v1.2.3