From aa6d1e9766b92029b5219201ba7d1081b687c0f9 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
Date: Sat, 17 Nov 2007 11:33:13 +0100
Subject: schema: enclosure fixes

---
 schema/versions/pgsql/26.sql | 9 ++++-----
 1 file changed, 4 insertions(+), 5 deletions(-)

(limited to 'schema/versions/pgsql/26.sql')

diff --git a/schema/versions/pgsql/26.sql b/schema/versions/pgsql/26.sql
index b597c2940..fa1c812ed 100644
--- a/schema/versions/pgsql/26.sql
+++ b/schema/versions/pgsql/26.sql
@@ -4,10 +4,9 @@ alter table ttrss_users add column created timestamp;
 alter table ttrss_users alter column created set default null;
 
 create table ttrss_enclosures (id serial not null primary key,
-   content_url text not null,
-   content_type varchar(250) not null,
-   post_id integer not null, 
-   index (post_id),
-   foreign key (post_id) references ttrss_entries(id) ON DELETE cascade);
+	content_url text not null,
+	content_type varchar(250) not null,
+	title text not null,
+	post_id integer references ttrss_entries(id) ON DELETE cascade NOT NULL);
 
 update ttrss_version set schema_version = 26;
-- 
cgit v1.2.3-54-g00ecf

