Stuff

CREATE TABLE _feeds (
  feed_id varchar(40) NOT NULL default '',
  rss varchar(255) NOT NULL default '',
  site_url varchar(255) NOT NULL default '',
  name varchar(140) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  classify enum('warn','explicit','independant','media','') NOT NULL default '',
  `type` enum('audio','video','multi') NOT NULL default 'multi',
  lang varchar(2) NOT NULL default 'fr',
  image varchar(255) default NULL,
  site_id varchar(80) NOT NULL default '',
  sync_notes mediumtext,
  play_size smallint(1) default NULL,
  rating int(3) NOT NULL default '50',
  UNIQUE KEY feed_id (feed_id),
  KEY site_id (site_id),
  KEY `type` (`type`),
  KEY classify (classify),
  KEY lang (lang),
  FULLTEXT KEY `text` (site_url,name,description),
  FULLTEXT KEY name (name),
  FULLTEXT KEY desc_url (site_url,description)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



CREATE TABLE _posts (
  feed_id varchar(40) NOT NULL default '',
  guid varchar(40) NOT NULL default '',
  title varchar(200) default NULL,
  content longtext,
  post_url varchar(255) NOT NULL default '',
  date_posted int(12) NOT NULL default '0',
  date_modified int(12) NOT NULL default '0',
  author varchar(50) default NULL,
  enclosure varchar(255) NOT NULL default '',
  enc_type varchar(20) NOT NULL default '',
  enc_size int(20) NOT NULL default '0',
  UNIQUE KEY id (guid,feed_id),
  KEY feed_id (feed_id),
  KEY date_posted (date_posted),
  FULLTEXT KEY txt_enc (content,enclosure),
  FULLTEXT KEY txt (title,content,author,enclosure),
  FULLTEXT KEY title (title)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;