library.sql

来自「一个用java开发的具有搜索功能的图书管理系统」· SQL 代码 · 共 129 行 · 第 1/5 页

INSERT INTO `administrator` VALUES ('jkghkjhbn','1','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('nbvcntr','75','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('nbvzvcxzvb','1236','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('nnbvcgrfgf','45','2007-06-21 00:00:00',NULL);
INSERT INTO `administrator` VALUES ('ytrewrt','85','2007-06-21 00:00:00',NULL);


#
# Table structure for table book
#

CREATE TABLE `book` (
  `bookID` bigint(20) unsigned NOT NULL auto_increment,
  `bookName` varchar(50) NOT NULL,
  `author` varchar(20) NOT NULL,
  `sort` varchar(30) NOT NULL,
  `price` float unsigned NOT NULL,
  `description` text NOT NULL,
  `publishDate` date NOT NULL,
  `totality` smallint(6) default '0',
  `stocks` smallint(6) default '0',
  `cover` mediumblob,
  `remark` mediumtext,
  PRIMARY KEY  (`bookID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;