?? openblog_mysql.sql
字號:
# 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 */;
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -