diff options
author | Andrew Dolgov <[email protected]> | 2005-09-08 08:43:44 +0100 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2005-09-08 08:43:44 +0100 |
commit | 48f0adb02e8aacfc5850fd6ec2f15a9fb1af7561 (patch) | |
tree | 54e2415464a16c4f5fc094869fce93cc0bc613db /schema/ttrss_schema_pgsql.sql | |
parent | 7bb699de1c568c23c1f102f4b9396d8294dfc242 (diff) |
virtual feeds (labels) support
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
-rw-r--r-- | schema/ttrss_schema_pgsql.sql | 12 |
1 files changed, 12 insertions, 0 deletions
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'); + |