From a0d5388913ca8f9a97fa1ef257517230412bafdd Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Sat, 3 Sep 2005 08:22:29 +0100
Subject: reworked preferences dialog, start work on post filters (schema
 updated)

---
 ttrss_schema.sql | 19 ++++++++++++++++++-
 1 file changed, 18 insertions(+), 1 deletion(-)

(limited to 'ttrss_schema.sql')

diff --git a/ttrss_schema.sql b/ttrss_schema.sql
index 364087f17..79a58677c 100644
--- a/ttrss_schema.sql
+++ b/ttrss_schema.sql
@@ -41,4 +41,21 @@ create table ttrss_entries (id serial not null primary key,
 	no_orig_date boolean not null default false,
 	comments varchar(250) not null default '',
 	unread boolean not null default true);
-	
+
+drop table ttrss_filters;
+drop table ttrss_filter_types;
+
+create table ttrss_filter_types (id integer primary key, 
+	name varchar(120) unique not null, 
+	description varchar(250) not null unique);
+
+insert into ttrss_filter_types (id,name,description) values (1, 'title', 'Title');
+insert into ttrss_filter_types (id,name,description) values (2, 'content', 'Content');
+insert into ttrss_filter_types (id,name,description) values (3, 'both', 
+	'Title and Content');
+
+create table ttrss_filters (id serial primary key, 
+	filter_type integer not null references ttrss_filter_types(id), 
+	regexp varchar(250) not null,
+	description varchar(250) not null default '');
+
-- 
cgit v1.2.3-54-g00ecf

