-- Convert schema './IronMan-Schema-0.01-MySQL.sql' to 'IronMan::Schema v0.02':;

BEGIN;

SET foreign_key_checks=0;

CREATE TABLE `posts` (
  post_id integer NOT NULL auto_increment,
  feed_id varchar(255) NOT NULL,
  url text NOT NULL,
  title text NOT NULL,
  posted_on datetime NOT NULL,
  summary text,
  body text NOT NULL,
  summary_filtered text,
  body_filtered text,
  INDEX posts_idx_feed_id (feed_id),
  PRIMARY KEY (post_id),
  UNIQUE url (url),
  CONSTRAINT posts_fk_feed_id FOREIGN KEY (feed_id) REFERENCES `feed` (id)
) ENGINE=InnoDB;

SET foreign_key_checks=1;

ALTER TABLE feed CHANGE COLUMN url url text,
                 CHANGE COLUMN link link text,
                 CHANGE COLUMN title title text;

ALTER TABLE tag CHANGE COLUMN name name text NOT NULL;


COMMIT;