/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 80020
Source Host           : localhost:3306
Source Database       : pet_battle

Target Server Type    : MYSQL
Target Server Version : 80020
File Encoding         : 65001

Date: 2020-06-27 09:28:28
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for friend_chat
-- ----------------------------
DROP TABLE IF EXISTS `friend_chat`;
CREATE TABLE `friend_chat` (
  `id` char(32) NOT NULL,
  `sender_id` int NOT NULL,
  `receiver_id` int NOT NULL,
  `message` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `send_time` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `my_user_id` (`sender_id`),
  KEY `friend_user_id` (`receiver_id`),
  CONSTRAINT `friend_chat_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `user_login` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `friend_chat_ibfk_2` FOREIGN KEY (`receiver_id`) REFERENCES `user_login` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of friend_chat
-- ----------------------------
INSERT INTO `friend_chat` VALUES ('714c1cf373e34757940838bfb3c6a545', '10000003', '10000008', '你好！', '2020-06-11 17:39:14');
INSERT INTO `friend_chat` VALUES ('bea3ce0d44c34bedb4586049dc25fc81', '10000003', '10000008', '离线消息测试哦！', '2020-06-11 17:39:04');

-- ----------------------------
-- Table structure for friend_mapper
-- ----------------------------
DROP TABLE IF EXISTS `friend_mapper`;
CREATE TABLE `friend_mapper` (
  `id` int NOT NULL AUTO_INCREMENT,
  `inviter_id` int NOT NULL,
  `invitee_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `my_user_id` (`inviter_id`),
  KEY `friend_user_id` (`invitee_id`),
  CONSTRAINT `friend_mapper_ibfk_1` FOREIGN KEY (`inviter_id`) REFERENCES `user_login` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `friend_mapper_ibfk_2` FOREIGN KEY (`invitee_id`) REFERENCES `user_login` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of friend_mapper
-- ----------------------------
INSERT INTO `friend_mapper` VALUES ('15', '10000003', '10000008');

-- ----------------------------
-- Table structure for shop_goods
-- ----------------------------
DROP TABLE IF EXISTS `shop_goods`;
CREATE TABLE `shop_goods` (
  `id` int NOT NULL AUTO_INCREMENT,
  `goods_id` int NOT NULL,
  `goods_type` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `currency` varchar(8) NOT NULL,
  `price` int NOT NULL,
  `single_buy` int NOT NULL,
  `max_buy` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of shop_goods
-- ----------------------------
INSERT INTO `shop_goods` VALUES ('1', '6004', 'pet', 'coin', '10000', '1', '5');
INSERT INTO `shop_goods` VALUES ('2', '6005', 'pet', 'diamond', '500', '1', '3');
INSERT INTO `shop_goods` VALUES ('3', '6006', 'pet', 'diamond', '2000', '1', '1');
INSERT INTO `shop_goods` VALUES ('4', '6095', 'pet', 'diamond', '5000', '1', '1');
INSERT INTO `shop_goods` VALUES ('5', '6115', 'pet', 'diamond', '5000', '1', '1');
INSERT INTO `shop_goods` VALUES ('6', '6131', 'pet', 'diamond', '2000', '1', '1');
INSERT INTO `shop_goods` VALUES ('7', '6133', 'pet', 'diamond', '2000', '1', '1');
INSERT INTO `shop_goods` VALUES ('8', '1001', 'prop', 'coin', '2000', '5', '100');
INSERT INTO `shop_goods` VALUES ('9', '1002', 'prop', 'coin', '5000', '5', '50');
INSERT INTO `shop_goods` VALUES ('10', '1003', 'prop', 'diamond', '200', '1', '30');
INSERT INTO `shop_goods` VALUES ('11', '1004', 'prop', 'diamond', '1000', '1', '10');
INSERT INTO `shop_goods` VALUES ('12', '2041', 'prop', 'diamond', '100', '1', '10');
INSERT INTO `shop_goods` VALUES ('13', '2042', 'prop', 'diamond', '100', '1', '10');
INSERT INTO `shop_goods` VALUES ('14', '2001', 'prop', 'diamond', '30', '3', '30');
INSERT INTO `shop_goods` VALUES ('15', '2002', 'prop', 'diamond', '30', '3', '30');
INSERT INTO `shop_goods` VALUES ('16', '2003', 'prop', 'diamond', '30', '3', '30');
INSERT INTO `shop_goods` VALUES ('17', '2011', 'prop', 'diamond', '60', '3', '20');
INSERT INTO `shop_goods` VALUES ('18', '2012', 'prop', 'diamond', '60', '3', '20');
INSERT INTO `shop_goods` VALUES ('19', '2013', 'prop', 'diamond', '60', '3', '20');
INSERT INTO `shop_goods` VALUES ('20', '2021', 'prop', 'diamond', '90', '3', '10');
INSERT INTO `shop_goods` VALUES ('21', '2022', 'prop', 'diamond', '90', '3', '10');
INSERT INTO `shop_goods` VALUES ('22', '2023', 'prop', 'diamond', '90', '3', '10');
INSERT INTO `shop_goods` VALUES ('23', '2031', 'prop', 'diamond', '50', '1', '15');
INSERT INTO `shop_goods` VALUES ('24', '2032', 'prop', 'diamond', '100', '1', '10');
INSERT INTO `shop_goods` VALUES ('25', '2033', 'prop', 'diamond', '150', '1', '5');
INSERT INTO `shop_goods` VALUES ('26', '1011', 'prop', 'diamond', '50', '1', '20');
INSERT INTO `shop_goods` VALUES ('27', '1021', 'prop', 'diamond', '200', '1', '5');
INSERT INTO `shop_goods` VALUES ('28', '6017', 'pet', 'diamond', '2000', '1', '1');
INSERT INTO `shop_goods` VALUES ('29', '6104', 'pet', 'diamond', '2000', '1', '1');
INSERT INTO `shop_goods` VALUES ('30', '6113', 'pet', 'diamond', '5000', '1', '1');
INSERT INTO `shop_goods` VALUES ('31', '6140', 'pet', 'diamond', '5000', '1', '1');
INSERT INTO `shop_goods` VALUES ('32', '3001', 'equipment', 'coin', '10000', '1', '50');
INSERT INTO `shop_goods` VALUES ('33', '3011', 'equipment', 'coin', '10000', '1', '50');
INSERT INTO `shop_goods` VALUES ('34', '3021', 'equipment', 'coin', '10000', '1', '50');
INSERT INTO `shop_goods` VALUES ('35', '3031', 'equipment', 'coin', '10000', '1', '50');
INSERT INTO `shop_goods` VALUES ('36', '3041', 'equipment', 'coin', '10000', '1', '50');
INSERT INTO `shop_goods` VALUES ('37', '3051', 'equipment', 'coin', '10000', '1', '50');
INSERT INTO `shop_goods` VALUES ('38', '3002', 'equipment', 'diamond', '200', '1', '30');
INSERT INTO `shop_goods` VALUES ('39', '3012', 'equipment', 'diamond', '200', '1', '30');
INSERT INTO `shop_goods` VALUES ('40', '3022', 'equipment', 'diamond', '200', '1', '30');
INSERT INTO `shop_goods` VALUES ('41', '3032', 'equipment', 'diamond', '200', '1', '30');
INSERT INTO `shop_goods` VALUES ('42', '3042', 'equipment', 'diamond', '200', '1', '30');
INSERT INTO `shop_goods` VALUES ('43', '3052', 'equipment', 'diamond', '200', '1', '30');
INSERT INTO `shop_goods` VALUES ('44', '3003', 'equipment', 'diamond', '500', '1', '10');
INSERT INTO `shop_goods` VALUES ('45', '3013', 'equipment', 'diamond', '500', '1', '10');
INSERT INTO `shop_goods` VALUES ('46', '3023', 'equipment', 'diamond', '500', '1', '10');
INSERT INTO `shop_goods` VALUES ('47', '3033', 'equipment', 'diamond', '500', '1', '10');
INSERT INTO `shop_goods` VALUES ('48', '3043', 'equipment', 'diamond', '500', '1', '10');
INSERT INTO `shop_goods` VALUES ('49', '3053', 'equipment', 'diamond', '500', '1', '10');

-- ----------------------------
-- Table structure for user_embattle
-- ----------------------------
DROP TABLE IF EXISTS `user_embattle`;
CREATE TABLE `user_embattle` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `user_pet_id` int NOT NULL,
  `sequence_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `user_pet_id` (`user_pet_id`),
  CONSTRAINT `user_embattle_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_login` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `user_embattle_ibfk_2` FOREIGN KEY (`user_pet_id`) REFERENCES `user_pet` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=554 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_embattle
-- ----------------------------
INSERT INTO `user_embattle` VALUES ('532', '10000008', '1391', '0');
INSERT INTO `user_embattle` VALUES ('533', '10000008', '1375', '1');
INSERT INTO `user_embattle` VALUES ('534', '10000008', '1374', '2');
INSERT INTO `user_embattle` VALUES ('535', '10000008', '1378', '3');
INSERT INTO `user_embattle` VALUES ('536', '10000008', '1376', '4');
INSERT INTO `user_embattle` VALUES ('537', '10000008', '1371', '5');
INSERT INTO `user_embattle` VALUES ('543', '10000003', '1381', '0');
INSERT INTO `user_embattle` VALUES ('544', '10000003', '1383', '1');
INSERT INTO `user_embattle` VALUES ('550', '10000003', '1389', '3');
INSERT INTO `user_embattle` VALUES ('551', '10000003', '1387', '4');
INSERT INTO `user_embattle` VALUES ('552', '10000003', '1386', '2');
INSERT INTO `user_embattle` VALUES ('553', '10000003', '1384', '5');

-- ----------------------------
-- Table structure for user_equipment
-- ----------------------------
DROP TABLE IF EXISTS `user_equipment`;
CREATE TABLE `user_equipment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `equipment_id` int NOT NULL,
  `main_status` varchar(255) NOT NULL,
  `vice_status` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `strength_level` int NOT NULL DEFAULT '0',
  `star_level` int NOT NULL DEFAULT '0',
  `user_pet_id` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  KEY `user_equipment_ibfk_2` (`user_pet_id`),
  CONSTRAINT `user_equipment_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_login` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=404 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_equipment
-- ----------------------------
INSERT INTO `user_equipment` VALUES ('353', '10000003', '3043', '{\"attack\":49}', '{\"hp\":198,\"critRate\":12,\"speed\":11}', '5', '0', '1381');
INSERT INTO `user_equipment` VALUES ('354', '10000003', '3053', '{\"resist\":25}', '{\"defend\":15,\"critRate\":8,\"speed\":13}', '0', '0', '1381');
INSERT INTO `user_equipment` VALUES ('355', '10000003', '3033', '{\"hp\":342}', '{\"defend\":19,\"hp\":188,\"speed\":12}', '2', '0', '1381');
INSERT INTO `user_equipment` VALUES ('356', '10000003', '3023', '{\"defend\":34}', '{\"hit\":12,\"critHurt\":25,\"hp\":187}', '0', '0', '1381');
INSERT INTO `user_equipment` VALUES ('358', '10000003', '3003', '{\"hit\":16}', '{\"defend\":26,\"resist\":13,\"speed\":14}', '2', '2', '1381');
INSERT INTO `user_equipment` VALUES ('360', '10000003', '3053', '{\"resist\":27}', '{\"defend\":17,\"attack\":48,\"speed\":15}', '3', '0', '1387');
INSERT INTO `user_equipment` VALUES ('361', '10000003', '3043', '{\"speed\":20}', '{\"hit\":13,\"critHurt\":20,\"resist\":13}', '0', '0', '1383');
INSERT INTO `user_equipment` VALUES ('363', '10000003', '3013', '{\"attack\":54}', '{\"critHurt\":25,\"hp\":189,\"critRate\":9}', '0', '0', '1381');
INSERT INTO `user_equipment` VALUES ('364', '10000003', '3023', '{\"defend\":29}', '{\"critHurt\":20,\"resist\":9,\"speed\":15}', '0', '0', '1387');
INSERT INTO `user_equipment` VALUES ('365', '10000003', '3003', '{\"resist\":26}', '{\"hit\":14,\"attack\":53,\"critRate\":11}', '2', '0', '1389');
INSERT INTO `user_equipment` VALUES ('366', '10000003', '3033', '{\"defend\":33}', '{\"attack\":47,\"resist\":9,\"hp\":264}', '0', '0', '1389');
INSERT INTO `user_equipment` VALUES ('367', '10000003', '3013', '{\"critHurt\":24}', '{\"defend\":27,\"critHurt\":16,\"resist\":13}', '0', '0', '1389');
INSERT INTO `user_equipment` VALUES ('369', '10000003', '3023', '{\"resist\":26}', '{\"defend\":26,\"hp\":202,\"speed\":13}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('370', '10000008', '3033', '{\"resist\":16}', '{\"hit\":13,\"defend\":17,\"critRate\":8}', '0', '0', '1373');
INSERT INTO `user_equipment` VALUES ('371', '10000008', '3013', '{\"attack\":52}', '{\"hit\":11,\"resist\":13,\"critRate\":12}', '0', '0', '1373');
INSERT INTO `user_equipment` VALUES ('372', '10000008', '3023', '{\"resist\":29}', '{\"resist\":12,\"critRate\":7,\"speed\":13}', '0', '0', '1373');
INSERT INTO `user_equipment` VALUES ('373', '10000008', '3003', '{\"defend\":23}', '{\"hit\":15,\"hp\":198,\"speed\":8}', '0', '0', '1373');
INSERT INTO `user_equipment` VALUES ('374', '10000008', '3053', '{\"hp\":322}', '{\"hit\":13,\"defend\":26,\"speed\":7}', '0', '0', '1373');
INSERT INTO `user_equipment` VALUES ('375', '10000008', '3053', '{\"defend\":30}', '{\"hit\":14,\"resist\":12,\"hp\":217}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('376', '10000008', '3043', '{\"attack\":63}', '{\"hit\":8,\"resist\":10,\"critRate\":11}', '0', '0', '1373');
INSERT INTO `user_equipment` VALUES ('377', '10000008', '3043', '{\"critRate\":17}', '{\"defend\":21,\"hp\":271,\"critRate\":13}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('378', '10000003', '3033', '{\"defend\":27}', '{\"resist\":11,\"hp\":217,\"speed\":7}', '0', '0', '1387');
INSERT INTO `user_equipment` VALUES ('379', '10000003', '3053', '{\"hp\":341}', '{\"critHurt\":18,\"resist\":11,\"hp\":211}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('380', '10000003', '3053', '{\"defend\":33}', '{\"critHurt\":18,\"resist\":12,\"critRate\":11}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('381', '10000003', '3053', '{\"resist\":16}', '{\"hp\":233,\"critRate\":12,\"speed\":11}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('382', '10000003', '3053', '{\"resist\":23}', '{\"critHurt\":30,\"defend\":20,\"attack\":38}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('383', '10000003', '3053', '{\"hp\":364}', '{\"hit\":11,\"attack\":45,\"speed\":13}', '0', '0', '1383');
INSERT INTO `user_equipment` VALUES ('384', '10000003', '3033', '{\"defend\":30}', '{\"critHurt\":17,\"critRate\":7,\"speed\":10}', '0', '0', '1383');
INSERT INTO `user_equipment` VALUES ('385', '10000003', '3033', '{\"defend\":27}', '{\"attack\":43,\"hp\":233,\"critRate\":9}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('386', '10000003', '3043', '{\"critRate\":15}', '{\"defend\":15,\"attack\":50,\"resist\":13}', '0', '0', '1387');
INSERT INTO `user_equipment` VALUES ('387', '10000003', '3043', '{\"speed\":24}', '{\"defend\":15,\"attack\":44,\"hp\":241}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('388', '10000003', '3043', '{\"critRate\":18}', '{\"attack\":47,\"hp\":274,\"critRate\":13}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('389', '10000003', '3033', '{\"resist\":16}', '{\"defend\":27,\"hp\":279,\"critRate\":15}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('390', '10000003', '3023', '{\"hit\":27}', '{\"hit\":12,\"critHurt\":30,\"defend\":22}', '0', '0', '1383');
INSERT INTO `user_equipment` VALUES ('391', '10000003', '3023', '{\"resist\":23}', '{\"critHurt\":23,\"attack\":36,\"critRate\":10}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('392', '10000003', '3013', '{\"critRate\":15}', '{\"critHurt\":16,\"critRate\":7,\"speed\":14}', '0', '0', '1383');
INSERT INTO `user_equipment` VALUES ('393', '10000003', '3023', '{\"hit\":29}', '{\"critHurt\":17,\"attack\":32,\"speed\":15}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('394', '10000003', '3013', '{\"attack\":65}', '{\"defend\":23,\"hp\":260,\"critRate\":15}', '0', '0', '1387');
INSERT INTO `user_equipment` VALUES ('395', '10000003', '3003', '{\"hit\":17}', '{\"hp\":214,\"critRate\":7,\"speed\":11}', '0', '0', '1383');
INSERT INTO `user_equipment` VALUES ('396', '10000003', '3003', '{\"resist\":22}', '{\"defend\":15,\"attack\":49,\"resist\":11}', '0', '0', '1387');
INSERT INTO `user_equipment` VALUES ('397', '10000003', '3003', '{\"resist\":17}', '{\"hit\":15,\"resist\":11,\"speed\":12}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('398', '10000003', '3003', '{\"resist\":15}', '{\"critHurt\":15,\"attack\":30,\"critRate\":14}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('399', '10000003', '3003', '{\"hit\":22}', '{\"defend\":20,\"attack\":50,\"resist\":8}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('400', '10000003', '3003', '{\"resist\":18}', '{\"hit\":9,\"defend\":17,\"speed\":7}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('401', '10000003', '3003', '{\"defend\":30}', '{\"hit\":12,\"critRate\":14,\"speed\":14}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('402', '10000003', '3003', '{\"defend\":25}', '{\"hit\":15,\"critHurt\":20,\"speed\":15}', '0', '0', '0');
INSERT INTO `user_equipment` VALUES ('403', '10000003', '3003', '{\"hit\":20}', '{\"critHurt\":27,\"resist\":10,\"speed\":12}', '0', '0', '0');

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `id` int NOT NULL,
  `nickname` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `gender` int NOT NULL DEFAULT '0',
  `avatarUrl` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `coin` int NOT NULL DEFAULT '0',
  `diamond` int NOT NULL DEFAULT '0',
  `strength` int NOT NULL DEFAULT '120',
  `integral` int NOT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `user_info_ibfk_1` FOREIGN KEY (`id`) REFERENCES `user_login` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES ('10000003', '玩家10000003', '2', 'Texture/Icon/HeadPhoto/6901', '999643900', '503234', '100', '1082');
INSERT INTO `user_info` VALUES ('10000008', '玩家10000008', '1', 'Texture/Icon/HeadPhoto/6902', '90000', '39924', '100', '993');

-- ----------------------------
-- Table structure for user_login
-- ----------------------------
DROP TABLE IF EXISTS `user_login`;
CREATE TABLE `user_login` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `password` varchar(24) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10000015 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_login
-- ----------------------------
INSERT INTO `user_login` VALUES ('10000003', '123456', '123456');
INSERT INTO `user_login` VALUES ('10000008', 'asdfgh', 'asdfgh');
INSERT INTO `user_login` VALUES ('10000013', 'asdasd', 'asdasd');
INSERT INTO `user_login` VALUES ('10000014', '123123', '123123');

-- ----------------------------
-- Table structure for user_pet
-- ----------------------------
DROP TABLE IF EXISTS `user_pet`;
CREATE TABLE `user_pet` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `pet_id` int NOT NULL,
  `pet_level` int NOT NULL DEFAULT '0',
  `blood_level` int NOT NULL DEFAULT '0',
  `break_level` int NOT NULL DEFAULT '0',
  `pet_exp` int NOT NULL DEFAULT '0',
  `blood_exp` int NOT NULL DEFAULT '0',
  `fragment` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_pet_ibfk_1` (`user_id`),
  CONSTRAINT `user_pet_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_login` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1392 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_pet
-- ----------------------------
INSERT INTO `user_pet` VALUES ('1370', '10000003', '6006', '100', '0', '0', '0', '0', '2');
INSERT INTO `user_pet` VALUES ('1371', '10000008', '6095', '100', '0', '0', '0', '0', '6');
INSERT INTO `user_pet` VALUES ('1372', '10000008', '6017', '100', '0', '0', '0', '0', '2');
INSERT INTO `user_pet` VALUES ('1373', '10000008', '6140', '100', '0', '0', '600000', '0', '2');
INSERT INTO `user_pet` VALUES ('1374', '10000008', '6005', '100', '0', '0', '0', '0', '18');
INSERT INTO `user_pet` VALUES ('1375', '10000008', '6104', '100', '0', '0', '0', '0', '4');
INSERT INTO `user_pet` VALUES ('1376', '10000008', '6004', '100', '0', '0', '0', '0', '14');
INSERT INTO `user_pet` VALUES ('1377', '10000008', '6115', '100', '0', '0', '0', '0', '8');
INSERT INTO `user_pet` VALUES ('1378', '10000008', '6133', '100', '0', '0', '0', '0', '1');
INSERT INTO `user_pet` VALUES ('1379', '10000008', '6113', '100', '0', '0', '0', '0', '1');
INSERT INTO `user_pet` VALUES ('1380', '10000008', '6131', '100', '0', '0', '0', '0', '2');
INSERT INTO `user_pet` VALUES ('1381', '10000003', '6115', '100', '0', '0', '0', '0', '4');
INSERT INTO `user_pet` VALUES ('1382', '10000003', '6004', '100', '0', '1', '100000', '0', '17');
INSERT INTO `user_pet` VALUES ('1383', '10000003', '6017', '100', '0', '0', '600000', '0', '2');
INSERT INTO `user_pet` VALUES ('1384', '10000003', '6113', '100', '0', '0', '0', '0', '5');
INSERT INTO `user_pet` VALUES ('1385', '10000003', '6005', '100', '0', '0', '0', '0', '11');
INSERT INTO `user_pet` VALUES ('1386', '10000003', '6104', '100', '1', '0', '0', '8', '2');
INSERT INTO `user_pet` VALUES ('1387', '10000003', '6131', '100', '0', '0', '0', '0', '5');
INSERT INTO `user_pet` VALUES ('1388', '10000003', '6095', '100', '0', '0', '0', '0', '6');
INSERT INTO `user_pet` VALUES ('1389', '10000003', '6140', '100', '0', '2', '0', '0', '0');
INSERT INTO `user_pet` VALUES ('1390', '10000003', '6133', '100', '0', '0', '0', '0', '0');
INSERT INTO `user_pet` VALUES ('1391', '10000008', '6006', '100', '0', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for user_prop
-- ----------------------------
DROP TABLE IF EXISTS `user_prop`;
CREATE TABLE `user_prop` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `prop_id` int NOT NULL,
  `amount` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_id` (`user_id`),
  CONSTRAINT `user_prop_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_login` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=405 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_prop
-- ----------------------------
INSERT INTO `user_prop` VALUES ('386', '10000003', '1003', '13');
INSERT INTO `user_prop` VALUES ('388', '10000003', '2032', '1');
INSERT INTO `user_prop` VALUES ('393', '10000003', '1001', '10');
INSERT INTO `user_prop` VALUES ('394', '10000003', '1004', '9');
INSERT INTO `user_prop` VALUES ('395', '10000003', '2002', '21');
INSERT INTO `user_prop` VALUES ('397', '10000008', '1004', '4');
INSERT INTO `user_prop` VALUES ('399', '10000003', '2001', '18');
INSERT INTO `user_prop` VALUES ('400', '10000003', '2003', '21');
INSERT INTO `user_prop` VALUES ('401', '10000003', '1002', '5');
INSERT INTO `user_prop` VALUES ('403', '10000003', '1021', '2');
INSERT INTO `user_prop` VALUES ('404', '10000003', '1011', '1');

-- ----------------------------
-- Table structure for user_vs_rank
-- ----------------------------
DROP TABLE IF EXISTS `user_vs_rank`;
CREATE TABLE `user_vs_rank` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `avatarUrl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pet_ids` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `pet_levels` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `strength` int NOT NULL,
  `integral` int NOT NULL,
  `create_time` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`,`user_id`),
  UNIQUE KEY `user_id` (`user_id`),
  KEY `integral` (`integral`) USING BTREE,
  CONSTRAINT `user_vs_rank_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `user_login` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=267 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_vs_rank
-- ----------------------------
INSERT INTO `user_vs_rank` VALUES ('263', '10000008', '玩家10000008', 'Texture/Icon/HeadPhoto/6902', '[6006,6104,6005,6133,6004,6095]', '[100,100,100,100,100,100]', '414438', '993', '2020-06-09 12:38:19');
INSERT INTO `user_vs_rank` VALUES ('266', '10000003', '玩家10000003', 'Texture/Icon/HeadPhoto/6901', '[6115,6017,6095,6140,6131,6004]', '[100,100,100,100,100,100]', '480305', '1082', '2020-06-27 09:17:53');