schema/ttrss_schema_mysql.sql

   1 drop table if exists ttrss_tags;
   2 drop table if exists ttrss_entries;
   3 drop table if exists ttrss_feeds;
   4
   5 create table ttrss_feeds (id integer not null auto_increment primary key,
   6         title varchar(200) not null unique,
   7         feed_url varchar(250) unique not null,
   8         icon_url varchar(250) not null default '',
   9         last_updated datetime default '') TYPE=InnoDB;
  10
  11 insert into ttrss_feeds (title,feed_url) values ('Footnotes', 'http://gnomedesktop.org/node/feed');
  12 insert into ttrss_feeds (title,feed_url) values ('Freedesktop.org', 'http://planet.freedesktop.org/rss20.xml');
  13 insert into ttrss_feeds (title,feed_url) values ('Planet Debian', 'http://planet.debian.org/rss20.xml');
  14 insert into ttrss_feeds (title,feed_url) values ('Planet GNOME', 'http://planet.gnome.org/rss20.xml');
  15 insert into ttrss_feeds (title,feed_url) values ('Planet Ubuntu', 'http://planet.ubuntulinux.org/rss20.xml');
  16
  17 insert into ttrss_feeds (title,feed_url) values ('Monologue', 'http://www.go-mono.com/monologue/index.rss');
  18
  19 insert into ttrss_feeds (title,feed_url) values ('Latest Linux Kernel Versions',
  20         'http://kernel.org/kdist/rss.xml');
  21
  22 insert into ttrss_feeds (title,feed_url) values ('RPGDot Newsfeed',
  23         'http://www.rpgdot.com/team/rss/rss0.xml');
  24
  25 insert into ttrss_feeds (title,feed_url) values ('Digg.com News',
  26         'http://digg.com/rss/index.xml');
  27
  28 insert into ttrss_feeds (title,feed_url) values ('Technocrat.net',
  29         'http://syndication.technocrat.net/rss');
  30
  31 create table ttrss_entries (id integer not null primary key auto_increment,
  32         feed_id integer not null references ttrss_feeds(id) ON DELETE CASCADE,
  33         updated datetime not null,
  34         title text not null,
  35         guid varchar(255) not null unique,
  36         link text not null,
  37         content text not null,
  38         content_hash varchar(250) not null,
  39         last_read datetime,
  40         marked bool not null default 0,
  41         date_entered datetime not null,
  42         no_orig_date bool not null default 0,
  43         comments varchar(250) not null default '',
  44         unread bool not null default 1) TYPE=InnoDB;
  45
  46 drop table if exists ttrss_filters;
  47 drop table if exists ttrss_filter_types;
  48
  49 create table ttrss_filter_types (id integer primary key,
  50         name varchar(120) unique not null,
  51         description varchar(250) not null unique) TYPE=InnoDB;
  52
  53
  54 insert into ttrss_filter_types (id,name,description) values (1, 'title', 'Title');
  55 insert into ttrss_filter_types (id,name,description) values (2, 'content', 'Content');
  56 insert into ttrss_filter_types (id,name,description) values (3, 'both',
  57         'Title or Content');
  58
  59 create table ttrss_filters (id integer primary key auto_increment,
  60         filter_type integer not null references ttrss_filter_types(id),
  61         reg_exp varchar(250) not null,
  62         description varchar(250) not null default '') TYPE=InnoDB;
  63
  64 drop table if exists ttrss_labels;
  65
  66 create table ttrss_labels (id integer primary key auto_increment,
  67         sql_exp varchar(250) not null,
  68         description varchar(250) not null) TYPE=InnoDB;
  69
  70 insert into ttrss_labels (sql_exp,description) values ('unread = true',
  71         'Unread articles');
  72
  73 create table ttrss_tags (id integer primary key auto_increment,
  74         tag_name varchar(250) not null,
  75         post_id integer references ttrss_entries(id) ON DELETE CASCADE) TYPE=InnoDB;
  76