Unnamed

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;