Z-BLOG 数据库 mysql版
Z-BLOG 数据库 mysql版
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for blog_article
-- ----------------------------
DROP TABLE IF EXISTS `blog_article`;
CREATE TABLE `blog_article` (
`log_ID` int(11) NOT NULL AUTO_INCREMENT,
`log_CateID` int(11) DEFAULT NULL,
`log_AuthorID` int(11) DEFAULT NULL,
`log_Level` int(11) DEFAULT NULL,
`log_Url` varchar(255) DEFAULT NULL,
`log_Title` varchar(255) DEFAULT NULL,
`log_Intro` longtext,
`log_Content` longtext,
`log_IP` varchar(15) DEFAULT NULL,
`log_PostTime` datetime DEFAULT NULL,
`log_CommNums` int(11) DEFAULT NULL,
`log_ViewNums` int(11) DEFAULT NULL,
`log_TrackBackNums` int(11) DEFAULT NULL,
`log_Tag` varchar(255) DEFAULT NULL,
`log_IsTop` tinyint(4) DEFAULT NULL,
PRIMARY KEY (`log_ID`),
KEY `blog_ID` (`log_ID`),
KEY `log_AuthorID` (`log_AuthorID`),
KEY `log_CateID` (`log_CateID`),
KEY `log_PostTime` (`log_PostTime`),
KEY `log_Tag` (`log_Tag`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Table structure for blog_category
-- ----------------------------
DROP TABLE IF EXISTS `blog_category`;
CREATE TABLE `blog_category` (
`cate_ID` int(11) NOT NULL AUTO_INCREMENT,
`cate_Name` varchar(50) DEFAULT NULL,
`cate_Order` int(11) DEFAULT NULL,
`cate_Intro` varchar(255) DEFAULT NULL,
`cate_Count` int(11) DEFAULT NULL,
PRIMARY KEY (`cate_ID`),
KEY `cate_ID` (`cate_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Table structure for blog_comment
-- ----------------------------
DROP TABLE IF EXISTS `blog_comment`;
CREATE TABLE `blog_comment` (
`comm_ID` int(11) NOT NULL AUTO_INCREMENT,
`log_ID` int(11) DEFAULT NULL,
`comm_AuthorID` int(11) DEFAULT NULL,
`comm_Author` varchar(20) DEFAULT NULL,
`comm_Content` longtext,
`comm_Email` varchar(50) DEFAULT NULL,
`comm_HomePage` varchar(255) DEFAULT NULL,
`comm_PostTime` datetime DEFAULT NULL,
`comm_IP` varchar(15) DEFAULT NULL,
`comm_Agent` longtext,
PRIMARY KEY (`comm_ID`),
KEY `comm_AuthorID` (`comm_AuthorID`),
KEY `comm_ID` (`comm_ID`),
KEY `comm_PostTime` (`comm_PostTime`),
KEY `log_ID` (`log_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Table structure for blog_counter
-- ----------------------------
DROP TABLE IF EXISTS `blog_counter`;
CREATE TABLE `blog_counter` (
`coun_ID` int(11) NOT NULL AUTO_INCREMENT,
`coun_IP` varchar(20) DEFAULT NULL,
`coun_Agent` longtext,
`coun_Refer` varchar(250) DEFAULT NULL,
`coun_PostTime` datetime DEFAULT NULL,
PRIMARY KEY (`coun_ID`),
KEY `cou_ID` (`coun_ID`),
KEY `coun_IP` (`coun_IP`),
KEY `coun_PostTime` (`coun_PostTime`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Table structure for blog_keyword
-- ----------------------------
DROP TABLE IF EXISTS `blog_keyword`;
CREATE TABLE `blog_keyword` (
`key_ID` int(11) NOT NULL AUTO_INCREMENT,
`key_Name` varchar(255) DEFAULT NULL,
`key_Intro` longtext,
`key_URL` varchar(255) DEFAULT NULL,
KEY `key_ID` (`key_ID`),
KEY `key_Name` (`key_Name`),
KEY `key_URL` (`key_URL`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Table structure for blog_member
-- ----------------------------
DROP TABLE IF EXISTS `blog_member`;
CREATE TABLE `blog_member` (
`mem_ID` int(11) NOT NULL AUTO_INCREMENT,
`mem_Level` int(11) DEFAULT NULL,
`mem_Name` varchar(20) DEFAULT NULL,
`mem_Password` varchar(32) DEFAULT NULL,
`mem_Sex` tinyint(4) DEFAULT NULL,
`mem_Email` varchar(50) DEFAULT NULL,
`mem_MSN` varchar(50) DEFAULT NULL,
`mem_QQ` varchar(50) DEFAULT NULL,
`mem_HomePage` varchar(255) DEFAULT NULL,
`mem_LastVisit` datetime DEFAULT NULL,
`mem_Status` int(11) DEFAULT NULL,
`mem_PostLogs` int(11) DEFAULT NULL,
`mem_PostComms` int(11) DEFAULT NULL,
`mem_Intro` longtext,
`mem_IP` varchar(15) DEFAULT NULL,
`mem_Count` int(11) DEFAULT NULL,
PRIMARY KEY (`mem_ID`),
UNIQUE KEY `mem_Name` (`mem_Name`),
KEY `mem_ID` (`mem_ID`),
KEY `mem_UserGroupID` (`mem_Level`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Table structure for blog_tag
-- ----------------------------
DROP TABLE IF EXISTS `blog_tag`;
CREATE TABLE `blog_tag` (
`tag_ID` int(11) NOT NULL AUTO_INCREMENT,
`tag_Name` varchar(255) DEFAULT NULL,
`tag_Intro` longtext,
`tag_ParentID` int(11) DEFAULT NULL,
`tag_URL` varchar(255) DEFAULT NULL,
`tag_Order` int(11) DEFAULT NULL,
`tag_Count` int(11) DEFAULT NULL,
PRIMARY KEY (`tag_ID`),
KEY `id` (`tag_ID`),
KEY `parentid` (`tag_ParentID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Table structure for blog_trackback
-- ----------------------------
DROP TABLE IF EXISTS `blog_trackback`;
CREATE TABLE `blog_trackback` (
`tb_ID` int(11) NOT NULL AUTO_INCREMENT,
`log_ID` int(11) DEFAULT NULL,
`tb_URL` varchar(255) DEFAULT NULL,
`tb_Title` varchar(100) DEFAULT NULL,
`tb_Blog` varchar(50) DEFAULT NULL,
`tb_Excerpt` longtext,
`tb_PostTime` datetime DEFAULT NULL,
`tb_IP` varchar(15) DEFAULT NULL,
`tb_Agent` longtext,
PRIMARY KEY (`tb_ID`),
KEY `blog_ID` (`log_ID`),
KEY `tb_ID` (`tb_ID`),
KEY `tb_PostTime` (`tb_PostTime`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Table structure for blog_upload
-- ----------------------------
DROP TABLE IF EXISTS `blog_upload`;
CREATE TABLE `blog_upload` (
`ul_ID` int(11) NOT NULL AUTO_INCREMENT,
`ul_AuthorID` int(11) DEFAULT NULL,
`ul_FileSize` int(11) DEFAULT NULL,
`ul_FileName` varchar(50) DEFAULT NULL,
`ul_PostTime` datetime DEFAULT NULL,
`ul_Quote` varchar(255) DEFAULT NULL,
`ul_DownNum` int(11) DEFAULT NULL,
PRIMARY KEY (`ul_ID`),
UNIQUE KEY `ul_FileName` (`ul_FileName`),
KEY `log_AuthorID` (`ul_AuthorID`),
KEY `log_PostTime` (`ul_PostTime`),
KEY `ul_AuthorID` (`ul_FileSize`),
KEY `ul_DownNum` (`ul_DownNum`),
KEY `ym_ID` (`ul_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `blog_member` VALUES ('1', '1', 'zblogger', 'aa055c6d7875a18fa49058c2c48f2140', '0', 'a@b.com', null, null, '', '2005-02-17 08:43:28', '0', '0', '0', null, null, '0');