From 466001c4fabb43a86b4366b2790169b5377f7d51 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 23 Aug 2005 11:51:29 +0100 Subject: cleaned up headline update process, fixed bug mentioned in previous patch --- ttrss_schema.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) (limited to 'ttrss_schema.sql') diff --git a/ttrss_schema.sql b/ttrss_schema.sql index e926ef226..26ab01b27 100644 --- a/ttrss_schema.sql +++ b/ttrss_schema.sql @@ -10,6 +10,8 @@ insert into ttrss_feeds (title,feed_url) values ('Footnotes', 'http://gnomedeskt insert into ttrss_feeds (title,feed_url) values ('Freedesktop.org', 'http://planet.freedesktop.org/rss20.xml'); insert into ttrss_feeds (title,feed_url) values ('Planet Debian', 'http://planet.debian.org/rss20.xml'); insert into ttrss_feeds (title,feed_url) values ('Planet GNOME', 'http://planet.gnome.org/rss20.xml'); +insert into ttrss_feeds (title,feed_url) values ('Planet Ubuntu', 'http://planet.ubuntulinux.org/rss20.xml'); + insert into ttrss_feeds (title,feed_url) values ('Monologue', 'http://www.go-mono.com/monologue/index.rss'); insert into ttrss_feeds (title,feed_url) values ('Latest Linux Kernel Versions', @@ -30,8 +32,8 @@ create table ttrss_entries (id serial not null primary key, title varchar(250) not null, guid varchar(300) not null unique, link varchar(300) not null unique, - md5_hash varchar(200) not null, content text not null, + content_hash varchar(250) not null, last_read timestamp, no_orig_date boolean not null default false, unread boolean not null default true); -- cgit v1.2.3