From 40b2356be212cfee1d68784714672b7c00114e2d Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Mon, 20 Dec 2021 07:56:16 +0300 Subject: filters: * add filter action to ignore feed-provided tags * simplify handling of various filter-provided tags * bump schema to 146 --- sql/mysql/migrations/146.sql | 2 ++ sql/mysql/schema.sql | 3 +++ sql/pgsql/migrations/146.sql | 2 ++ sql/pgsql/schema.sql | 3 +++ 4 files changed, 10 insertions(+) create mode 100644 sql/mysql/migrations/146.sql create mode 100644 sql/pgsql/migrations/146.sql (limited to 'sql') diff --git a/sql/mysql/migrations/146.sql b/sql/mysql/migrations/146.sql new file mode 100644 index 000000000..6d4824727 --- /dev/null +++ b/sql/mysql/migrations/146.sql @@ -0,0 +1,2 @@ +insert into ttrss_filter_actions (id,name,description) values (10, 'ignore-tag', + 'Ignore tags'); diff --git a/sql/mysql/schema.sql b/sql/mysql/schema.sql index ff6ff4797..589d1013a 100644 --- a/sql/mysql/schema.sql +++ b/sql/mysql/schema.sql @@ -249,6 +249,9 @@ insert into ttrss_filter_actions (id,name,description) values (8, 'stop', insert into ttrss_filter_actions (id,name,description) values (9, 'plugin', 'Invoke plugin'); +insert into ttrss_filter_actions (id,name,description) values (10, 'ignore-tag', + 'Ignore tags'); + create table ttrss_filters2(id integer primary key auto_increment, owner_uid integer not null, match_any_rule boolean not null default false, diff --git a/sql/pgsql/migrations/146.sql b/sql/pgsql/migrations/146.sql new file mode 100644 index 000000000..6d4824727 --- /dev/null +++ b/sql/pgsql/migrations/146.sql @@ -0,0 +1,2 @@ +insert into ttrss_filter_actions (id,name,description) values (10, 'ignore-tag', + 'Ignore tags'); diff --git a/sql/pgsql/schema.sql b/sql/pgsql/schema.sql index b539419b6..938ccc905 100644 --- a/sql/pgsql/schema.sql +++ b/sql/pgsql/schema.sql @@ -245,6 +245,9 @@ insert into ttrss_filter_actions (id,name,description) values (8, 'stop', insert into ttrss_filter_actions (id,name,description) values (9, 'plugin', 'Invoke plugin'); +insert into ttrss_filter_actions (id,name,description) values (10, 'ignore-tag', + 'Ignore tags'); + create table ttrss_filters2(id serial not null primary key, owner_uid integer not null references ttrss_users(id) on delete cascade, match_any_rule boolean not null default false, -- cgit v1.2.3