 -- Table structure for table `category`
 --
 
-DROP TABLE IF EXISTS `category`;
 CREATE TABLE IF NOT EXISTS `category` (
   `id` int(3) NOT NULL AUTO_INCREMENT,
-  `name` varchar(600) NOT NULL,
+  `name` varchar(600) CHARACTER SET utf8 NOT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
-
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 --
--- Table data for table `category`
+-- Dumping data for table `category`
 --
 
-INSERT INTO `category` (`id`, `name`) 
-VALUES (1, 'Uncategorized');
 
 -- --------------------------------------------------------
 

-- Table structure for table `feeds`
--

DROP TABLE IF EXISTS `feeds`;
CREATE TABLE IF NOT EXISTS `feeds` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `name_desc` varchar(2000) DEFAULT NULL,
  `url` varchar(200) NOT NULL,
  `category` varchar(200) NOT NULL DEFAULT 'uncategorized',
  `favicon` varchar(200) DEFAULT NULL,
  `last_update` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `index_feed_id` (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


-- Table structure for table `articles`
--

CREATE TABLE IF NOT EXISTS `articles` (
  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `feed_id` mediumint(9) DEFAULT NULL,
  `status` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
  `star_ind` int(1) NOT NULL DEFAULT '0',
  `url` varchar(400) CHARACTER SET utf8 DEFAULT NULL,
  `subject` varchar(400) CHARACTER SET utf8 DEFAULT NULL,
  `content` text CHARACTER SET utf8,
  `insert_date` datetime DEFAULT NULL,
  `publish_date` datetime DEFAULT NULL,
  `author` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `articles`
--


-- --------------------------------------------------------

