ttrss_schema.sql

   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
   9 insert into ttrss_feeds (title,feed_url) values ('Footnotes', 'http://gnomedesktop.org/node/feed');
  10 insert into ttrss_feeds (title,feed_url) values ('Freedesktop.org', 'http://planet.freedesktop.org/rss20.xml');
  11 insert into ttrss_feeds (title,feed_url) values ('Planet Debian', 'http://planet.debian.org/rss20.xml');
  12 insert into ttrss_feeds (title,feed_url) values ('Planet GNOME', 'http://planet.gnome.org/rss20.xml');
  13 insert into ttrss_feeds (title,feed_url) values ('Planet Ubuntu', 'http://planet.ubuntulinux.org/rss20.xml');
  14
  15 insert into ttrss_feeds (title,feed_url) values ('Monologue', 'http://www.go-mono.com/monologue/index.rss');
  16
  17 insert into ttrss_feeds (title,feed_url) values ('Latest Linux Kernel Versions',
  18         'http://kernel.org/kdist/rss.xml');
  19
  20 insert into ttrss_feeds (title,feed_url) values ('RPGDot Newsfeed',
  21         'http://www.rpgdot.com/team/rss/rss0.xml');
  22
  23 insert into ttrss_feeds (title,feed_url) values ('Digg.com News',
  24         'http://digg.com/rss/index.xml');
  25
  26 insert into ttrss_feeds (id,title,feed_url) values ('Technocrat.net',
  27         'http://syndication.technocrat.net/rss');
  28
  29 create table ttrss_entries (id serial not null primary key,
  30         feed_id int references ttrss_feeds(id) not null,
  31         updated timestamp not null,
  32         title varchar(250) not null,
  33         guid varchar(300) not null unique,
  34         link varchar(300) not null unique,
  35         content text not null,
  36         content_hash varchar(250) not null,
  37         last_read timestamp,
  38         no_orig_date boolean not null default false,
  39         unread boolean not null default true);
  40