-- 
-- Created by SQL::Translator::Producer::SQLite
-- Created on Tue Dec 22 23:19:43 2009
-- 


BEGIN TRANSACTION;

--
-- Table: feed
--
DROP TABLE feed;

CREATE TABLE feed (
  id varchar(255) NOT NULL,
  url varchar(1024),
  link varchar(1024),
  title varchar(1024),
  owner varchar(255) NOT NULL,
  PRIMARY KEY (id)
);

CREATE UNIQUE INDEX url_feed ON feed (url);

--
-- Table: feed_tag_map
--
DROP TABLE feed_tag_map;

CREATE TABLE feed_tag_map (
  feed integer NOT NULL,
  tag integer NOT NULL,
  PRIMARY KEY (feed, tag)
);

CREATE INDEX feed_tag_map_idx_feed_feed_tag ON feed_tag_map (feed);

CREATE INDEX feed_tag_map_idx_tag_feed_tag_ ON feed_tag_map (tag);

--
-- Table: posts
--
DROP TABLE posts;

CREATE TABLE posts (
  post_id INTEGER PRIMARY KEY NOT NULL,
  feed_id varchar(255) NOT NULL,
  url varchar(1024) NOT NULL,
  title varchar(1024) NOT NULL,
  posted_on datetime NOT NULL,
  summary text,
  body text NOT NULL,
  summary_filtered text,
  body_filtered text,
  author varchar(1024) NOT NULL,
  tags varchar(1024) NOT NULL
);

CREATE INDEX posts_idx_feed_id_posts ON posts (feed_id);

CREATE UNIQUE INDEX url_posts ON posts (url);

--
-- Table: tag
--
DROP TABLE tag;

CREATE TABLE tag (
  id INTEGER PRIMARY KEY NOT NULL,
  name varchar(1024) NOT NULL
);

COMMIT;