summaryrefslogtreecommitdiff
path: root/schema/ttrss_schema_pgsql.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2007-11-17 13:13:08 +0100
committerAndrew Dolgov <[email protected]>2007-11-17 13:13:08 +0100
commitce53e200b475675389f6903f341d99116f3ef0b7 (patch)
tree1177023c042b36d47b9630808248af04c732551b /schema/ttrss_schema_pgsql.sql
parent66a251f901306b8dd5bd856efc75681d68880261 (diff)
add support for enclosures (closes #165)
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
-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 0b9eda212..dfb32ca15 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -187,6 +187,7 @@ create table ttrss_enclosures (id serial not null primary key,
content_url text not null,
content_type varchar(250) not null,
title text not null,
+ duration text not null,
post_id integer references ttrss_entries(id) ON DELETE cascade NOT NULL);
create table ttrss_prefs_types (id integer not null primary key,