--
-- Table structure for table `feeds`
--

DROP TABLE IF EXISTS `feeds`;
CREATE TABLE IF NOT EXISTS `feeds` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(255) NOT NULL default 'untitled',
  `url` varchar(255) NOT NULL default '',
  `link` varchar(255) default NULL,
  `description` longtext default NULL,
  `icon` varchar(255) default NULL,
  `added` datetime NOT NULL default '0000-00-00 00:00:00',
  `private` tinyint(4) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `url` (`url`)
) TYPE=MyISAM ;

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
CREATE TABLE IF NOT EXISTS `tags` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `tag` varchar(255) NOT NULL default '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `tag` (`tag`)
) TYPE=MyISAM ;

--
-- Table structure for table `feeds2tags`
--

DROP TABLE IF EXISTS `feeds2tags`;
CREATE TABLE IF NOT EXISTS `feeds2tags` (
  `feed_id` int(10) unsigned NOT NULL default '0',
  `tag_id` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`feed_id`,`tag_id`)
) TYPE=MyISAM;

--
-- Table structure for table `items`
--

DROP TABLE IF EXISTS `items`;
CREATE TABLE IF NOT EXISTS `items` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `feed_id` int(10) unsigned NOT NULL default '0',
  `title` varchar(255) NOT NULL default '-- untitled --',
  `link` varchar(255) NOT NULL default '',
  `description` text,
  `fetch_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `pub_date` datetime NOT NULL default '0000-00-00 00:00:00',
  `read` tinyint(4) default '0',
  `saved` tinyint(4) default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `feed_id_link` (`feed_id`,`link`)
) TYPE=MyISAM ;