/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80012
 Source Host           : localhost:3306
 Source Schema         : wapgame

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

 Date: 17/05/2023 22:24:01
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for base_bag
-- ----------------------------
DROP TABLE IF EXISTS `base_bag`;
CREATE TABLE `base_bag`  (
  `id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '背包主键',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  `bag_good_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '背包物品id',
  `bag_good_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '背包物品名称',
  `bag_good_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '背包物品类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '背包表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of base_bag
-- ----------------------------
INSERT INTO `base_bag` VALUES ('1656578414436401153', 4691, '2', '神之魔瓶', 'prop');
INSERT INTO `base_bag` VALUES ('1656579002712698881', 4691, '2', '神之魔瓶', 'prop');
INSERT INTO `base_bag` VALUES ('1656584757788528641', 4691, '2', '神之魔瓶', 'prop');
INSERT INTO `base_bag` VALUES ('1656584763652165634', 4691, '2', '神之魔瓶', 'prop');
INSERT INTO `base_bag` VALUES ('1656584766432989186', 4691, '2', '神之魔瓶', 'prop');
INSERT INTO `base_bag` VALUES ('1656584891951718401', 4691, '2', '神之魔瓶', 'prop');
INSERT INTO `base_bag` VALUES ('1656585053000392705', 4691, '1', '神之血瓶', 'prop');
INSERT INTO `base_bag` VALUES ('1656585057475715073', 4691, '1', '神之血瓶', 'prop');
INSERT INTO `base_bag` VALUES ('1656585059551895554', 4691, '1', '神之血瓶', 'prop');
INSERT INTO `base_bag` VALUES ('1656585060327841794', 4691, '1', '神之血瓶', 'prop');
INSERT INTO `base_bag` VALUES ('1656585061112176641', 4691, '1', '神之血瓶', 'prop');
INSERT INTO `base_bag` VALUES ('1656585066204061698', 4691, '1', '神之血瓶', 'prop');

-- ----------------------------
-- Table structure for base_friend
-- ----------------------------
DROP TABLE IF EXISTS `base_friend`;
CREATE TABLE `base_friend`  (
  `id` bigint(20) NOT NULL,
  `user_id` bigint(20) NULL DEFAULT NULL COMMENT '玩家id',
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '玩家昵称',
  `belong_id` bigint(20) NULL DEFAULT NULL COMMENT '玩家好友归属id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of base_friend
-- ----------------------------
INSERT INTO `base_friend` VALUES (1582390801672196098, 4691, '咸鱼测试', 4433);
INSERT INTO `base_friend` VALUES (1582390801672196099, 4433, 'Java胡', 4691);

-- ----------------------------
-- Table structure for base_good
-- ----------------------------
DROP TABLE IF EXISTS `base_good`;
CREATE TABLE `base_good`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '物品主键',
  `good_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物品名称',
  `good_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物品类型',
  `good_way` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '物品功能',
  `good_remark` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL COMMENT '物品描述',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '物品表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of base_good
-- ----------------------------
INSERT INTO `base_good` VALUES (1, '神之血瓶', 'prop', 'hp', '储存10万的生命，可以随时使用，每次补满自己的生命，耗尽消失。');
INSERT INTO `base_good` VALUES (2, '神之魔瓶', 'prop', 'mp', '储存10万的魔力，可以随时使用，每次补满自己的魔力，耗尽消失。');

-- ----------------------------
-- Table structure for base_letter
-- ----------------------------
DROP TABLE IF EXISTS `base_letter`;
CREATE TABLE `base_letter`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '私信内容',
  `send_id` bigint(20) NULL DEFAULT NULL COMMENT '发信玩家id',
  `send_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '发信玩家昵称',
  `get_id` bigint(20) NULL DEFAULT NULL COMMENT '收信玩家Id',
  `is_read` int(11) NULL DEFAULT 0 COMMENT '是否查看 0未查看 1查看',
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of base_letter
-- ----------------------------
INSERT INTO `base_letter` VALUES (1653042603387465729, '测试', 4691, '咸鱼测试', 4433, 1, '2023-05-01 22:24:03', '2023-05-01 23:32:42');
INSERT INTO `base_letter` VALUES (1653044329150652417, '1', 4691, '咸鱼测试', 4433, 1, '2023-05-01 22:30:55', '2023-05-01 23:32:42');
INSERT INTO `base_letter` VALUES (1653045669906001922, '0', 4691, '咸鱼测试', 4433, 1, '2023-05-01 22:36:14', '2023-05-01 23:32:42');
INSERT INTO `base_letter` VALUES (1653054976043180034, '1', 4691, '咸鱼测试', 4433, 1, '2023-05-01 23:13:13', '2023-05-01 23:32:42');
INSERT INTO `base_letter` VALUES (1653055669546180610, '00000', 4691, '咸鱼测试', 4433, 1, '2023-05-01 23:15:59', '2023-05-01 23:32:42');
INSERT INTO `base_letter` VALUES (1653055863264280577, '1212', 4691, '咸鱼测试', 4433, 1, '2023-05-01 23:16:45', '2023-05-01 23:32:42');
INSERT INTO `base_letter` VALUES (1653056408460926977, '3423', 4691, '咸鱼测试', 4433, 1, '2023-05-01 23:18:55', '2023-05-01 23:32:42');
INSERT INTO `base_letter` VALUES (1653056729744539650, '天天如题如题如题', 4691, '咸鱼测试', 4433, 1, '2023-05-01 23:20:11', '2023-05-01 23:32:42');
INSERT INTO `base_letter` VALUES (1653057681130209281, '121212', 4691, '咸鱼测试', 4433, 1, '2023-05-01 23:23:58', '2023-05-01 23:32:42');
INSERT INTO `base_letter` VALUES (1653058681228419074, '1', 4691, '咸鱼测试', 4433, 1, '2023-05-01 23:27:57', '2023-05-01 23:32:42');
INSERT INTO `base_letter` VALUES (1653059824746680322, '1', 4433, 'Java胡', 4691, 1, '2023-05-01 23:32:29', '2023-05-17 22:14:26');
INSERT INTO `base_letter` VALUES (1653059907538046978, '1', 4433, 'Java胡', 4691, 1, '2023-05-01 23:32:49', '2023-05-17 22:14:26');

-- ----------------------------
-- Table structure for base_mall
-- ----------------------------
DROP TABLE IF EXISTS `base_mall`;
CREATE TABLE `base_mall`  (
  `id` int(255) NOT NULL AUTO_INCREMENT COMMENT '商城主键',
  `mall_good_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  `mall_good_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品名称',
  `mall_price` int(11) NULL DEFAULT NULL COMMENT '商品价格',
  `mall_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '商品类型',
  `create_time` datetime(0) NULL DEFAULT NULL,
  `update_time` datetime(0) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '商城表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of base_mall
-- ----------------------------
INSERT INTO `base_mall` VALUES (1, 1, '神之血瓶', 100, 'prop', '2023-05-10 18:11:45', NULL);
INSERT INTO `base_mall` VALUES (2, 2, '神之魔瓶', 99, 'prop', '2023-05-10 18:11:45', NULL);

-- ----------------------------
-- Table structure for base_map
-- ----------------------------
DROP TABLE IF EXISTS `base_map`;
CREATE TABLE `base_map`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名字',
  `west` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '出口-西',
  `east` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '出口-东',
  `north` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '出口-北',
  `south` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '出口-南',
  `up` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '出口-上',
  `down` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '出口-下',
  `textmark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '描述',
  `des` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '描述2',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图标',
  `map` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '1是地图0是野外',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `name`(`name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 140 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '魔界地图配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of base_map
-- ----------------------------
INSERT INTO `base_map` VALUES (100, '月弦之地', 0, 0, 0, 101, 0, 0, '百花盛开的村子', '月光之下，虚无缥缈，几个腐烂的靶子东倒西歪。', '', '1');
INSERT INTO `base_map` VALUES (101, '练武场', 0, 0, 100, 102, 0, 0, '', '', '', '1');
INSERT INTO `base_map` VALUES (102, '塞纳河畔', 0, 0, 101, 103, 0, 0, '', '', '', '1');
INSERT INTO `base_map` VALUES (103, '中央广场', 104, 109, 102, 108, 0, 0, '', '', '', '1');
INSERT INTO `base_map` VALUES (104, '教堂', 116, 103, 0, 0, 0, 0, '', '', '', '1');
INSERT INTO `base_map` VALUES (105, '杂货铺', 0, 108, 0, 0, 0, 0, '', '', '', '1');
INSERT INTO `base_map` VALUES (106, '马戏团', 0, 107, 0, 0, 0, 0, '', '', '', '1');
INSERT INTO `base_map` VALUES (107, '壁炉旅店', 106, 111, 108, 0, 0, 0, '', '', '', '1');
INSERT INTO `base_map` VALUES (108, '集市', 105, 110, 103, 107, 0, 0, '', '', '', '1');
INSERT INTO `base_map` VALUES (109, '图书馆', 103, 0, 0, 0, 0, 0, '', '', '', '1');
INSERT INTO `base_map` VALUES (110, '铁匠铺', 108, 114, 0, 0, 0, 0, '', '', '', '1');
INSERT INTO `base_map` VALUES (111, '角斗场一', 107, 0, 0, 112, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (112, '角斗场二', 0, 113, 111, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (113, '角斗场三', 112, 0, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (114, '东城门', 110, 150, 0, 115, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (115, '喧哗小区', 0, 0, 114, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (116, '荒野', 117, 104, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (117, '洞口', 0, 116, 0, 118, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (118, '山洞1', 0, 0, 117, 119, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (119, '山洞2', 0, 0, 118, 120, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (120, '山洞3', 0, 0, 119, 121, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (121, '山洞4', 130, 132, 120, 122, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (122, '山洞5', 137, 138, 121, 123, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (123, '山洞6', 0, 0, 122, 124, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (124, '山洞7', 125, 0, 123, 139, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (125, '山洞8', 126, 124, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (126, '山洞9', 127, 125, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (127, '山洞10', 128, 126, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (128, '山洞11', 129, 127, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (129, '山洞12', 0, 128, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (130, '密室1', 131, 121, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (131, '密室2', 0, 130, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (132, '密室3', 121, 133, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (133, '密室4', 132, 134, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (134, '密室5', 133, 135, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (135, '密室6', 134, 136, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (136, '密室7', 135, 137, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (137, '密室8', 122, 138, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (138, '密室9', 137, 0, 0, 0, 0, 0, '', '', '', NULL);
INSERT INTO `base_map` VALUES (139, '地洞1', 0, 0, 124, 0, 0, 0, '', '', '', NULL);

-- ----------------------------
-- Table structure for base_mon
-- ----------------------------
DROP TABLE IF EXISTS `base_mon`;
CREATE TABLE `base_mon`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名字',
  `nick_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '称号',
  `level` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等级',
  `hp` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '生命值',
  `min_attack` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最小攻击',
  `max_attack` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大攻击',
  `min_defence` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最小物防',
  `max_defence` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大物防',
  `room_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '所属地图',
  `icon` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '图标',
  `des` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '描述',
  `talk` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '对话',
  `drop_exp` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '掉落经验',
  `drop_money` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '掉落金钱',
  `refresh_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '刷新时长(秒)',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `map_id`(`room_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '魔界NPC配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of base_mon
-- ----------------------------
INSERT INTO `base_mon` VALUES (1, '吸血蝙蝠', '黑暗精灵', 2, 260, 26, 30, 18, 40, 101, '238.png', '拥有尖锐的毒牙，如幽灵般附在目标身上吸血攻击，当目标察觉时却早已无法行动了。', '咝...咝...', 20, 20, 0);
INSERT INTO `base_mon` VALUES (2, '僵尸', '黑暗精灵', 5, 520, 35, 55, 30, 46, 101, '2.png', '全身布满腐烂的肌肉，不停的流着脓血，睁大白色的眼球饥渴的盯着你。', '我好饿啊……', 50, 50, 0);
INSERT INTO `base_mon` VALUES (3, '骷髅', '黑暗精灵', 8, 800, 50, 80, 50, 100, 101, '3.png', '全身只剩下皑皑白骨，每走一步都吱吱作响。', '吱吱!我活着的时候是个战士……', 80, 80, 0);
INSERT INTO `base_mon` VALUES (4, '吸血鬼', '黑暗精灵', 10, 1200, 100, 120, 34, 100, 101, '4.png', '依靠鲜血来生活的远古邪恶生物。', '鲜血啊……', 100, 100, 0);

-- ----------------------------
-- Table structure for base_npc
-- ----------------------------
DROP TABLE IF EXISTS `base_npc`;
CREATE TABLE `base_npc`  (
  `npc_id` int(11) NOT NULL AUTO_INCREMENT,
  `npc_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'NPC名字',
  `npc_desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT 'NPC描述',
  `room` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '房间ID',
  PRIMARY KEY (`npc_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of base_npc
-- ----------------------------
INSERT INTO `base_npc` VALUES (1, '村长', '测试发言', '100');

-- ----------------------------
-- Table structure for base_talk
-- ----------------------------
DROP TABLE IF EXISTS `base_talk`;
CREATE TABLE `base_talk`  (
  `id` bigint(20) NOT NULL COMMENT '主键',
  `talk_id` int(11) NOT NULL COMMENT '聊天玩家id',
  `talk_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '聊天玩家名字',
  `talk_content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '聊天内容',
  `talk_time` datetime(0) NULL DEFAULT NULL COMMENT '聊天时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of base_talk
-- ----------------------------
INSERT INTO `base_talk` VALUES (1580949035916009474, 4691, '咸鱼测试', '1212', '2022-10-14 23:49:57');
INSERT INTO `base_talk` VALUES (1582744785025040386, 4691, '咸鱼测试', '1', '2022-10-19 22:45:37');
INSERT INTO `base_talk` VALUES (1653057963083907073, 4691, '咸鱼测试', '12', '2023-05-01 23:25:05');

-- ----------------------------
-- Table structure for role
-- ----------------------------
DROP TABLE IF EXISTS `role`;
CREATE TABLE `role`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '社区用户ID',
  `role_name` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '名称',
  `nick_name` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '自定义称号',
  `head_img` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',
  `level` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '等级',
  `money` int(11) NULL DEFAULT 0 COMMENT '金额',
  `exp` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '当前经验',
  `hp` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '当前气血',
  `max_hp` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大气血',
  `mp` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '当前魔力',
  `max_mp` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大魔力',
  `min_attack` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最小攻击',
  `max_attack` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大攻击',
  `min_defence` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最下防御',
  `max_defence` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '最大防御',
  `room_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '所在房间ID',
  `speed` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '攻速',
  `is_dead` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否已死亡',
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '性别',
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `role_name`(`role_name`) USING BTREE,
  INDEX `user_id`(`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '玩家角色表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of role
-- ----------------------------
INSERT INTO `role` VALUES (1, 1000, '重温旧梦', '龙骑士', '', 1, 0, 0, 10000, 10000, 460, 640, 20, 60, 32, 64, 100, 300, 0, NULL);
INSERT INTO `role` VALUES (3, 4691, '咸鱼测试', '', '', 1, 4, 0, 10000, 10000, 460, 640, 20, 60, 32, 64, 100, 300, 0, 'man');
INSERT INTO `role` VALUES (4, 4433, 'Java胡', '', '', 1, 0, 0, 10000, 10000, 460, 640, 20, 60, 32, 64, 100, 300, 0, NULL);

-- ----------------------------
-- Table structure for sys_dict_type
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_type`;
CREATE TABLE `sys_dict_type`  (
  `dict_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '字典类型',
  `status` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '0' COMMENT '状态（0正常 1停用）',
  `create_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '创建者',
  `create_time` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT '' COMMENT '更新者',
  `update_time` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dict_id`) USING BTREE,
  UNIQUE INDEX `dict_type`(`dict_type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_dict_type
-- ----------------------------
INSERT INTO `sys_dict_type` VALUES (1, '道具', 'prop', '0', 'gm', '2023-05-10 15:13:16', 'gm', '2023-05-10 15:13:16', NULL);
INSERT INTO `sys_dict_type` VALUES (2, '武器', 'weapon', '0', 'gm', '2023-05-10 15:13:16', 'gm', '2023-05-10 15:13:16', NULL);
INSERT INTO `sys_dict_type` VALUES (3, '防具', 'armor', '0', 'gm', '2023-05-10 15:13:16', 'gm', '2023-05-10 15:13:16', NULL);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '编号',
  `user_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'ID',
  `union_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '唯一标识',
  `login_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '登陆名',
  `nick_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '昵称',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '登陆密码',
  `money` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '财富',
  `level` tinyint(1) NOT NULL DEFAULT 0 COMMENT '社区等级',
  `vip` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '会员等级',
  `vip_exp` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'VIP经验',
  `register_time` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '注册时间',
  `head_img` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '头像',
  `sex` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '性别, 取值: 0女/1男/2保密',
  `state` int(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '状态: 0冻结 1正常 2封印 3无效',
  `active_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '活跃度',
  `phone` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '' COMMENT '手机号码',
  `exp` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '社区经验',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '社区用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 1000, '5ced7e6c-b9d3-49f5-a7b5-d23d4ea70fed', '张三', '张三', 'e10adc3949ba59abbe56e057f20f883e', 88888, 86, 0, 0, 1532257883, 'header_1.png', 0, 1, 0, '13000000000', 0);
INSERT INTO `user` VALUES (11, 4691, 'a6342048-a73b-45af-9a69-ab3bc56da637', '523396414@qq.com', 'game_4691', 'e10adc3949ba59abbe56e057f20f883e', 0, 0, 0, 0, 1640698203, 'header_1.png', 0, 1, 0, '11111111111', 0);
INSERT INTO `user` VALUES (12, 4433, '61a78417-dc4a-4dd3-82c7-4c472e970813', '1018537760@qq.com', 'game_4433', 'e10adc3949ba59abbe56e057f20f883e', 0, 0, 0, 0, 1665762669, 'header_1.png', 0, 1, 0, '11111111111', 0);
INSERT INTO `user` VALUES (13, 2218, '528de75a-8e0a-4fec-b60b-df048140c35f', '811428248@qq.com', 'game_2218', '202cb962ac59075b964b07152d234b70', 0, 0, 0, 0, 1683535034, 'header_1.png', 0, 1, 0, '11111111111', 0);

SET FOREIGN_KEY_CHECKS = 1;