virtual feeds (labels) support

1 files changed, 11 insertions, 0 deletions

diff --git a/schema/ttrss_schema_mysql.sql b/schema/ttrss_schema_mysql.sql
index 348cb2421..b7267e3b7 100644
--- a/schema/ttrss_schema_mysql.sql
+++ b/schema/ttrss_schema_mysql.sql
@@ -60,4 +60,15 @@ create table ttrss_filters (id integer primary key auto_increment,
 	reg_exp varchar(250) not null,
 	description varchar(250) not null default '') TYPE=InnoDB;
 
+drop table ttrss_labels;
+
+create table ttrss_labels (id integer primary key auto increment, 
+	sql_exp varchar(250) not null,
+	description varchar(250) not null);
+
+insert into ttrss_labels (sql_exp,description) values ('title = \'Interesting Topic\'',
+	'Example Label');
+
+insert into ttrss_labels (sql_exp,description) values ('unread = true', 
+	'Unread articles');