openblog_mysql.sql

openblog是一个博客管理系统

# MySQL-Front 3.2  (Build 14.3)

/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='SYSTEM' */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE */;
/*!40101 SET SQL_MODE='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES */;
/*!40103 SET SQL_NOTES='ON' */;


# Host: localhost    Database: openblog
# ------------------------------------------------------
# Server version 5.0.45-community-nt-log

DROP DATABASE IF EXISTS `openblog`;
CREATE DATABASE `openblog` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `openblog`;

#
# Table structure for table article
#

CREATE TABLE `article` (
  `article_id` int(11) NOT NULL auto_increment,
  `article_title` varchar(500) NOT NULL default '',
  `article_content` varchar(9000) default NULL,
  `article_date` varchar(50) default NULL,
  `article_sortid` int(11) default NULL,
  `article_count` int(11) NOT NULL default '0',
  PRIMARY KEY  (`article_id`),
  KEY `article_sortid` (`article_sortid`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8;


#
# Table structure for table comment
#

CREATE TABLE `comment` (
  `comment_id` int(11) NOT NULL auto_increment,
  `comment_name` varchar(50) NOT NULL default '',
  `comment_url` varchar(100) default NULL,
  `comment_qq` varchar(20) default NULL,
  `comment_email` varchar(50) default NULL,
  `comment_content` varchar(2000) default NULL,
  `comment_status` int(1) NOT NULL default '0',
  `comment_article` int(11) default NULL,
  `comment_date` varchar(30) default NULL,
  PRIMARY KEY  (`comment_id`),
  KEY `comment_article` (`comment_article`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;


#
# Table structure for table guestbook
#

CREATE TABLE `guestbook` (
  `guest_id` int(11) NOT NULL auto_increment,
  `guest_name` varchar(50) NOT NULL default '',
  `guest_url` varchar(100) default NULL,
  `guest_qq` varchar(20) default NULL,
  `guest_email` varchar(50) default NULL,
  `guest_content` varchar(2000) default NULL,
  `guest_status` int(10) NOT NULL default '0',
  `guest_date` varchar(30) default NULL,
  PRIMARY KEY  (`guest_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;


#
# Table structure for table info
#

CREATE TABLE `info` (
  `info_id` int(11) NOT NULL auto_increment,
  `info_name` varchar(50) NOT NULL default '',
  `info_photo` varchar(600) NOT NULL default '',
  `info_qq` varchar(20) default NULL,
  `info_email` varchar(50) default NULL,
  `info_website` varchar(200) default NULL,
  PRIMARY KEY  (`info_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;


#
# Table structure for table links
#

CREATE TABLE `links` (
  `links_id` int(11) NOT NULL auto_increment,
  `links_name` varchar(50) default NULL,
  `links_url` varchar(500) default NULL,
  PRIMARY KEY  (`links_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPRESSED;


#
# Table structure for table sort
#

CREATE TABLE `sort` (
  `sort_id` int(11) NOT NULL auto_increment,
  `sort_name` varchar(50) NOT NULL default '',
  `sort_parent` int(11) NOT NULL default '0',
  PRIMARY KEY  (`sort_id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;


#
# Table structure for table userinfo
#

CREATE TABLE `userinfo` (
  `user_id` int(11) NOT NULL auto_increment,
  `user_name` char(30) NOT NULL default '',
  `user_password` char(200) NOT NULL default '',
  PRIMARY KEY  (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;


#
#  Foreign keys for table article
#

ALTER TABLE `article`
  ADD FOREIGN KEY (`article_sortid`) REFERENCES `sort` (`sort_id`);

#
#  Foreign keys for table comment
#

ALTER TABLE `comment`
  ADD FOREIGN KEY (`comment_article`) REFERENCES `article` (`article_id`);


/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;