From ee9008f922b2fd440da8c7748fae56a5b714847a Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Thu, 17 Nov 2005 18:34:58 +0100
Subject: update schema

---
 schema/ttrss_schema_pgsql.sql | 7 +++++--
 1 file changed, 5 insertions(+), 2 deletions(-)

(limited to 'schema/ttrss_schema_pgsql.sql')

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 812905061..a4274d235 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -1,6 +1,8 @@
 drop table ttrss_tags;
 drop table ttrss_entries;
 drop table ttrss_feeds;
+drop table ttrss_labels;
+drop table ttrss_filters;
 
 drop table ttrss_user_prefs;
 drop table ttrss_users;
@@ -83,14 +85,15 @@ 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 ('unread = true', 
+insert into ttrss_labels (owner_uid,sql_exp,description) values (1,'unread = true', 
 	'Unread articles');
 
-insert into ttrss_labels (sql_exp,description) values (
+insert into ttrss_labels (owner_uid,sql_exp,description) values (1,
 	'last_read is null and unread = false', 'Updated articles');
 
 create table ttrss_tags (id serial primary key, 
 	tag_name varchar(250) not null,
+	owner_uid integer not null references ttrss_users(id) on delete cascade,
 	post_id integer references ttrss_entries(id) ON DELETE CASCADE not null);
 
 drop table ttrss_version;
-- 
cgit v1.2.3-54-g00ecf

