数据库/jspblog.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
MySQL Data Transfer
Source Host: localhost
Source Database: jspblog
Target Host: localhost
Target Database: jspblog
Date: 2013-5-4 19:35:27
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for blog
-- ----------------------------
CREATE TABLE `blog` (
  `bid` int(11) NOT NULL auto_increment,
  `btitle` varchar(50) default NULL,
  `typeid` int(11) default NULL,
  `lbid` int(11) default NULL,
  `blgcontent` varchar(4000) default NULL,
  `uname` varchar(40) default NULL,
  `btime` date default NULL,
  `linknum` int(11) default '0',
  PRIMARY KEY  (`bid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for bloglb
-- ----------------------------
CREATE TABLE `bloglb` (
  `lbid` int(11) NOT NULL auto_increment,
  `lbname` varchar(50) default NULL,
  `lbdesc` varchar(100) default NULL,
  `lbuser` varchar(40) default NULL,
  PRIMARY KEY  (`lbid`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for blogtype
-- ----------------------------
CREATE TABLE `blogtype` (
  `typeid` int(11) NOT NULL auto_increment,
  `typename` varchar(40) default NULL,
  PRIMARY KEY  (`typeid`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for message
-- ----------------------------
CREATE TABLE `message` (
  `mid` int(11) NOT NULL auto_increment,
  `bid` int(11) default NULL,
  `uname` varchar(50) default NULL,
  `mtime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  `content` varchar(1000) default NULL,
  PRIMARY KEY  (`mid`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=gb2312;

-- ----------------------------
-- Table structure for users
-- ----------------------------