summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--schema/ttrss_schema_pgsql.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index a4274d235..8bd8221de 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -46,6 +46,7 @@ insert into ttrss_feeds (owner_uid,title,feed_url) values (1,'Technocrat.net',
'http://syndication.technocrat.net/rss');
create table ttrss_entries (id serial not null primary key,
+ owner_uid integer not null references ttrss_users(id) on delete cascade,
feed_id int references ttrss_feeds(id) ON DELETE CASCADE not null,
updated timestamp not null,
title text not null,