-- phpMyAdmin SQL Dump
-- version 3.3.9
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 18, 2012 at 04:39 PM
-- Server version: 5.1.53
-- PHP Version: 5.3.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;


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

--
-- Table structure for table `aproves`
--

CREATE TABLE IF NOT EXISTS `aproves` (
  `aprove_id` INT(11) NOT NULL AUTO_INCREMENT,
  `aprove_comment_id` INT(11) NOT NULL,
  `aprove_post_id` INT(11) NOT NULL,
  `aprove_status_id` INT(11) NOT NULL,
  `aprove_admin_id` INT(11) NOT NULL,
  `aprove_time` INT(11) NOT NULL,
  PRIMARY KEY (`aprove_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;

--
-- Table structure for table `comments`
--

CREATE TABLE IF NOT EXISTS `comments` (
  `comment_id` INT(9) NOT NULL AUTO_INCREMENT,
  `comment_post_id` INT(9) NOT NULL,
  `comment_master_id` INT(9) NOT NULL,
  `comment_master_name` text NOT NULL,
  `comment_index` text NOT NULL,
  PRIMARY KEY (`comment_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=56 ;


--
-- Table structure for table `hold_comment`
--

CREATE TABLE IF NOT EXISTS `hold_comment` (
  `hold_id` INT(11) NOT NULL AUTO_INCREMENT,
  `hold_master_id` INT(11) NOT NULL,
  `hold_master_name` text NOT NULL,
  `hold_index` text NOT NULL,
  `hold_status` INT(1) NOT NULL,
  `hold_post_id` INT(11) NOT NULL,
  PRIMARY KEY (`hold_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;



--
-- Table structure for table `hold_post`
--

CREATE TABLE IF NOT EXISTS `hold_post` (
  `hold_id` INT(11) NOT NULL AUTO_INCREMENT,
  `hold_title` text NOT NULL,
  `hold_index` text NOT NULL,
  `hold_category` text NOT NULL,
  `hold_tag` text NOT NULL,
  `hold_master_id` INT(11) NOT NULL,
  `hold_master_name` text NOT NULL,
  `hold_status` INT(1) NOT NULL,
  `hold_time` INT(11) NOT NULL,
  PRIMARY KEY (`hold_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=90 ;

--
-- Table structure for table `likes`
--

CREATE TABLE IF NOT EXISTS `likes` (
  `like_user_id` INT(10) NOT NULL,
  `like_index_id` INT(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `likes`
--

INSERT INTO `likes` (`like_user_id`, `like_index_id`) VALUES
(1, 10),
(1, 13),
(1, 11),
(1, 15),
(1, 90);

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

--
-- Table structure for table `limits`
--

CREATE TABLE IF NOT EXISTS `limits` (
  `limit_user_id` INT(11) NOT NULL,
  `limit_time` INT(5) NOT NULL,
  `limit_comment` INT(5) NOT NULL,
  `limit_like` INT(5) NOT NULL,
  `limit_post` INT(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `limits`
--


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

--
-- Table structure for table `posts`
--

CREATE TABLE IF NOT EXISTS `posts` (
  `post_id` INT(9) NOT NULL AUTO_INCREMENT,
  `post_title` text NOT NULL,
  `post_index` text NOT NULL,
  `post_date` INT(11) NOT NULL,
  `post_master_id` INT(9) NOT NULL,
  `post_master_name` text NOT NULL,
  `post_like` INT(11) NOT NULL,
  `post_view` INT(11) NOT NULL,
  `post_comment` INT(11) NOT NULL,
  `post_tag` text NOT NULL,
  `post_category` text NOT NULL,
  `post_report` INT(10) NOT NULL,
  PRIMARY KEY (`post_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=91 ;


--
-- Table structure for table `reports`
--

CREATE TABLE IF NOT EXISTS `reports` (
  `report_id` INT(11) NOT NULL,
  `report_post_id` INT(11) NOT NULL,
  `report_user_id` INT(11) NOT NULL,
  `report_comment_id` INT(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `reports`
--

INSERT INTO `reports` (`report_id`, `report_post_id`, `report_user_id`, `report_comment_id`) VALUES
(0, 17, 1, 0),
(0, 90, 1, 0);

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

--
-- Table structure for table `setting`
--

CREATE TABLE IF NOT EXISTS `setting` (
  `admin_user_id` INT(11) NOT NULL,
  `admin_user_level` INT(11) NOT NULL,
  `messages_id` INT(11) NOT NULL AUTO_INCREMENT,
  `message_index` text NOT NULL,
  PRIMARY KEY (`messages_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Dumping data for table `setting`
--

INSERT INTO `setting` (`admin_user_id`, `admin_user_level`, `messages_id`, `message_index`) VALUES
(1, 10, 1, ''),
(1, 10, 2, ''),
(1, 10, 3, ''),
(1, 10, 4, '');

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

--
-- Table structure for table `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `user_id` INT(9) NOT NULL AUTO_INCREMENT,
  `user_name` text NOT NULL,
  `user_password` text NOT NULL,
  `user_email` text NOT NULL,
  `user_gen` INT(1) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;



-- Database: `information_schema`