diff options
| author | Andrew Dolgov <[email protected]> | 2005-08-23 11:51:29 +0100 |
|---|---|---|
| committer | Andrew Dolgov <[email protected]> | 2005-08-23 11:51:29 +0100 |
| commit | 466001c4fabb43a86b4366b2790169b5377f7d51 (patch) | |
| tree | c3e668e507c27d92adc445fafdeec8591be77568 /ttrss_schema.sql | |
| parent | cb0bd8bd0fc516a51867041a20909a56f631e20e (diff) | |
cleaned up headline update process, fixed bug mentioned in previous patch
Diffstat (limited to 'ttrss_schema.sql')
| -rw-r--r-- | ttrss_schema.sql | 4 |
1 files changed, 3 insertions, 1 deletions
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); |