From 48f0adb02e8aacfc5850fd6ec2f15a9fb1af7561 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Thu, 8 Sep 2005 08:43:44 +0100 Subject: virtual feeds (labels) support --- schema/ttrss_schema_mysql.sql | 11 +++++++++++ schema/ttrss_schema_pgsql.sql | 12 ++++++++++++ 2 files changed, 23 insertions(+) (limited to 'schema') 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'); 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