online.sql

来自「在线读书交流平台」· SQL 代码 · 共 135 行 · 第 1/5 页

  `writer` varchar(20) NOT NULL default '',
  `userId` int(15) default NULL,
  `status` int(2) NOT NULL default '0',
  `price` int(20) NOT NULL default '0',
  `category` varchar(20) default NULL,
  `clickCount` int(15) default '0',
  `recomCount` int(11) default '0',
  `updateTime` date default NULL,
  `wordCount` int(11) default NULL,
  `lastChapter` varchar(20) default NULL,
  `chapterCount` int(11) NOT NULL default '0',
  `imagePath` varchar(50) default 'UploadImages/defaultBookImage.jpg',
  `discription` varchar(500) default NULL,
  `notice` varchar(500) default NULL,
  `label` varchar(50) default NULL,
  PRIMARY KEY  (`bookId`)
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8 ROW_FORMAT=REDUNDANT;

#
# Dumping data for table book
#

INSERT INTO `book` VALUES (1,'坏蛋是怎样炼成的','六道',8,1,0,'都市情感',2,0,'2008-11-25',NULL,NULL,3,NULL,NULL,NULL,NULL);
INSERT INTO `book` VALUES (2,'少林八绝','天魔圣',8,1,0,'武侠仙侠',0,0,'2008-11-25',NULL,NULL,3,NULL,NULL,NULL,NULL);
INSERT INTO `book` VALUES (3,'绝色佳人','乘胜＆追击 ',8,1,0,'都市情感',0,0,'2008-11-25',NULL,NULL,3,NULL,NULL,NULL,NULL);
INSERT INTO `book` VALUES (4,'和空姐同居的日子','三十',8,1,0,'都市情感',0,0,'2008-11-25',NULL,NULL,3,NULL,NULL,NULL,NULL);
INSERT INTO `book` VALUES (5,'世纪三国 ','罗吉甫',8,1,0,'军事历史',0,0,'2008-11-25',NULL,NULL,3,NULL,NULL,NULL,NULL);