From 466001c4fabb43a86b4366b2790169b5377f7d51 Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <fox@bah.spb.su>
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-54-g00ecf

