]>
Commit | Line | Data |
---|---|---|
28a80fbf AD |
1 | drop table ttrss_entries; |
2 | drop table ttrss_feeds; | |
3 | ||
4 | create table ttrss_feeds (id serial not null primary key, | |
5 | title varchar(200) not null unique, | |
6 | feed_url varchar(250) unique not null, | |
7 | last_updated timestamp default null); | |
8 | ||
d76a3b03 | 9 | insert into ttrss_feeds (id,title,feed_url) values (0, 'Daily Strips', 'http://naboo.lan/~fox/strips/backend.php?op=rss'); |
28a80fbf AD |
10 | insert into ttrss_feeds (id,title,feed_url) values (1, 'Footnotes', 'http://gnomedesktop.org/node/feed'); |
11 | insert into ttrss_feeds (id,title,feed_url) values (2, 'Freedesktop.org', 'http://planet.freedesktop.org/rss20.xml'); | |
12 | insert into ttrss_feeds (id,title,feed_url) values (3, 'Planet Debian', 'http://planet.debian.org/rss20.xml'); | |
28a80fbf AD |
13 | insert into ttrss_feeds (id,title,feed_url) values (5, 'Planet GNOME', 'http://planet.gnome.org/rss20.xml'); |
14 | insert into ttrss_feeds (id,title,feed_url) values (6, 'Monologue', 'http://www.go-mono.com/monologue/index.rss'); | |
857d6a80 AD |
15 | |
16 | insert into ttrss_feeds (id,title,feed_url) values (8, 'Latest Linux Kernel Versions', | |
17 | 'http://kernel.org/kdist/rss.xml'); | |
18 | ||
19 | insert into ttrss_feeds (id,title,feed_url) values (9, 'RPGDot Newsfeed', | |
20 | 'http://www.rpgdot.com/team/rss/rss0.xml'); | |
21 | ||
22 | insert into ttrss_feeds (id,title,feed_url) values (10, 'Digg.com News', | |
23 | 'http://digg.com/rss/index.xml'); | |
24 | ||
25 | insert into ttrss_feeds (id,title,feed_url) values (11, 'Technocrat.net', | |
26 | 'http://syndication.technocrat.net/rss'); | |
28a80fbf | 27 | |
28a80fbf | 28 | create table ttrss_entries (id serial not null primary key, |
d76a3b03 AD |
29 | feed_id int references ttrss_feeds(id) not null, |
30 | updated timestamp not null, | |
31 | title varchar(250) not null, | |
28a80fbf | 32 | guid varchar(300) not null unique, |
d76a3b03 AD |
33 | link varchar(300) not null unique, |
34 | md5_hash varchar(200) not null unique, | |
35 | content text not null, | |
b197f117 | 36 | last_read timestamp, |
6f428bc5 AD |
37 | unread boolean default true); |
38 |