From de99f5005d48a668392ff4bda877854134e0d2f1 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Wed, 28 Dec 2005 19:59:47 +0100
Subject: add parent_feed column to ttrss_feeds, create upgrade script for
 1.1.1, move out old scripts to schema/obsolete

---
 schema/ttrss_schema_pgsql.sql | 3 ++-
 1 file changed, 2 insertions(+), 1 deletion(-)

(limited to 'schema/ttrss_schema_pgsql.sql')

diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index 9df7418fa..c2db4b36c 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -49,7 +49,8 @@ create table ttrss_feeds (id serial not null primary key,
 	last_error text not null default '',
 	site_url varchar(250) not null default '',
 	auth_login varchar(250) not null default '',
-	auth_pass varchar(250) not null default '');
+	parent_feed integer default null references ttrss_feeds(id) on delete set null,
+	auth_pass varchar(250) not null default '');	
 
 create index ttrss_feeds_owner_uid_index on ttrss_feeds(owner_uid);
 
-- 
cgit v1.2.3-54-g00ecf

