 -- Table structure for table `articles`
 --
 
-DROP TABLE IF EXISTS `articles`;
 CREATE TABLE IF NOT EXISTS `articles` (
   `id` mediumint(9) NOT NULL AUTO_INCREMENT,
   `feed_id` mediumint(9) DEFAULT NULL,
-  `status` varchar(10) DEFAULT NULL,
+  `status` varchar(10) CHARACTER SET utf8 DEFAULT NULL,
   `star_ind` int(1) NOT NULL DEFAULT '0',
-  `url` varchar(400) DEFAULT NULL,
-  `subject` varchar(400) DEFAULT NULL,
-  `content` text,
+  `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) DEFAULT NULL,
+  `author` varchar(200) CHARACTER SET utf8 DEFAULT NULL,
   PRIMARY KEY (`id`)
-) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
+
+--
+-- Dumping data for table `articles`
+--
+
 
 -- --------------------------------------------------------
 

SET NAMES utf8;
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";

--
-- Database: `phppaper`
--

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


-- Table structure for table `category`
--

CREATE TABLE IF NOT EXISTS `category` (
  `id` int(3) NOT NULL AUTO_INCREMENT,
  `name` varchar(600) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `category`
--


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

