/*
 Navicat Premium Data Transfer

 Source Server         : 本地数据库
 Source Server Type    : MySQL
 Source Server Version : 80013
 Source Host           : localhost:3306
 Source Schema         : Novel

 Target Server Type    : MySQL
 Target Server Version : 80013
 File Encoding         : 65001

 Date: 20/01/2019 23:47:49
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for novel_collection
-- ----------------------------
DROP TABLE IF EXISTS `novel_collection`;
CREATE TABLE `novel_collection` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `collection_user` varchar(255) NOT NULL COMMENT '用户的id',
  `collection_bookid` varchar(255) DEFAULT NULL COMMENT '用户收藏的小说id',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of novel_collection
-- ----------------------------
BEGIN;
INSERT INTO `novel_collection` VALUES (1, '1', '25/25991/');
INSERT INTO `novel_collection` VALUES (2, '1', '29/29000/');
INSERT INTO `novel_collection` VALUES (3, '1', '27/27613/');
INSERT INTO `novel_collection` VALUES (4, '1', '25/25952/');
INSERT INTO `novel_collection` VALUES (5, '1', '26/26966/');
INSERT INTO `novel_collection` VALUES (6, '1', '25/25155/');
INSERT INTO `novel_collection` VALUES (7, '1', '26/26472/');
INSERT INTO `novel_collection` VALUES (8, '2', '27/27613/');
COMMIT;

-- ----------------------------
-- Table structure for novel_user
-- ----------------------------
DROP TABLE IF EXISTS `novel_user`;
CREATE TABLE `novel_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_phone` varchar(11) DEFAULT NULL,
  `user_pwd` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `user_ip` varchar(15) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of novel_user
-- ----------------------------
BEGIN;
INSERT INTO `novel_user` VALUES (1, '15155145354', 'e10adc3949ba59abbe56e057f20f883e', '112.32.95.213');
INSERT INTO `novel_user` VALUES (2, '18305520337', 'e10adc3949ba59abbe56e057f20f883e', '112.32.95.213');
INSERT INTO `novel_user` VALUES (3, '18305520334', 'e10adc3949ba59abbe56e057f20f883e', '112.32.95.213');
INSERT INTO `novel_user` VALUES (4, '15155145352', '25f9e794323b453885f5181f1b624d0b', '112.32.95.213');
INSERT INTO `novel_user` VALUES (5, '18305520338', 'e10adc3949ba59abbe56e057f20f883e', '112.32.95.213');
INSERT INTO `novel_user` VALUES (6, '18305520339', 'e10adc3949ba59abbe56e057f20f883e', '112.32.95.213');
INSERT INTO `novel_user` VALUES (7, '15155145350', 'e10adc3949ba59abbe56e057f20f883e', '112.32.95.213');
INSERT INTO `novel_user` VALUES (8, '13003085278', 'e10adc3949ba59abbe56e057f20f883e', '112.32.95.213');
INSERT INTO `novel_user` VALUES (9, '18305520336', 'e10adc3949ba59abbe56e057f20f883e', '112.32.95.213');
INSERT INTO `novel_user` VALUES (10, '15155145359', 'e10adc3949ba59abbe56e057f20f883e', '112.32.95.213');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;