数据库我不太懂求大神帮忙啊SETFOREIGN_KEY_CHECKS=0;DROPTABLEIFEXISTS`tb_bookcase`;CREATETABLE`tb_bookcase`(`id`int(10)unsignedNOTNULLAUTO_INCREMENT,`name`varchar(30)DEFAUL...
数据库我不太懂 求大神帮忙啊
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS `tb_bookcase`;
CREATE TABLE `tb_bookcase` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=gbk;
INSERT INTO `tb_bookcase` VALUES ('4', '宸-1');
INSERT INTO `tb_bookcase` VALUES ('5', '宸-2');
INSERT INTO `tb_bookcase` VALUES ('6', '鍙矨-1');
INSERT INTO `tb_bookcase` VALUES ('8', '鍙矨-2');
DROP TABLE IF EXISTS `tb_bookinfo`;
CREATE TABLE `tb_bookinfo` (
`barcode` varchar(30) DEFAULT NULL,
`bookname` varchar(70) DEFAULT NULL,
`typeid` int(10) unsigned DEFAULT NULL,
`author` varchar(30) DEFAULT NULL,
`translator` varchar(30) DEFAULT NULL,
`ISBN` varchar(20) DEFAULT NULL,
`price` float(8,2) DEFAULT NULL,
`page` int(10) unsigned DEFAULT NULL,
`bookcase` int(10) unsigned DEFAULT NULL,
`inTime` date DEFAULT NULL,
`operator` varchar(30) DEFAULT NULL,
`del` tinyint(1) DEFAULT '0',
`id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=gbk;
INSERT INTO `tb_bookinfo` VALUES ('9787302210337', 'Java Web寮€鍙戝疄鎴桦疂鍏?, '4', '鐜嫔浗杈?, '浜屽▋', '302', '89.00', '834', '4', '-02-24', 'mr', '0', '7');
INSERT INTO `tb_bookinfo` VALUES ('9787115195975', 'Java Web寮€鍙戝吀鍨嬫ā鍧楀ぇ鍏?, '4', '鐜嫔浗杈夈€佺帇姣呫€佺帇娈婂畤', '', '115', '89.00', '752', '5', '-02-24', 'mr', '0', '8');
INSERT INTO `tb_bookinfo` VALUES ('4521212', 'njknjn', '5', 'mnm', '', '115', '11.00', '0', '4', '-02-24', 'mr', '1', '9');
INSERT INTO `tb_bookinfo` VALUES ('gf', 'gfhgf', '4', '', '', '111', '26.00', '0', '4', '-02-24', 'mr', '1', '10');
INSERT INTO `tb_bookinfo` VALUES ('989823131', 'java', '4', 'user', 'user', '115', '12.00', '123', '4', '-11-29', 'admin', '0', '11');
DROP TABLE IF EXISTS `tb_booktype`;
CREATE TABLE `tb_booktype` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`typename` varchar(30) DEFAULT NULL,
`days` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=gbk;
INSERT INTO `tb_booktype` VALUES ('4', '缃戠粶缂栫▼', '20');
INSERT INTO `tb_booktype` VALUES ('5', '鏁版嵁搴揿紑鍙?, '15');
DROP TABLE IF EXISTS `tb_manager`;
CREATE TABLE `tb_manager` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(30) DEFAULT NULL,
`PWD` varchar(30) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=gbk;
INSERT INTO `tb_manager` VALUES ('9', 'admin', '111');
DROP TABLE IF EXISTS `tb_publishing`;
CREATE TABLE `tb_publishing` (
`ISBN` varchar(20) NOT NULL COMMENT 'ISBN鍙?,
`pubname` varchar(30) DEFAULT NULL COMMENT '鍑虹増绀惧悕绉?,
PRIMARY KEY (`ISBN`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
INSERT INTO `tb_publishing` VALUES ('111', '链烘宸ヤ笟鍑虹増绀?);
INSERT INTO `tb_publishing` VALUES ('115', '浜烘皯闾数鍑虹増绀?);
INSERT INTO `tb_publishing` VALUES ('302', '娓呭崕澶у鍑虹増绀?);
展开