text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : localhost
  Source Server Version : 50716
  Source Host           : localhost:3306
  Source Database       : book
  
  Target Server Type    : MYSQL
  Target Server Version : 50716
  File Encoding         : 65001
  
  Date: 2017-12-27 19:25:49
  */
  
  
  SET FOREIGN_KEY_CHECKS=0;
  
  
  -- ----------------------------
  -- Table structure for `book_info`
  -- ----------------------------
  DROP TABLE IF EXISTS `book_info`;
  CREATE TABLE `book_info` (
    `book_id` int(11) NOT NULL AUTO_INCREMENT,
    `book_name` varchar(15) DEFAULT NULL,
    `book_author` varchar(15) DEFAULT NULL,
    `book_price` decimal(5,2) DEFAULT NULL,
    `book_type` varchar(15) DEFAULT NULL,
    `book_publish` varchar(15) DEFAULT NULL,
    `book_sum` int(255) DEFAULT NULL,
    `book_mark` varchar(255) DEFAULT NULL,
    PRIMARY KEY (`book_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of book_info
  -- ----------------------------
  INSERT INTO `book_info` VALUES ('1', 'aaa', 'aa', '222.00', 'aaa', 'aaa', '2', null);
  INSERT INTO `book_info` VALUES ('2', 'eee', 'ee', '0.00', 'ee', 'eeee', '200', null);
  
  -- ----------------------------
  -- Table structure for `record_info`
  -- ----------------------------
  DROP TABLE IF EXISTS `record_info`;
  CREATE TABLE `record_info` (
    `record_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) DEFAULT NULL,
    `book_id` int(11) DEFAULT NULL,
    `book_name` varchar(15) DEFAULT NULL,
    `book_author` varchar(15) DEFAULT NULL,
    `book_price` decimal(5,2) DEFAULT NULL,
    `book_type` varchar(15) DEFAULT NULL,
    `book_publish` varchar(15) DEFAULT NULL,
    `user_name` varchar(15) DEFAULT NULL,
    `record_time` datetime DEFAULT NULL,
    PRIMARY KEY (`record_id`),
    KEY `FK_Reference_1` (`user_id`),
    KEY `FK_Reference_2` (`book_id`),
    CONSTRAINT `FK_Reference_1` FOREIGN KEY (`user_id`) REFERENCES `user_info` (`user_id`),
    CONSTRAINT `FK_Reference_2` FOREIGN KEY (`book_id`) REFERENCES `book_info` (`book_id`)
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of record_info
  -- ----------------------------
  
  -- ----------------------------
  -- Table structure for `user_info`
  -- ----------------------------
  DROP TABLE IF EXISTS `user_info`;
  CREATE TABLE `user_info` (
    `user_id` int(11) NOT NULL AUTO_INCREMENT,
    `user_account` varchar(15) DEFAULT NULL,
    `user_pw` varchar(15) DEFAULT NULL,
    `user_number` varchar(15) DEFAULT NULL,
    `user_name` varchar(10) DEFAULT NULL,
    `user_age` int(11) DEFAULT NULL,
    `user_sex` varchar(5) DEFAULT NULL,
    `user_mark` varchar(5) DEFAULT NULL,
    PRIMARY KEY (`user_id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of user_info
  -- ----------------------------
  INSERT INTO `user_info` VALUES ('1', 'admin', '123456', '123456789', '小别同志', '23', '保密', '管理员');
  INSERT INTO `user_info` VALUES ('2', '小鱼', '123456', '1415925547', '于得水', '22', '男', null);
  INSERT INTO `user_info` VALUES ('3', '小刘', '123456', '1415925548', '刘备', '23', '男', '1');
  INSERT INTO `user_info` VALUES ('4', '111', '111', '111', '111', '111', '保密', '管理员');
  INSERT INTO `user_info` VALUES ('5', '3333', '3333', '3333', '5555', '22', '保密', '管理员');
  INSERT INTO `user_info` VALUES ('7', '', '', '', '', '0', '保密', '管理员');
  