74 lines
3.0 KiB
PL/PgSQL
74 lines
3.0 KiB
PL/PgSQL
/*
|
|
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;
|