allow filtering by article tags (bump schema)

4 files changed, 10 insertions, 2 deletions

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 03ea5e610..da73cedd4 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -187,6 +187,7 @@ insert into ttrss_filter_types (id,name,description) values (4, 'link',
 insert into ttrss_filter_types (id,name,description) values (5, 'date', 
 	'Article Date');
 insert into ttrss_filter_types (id,name,description) values (6, 'author', 'Author');
+insert into ttrss_filter_types (id,name,description) values (7, 'tag', 'Article Tags');
 
 create table ttrss_filter_actions (id integer not null primary key, 
 	name varchar(120) unique not null, 
@@ -243,7 +244,7 @@ create table ttrss_tags (id integer primary key auto_increment,
 
 create table ttrss_version (schema_version int not null) TYPE=InnoDB DEFAULT CHARSET=UTF8;
 
-insert into ttrss_version values (70);
+insert into ttrss_version values (71);
 
 create table ttrss_enclosures (id integer primary key auto_increment,
 	content_url text not null,
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 2d1f33c6f..3583639c6 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -169,6 +169,7 @@ insert into ttrss_filter_types (id,name,description) values (4, 'link',
 insert into ttrss_filter_types (id,name,description) values (5, 'date', 
 	'Article Date');
 insert into ttrss_filter_types (id,name,description) values (6, 'author', 'Author');
+insert into ttrss_filter_types (id,name,description) values (7, 'tag', 'Article Tags');
 
 create table ttrss_filter_actions (id integer not null primary key, 
 	name varchar(120) unique not null, 
@@ -215,7 +216,7 @@ create index ttrss_tags_owner_uid_index on ttrss_tags(owner_uid);
 
 create table ttrss_version (schema_version int not null);
 
-insert into ttrss_version values (70);
+insert into ttrss_version values (71);
 
 create table ttrss_enclosures (id serial not null primary key,
 	content_url text not null,
diff --git a/schema/versions/mysql/71.sql b/schema/versions/mysql/71.sql
new file mode 100644
index 000000000..50ac7820a
--- /dev/null
+++ b/schema/versions/mysql/71.sql
@@ -0,0 +1,3 @@
+insert into ttrss_filter_types (id,name,description) values (7, 'tag', 'Article Tags');
+
+update ttrss_version set schema_version = 71;
diff --git a/schema/versions/pgsql/71.sql b/schema/versions/pgsql/71.sql
new file mode 100644
index 000000000..50ac7820a
--- /dev/null
+++ b/schema/versions/pgsql/71.sql
@@ -0,0 +1,3 @@
+insert into ttrss_filter_types (id,name,description) values (7, 'tag', 'Article Tags');
+
+update ttrss_version set schema_version = 71;