text: /*
  Navicat MySQL Data Transfer
  
  Source Server         : localhost
  Source Server Version : 50553
  Source Host           : localhost:3306
  Source Database       : test
  
  Target Server Type    : MYSQL
  Target Server Version : 50553
  File Encoding         : 65001
  
  Date: 2018-03-15 22:40:32
  */
  
  SET FOREIGN_KEY_CHECKS=0;
  
  -- ----------------------------
  -- Table structure for book
  -- ----------------------------
  DROP TABLE IF EXISTS `book`;
  CREATE TABLE `book` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `name` varchar(128) DEFAULT NULL,
    `price` decimal(8,2) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of book
  -- ----------------------------
  INSERT INTO `book` VALUES ('1', 'book1', '10.10');
  INSERT INTO `book` VALUES ('2', 'book2', '9.90');
  
  -- ----------------------------
  -- Table structure for user
  -- ----------------------------
  DROP TABLE IF EXISTS `user`;
  CREATE TABLE `user` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `username` varchar(128) DEFAULT NULL,
    `password` varchar(128) DEFAULT NULL,
    `age` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of user
  -- ----------------------------
  INSERT INTO `user` VALUES ('1', 'liuzhenxiang', '1', '1');
  
  -- ----------------------------
  -- Table structure for userbook
  -- ----------------------------
  DROP TABLE IF EXISTS `userbook`;
  CREATE TABLE `userbook` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `user_id` int(11) DEFAULT NULL,
    `book_id` int(11) DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
  
  -- ----------------------------
  -- Records of userbook
  -- ----------------------------
  INSERT INTO `userbook` VALUES ('1', '1', '1');
  INSERT INTO `userbook` VALUES ('2', '1', '2');
  