game_server.sql

/*
 Navicat MySQL Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : localhost:3306
 Source Schema         : game_server

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

 Date: 15/01/2024 12:51:38
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for hero
-- ----------------------------
DROP TABLE IF EXISTS `hero`;
CREATE TABLE `hero`  (
  `id` bigint NOT NULL DEFAULT 0 COMMENT '主键ID',
  `is_delete` int NULL DEFAULT 0 COMMENT '逻辑删除(默认为0，删除为1)',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注（备用字段）',
  `user_id` bigint NULL DEFAULT NULL COMMENT '用户id',
  `hero_num` int NULL DEFAULT NULL COMMENT '英雄编号',
  `hero_grade` int NULL DEFAULT 1 COMMENT '等级',
  `hero_fight` int NULL DEFAULT 0 COMMENT '战力',
  `hero_exp` int NULL DEFAULT 0 COMMENT '经验',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hero
-- ----------------------------
INSERT INTO `hero` VALUES (1723907257525215230, 0, '2023-11-13 11:34:53', '2024-01-10 11:54:36', NULL, NULL, 1723907257525215232, 0, 56, 3560, 350);
INSERT INTO `hero` VALUES (1723907257525215231, 0, '2023-11-13 11:34:53', '2023-11-29 19:26:29', NULL, NULL, 1723907257525215232, 12, 100, 5000, 0);
INSERT INTO `hero` VALUES (1730481954240995328, 0, '2023-12-01 15:00:23', '2023-12-20 23:11:03', NULL, NULL, 1723907257525215232, 6, 30, 600, 350);
INSERT INTO `hero` VALUES (1730481985371119616, 0, '2023-12-01 15:00:30', '2024-01-08 18:56:06', NULL, NULL, 1723907257525215232, 5, 3, 330, 190);
INSERT INTO `hero` VALUES (1730482017549819904, 0, '2023-12-01 15:00:38', '2023-12-01 15:00:38', NULL, NULL, 1723907257525215232, 7, 1, 20, 0);
INSERT INTO `hero` VALUES (1730482048692527104, 0, '2023-12-01 15:00:45', '2024-01-09 08:38:55', NULL, NULL, 1723907257525215232, 1, 5, 1550, 100);
INSERT INTO `hero` VALUES (1730482184143380480, 0, '2023-12-01 15:01:18', '2024-01-06 16:27:04', NULL, NULL, 1723907257525215232, 9, 9, 3690, 230);
INSERT INTO `hero` VALUES (1730482214988292096, 0, '2023-12-01 15:01:25', '2024-01-08 18:57:16', NULL, NULL, 1723907257525215232, 10, 10, 3200, 50);
INSERT INTO `hero` VALUES (1732680864481026048, 0, '2023-12-07 16:38:04', '2023-12-07 16:38:04', NULL, NULL, 1723907257525215232, 11, 1, 40, 0);
INSERT INTO `hero` VALUES (1737491256755494912, 0, '2023-12-20 23:12:51', '2024-01-09 08:38:57', NULL, NULL, 1723907257525215232, 2, 3, 630, 90);
INSERT INTO `hero` VALUES (1742815275243413504, 0, '2024-01-04 15:48:36', '2024-01-04 15:48:36', NULL, NULL, 1723907257525215233, 10, 1, 40, 0);
INSERT INTO `hero` VALUES (1742815310941134848, 0, '2024-01-04 15:48:44', '2024-01-05 21:29:08', NULL, NULL, 1723907257525215233, 12, 1, 20, 0);
INSERT INTO `hero` VALUES (1742815388615450624, 0, '2024-01-04 15:49:03', '2024-01-04 15:49:03', NULL, NULL, 1723907257525215233, 3, 1, 10, 0);
INSERT INTO `hero` VALUES (1742815422236991488, 0, '2024-01-04 15:49:11', '2024-01-04 15:49:11', NULL, NULL, 1723907257525215233, 8, 1, 20, 0);
INSERT INTO `hero` VALUES (1742815462976266240, 0, '2024-01-04 15:49:20', '2024-01-04 15:49:20', NULL, NULL, 1723907257525215233, 6, 1, 20, 0);
INSERT INTO `hero` VALUES (1743210111578546176, 0, '2024-01-05 17:57:32', '2024-01-05 17:57:32', NULL, NULL, 1723907257525215232, 27, 1, 30, 0);
INSERT INTO `hero` VALUES (1743210576370343936, 0, '2024-01-05 17:59:23', '2024-01-05 17:59:23', NULL, NULL, 1723907257525215232, 24, 1, 30, 0);
INSERT INTO `hero` VALUES (1743210609211744256, 0, '2024-01-05 17:59:31', '2024-01-05 17:59:31', NULL, NULL, 1723907257525215232, 22, 1, 30, 0);
INSERT INTO `hero` VALUES (1743210642275442688, 0, '2024-01-05 17:59:39', '2024-01-05 17:59:39', NULL, NULL, 1723907257525215232, 29, 1, 30, 0);
INSERT INTO `hero` VALUES (1743210678208045056, 0, '2024-01-05 17:59:47', '2024-01-05 17:59:47', NULL, NULL, 1723907257525215232, 23, 1, 30, 0);
INSERT INTO `hero` VALUES (1743210711124942848, 0, '2024-01-05 17:59:55', '2024-01-05 17:59:55', NULL, NULL, 1723907257525215232, 31, 1, 40, 0);
INSERT INTO `hero` VALUES (1743210743865679872, 0, '2024-01-05 18:00:03', '2024-01-05 18:00:03', NULL, NULL, 1723907257525215232, 33, 1, 40, 0);
INSERT INTO `hero` VALUES (1743210776384118784, 0, '2024-01-05 18:00:11', '2024-01-05 18:00:11', NULL, NULL, 1723907257525215232, 26, 1, 30, 0);
INSERT INTO `hero` VALUES (1743210808525070336, 0, '2024-01-05 18:00:18', '2024-01-05 18:00:18', NULL, NULL, 1723907257525215232, 32, 1, 40, 0);
INSERT INTO `hero` VALUES (1743210845871153152, 0, '2024-01-05 18:00:27', '2024-01-05 18:00:27', NULL, NULL, 1723907257525215232, 34, 1, 40, 0);
INSERT INTO `hero` VALUES (1743210877085163520, 0, '2024-01-05 18:00:35', '2024-01-05 18:00:35', NULL, NULL, 1723907257525215232, 38, 1, 40, 0);
INSERT INTO `hero` VALUES (1743210907221237760, 0, '2024-01-05 18:00:42', '2024-01-05 18:00:42', NULL, NULL, 1723907257525215232, 37, 1, 40, 0);
INSERT INTO `hero` VALUES (1743210941471924224, 0, '2024-01-05 18:00:50', '2024-01-05 18:00:50', NULL, NULL, 1723907257525215232, 35, 1, 40, 0);
INSERT INTO `hero` VALUES (1743210978541182976, 0, '2024-01-05 18:00:59', '2024-01-05 18:00:59', NULL, NULL, 1723907257525215232, 21, 1, 30, 0);
INSERT INTO `hero` VALUES (1743211045998174208, 0, '2024-01-05 18:01:15', '2024-01-05 18:01:15', NULL, NULL, 1723907257525215232, 30, 1, 40, 0);
INSERT INTO `hero` VALUES (1743212154930208768, 0, '2024-01-05 18:05:39', '2024-01-05 18:05:39', NULL, NULL, 1723907257525215232, 25, 1, 30, 0);
INSERT INTO `hero` VALUES (1743212541347241984, 0, '2024-01-05 18:07:11', '2024-01-05 18:07:11', NULL, NULL, 1723907257525215232, 42, 1, 50, 0);
INSERT INTO `hero` VALUES (1743213181230260224, 0, '2024-01-05 18:09:44', '2024-01-05 18:09:44', NULL, NULL, 1723907257525215232, 18, 1, 20, 0);
INSERT INTO `hero` VALUES (1743262928687210496, 0, '2024-01-05 21:27:25', '2024-01-05 21:27:25', NULL, NULL, 1723907257525215233, 20, 1, 30, 0);
INSERT INTO `hero` VALUES (1743262940326404096, 0, '2024-01-05 21:27:27', '2024-01-05 21:27:27', NULL, NULL, 1723907257525215232, 19, 1, 20, 0);
INSERT INTO `hero` VALUES (1743262980591722496, 0, '2024-01-05 21:27:37', '2024-01-05 21:27:37', NULL, NULL, 1723907257525215233, 17, 1, 20, 0);
INSERT INTO `hero` VALUES (1743263025789542400, 0, '2024-01-05 21:27:48', '2024-01-05 21:27:48', NULL, NULL, 1723907257525215233, 24, 1, 30, 0);
INSERT INTO `hero` VALUES (1743263028377427968, 0, '2024-01-05 21:27:48', '2024-01-05 21:27:48', NULL, NULL, 1723907257525215232, 39, 1, 40, 0);
INSERT INTO `hero` VALUES (1743263128700985344, 0, '2024-01-05 21:28:12', '2024-01-05 21:29:14', NULL, NULL, 1723907257525215233, 32, 1, 1840, 0);
INSERT INTO `hero` VALUES (1743549787078270976, 0, '2024-01-06 16:27:17', '2024-01-06 16:27:17', NULL, NULL, 1723907257525215232, 13, 1, 20, 0);
INSERT INTO `hero` VALUES (1744323917763452928, 0, '2024-01-08 19:43:24', '2024-01-08 19:43:24', NULL, NULL, 1744323917750870016, 0, 1, 10, 0);
INSERT INTO `hero` VALUES (1744323917763452929, 0, '2024-01-08 19:43:24', '2024-01-08 19:43:24', NULL, NULL, 1744323917750870016, 1, 1, 10, 0);
INSERT INTO `hero` VALUES (1744323917763452930, 0, '2024-01-08 19:43:24', '2024-01-08 19:43:24', NULL, NULL, 1744323917750870016, 2, 1, 10, 0);
INSERT INTO `hero` VALUES (1744329991455383552, 0, '2024-01-08 20:07:32', '2024-01-08 20:13:48', NULL, NULL, 1744329991446994944, 0, 6, 960, 450);
INSERT INTO `hero` VALUES (1744329991455383553, 0, '2024-01-08 20:07:32', '2024-01-08 20:07:32', NULL, NULL, 1744329991446994944, 1, 1, 10, 0);
INSERT INTO `hero` VALUES (1744329991455383554, 0, '2024-01-08 20:07:32', '2024-01-08 20:07:32', NULL, NULL, 1744329991446994944, 2, 1, 10, 0);
INSERT INTO `hero` VALUES (1744522636421111808, 0, '2024-01-09 08:53:02', '2024-01-09 08:54:38', NULL, NULL, 1744522636412723200, 0, 1, 310, 0);
INSERT INTO `hero` VALUES (1744522636421111809, 0, '2024-01-09 08:53:02', '2024-01-09 08:53:02', NULL, NULL, 1744522636412723200, 1, 1, 10, 0);
INSERT INTO `hero` VALUES (1744522636421111810, 0, '2024-01-09 08:53:02', '2024-01-09 08:53:02', NULL, NULL, 1744522636412723200, 2, 1, 10, 0);
INSERT INTO `hero` VALUES (1744893966349901824, 0, '2024-01-10 09:28:34', '2024-01-10 09:28:34', NULL, NULL, 1723907257525215232, 17, 1, 20, 0);
INSERT INTO `hero` VALUES (1744905656210694144, 0, '2024-01-10 10:15:01', '2024-01-10 10:18:42', NULL, NULL, 1744905656193916928, 0, 1, 10, 50);
INSERT INTO `hero` VALUES (1744905656210694145, 0, '2024-01-10 10:15:01', '2024-01-10 10:15:01', NULL, NULL, 1744905656193916928, 1, 1, 10, 0);
INSERT INTO `hero` VALUES (1744905656210694146, 0, '2024-01-10 10:15:01', '2024-01-10 10:15:01', NULL, NULL, 1744905656193916928, 2, 1, 10, 0);
INSERT INTO `hero` VALUES (1744906606056972288, 0, '2024-01-10 10:18:48', '2024-01-10 10:18:48', NULL, NULL, 1744905656193916928, 17, 1, 20, 0);
INSERT INTO `hero` VALUES (1744906847246229504, 0, '2024-01-10 10:19:45', '2024-01-10 10:23:47', NULL, NULL, 1744906847237840896, 0, 1, 10, 50);
INSERT INTO `hero` VALUES (1744906847246229505, 0, '2024-01-10 10:19:45', '2024-01-10 10:19:45', NULL, NULL, 1744906847237840896, 1, 1, 10, 0);
INSERT INTO `hero` VALUES (1744906847246229506, 0, '2024-01-10 10:19:45', '2024-01-10 10:19:45', NULL, NULL, 1744906847237840896, 2, 1, 10, 0);
INSERT INTO `hero` VALUES (1744907884346613760, 0, '2024-01-10 10:23:53', '2024-01-10 10:23:53', NULL, NULL, 1744906847237840896, 18, 1, 20, 0);
INSERT INTO `hero` VALUES (1744918097044840448, 0, '2024-01-10 11:04:28', '2024-01-10 11:07:11', NULL, NULL, 1744918097032257536, 0, 1, 10, 50);
INSERT INTO `hero` VALUES (1744918097044840449, 0, '2024-01-10 11:04:28', '2024-01-10 11:04:28', NULL, NULL, 1744918097032257536, 1, 1, 10, 0);
INSERT INTO `hero` VALUES (1744918097044840450, 0, '2024-01-10 11:04:28', '2024-01-10 11:10:50', NULL, NULL, 1744918097032257536, 2, 1, 1210, 0);
INSERT INTO `hero` VALUES (1744918808956641280, 0, '2024-01-10 11:07:17', '2024-01-10 11:07:17', NULL, NULL, 1744918097032257536, 25, 1, 30, 0);

-- ----------------------------
-- Table structure for hero_rune
-- ----------------------------
DROP TABLE IF EXISTS `hero_rune`;
CREATE TABLE `hero_rune`  (
  `id` bigint NOT NULL DEFAULT 0 COMMENT '主键ID',
  `hero_id` bigint NULL DEFAULT 0 COMMENT '装备的英雄',
  `user_rune_id` bigint NULL DEFAULT 0 COMMENT '用户符文信息',
  `rune_pos` int NULL DEFAULT 0 COMMENT '装备位置',
  `rune_num` int NULL DEFAULT 0 COMMENT '符文编号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hero_rune
-- ----------------------------
INSERT INTO `hero_rune` VALUES (1730482321418756096, 1730482214988292096, 1730213013287477248, 0, 7);
INSERT INTO `hero_rune` VALUES (1730482326309314560, 1730482214988292096, 1730475357339000832, 1, 0);
INSERT INTO `hero_rune` VALUES (1730482337025761280, 1730482214988292096, 1730475362896453632, 2, 4);
INSERT INTO `hero_rune` VALUES (1731636582907256832, 1730481985371119616, 1730475370047741952, 3, 12);
INSERT INTO `hero_rune` VALUES (1732681314710200320, 1730482048692527104, 1732255706402398208, 2, 14);
INSERT INTO `hero_rune` VALUES (1743263379822354432, 1743263128700985344, 1742792062178304000, 0, 0);
INSERT INTO `hero_rune` VALUES (1743263384515780608, 1743263128700985344, 1743263192563458048, 1, 9);
INSERT INTO `hero_rune` VALUES (1743263389163069440, 1743263128700985344, 1743263197592428544, 3, 10);
INSERT INTO `hero_rune` VALUES (1743549719193460736, 1730482184143380480, 1732725552672022528, 0, 10);
INSERT INTO `hero_rune` VALUES (1743549723253547008, 1730482184143380480, 1737092006867509248, 1, 14);
INSERT INTO `hero_rune` VALUES (1743549728286711808, 1730482184143380480, 1737353464998141952, 3, 7);
INSERT INTO `hero_rune` VALUES (1743549733185658880, 1730482184143380480, 1737446034101116928, 2, 17);
INSERT INTO `hero_rune` VALUES (1744312309444124672, 1730482214988292096, 1732679530117734400, 3, 7);
INSERT INTO `hero_rune` VALUES (1744312324199686144, 1737491256755494912, 1732680939328380928, 1, 1);
INSERT INTO `hero_rune` VALUES (1744312334677057536, 1730482048692527104, 1737446622805237761, 1, 9);
INSERT INTO `hero_rune` VALUES (1744331564722036736, 1744329991455383552, 1744331351940800512, 0, 1);
INSERT INTO `hero_rune` VALUES (1744331569474183168, 1744329991455383552, 1744330012934414336, 1, 0);
INSERT INTO `hero_rune` VALUES (1744523037526597632, 1744522636421111808, 1744522776783495168, 0, 0);
INSERT INTO `hero_rune` VALUES (1744525233060192256, 1723907257525215230, 1732679530797211648, 3, 7);
INSERT INTO `hero_rune` VALUES (1744525247635398656, 1723907257525215230, 1732728681534726144, 1, 10);
INSERT INTO `hero_rune` VALUES (1744525257659785216, 1723907257525215230, 1737627481093054464, 0, 9);
INSERT INTO `hero_rune` VALUES (1744525267323461632, 1723907257525215230, 1743553221827371008, 2, 16);
INSERT INTO `hero_rune` VALUES (1744919689764675584, 1744918097044840450, 1744918927105990656, 2, 10);
INSERT INTO `hero_rune` VALUES (1744919699961028608, 1744918097044840450, 1744918896500154368, 0, 0);

-- ----------------------------
-- Table structure for hero_team
-- ----------------------------
DROP TABLE IF EXISTS `hero_team`;
CREATE TABLE `hero_team`  (
  `id` bigint NOT NULL DEFAULT 0 COMMENT '主键ID',
  `hero_id` bigint NULL DEFAULT 0 COMMENT '英雄ID',
  `team_pos` int NULL DEFAULT 0 COMMENT '队伍位置',
  `user_id` bigint NULL DEFAULT 0 COMMENT '用户ID',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hero_team
-- ----------------------------
INSERT INTO `hero_team` VALUES (1743263300495482880, 1742815310941134848, 0, 1723907257525215233);
INSERT INTO `hero_team` VALUES (1743263300495482881, 1743263128700985344, 1, 1723907257525215233);
INSERT INTO `hero_team` VALUES (1743263300495482882, 1743262980591722496, 2, 1723907257525215233);
INSERT INTO `hero_team` VALUES (1743263300495482883, 1743262928687210496, 3, 1723907257525215233);
INSERT INTO `hero_team` VALUES (1743263300495482884, 1742815275243413504, 4, 1723907257525215233);
INSERT INTO `hero_team` VALUES (1744323917771841536, 1744323917763452928, 0, 1744323917750870016);
INSERT INTO `hero_team` VALUES (1744323917771841537, 1744323917763452929, 1, 1744323917750870016);
INSERT INTO `hero_team` VALUES (1744323917771841538, 1744323917763452930, 2, 1744323917750870016);
INSERT INTO `hero_team` VALUES (1744330266425565184, 1744329991455383554, 0, 1744329991446994944);
INSERT INTO `hero_team` VALUES (1744330266425565185, 1744329991455383552, 1, 1744329991446994944);
INSERT INTO `hero_team` VALUES (1744330266425565186, 1744329991455383553, 2, 1744329991446994944);
INSERT INTO `hero_team` VALUES (1744522636429500416, 1744522636421111808, 0, 1744522636412723200);
INSERT INTO `hero_team` VALUES (1744522636429500417, 1744522636421111809, 1, 1744522636412723200);
INSERT INTO `hero_team` VALUES (1744522636429500418, 1744522636421111810, 2, 1744522636412723200);
INSERT INTO `hero_team` VALUES (1744613840580124672, 1723907257525215230, 0, 1723907257525215232);
INSERT INTO `hero_team` VALUES (1744613840580124673, 1723907257525215231, 1, 1723907257525215232);
INSERT INTO `hero_team` VALUES (1744613840580124674, 1730481954240995328, 2, 1723907257525215232);
INSERT INTO `hero_team` VALUES (1744613840580124675, 1730482184143380480, 3, 1723907257525215232);
INSERT INTO `hero_team` VALUES (1744613840580124676, 1730482214988292096, 4, 1723907257525215232);
INSERT INTO `hero_team` VALUES (1744906657365893120, 1744905656210694144, 0, 1744905656193916928);
INSERT INTO `hero_team` VALUES (1744906657365893121, 1744905656210694145, 1, 1744905656193916928);
INSERT INTO `hero_team` VALUES (1744906657365893122, 1744905656210694146, 2, 1744905656193916928);
INSERT INTO `hero_team` VALUES (1744906657365893123, 1744906606056972288, 3, 1744905656193916928);
INSERT INTO `hero_team` VALUES (1744907929359884288, 1744906847246229504, 0, 1744906847237840896);
INSERT INTO `hero_team` VALUES (1744907929359884289, 1744906847246229505, 1, 1744906847237840896);
INSERT INTO `hero_team` VALUES (1744907929359884290, 1744906847246229506, 2, 1744906847237840896);
INSERT INTO `hero_team` VALUES (1744907929359884291, 1744907884346613760, 3, 1744906847237840896);
INSERT INTO `hero_team` VALUES (1744918854531948544, 1744918097044840448, 0, 1744918097032257536);
INSERT INTO `hero_team` VALUES (1744918854531948545, 1744918097044840449, 1, 1744918097032257536);
INSERT INTO `hero_team` VALUES (1744918854531948546, 1744918097044840450, 2, 1744918097032257536);
INSERT INTO `hero_team` VALUES (1744918854531948547, 1744918808956641280, 3, 1744918097032257536);

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `id` bigint NOT NULL COMMENT '主键ID',
  `is_delete` int NULL DEFAULT 0 COMMENT '逻辑删除(默认为0，删除为1)',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注（备用字段）',
  `user_name` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '用户名',
  `pwd` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '密码',
  `glod_coin` int NULL DEFAULT 0 COMMENT '金币',
  `sliver_coin` int NULL DEFAULT 0 COMMENT '银币',
  `fight` int NULL DEFAULT 0 COMMENT '战力',
  `grade` int NULL DEFAULT 1 COMMENT '等级',
  `phy` int NULL DEFAULT 0 COMMENT '体力',
  `exp` int NULL DEFAULT 0 COMMENT '经验',
  `icon` int NULL DEFAULT 0 COMMENT '头像编号',
  `last_sign_day` int NULL DEFAULT 0 COMMENT '最后签到的时间，距离月初',
  `sign_count` int NULL DEFAULT 0 COMMENT '登录领奖次数',
  `last_lottery_day` int NULL DEFAULT 0 COMMENT '最后抽奖时间，距离特定时间',
  `shop_data` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '商城数据',
  `level` int NULL DEFAULT 1 COMMENT '关卡',
  `is_first_day_login` int NULL DEFAULT 1 COMMENT '今天第一次登录',
  `is_first_month_login` int NULL DEFAULT 1 COMMENT '本月第一次登录',
  `task_data` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '任务数据',
  `guide` int NULL DEFAULT 0 COMMENT '指引',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1723907257525215232, 0, '2023-11-13 11:34:53', '2024-01-10 11:54:59', NULL, NULL, 'zhl', '7eea48bdaf06fedd9683a769ec362e48', 999984130, 23455, 16250, 8, 64, 151, 0, 10, 3, 40, '000000000000', 2, 0, 0, '111101101001001001001', 18);
INSERT INTO `user` VALUES (1723907257525215233, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'zhl1', '7eea48bdaf06fedd9683a769ec362e48', 999998430, 6590, 13, 2, 100, 70, 1, 5, 2, 0, '000000000000', 1, 1, 0, '0', 0);
INSERT INTO `user` VALUES (1723907257525215234, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'zhl222', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 187, 18, 100, 70, 2, 0, 0, 0, '000000000000', 1, 1, 0, '0', 0);
INSERT INTO `user` VALUES (1723907257525215235, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'zhl223', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 184, 10, 50, 70, 3, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215236, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'zhl27', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 1845, 43, 50, 70, 4, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215237, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'zhl31', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 187, 18, 50, 70, 5, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215238, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'zhl32', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 184, 10, 50, 70, 6, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215239, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'zhl33', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 1845, 23, 50, 70, 7, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215240, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'zhl41', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 1845, 12, 50, 70, 8, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215241, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'zhl42', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 187, 18, 50, 70, 9, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215242, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'das', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 184, 10, 50, 70, 10, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215243, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'eqweq', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 1845, 15, 50, 70, 11, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215244, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, '444', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 9999, 78, 50, 70, 12, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215245, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'weqqew', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 15455, 100, 50, 70, 0, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215246, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'rerer', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 184, 10, 50, 70, 1, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215247, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'dsadas', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 1845, 65, 50, 70, 2, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215248, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'ssss', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 1845, 45, 50, 70, 3, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215249, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'dddd', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 187, 18, 50, 70, 4, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215250, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'yyyy', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 184, 10, 50, 70, 5, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215251, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'testdasd', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 54545, 77, 50, 70, 6, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1723907257525215252, 0, '2023-11-13 11:34:53', '2024-01-10 00:00:00', NULL, NULL, 'tes', '7eea48bdaf06fedd9683a769ec362e48', 999999160, 7640, 1, 55, 50, 70, 7, 0, 0, 0, '000000000000', 1, 1, 1, '0', 0);
INSERT INTO `user` VALUES (1744323917750870016, 0, '2024-01-08 19:43:24', '2024-01-10 00:00:00', NULL, NULL, '123', '202cb962ac59075b964b07152d234b70', 0, 0, 130, 1, 100, 0, 0, 0, 1, 0, '000000000000', 1, 1, 0, '0', 0);
INSERT INTO `user` VALUES (1744329991446994944, 0, '2024-01-08 20:07:32', '2024-01-10 00:00:00', NULL, NULL, '789', '68053af2923e00204c3ca7c6a3150cf7', 0, 100, 1080, 1, 91, 0, 0, 8, 1, 38, '000000000000', 1, 1, 0, '001001000000000000000', 0);
INSERT INTO `user` VALUES (1744522636412723200, 0, '2024-01-09 08:53:02', '2024-01-10 00:00:00', NULL, NULL, 'ttt', '9990775155c3518a0d7917f7780b24aa', 0, 20, 430, 1, 100, 0, 0, 9, 1, 39, '000000000000', 1, 1, 0, '001001000000000000000', 0);
INSERT INTO `user` VALUES (1744905656193916928, 0, '2024-01-10 10:15:01', '2024-01-10 10:19:08', NULL, NULL, 'qwe', '76d80224611fc919a5d54f0ff9fba446', 0, 1070, 250, 1, 91, 150, 0, 10, 1, 40, '000000000000', 2, 0, 0, '0', 18);
INSERT INTO `user` VALUES (1744906847237840896, 0, '2024-01-10 10:19:45', '2024-01-15 12:16:07', NULL, NULL, 'www', '4eae35f1b35977a00ebd8086c259d4c9', 0, 1070, 250, 1, 300, 150, 0, 10, 1, 40, '000000000000', 2, 0, 0, '0', 18);
INSERT INTO `user` VALUES (1744918097032257536, 0, '2024-01-10 11:04:28', '2024-01-10 11:50:04', NULL, NULL, 'aaa', '47bce5c74f589f4867dbd57e9ca9f808', 0, 2170, 1560, 2, 64, 180, 0, 10, 1, 40, '000000000000', 3, 0, 0, '011001000000000000000', 18);

-- ----------------------------
-- Table structure for user_email
-- ----------------------------
DROP TABLE IF EXISTS `user_email`;
CREATE TABLE `user_email`  (
  `id` bigint NOT NULL DEFAULT 0 COMMENT '主键ID',
  `is_delete` int NULL DEFAULT 0 COMMENT '逻辑删除(默认为0，删除为1)',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注（备用字段）',
  `user_id` bigint NULL DEFAULT 0 COMMENT '用户id',
  `item_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '奖励物品',
  `email_title` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件标题',
  `email_content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL COMMENT '邮件内容',
  `is_read` int NULL DEFAULT 0 COMMENT '是否已读',
  `is_get` int NULL DEFAULT 0 COMMENT '是否领取',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_email
-- ----------------------------
INSERT INTO `user_email` VALUES (1727212273692245164, 1, '2023-11-22 19:06:00', '2023-11-29 09:57:11', '2023-11-29 09:57:20', NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试', '测试', 1, 1);
INSERT INTO `user_email` VALUES (1727280553750831100, 1, '2023-11-22 18:59:09', '2023-11-29 09:51:11', '2023-11-24 15:59:12', NULL, 1723907257525215232, '[{\"item_num\":2,\"item_amount\":100},{\"item_num\":3,\"item_amount\":10},{\"item_num\":1,\"item_amount\":10}]', '在线奖励', '在线时长奖励', 1, 0);
INSERT INTO `user_email` VALUES (1727280553750831101, 1, '2023-11-22 18:59:09', '2023-11-29 09:27:29', '2023-11-29 09:27:38', NULL, 1723907257525215232, '[{\"item_num\":2,\"item_amount\":100},{\"item_num\":3,\"item_amount\":10}]', '在线奖励', '在线时长奖励', 0, 0);
INSERT INTO `user_email` VALUES (1727280553750831102, 1, '2023-11-22 18:59:09', '2023-11-29 09:51:06', '2023-11-24 11:33:31', NULL, 1723907257525215232, '[{\"item_num\":2,\"item_amount\":100},{\"item_num\":3,\"item_amount\":10}]', '在线奖励', '在线时长奖励', 1, 0);
INSERT INTO `user_email` VALUES (1727280553750831104, 1, '2023-11-22 18:59:09', '2023-11-29 09:51:05', '2023-11-29 09:57:56', NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试', '测试', 1, 1);
INSERT INTO `user_email` VALUES (1727281088088383488, 1, '2023-11-22 19:01:17', '2023-11-29 09:28:15', '2023-11-24 11:18:38', NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试', '测试', 0, 0);
INSERT INTO `user_email` VALUES (1727288488482400256, 1, '2023-11-22 19:31:53', '2023-11-22 19:31:54', '2023-11-22 19:31:55', NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试', '测试', 0, 0);
INSERT INTO `user_email` VALUES (1727288788482400256, 1, '2023-11-22 19:31:53', '2023-11-22 19:31:54', '2023-11-22 19:31:55', NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试', '测试', 0, 0);
INSERT INTO `user_email` VALUES (1729682868650778624, 1, '2023-11-29 10:05:06', '2023-11-29 10:06:28', '2023-11-29 10:06:47', NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 1, 1);
INSERT INTO `user_email` VALUES (1729683202030837760, 1, '2023-11-29 10:06:25', '2023-11-29 19:01:42', '2023-11-29 19:32:13', NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 1, 1);
INSERT INTO `user_email` VALUES (1729683216899645440, 0, '2023-11-29 10:06:29', '2023-12-20 20:03:00', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 1, 1);
INSERT INTO `user_email` VALUES (1729683239171399680, 1, '2023-11-29 10:06:34', '2023-11-29 19:45:37', '2023-12-07 16:37:42', NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 1, 1);
INSERT INTO `user_email` VALUES (1729683260780453888, 0, '2023-11-29 10:06:39', '2023-12-07 16:37:45', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 1, 1);
INSERT INTO `user_email` VALUES (1729683261602537472, 0, '2023-11-29 10:06:40', '2023-12-01 14:34:26', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 1, 1);
INSERT INTO `user_email` VALUES (1729683262286209024, 1, '2023-11-29 10:06:40', '2023-11-29 19:32:17', '2023-12-01 14:34:23', NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 1, 1);
INSERT INTO `user_email` VALUES (1729693386908246016, 1, '2023-11-29 10:46:54', '2023-11-29 10:46:59', '2023-11-29 19:32:15', NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 1, 1);
INSERT INTO `user_email` VALUES (1737353470303936512, 0, '2023-12-20 14:05:20', '2023-12-20 20:03:05', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 1, 1);
INSERT INTO `user_email` VALUES (1737444103970496512, 0, '2023-12-20 20:05:29', '2023-12-20 20:05:35', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 1, 1);
INSERT INTO `user_email` VALUES (1737626975360655360, 0, '2023-12-21 08:12:09', '2024-01-09 09:04:33', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 1, 1);
INSERT INTO `user_email` VALUES (1739213108469178368, 0, '2023-12-25 17:14:52', '2024-01-09 08:39:31', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 1, 1);
INSERT INTO `user_email` VALUES (1739213976908210176, 0, '2023-12-25 17:18:19', '2023-12-25 17:18:19', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 0, 0);
INSERT INTO `user_email` VALUES (1739213986496389120, 0, '2023-12-25 17:18:22', '2023-12-25 17:18:22', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 0, 0);
INSERT INTO `user_email` VALUES (1739214001121927168, 0, '2023-12-25 17:18:25', '2023-12-25 17:18:25', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 0, 0);
INSERT INTO `user_email` VALUES (1739214012593348608, 0, '2023-12-25 17:18:28', '2023-12-25 17:18:28', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 0, 0);
INSERT INTO `user_email` VALUES (1739214179195297792, 0, '2023-12-25 17:19:08', '2023-12-25 17:19:08', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '测试添加', '内容不重要', 0, 0);
INSERT INTO `user_email` VALUES (1739585929615646720, 0, '2023-12-26 17:56:20', '2023-12-26 17:56:20', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1739605408902946816, 0, '2023-12-26 19:13:44', '2023-12-26 19:13:44', NULL, NULL, 1723907257525215233, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1739627374879842304, 0, '2023-12-26 20:41:01', '2023-12-26 20:41:01', NULL, NULL, 1723907257525215234, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1742740749973331968, 0, '2024-01-04 10:52:28', '2024-01-04 10:53:18', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 1, 0);
INSERT INTO `user_email` VALUES (1742791526045589504, 0, '2024-01-04 14:14:13', '2024-01-04 14:14:13', NULL, NULL, 1723907257525215233, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1743209974508691456, 0, '2024-01-05 17:56:59', '2024-01-05 17:56:59', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1743220343105003520, 0, '2024-01-05 18:38:11', '2024-01-05 18:38:11', NULL, NULL, 1723907257525215233, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1743547481402253312, 0, '2024-01-06 16:18:07', '2024-01-06 16:18:07', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1743547819882586112, 0, '2024-01-06 16:19:28', '2024-01-06 16:23:51', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 1, 1);
INSERT INTO `user_email` VALUES (1743553301535924224, 0, '2024-01-06 16:41:15', '2024-01-06 16:41:15', NULL, NULL, 1723907257525215233, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1743557083418206208, 0, '2024-01-06 16:56:17', '2024-01-06 16:56:17', NULL, NULL, 1723907257525215234, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1744302376044601344, 0, '2024-01-08 18:17:48', '2024-01-08 18:17:48', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1744320969511673856, 0, '2024-01-08 19:31:41', '2024-01-08 19:31:41', NULL, NULL, 1744320956698075136, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1744322257183973376, 0, '2024-01-08 19:36:48', '2024-01-08 19:36:48', NULL, NULL, 1744322229879054336, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1744322810026795008, 0, '2024-01-08 19:39:00', '2024-01-08 19:39:00', NULL, NULL, 1744322800589611008, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1744323925816516608, 0, '2024-01-08 19:43:26', '2024-01-08 19:43:26', NULL, NULL, 1744323917750870016, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1744324557877157888, 1, '2024-01-08 19:45:57', '2024-01-08 19:47:51', '2024-01-08 19:47:54', NULL, 1744324547047464960, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 1, 1);
INSERT INTO `user_email` VALUES (1744329997499375616, 1, '2024-01-08 20:07:34', '2024-01-08 20:13:14', '2024-01-08 20:13:19', NULL, 1744329991446994944, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 1, 1);
INSERT INTO `user_email` VALUES (1744518894397300736, 0, '2024-01-09 08:38:10', '2024-01-09 08:38:10', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1744520609498537984, 0, '2024-01-09 08:44:59', '2024-01-09 08:44:59', NULL, NULL, 1723907257525215233, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1744522657090641920, 1, '2024-01-09 08:53:07', '2024-01-09 08:54:00', '2024-01-09 08:54:02', NULL, 1744522636412723200, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 1, 1);
INSERT INTO `user_email` VALUES (1744878438537371648, 0, '2024-01-10 08:26:52', '2024-01-10 08:26:52', NULL, NULL, 1723907257525215232, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1744905667799556096, 0, '2024-01-10 10:15:04', '2024-01-10 10:15:04', NULL, NULL, 1744905656193916928, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1744906875201265664, 0, '2024-01-10 10:19:52', '2024-01-10 10:19:52', NULL, NULL, 1744906847237840896, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);
INSERT INTO `user_email` VALUES (1744918101482414080, 0, '2024-01-10 11:04:29', '2024-01-10 11:08:05', NULL, NULL, 1744918097032257536, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 1, 1);
INSERT INTO `user_email` VALUES (1746748069258600448, 0, '2024-01-15 12:16:07', '2024-01-15 12:16:07', NULL, NULL, 1744906847237840896, '[{\"item_num\": 1, \"item_amount\": 10}]', '登录奖励', '每日登录奖励', 0, 0);

-- ----------------------------
-- Table structure for user_friend
-- ----------------------------
DROP TABLE IF EXISTS `user_friend`;
CREATE TABLE `user_friend`  (
  `id` bigint NOT NULL DEFAULT 0 COMMENT '主键ID',
  `user_id` bigint NULL DEFAULT 0 COMMENT '用户id',
  `friend_user_id` bigint NULL DEFAULT 0 COMMENT '好友用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_friend
-- ----------------------------
INSERT INTO `user_friend` VALUES (1742791743708995584, 1723907257525215232, 1723907257525215233);
INSERT INTO `user_friend` VALUES (1742791743713189888, 1723907257525215233, 1723907257525215232);

-- ----------------------------
-- Table structure for user_friend_req
-- ----------------------------
DROP TABLE IF EXISTS `user_friend_req`;
CREATE TABLE `user_friend_req`  (
  `id` bigint NOT NULL DEFAULT 0 COMMENT '主键ID',
  `is_delete` int NULL DEFAULT 0 COMMENT '逻辑删除(默认为0，删除为1)',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `delete_time` datetime NULL DEFAULT NULL COMMENT '删除时间',
  `remarks` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注（备用字段）',
  `req_user_id` bigint NULL DEFAULT 0 COMMENT '发送请求用户id',
  `friend_user_id` bigint NULL DEFAULT 0 COMMENT '好友用户id',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_friend_req
-- ----------------------------
INSERT INTO `user_friend_req` VALUES (1739626451629645824, 1, '2023-12-26 20:37:21', '2023-12-26 20:37:21', '2023-12-26 20:37:33', NULL, 1723907257525215233, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1739626510739972096, 1, '2023-12-26 20:37:35', '2023-12-26 20:37:35', '2023-12-26 20:37:40', NULL, 1723907257525215233, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1739626605501882368, 1, '2023-12-26 20:37:58', '2023-12-26 20:37:58', '2023-12-26 20:38:02', NULL, 1723907257525215233, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1739626712368553984, 0, '2023-12-26 20:38:23', '2023-12-26 20:38:23', NULL, NULL, 1723907257525215233, 1723907257525215235);
INSERT INTO `user_friend_req` VALUES (1739627332576092160, 1, '2023-12-26 20:40:51', '2023-12-26 20:40:51', '2024-01-06 16:56:54', NULL, 1723907257525215233, 1723907257525215234);
INSERT INTO `user_friend_req` VALUES (1739627338162905088, 0, '2023-12-26 20:40:52', '2023-12-26 20:40:52', NULL, NULL, 1723907257525215233, 1723907257525215236);
INSERT INTO `user_friend_req` VALUES (1739627343128961024, 0, '2023-12-26 20:40:53', '2023-12-26 20:40:53', NULL, NULL, 1723907257525215233, 1723907257525215237);
INSERT INTO `user_friend_req` VALUES (1739627347411345408, 0, '2023-12-26 20:40:54', '2023-12-26 20:40:54', NULL, NULL, 1723907257525215233, 1723907257525215238);
INSERT INTO `user_friend_req` VALUES (1739627396824440832, 1, '2023-12-26 20:41:06', '2023-12-26 20:41:06', '2023-12-26 20:47:36', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1739627523014270976, 1, '2023-12-26 20:41:36', '2023-12-26 20:41:36', '2023-12-26 20:47:36', NULL, 1723907257525215233, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1742791691498299392, 1, '2024-01-04 14:14:53', '2024-01-04 14:14:53', '2024-01-04 14:15:05', NULL, 1723907257525215232, 1723907257525215233);
INSERT INTO `user_friend_req` VALUES (1743558149241184256, 1, '2024-01-06 17:00:31', '2024-01-06 17:00:31', '2024-01-06 17:00:47', NULL, 1723907257525215232, 1723907257525215234);
INSERT INTO `user_friend_req` VALUES (1743559067428855808, 1, '2024-01-06 17:04:10', '2024-01-06 17:04:10', '2024-01-06 17:04:18', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743559476268638208, 1, '2024-01-06 17:05:47', '2024-01-06 17:05:47', '2024-01-06 17:05:53', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743559555855556608, 1, '2024-01-06 17:06:06', '2024-01-06 17:06:06', '2024-01-06 17:06:13', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743559601816739840, 1, '2024-01-06 17:06:17', '2024-01-06 17:06:17', '2024-01-06 17:06:20', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743559679604301824, 1, '2024-01-06 17:06:36', '2024-01-06 17:06:36', '2024-01-06 17:06:43', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743559718124789760, 1, '2024-01-06 17:06:45', '2024-01-06 17:06:45', '2024-01-06 17:06:47', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743559737552805888, 1, '2024-01-06 17:06:49', '2024-01-06 17:06:49', '2024-01-06 17:06:55', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743560118248808448, 1, '2024-01-06 17:08:20', '2024-01-06 17:08:20', '2024-01-06 17:08:31', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743560170702774272, 1, '2024-01-06 17:08:33', '2024-01-06 17:08:33', '2024-01-06 17:08:35', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743560184896299008, 1, '2024-01-06 17:08:36', '2024-01-06 17:08:36', '2024-01-06 17:08:39', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743560335287263232, 1, '2024-01-06 17:09:12', '2024-01-06 17:09:12', '2024-01-06 17:09:19', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743560715618361344, 1, '2024-01-06 17:10:43', '2024-01-06 17:10:43', '2024-01-06 17:10:57', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743560795373051904, 1, '2024-01-06 17:11:02', '2024-01-06 17:11:02', '2024-01-06 17:12:21', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743561150626406400, 1, '2024-01-06 17:12:26', '2024-01-06 17:12:26', '2024-01-06 17:12:32', NULL, 1723907257525215234, 1723907257525215232);
INSERT INTO `user_friend_req` VALUES (1743561214975418368, 0, '2024-01-06 17:12:42', '2024-01-06 17:12:42', NULL, NULL, 1723907257525215232, 1723907257525215234);
INSERT INTO `user_friend_req` VALUES (1744929839334432768, 0, '2024-01-10 11:51:07', '2024-01-10 11:51:07', NULL, NULL, 1744918097032257536, 1723907257525215232);

-- ----------------------------
-- Table structure for user_item
-- ----------------------------
DROP TABLE IF EXISTS `user_item`;
CREATE TABLE `user_item`  (
  `id` bigint NOT NULL DEFAULT 0 COMMENT '主键ID',
  `user_id` bigint NULL DEFAULT 0 COMMENT '用户id',
  `item_num` int NULL DEFAULT 0 COMMENT '物品编号',
  `item_amount` int NULL DEFAULT 0 COMMENT '物品数量',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_item
-- ----------------------------
INSERT INTO `user_item` VALUES (1729753767781474304, 1723907257525215232, 2, 1);
INSERT INTO `user_item` VALUES (1729753767781474305, 1723907257525215232, 3, 1875);
INSERT INTO `user_item` VALUES (1730212875735277568, 1723907257525215232, 4, 53);
INSERT INTO `user_item` VALUES (1737627377778958336, 1723907257525215232, 1, 6783);
INSERT INTO `user_item` VALUES (1742815343597985792, 1723907257525215233, 4, 20);
INSERT INTO `user_item` VALUES (1743255319431225344, 1723907257525215233, 1, 5);
INSERT INTO `user_item` VALUES (1744324638684618752, 1744324547047464960, 3, 3);
INSERT INTO `user_item` VALUES (1744325036963143680, 1744324547047464960, 1, 10);
INSERT INTO `user_item` VALUES (1744331272731369472, 1744329991446994944, 1, 28);
INSERT INTO `user_item` VALUES (1744331272731369473, 1744329991446994944, 3, 4);
INSERT INTO `user_item` VALUES (1744522788020035584, 1744522636412723200, 1, 33);
INSERT INTO `user_item` VALUES (1744522927874908160, 1744522636412723200, 4, 10);
INSERT INTO `user_item` VALUES (1744523011530301440, 1744522636412723200, 3, 8);
INSERT INTO `user_item` VALUES (1744905656227471360, 1744905656193916928, 1, 1054);
INSERT INTO `user_item` VALUES (1744906847258812416, 1744906847237840896, 1, 6);
INSERT INTO `user_item` VALUES (1744907959978303488, 1744906847237840896, 3, 4);
INSERT INTO `user_item` VALUES (1744918097065811968, 1744918097032257536, 1, 44);
INSERT INTO `user_item` VALUES (1744919752486297600, 1744918097032257536, 3, 10);

-- ----------------------------
-- Table structure for user_rune
-- ----------------------------
DROP TABLE IF EXISTS `user_rune`;
CREATE TABLE `user_rune`  (
  `id` bigint NOT NULL DEFAULT 0 COMMENT '主键ID',
  `user_id` bigint NULL DEFAULT 0 COMMENT '用户id',
  `rune_num` int NULL DEFAULT 0 COMMENT '符文编号',
  `is_put` int NULL DEFAULT 0 COMMENT '是否装备',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user_rune
-- ----------------------------
INSERT INTO `user_rune` VALUES (1730213013287477248, 1723907257525215232, 7, 1);
INSERT INTO `user_rune` VALUES (1730475357339000832, 1723907257525215232, 0, 1);
INSERT INTO `user_rune` VALUES (1730475362896453632, 1723907257525215232, 4, 1);
INSERT INTO `user_rune` VALUES (1730475370047741952, 1723907257525215232, 12, 1);
INSERT INTO `user_rune` VALUES (1732255706402398208, 1723907257525215232, 14, 1);
INSERT INTO `user_rune` VALUES (1732679530117734400, 1723907257525215232, 7, 1);
INSERT INTO `user_rune` VALUES (1732679530797211648, 1723907257525215232, 7, 1);
INSERT INTO `user_rune` VALUES (1732680939328380928, 1723907257525215232, 1, 1);
INSERT INTO `user_rune` VALUES (1732721958220603392, 1723907257525215232, 10, 0);
INSERT INTO `user_rune` VALUES (1732725552672022528, 1723907257525215232, 10, 1);
INSERT INTO `user_rune` VALUES (1732728681534726144, 1723907257525215232, 10, 1);
INSERT INTO `user_rune` VALUES (1732729031889133568, 1723907257525215232, 10, 0);
INSERT INTO `user_rune` VALUES (1732730400339533824, 1723907257525215232, 10, 0);
INSERT INTO `user_rune` VALUES (1732730462792720384, 1723907257525215232, 10, 0);
INSERT INTO `user_rune` VALUES (1734883878600056832, 1723907257525215232, 10, 0);
INSERT INTO `user_rune` VALUES (1734890838435176448, 1723907257525215232, 10, 0);
INSERT INTO `user_rune` VALUES (1737092006867509248, 1723907257525215232, 14, 1);
INSERT INTO `user_rune` VALUES (1737353464998141952, 1723907257525215232, 7, 1);
INSERT INTO `user_rune` VALUES (1737443455845670912, 1723907257525215232, 10, 0);
INSERT INTO `user_rune` VALUES (1737444143283707904, 1723907257525215232, 10, 0);
INSERT INTO `user_rune` VALUES (1737446034101116928, 1723907257525215232, 17, 1);
INSERT INTO `user_rune` VALUES (1737446622805237761, 1723907257525215232, 9, 1);
INSERT INTO `user_rune` VALUES (1737627481093054464, 1723907257525215232, 9, 1);
INSERT INTO `user_rune` VALUES (1737627485018923008, 1723907257525215232, 10, 0);
INSERT INTO `user_rune` VALUES (1742740849839710208, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1742740849839710209, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1742792062178304000, 1723907257525215233, 0, 1);
INSERT INTO `user_rune` VALUES (1742792062178304001, 1723907257525215233, 0, 0);
INSERT INTO `user_rune` VALUES (1743255339761016832, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1743255339761016833, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1743263192563458048, 1723907257525215233, 9, 1);
INSERT INTO `user_rune` VALUES (1743263192563458049, 1723907257525215233, 9, 0);
INSERT INTO `user_rune` VALUES (1743263197592428544, 1723907257525215233, 10, 1);
INSERT INTO `user_rune` VALUES (1743547983607242752, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1743547983607242753, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1743548799739109376, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1743548799739109377, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1743548817422295040, 1723907257525215232, 10, 0);
INSERT INTO `user_rune` VALUES (1743553221827371008, 1723907257525215232, 16, 1);
INSERT INTO `user_rune` VALUES (1744324019307552768, 1744323917750870016, 0, 0);
INSERT INTO `user_rune` VALUES (1744324019307552769, 1744323917750870016, 0, 0);
INSERT INTO `user_rune` VALUES (1744330012934414336, 1744329991446994944, 0, 1);
INSERT INTO `user_rune` VALUES (1744330012934414337, 1744329991446994944, 0, 0);
INSERT INTO `user_rune` VALUES (1744331351940800512, 1744329991446994944, 1, 1);
INSERT INTO `user_rune` VALUES (1744331351940800513, 1744329991446994944, 1, 0);
INSERT INTO `user_rune` VALUES (1744518926148182016, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1744518926148182017, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1744519155383672832, 1723907257525215232, 10, 0);
INSERT INTO `user_rune` VALUES (1744519160748187648, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1744519160748187649, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1744522776783495168, 1744522636412723200, 0, 1);
INSERT INTO `user_rune` VALUES (1744522776783495169, 1744522636412723200, 0, 0);
INSERT INTO `user_rune` VALUES (1744525366220955648, 1723907257525215232, 5, 0);
INSERT INTO `user_rune` VALUES (1744525392104005632, 1723907257525215232, 4, 0);
INSERT INTO `user_rune` VALUES (1744525394553479168, 1723907257525215232, 0, 0);
INSERT INTO `user_rune` VALUES (1744525395371368448, 1723907257525215232, 0, 0);
INSERT INTO `user_rune` VALUES (1744525396076011520, 1723907257525215232, 0, 0);
INSERT INTO `user_rune` VALUES (1744525397883756544, 1723907257525215232, 0, 0);
INSERT INTO `user_rune` VALUES (1744525400693940224, 1723907257525215232, 8, 0);
INSERT INTO `user_rune` VALUES (1744525401335668736, 1723907257525215232, 8, 0);
INSERT INTO `user_rune` VALUES (1744525403688673280, 1723907257525215232, 12, 0);
INSERT INTO `user_rune` VALUES (1744525404368150528, 1723907257525215232, 12, 0);
INSERT INTO `user_rune` VALUES (1744525404938575872, 1723907257525215232, 12, 0);
INSERT INTO `user_rune` VALUES (1744525408386293760, 1723907257525215232, 16, 0);
INSERT INTO `user_rune` VALUES (1744525408998662144, 1723907257525215232, 16, 0);
INSERT INTO `user_rune` VALUES (1744525435515052032, 1723907257525215232, 4, 0);
INSERT INTO `user_rune` VALUES (1744896258398625792, 1723907257525215232, 8, 0);
INSERT INTO `user_rune` VALUES (1744896258398625793, 1723907257525215232, 8, 0);
INSERT INTO `user_rune` VALUES (1744897232227934208, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1744897232227934209, 1723907257525215232, 9, 0);
INSERT INTO `user_rune` VALUES (1744906674919055360, 1744905656193916928, 0, 0);
INSERT INTO `user_rune` VALUES (1744906674919055361, 1744905656193916928, 0, 0);
INSERT INTO `user_rune` VALUES (1744906690857410560, 1744905656193916928, 9, 0);
INSERT INTO `user_rune` VALUES (1744906690857410561, 1744905656193916928, 9, 0);
INSERT INTO `user_rune` VALUES (1744907944681676800, 1744906847237840896, 0, 0);
INSERT INTO `user_rune` VALUES (1744907944681676801, 1744906847237840896, 0, 0);
INSERT INTO `user_rune` VALUES (1744918896500154368, 1744918097032257536, 0, 1);
INSERT INTO `user_rune` VALUES (1744918896500154369, 1744918097032257536, 0, 0);
INSERT INTO `user_rune` VALUES (1744918927105990656, 1744918097032257536, 10, 1);

SET FOREIGN_KEY_CHECKS = 1;