个人博客mysql 建表与数据测试

//建博客表

CREATE TABLE `blog` (  
  `bId` int(11) NOT NULL AUTO_INCREMENT,
  `bUid` int(11),
  `bAuthor` varchar(40) NOT NULL,
  `bCateid` int(11),
  `bIstj` boolean NOT NULL,
  `bTitle` varchar(50) NOT NULL,  
  `bContent` text NOT NULL, 
  `bDate` TIMESTAMP,
  `bClicks` int(10) NOT NULL,
  `bComments` int(10) NOT NULL,
  PRIMARY KEY (`bId`)
  
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

//建类别表

CREATE TABLE `category` (  
  `cId` int(10) NOT NULL AUTO_INCREMENT,  
  `cName` varchar(40) NOT NULL, 
  `cDate` TIMESTAMP, 
  PRIMARY KEY (`cId`)  
)ENGINE=InnoDB DEFAULT CHARSET=utf8;

//建评论表

CREATE TABLE `comment` (  
  `mId` int(11) NOT NULL AUTO_INCREMENT,  
  `mUser` varchar(40) NOT NULL,  
  `mEmail` varchar(50) NOT NULL,
  `mContent` text NOT NULL,
  `mDate` TIMES