网上书店数据库

/* Navicat MySQL Data Transfer Source Server : localhost_3306 Source Server Version : 50524 Source Host : localhost:3306 Source Database : bookstore Target Server Type : MYSQL Target Server Version : 50524 File Encoding : 65001 Date: 2016-01-06 10:50:08 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `book` -- ---------------------------- DROP TABLE IF EXISTS `book`; CREATE TABLE `book` ( `bookid` int(11) NOT NULL, `catalogid` int(11) NOT NULL, `boo kname` varchar(20) NOT NULL, `price` int(11) NOT NULL, `picture` varchar(30) NOT NULL, PRIMARY KEY (`bookid`), KEY `FK_Relationship_3` (`catalogid`), CONSTRAINT `FK_Relationship_3` FOREIGN KEY (`catalogid`) REFERENCES `catalog` (`catalogid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of book kname` varchar(20) NOT NULL, `price` int(11) NOT NULL, `picture` varchar(30) NOT NULL, PRIMARY KEY (`bookid`), KEY `FK_Relationship_3` (`catalogid`), CONSTRAINT `FK_Relationship_3` FOREIGN KEY (`catalogid`) REFERENCES `catalog` (`catalogid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of book