SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';CREATE SCHEMA IF NOT EXISTS `easy_book` DEFAULT CHARACTER SET latin1 ;
USE `easy_book` ;-- -----------------------------------------------------
-- Table `easy_book`.`admin`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`admin` (
`Admin` VARCHAR(20) NULL DEFAULT NULL ,
`Password` VARCHAR(30) NOT NULL )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `easy_book`.`response`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`response` (
`Response_id` INT(10) NOT NULL ,
`Response_orderId` INT(10) NOT NULL ,
`Response_kind` TINYINT(4) NOT NULL ,
`Response_star` TINYINT(4) NOT NULL ,
`Response_time` DATE NOT NULL ,
`Response_content` TINYTEXT NULL DEFAULT NULL ,
PRIMARY KEY (`Response_id`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `easy_book`.`orderdic`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`orderdic` (
`OrderDic_orderId` INT(10) NOT NULL ,
`OrderDic_bookId` INT(10) NOT NULL ,
PRIMARY KEY(`OrderDic_orderId` ,`OrderDic_bookId`),
INDEX `fk_orderdic_response1` (`OrderDic_orderId` ASC) ,
CONSTRAINT `fk_orderdic_response1`
FOREIGN KEY (`OrderDic_orderId` )
REFERENCES `easy_book`.`response` (`Response_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `easy_book`.`book`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`book` (
`Book_id` INT(10) NOT NULL ,
`Book_name` VARCHAR(20) NOT NULL ,
`Book_introduction` TEXT NOT NULL ,
`Book_price` DECIMAL(5,2) NOT NULL ,
`Book_PDF` VARCHAR(80) NULL DEFAULT NULL ,
`Book_num` INT(11) NOT NULL ,
`Book_saleNum` INT(11) NOT NULL ,
`Book_countPrice` DECIMAL(5,2) NULL DEFAULT NULL ,
`Book_Sphoto` VARCHAR(80) NOT NULL ,
`Book_Bphoto` VARCHAR(80) NOT NULL ,
`Book_kind` INT(1) NOT NULL ,
PRIMARY KEY (`Book_id`) ,
CONSTRAINT `fk_book_orderdic1`
FOREIGN KEY (`Book_id` )
REFERENCES `easy_book`.`orderdic` (`OrderDic_bookId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `easy_book`.`order`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`order` (
`Order_id` INT(10) NOT NULL ,
`Order_userId` INT(10) NOT NULL ,
`Order_price` DECIMAL(8,2) NOT NULL ,
`Order_addr` VARCHAR(80) NOT NULL ,
`Order_phone` VARCHAR(15) NOT NULL ,
`Order_date` DATE NOT NULL ,
`Order_status` TINYINT(4) NULL DEFAULT '0' ,
PRIMARY KEY (`Order_id`) ,
CONSTRAINT `fk_order_orderdic1`
FOREIGN KEY (`Order_id` )
REFERENCES `easy_book`.`orderdic` (`OrderDic_orderId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `easy_book`.`user`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`user` (
`User_id` INT(10) NOT NULL ,
`User_name` VARCHAR(20) NULL DEFAULT NULL ,
`User_psd` VARCHAR(30) NOT NULL ,
`User_account` VARCHAR(20) NOT NULL ,
`User_photo` VARCHAR(80) NULL DEFAULT NULL ,
`User_age` TINYINT(4) NULL DEFAULT '0' ,
`User_sex` TINYINT(4) NULL DEFAULT '0' ,
`User_addr` VARCHAR(100) NULL DEFAULT NULL ,
`User_email` VARCHAR(40) NULL DEFAULT NULL ,
PRIMARY KEY (`User_id`) ,
CONSTRAINT `fk_user_order`
FOREIGN KEY (`User_id` )
REFERENCES `easy_book`.`order` (`Order_userId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL';CREATE SCHEMA IF NOT EXISTS `easy_book` DEFAULT CHARACTER SET latin1 ;
USE `easy_book` ;-- -----------------------------------------------------
-- Table `easy_book`.`admin`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`admin` (
`Admin` VARCHAR(20) NULL DEFAULT NULL ,
`Password` VARCHAR(30) NOT NULL )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `easy_book`.`response`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`response` (
`Response_id` INT(10) NOT NULL ,
`Response_orderId` INT(10) NOT NULL ,
`Response_kind` TINYINT(4) NOT NULL ,
`Response_star` TINYINT(4) NOT NULL ,
`Response_time` DATE NOT NULL ,
`Response_content` TINYTEXT NULL DEFAULT NULL ,
PRIMARY KEY (`Response_id`) )
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `easy_book`.`orderdic`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`orderdic` (
`OrderDic_orderId` INT(10) NOT NULL ,
`OrderDic_bookId` INT(10) NOT NULL ,
PRIMARY KEY(`OrderDic_orderId` ,`OrderDic_bookId`),
INDEX `fk_orderdic_response1` (`OrderDic_orderId` ASC) ,
CONSTRAINT `fk_orderdic_response1`
FOREIGN KEY (`OrderDic_orderId` )
REFERENCES `easy_book`.`response` (`Response_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `easy_book`.`book`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`book` (
`Book_id` INT(10) NOT NULL ,
`Book_name` VARCHAR(20) NOT NULL ,
`Book_introduction` TEXT NOT NULL ,
`Book_price` DECIMAL(5,2) NOT NULL ,
`Book_PDF` VARCHAR(80) NULL DEFAULT NULL ,
`Book_num` INT(11) NOT NULL ,
`Book_saleNum` INT(11) NOT NULL ,
`Book_countPrice` DECIMAL(5,2) NULL DEFAULT NULL ,
`Book_Sphoto` VARCHAR(80) NOT NULL ,
`Book_Bphoto` VARCHAR(80) NOT NULL ,
`Book_kind` INT(1) NOT NULL ,
PRIMARY KEY (`Book_id`) ,
CONSTRAINT `fk_book_orderdic1`
FOREIGN KEY (`Book_id` )
REFERENCES `easy_book`.`orderdic` (`OrderDic_bookId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `easy_book`.`order`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`order` (
`Order_id` INT(10) NOT NULL ,
`Order_userId` INT(10) NOT NULL ,
`Order_price` DECIMAL(8,2) NOT NULL ,
`Order_addr` VARCHAR(80) NOT NULL ,
`Order_phone` VARCHAR(15) NOT NULL ,
`Order_date` DATE NOT NULL ,
`Order_status` TINYINT(4) NULL DEFAULT '0' ,
PRIMARY KEY (`Order_id`) ,
CONSTRAINT `fk_order_orderdic1`
FOREIGN KEY (`Order_id` )
REFERENCES `easy_book`.`orderdic` (`OrderDic_orderId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;
-- -----------------------------------------------------
-- Table `easy_book`.`user`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `easy_book`.`user` (
`User_id` INT(10) NOT NULL ,
`User_name` VARCHAR(20) NULL DEFAULT NULL ,
`User_psd` VARCHAR(30) NOT NULL ,
`User_account` VARCHAR(20) NOT NULL ,
`User_photo` VARCHAR(80) NULL DEFAULT NULL ,
`User_age` TINYINT(4) NULL DEFAULT '0' ,
`User_sex` TINYINT(4) NULL DEFAULT '0' ,
`User_addr` VARCHAR(100) NULL DEFAULT NULL ,
`User_email` VARCHAR(40) NULL DEFAULT NULL ,
PRIMARY KEY (`User_id`) ,
CONSTRAINT `fk_user_order`
FOREIGN KEY (`User_id` )
REFERENCES `easy_book`.`order` (`Order_userId` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = latin1;SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货