From 48f0adb02e8aacfc5850fd6ec2f15a9fb1af7561 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Thu, 8 Sep 2005 08:43:44 +0100
Subject: virtual feeds (labels) support

---
 schema/ttrss_schema_pgsql.sql | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'schema/ttrss_schema_pgsql.sql')

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 95887acb3..0bb704483 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -59,3 +59,15 @@ create table ttrss_filters (id serial primary key,
 	reg_exp varchar(250) not null,
 	description varchar(250) not null default '');
 
+drop table ttrss_labels;
+
+create table ttrss_labels (id serial primary key, 
+	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');
+
-- 
cgit v1.2.3-54-g00ecf

