summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2005-11-17 18:37:15 +0100
committerAndrew Dolgov <[email protected]>2005-11-17 18:37:15 +0100
commitb58cf26600592cbd6374c689095a817a95349652 (patch)
treed37935674daac83e06a81ca571bad82511e7f330
parentee9008f922b2fd440da8c7748fae56a5b714847a (diff)
update schema again
-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,