summaryrefslogtreecommitdiff
path: root/schema/ttrss_schema_pgsql.sql
diff options
context:
space:
mode:
authorAndrew Dolgov <[email protected]>2005-11-02 12:53:06 +0100
committerAndrew Dolgov <[email protected]>2005-11-02 12:53:06 +0100
commit37d379de29265eb18622984575fb45c8fe89f647 (patch)
tree15a0142c3f42c52b1efa83fb742f359ea6221829 /schema/ttrss_schema_pgsql.sql
parent32bd6e262f3794fc603ffa848548fbab3bea7e75 (diff)
reserve column in ttrss_feeds for site url (schema+upgrade script updated)
Diffstat (limited to 'schema/ttrss_schema_pgsql.sql')
-rw-r--r--schema/ttrss_schema_pgsql.sql3
1 files changed, 2 insertions, 1 deletions
diff --git a/schema/ttrss_schema_pgsql.sql b/schema/ttrss_schema_pgsql.sql
index cc9cec5dc..2ab310cc5 100644
--- a/schema/ttrss_schema_pgsql.sql
+++ b/schema/ttrss_schema_pgsql.sql
@@ -8,7 +8,8 @@ create table ttrss_feeds (id serial not null primary key,
icon_url varchar(250) not null default '',
update_interval integer not null default 0,
last_updated timestamp default null,
- last_error text not null default '');
+ last_error text not null default '',
+ site_url varchar(250) not null default '');
insert into ttrss_feeds (title,feed_url) values ('Footnotes', 'http://gnomedesktop.org/node/feed');
insert into ttrss_feeds (title,feed_url) values ('Freedesktop.org', 'http://planet.freedesktop.org/rss20.xml');