x1-project/db/x1_1_game.sql

/*
 Navicat Premium Data Transfer

 Source Server         : 192.168.3.245
 Source Server Type    : MySQL
 Source Server Version : 50727 (5.7.27)
 Source Host           : 192.168.3.245:33061
 Source Schema         : x1_4_game

 Target Server Type    : MySQL
 Target Server Version : 50727 (5.7.27)
 File Encoding         : 65001

 Date: 05/03/2025 09:32:16
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for achievement
-- ----------------------------
DROP TABLE IF EXISTS `achievement`;
CREATE TABLE `achievement` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `point` bigint(20) DEFAULT '0' COMMENT '成就点数',
  `task_map` text COMMENT '成就任务列表',
  `over_tasks` text COMMENT '已经完结的成就',
  `point_reward_id` int(11) DEFAULT '0' COMMENT '已经领取的成就点数奖励ID',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家成就任务表';

-- ----------------------------
-- Records of achievement
-- ----------------------------
BEGIN;
INSERT INTO `achievement` (`insert_time`, `update_time`, `pid`, `point`, `task_map`, `over_tasks`, `point_reward_id`) VALUES ('2024-11-22 11:03:03', '2024-11-22 11:22:15', 335879897874433, 0, '{\"1024\":{\"id\":1024,\"process\":4,\"status\":0},\"1025\":{\"id\":1025,\"process\":4,\"status\":0},\"1026\":{\"id\":1026,\"process\":4,\"status\":0},\"1027\":{\"id\":1027,\"process\":4,\"status\":0},\"1028\":{\"id\":1028,\"process\":4,\"status\":0},\"1029\":{\"id\":1029,\"process\":4,\"status\":0},\"1030\":{\"id\":1030,\"process\":4,\"status\":0},\"1031\":{\"id\":1031,\"process\":4,\"status\":0},\"1032\":{\"id\":1032,\"process\":4,\"status\":0},\"1033\":{\"id\":1033,\"process\":4,\"status\":0},\"1034\":{\"id\":1034,\"process\":4,\"status\":0},\"1035\":{\"id\":1035,\"process\":4,\"status\":0},\"1036\":{\"id\":1036,\"process\":4,\"status\":0},\"1037\":{\"id\":1037,\"process\":4,\"status\":0},\"1038\":{\"id\":1038,\"process\":4,\"status\":0},\"1039\":{\"id\":1039,\"process\":4,\"status\":0},\"1040\":{\"id\":1040,\"process\":4,\"status\":0},\"1041\":{\"id\":1041,\"process\":4,\"status\":0},\"1042\":{\"id\":1042,\"process\":4,\"status\":0},\"1043\":{\"id\":1043,\"process\":4,\"status\":0},\"1044\":{\"id\":1044,\"process\":4,\"status\":0},\"2101\":{\"id\":2101,\"process\":0,\"status\":0},\"2102\":{\"id\":2102,\"process\":0,\"status\":0},\"2103\":{\"id\":2103,\"process\":0,\"status\":0},\"2104\":{\"id\":2104,\"process\":0,\"status\":0},\"2105\":{\"id\":2105,\"process\":0,\"status\":0},\"2106\":{\"id\":2106,\"process\":0,\"status\":0},\"2107\":{\"id\":2107,\"process\":0,\"status\":0},\"2108\":{\"id\":2108,\"process\":0,\"status\":0},\"2109\":{\"id\":2109,\"process\":0,\"status\":0},\"2110\":{\"id\":2110,\"process\":0,\"status\":0},\"2111\":{\"id\":2111,\"process\":0,\"status\":0},\"2112\":{\"id\":2112,\"process\":0,\"status\":0},\"1601\":{\"id\":1601,\"process\":0,\"status\":0},\"2113\":{\"id\":2113,\"process\":0,\"status\":0},\"1602\":{\"id\":1602,\"process\":0,\"status\":0},\"2114\":{\"id\":2114,\"process\":0,\"status\":0},\"1603\":{\"id\":1603,\"process\":0,\"status\":0},\"2115\":{\"id\":2115,\"process\":0,\"status\":0},\"1604\":{\"id\":1604,\"process\":0,\"status\":0},\"2116\":{\"id\":2116,\"process\":0,\"status\":0},\"1605\":{\"id\":1605,\"process\":0,\"status\":0},\"2117\":{\"id\":2117,\"process\":0,\"status\":0},\"1606\":{\"id\":1606,\"process\":0,\"status\":0},\"2118\":{\"id\":2118,\"process\":0,\"status\":0},\"1607\":{\"id\":1607,\"process\":0,\"status\":0},\"2119\":{\"id\":2119,\"process\":0,\"status\":0},\"1608\":{\"id\":1608,\"process\":0,\"status\":0},\"2120\":{\"id\":2120,\"process\":0,\"status\":0},\"1609\":{\"id\":1609,\"process\":0,\"status\":0},\"2121\":{\"id\":2121,\"process\":0,\"status\":0},\"1610\":{\"id\":1610,\"process\":0,\"status\":0},\"2122\":{\"id\":2122,\"process\":0,\"status\":0},\"1611\":{\"id\":1611,\"process\":0,\"status\":0},\"2123\":{\"id\":2123,\"process\":0,\"status\":0},\"1612\":{\"id\":1612,\"process\":0,\"status\":0},\"2124\":{\"id\":2124,\"process\":0,\"status\":0},\"1101\":{\"id\":1101,\"process\":0,\"status\":0},\"1613\":{\"id\":1613,\"process\":0,\"status\":0},\"2125\":{\"id\":2125,\"process\":0,\"status\":0},\"1102\":{\"id\":1102,\"process\":0,\"status\":0},\"1614\":{\"id\":1614,\"process\":0,\"status\":0},\"2126\":{\"id\":2126,\"process\":0,\"status\":0},\"1103\":{\"id\":1103,\"process\":0,\"status\":0},\"1615\":{\"id\":1615,\"process\":0,\"status\":0},\"1104\":{\"id\":1104,\"process\":0,\"status\":0},\"1616\":{\"id\":1616,\"process\":0,\"status\":0},\"1105\":{\"id\":1105,\"process\":0,\"status\":0},\"1617\":{\"id\":1617,\"process\":0,\"status\":0},\"1106\":{\"id\":1106,\"process\":0,\"status\":0},\"1618\":{\"id\":1618,\"process\":0,\"status\":0},\"1107\":{\"id\":1107,\"process\":0,\"status\":0},\"1619\":{\"id\":1619,\"process\":0,\"status\":0},\"1108\":{\"id\":1108,\"process\":0,\"status\":0},\"1620\":{\"id\":1620,\"process\":0,\"status\":0},\"1109\":{\"id\":1109,\"process\":0,\"status\":0},\"1621\":{\"id\":1621,\"process\":0,\"status\":0},\"1110\":{\"id\":1110,\"process\":0,\"status\":0},\"1622\":{\"id\":1622,\"process\":0,\"status\":0},\"1111\":{\"id\":1111,\"process\":0,\"status\":0},\"1623\":{\"id\":1623,\"process\":0,\"status\":0},\"1112\":{\"id\":1112,\"process\":0,\"status\":0},\"1113\":{\"id\":1113,\"process\":0,\"status\":0},\"1114\":{\"id\":1114,\"process\":0,\"status\":0},\"1115\":{\"id\":1115,\"process\":0,\"status\":0},\"1116\":{\"id\":1116,\"process\":0,\"status\":0},\"1117\":{\"id\":1117,\"process\":0,\"status\":0},\"1118\":{\"id\":1118,\"process\":0,\"status\":0},\"1119\":{\"id\":1119,\"process\":0,\"status\":0},\"1120\":{\"id\":1120,\"process\":0,\"status\":0},\"1121\":{\"id\":1121,\"process\":0,\"status\":0},\"1122\":{\"id\":1122,\"process\":0,\"status\":0},\"1123\":{\"id\":1123,\"process\":0,\"status\":0},\"1124\":{\"id\":1124,\"process\":0,\"status\":0},\"1125\":{\"id\":1125,\"process\":0,\"status\":0},\"1126\":{\"id\":1126,\"process\":0,\"status\":0},\"1127\":{\"id\":1127,\"process\":0,\"status\":0},\"1128\":{\"id\":1128,\"process\":0,\"status\":0},\"1701\":{\"id\":1701,\"process\":0,\"status\":0},\"1702\":{\"id\":1702,\"process\":0,\"status\":0},\"1703\":{\"id\":1703,\"process\":0,\"status\":0},\"1704\":{\"id\":1704,\"process\":0,\"status\":0},\"1705\":{\"id\":1705,\"process\":0,\"status\":0},\"1706\":{\"id\":1706,\"process\":0,\"status\":0},\"1707\":{\"id\":1707,\"process\":0,\"status\":0},\"1708\":{\"id\":1708,\"process\":0,\"status\":0},\"1709\":{\"id\":1709,\"process\":0,\"status\":0},\"1710\":{\"id\":1710,\"process\":0,\"status\":0},\"1711\":{\"id\":1711,\"process\":0,\"status\":0},\"1712\":{\"id\":1712,\"process\":0,\"status\":0},\"1201\":{\"id\":1201,\"process\":0,\"status\":0},\"1713\":{\"id\":1713,\"process\":0,\"status\":0},\"1202\":{\"id\":1202,\"process\":0,\"status\":0},\"1714\":{\"id\":1714,\"process\":0,\"status\":0},\"1203\":{\"id\":1203,\"process\":0,\"status\":0},\"1204\":{\"id\":1204,\"process\":0,\"status\":0},\"1205\":{\"id\":1205,\"process\":0,\"status\":0},\"1206\":{\"id\":1206,\"process\":0,\"status\":0},\"1207\":{\"id\":1207,\"process\":0,\"status\":0},\"1208\":{\"id\":1208,\"process\":0,\"status\":0},\"1209\":{\"id\":1209,\"process\":0,\"status\":0},\"1210\":{\"id\":1210,\"process\":0,\"status\":0},\"1211\":{\"id\":1211,\"process\":0,\"status\":0},\"1212\":{\"id\":1212,\"process\":0,\"status\":0},\"1213\":{\"id\":1213,\"process\":0,\"status\":0},\"1214\":{\"id\":1214,\"process\":0,\"status\":0},\"1215\":{\"id\":1215,\"process\":0,\"status\":0},\"1216\":{\"id\":1216,\"process\":0,\"status\":0},\"1217\":{\"id\":1217,\"process\":0,\"status\":0},\"1218\":{\"id\":1218,\"process\":0,\"status\":0},\"1219\":{\"id\":1219,\"process\":0,\"status\":0},\"1220\":{\"id\":1220,\"process\":0,\"status\":0},\"1221\":{\"id\":1221,\"process\":0,\"status\":0},\"1222\":{\"id\":1222,\"process\":0,\"status\":0},\"1223\":{\"id\":1223,\"process\":0,\"status\":0},\"1224\":{\"id\":1224,\"process\":0,\"status\":0},\"1225\":{\"id\":1225,\"process\":0,\"status\":0},\"1226\":{\"id\":1226,\"process\":0,\"status\":0},\"1227\":{\"id\":1227,\"process\":0,\"status\":0},\"1228\":{\"id\":1228,\"process\":0,\"status\":0},\"1229\":{\"id\":1229,\"process\":0,\"status\":0},\"1230\":{\"id\":1230,\"process\":0,\"status\":0},\"1801\":{\"id\":1801,\"process\":0,\"status\":0},\"1802\":{\"id\":1802,\"process\":0,\"status\":0},\"1803\":{\"id\":1803,\"process\":0,\"status\":0},\"1804\":{\"id\":1804,\"process\":0,\"status\":0},\"1805\":{\"id\":1805,\"process\":0,\"status\":0},\"1806\":{\"id\":1806,\"process\":0,\"status\":0},\"1807\":{\"id\":1807,\"process\":0,\"status\":0},\"1808\":{\"id\":1808,\"process\":0,\"status\":0},\"1809\":{\"id\":1809,\"process\":0,\"status\":0},\"1810\":{\"id\":1810,\"process\":0,\"status\":0},\"1811\":{\"id\":1811,\"process\":0,\"status\":0},\"1812\":{\"id\":1812,\"process\":0,\"status\":0},\"1301\":{\"id\":1301,\"process\":0,\"status\":0},\"1813\":{\"id\":1813,\"process\":0,\"status\":0},\"1302\":{\"id\":1302,\"process\":0,\"status\":0},\"1814\":{\"id\":1814,\"process\":0,\"status\":0},\"1303\":{\"id\":1303,\"process\":0,\"status\":0},\"1815\":{\"id\":1815,\"process\":0,\"status\":0},\"1304\":{\"id\":1304,\"process\":0,\"status\":0},\"1816\":{\"id\":1816,\"process\":0,\"status\":0},\"1305\":{\"id\":1305,\"process\":0,\"status\":0},\"1817\":{\"id\":1817,\"process\":0,\"status\":0},\"1306\":{\"id\":1306,\"process\":0,\"status\":0},\"1818\":{\"id\":1818,\"process\":0,\"status\":0},\"1307\":{\"id\":1307,\"process\":0,\"status\":0},\"1819\":{\"id\":1819,\"process\":0,\"status\":0},\"1308\":{\"id\":1308,\"process\":0,\"status\":0},\"1820\":{\"id\":1820,\"process\":0,\"status\":0},\"1309\":{\"id\":1309,\"process\":0,\"status\":0},\"1821\":{\"id\":1821,\"process\":0,\"status\":0},\"1310\":{\"id\":1310,\"process\":0,\"status\":0},\"1822\":{\"id\":1822,\"process\":0,\"status\":0},\"1311\":{\"id\":1311,\"process\":0,\"status\":0},\"1823\":{\"id\":1823,\"process\":0,\"status\":0},\"1312\":{\"id\":1312,\"process\":0,\"status\":0},\"1313\":{\"id\":1313,\"process\":0,\"status\":0},\"1901\":{\"id\":1901,\"process\":0,\"status\":0},\"1902\":{\"id\":1902,\"process\":0,\"status\":0},\"1903\":{\"id\":1903,\"process\":0,\"status\":0},\"1904\":{\"id\":1904,\"process\":0,\"status\":0},\"1905\":{\"id\":1905,\"process\":0,\"status\":0},\"1906\":{\"id\":1906,\"process\":0,\"status\":0},\"1907\":{\"id\":1907,\"process\":0,\"status\":0},\"1908\":{\"id\":1908,\"process\":0,\"status\":0},\"1909\":{\"id\":1909,\"process\":0,\"status\":0},\"1910\":{\"id\":1910,\"process\":0,\"status\":0},\"1911\":{\"id\":1911,\"process\":0,\"status\":0},\"1912\":{\"id\":1912,\"process\":0,\"status\":0},\"1401\":{\"id\":1401,\"process\":0,\"status\":0},\"1913\":{\"id\":1913,\"process\":0,\"status\":0},\"1402\":{\"id\":1402,\"process\":0,\"status\":0},\"1914\":{\"id\":1914,\"process\":0,\"status\":0},\"1403\":{\"id\":1403,\"process\":0,\"status\":0},\"1915\":{\"id\":1915,\"process\":0,\"status\":0},\"1404\":{\"id\":1404,\"process\":0,\"status\":0},\"1916\":{\"id\":1916,\"process\":0,\"status\":0},\"1405\":{\"id\":1405,\"process\":0,\"status\":0},\"1917\":{\"id\":1917,\"process\":0,\"status\":0},\"1406\":{\"id\":1406,\"process\":0,\"status\":0},\"1918\":{\"id\":1918,\"process\":0,\"status\":0},\"1407\":{\"id\":1407,\"process\":0,\"status\":0},\"1919\":{\"id\":1919,\"process\":0,\"status\":0},\"1408\":{\"id\":1408,\"process\":0,\"status\":0},\"1920\":{\"id\":1920,\"process\":0,\"status\":0},\"1409\":{\"id\":1409,\"process\":0,\"status\":0},\"1410\":{\"id\":1410,\"process\":0,\"status\":0},\"1411\":{\"id\":1411,\"process\":0,\"status\":0},\"2001\":{\"id\":2001,\"process\":0,\"status\":0},\"2002\":{\"id\":2002,\"process\":0,\"status\":0},\"2003\":{\"id\":2003,\"process\":0,\"status\":0},\"2004\":{\"id\":2004,\"process\":0,\"status\":0},\"2005\":{\"id\":2005,\"process\":0,\"status\":0},\"2006\":{\"id\":2006,\"process\":0,\"status\":0},\"2007\":{\"id\":2007,\"process\":0,\"status\":0},\"2008\":{\"id\":2008,\"process\":0,\"status\":0},\"2009\":{\"id\":2009,\"process\":0,\"status\":0},\"2010\":{\"id\":2010,\"process\":0,\"status\":0},\"2011\":{\"id\":2011,\"process\":0,\"status\":0},\"2012\":{\"id\":2012,\"process\":0,\"status\":0},\"1501\":{\"id\":1501,\"process\":0,\"status\":0},\"2013\":{\"id\":2013,\"process\":0,\"status\":0},\"1502\":{\"id\":1502,\"process\":0,\"status\":0},\"2014\":{\"id\":2014,\"process\":0,\"status\":0},\"1503\":{\"id\":1503,\"process\":0,\"status\":0},\"2015\":{\"id\":2015,\"process\":0,\"status\":0},\"1504\":{\"id\":1504,\"process\":0,\"status\":0},\"2016\":{\"id\":2016,\"process\":0,\"status\":0},\"1505\":{\"id\":1505,\"process\":0,\"status\":0},\"2017\":{\"id\":2017,\"process\":0,\"status\":0},\"1506\":{\"id\":1506,\"process\":0,\"status\":0},\"2018\":{\"id\":2018,\"process\":0,\"status\":0},\"1507\":{\"id\":1507,\"process\":0,\"status\":0},\"2019\":{\"id\":2019,\"process\":0,\"status\":0},\"1508\":{\"id\":1508,\"process\":0,\"status\":0},\"2020\":{\"id\":2020,\"process\":0,\"status\":0},\"1509\":{\"id\":1509,\"process\":0,\"status\":0},\"2021\":{\"id\":2021,\"process\":0,\"status\":0},\"1510\":{\"id\":1510,\"process\":0,\"status\":0},\"2022\":{\"id\":2022,\"process\":0,\"status\":0},\"1511\":{\"id\":1511,\"process\":0,\"status\":0},\"2023\":{\"id\":2023,\"process\":0,\"status\":0},\"1512\":{\"id\":1512,\"process\":0,\"status\":0},\"2024\":{\"id\":2024,\"process\":0,\"status\":0},\"1001\":{\"id\":1001,\"process\":2,\"status\":1},\"1513\":{\"id\":1513,\"process\":0,\"status\":0},\"2025\":{\"id\":2025,\"process\":0,\"status\":0},\"1002\":{\"id\":1002,\"process\":4,\"status\":1},\"1514\":{\"id\":1514,\"process\":0,\"status\":0},\"1003\":{\"id\":1003,\"process\":4,\"status\":0},\"1515\":{\"id\":1515,\"process\":0,\"status\":0},\"1004\":{\"id\":1004,\"process\":4,\"status\":0},\"1516\":{\"id\":1516,\"process\":0,\"status\":0},\"1005\":{\"id\":1005,\"process\":4,\"status\":0},\"1517\":{\"id\":1517,\"process\":0,\"status\":0},\"1006\":{\"id\":1006,\"process\":4,\"status\":0},\"1518\":{\"id\":1518,\"process\":0,\"status\":0},\"1007\":{\"id\":1007,\"process\":4,\"status\":0},\"1519\":{\"id\":1519,\"process\":0,\"status\":0},\"1008\":{\"id\":1008,\"process\":4,\"status\":0},\"1520\":{\"id\":1520,\"process\":0,\"status\":0},\"1009\":{\"id\":1009,\"process\":4,\"status\":0},\"1521\":{\"id\":1521,\"process\":0,\"status\":0},\"1010\":{\"id\":1010,\"process\":4,\"status\":0},\"1522\":{\"id\":1522,\"process\":0,\"status\":0},\"1011\":{\"id\":1011,\"process\":4,\"status\":0},\"1523\":{\"id\":1523,\"process\":0,\"status\":0},\"1012\":{\"id\":1012,\"process\":4,\"status\":0},\"1524\":{\"id\":1524,\"process\":0,\"status\":0},\"1013\":{\"id\":1013,\"process\":4,\"status\":0},\"1014\":{\"id\":1014,\"process\":4,\"status\":0},\"1015\":{\"id\":1015,\"process\":4,\"status\":0},\"1016\":{\"id\":1016,\"process\":4,\"status\":0},\"1017\":{\"id\":1017,\"process\":4,\"status\":0},\"1018\":{\"id\":1018,\"process\":4,\"status\":0},\"1019\":{\"id\":1019,\"process\":4,\"status\":0},\"1020\":{\"id\":1020,\"process\":4,\"status\":0},\"1021\":{\"id\":1021,\"process\":4,\"status\":0},\"1022\":{\"id\":1022,\"process\":4,\"status\":0},\"1023\":{\"id\":1023,\"process\":4,\"status\":0}}', '[]', 0);
INSERT INTO `achievement` (`insert_time`, `update_time`, `pid`, `point`, `task_map`, `over_tasks`, `point_reward_id`) VALUES ('2024-11-22 11:37:15', '2024-11-22 11:50:16', 335879897874434, 0, '{\"1024\":{\"id\":1024,\"process\":1,\"status\":0},\"1025\":{\"id\":1025,\"process\":1,\"status\":0},\"1026\":{\"id\":1026,\"process\":1,\"status\":0},\"1027\":{\"id\":1027,\"process\":1,\"status\":0},\"1028\":{\"id\":1028,\"process\":1,\"status\":0},\"1029\":{\"id\":1029,\"process\":1,\"status\":0},\"1030\":{\"id\":1030,\"process\":1,\"status\":0},\"1031\":{\"id\":1031,\"process\":1,\"status\":0},\"1032\":{\"id\":1032,\"process\":1,\"status\":0},\"1033\":{\"id\":1033,\"process\":1,\"status\":0},\"1034\":{\"id\":1034,\"process\":1,\"status\":0},\"1035\":{\"id\":1035,\"process\":1,\"status\":0},\"1036\":{\"id\":1036,\"process\":1,\"status\":0},\"1037\":{\"id\":1037,\"process\":1,\"status\":0},\"1038\":{\"id\":1038,\"process\":1,\"status\":0},\"1039\":{\"id\":1039,\"process\":1,\"status\":0},\"1040\":{\"id\":1040,\"process\":1,\"status\":0},\"1041\":{\"id\":1041,\"process\":1,\"status\":0},\"1042\":{\"id\":1042,\"process\":1,\"status\":0},\"1043\":{\"id\":1043,\"process\":1,\"status\":0},\"1044\":{\"id\":1044,\"process\":1,\"status\":0},\"2101\":{\"id\":2101,\"process\":0,\"status\":0},\"2102\":{\"id\":2102,\"process\":0,\"status\":0},\"2103\":{\"id\":2103,\"process\":0,\"status\":0},\"2104\":{\"id\":2104,\"process\":0,\"status\":0},\"2105\":{\"id\":2105,\"process\":0,\"status\":0},\"2106\":{\"id\":2106,\"process\":0,\"status\":0},\"2107\":{\"id\":2107,\"process\":0,\"status\":0},\"2108\":{\"id\":2108,\"process\":0,\"status\":0},\"2109\":{\"id\":2109,\"process\":0,\"status\":0},\"2110\":{\"id\":2110,\"process\":0,\"status\":0},\"2111\":{\"id\":2111,\"process\":0,\"status\":0},\"2112\":{\"id\":2112,\"process\":0,\"status\":0},\"1601\":{\"id\":1601,\"process\":540,\"status\":1},\"2113\":{\"id\":2113,\"process\":0,\"status\":0},\"1602\":{\"id\":1602,\"process\":540,\"status\":1},\"2114\":{\"id\":2114,\"process\":0,\"status\":0},\"1603\":{\"id\":1603,\"process\":540,\"status\":1},\"2115\":{\"id\":2115,\"process\":0,\"status\":0},\"1604\":{\"id\":1604,\"process\":1043,\"status\":1},\"2116\":{\"id\":2116,\"process\":0,\"status\":0},\"1605\":{\"id\":1605,\"process\":1043,\"status\":1},\"2117\":{\"id\":2117,\"process\":0,\"status\":0},\"1606\":{\"id\":1606,\"process\":1043,\"status\":0},\"2118\":{\"id\":2118,\"process\":0,\"status\":0},\"1607\":{\"id\":1607,\"process\":1043,\"status\":0},\"2119\":{\"id\":2119,\"process\":0,\"status\":0},\"1608\":{\"id\":1608,\"process\":1043,\"status\":0},\"2120\":{\"id\":2120,\"process\":0,\"status\":0},\"1609\":{\"id\":1609,\"process\":1043,\"status\":0},\"2121\":{\"id\":2121,\"process\":0,\"status\":0},\"1610\":{\"id\":1610,\"process\":1043,\"status\":0},\"2122\":{\"id\":2122,\"process\":0,\"status\":0},\"1611\":{\"id\":1611,\"process\":1043,\"status\":0},\"2123\":{\"id\":2123,\"process\":0,\"status\":0},\"1612\":{\"id\":1612,\"process\":1043,\"status\":0},\"2124\":{\"id\":2124,\"process\":0,\"status\":0},\"1101\":{\"id\":1101,\"process\":3,\"status\":0},\"1613\":{\"id\":1613,\"process\":1043,\"status\":0},\"2125\":{\"id\":2125,\"process\":0,\"status\":0},\"1102\":{\"id\":1102,\"process\":3,\"status\":0},\"1614\":{\"id\":1614,\"process\":1043,\"status\":0},\"2126\":{\"id\":2126,\"process\":0,\"status\":0},\"1103\":{\"id\":1103,\"process\":3,\"status\":0},\"1615\":{\"id\":1615,\"process\":1043,\"status\":0},\"1104\":{\"id\":1104,\"process\":3,\"status\":0},\"1616\":{\"id\":1616,\"process\":1043,\"status\":0},\"1105\":{\"id\":1105,\"process\":3,\"status\":0},\"1617\":{\"id\":1617,\"process\":1043,\"status\":0},\"1106\":{\"id\":1106,\"process\":3,\"status\":0},\"1618\":{\"id\":1618,\"process\":1043,\"status\":0},\"1107\":{\"id\":1107,\"process\":3,\"status\":0},\"1619\":{\"id\":1619,\"process\":1043,\"status\":0},\"1108\":{\"id\":1108,\"process\":3,\"status\":0},\"1620\":{\"id\":1620,\"process\":1043,\"status\":0},\"1109\":{\"id\":1109,\"process\":3,\"status\":0},\"1621\":{\"id\":1621,\"process\":1043,\"status\":0},\"1110\":{\"id\":1110,\"process\":3,\"status\":0},\"1622\":{\"id\":1622,\"process\":1043,\"status\":0},\"1111\":{\"id\":1111,\"process\":3,\"status\":0},\"1623\":{\"id\":1623,\"process\":1043,\"status\":0},\"1112\":{\"id\":1112,\"process\":3,\"status\":0},\"1113\":{\"id\":1113,\"process\":3,\"status\":0},\"1114\":{\"id\":1114,\"process\":3,\"status\":0},\"1115\":{\"id\":1115,\"process\":3,\"status\":0},\"1116\":{\"id\":1116,\"process\":3,\"status\":0},\"1117\":{\"id\":1117,\"process\":3,\"status\":0},\"1118\":{\"id\":1118,\"process\":3,\"status\":0},\"1119\":{\"id\":1119,\"process\":3,\"status\":0},\"1120\":{\"id\":1120,\"process\":3,\"status\":0},\"1121\":{\"id\":1121,\"process\":3,\"status\":0},\"1122\":{\"id\":1122,\"process\":3,\"status\":0},\"1123\":{\"id\":1123,\"process\":3,\"status\":0},\"1124\":{\"id\":1124,\"process\":3,\"status\":0},\"1125\":{\"id\":1125,\"process\":3,\"status\":0},\"1126\":{\"id\":1126,\"process\":3,\"status\":0},\"1127\":{\"id\":1127,\"process\":3,\"status\":0},\"1128\":{\"id\":1128,\"process\":3,\"status\":0},\"1701\":{\"id\":1701,\"process\":1043,\"status\":0},\"1702\":{\"id\":1702,\"process\":1043,\"status\":0},\"1703\":{\"id\":1703,\"process\":1043,\"status\":0},\"1704\":{\"id\":1704,\"process\":1043,\"status\":0},\"1705\":{\"id\":1705,\"process\":1043,\"status\":0},\"1706\":{\"id\":1706,\"process\":1043,\"status\":0},\"1707\":{\"id\":1707,\"process\":1043,\"status\":0},\"1708\":{\"id\":1708,\"process\":1043,\"status\":0},\"1709\":{\"id\":1709,\"process\":1043,\"status\":0},\"1710\":{\"id\":1710,\"process\":1043,\"status\":0},\"1711\":{\"id\":1711,\"process\":1043,\"status\":0},\"1712\":{\"id\":1712,\"process\":1043,\"status\":0},\"1201\":{\"id\":1201,\"process\":3,\"status\":0},\"1713\":{\"id\":1713,\"process\":1043,\"status\":0},\"1202\":{\"id\":1202,\"process\":3,\"status\":0},\"1714\":{\"id\":1714,\"process\":1043,\"status\":0},\"1203\":{\"id\":1203,\"process\":3,\"status\":0},\"1204\":{\"id\":1204,\"process\":3,\"status\":0},\"1205\":{\"id\":1205,\"process\":3,\"status\":0},\"1206\":{\"id\":1206,\"process\":3,\"status\":0},\"1207\":{\"id\":1207,\"process\":3,\"status\":0},\"1208\":{\"id\":1208,\"process\":3,\"status\":0},\"1209\":{\"id\":1209,\"process\":3,\"status\":0},\"1210\":{\"id\":1210,\"process\":3,\"status\":0},\"1211\":{\"id\":1211,\"process\":3,\"status\":0},\"1212\":{\"id\":1212,\"process\":3,\"status\":0},\"1213\":{\"id\":1213,\"process\":3,\"status\":0},\"1214\":{\"id\":1214,\"process\":3,\"status\":0},\"1215\":{\"id\":1215,\"process\":3,\"status\":0},\"1216\":{\"id\":1216,\"process\":3,\"status\":0},\"1217\":{\"id\":1217,\"process\":3,\"status\":0},\"1218\":{\"id\":1218,\"process\":3,\"status\":0},\"1219\":{\"id\":1219,\"process\":3,\"status\":0},\"1220\":{\"id\":1220,\"process\":3,\"status\":0},\"1221\":{\"id\":1221,\"process\":3,\"status\":0},\"1222\":{\"id\":1222,\"process\":3,\"status\":0},\"1223\":{\"id\":1223,\"process\":3,\"status\":0},\"1224\":{\"id\":1224,\"process\":3,\"status\":0},\"1225\":{\"id\":1225,\"process\":3,\"status\":0},\"1226\":{\"id\":1226,\"process\":3,\"status\":0},\"1227\":{\"id\":1227,\"process\":3,\"status\":0},\"1228\":{\"id\":1228,\"process\":3,\"status\":0},\"1229\":{\"id\":1229,\"process\":3,\"status\":0},\"1230\":{\"id\":1230,\"process\":3,\"status\":0},\"1801\":{\"id\":1801,\"process\":63,\"status\":0},\"1802\":{\"id\":1802,\"process\":63,\"status\":0},\"1803\":{\"id\":1803,\"process\":63,\"status\":0},\"1804\":{\"id\":1804,\"process\":63,\"status\":0},\"1805\":{\"id\":1805,\"process\":63,\"status\":0},\"1806\":{\"id\":1806,\"process\":63,\"status\":0},\"1807\":{\"id\":1807,\"process\":63,\"status\":0},\"1808\":{\"id\":1808,\"process\":63,\"status\":0},\"1809\":{\"id\":1809,\"process\":63,\"status\":0},\"1810\":{\"id\":1810,\"process\":63,\"status\":0},\"1811\":{\"id\":1811,\"process\":63,\"status\":0},\"1812\":{\"id\":1812,\"process\":63,\"status\":0},\"1301\":{\"id\":1301,\"process\":2,\"status\":1},\"1813\":{\"id\":1813,\"process\":63,\"status\":0},\"1302\":{\"id\":1302,\"process\":3,\"status\":0},\"1814\":{\"id\":1814,\"process\":63,\"status\":0},\"1303\":{\"id\":1303,\"process\":3,\"status\":0},\"1815\":{\"id\":1815,\"process\":63,\"status\":0},\"1304\":{\"id\":1304,\"process\":3,\"status\":0},\"1816\":{\"id\":1816,\"process\":63,\"status\":0},\"1305\":{\"id\":1305,\"process\":3,\"status\":0},\"1817\":{\"id\":1817,\"process\":63,\"status\":0},\"1306\":{\"id\":1306,\"process\":3,\"status\":0},\"1818\":{\"id\":1818,\"process\":63,\"status\":0},\"1307\":{\"id\":1307,\"process\":3,\"status\":0},\"1819\":{\"id\":1819,\"process\":63,\"status\":0},\"1308\":{\"id\":1308,\"process\":3,\"status\":0},\"1820\":{\"id\":1820,\"process\":63,\"status\":0},\"1309\":{\"id\":1309,\"process\":3,\"status\":0},\"1821\":{\"id\":1821,\"process\":63,\"status\":0},\"1310\":{\"id\":1310,\"process\":3,\"status\":0},\"1822\":{\"id\":1822,\"process\":63,\"status\":0},\"1311\":{\"id\":1311,\"process\":3,\"status\":0},\"1823\":{\"id\":1823,\"process\":63,\"status\":0},\"1312\":{\"id\":1312,\"process\":3,\"status\":0},\"1313\":{\"id\":1313,\"process\":3,\"status\":0},\"1901\":{\"id\":1901,\"process\":0,\"status\":0},\"1902\":{\"id\":1902,\"process\":0,\"status\":0},\"1903\":{\"id\":1903,\"process\":0,\"status\":0},\"1904\":{\"id\":1904,\"process\":0,\"status\":0},\"1905\":{\"id\":1905,\"process\":0,\"status\":0},\"1906\":{\"id\":1906,\"process\":0,\"status\":0},\"1907\":{\"id\":1907,\"process\":0,\"status\":0},\"1908\":{\"id\":1908,\"process\":0,\"status\":0},\"1909\":{\"id\":1909,\"process\":0,\"status\":0},\"1910\":{\"id\":1910,\"process\":0,\"status\":0},\"1911\":{\"id\":1911,\"process\":0,\"status\":0},\"1912\":{\"id\":1912,\"process\":0,\"status\":0},\"1401\":{\"id\":1401,\"process\":2,\"status\":1},\"1913\":{\"id\":1913,\"process\":0,\"status\":0},\"1402\":{\"id\":1402,\"process\":3,\"status\":1},\"1914\":{\"id\":1914,\"process\":0,\"status\":0},\"1403\":{\"id\":1403,\"process\":3,\"status\":0},\"1915\":{\"id\":1915,\"process\":0,\"status\":0},\"1404\":{\"id\":1404,\"process\":3,\"status\":0},\"1916\":{\"id\":1916,\"process\":0,\"status\":0},\"1405\":{\"id\":1405,\"process\":3,\"status\":0},\"1917\":{\"id\":1917,\"process\":0,\"status\":0},\"1406\":{\"id\":1406,\"process\":3,\"status\":0},\"1918\":{\"id\":1918,\"process\":0,\"status\":0},\"1407\":{\"id\":1407,\"process\":3,\"status\":0},\"1919\":{\"id\":1919,\"process\":0,\"status\":0},\"1408\":{\"id\":1408,\"process\":3,\"status\":0},\"1920\":{\"id\":1920,\"process\":0,\"status\":0},\"1409\":{\"id\":1409,\"process\":3,\"status\":0},\"1410\":{\"id\":1410,\"process\":3,\"status\":0},\"1411\":{\"id\":1411,\"process\":3,\"status\":0},\"2001\":{\"id\":2001,\"process\":0,\"status\":0},\"2002\":{\"id\":2002,\"process\":0,\"status\":0},\"2003\":{\"id\":2003,\"process\":0,\"status\":0},\"2004\":{\"id\":2004,\"process\":0,\"status\":0},\"2005\":{\"id\":2005,\"process\":0,\"status\":0},\"2006\":{\"id\":2006,\"process\":0,\"status\":0},\"2007\":{\"id\":2007,\"process\":0,\"status\":0},\"2008\":{\"id\":2008,\"process\":0,\"status\":0},\"2009\":{\"id\":2009,\"process\":0,\"status\":0},\"2010\":{\"id\":2010,\"process\":0,\"status\":0},\"2011\":{\"id\":2011,\"process\":0,\"status\":0},\"2012\":{\"id\":2012,\"process\":0,\"status\":0},\"1501\":{\"id\":1501,\"process\":1043,\"status\":0},\"2013\":{\"id\":2013,\"process\":0,\"status\":0},\"1502\":{\"id\":1502,\"process\":1043,\"status\":0},\"2014\":{\"id\":2014,\"process\":0,\"status\":0},\"1503\":{\"id\":1503,\"process\":1043,\"status\":0},\"2015\":{\"id\":2015,\"process\":0,\"status\":0},\"1504\":{\"id\":1504,\"process\":1043,\"status\":0},\"2016\":{\"id\":2016,\"process\":0,\"status\":0},\"1505\":{\"id\":1505,\"process\":1043,\"status\":0},\"2017\":{\"id\":2017,\"process\":0,\"status\":0},\"1506\":{\"id\":1506,\"process\":1043,\"status\":0},\"2018\":{\"id\":2018,\"process\":0,\"status\":0},\"1507\":{\"id\":1507,\"process\":1043,\"status\":0},\"2019\":{\"id\":2019,\"process\":0,\"status\":0},\"1508\":{\"id\":1508,\"process\":1043,\"status\":0},\"2020\":{\"id\":2020,\"process\":0,\"status\":0},\"1509\":{\"id\":1509,\"process\":1043,\"status\":0},\"2021\":{\"id\":2021,\"process\":0,\"status\":0},\"1510\":{\"id\":1510,\"process\":1043,\"status\":0},\"2022\":{\"id\":2022,\"process\":0,\"status\":0},\"1511\":{\"id\":1511,\"process\":1043,\"status\":0},\"2023\":{\"id\":2023,\"process\":0,\"status\":0},\"1512\":{\"id\":1512,\"process\":1043,\"status\":0},\"2024\":{\"id\":2024,\"process\":0,\"status\":0},\"1001\":{\"id\":1001,\"process\":1,\"status\":0},\"1513\":{\"id\":1513,\"process\":1043,\"status\":0},\"2025\":{\"id\":2025,\"process\":0,\"status\":0},\"1002\":{\"id\":1002,\"process\":1,\"status\":0},\"1514\":{\"id\":1514,\"process\":1043,\"status\":0},\"1003\":{\"id\":1003,\"process\":1,\"status\":0},\"1515\":{\"id\":1515,\"process\":1043,\"status\":0},\"1004\":{\"id\":1004,\"process\":1,\"status\":0},\"1516\":{\"id\":1516,\"process\":1043,\"status\":0},\"1005\":{\"id\":1005,\"process\":1,\"status\":0},\"1517\":{\"id\":1517,\"process\":1043,\"status\":0},\"1006\":{\"id\":1006,\"process\":1,\"status\":0},\"1518\":{\"id\":1518,\"process\":1043,\"status\":0},\"1007\":{\"id\":1007,\"process\":1,\"status\":0},\"1519\":{\"id\":1519,\"process\":1043,\"status\":0},\"1008\":{\"id\":1008,\"process\":1,\"status\":0},\"1520\":{\"id\":1520,\"process\":1043,\"status\":0},\"1009\":{\"id\":1009,\"process\":1,\"status\":0},\"1521\":{\"id\":1521,\"process\":1043,\"status\":0},\"1010\":{\"id\":1010,\"process\":1,\"status\":0},\"1522\":{\"id\":1522,\"process\":1043,\"status\":0},\"1011\":{\"id\":1011,\"process\":1,\"status\":0},\"1523\":{\"id\":1523,\"process\":1043,\"status\":0},\"1012\":{\"id\":1012,\"process\":1,\"status\":0},\"1524\":{\"id\":1524,\"process\":1043,\"status\":0},\"1013\":{\"id\":1013,\"process\":1,\"status\":0},\"1014\":{\"id\":1014,\"process\":1,\"status\":0},\"1015\":{\"id\":1015,\"process\":1,\"status\":0},\"1016\":{\"id\":1016,\"process\":1,\"status\":0},\"1017\":{\"id\":1017,\"process\":1,\"status\":0},\"1018\":{\"id\":1018,\"process\":1,\"status\":0},\"1019\":{\"id\":1019,\"process\":1,\"status\":0},\"1020\":{\"id\":1020,\"process\":1,\"status\":0},\"1021\":{\"id\":1021,\"process\":1,\"status\":0},\"1022\":{\"id\":1022,\"process\":1,\"status\":0},\"1023\":{\"id\":1023,\"process\":1,\"status\":0}}', '[]', 0);
COMMIT;

-- ----------------------------
-- Table structure for arena_player
-- ----------------------------
DROP TABLE IF EXISTS `arena_player`;
CREATE TABLE `arena_player` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `challenge_num` int(11) DEFAULT '0' COMMENT '已挑战次数',
  `buy_num` int(11) DEFAULT '0' COMMENT '已购买挑战次数',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `auto_refresh_time` bigint(20) DEFAULT '0' COMMENT '自动刷新时间',
  `hand_refresh_time` bigint(20) DEFAULT '0' COMMENT '手动刷新时间',
  `competitors` varchar(5000) DEFAULT '' COMMENT '待挑战者',
  `template_fighter` text COMMENT '将要挑战的对方阵容数据',
  `score` bigint(20) DEFAULT '0' COMMENT '积分',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家竞技场数据表';

-- ----------------------------
-- Records of arena_player
-- ----------------------------
BEGIN;
INSERT INTO `arena_player` (`insert_time`, `update_time`, `pid`, `challenge_num`, `buy_num`, `daily_time`, `auto_refresh_time`, `hand_refresh_time`, `competitors`, `template_fighter`, `score`) VALUES ('2024-11-22 11:02:50', '2024-11-22 11:02:50', 335879897874433, 0, 0, '2024-11-22 11:02:10', 0, 0, '[]', 'null', 0);
INSERT INTO `arena_player` (`insert_time`, `update_time`, `pid`, `challenge_num`, `buy_num`, `daily_time`, `auto_refresh_time`, `hand_refresh_time`, `competitors`, `template_fighter`, `score`) VALUES ('2024-11-22 11:37:15', '2024-11-22 11:37:15', 335879897874434, 0, 0, '2024-11-23 05:00:00', 0, 0, '[]', 'null', 0);
COMMIT;

-- ----------------------------
-- Table structure for arena_record
-- ----------------------------
DROP TABLE IF EXISTS `arena_record`;
CREATE TABLE `arena_record` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `other_pid` bigint(20) DEFAULT '0' COMMENT '对方玩家ID',
  `other_nick` varchar(255) DEFAULT '' COMMENT '昵称',
  `head` varchar(255) DEFAULT '' COMMENT '头像',
  `battle_time` bigint(20) DEFAULT '0' COMMENT '战斗时间戳，毫秒',
  `result` int(11) DEFAULT '0' COMMENT '1胜利，2失败',
  `score` int(11) DEFAULT '0' COMMENT '积分增减',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='英雄信息表';

-- ----------------------------
-- Records of arena_record
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for bag
-- ----------------------------
DROP TABLE IF EXISTS `bag`;
CREATE TABLE `bag` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `id_grid_map` text COMMENT '道具数据 K:道具id v:格子信息',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家背包表';

-- ----------------------------
-- Records of bag
-- ----------------------------
BEGIN;
INSERT INTO `bag` (`insert_time`, `update_time`, `pid`, `id_grid_map`) VALUES ('2024-11-22 11:03:03', '2024-11-22 11:03:03', 335879897874433, '{}');
INSERT INTO `bag` (`insert_time`, `update_time`, `pid`, `id_grid_map`) VALUES ('2024-11-22 11:37:54', '2024-11-22 11:37:54', 335879897874434, '{}');
COMMIT;

-- ----------------------------
-- Table structure for chat_world
-- ----------------------------
DROP TABLE IF EXISTS `chat_world`;
CREATE TABLE `chat_world` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '消息ID',
  `speaker_id` bigint(20) DEFAULT '0' COMMENT '说话者ID',
  `speaker_nick` varchar(255) DEFAULT '' COMMENT '说话者昵称',
  `head` varchar(255) DEFAULT '' COMMENT '头像',
  `sex` int(11) DEFAULT '0' COMMENT '性别',
  `content` varchar(255) DEFAULT '' COMMENT '聊天内容',
  `ori_content` varchar(255) DEFAULT '' COMMENT '聊天原始内容',
  `doubt` char(5) DEFAULT 'false' COMMENT '是否为可疑聊天内容',
  `level` int(11) DEFAULT '0' COMMENT '等级',
  `vip_level` int(11) DEFAULT '0' COMMENT 'vip等级',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='本服聊天表';

-- ----------------------------
-- Records of chat_world
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for daily_task
-- ----------------------------
DROP TABLE IF EXISTS `daily_task`;
CREATE TABLE `daily_task` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `day_points` bigint(20) DEFAULT '0' COMMENT '日常积分',
  `day_point_reward` varchar(255) DEFAULT '' COMMENT '已领日常活跃奖励',
  `daily_tasks` text COMMENT '日常任务列表',
  `daily_time` datetime DEFAULT NULL COMMENT '日重置时间',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='日常任务表';

-- ----------------------------
-- Records of daily_task
-- ----------------------------
BEGIN;
INSERT INTO `daily_task` (`insert_time`, `update_time`, `pid`, `day_points`, `day_point_reward`, `daily_tasks`, `daily_time`) VALUES ('2024-11-22 11:02:42', '2024-11-22 11:02:42', 335879897874433, 0, '[]', '[{\"id\":10001,\"process\":1,\"status\":1},{\"id\":10002,\"process\":0,\"status\":0},{\"id\":10003,\"process\":0,\"status\":0},{\"id\":10004,\"process\":0,\"status\":0},{\"id\":10005,\"process\":0,\"status\":0},{\"id\":10006,\"process\":0,\"status\":0},{\"id\":10007,\"process\":0,\"status\":0},{\"id\":10008,\"process\":0,\"status\":0},{\"id\":10009,\"process\":0,\"status\":0},{\"id\":10010,\"process\":0,\"status\":0},{\"id\":10011,\"process\":0,\"status\":0},{\"id\":10012,\"process\":0,\"status\":0},{\"id\":10013,\"process\":0,\"status\":0}]', '2024-11-23 05:00:00');
INSERT INTO `daily_task` (`insert_time`, `update_time`, `pid`, `day_points`, `day_point_reward`, `daily_tasks`, `daily_time`) VALUES ('2024-11-22 11:37:58', '2024-11-22 11:49:59', 335879897874434, 0, '[]', '[{\"id\":10001,\"process\":1,\"status\":1},{\"id\":10002,\"process\":0,\"status\":0},{\"id\":10003,\"process\":0,\"status\":0},{\"id\":10004,\"process\":0,\"status\":0},{\"id\":10005,\"process\":0,\"status\":0},{\"id\":10006,\"process\":63,\"status\":0},{\"id\":10007,\"process\":0,\"status\":0},{\"id\":10008,\"process\":0,\"status\":0},{\"id\":10009,\"process\":0,\"status\":0},{\"id\":10010,\"process\":0,\"status\":0},{\"id\":10011,\"process\":50,\"status\":1},{\"id\":10012,\"process\":0,\"status\":0},{\"id\":10013,\"process\":0,\"status\":0}]', '2024-11-23 05:00:00');
COMMIT;

-- ----------------------------
-- Table structure for day_recharge
-- ----------------------------
DROP TABLE IF EXISTS `day_recharge`;
CREATE TABLE `day_recharge` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `buy_all` char(5) DEFAULT 'false' COMMENT '一键购买',
  `free_reward` char(5) DEFAULT 'false' COMMENT '是否已领取免费好礼',
  `day_recharge` varchar(255) DEFAULT '' COMMENT '散买商品列表',
  `daily_time` datetime DEFAULT NULL COMMENT '重置时间',
  `buy_round` int(11) DEFAULT '0' COMMENT '当前可购轮次',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='每日首充表';

-- ----------------------------
-- Records of day_recharge
-- ----------------------------
BEGIN;
INSERT INTO `day_recharge` (`insert_time`, `update_time`, `pid`, `buy_all`, `free_reward`, `day_recharge`, `daily_time`, `buy_round`) VALUES ('2024-11-22 11:02:43', '2024-11-22 11:02:43', 335879897874433, 'false', 'false', '[]', '2024-11-22 11:02:10', 0);
INSERT INTO `day_recharge` (`insert_time`, `update_time`, `pid`, `buy_all`, `free_reward`, `day_recharge`, `daily_time`, `buy_round`) VALUES ('2024-11-22 11:37:19', '2024-11-22 11:37:19', 335879897874434, 'false', 'false', '[]', '2024-11-23 05:00:00', 1);
COMMIT;

-- ----------------------------
-- Table structure for dungeon
-- ----------------------------
DROP TABLE IF EXISTS `dungeon`;
CREATE TABLE `dungeon` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `normal_dungeons` varchar(255) DEFAULT '' COMMENT '日常副本通已关ID',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='地下城表';

-- ----------------------------
-- Records of dungeon
-- ----------------------------
BEGIN;
INSERT INTO `dungeon` (`insert_time`, `update_time`, `pid`, `normal_dungeons`, `daily_time`) VALUES ('2024-11-22 11:03:02', '2024-11-22 11:03:02', 335879897874433, '[]', '2024-11-22 11:02:10');
INSERT INTO `dungeon` (`insert_time`, `update_time`, `pid`, `normal_dungeons`, `daily_time`) VALUES ('2024-11-22 11:37:14', '2024-11-22 11:37:14', 335879897874434, '[]', '2024-11-23 05:00:00');
COMMIT;

-- ----------------------------
-- Table structure for equip
-- ----------------------------
DROP TABLE IF EXISTS `equip`;
CREATE TABLE `equip` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `identity` int(11) DEFAULT '0' COMMENT '装备ID',
  `name` varchar(255) DEFAULT '' COMMENT '装备名称',
  `wear` char(5) DEFAULT 'false' COMMENT '是否穿戴',
  `lock` char(5) DEFAULT 'false' COMMENT '是否锁定',
  `appraise` char(5) DEFAULT 'false' COMMENT '是否已鉴定',
  `score` bigint(20) DEFAULT '0' COMMENT '评分',
  `sub_attrs` varchar(300) DEFAULT '' COMMENT '附加属性',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='装备表';

-- ----------------------------
-- Records of equip
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for equip_wear
-- ----------------------------
DROP TABLE IF EXISTS `equip_wear`;
CREATE TABLE `equip_wear` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `wearing` varchar(500) DEFAULT '' COMMENT '穿戴列表（部位：装备唯一ID）',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='装备穿戴表';

-- ----------------------------
-- Records of equip_wear
-- ----------------------------
BEGIN;
INSERT INTO `equip_wear` (`insert_time`, `update_time`, `pid`, `wearing`) VALUES ('2024-11-22 11:02:12', '2024-11-22 11:02:12', 335879897874433, '{}');
INSERT INTO `equip_wear` (`insert_time`, `update_time`, `pid`, `wearing`) VALUES ('2024-11-22 11:38:01', '2024-11-22 11:38:01', 335879897874434, '{}');
COMMIT;

-- ----------------------------
-- Table structure for evil
-- ----------------------------
DROP TABLE IF EXISTS `evil`;
CREATE TABLE `evil` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家id',
  `identity` int(11) DEFAULT '0' COMMENT '妖ID',
  `level` int(11) DEFAULT '0' COMMENT '阶',
  `fragment` bigint(20) DEFAULT '0' COMMENT '碎片数量',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='妖录表';

-- ----------------------------
-- Records of evil
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for evil_furnace
-- ----------------------------
DROP TABLE IF EXISTS `evil_furnace`;
CREATE TABLE `evil_furnace` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `speed_up_time` bigint(20) DEFAULT '0' COMMENT '加速时间/分',
  `refine_detail` varchar(1000) DEFAULT '' COMMENT '炼妖详情',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='炼妖炉';

-- ----------------------------
-- Records of evil_furnace
-- ----------------------------
BEGIN;
INSERT INTO `evil_furnace` (`insert_time`, `update_time`, `pid`, `speed_up_time`, `refine_detail`) VALUES ('2024-11-22 11:02:42', '2024-11-22 11:02:42', 335879897874433, 0, '[]');
INSERT INTO `evil_furnace` (`insert_time`, `update_time`, `pid`, `speed_up_time`, `refine_detail`) VALUES ('2024-11-22 11:37:19', '2024-11-22 11:37:19', 335879897874434, 0, '[]');
COMMIT;

-- ----------------------------
-- Table structure for first_recharge
-- ----------------------------
DROP TABLE IF EXISTS `first_recharge`;
CREATE TABLE `first_recharge` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `recharge_datas` varchar(5000) DEFAULT '' COMMENT '首充数据',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='首充表';

-- ----------------------------
-- Records of first_recharge
-- ----------------------------
BEGIN;
INSERT INTO `first_recharge` (`insert_time`, `update_time`, `pid`, `daily_time`, `recharge_datas`) VALUES ('2024-11-22 11:02:43', '2024-11-22 11:02:43', 335879897874433, '2024-11-22 11:02:10', '{}');
INSERT INTO `first_recharge` (`insert_time`, `update_time`, `pid`, `daily_time`, `recharge_datas`) VALUES ('2024-11-22 11:38:03', '2024-11-22 11:38:03', 335879897874434, '2024-11-23 05:00:00', '{}');
COMMIT;

-- ----------------------------
-- Table structure for forbid_list
-- ----------------------------
DROP TABLE IF EXISTS `forbid_list`;
CREATE TABLE `forbid_list` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL COMMENT '唯一ID',
  `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `openid` (`open_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='封禁账号表';

-- ----------------------------
-- Records of forbid_list
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for formation
-- ----------------------------
DROP TABLE IF EXISTS `formation`;
CREATE TABLE `formation` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `type` int(11) DEFAULT '0' COMMENT '战斗类型',
  `main_hero_identity` int(11) DEFAULT '0' COMMENT '主英雄ID',
  `positions` varchar(500) DEFAULT '' COMMENT '布阵英雄（英雄标识-位置）',
  `fighting` bigint(20) DEFAULT '0' COMMENT '战斗力',
  `equip_fighting` bigint(20) DEFAULT '0' COMMENT '装备提供的战斗力',
  `manual_change` char(5) DEFAULT 'false' COMMENT '是否玩家修改过',
  `max_fighting` bigint(20) DEFAULT '0' COMMENT '历史最高战斗力',
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid_type` (`pid`,`type`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000023 DEFAULT CHARSET=utf8mb4 COMMENT='上阵信息表';

-- ----------------------------
-- Records of formation
-- ----------------------------
BEGIN;
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000001, 335879897874433, 1, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000002, 335879897874433, 2, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000003, 335879897874433, 3, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000004, 335879897874433, 4, 0, '{}', 0, 0, 'false', 0);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000005, 335879897874433, 5, 0, '{}', 0, 0, 'false', 0);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000006, 335879897874433, 6, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000007, 335879897874433, 7, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000008, 335879897874433, 8, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000009, 335879897874433, 9, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000010, 335879897874433, 10, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000011, 335879897874433, 11, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:38:12', 100000012, 335879897874434, 1, 1020001, '{\"1010005\":{\"identity\":1010005,\"pos\":2},\"1020001\":{\"identity\":1020001,\"pos\":1}}', 1043, 0, 'true', 1043);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000013, 335879897874434, 2, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000014, 335879897874434, 3, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000015, 335879897874434, 4, 0, '{}', 0, 0, 'false', 0);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000016, 335879897874434, 5, 0, '{}', 0, 0, 'false', 0);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000017, 335879897874434, 6, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000018, 335879897874434, 7, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000019, 335879897874434, 8, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000020, 335879897874434, 9, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000021, 335879897874434, 10, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
INSERT INTO `formation` (`insert_time`, `update_time`, `id`, `pid`, `type`, `main_hero_identity`, `positions`, `fighting`, `equip_fighting`, `manual_change`, `max_fighting`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000022, 335879897874434, 11, 1020001, '{\"1020001\":{\"identity\":1020001,\"pos\":1}}', 540, 0, 'false', 540);
COMMIT;

-- ----------------------------
-- Table structure for golden_pig
-- ----------------------------
DROP TABLE IF EXISTS `golden_pig`;
CREATE TABLE `golden_pig` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `max_stage` int(11) DEFAULT '0' COMMENT '已经通关的层级',
  `challenge_num` int(11) DEFAULT '0' COMMENT '今天已挑战次数',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `init_ticket` char(5) DEFAULT 'false' COMMENT '是否已获取初始化的门票',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家黄金猪表';

-- ----------------------------
-- Records of golden_pig
-- ----------------------------
BEGIN;
INSERT INTO `golden_pig` (`insert_time`, `update_time`, `pid`, `max_stage`, `challenge_num`, `daily_time`, `init_ticket`) VALUES ('2024-11-22 11:03:02', '2024-11-22 11:03:02', 335879897874433, 0, 0, '2024-11-22 11:02:10', 'false');
INSERT INTO `golden_pig` (`insert_time`, `update_time`, `pid`, `max_stage`, `challenge_num`, `daily_time`, `init_ticket`) VALUES ('2024-11-22 11:37:11', '2024-11-22 11:37:11', 335879897874434, 0, 0, '2024-11-23 05:00:00', 'false');
COMMIT;

-- ----------------------------
-- Table structure for hand_book
-- ----------------------------
DROP TABLE IF EXISTS `hand_book`;
CREATE TABLE `hand_book` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `identity` int(11) DEFAULT '0' COMMENT '图鉴标识（图鉴类型），总览的积分记录在类型0的数据中',
  `name` varchar(255) DEFAULT '' COMMENT '图鉴名称',
  `point` int(11) DEFAULT '0' COMMENT '进度积分',
  `book_details` text COMMENT '图鉴详情，记录等级',
  `reward_lv` int(11) DEFAULT '0' COMMENT '已经领取到的进度奖励等级',
  `suits` varchar(255) DEFAULT '' COMMENT '已经激活的套装',
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid_identity` (`pid`,`identity`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000007 DEFAULT CHARSET=utf8mb4 COMMENT='图鉴表';

-- ----------------------------
-- Records of hand_book
-- ----------------------------
BEGIN;
INSERT INTO `hand_book` (`insert_time`, `update_time`, `id`, `pid`, `identity`, `name`, `point`, `book_details`, `reward_lv`, `suits`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000001, 335879897874433, 0, '总览，不要删了', 0, '{}', 0, '[]');
INSERT INTO `hand_book` (`insert_time`, `update_time`, `id`, `pid`, `identity`, `name`, `point`, `book_details`, `reward_lv`, `suits`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000002, 335879897874433, 1, '人族', 0, '{}', 0, '[]');
INSERT INTO `hand_book` (`insert_time`, `update_time`, `id`, `pid`, `identity`, `name`, `point`, `book_details`, `reward_lv`, `suits`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000003, 335879897874433, 2, '人界', 0, '{}', 0, '[]');
INSERT INTO `hand_book` (`insert_time`, `update_time`, `id`, `pid`, `identity`, `name`, `point`, `book_details`, `reward_lv`, `suits`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000004, 335879897874434, 0, '总览，不要删了', 0, '{}', 0, '[]');
INSERT INTO `hand_book` (`insert_time`, `update_time`, `id`, `pid`, `identity`, `name`, `point`, `book_details`, `reward_lv`, `suits`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000005, 335879897874434, 1, '人族', 0, '{}', 0, '[]');
INSERT INTO `hand_book` (`insert_time`, `update_time`, `id`, `pid`, `identity`, `name`, `point`, `book_details`, `reward_lv`, `suits`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000006, 335879897874434, 2, '人界', 0, '{}', 0, '[]');
COMMIT;

-- ----------------------------
-- Table structure for hero
-- ----------------------------
DROP TABLE IF EXISTS `hero`;
CREATE TABLE `hero` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `identity` int(11) DEFAULT '0' COMMENT '英雄标识',
  `name` varchar(255) DEFAULT '' COMMENT '英雄名称',
  `level` int(11) DEFAULT '0' COMMENT '英雄等级',
  `awaken_level` int(11) DEFAULT '0' COMMENT '觉醒等级',
  `fragment` bigint(20) DEFAULT '0' COMMENT '碎片数量',
  `his_fragment` bigint(20) DEFAULT '0' COMMENT '历史获得碎片数量',
  `fighting` bigint(20) DEFAULT '0' COMMENT '战斗力',
  `equip_fighting` bigint(20) DEFAULT '0' COMMENT '装备提供的战力',
  `relic_fighting` bigint(20) DEFAULT '0' COMMENT '遗物提供的战力',
  `panel_attr` varchar(3000) DEFAULT '' COMMENT '面板属性',
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid_identity` (`pid`,`identity`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000004 DEFAULT CHARSET=utf8mb4 COMMENT='英雄信息表';

-- ----------------------------
-- Records of hero
-- ----------------------------
BEGIN;
INSERT INTO `hero` (`insert_time`, `update_time`, `id`, `pid`, `identity`, `name`, `level`, `awaken_level`, `fragment`, `his_fragment`, `fighting`, `equip_fighting`, `relic_fighting`, `panel_attr`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000001, 335879897874433, 1020001, '李大侠', 1, 0, 1, 1, 540, 0, 0, '{\"hp\":0,\"maxHp\":400,\"atk\":35,\"def\":0,\"hpRate\":0,\"atkRate\":0,\"defRate\":0,\"dmgRate\":0,\"hit\":10000,\"dodge\":800,\"crit\":800,\"critDmgRate\":15000,\"vampireRate\":0,\"reduceDmg\":0,\"reduceDmgRate\":0,\"cdSpdRate\":0,\"moveSpd\":300,\"moveSpdRate\":0,\"atkSpd\":0,\"atkSpdRate\":0,\"dmgbl\":0,\"dmg\":0,\"llmaxRate\":0,\"lldmgRate\":0,\"mjmaxRate\":0,\"mjdmgRate\":0,\"zlmaxRate\":0,\"zldmgRate\":0,\"woodDmg\":1,\"mineDmg\":1,\"llmax\":0,\"lldmg\":0,\"mjmax\":0,\"mjdmg\":0,\"zlmax\":0,\"zldmg\":0,\"battleRange\":230,\"llpvedmg\":0,\"mjpvedmg\":0,\"zlpvedmg\":0,\"pvedmg\":0,\"fovRange\":500,\"reducecrit\":0,\"hpBrate\":0,\"atkBrate\":0}');
INSERT INTO `hero` (`insert_time`, `update_time`, `id`, `pid`, `identity`, `name`, `level`, `awaken_level`, `fragment`, `his_fragment`, `fighting`, `equip_fighting`, `relic_fighting`, `panel_attr`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:06', 100000002, 335879897874434, 1020001, '李大侠', 1, 0, 1, 1, 540, 0, 0, '{\"hp\":0,\"maxHp\":400,\"atk\":35,\"def\":0,\"hpRate\":0,\"atkRate\":0,\"defRate\":0,\"dmgRate\":0,\"hit\":10000,\"dodge\":800,\"crit\":800,\"critDmgRate\":15000,\"vampireRate\":0,\"reduceDmg\":0,\"reduceDmgRate\":0,\"cdSpdRate\":0,\"moveSpd\":300,\"moveSpdRate\":0,\"atkSpd\":0,\"atkSpdRate\":0,\"dmgbl\":0,\"dmg\":0,\"llmaxRate\":0,\"lldmgRate\":0,\"mjmaxRate\":0,\"mjdmgRate\":0,\"zlmaxRate\":0,\"zldmgRate\":0,\"woodDmg\":1,\"mineDmg\":1,\"llmax\":0,\"lldmg\":0,\"mjmax\":0,\"mjdmg\":0,\"zlmax\":0,\"zldmg\":0,\"battleRange\":230,\"llpvedmg\":0,\"mjpvedmg\":0,\"zlpvedmg\":0,\"pvedmg\":0,\"fovRange\":500,\"reducecrit\":0,\"hpBrate\":0,\"atkBrate\":0}');
INSERT INTO `hero` (`insert_time`, `update_time`, `id`, `pid`, `identity`, `name`, `level`, `awaken_level`, `fragment`, `his_fragment`, `fighting`, `equip_fighting`, `relic_fighting`, `panel_attr`) VALUES ('2024-11-22 11:37:54', '2024-11-22 11:37:54', 100000003, 335879897874434, 1010005, '明月新', 1, 0, 1, 1, 503, 0, 0, '{\"hp\":0,\"maxHp\":375,\"atk\":32,\"def\":0,\"hpRate\":0,\"atkRate\":0,\"defRate\":0,\"dmgRate\":0,\"hit\":10000,\"dodge\":800,\"crit\":800,\"critDmgRate\":15000,\"vampireRate\":0,\"reduceDmg\":0,\"reduceDmgRate\":0,\"cdSpdRate\":0,\"moveSpd\":300,\"moveSpdRate\":0,\"atkSpd\":0,\"atkSpdRate\":0,\"dmgbl\":0,\"dmg\":0,\"llmaxRate\":0,\"lldmgRate\":0,\"mjmaxRate\":0,\"mjdmgRate\":0,\"zlmaxRate\":0,\"zldmgRate\":0,\"woodDmg\":1,\"mineDmg\":1,\"llmax\":0,\"lldmg\":0,\"mjmax\":0,\"mjdmg\":0,\"zlmax\":0,\"zldmg\":0,\"battleRange\":230,\"llpvedmg\":0,\"mjpvedmg\":0,\"zlpvedmg\":0,\"pvedmg\":0,\"fovRange\":500,\"reducecrit\":0,\"hpBrate\":0,\"atkBrate\":0}');
COMMIT;

-- ----------------------------
-- Table structure for hero_troop
-- ----------------------------
DROP TABLE IF EXISTS `hero_troop`;
CREATE TABLE `hero_troop` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `troop_attr` varchar(2500) DEFAULT '' COMMENT '团队面板属性',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家英雄团队数据表';

-- ----------------------------
-- Records of hero_troop
-- ----------------------------
BEGIN;
INSERT INTO `hero_troop` (`insert_time`, `update_time`, `pid`, `troop_attr`) VALUES ('2024-11-22 11:03:02', '2024-11-22 11:03:02', 335879897874433, '{\"hp\":0,\"maxHp\":0,\"atk\":0,\"def\":0,\"hpRate\":0,\"atkRate\":0,\"defRate\":0,\"dmgRate\":0,\"hit\":0,\"dodge\":0,\"crit\":0,\"critDmgRate\":0,\"vampireRate\":0,\"reduceDmg\":0,\"reduceDmgRate\":0,\"cdSpdRate\":0,\"moveSpd\":0,\"moveSpdRate\":0,\"atkSpd\":0,\"atkSpdRate\":0,\"dmgbl\":0,\"dmg\":0,\"llmaxRate\":0,\"lldmgRate\":0,\"mjmaxRate\":0,\"mjdmgRate\":0,\"zlmaxRate\":0,\"zldmgRate\":0,\"woodDmg\":0,\"mineDmg\":0,\"llmax\":0,\"lldmg\":0,\"mjmax\":0,\"mjdmg\":0,\"zlmax\":0,\"zldmg\":0,\"battleRange\":0,\"llpvedmg\":0,\"mjpvedmg\":0,\"zlpvedmg\":0,\"pvedmg\":0,\"fovRange\":0,\"reducecrit\":0,\"hpBrate\":0,\"atkBrate\":0}');
INSERT INTO `hero_troop` (`insert_time`, `update_time`, `pid`, `troop_attr`) VALUES ('2024-11-22 11:37:07', '2024-11-22 11:37:07', 335879897874434, '{\"hp\":0,\"maxHp\":0,\"atk\":0,\"def\":0,\"hpRate\":0,\"atkRate\":0,\"defRate\":0,\"dmgRate\":0,\"hit\":0,\"dodge\":0,\"crit\":0,\"critDmgRate\":0,\"vampireRate\":0,\"reduceDmg\":0,\"reduceDmgRate\":0,\"cdSpdRate\":0,\"moveSpd\":0,\"moveSpdRate\":0,\"atkSpd\":0,\"atkSpdRate\":0,\"dmgbl\":0,\"dmg\":0,\"llmaxRate\":0,\"lldmgRate\":0,\"mjmaxRate\":0,\"mjdmgRate\":0,\"zlmaxRate\":0,\"zldmgRate\":0,\"woodDmg\":0,\"mineDmg\":0,\"llmax\":0,\"lldmg\":0,\"mjmax\":0,\"mjdmg\":0,\"zlmax\":0,\"zldmg\":0,\"battleRange\":0,\"llpvedmg\":0,\"mjpvedmg\":0,\"zlpvedmg\":0,\"pvedmg\":0,\"fovRange\":0,\"reducecrit\":0,\"hpBrate\":0,\"atkBrate\":0}');
COMMIT;

-- ----------------------------
-- Table structure for home
-- ----------------------------
DROP TABLE IF EXISTS `home`;
CREATE TABLE `home` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `store_lv` int(11) DEFAULT '0' COMMENT '仓库等级，从0开始',
  `meat` bigint(20) DEFAULT '0' COMMENT '肉',
  `wood` bigint(20) DEFAULT '0' COMMENT '木',
  `mine` bigint(20) DEFAULT '0' COMMENT '矿',
  `producers` varchar(300) DEFAULT '' COMMENT '资源产出池（产出池类型，数据）',
  `building_opening` text COMMENT '建筑激活交付数据',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家场景数据表';

-- ----------------------------
-- Records of home
-- ----------------------------
BEGIN;
INSERT INTO `home` (`insert_time`, `update_time`, `pid`, `store_lv`, `meat`, `wood`, `mine`, `producers`, `building_opening`) VALUES ('2024-11-22 11:02:53', '2024-11-22 11:02:53', 335879897874433, 0, 0, 0, 0, '{}', '{}');
INSERT INTO `home` (`insert_time`, `update_time`, `pid`, `store_lv`, `meat`, `wood`, `mine`, `producers`, `building_opening`) VALUES ('2024-11-22 11:38:00', '2024-11-22 11:50:01', 335879897874434, 0, 60, 0, 0, '{}', '{}');
COMMIT;

-- ----------------------------
-- Table structure for login_sign
-- ----------------------------
DROP TABLE IF EXISTS `login_sign`;
CREATE TABLE `login_sign` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `login_day` int(11) DEFAULT '0' COMMENT '已经领取完的登录奖励天数',
  `sign_day` int(11) DEFAULT '0' COMMENT '已经领取完的登录奖励天数',
  `take_sign_reward` char(5) DEFAULT 'false' COMMENT '是否可以领取登录奖励',
  `take_login_reward` char(5) DEFAULT 'false' COMMENT '是否可以领取登录奖励',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家登录和签到表';

-- ----------------------------
-- Records of login_sign
-- ----------------------------
BEGIN;
INSERT INTO `login_sign` (`insert_time`, `update_time`, `pid`, `login_day`, `sign_day`, `take_sign_reward`, `take_login_reward`, `daily_time`) VALUES ('2024-11-22 11:03:03', '2024-11-22 11:03:03', 335879897874433, 0, 0, 'false', 'false', '2024-11-22 11:02:10');
INSERT INTO `login_sign` (`insert_time`, `update_time`, `pid`, `login_day`, `sign_day`, `take_sign_reward`, `take_login_reward`, `daily_time`) VALUES ('2024-11-22 11:37:53', '2024-11-22 11:37:53', 335879897874434, 0, 0, 'false', 'false', '2024-11-23 05:00:00');
COMMIT;

-- ----------------------------
-- Table structure for mail
-- ----------------------------
DROP TABLE IF EXISTS `mail`;
CREATE TABLE `mail` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '邮件自增ID',
  `receiver` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `template` int(11) DEFAULT '0' COMMENT '邮件模板ID',
  `title_args` varchar(500) DEFAULT '' COMMENT '标题参数',
  `content_args` varchar(5000) DEFAULT '' COMMENT '内容参数',
  `attachment` text COMMENT '附件',
  `read` char(5) DEFAULT 'false' COMMENT '是否已读',
  `receive` char(5) DEFAULT 'false' COMMENT '是否已领',
  `expire_time` datetime DEFAULT NULL COMMENT '到期时间',
  `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  `from_pool_id` bigint(20) DEFAULT '0' COMMENT '来自哪个系统邮件',
  PRIMARY KEY (`id`),
  KEY `receiver` (`receiver`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000002 DEFAULT CHARSET=utf8mb4 COMMENT='邮件表';

-- ----------------------------
-- Records of mail
-- ----------------------------
BEGIN;
INSERT INTO `mail` (`insert_time`, `update_time`, `id`, `receiver`, `template`, `title_args`, `content_args`, `attachment`, `read`, `receive`, `expire_time`, `game_cause`, `game_cause_text`, `from_pool_id`) VALUES ('2025-02-27 09:47:25', '2025-02-27 09:47:25', 100000001, 335879897874434, 2100801, '[]', '[\"1\"]', '[{\"item\":1040006,\"num\":300},{\"item\":1,\"num\":5000},{\"item\":5,\"num\":5000}]', 'false', 'false', '2027-11-23 09:47:25', 2100801, '伙伴战力榜排名奖励', 0);
COMMIT;

-- ----------------------------
-- Table structure for mail_player
-- ----------------------------
DROP TABLE IF EXISTS `mail_player`;
CREATE TABLE `mail_player` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `read_time` datetime DEFAULT NULL COMMENT '最后读取系统邮件的时间',
  `last_read_time` int(11) DEFAULT '0' COMMENT '最后读取系统邮件的时间',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家邮件表';

-- ----------------------------
-- Records of mail_player
-- ----------------------------
BEGIN;
INSERT INTO `mail_player` (`insert_time`, `update_time`, `pid`, `read_time`, `last_read_time`) VALUES ('2024-11-22 11:03:02', '2024-11-22 11:03:02', 335879897874433, '2024-11-22 11:02:10', 0);
INSERT INTO `mail_player` (`insert_time`, `update_time`, `pid`, `read_time`, `last_read_time`) VALUES ('2024-11-22 11:37:08', '2024-11-22 11:38:08', 335879897874434, '2024-11-22 11:37:06', 1732246625);
COMMIT;

-- ----------------------------
-- Table structure for mail_system
-- ----------------------------
DROP TABLE IF EXISTS `mail_system`;
CREATE TABLE `mail_system` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '邮件自增ID',
  `template` int(11) DEFAULT '0' COMMENT '邮件模板ID',
  `belong` varchar(255) DEFAULT '' COMMENT '邮件类型 1全服邮件 2特定玩家邮件',
  `receivers` text COMMENT '收到邮件的玩家们ID',
  `server_ids` varchar(1000) DEFAULT '' COMMENT '对哪些服务器的玩家开放',
  `title_args` varchar(2500) DEFAULT '' COMMENT '标题参数',
  `content_args` varchar(2500) DEFAULT '' COMMENT '内容参数',
  `attachment` varchar(2500) DEFAULT '' COMMENT '附件',
  `expire_time` datetime DEFAULT NULL COMMENT '到期时间',
  `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  `from_id` bigint(20) DEFAULT '0' COMMENT '后台邮件ID',
  `level` int(11) DEFAULT '0' COMMENT '系统邮件能接受的玩家等级限制',
  `post_time` int(11) DEFAULT '0' COMMENT '发送时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='系统邮件表';

-- ----------------------------
-- Records of mail_system
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mail_system_result
-- ----------------------------
DROP TABLE IF EXISTS `mail_system_result`;
CREATE TABLE `mail_system_result` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL COMMENT '后台邮件ID',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='系统邮件记录表';

-- ----------------------------
-- Records of mail_system_result
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for mainline_player
-- ----------------------------
DROP TABLE IF EXISTS `mainline_player`;
CREATE TABLE `mainline_player` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `curr_battle_type` int(11) DEFAULT '0' COMMENT '玩家当前的任务类型',
  `curr_scene` int(11) DEFAULT '0' COMMENT '玩家当前所在的场景',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `start_camp_time` bigint(20) DEFAULT '0' COMMENT '开始露营的时间，单位毫秒',
  `camping` char(5) DEFAULT 'false' COMMENT '是否正在露营',
  `camp_time` bigint(20) DEFAULT '0' COMMENT '已露营时间，单位毫秒',
  `camp_adv_end_time` bigint(20) DEFAULT '0' COMMENT '高级露营结束时间，单位毫秒',
  `camp_adv_num` int(11) DEFAULT '0' COMMENT '已进行高级露营次数',
  `camp_produces` varchar(5000) DEFAULT '' COMMENT '露营累计产出，仅用于展示',
  `revive_num` int(11) DEFAULT '0' COMMENT '可复活次数',
  `kill_num` int(11) DEFAULT '0' COMMENT '主线杀怪数量',
  `all_dead_num` int(11) DEFAULT '0' COMMENT '主线野外全死次数',
  `treasure_num` int(11) DEFAULT '0' COMMENT '拾取的宝箱数量',
  `boss_treasure` varchar(1000) DEFAULT '' COMMENT 'BOSS宝箱',
  `map_treasure` varchar(1000) DEFAULT '' COMMENT '是否有地图宝箱',
  `next_box_time` datetime DEFAULT NULL COMMENT '下一次出现时间宝箱的时间',
  `hang_opened` char(5) DEFAULT 'false' COMMENT '离线挂机功能是否已经开启',
  `hang_start_time` bigint(20) DEFAULT '0' COMMENT '离线挂机开始时间',
  `hang_boss_id` int(11) DEFAULT '0' COMMENT '离线挂机BossID',
  `has_hang_reward` char(5) DEFAULT 'false' COMMENT '是否有离线挂机奖励',
  `task` varchar(255) DEFAULT '' COMMENT '当前场景下的任务数据',
  `parallel_tasks` text COMMENT '并行任务数据',
  `finish_tasks` text COMMENT '已经完成的任务',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家场景数据表';

-- ----------------------------
-- Records of mainline_player
-- ----------------------------
BEGIN;
INSERT INTO `mainline_player` (`insert_time`, `update_time`, `pid`, `curr_battle_type`, `curr_scene`, `daily_time`, `start_camp_time`, `camping`, `camp_time`, `camp_adv_end_time`, `camp_adv_num`, `camp_produces`, `revive_num`, `kill_num`, `all_dead_num`, `treasure_num`, `boss_treasure`, `map_treasure`, `next_box_time`, `hang_opened`, `hang_start_time`, `hang_boss_id`, `has_hang_reward`, `task`, `parallel_tasks`, `finish_tasks`) VALUES ('2024-11-22 11:02:58', '2024-11-22 11:02:58', 335879897874433, 0, 1000, '2024-11-23 05:00:00', 0, 'false', 0, 0, 0, '{}', 0, 0, 0, 0, '{\"boxType\":0,\"disappearTime\":0,\"boxArg\":0}', '{\"boxType\":0,\"disappearTime\":0,\"boxArg\":0}', '2024-11-22 11:03:41', 'false', 0, 0, 'false', '{\"id\":10001,\"process\":0,\"status\":0}', '{\"10002\":{\"id\":10002,\"process\":0,\"status\":0},\"10003\":{\"id\":10003,\"process\":0,\"status\":0},\"10004\":{\"id\":10004,\"process\":0,\"status\":0},\"10005\":{\"id\":10005,\"process\":0,\"status\":0},\"10006\":{\"id\":10006,\"process\":0,\"status\":0},\"10007\":{\"id\":10007,\"process\":0,\"status\":0},\"10009\":{\"id\":10009,\"process\":0,\"status\":0},\"10010\":{\"id\":10010,\"process\":0,\"status\":0},\"10011\":{\"id\":10011,\"process\":0,\"status\":0},\"10012\":{\"id\":10012,\"process\":0,\"status\":0},\"10013\":{\"id\":10013,\"process\":0,\"status\":0},\"10014\":{\"id\":10014,\"process\":0,\"status\":0},\"10015\":{\"id\":10015,\"process\":0,\"status\":0},\"10016\":{\"id\":10016,\"process\":0,\"status\":0},\"10017\":{\"id\":10017,\"process\":0,\"status\":0},\"10018\":{\"id\":10018,\"process\":0,\"status\":0},\"10019\":{\"id\":10019,\"process\":0,\"status\":0},\"10020\":{\"id\":10020,\"process\":0,\"status\":0},\"10021\":{\"id\":10021,\"process\":0,\"status\":0},\"10022\":{\"id\":10022,\"process\":0,\"status\":0},\"10023\":{\"id\":10023,\"process\":0,\"status\":0},\"10024\":{\"id\":10024,\"process\":0,\"status\":0},\"10025\":{\"id\":10025,\"process\":0,\"status\":0},\"10026\":{\"id\":10026,\"process\":0,\"status\":0},\"10027\":{\"id\":10027,\"process\":0,\"status\":0},\"10028\":{\"id\":10028,\"process\":0,\"status\":0},\"10029\":{\"id\":10029,\"process\":0,\"status\":0},\"10030\":{\"id\":10030,\"process\":0,\"status\":0},\"10031\":{\"id\":10031,\"process\":0,\"status\":0},\"10032\":{\"id\":10032,\"process\":0,\"status\":0},\"10033\":{\"id\":10033,\"process\":0,\"status\":0},\"10034\":{\"id\":10034,\"process\":0,\"status\":0},\"10035\":{\"id\":10035,\"process\":0,\"status\":0},\"10036\":{\"id\":10036,\"process\":0,\"status\":0},\"10037\":{\"id\":10037,\"process\":0,\"status\":0},\"10038\":{\"id\":10038,\"process\":0,\"status\":0},\"10039\":{\"id\":10039,\"process\":0,\"status\":0},\"10040\":{\"id\":10040,\"process\":0,\"status\":0},\"10041\":{\"id\":10041,\"process\":0,\"status\":0},\"10042\":{\"id\":10042,\"process\":0,\"status\":0},\"10043\":{\"id\":10043,\"process\":0,\"status\":0},\"10044\":{\"id\":10044,\"process\":0,\"status\":0},\"10045\":{\"id\":10045,\"process\":0,\"status\":0},\"10046\":{\"id\":10046,\"process\":0,\"status\":0},\"10047\":{\"id\":10047,\"process\":0,\"status\":0},\"10048\":{\"id\":10048,\"process\":0,\"status\":0},\"10049\":{\"id\":10049,\"process\":0,\"status\":0},\"10050\":{\"id\":10050,\"process\":0,\"status\":0},\"10051\":{\"id\":10051,\"process\":0,\"status\":0},\"10052\":{\"id\":10052,\"process\":0,\"status\":0},\"10053\":{\"id\":10053,\"process\":0,\"status\":0},\"10054\":{\"id\":10054,\"process\":0,\"status\":0},\"10055\":{\"id\":10055,\"process\":0,\"status\":0},\"10056\":{\"id\":10056,\"process\":0,\"status\":0},\"10057\":{\"id\":10057,\"process\":0,\"status\":0},\"10058\":{\"id\":10058,\"process\":0,\"status\":0},\"10059\":{\"id\":10059,\"process\":0,\"status\":0},\"10060\":{\"id\":10060,\"process\":0,\"status\":0},\"10061\":{\"id\":10061,\"process\":0,\"status\":0},\"10062\":{\"id\":10062,\"process\":0,\"status\":0},\"10063\":{\"id\":10063,\"process\":0,\"status\":0},\"10064\":{\"id\":10064,\"process\":0,\"status\":0},\"10065\":{\"id\":10065,\"process\":0,\"status\":0},\"10066\":{\"id\":10066,\"process\":0,\"status\":0},\"10067\":{\"id\":10067,\"process\":0,\"status\":0},\"10068\":{\"id\":10068,\"process\":0,\"status\":0},\"10069\":{\"id\":10069,\"process\":0,\"status\":0},\"10070\":{\"id\":10070,\"process\":0,\"status\":0},\"10071\":{\"id\":10071,\"process\":0,\"status\":0},\"10072\":{\"id\":10072,\"process\":0,\"status\":0},\"10073\":{\"id\":10073,\"process\":0,\"status\":0},\"10074\":{\"id\":10074,\"process\":0,\"status\":0},\"10075\":{\"id\":10075,\"process\":0,\"status\":0},\"10076\":{\"id\":10076,\"process\":0,\"status\":0},\"10077\":{\"id\":10077,\"process\":0,\"status\":0},\"10078\":{\"id\":10078,\"process\":0,\"status\":0},\"10079\":{\"id\":10079,\"process\":0,\"status\":0},\"10080\":{\"id\":10080,\"process\":0,\"status\":0},\"10081\":{\"id\":10081,\"process\":0,\"status\":0},\"10082\":{\"id\":10082,\"process\":0,\"status\":0},\"10083\":{\"id\":10083,\"process\":0,\"status\":0},\"10084\":{\"id\":10084,\"process\":0,\"status\":0},\"10085\":{\"id\":10085,\"process\":0,\"status\":0},\"10086\":{\"id\":10086,\"process\":0,\"status\":0},\"10087\":{\"id\":10087,\"process\":0,\"status\":0},\"10088\":{\"id\":10088,\"process\":0,\"status\":0},\"10089\":{\"id\":10089,\"process\":0,\"status\":0},\"10090\":{\"id\":10090,\"process\":0,\"status\":0},\"10091\":{\"id\":10091,\"process\":0,\"status\":0},\"10092\":{\"id\":10092,\"process\":0,\"status\":0},\"10093\":{\"id\":10093,\"process\":0,\"status\":0},\"10094\":{\"id\":10094,\"process\":0,\"status\":0},\"10095\":{\"id\":10095,\"process\":0,\"status\":0},\"10096\":{\"id\":10096,\"process\":0,\"status\":0},\"10097\":{\"id\":10097,\"process\":0,\"status\":0},\"10098\":{\"id\":10098,\"process\":0,\"status\":0},\"10099\":{\"id\":10099,\"process\":0,\"status\":0},\"10100\":{\"id\":10100,\"process\":0,\"status\":0},\"10101\":{\"id\":10101,\"process\":0,\"status\":0},\"10102\":{\"id\":10102,\"process\":0,\"status\":0},\"10103\":{\"id\":10103,\"process\":0,\"status\":0},\"10104\":{\"id\":10104,\"process\":0,\"status\":0},\"10105\":{\"id\":10105,\"process\":0,\"status\":0},\"10106\":{\"id\":10106,\"process\":0,\"status\":0},\"10107\":{\"id\":10107,\"process\":0,\"status\":0},\"10108\":{\"id\":10108,\"process\":0,\"status\":0},\"10109\":{\"id\":10109,\"process\":0,\"status\":0},\"10110\":{\"id\":10110,\"process\":0,\"status\":0},\"10111\":{\"id\":10111,\"process\":0,\"status\":0},\"10112\":{\"id\":10112,\"process\":0,\"status\":0},\"10113\":{\"id\":10113,\"process\":0,\"status\":0},\"10114\":{\"id\":10114,\"process\":0,\"status\":0},\"10115\":{\"id\":10115,\"process\":0,\"status\":0},\"10116\":{\"id\":10116,\"process\":0,\"status\":0},\"10117\":{\"id\":10117,\"process\":0,\"status\":0},\"10118\":{\"id\":10118,\"process\":0,\"status\":0},\"10119\":{\"id\":10119,\"process\":0,\"status\":0},\"10120\":{\"id\":10120,\"process\":0,\"status\":0},\"10121\":{\"id\":10121,\"process\":0,\"status\":0},\"10122\":{\"id\":10122,\"process\":0,\"status\":0},\"10123\":{\"id\":10123,\"process\":0,\"status\":0},\"10124\":{\"id\":10124,\"process\":0,\"status\":0},\"10125\":{\"id\":10125,\"process\":0,\"status\":0},\"10126\":{\"id\":10126,\"process\":0,\"status\":0},\"10127\":{\"id\":10127,\"process\":0,\"status\":0},\"10128\":{\"id\":10128,\"process\":0,\"status\":0},\"10129\":{\"id\":10129,\"process\":0,\"status\":0},\"10130\":{\"id\":10130,\"process\":0,\"status\":0},\"10131\":{\"id\":10131,\"process\":0,\"status\":0},\"10132\":{\"id\":10132,\"process\":0,\"status\":0},\"10133\":{\"id\":10133,\"process\":0,\"status\":0},\"10134\":{\"id\":10134,\"process\":0,\"status\":0},\"10135\":{\"id\":10135,\"process\":0,\"status\":0},\"10136\":{\"id\":10136,\"process\":0,\"status\":0},\"10137\":{\"id\":10137,\"process\":0,\"status\":0},\"10138\":{\"id\":10138,\"process\":0,\"status\":0},\"10139\":{\"id\":10139,\"process\":0,\"status\":0},\"10140\":{\"id\":10140,\"process\":0,\"status\":0},\"10141\":{\"id\":10141,\"process\":0,\"status\":0},\"10142\":{\"id\":10142,\"process\":0,\"status\":0},\"10143\":{\"id\":10143,\"process\":0,\"status\":0},\"10144\":{\"id\":10144,\"process\":0,\"status\":0},\"10145\":{\"id\":10145,\"process\":0,\"status\":0},\"10146\":{\"id\":10146,\"process\":0,\"status\":0},\"10147\":{\"id\":10147,\"process\":0,\"status\":0},\"10148\":{\"id\":10148,\"process\":0,\"status\":0},\"10149\":{\"id\":10149,\"process\":0,\"status\":0},\"10150\":{\"id\":10150,\"process\":0,\"status\":0},\"10151\":{\"id\":10151,\"process\":0,\"status\":0},\"10152\":{\"id\":10152,\"process\":0,\"status\":0},\"10153\":{\"id\":10153,\"process\":0,\"status\":0},\"10154\":{\"id\":10154,\"process\":0,\"status\":0},\"10155\":{\"id\":10155,\"process\":0,\"status\":0},\"10156\":{\"id\":10156,\"process\":0,\"status\":0},\"10157\":{\"id\":10157,\"process\":0,\"status\":0},\"10158\":{\"id\":10158,\"process\":0,\"status\":0},\"10159\":{\"id\":10159,\"process\":0,\"status\":0},\"10160\":{\"id\":10160,\"process\":0,\"status\":0},\"10161\":{\"id\":10161,\"process\":0,\"status\":0},\"10162\":{\"id\":10162,\"process\":0,\"status\":0},\"10163\":{\"id\":10163,\"process\":0,\"status\":0},\"10164\":{\"id\":10164,\"process\":0,\"status\":0},\"10165\":{\"id\":10165,\"process\":0,\"status\":0},\"10166\":{\"id\":10166,\"process\":0,\"status\":0},\"10167\":{\"id\":10167,\"process\":0,\"status\":0},\"10168\":{\"id\":10168,\"process\":0,\"status\":0},\"10169\":{\"id\":10169,\"process\":0,\"status\":0},\"10170\":{\"id\":10170,\"process\":0,\"status\":0},\"10171\":{\"id\":10171,\"process\":0,\"status\":0},\"10172\":{\"id\":10172,\"process\":0,\"status\":0},\"10173\":{\"id\":10173,\"process\":0,\"status\":0},\"10174\":{\"id\":10174,\"process\":0,\"status\":0},\"10175\":{\"id\":10175,\"process\":0,\"status\":0},\"10176\":{\"id\":10176,\"process\":0,\"status\":0},\"10177\":{\"id\":10177,\"process\":0,\"status\":0},\"10178\":{\"id\":10178,\"process\":0,\"status\":0},\"10179\":{\"id\":10179,\"process\":0,\"status\":0},\"10180\":{\"id\":10180,\"process\":0,\"status\":0},\"10181\":{\"id\":10181,\"process\":0,\"status\":0},\"10182\":{\"id\":10182,\"process\":0,\"status\":0},\"10183\":{\"id\":10183,\"process\":0,\"status\":0},\"10184\":{\"id\":10184,\"process\":0,\"status\":0}}', '[]');
INSERT INTO `mainline_player` (`insert_time`, `update_time`, `pid`, `curr_battle_type`, `curr_scene`, `daily_time`, `start_camp_time`, `camping`, `camp_time`, `camp_adv_end_time`, `camp_adv_num`, `camp_produces`, `revive_num`, `kill_num`, `all_dead_num`, `treasure_num`, `boss_treasure`, `map_treasure`, `next_box_time`, `hang_opened`, `hang_start_time`, `hang_boss_id`, `has_hang_reward`, `task`, `parallel_tasks`, `finish_tasks`) VALUES ('2024-11-22 11:37:20', '2024-11-22 11:50:20', 335879897874434, 1, 1000, '2024-11-23 05:00:00', 0, 'false', 0, 0, 0, '{}', 3, 63, 0, 0, '{\"boxType\":0,\"disappearTime\":0,\"boxArg\":0}', '{\"boxType\":0,\"disappearTime\":0,\"boxArg\":0}', '2024-11-22 11:38:36', 'false', 0, 0, 'false', '{\"id\":10004,\"process\":0,\"status\":0}', '{\"10005\":{\"id\":10005,\"process\":5,\"status\":1},\"10006\":{\"id\":10006,\"process\":0,\"status\":0},\"10007\":{\"id\":10007,\"process\":0,\"status\":0},\"10009\":{\"id\":10009,\"process\":0,\"status\":0},\"10010\":{\"id\":10010,\"process\":0,\"status\":0},\"10011\":{\"id\":10011,\"process\":0,\"status\":0},\"10012\":{\"id\":10012,\"process\":0,\"status\":0},\"10013\":{\"id\":10013,\"process\":0,\"status\":0},\"10014\":{\"id\":10014,\"process\":0,\"status\":0},\"10015\":{\"id\":10015,\"process\":0,\"status\":0},\"10016\":{\"id\":10016,\"process\":0,\"status\":0},\"10017\":{\"id\":10017,\"process\":0,\"status\":0},\"10018\":{\"id\":10018,\"process\":0,\"status\":0},\"10019\":{\"id\":10019,\"process\":0,\"status\":0},\"10020\":{\"id\":10020,\"process\":0,\"status\":0},\"10021\":{\"id\":10021,\"process\":0,\"status\":0},\"10022\":{\"id\":10022,\"process\":0,\"status\":0},\"10023\":{\"id\":10023,\"process\":0,\"status\":0},\"10024\":{\"id\":10024,\"process\":0,\"status\":0},\"10025\":{\"id\":10025,\"process\":0,\"status\":0},\"10026\":{\"id\":10026,\"process\":0,\"status\":0},\"10027\":{\"id\":10027,\"process\":0,\"status\":0},\"10028\":{\"id\":10028,\"process\":0,\"status\":0},\"10029\":{\"id\":10029,\"process\":0,\"status\":0},\"10030\":{\"id\":10030,\"process\":0,\"status\":0},\"10031\":{\"id\":10031,\"process\":0,\"status\":0},\"10032\":{\"id\":10032,\"process\":0,\"status\":0},\"10033\":{\"id\":10033,\"process\":0,\"status\":0},\"10034\":{\"id\":10034,\"process\":0,\"status\":0},\"10035\":{\"id\":10035,\"process\":0,\"status\":0},\"10036\":{\"id\":10036,\"process\":0,\"status\":0},\"10037\":{\"id\":10037,\"process\":0,\"status\":0},\"10038\":{\"id\":10038,\"process\":0,\"status\":0},\"10039\":{\"id\":10039,\"process\":0,\"status\":0},\"10040\":{\"id\":10040,\"process\":0,\"status\":0},\"10041\":{\"id\":10041,\"process\":0,\"status\":0},\"10042\":{\"id\":10042,\"process\":0,\"status\":0},\"10043\":{\"id\":10043,\"process\":0,\"status\":0},\"10044\":{\"id\":10044,\"process\":0,\"status\":0},\"10045\":{\"id\":10045,\"process\":0,\"status\":0},\"10046\":{\"id\":10046,\"process\":0,\"status\":0},\"10047\":{\"id\":10047,\"process\":0,\"status\":0},\"10048\":{\"id\":10048,\"process\":0,\"status\":0},\"10049\":{\"id\":10049,\"process\":0,\"status\":0},\"10050\":{\"id\":10050,\"process\":0,\"status\":0},\"10051\":{\"id\":10051,\"process\":0,\"status\":0},\"10052\":{\"id\":10052,\"process\":0,\"status\":0},\"10053\":{\"id\":10053,\"process\":0,\"status\":0},\"10054\":{\"id\":10054,\"process\":3,\"status\":0},\"10055\":{\"id\":10055,\"process\":0,\"status\":0},\"10056\":{\"id\":10056,\"process\":0,\"status\":0},\"10057\":{\"id\":10057,\"process\":0,\"status\":0},\"10058\":{\"id\":10058,\"process\":0,\"status\":0},\"10059\":{\"id\":10059,\"process\":0,\"status\":0},\"10060\":{\"id\":10060,\"process\":0,\"status\":0},\"10061\":{\"id\":10061,\"process\":0,\"status\":0},\"10062\":{\"id\":10062,\"process\":0,\"status\":0},\"10063\":{\"id\":10063,\"process\":0,\"status\":0},\"10064\":{\"id\":10064,\"process\":0,\"status\":0},\"10065\":{\"id\":10065,\"process\":0,\"status\":0},\"10066\":{\"id\":10066,\"process\":0,\"status\":0},\"10067\":{\"id\":10067,\"process\":0,\"status\":0},\"10068\":{\"id\":10068,\"process\":0,\"status\":0},\"10069\":{\"id\":10069,\"process\":3,\"status\":0},\"10070\":{\"id\":10070,\"process\":0,\"status\":0},\"10071\":{\"id\":10071,\"process\":0,\"status\":0},\"10072\":{\"id\":10072,\"process\":0,\"status\":0},\"10073\":{\"id\":10073,\"process\":0,\"status\":0},\"10074\":{\"id\":10074,\"process\":0,\"status\":0},\"10075\":{\"id\":10075,\"process\":0,\"status\":0},\"10076\":{\"id\":10076,\"process\":0,\"status\":0},\"10077\":{\"id\":10077,\"process\":3,\"status\":0},\"10078\":{\"id\":10078,\"process\":0,\"status\":0},\"10079\":{\"id\":10079,\"process\":0,\"status\":0},\"10080\":{\"id\":10080,\"process\":0,\"status\":0},\"10081\":{\"id\":10081,\"process\":0,\"status\":0},\"10082\":{\"id\":10082,\"process\":0,\"status\":0},\"10083\":{\"id\":10083,\"process\":0,\"status\":0},\"10084\":{\"id\":10084,\"process\":0,\"status\":0},\"10085\":{\"id\":10085,\"process\":0,\"status\":0},\"10086\":{\"id\":10086,\"process\":0,\"status\":0},\"10087\":{\"id\":10087,\"process\":0,\"status\":0},\"10088\":{\"id\":10088,\"process\":0,\"status\":0},\"10089\":{\"id\":10089,\"process\":3,\"status\":0},\"10090\":{\"id\":10090,\"process\":0,\"status\":0},\"10091\":{\"id\":10091,\"process\":0,\"status\":0},\"10092\":{\"id\":10092,\"process\":0,\"status\":0},\"10093\":{\"id\":10093,\"process\":0,\"status\":0},\"10094\":{\"id\":10094,\"process\":0,\"status\":0},\"10095\":{\"id\":10095,\"process\":0,\"status\":0},\"10096\":{\"id\":10096,\"process\":0,\"status\":0},\"10097\":{\"id\":10097,\"process\":0,\"status\":0},\"10098\":{\"id\":10098,\"process\":0,\"status\":0},\"10099\":{\"id\":10099,\"process\":0,\"status\":0},\"10100\":{\"id\":10100,\"process\":0,\"status\":0},\"10101\":{\"id\":10101,\"process\":0,\"status\":0},\"10102\":{\"id\":10102,\"process\":0,\"status\":0},\"10103\":{\"id\":10103,\"process\":0,\"status\":0},\"10104\":{\"id\":10104,\"process\":0,\"status\":0},\"10105\":{\"id\":10105,\"process\":0,\"status\":0},\"10106\":{\"id\":10106,\"process\":0,\"status\":0},\"10107\":{\"id\":10107,\"process\":0,\"status\":0},\"10108\":{\"id\":10108,\"process\":0,\"status\":0},\"10109\":{\"id\":10109,\"process\":0,\"status\":0},\"10110\":{\"id\":10110,\"process\":0,\"status\":0},\"10111\":{\"id\":10111,\"process\":0,\"status\":0},\"10112\":{\"id\":10112,\"process\":3,\"status\":0},\"10113\":{\"id\":10113,\"process\":0,\"status\":0},\"10114\":{\"id\":10114,\"process\":0,\"status\":0},\"10115\":{\"id\":10115,\"process\":0,\"status\":0},\"10116\":{\"id\":10116,\"process\":0,\"status\":0},\"10117\":{\"id\":10117,\"process\":0,\"status\":0},\"10118\":{\"id\":10118,\"process\":0,\"status\":0},\"10119\":{\"id\":10119,\"process\":0,\"status\":0},\"10120\":{\"id\":10120,\"process\":3,\"status\":0},\"10121\":{\"id\":10121,\"process\":0,\"status\":0},\"10122\":{\"id\":10122,\"process\":0,\"status\":0},\"10123\":{\"id\":10123,\"process\":0,\"status\":0},\"10124\":{\"id\":10124,\"process\":0,\"status\":0},\"10125\":{\"id\":10125,\"process\":0,\"status\":0},\"10126\":{\"id\":10126,\"process\":0,\"status\":0},\"10127\":{\"id\":10127,\"process\":0,\"status\":0},\"10128\":{\"id\":10128,\"process\":0,\"status\":0},\"10129\":{\"id\":10129,\"process\":0,\"status\":0},\"10130\":{\"id\":10130,\"process\":0,\"status\":0},\"10131\":{\"id\":10131,\"process\":0,\"status\":0},\"10132\":{\"id\":10132,\"process\":3,\"status\":0},\"10133\":{\"id\":10133,\"process\":0,\"status\":0},\"10134\":{\"id\":10134,\"process\":0,\"status\":0},\"10135\":{\"id\":10135,\"process\":0,\"status\":0},\"10136\":{\"id\":10136,\"process\":0,\"status\":0},\"10137\":{\"id\":10137,\"process\":0,\"status\":0},\"10138\":{\"id\":10138,\"process\":0,\"status\":0},\"10139\":{\"id\":10139,\"process\":0,\"status\":0},\"10140\":{\"id\":10140,\"process\":0,\"status\":0},\"10141\":{\"id\":10141,\"process\":0,\"status\":0},\"10142\":{\"id\":10142,\"process\":0,\"status\":0},\"10143\":{\"id\":10143,\"process\":0,\"status\":0},\"10144\":{\"id\":10144,\"process\":0,\"status\":0},\"10145\":{\"id\":10145,\"process\":0,\"status\":0},\"10146\":{\"id\":10146,\"process\":0,\"status\":0},\"10147\":{\"id\":10147,\"process\":0,\"status\":0},\"10148\":{\"id\":10148,\"process\":0,\"status\":0},\"10149\":{\"id\":10149,\"process\":0,\"status\":0},\"10150\":{\"id\":10150,\"process\":0,\"status\":0},\"10151\":{\"id\":10151,\"process\":0,\"status\":0},\"10152\":{\"id\":10152,\"process\":0,\"status\":0},\"10153\":{\"id\":10153,\"process\":0,\"status\":0},\"10154\":{\"id\":10154,\"process\":0,\"status\":0},\"10155\":{\"id\":10155,\"process\":3,\"status\":0},\"10156\":{\"id\":10156,\"process\":0,\"status\":0},\"10157\":{\"id\":10157,\"process\":0,\"status\":0},\"10158\":{\"id\":10158,\"process\":0,\"status\":0},\"10159\":{\"id\":10159,\"process\":0,\"status\":0},\"10160\":{\"id\":10160,\"process\":0,\"status\":0},\"10161\":{\"id\":10161,\"process\":0,\"status\":0},\"10162\":{\"id\":10162,\"process\":0,\"status\":0},\"10163\":{\"id\":10163,\"process\":3,\"status\":0},\"10164\":{\"id\":10164,\"process\":0,\"status\":0},\"10165\":{\"id\":10165,\"process\":0,\"status\":0},\"10166\":{\"id\":10166,\"process\":0,\"status\":0},\"10167\":{\"id\":10167,\"process\":0,\"status\":0},\"10168\":{\"id\":10168,\"process\":0,\"status\":0},\"10169\":{\"id\":10169,\"process\":0,\"status\":0},\"10170\":{\"id\":10170,\"process\":0,\"status\":0},\"10171\":{\"id\":10171,\"process\":0,\"status\":0},\"10172\":{\"id\":10172,\"process\":0,\"status\":0},\"10173\":{\"id\":10173,\"process\":0,\"status\":0},\"10174\":{\"id\":10174,\"process\":0,\"status\":0},\"10175\":{\"id\":10175,\"process\":3,\"status\":0},\"10176\":{\"id\":10176,\"process\":0,\"status\":0},\"10177\":{\"id\":10177,\"process\":0,\"status\":0},\"10178\":{\"id\":10178,\"process\":0,\"status\":0},\"10179\":{\"id\":10179,\"process\":0,\"status\":0},\"10180\":{\"id\":10180,\"process\":0,\"status\":0},\"10181\":{\"id\":10181,\"process\":0,\"status\":0},\"10182\":{\"id\":10182,\"process\":0,\"status\":0},\"10183\":{\"id\":10183,\"process\":0,\"status\":0},\"10184\":{\"id\":10184,\"process\":0,\"status\":0}}', '[10001,10002,10003]');
COMMIT;

-- ----------------------------
-- Table structure for mainline_scene
-- ----------------------------
DROP TABLE IF EXISTS `mainline_scene`;
CREATE TABLE `mainline_scene` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `identity` int(11) DEFAULT '0' COMMENT '场景标识ID',
  `max_stage` int(11) DEFAULT '0' COMMENT '当前开启的最大场景阶段',
  `first_stages` varchar(255) DEFAULT '' COMMENT '已领取首通奖励的阶段',
  `curr_stage` int(11) DEFAULT '0' COMMENT '当前进行挑战的场景阶级',
  `teleports` varchar(1000) DEFAULT '' COMMENT '已经开启的传送点',
  `opening_teleports` varchar(2000) DEFAULT '' COMMENT '正在开启的传送点',
  `fogs` text COMMENT '已经开启的区域',
  `opening_fogs` varchar(2000) DEFAULT '' COMMENT '正在开启的迷雾',
  `npcs` text COMMENT '已经完成缴纳的npc',
  `opening_npcs` varchar(2000) DEFAULT '' COMMENT '正在缴纳素材的npc',
  `dungeons` varchar(255) DEFAULT '' COMMENT '已经通关的场景副本',
  `portal_x` int(11) DEFAULT '0' COMMENT '传送门X坐标',
  `portal_y` int(11) DEFAULT '0' COMMENT '传送门Y坐标',
  `kill_monsters` varchar(2000) DEFAULT '' COMMENT '不需要再刷新出来的怪物ID',
  `open_next` char(5) DEFAULT 'false' COMMENT '是否已经开启下一场景',
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid_identity` (`pid`,`identity`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='场景信息表';

-- ----------------------------
-- Records of mainline_scene
-- ----------------------------
BEGIN;
INSERT INTO `mainline_scene` (`insert_time`, `update_time`, `id`, `pid`, `identity`, `max_stage`, `first_stages`, `curr_stage`, `teleports`, `opening_teleports`, `fogs`, `opening_fogs`, `npcs`, `opening_npcs`, `dungeons`, `portal_x`, `portal_y`, `kill_monsters`, `open_next`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:11', 100000001, 335879897874433, 1000, 1, '[]', 1, '[]', '{}', '[]', '{}', '[]', '{}', '[]', 0, 0, '[]', 'false');
INSERT INTO `mainline_scene` (`insert_time`, `update_time`, `id`, `pid`, `identity`, `max_stage`, `first_stages`, `curr_stage`, `teleports`, `opening_teleports`, `fogs`, `opening_fogs`, `npcs`, `opening_npcs`, `dungeons`, `portal_x`, `portal_y`, `kill_monsters`, `open_next`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:38:20', 100000002, 335879897874434, 1000, 1, '[]', 1, '[]', '{}', '[1]', '{}', '[1]', '{}', '[]', 0, 0, '[]', 'false');
COMMIT;

-- ----------------------------
-- Table structure for open_function
-- ----------------------------
DROP TABLE IF EXISTS `open_function`;
CREATE TABLE `open_function` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `function_ids` varchar(5000) DEFAULT '' COMMENT '已开启的功能ID',
  `guides` varchar(5000) DEFAULT '' COMMENT '已完成的新手引导步骤',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='功能开启表';

-- ----------------------------
-- Records of open_function
-- ----------------------------
BEGIN;
INSERT INTO `open_function` (`insert_time`, `update_time`, `pid`, `function_ids`, `guides`) VALUES ('2024-11-22 11:02:58', '2024-11-22 11:02:58', 335879897874433, '[10004,10022,10058,10014]', '{}');
INSERT INTO `open_function` (`insert_time`, `update_time`, `pid`, `function_ids`, `guides`) VALUES ('2024-11-22 11:38:01', '2024-11-22 11:39:01', 335879897874434, '[10004,10022,10058,10014]', '{\"1\":{\"group\":1,\"step\":3},\"2\":{\"group\":2,\"step\":3},\"3\":{\"group\":3,\"step\":1},\"4\":{\"group\":4,\"step\":2},\"5\":{\"group\":5,\"step\":1},\"6\":{\"group\":6,\"step\":1}}');
COMMIT;

-- ----------------------------
-- Table structure for p1001_zhan_ling_exp
-- ----------------------------
DROP TABLE IF EXISTS `p1001_zhan_ling_exp`;
CREATE TABLE `p1001_zhan_ling_exp` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `type_id` int(11) DEFAULT '0' COMMENT '活动类型ID',
  `type_name` varchar(255) DEFAULT '' COMMENT '活动类型名字',
  `turns` int(11) DEFAULT '0' COMMENT '活动轮数',
  `level` int(11) DEFAULT '0' COMMENT '等级',
  `exp` bigint(20) DEFAULT '0' COMMENT '经验值',
  `free_reward_lv` int(11) DEFAULT '0' COMMENT '已领取到的免费奖励等级',
  `premium_reward_lv` int(11) DEFAULT '0' COMMENT '已领取到的高级奖励等级',
  `buy_premium` char(5) DEFAULT 'false' COMMENT '是否已经购买高级通行证',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='经验类战令';

-- ----------------------------
-- Records of p1001_zhan_ling_exp
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for p1002_zhan_ling_goal
-- ----------------------------
DROP TABLE IF EXISTS `p1002_zhan_ling_goal`;
CREATE TABLE `p1002_zhan_ling_goal` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `type_id` int(11) DEFAULT '0' COMMENT '活动类型ID',
  `type_name` varchar(255) DEFAULT '' COMMENT '活动类型名字',
  `turns` int(11) DEFAULT '0' COMMENT '活动轮数',
  `tasks` text COMMENT '目标任务数据',
  `premium_tasks` varchar(2000) DEFAULT '' COMMENT '已经领取高级奖励的任务ID',
  `buy_premium` char(5) DEFAULT 'false' COMMENT '是否已经购买高级通行证',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000005 DEFAULT CHARSET=utf8mb4 COMMENT='经验类战令';

-- ----------------------------
-- Records of p1002_zhan_ling_goal
-- ----------------------------
BEGIN;
INSERT INTO `p1002_zhan_ling_goal` (`insert_time`, `update_time`, `id`, `pid`, `type_id`, `type_name`, `turns`, `tasks`, `premium_tasks`, `buy_premium`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:12', 100000001, 335879897874433, 1002001, '等级战令', 1, '[{\"id\":1001,\"process\":0,\"status\":0},{\"id\":1002,\"process\":0,\"status\":0},{\"id\":1003,\"process\":0,\"status\":0},{\"id\":1004,\"process\":0,\"status\":0},{\"id\":1005,\"process\":0,\"status\":0},{\"id\":1006,\"process\":0,\"status\":0},{\"id\":1007,\"process\":0,\"status\":0},{\"id\":1008,\"process\":0,\"status\":0},{\"id\":1009,\"process\":0,\"status\":0},{\"id\":1010,\"process\":0,\"status\":0},{\"id\":1011,\"process\":0,\"status\":0},{\"id\":1012,\"process\":0,\"status\":0},{\"id\":1013,\"process\":0,\"status\":0},{\"id\":1014,\"process\":0,\"status\":0},{\"id\":1015,\"process\":0,\"status\":0},{\"id\":1016,\"process\":0,\"status\":0},{\"id\":1017,\"process\":0,\"status\":0},{\"id\":1018,\"process\":0,\"status\":0},{\"id\":1019,\"process\":0,\"status\":0},{\"id\":1020,\"process\":0,\"status\":0},{\"id\":1021,\"process\":0,\"status\":0},{\"id\":1022,\"process\":0,\"status\":0},{\"id\":1023,\"process\":0,\"status\":0},{\"id\":1024,\"process\":0,\"status\":0}]', '[]', 'false');
INSERT INTO `p1002_zhan_ling_goal` (`insert_time`, `update_time`, `id`, `pid`, `type_id`, `type_name`, `turns`, `tasks`, `premium_tasks`, `buy_premium`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:12', 100000002, 335879897874433, 1002004, '循环活动-招募战令', 1, '[{\"id\":2001,\"process\":0,\"status\":0},{\"id\":2002,\"process\":0,\"status\":0},{\"id\":2003,\"process\":0,\"status\":0},{\"id\":2004,\"process\":0,\"status\":0},{\"id\":2005,\"process\":0,\"status\":0},{\"id\":2006,\"process\":0,\"status\":0},{\"id\":2007,\"process\":0,\"status\":0},{\"id\":2008,\"process\":0,\"status\":0},{\"id\":2009,\"process\":0,\"status\":0},{\"id\":2010,\"process\":0,\"status\":0},{\"id\":2011,\"process\":0,\"status\":0},{\"id\":2012,\"process\":0,\"status\":0},{\"id\":2013,\"process\":0,\"status\":0},{\"id\":2014,\"process\":0,\"status\":0},{\"id\":2015,\"process\":0,\"status\":0},{\"id\":2016,\"process\":0,\"status\":0},{\"id\":2017,\"process\":0,\"status\":0},{\"id\":2018,\"process\":0,\"status\":0},{\"id\":2019,\"process\":0,\"status\":0},{\"id\":2020,\"process\":0,\"status\":0},{\"id\":2021,\"process\":0,\"status\":0},{\"id\":2022,\"process\":0,\"status\":0},{\"id\":2023,\"process\":0,\"status\":0},{\"id\":2024,\"process\":0,\"status\":0},{\"id\":2025,\"process\":0,\"status\":0},{\"id\":2026,\"process\":0,\"status\":0},{\"id\":2027,\"process\":0,\"status\":0},{\"id\":2028,\"process\":0,\"status\":0},{\"id\":2029,\"process\":0,\"status\":0},{\"id\":2030,\"process\":0,\"status\":0},{\"id\":2031,\"process\":0,\"status\":0},{\"id\":2032,\"process\":0,\"status\":0}]', '[]', 'false');
INSERT INTO `p1002_zhan_ling_goal` (`insert_time`, `update_time`, `id`, `pid`, `type_id`, `type_name`, `turns`, `tasks`, `premium_tasks`, `buy_premium`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:46:21', 100000003, 335879897874434, 1002001, '等级战令', 1, '[{\"id\":1001,\"process\":3,\"status\":0},{\"id\":1002,\"process\":3,\"status\":0},{\"id\":1003,\"process\":3,\"status\":0},{\"id\":1004,\"process\":3,\"status\":0},{\"id\":1005,\"process\":3,\"status\":0},{\"id\":1006,\"process\":3,\"status\":0},{\"id\":1007,\"process\":3,\"status\":0},{\"id\":1008,\"process\":3,\"status\":0},{\"id\":1009,\"process\":3,\"status\":0},{\"id\":1010,\"process\":3,\"status\":0},{\"id\":1011,\"process\":3,\"status\":0},{\"id\":1012,\"process\":3,\"status\":0},{\"id\":1013,\"process\":3,\"status\":0},{\"id\":1014,\"process\":3,\"status\":0},{\"id\":1015,\"process\":3,\"status\":0},{\"id\":1016,\"process\":3,\"status\":0},{\"id\":1017,\"process\":3,\"status\":0},{\"id\":1018,\"process\":3,\"status\":0},{\"id\":1019,\"process\":3,\"status\":0},{\"id\":1020,\"process\":3,\"status\":0},{\"id\":1021,\"process\":3,\"status\":0},{\"id\":1022,\"process\":3,\"status\":0},{\"id\":1023,\"process\":3,\"status\":0},{\"id\":1024,\"process\":3,\"status\":0}]', '[]', 'false');
INSERT INTO `p1002_zhan_ling_goal` (`insert_time`, `update_time`, `id`, `pid`, `type_id`, `type_name`, `turns`, `tasks`, `premium_tasks`, `buy_premium`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:21', 100000004, 335879897874434, 1002004, '循环活动-招募战令', 1, '[{\"id\":2001,\"process\":0,\"status\":0},{\"id\":2002,\"process\":0,\"status\":0},{\"id\":2003,\"process\":0,\"status\":0},{\"id\":2004,\"process\":0,\"status\":0},{\"id\":2005,\"process\":0,\"status\":0},{\"id\":2006,\"process\":0,\"status\":0},{\"id\":2007,\"process\":0,\"status\":0},{\"id\":2008,\"process\":0,\"status\":0},{\"id\":2009,\"process\":0,\"status\":0},{\"id\":2010,\"process\":0,\"status\":0},{\"id\":2011,\"process\":0,\"status\":0},{\"id\":2012,\"process\":0,\"status\":0},{\"id\":2013,\"process\":0,\"status\":0},{\"id\":2014,\"process\":0,\"status\":0},{\"id\":2015,\"process\":0,\"status\":0},{\"id\":2016,\"process\":0,\"status\":0},{\"id\":2017,\"process\":0,\"status\":0},{\"id\":2018,\"process\":0,\"status\":0},{\"id\":2019,\"process\":0,\"status\":0},{\"id\":2020,\"process\":0,\"status\":0},{\"id\":2021,\"process\":0,\"status\":0},{\"id\":2022,\"process\":0,\"status\":0},{\"id\":2023,\"process\":0,\"status\":0},{\"id\":2024,\"process\":0,\"status\":0},{\"id\":2025,\"process\":0,\"status\":0},{\"id\":2026,\"process\":0,\"status\":0},{\"id\":2027,\"process\":0,\"status\":0},{\"id\":2028,\"process\":0,\"status\":0},{\"id\":2029,\"process\":0,\"status\":0},{\"id\":2030,\"process\":0,\"status\":0},{\"id\":2031,\"process\":0,\"status\":0},{\"id\":2032,\"process\":0,\"status\":0}]', '[]', 'false');
COMMIT;

-- ----------------------------
-- Table structure for p1004_tong_tian_ta_te_quan
-- ----------------------------
DROP TABLE IF EXISTS `p1004_tong_tian_ta_te_quan`;
CREATE TABLE `p1004_tong_tian_ta_te_quan` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `type_id` int(11) DEFAULT '0' COMMENT '活动类型ID',
  `tower_details` text COMMENT '奖励数据',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='通天塔特权';

-- ----------------------------
-- Records of p1004_tong_tian_ta_te_quan
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for p1005_xian_shi_li_bao
-- ----------------------------
DROP TABLE IF EXISTS `p1005_xian_shi_li_bao`;
CREATE TABLE `p1005_xian_shi_li_bao` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `gift_id` int(11) DEFAULT '0' COMMENT '礼包id',
  `buy` char(5) DEFAULT 'false' COMMENT '是否已购买',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='限时礼包';

-- ----------------------------
-- Records of p1005_xian_shi_li_bao
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for p1005_xslb_player
-- ----------------------------
DROP TABLE IF EXISTS `p1005_xslb_player`;
CREATE TABLE `p1005_xslb_player` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `daily_limits` varchar(5000) DEFAULT '' COMMENT '每日触发次数限制',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `life_limits` varchar(5000) DEFAULT '' COMMENT '终生触发次数限制',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='限时礼包玩家数据';

-- ----------------------------
-- Records of p1005_xslb_player
-- ----------------------------
BEGIN;
INSERT INTO `p1005_xslb_player` (`insert_time`, `update_time`, `pid`, `daily_limits`, `daily_time`, `life_limits`) VALUES ('2024-11-22 11:02:58', '2024-11-22 11:02:58', 335879897874433, '{}', '2024-11-23 05:00:00', '{}');
INSERT INTO `p1005_xslb_player` (`insert_time`, `update_time`, `pid`, `daily_limits`, `daily_time`, `life_limits`) VALUES ('2024-11-22 11:37:08', '2024-11-22 11:37:08', 335879897874434, '{}', '2024-11-23 05:00:00', '{}');
COMMIT;

-- ----------------------------
-- Table structure for p1006_cheng_zhang_ji_jin
-- ----------------------------
DROP TABLE IF EXISTS `p1006_cheng_zhang_ji_jin`;
CREATE TABLE `p1006_cheng_zhang_ji_jin` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `type_id` int(11) DEFAULT '0' COMMENT '活动类型ID',
  `round` int(11) DEFAULT '0' COMMENT '期数',
  `open` char(5) DEFAULT 'false' COMMENT '是否已购买本期基金',
  `reward_ids` varchar(255) DEFAULT '' COMMENT '已领取的奖励ID',
  PRIMARY KEY (`id`),
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='成长基金';

-- ----------------------------
-- Records of p1006_cheng_zhang_ji_jin
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for p1007_qi_ri_mu_biao
-- ----------------------------
DROP TABLE IF EXISTS `p1007_qi_ri_mu_biao`;
CREATE TABLE `p1007_qi_ri_mu_biao` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `opened` char(5) DEFAULT 'false' COMMENT '玩家是否已经达到开启该活动的条件',
  `day` int(11) DEFAULT '0' COMMENT '当前所处天数',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `task_map` text COMMENT '任务数据',
  `end_time` datetime DEFAULT NULL COMMENT '活动结束时间',
  `stage_rewards` varchar(255) DEFAULT '' COMMENT '已经领取的阶段奖励',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='七日目标';

-- ----------------------------
-- Records of p1007_qi_ri_mu_biao
-- ----------------------------
BEGIN;
INSERT INTO `p1007_qi_ri_mu_biao` (`insert_time`, `update_time`, `pid`, `opened`, `day`, `daily_time`, `task_map`, `end_time`, `stage_rewards`) VALUES ('2024-11-22 11:02:10', '2024-11-22 11:02:42', 335879897874433, 'false', 1, '2024-11-23 05:00:00', '{\"5001\":{\"id\":5001,\"process\":1,\"status\":0},\"5002\":{\"id\":5002,\"process\":0,\"status\":0},\"5003\":{\"id\":5003,\"process\":0,\"status\":0},\"5004\":{\"id\":5004,\"process\":0,\"status\":0},\"5005\":{\"id\":5005,\"process\":0,\"status\":0},\"5006\":{\"id\":5006,\"process\":0,\"status\":0},\"5007\":{\"id\":5007,\"process\":0,\"status\":0},\"5008\":{\"id\":5008,\"process\":0,\"status\":0},\"5009\":{\"id\":5009,\"process\":0,\"status\":0},\"5010\":{\"id\":5010,\"process\":0,\"status\":0},\"5011\":{\"id\":5011,\"process\":0,\"status\":0},\"5012\":{\"id\":5012,\"process\":0,\"status\":0},\"4001\":{\"id\":4001,\"process\":1,\"status\":0},\"4002\":{\"id\":4002,\"process\":0,\"status\":0},\"4003\":{\"id\":4003,\"process\":0,\"status\":0},\"4004\":{\"id\":4004,\"process\":0,\"status\":0},\"4005\":{\"id\":4005,\"process\":0,\"status\":0},\"4006\":{\"id\":4006,\"process\":0,\"status\":0},\"4007\":{\"id\":4007,\"process\":0,\"status\":0},\"4008\":{\"id\":4008,\"process\":0,\"status\":0},\"4009\":{\"id\":4009,\"process\":0,\"status\":0},\"4010\":{\"id\":4010,\"process\":0,\"status\":0},\"4011\":{\"id\":4011,\"process\":0,\"status\":0},\"4012\":{\"id\":4012,\"process\":0,\"status\":0},\"3001\":{\"id\":3001,\"process\":1,\"status\":0},\"3002\":{\"id\":3002,\"process\":0,\"status\":0},\"3003\":{\"id\":3003,\"process\":0,\"status\":0},\"3004\":{\"id\":3004,\"process\":0,\"status\":0},\"3005\":{\"id\":3005,\"process\":0,\"status\":0},\"3006\":{\"id\":3006,\"process\":0,\"status\":0},\"3007\":{\"id\":3007,\"process\":0,\"status\":0},\"3008\":{\"id\":3008,\"process\":0,\"status\":0},\"3009\":{\"id\":3009,\"process\":0,\"status\":0},\"3010\":{\"id\":3010,\"process\":0,\"status\":0},\"3011\":{\"id\":3011,\"process\":0,\"status\":0},\"3012\":{\"id\":3012,\"process\":0,\"status\":0},\"2001\":{\"id\":2001,\"process\":1,\"status\":0},\"2002\":{\"id\":2002,\"process\":0,\"status\":0},\"2003\":{\"id\":2003,\"process\":0,\"status\":0},\"2004\":{\"id\":2004,\"process\":0,\"status\":0},\"2005\":{\"id\":2005,\"process\":0,\"status\":0},\"2006\":{\"id\":2006,\"process\":0,\"status\":0},\"2007\":{\"id\":2007,\"process\":0,\"status\":0},\"2008\":{\"id\":2008,\"process\":0,\"status\":0},\"2009\":{\"id\":2009,\"process\":0,\"status\":0},\"7001\":{\"id\":7001,\"process\":1,\"status\":0},\"2010\":{\"id\":2010,\"process\":0,\"status\":0},\"7002\":{\"id\":7002,\"process\":0,\"status\":0},\"2011\":{\"id\":2011,\"process\":0,\"status\":0},\"7003\":{\"id\":7003,\"process\":0,\"status\":0},\"2012\":{\"id\":2012,\"process\":0,\"status\":0},\"7004\":{\"id\":7004,\"process\":0,\"status\":0},\"7005\":{\"id\":7005,\"process\":0,\"status\":0},\"7006\":{\"id\":7006,\"process\":0,\"status\":0},\"7007\":{\"id\":7007,\"process\":0,\"status\":0},\"7008\":{\"id\":7008,\"process\":0,\"status\":0},\"7009\":{\"id\":7009,\"process\":0,\"status\":0},\"7010\":{\"id\":7010,\"process\":0,\"status\":0},\"7011\":{\"id\":7011,\"process\":0,\"status\":0},\"7012\":{\"id\":7012,\"process\":0,\"status\":0},\"1001\":{\"id\":1001,\"process\":1,\"status\":1},\"1002\":{\"id\":1002,\"process\":0,\"status\":0},\"1003\":{\"id\":1003,\"process\":0,\"status\":0},\"1004\":{\"id\":1004,\"process\":0,\"status\":0},\"1005\":{\"id\":1005,\"process\":0,\"status\":0},\"1006\":{\"id\":1006,\"process\":0,\"status\":0},\"1007\":{\"id\":1007,\"process\":0,\"status\":0},\"1008\":{\"id\":1008,\"process\":0,\"status\":0},\"1009\":{\"id\":1009,\"process\":0,\"status\":0},\"6001\":{\"id\":6001,\"process\":1,\"status\":0},\"1010\":{\"id\":1010,\"process\":0,\"status\":0},\"6002\":{\"id\":6002,\"process\":0,\"status\":0},\"1011\":{\"id\":1011,\"process\":0,\"status\":0},\"6003\":{\"id\":6003,\"process\":0,\"status\":0},\"1012\":{\"id\":1012,\"process\":0,\"status\":0},\"6004\":{\"id\":6004,\"process\":0,\"status\":0},\"6005\":{\"id\":6005,\"process\":0,\"status\":0},\"6006\":{\"id\":6006,\"process\":0,\"status\":0},\"6007\":{\"id\":6007,\"process\":0,\"status\":0},\"6008\":{\"id\":6008,\"process\":0,\"status\":0},\"6009\":{\"id\":6009,\"process\":0,\"status\":0},\"6010\":{\"id\":6010,\"process\":0,\"status\":0},\"6011\":{\"id\":6011,\"process\":0,\"status\":0},\"6012\":{\"id\":6012,\"process\":0,\"status\":0}}', '2024-11-29 11:02:10', '[]');
INSERT INTO `p1007_qi_ri_mu_biao` (`insert_time`, `update_time`, `pid`, `opened`, `day`, `daily_time`, `task_map`, `end_time`, `stage_rewards`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:50:54', 335879897874434, 'false', 1, '2024-11-23 05:00:00', '{\"5001\":{\"id\":5001,\"process\":1,\"status\":0},\"5002\":{\"id\":5002,\"process\":0,\"status\":0},\"5003\":{\"id\":5003,\"process\":0,\"status\":0},\"5004\":{\"id\":5004,\"process\":1043,\"status\":0},\"5005\":{\"id\":5005,\"process\":0,\"status\":0},\"5006\":{\"id\":5006,\"process\":0,\"status\":0},\"5007\":{\"id\":5007,\"process\":0,\"status\":0},\"5008\":{\"id\":5008,\"process\":0,\"status\":0},\"5009\":{\"id\":5009,\"process\":0,\"status\":0},\"5010\":{\"id\":5010,\"process\":63,\"status\":0},\"5011\":{\"id\":5011,\"process\":0,\"status\":0},\"5012\":{\"id\":5012,\"process\":3,\"status\":0},\"4001\":{\"id\":4001,\"process\":1,\"status\":0},\"4002\":{\"id\":4002,\"process\":0,\"status\":0},\"4003\":{\"id\":4003,\"process\":0,\"status\":0},\"4004\":{\"id\":4004,\"process\":1043,\"status\":0},\"4005\":{\"id\":4005,\"process\":0,\"status\":0},\"4006\":{\"id\":4006,\"process\":0,\"status\":0},\"4007\":{\"id\":4007,\"process\":0,\"status\":0},\"4008\":{\"id\":4008,\"process\":0,\"status\":0},\"4009\":{\"id\":4009,\"process\":0,\"status\":0},\"4010\":{\"id\":4010,\"process\":63,\"status\":0},\"4011\":{\"id\":4011,\"process\":0,\"status\":0},\"4012\":{\"id\":4012,\"process\":3,\"status\":0},\"3001\":{\"id\":3001,\"process\":1,\"status\":0},\"3002\":{\"id\":3002,\"process\":0,\"status\":0},\"3003\":{\"id\":3003,\"process\":0,\"status\":0},\"3004\":{\"id\":3004,\"process\":1043,\"status\":0},\"3005\":{\"id\":3005,\"process\":0,\"status\":0},\"3006\":{\"id\":3006,\"process\":0,\"status\":0},\"3007\":{\"id\":3007,\"process\":0,\"status\":0},\"3008\":{\"id\":3008,\"process\":0,\"status\":0},\"3009\":{\"id\":3009,\"process\":0,\"status\":0},\"3010\":{\"id\":3010,\"process\":63,\"status\":0},\"3011\":{\"id\":3011,\"process\":0,\"status\":0},\"3012\":{\"id\":3012,\"process\":3,\"status\":0},\"2001\":{\"id\":2001,\"process\":1,\"status\":0},\"2002\":{\"id\":2002,\"process\":0,\"status\":0},\"2003\":{\"id\":2003,\"process\":0,\"status\":0},\"2004\":{\"id\":2004,\"process\":1043,\"status\":0},\"2005\":{\"id\":2005,\"process\":0,\"status\":0},\"2006\":{\"id\":2006,\"process\":0,\"status\":0},\"2007\":{\"id\":2007,\"process\":0,\"status\":0},\"2008\":{\"id\":2008,\"process\":0,\"status\":0},\"2009\":{\"id\":2009,\"process\":0,\"status\":0},\"7001\":{\"id\":7001,\"process\":1,\"status\":0},\"2010\":{\"id\":2010,\"process\":63,\"status\":0},\"7002\":{\"id\":7002,\"process\":0,\"status\":0},\"2011\":{\"id\":2011,\"process\":0,\"status\":0},\"7003\":{\"id\":7003,\"process\":0,\"status\":0},\"2012\":{\"id\":2012,\"process\":3,\"status\":0},\"7004\":{\"id\":7004,\"process\":1043,\"status\":0},\"7005\":{\"id\":7005,\"process\":0,\"status\":0},\"7006\":{\"id\":7006,\"process\":0,\"status\":0},\"7007\":{\"id\":7007,\"process\":0,\"status\":0},\"7008\":{\"id\":7008,\"process\":0,\"status\":0},\"7009\":{\"id\":7009,\"process\":0,\"status\":0},\"7010\":{\"id\":7010,\"process\":63,\"status\":0},\"7011\":{\"id\":7011,\"process\":0,\"status\":0},\"7012\":{\"id\":7012,\"process\":3,\"status\":0},\"1001\":{\"id\":1001,\"process\":1,\"status\":1},\"1002\":{\"id\":1002,\"process\":0,\"status\":0},\"1003\":{\"id\":1003,\"process\":0,\"status\":0},\"1004\":{\"id\":1004,\"process\":1043,\"status\":0},\"1005\":{\"id\":1005,\"process\":0,\"status\":0},\"1006\":{\"id\":1006,\"process\":0,\"status\":0},\"1007\":{\"id\":1007,\"process\":0,\"status\":0},\"1008\":{\"id\":1008,\"process\":0,\"status\":0},\"1009\":{\"id\":1009,\"process\":0,\"status\":0},\"6001\":{\"id\":6001,\"process\":1,\"status\":0},\"1010\":{\"id\":1010,\"process\":63,\"status\":0},\"6002\":{\"id\":6002,\"process\":0,\"status\":0},\"1011\":{\"id\":1011,\"process\":0,\"status\":0},\"6003\":{\"id\":6003,\"process\":0,\"status\":0},\"1012\":{\"id\":1012,\"process\":3,\"status\":0},\"6004\":{\"id\":6004,\"process\":1043,\"status\":0},\"6005\":{\"id\":6005,\"process\":0,\"status\":0},\"6006\":{\"id\":6006,\"process\":0,\"status\":0},\"6007\":{\"id\":6007,\"process\":0,\"status\":0},\"6008\":{\"id\":6008,\"process\":0,\"status\":0},\"6009\":{\"id\":6009,\"process\":0,\"status\":0},\"6010\":{\"id\":6010,\"process\":63,\"status\":0},\"6011\":{\"id\":6011,\"process\":0,\"status\":0},\"6012\":{\"id\":6012,\"process\":3,\"status\":0}}', '2024-11-29 11:37:06', '[]');
COMMIT;

-- ----------------------------
-- Table structure for p1008_chong_bang
-- ----------------------------
DROP TABLE IF EXISTS `p1008_chong_bang`;
CREATE TABLE `p1008_chong_bang` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `type_id` int(11) DEFAULT '0' COMMENT '活动类型ID',
  `type_name` varchar(255) DEFAULT '' COMMENT '活动名字（仅用于看）',
  `turns` int(11) DEFAULT '0' COMMENT '活动轮数',
  `score` bigint(20) DEFAULT '0' COMMENT '分数',
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid_typeid` (`pid`,`type_id`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='冲榜活动玩家数据';

-- ----------------------------
-- Records of p1008_chong_bang
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for p1009_zhi_gou
-- ----------------------------
DROP TABLE IF EXISTS `p1009_zhi_gou`;
CREATE TABLE `p1009_zhi_gou` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `type_id` int(11) DEFAULT '0' COMMENT '活动类型ID',
  `turns` int(11) DEFAULT '0' COMMENT '活动轮数',
  `limit_buys` varchar(5000) DEFAULT '' COMMENT '限购信息',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `weekly_time` datetime DEFAULT NULL COMMENT '每周重置时间',
  `monthly_time` datetime DEFAULT NULL COMMENT '每月重置时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid_typeid` (`pid`,`type_id`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='直购活动';

-- ----------------------------
-- Records of p1009_zhi_gou
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for p1010_huo_dong_mu_biao
-- ----------------------------
DROP TABLE IF EXISTS `p1010_huo_dong_mu_biao`;
CREATE TABLE `p1010_huo_dong_mu_biao` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `type_id` int(11) DEFAULT '0' COMMENT '活动类型ID',
  `type_name` varchar(255) DEFAULT '' COMMENT '活动名字（仅用于看）',
  `turns` int(11) DEFAULT '0' COMMENT '活动轮数',
  `tasks` text COMMENT '任务数据',
  `reward_round` int(11) DEFAULT '0' COMMENT '当前奖励轮数',
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid_typeid` (`pid`,`type_id`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000003 DEFAULT CHARSET=utf8mb4 COMMENT='活动目标';

-- ----------------------------
-- Records of p1010_huo_dong_mu_biao
-- ----------------------------
BEGIN;
INSERT INTO `p1010_huo_dong_mu_biao` (`insert_time`, `update_time`, `id`, `pid`, `type_id`, `type_name`, `turns`, `tasks`, `reward_round`) VALUES ('2024-11-22 11:02:11', '2024-11-22 11:02:42', 100000001, 335879897874433, 1010001, '开服活动-伙伴目标', 1, '[{\"id\":1001,\"process\":0,\"status\":0},{\"id\":1002,\"process\":0,\"status\":0},{\"id\":1003,\"process\":0,\"status\":0},{\"id\":1004,\"process\":0,\"status\":0},{\"id\":1005,\"process\":0,\"status\":0},{\"id\":1006,\"process\":0,\"status\":0},{\"id\":1007,\"process\":0,\"status\":0},{\"id\":1008,\"process\":0,\"status\":0},{\"id\":1009,\"process\":0,\"status\":0},{\"id\":1010,\"process\":0,\"status\":0}]', 1);
INSERT INTO `p1010_huo_dong_mu_biao` (`insert_time`, `update_time`, `id`, `pid`, `type_id`, `type_name`, `turns`, `tasks`, `reward_round`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:37:16', 100000002, 335879897874434, 1010001, '开服活动-伙伴目标', 1, '[{\"id\":1001,\"process\":0,\"status\":0},{\"id\":1002,\"process\":0,\"status\":0},{\"id\":1003,\"process\":0,\"status\":0},{\"id\":1004,\"process\":0,\"status\":0},{\"id\":1005,\"process\":0,\"status\":0},{\"id\":1006,\"process\":0,\"status\":0},{\"id\":1007,\"process\":0,\"status\":0},{\"id\":1008,\"process\":0,\"status\":0},{\"id\":1009,\"process\":0,\"status\":0},{\"id\":1010,\"process\":0,\"status\":0}]', 1);
COMMIT;

-- ----------------------------
-- Table structure for p1011_mei_ri_chong_zhi
-- ----------------------------
DROP TABLE IF EXISTS `p1011_mei_ri_chong_zhi`;
CREATE TABLE `p1011_mei_ri_chong_zhi` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '数据唯一ID',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `type_id` int(11) DEFAULT '0' COMMENT '活动类型ID',
  `type_name` varchar(255) DEFAULT '' COMMENT '活动名字（仅用于看）',
  `turns` int(11) DEFAULT '0' COMMENT '活动轮数',
  `recharge_value` bigint(20) DEFAULT '0' COMMENT '当天充值金额',
  `can_reward_id` int(11) DEFAULT '0' COMMENT '可以领取到的奖励ID',
  `take_rewards` varchar(255) DEFAULT '' COMMENT '已经领取过的奖励',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `reward_settle` char(5) DEFAULT 'false' COMMENT '当日奖励是否结算',
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid_typeid` (`pid`,`type_id`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000001 DEFAULT CHARSET=utf8mb4 COMMENT='每日充值';

-- ----------------------------
-- Records of p1011_mei_ri_chong_zhi
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for player
-- ----------------------------
DROP TABLE IF EXISTS `player`;
CREATE TABLE `player` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '玩家ID',
  `open_id` varchar(255) DEFAULT '' COMMENT '账户ID',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `nick` varchar(255) DEFAULT '' COMMENT '昵称',
  `head` varchar(255) DEFAULT '' COMMENT '头像',
  `image` int(11) DEFAULT '0' COMMENT '形象',
  `sex` int(11) DEFAULT '0' COMMENT '性别，0无性别，1男，2女',
  `level` int(11) DEFAULT '0' COMMENT '等级',
  `exp` bigint(20) DEFAULT '0' COMMENT '经验',
  `vip_level` int(11) DEFAULT '0' COMMENT 'vip等级',
  `vip_exp` bigint(20) DEFAULT '0' COMMENT 'vip经验',
  `gold` bigint(20) DEFAULT '0' COMMENT '金币',
  `diamond` bigint(20) DEFAULT '0' COMMENT '钻石',
  `fighting` bigint(20) DEFAULT '0' COMMENT '战斗力',
  `change_name_num` int(11) DEFAULT '0' COMMENT '修改名字的次数',
  `online` char(5) DEFAULT 'false' COMMENT '是否在线',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `last_logout_time` datetime DEFAULT NULL COMMENT '最后登出时间',
  `forbid_end_time` datetime DEFAULT NULL COMMENT '封号结束时间',
  `buy_privilege` char(5) DEFAULT 'false' COMMENT '是否已购买特权',
  `daily_online` int(11) DEFAULT '0' COMMENT '今日在线时长',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `login_ip` varchar(255) DEFAULT '' COMMENT '登录IP',
  `login_device_type` varchar(10) DEFAULT '' COMMENT '登录客户端类型，ANDROID，IOS，H5',
  `login_device_id` varchar(255) DEFAULT '' COMMENT '登录设备ID',
  `login_version` varchar(255) DEFAULT '' COMMENT '登录游戏版本号',
  `create_ip` varchar(255) DEFAULT '' COMMENT '创号IP',
  `create_device_type` varchar(10) DEFAULT '' COMMENT '创号客户端类型，ANDROID，IOS，H5',
  `create_device_id` varchar(255) DEFAULT '' COMMENT '创号设备ID',
  `create_channel` int(11) DEFAULT '0' COMMENT '注册渠道',
  `create_pay` char(5) DEFAULT 'false' COMMENT '是否创号当天有充值',
  `lang_type` varchar(255) DEFAULT '' COMMENT '语言类型',
  PRIMARY KEY (`id`),
  UNIQUE KEY `openid_serverid` (`open_id`,`server_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=335879897874435 DEFAULT CHARSET=utf8mb4 COMMENT='玩家信息表';

-- ----------------------------
-- Records of player
-- ----------------------------
BEGIN;
INSERT INTO `player` (`insert_time`, `update_time`, `id`, `open_id`, `server_id`, `nick`, `head`, `image`, `sex`, `level`, `exp`, `vip_level`, `vip_exp`, `gold`, `diamond`, `fighting`, `change_name_num`, `online`, `last_login_time`, `last_logout_time`, `forbid_end_time`, `buy_privilege`, `daily_online`, `daily_time`, `login_ip`, `login_device_type`, `login_device_id`, `login_version`, `create_ip`, `create_device_type`, `create_device_id`, `create_channel`, `create_pay`, `lang_type`) VALUES ('2024-11-22 11:02:10', '2024-11-22 13:11:15', 335879897874433, 'zxt', 1, '宁丁兰', '', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'false', '2024-11-22 11:21:30', '2024-11-22 13:11:11', '2024-11-22 11:02:10', 'false', 6761, '2024-11-23 05:00:00', '127.0.0.1', 'IOS-TEST', '', NULL, '127.0.0.1', 'IOS-TEST', '', 1, 'false', NULL);
INSERT INTO `player` (`insert_time`, `update_time`, `id`, `open_id`, `server_id`, `nick`, `head`, `image`, `sex`, `level`, `exp`, `vip_level`, `vip_exp`, `gold`, `diamond`, `fighting`, `change_name_num`, `online`, `last_login_time`, `last_logout_time`, `forbid_end_time`, `buy_privilege`, `daily_online`, `daily_time`, `login_ip`, `login_device_type`, `login_device_id`, `login_version`, `create_ip`, `create_device_type`, `create_device_id`, `create_channel`, `create_pay`, `lang_type`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:50:59', 335879897874434, 'xg011732246612147', 1, '方昊乾', '', 1020001, 0, 3, 199, 0, 0, 20, 0, 1043, 0, 'false', '2024-11-22 11:37:06', '2024-11-22 11:50:01', '2024-11-22 11:37:06', 'false', 776, '2024-11-23 05:00:00', '192.168.3.144', 'IOS', '1', NULL, '192.168.3.144', 'IOS', '1', 2, 'false', NULL);
COMMIT;

-- ----------------------------
-- Table structure for player_detail
-- ----------------------------
DROP TABLE IF EXISTS `player_detail`;
CREATE TABLE `player_detail` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `chat_cds` varchar(500) DEFAULT '' COMMENT '聊天冷却时间',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家杂项数据表';

-- ----------------------------
-- Records of player_detail
-- ----------------------------
BEGIN;
INSERT INTO `player_detail` (`insert_time`, `update_time`, `pid`, `chat_cds`) VALUES ('2024-11-22 11:02:53', '2024-11-22 11:02:53', 335879897874433, '{}');
INSERT INTO `player_detail` (`insert_time`, `update_time`, `pid`, `chat_cds`) VALUES ('2024-11-22 11:37:15', '2024-11-22 11:37:15', 335879897874434, '{}');
COMMIT;

-- ----------------------------
-- Table structure for privilege_boost
-- ----------------------------
DROP TABLE IF EXISTS `privilege_boost`;
CREATE TABLE `privilege_boost` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `privilege_list` varchar(500) DEFAULT '' COMMENT '特权ID',
  `vip_gift` varchar(500) DEFAULT '' COMMENT '已购买的vip等级礼包',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='特权加成表';

-- ----------------------------
-- Records of privilege_boost
-- ----------------------------
BEGIN;
INSERT INTO `privilege_boost` (`insert_time`, `update_time`, `pid`, `privilege_list`, `vip_gift`) VALUES ('2024-11-22 11:02:53', '2024-11-22 11:02:53', 335879897874433, '[]', '[]');
INSERT INTO `privilege_boost` (`insert_time`, `update_time`, `pid`, `privilege_list`, `vip_gift`) VALUES ('2024-11-22 11:37:12', '2024-11-22 11:37:12', 335879897874434, '[]', '[]');
COMMIT;

-- ----------------------------
-- Table structure for privilege_normal
-- ----------------------------
DROP TABLE IF EXISTS `privilege_normal`;
CREATE TABLE `privilege_normal` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `exp_pool` bigint(20) DEFAULT '0' COMMENT '角色经验池',
  `datas` varchar(1000) DEFAULT '' COMMENT '特权数据',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='普通特权表';

-- ----------------------------
-- Records of privilege_normal
-- ----------------------------
BEGIN;
INSERT INTO `privilege_normal` (`insert_time`, `update_time`, `pid`, `daily_time`, `exp_pool`, `datas`) VALUES ('2024-11-22 11:02:42', '2024-11-22 11:02:42', 335879897874433, '2024-11-22 11:02:10', 0, '{}');
INSERT INTO `privilege_normal` (`insert_time`, `update_time`, `pid`, `daily_time`, `exp_pool`, `datas`) VALUES ('2024-11-22 11:37:56', '2024-11-22 11:37:56', 335879897874434, '2024-11-23 05:00:00', 0, '{}');
COMMIT;

-- ----------------------------
-- Table structure for promotion_control
-- ----------------------------
DROP TABLE IF EXISTS `promotion_control`;
CREATE TABLE `promotion_control` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '唯一ID',
  `logic_type` int(11) DEFAULT '0' COMMENT '活动逻辑类型',
  `type_id` int(11) DEFAULT '0' COMMENT '活动类型ID',
  `name` varchar(255) DEFAULT '' COMMENT '活动名字',
  `stage` varchar(255) DEFAULT '' COMMENT '活动所在阶段',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `still_time` datetime DEFAULT NULL COMMENT '沉寂时间',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `idle_time` datetime DEFAULT NULL COMMENT '空闲时间',
  `settled` char(5) DEFAULT 'false' COMMENT '是否已结算',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `turns` int(11) DEFAULT '0' COMMENT '活动轮数',
  `config_id` int(11) DEFAULT '0' COMMENT '使用的配置ID',
  `settle_turns` int(11) DEFAULT '0' COMMENT '当前结算的活动轮数',
  `terminate` char(5) DEFAULT 'false' COMMENT '活动已经终结，不会再开',
  PRIMARY KEY (`id`),
  UNIQUE KEY `serverid_typeid` (`server_id`,`type_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000012 DEFAULT CHARSET=utf8mb4 COMMENT='活动控制表';

-- ----------------------------
-- Records of promotion_control
-- ----------------------------
BEGIN;
INSERT INTO `promotion_control` (`insert_time`, `update_time`, `id`, `logic_type`, `type_id`, `name`, `stage`, `start_time`, `still_time`, `end_time`, `idle_time`, `settled`, `server_id`, `turns`, `config_id`, `settle_turns`, `terminate`) VALUES ('2024-11-21 18:31:36', '2025-02-27 09:47:38', 100000001, 1001, 1001001, '循环活动-活跃战令', 'IDLE', '2025-02-27 09:47:25', '2025-03-29 09:47:25', '2025-03-29 09:47:25', '2025-03-29 09:47:25', 'false', 1, 3, 0, 1, 'false');
INSERT INTO `promotion_control` (`insert_time`, `update_time`, `id`, `logic_type`, `type_id`, `name`, `stage`, `start_time`, `still_time`, `end_time`, `idle_time`, `settled`, `server_id`, `turns`, `config_id`, `settle_turns`, `terminate`) VALUES ('2024-11-21 18:31:36', '2024-11-21 18:31:59', 100000002, 1002, 1002001, '等级战令', 'RUNNING', '2024-11-21 05:00:00', '2027-08-17 05:00:00', '2027-08-17 05:00:00', '2027-08-17 05:00:00', 'false', 1, 1, 0, 0, 'false');
INSERT INTO `promotion_control` (`insert_time`, `update_time`, `id`, `logic_type`, `type_id`, `name`, `stage`, `start_time`, `still_time`, `end_time`, `idle_time`, `settled`, `server_id`, `turns`, `config_id`, `settle_turns`, `terminate`) VALUES ('2024-11-21 18:31:36', '2025-02-27 09:47:38', 100000003, 1002, 1002004, '循环活动-招募战令', 'IDLE', '2025-02-27 09:47:25', '2025-03-14 09:47:25', '2025-03-14 09:47:25', '2025-03-14 09:47:25', 'false', 1, 3, 0, 1, 'false');
INSERT INTO `promotion_control` (`insert_time`, `update_time`, `id`, `logic_type`, `type_id`, `name`, `stage`, `start_time`, `still_time`, `end_time`, `idle_time`, `settled`, `server_id`, `turns`, `config_id`, `settle_turns`, `terminate`) VALUES ('2024-11-21 18:31:36', '2025-02-27 09:47:38', 100000004, 1008, 1008001, '开服活动-伙伴战力榜', 'IDLE', '2024-11-21 05:00:00', '2024-11-28 05:00:00', '2024-11-28 05:00:00', '2024-11-28 05:00:00', 'false', 1, 2, 0, 1, 'true');
INSERT INTO `promotion_control` (`insert_time`, `update_time`, `id`, `logic_type`, `type_id`, `name`, `stage`, `start_time`, `still_time`, `end_time`, `idle_time`, `settled`, `server_id`, `turns`, `config_id`, `settle_turns`, `terminate`) VALUES ('2024-11-21 18:31:36', '2025-02-27 09:47:38', 100000005, 1009, 1009001, '开服活动-伙伴直购', 'IDLE', '2024-11-21 05:00:00', '2024-11-28 05:00:00', '2024-11-28 05:00:00', '2024-11-28 05:00:00', 'false', 1, 2, 0, 1, 'true');
INSERT INTO `promotion_control` (`insert_time`, `update_time`, `id`, `logic_type`, `type_id`, `name`, `stage`, `start_time`, `still_time`, `end_time`, `idle_time`, `settled`, `server_id`, `turns`, `config_id`, `settle_turns`, `terminate`) VALUES ('2024-11-21 18:31:36', '2025-02-27 09:47:38', 100000006, 1010, 1010004, '开服活动-累计充值', 'IDLE', '2024-11-21 05:00:00', '2024-11-28 05:00:00', '2024-11-28 05:00:00', '2024-11-28 05:00:00', 'false', 1, 1, 0, 0, 'true');
INSERT INTO `promotion_control` (`insert_time`, `update_time`, `id`, `logic_type`, `type_id`, `name`, `stage`, `start_time`, `still_time`, `end_time`, `idle_time`, `settled`, `server_id`, `turns`, `config_id`, `settle_turns`, `terminate`) VALUES ('2024-11-21 18:31:36', '2025-02-27 09:47:38', 100000007, 1011, 1011001, '开服活动-每日充值', 'IDLE', '2024-11-21 05:00:00', '2024-11-28 05:00:00', '2024-11-28 05:00:00', '2024-11-28 05:00:00', 'false', 1, 2, 0, 1, 'true');
INSERT INTO `promotion_control` (`insert_time`, `update_time`, `id`, `logic_type`, `type_id`, `name`, `stage`, `start_time`, `still_time`, `end_time`, `idle_time`, `settled`, `server_id`, `turns`, `config_id`, `settle_turns`, `terminate`) VALUES ('2024-11-21 18:31:36', '2025-02-27 09:47:38', 100000008, 1010, 1010001, '开服活动-伙伴目标', 'IDLE', '2024-11-21 05:00:00', '2024-11-28 05:00:00', '2024-11-28 05:00:00', '2024-11-28 05:00:00', 'false', 1, 2, 0, 1, 'true');
INSERT INTO `promotion_control` (`insert_time`, `update_time`, `id`, `logic_type`, `type_id`, `name`, `stage`, `start_time`, `still_time`, `end_time`, `idle_time`, `settled`, `server_id`, `turns`, `config_id`, `settle_turns`, `terminate`) VALUES ('2024-11-21 18:31:36', '2025-02-27 09:47:38', 100000009, 1008, 1008101, '周主题-伙伴招募榜', 'IDLE', '2025-02-27 09:47:25', '2025-03-06 09:47:25', '2025-03-06 09:47:25', '2025-03-27 09:47:25', 'false', 1, 3, 0, 1, 'false');
INSERT INTO `promotion_control` (`insert_time`, `update_time`, `id`, `logic_type`, `type_id`, `name`, `stage`, `start_time`, `still_time`, `end_time`, `idle_time`, `settled`, `server_id`, `turns`, `config_id`, `settle_turns`, `terminate`) VALUES ('2024-11-21 18:31:36', '2025-02-27 09:47:38', 100000010, 1009, 1009101, '周主题-伙伴直购', 'IDLE', '2025-02-27 09:47:25', '2025-03-06 09:47:25', '2025-03-06 09:47:25', '2025-03-27 09:47:25', 'false', 1, 3, 0, 1, 'false');
INSERT INTO `promotion_control` (`insert_time`, `update_time`, `id`, `logic_type`, `type_id`, `name`, `stage`, `start_time`, `still_time`, `end_time`, `idle_time`, `settled`, `server_id`, `turns`, `config_id`, `settle_turns`, `terminate`) VALUES ('2024-11-21 18:31:36', '2025-02-27 09:47:38', 100000011, 1010, 1010101, '周主题-伙伴目标', 'IDLE', '2025-02-27 09:47:25', '2025-03-06 09:47:25', '2025-03-06 09:47:25', '2025-03-27 09:47:25', 'false', 1, 3, 0, 1, 'false');
COMMIT;

-- ----------------------------
-- Table structure for purgatory
-- ----------------------------
DROP TABLE IF EXISTS `purgatory`;
CREATE TABLE `purgatory` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `round` int(11) DEFAULT '0' COMMENT '赛季标识',
  `level` int(11) DEFAULT '0' COMMENT '当前阶数',
  `attrs` text COMMENT '加成',
  `free_times` int(11) DEFAULT '0' COMMENT '已使用免费加成次数',
  `plus_times` int(11) DEFAULT '0' COMMENT '购买的剩余加成次数',
  `refine_times` int(11) DEFAULT '0' COMMENT '洗练次数',
  `daily_time` datetime DEFAULT NULL COMMENT '日重置时间',
  `points` bigint(20) DEFAULT '0' COMMENT '炼狱积分',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='炼狱轮回';

-- ----------------------------
-- Records of purgatory
-- ----------------------------
BEGIN;
INSERT INTO `purgatory` (`insert_time`, `update_time`, `pid`, `round`, `level`, `attrs`, `free_times`, `plus_times`, `refine_times`, `daily_time`, `points`) VALUES ('2024-11-22 11:02:42', '2024-11-22 11:02:42', 335879897874433, 1, 0, '{}', 0, 0, 0, '2024-11-22 11:02:10', 0);
INSERT INTO `purgatory` (`insert_time`, `update_time`, `pid`, `round`, `level`, `attrs`, `free_times`, `plus_times`, `refine_times`, `daily_time`, `points`) VALUES ('2024-11-22 11:37:57', '2024-11-22 11:37:57', 335879897874434, 1, 0, '{}', 0, 0, 0, '2024-11-23 05:00:00', 0);
COMMIT;

-- ----------------------------
-- Table structure for purgatory_system
-- ----------------------------
DROP TABLE IF EXISTS `purgatory_system`;
CREATE TABLE `purgatory_system` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `server_id` int(11) NOT NULL COMMENT '服务器ID',
  `round` int(11) DEFAULT '0' COMMENT '赛季',
  `next_reset_time` datetime DEFAULT NULL COMMENT '下次重置时间',
  PRIMARY KEY (`server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='炼狱轮回赛季表';

-- ----------------------------
-- Records of purgatory_system
-- ----------------------------
BEGIN;
INSERT INTO `purgatory_system` (`insert_time`, `update_time`, `server_id`, `round`, `next_reset_time`) VALUES ('2024-11-22 11:02:10', '2024-11-22 11:02:10', 1, 1, '2024-11-28 18:31:35');
COMMIT;

-- ----------------------------
-- Table structure for rank_player
-- ----------------------------
DROP TABLE IF EXISTS `rank_player`;
CREATE TABLE `rank_player` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `type_rewards` varchar(5000) DEFAULT '' COMMENT '类型和奖励领取情况',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='排行榜玩家奖励记录表';

-- ----------------------------
-- Records of rank_player
-- ----------------------------
BEGIN;
INSERT INTO `rank_player` (`insert_time`, `update_time`, `pid`, `type_rewards`) VALUES ('2024-11-22 11:02:53', '2024-11-22 11:02:53', 335879897874433, '{}');
INSERT INTO `rank_player` (`insert_time`, `update_time`, `pid`, `type_rewards`) VALUES ('2024-11-22 11:38:06', '2024-11-22 11:38:06', 335879897874434, '{}');
COMMIT;

-- ----------------------------
-- Table structure for rank_reward
-- ----------------------------
DROP TABLE IF EXISTS `rank_reward`;
CREATE TABLE `rank_reward` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `type` int(11) NOT NULL COMMENT '排行榜类型',
  `name` varchar(255) DEFAULT '' COMMENT '排行榜名称',
  `reward_id` int(11) DEFAULT '0' COMMENT '奖励ID',
  `max_score` bigint(20) DEFAULT '0' COMMENT '历史最高分',
  `first_reachs` text COMMENT '首位达成',
  PRIMARY KEY (`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='排行榜奖励达成表';

-- ----------------------------
-- Records of rank_reward
-- ----------------------------
BEGIN;
INSERT INTO `rank_reward` (`insert_time`, `update_time`, `type`, `name`, `reward_id`, `max_score`, `first_reachs`) VALUES ('2024-11-21 18:31:35', '2024-11-22 11:46:16', 1, '等级排行榜', 0, 3, '{}');
INSERT INTO `rank_reward` (`insert_time`, `update_time`, `type`, `name`, `reward_id`, `max_score`, `first_reachs`) VALUES ('2024-11-21 18:31:35', '2024-11-22 11:38:16', 2, '主线战力排行榜', 0, 1043, '{}');
INSERT INTO `rank_reward` (`insert_time`, `update_time`, `type`, `name`, `reward_id`, `max_score`, `first_reachs`) VALUES ('2024-11-21 18:31:35', '2024-11-22 11:38:16', 3, '英雄基础战力排行榜', 0, 1043, '{}');
INSERT INTO `rank_reward` (`insert_time`, `update_time`, `type`, `name`, `reward_id`, `max_score`, `first_reachs`) VALUES ('2024-11-21 18:31:35', '2024-11-21 18:31:35', 4, '装备排行榜', 0, 0, '{}');
INSERT INTO `rank_reward` (`insert_time`, `update_time`, `type`, `name`, `reward_id`, `max_score`, `first_reachs`) VALUES ('2024-11-21 18:31:35', '2024-11-21 18:31:35', 5, '炼狱轮回阶数排行榜', 0, 0, '{}');
INSERT INTO `rank_reward` (`insert_time`, `update_time`, `type`, `name`, `reward_id`, `max_score`, `first_reachs`) VALUES ('2024-11-21 18:31:35', '2024-11-21 18:31:35', 6, '村庄保卫关卡排行榜', 0, 0, '{}');
INSERT INTO `rank_reward` (`insert_time`, `update_time`, `type`, `name`, `reward_id`, `max_score`, `first_reachs`) VALUES ('2024-11-21 18:31:35', '2024-11-22 11:38:16', 7, '迷雾解锁排行榜', 0, 1, '{}');
INSERT INTO `rank_reward` (`insert_time`, `update_time`, `type`, `name`, `reward_id`, `max_score`, `first_reachs`) VALUES ('2024-11-21 18:31:35', '2024-11-21 18:31:35', 8, '伙伴招募排行榜，活动', 0, 0, '{}');
INSERT INTO `rank_reward` (`insert_time`, `update_time`, `type`, `name`, `reward_id`, `max_score`, `first_reachs`) VALUES ('2024-11-21 18:31:35', '2024-11-21 18:31:35', 9, '装备招募排行榜，活动', 0, 0, '{}');
INSERT INTO `rank_reward` (`insert_time`, `update_time`, `type`, `name`, `reward_id`, `max_score`, `first_reachs`) VALUES ('2024-11-21 18:31:35', '2024-11-21 18:31:35', 10, '法宝招募排行榜，活动', 0, 0, '{}');
INSERT INTO `rank_reward` (`insert_time`, `update_time`, `type`, `name`, `reward_id`, `max_score`, `first_reachs`) VALUES ('2024-11-21 18:31:35', '2024-11-21 18:31:35', 11, '普通塔排行榜', 0, 0, '{}');
COMMIT;

-- ----------------------------
-- Table structure for ranker
-- ----------------------------
DROP TABLE IF EXISTS `ranker`;
CREATE TABLE `ranker` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` varchar(255) NOT NULL COMMENT '唯一ID，排行榜类型_数据标识（玩家ID、公会ID等等）',
  `rank_type` int(11) DEFAULT '0' COMMENT '排行榜类型',
  `rank_desc` varchar(255) DEFAULT '' COMMENT '排行榜类型描述',
  `entity_id` bigint(20) DEFAULT '0' COMMENT '实体ID，不同排行榜，实体ID有不同语意',
  `name` varchar(255) DEFAULT '' COMMENT '实体的名字，只是用来在数据库上看的',
  `score` bigint(20) DEFAULT '0' COMMENT '分数',
  `sub_score` bigint(20) DEFAULT '0' COMMENT '二级分数',
  `time` bigint(20) DEFAULT '0' COMMENT '进榜时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='排行榜表';

-- ----------------------------
-- Records of ranker
-- ----------------------------
BEGIN;
INSERT INTO `ranker` (`insert_time`, `update_time`, `id`, `rank_type`, `rank_desc`, `entity_id`, `name`, `score`, `sub_score`, `time`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:38:05', 'FIGHTING_335879897874434', 2, '主线战力排行榜', 335879897874434, '方昊乾', 1043, 0, 1732246673785);
INSERT INTO `ranker` (`insert_time`, `update_time`, `id`, `rank_type`, `rank_desc`, `entity_id`, `name`, `score`, `sub_score`, `time`) VALUES ('2024-11-22 11:38:09', '2024-11-22 11:38:09', 'FOG_335879897874434', 7, '迷雾解锁排行榜', 335879897874434, '方昊乾', 1, 0, 1732246689450);
INSERT INTO `ranker` (`insert_time`, `update_time`, `id`, `rank_type`, `rank_desc`, `entity_id`, `name`, `score`, `sub_score`, `time`) VALUES ('2024-11-22 11:37:06', '2024-11-22 11:38:05', 'HERO_335879897874434', 3, '英雄基础战力排行榜', 335879897874434, '方昊乾', 1043, 0, 1732246673785);
INSERT INTO `ranker` (`insert_time`, `update_time`, `id`, `rank_type`, `rank_desc`, `entity_id`, `name`, `score`, `sub_score`, `time`) VALUES ('2024-11-22 11:39:23', '2024-11-22 11:46:05', 'LEVEL_335879897874434', 1, '等级排行榜', 335879897874434, '方昊乾', 3, 0, 1732247133526);
COMMIT;

-- ----------------------------
-- Table structure for recharge
-- ----------------------------
DROP TABLE IF EXISTS `recharge`;
CREATE TABLE `recharge` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` varchar(255) NOT NULL COMMENT '唯一ID',
  `player_id` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `nick` varchar(255) DEFAULT '' COMMENT '玩家名称',
  `player_lv` int(11) DEFAULT '0' COMMENT '玩家下单时的等级',
  `product_id` int(11) DEFAULT '0' COMMENT '商品ID',
  `product_name` varchar(255) DEFAULT '' COMMENT '商品名称',
  `product_code` varchar(255) DEFAULT '' COMMENT '商品编码',
  `server_id` int(11) DEFAULT '0' COMMENT '服务器ID',
  `pre_pay_money` bigint(20) DEFAULT '0' COMMENT '预付金额',
  `pay_money` bigint(20) DEFAULT '0' COMMENT '实付金额',
  `status` int(11) DEFAULT '0' COMMENT '发货状态，0未处理，1成功，2失败',
  `give_time` datetime DEFAULT NULL COMMENT '发货时间',
  `backstage_order_id` varchar(255) DEFAULT '' COMMENT '回调时的后台订单号',
  `extra_info` varchar(255) DEFAULT '' COMMENT '透传参数',
  `product_data` varchar(1000) DEFAULT '' COMMENT '商品数据，由客户端传递',
  `test` char(5) DEFAULT 'false' COMMENT '是否测试订单',
  `virtual` char(5) DEFAULT 'false' COMMENT '是否虚拟订单（GM订单）',
  `game_cause` int(11) DEFAULT '0' COMMENT '游戏事件',
  `game_cause_text` varchar(255) DEFAULT '' COMMENT '游戏事件',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='充值表';

-- ----------------------------
-- Records of recharge
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for recharge_player
-- ----------------------------
DROP TABLE IF EXISTS `recharge_player`;
CREATE TABLE `recharge_player` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `total_pay` bigint(20) DEFAULT '0' COMMENT '历史总支付金额（含虚拟充值）',
  `real_total_pay` bigint(20) DEFAULT '0' COMMENT '真实历史总支付金额（不含虚拟充值）',
  `daily_pay` bigint(20) DEFAULT '0' COMMENT '今日支付金额（含虚拟充值）',
  `real_daily_pay` bigint(20) DEFAULT '0' COMMENT '真实今日支付金额（不含虚拟充值）',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `buy_products` text COMMENT '购买过的充值商品',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='玩家充值数据表';

-- ----------------------------
-- Records of recharge_player
-- ----------------------------
BEGIN;
INSERT INTO `recharge_player` (`insert_time`, `update_time`, `pid`, `total_pay`, `real_total_pay`, `daily_pay`, `real_daily_pay`, `daily_time`, `buy_products`) VALUES ('2024-11-22 11:02:12', '2024-11-22 11:03:12', 335879897874433, 0, 0, 0, 0, '2024-11-23 05:00:00', '[]');
INSERT INTO `recharge_player` (`insert_time`, `update_time`, `pid`, `total_pay`, `real_total_pay`, `daily_pay`, `real_daily_pay`, `daily_time`, `buy_products`) VALUES ('2024-11-22 11:37:11', '2024-11-22 11:37:11', 335879897874434, 0, 0, 0, 0, '2024-11-23 05:00:00', '[]');
COMMIT;

-- ----------------------------
-- Table structure for recruit
-- ----------------------------
DROP TABLE IF EXISTS `recruit`;
CREATE TABLE `recruit` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `points` bigint(20) DEFAULT '0' COMMENT '积分',
  `recruit_num` int(11) DEFAULT '0' COMMENT '抽取次数',
  `stage` int(11) DEFAULT '0' COMMENT '阶段',
  `stage_num` int(11) DEFAULT '0' COMMENT '当前阶段召唤的次数',
  `stage_up_weight` char(5) DEFAULT 'false' COMMENT '当前阶段提升权重的机会是否已经使用',
  `recruit_data` varchar(600) DEFAULT '' COMMENT '抽卡列表',
  `discount_num` int(11) DEFAULT '0' COMMENT '今日已使用折扣次数',
  `ad_free_num` int(11) DEFAULT '0' COMMENT '已观看广告次数',
  `multiple` int(11) DEFAULT '0' COMMENT '当前使用的倍数',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `last_refresh_time` bigint(20) DEFAULT '0' COMMENT '上次刷新时间',
  `draw_nums` varchar(255) DEFAULT '' COMMENT '抽奖项已抽奖次数',
  `today_recruit` int(11) DEFAULT '0' COMMENT '今天已抽奖次数',
  `hand_refresh` int(11) DEFAULT '0' COMMENT '手动刷新次数',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='招募表';

-- ----------------------------
-- Records of recruit
-- ----------------------------
BEGIN;
INSERT INTO `recruit` (`insert_time`, `update_time`, `pid`, `points`, `recruit_num`, `stage`, `stage_num`, `stage_up_weight`, `recruit_data`, `discount_num`, `ad_free_num`, `multiple`, `daily_time`, `last_refresh_time`, `draw_nums`, `today_recruit`, `hand_refresh`) VALUES ('2024-11-22 11:02:42', '2024-11-22 11:02:42', 335879897874433, 0, 0, 3, 0, 'false', '[{\"identity\":1020001,\"fragment\":15,\"weight\":0,\"score\":20,\"multiple\":1,\"crit\":true,\"take\":false},{\"identity\":1030007,\"fragment\":28,\"weight\":10000,\"score\":5,\"multiple\":1,\"crit\":false,\"take\":false},{\"identity\":1010005,\"fragment\":5,\"weight\":0,\"score\":5,\"multiple\":1,\"crit\":false,\"take\":false}]', 0, 0, 0, '2024-11-22 11:02:10', 0, '{}', 0, 0);
INSERT INTO `recruit` (`insert_time`, `update_time`, `pid`, `points`, `recruit_num`, `stage`, `stage_num`, `stage_up_weight`, `recruit_data`, `discount_num`, `ad_free_num`, `multiple`, `daily_time`, `last_refresh_time`, `draw_nums`, `today_recruit`, `hand_refresh`) VALUES ('2024-11-22 11:38:00', '2024-11-22 11:38:00', 335879897874434, 0, 0, 3, 0, 'false', '[{\"identity\":1020001,\"fragment\":18,\"weight\":0,\"score\":20,\"multiple\":1,\"crit\":true,\"take\":false},{\"identity\":1030007,\"fragment\":26,\"weight\":10000,\"score\":5,\"multiple\":1,\"crit\":false,\"take\":false},{\"identity\":1010005,\"fragment\":3,\"weight\":0,\"score\":20,\"multiple\":1,\"crit\":true,\"take\":false}]', 0, 0, 0, '2024-11-23 05:00:00', 0, '{}', 0, 0);
COMMIT;

-- ----------------------------
-- Table structure for server_info
-- ----------------------------
DROP TABLE IF EXISTS `server_info`;
CREATE TABLE `server_info` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL COMMENT '服务器ID',
  `opened` char(5) DEFAULT 'false' COMMENT '是否已经开服',
  `maintain` char(5) DEFAULT 'false' COMMENT '是否维护中',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  `open_time` datetime DEFAULT NULL COMMENT '开服时间',
  `online_count_time` datetime DEFAULT NULL COMMENT '在线人数统计时间',
  `online_scatter_time` datetime DEFAULT NULL COMMENT '在线时长占比统计时间',
  `online_5minute_time` datetime DEFAULT NULL COMMENT '5分钟在线人数统计时间',
  `resume_count_time` datetime DEFAULT NULL COMMENT '游戏汇总统计时间',
  `heart_beat_time` datetime DEFAULT NULL COMMENT '心跳时间',
  `cross_ip` varchar(255) DEFAULT '' COMMENT '跨服IP',
  `cross_port` varchar(255) DEFAULT '' COMMENT '跨服端口',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='服务器信息表';

-- ----------------------------
-- Records of server_info
-- ----------------------------
BEGIN;
INSERT INTO `server_info` (`insert_time`, `update_time`, `id`, `opened`, `maintain`, `daily_time`, `open_time`, `online_count_time`, `online_scatter_time`, `online_5minute_time`, `resume_count_time`, `heart_beat_time`, `cross_ip`, `cross_port`) VALUES ('2024-11-21 18:31:35', '2025-02-28 11:02:52', 1, 'true', 'false', '2025-03-01 05:00:00', '2024-11-21 18:31:35', '2025-02-28 11:30:00', '2025-03-01 05:05:00', '2025-02-28 11:17:37', '2025-03-01 00:00:00', '2025-02-28 11:03:03', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for shop_player
-- ----------------------------
DROP TABLE IF EXISTS `shop_player`;
CREATE TABLE `shop_player` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `shop_id` int(11) DEFAULT '0' COMMENT '商城Id',
  `increase_round` int(11) DEFAULT '0' COMMENT '递增轮次',
  `product_detail` varchar(5000) DEFAULT '' COMMENT '商品详情',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100000006 DEFAULT CHARSET=utf8mb4 COMMENT='兑换商城记录表';

-- ----------------------------
-- Records of shop_player
-- ----------------------------
BEGIN;
INSERT INTO `shop_player` (`insert_time`, `update_time`, `id`, `pid`, `shop_id`, `increase_round`, `product_detail`) VALUES ('2024-11-22 11:37:09', '2024-11-22 11:37:54', 100000001, 335879897874434, 10010, 1, '{}');
INSERT INTO `shop_player` (`insert_time`, `update_time`, `id`, `pid`, `shop_id`, `increase_round`, `product_detail`) VALUES ('2024-11-22 11:37:09', '2024-11-22 11:37:54', 100000002, 335879897874434, 10001, 1, '{}');
INSERT INTO `shop_player` (`insert_time`, `update_time`, `id`, `pid`, `shop_id`, `increase_round`, `product_detail`) VALUES ('2024-11-22 11:37:09', '2024-11-22 11:37:54', 100000003, 335879897874434, 10004, 1, '{}');
INSERT INTO `shop_player` (`insert_time`, `update_time`, `id`, `pid`, `shop_id`, `increase_round`, `product_detail`) VALUES ('2024-11-22 11:37:09', '2024-11-22 11:37:54', 100000004, 335879897874434, 10003, 1, '{}');
INSERT INTO `shop_player` (`insert_time`, `update_time`, `id`, `pid`, `shop_id`, `increase_round`, `product_detail`) VALUES ('2024-11-22 11:37:09', '2024-11-22 11:37:54', 100000005, 335879897874434, 10002, 1, '{}');
COMMIT;

-- ----------------------------
-- Table structure for shop_system
-- ----------------------------
DROP TABLE IF EXISTS `shop_system`;
CREATE TABLE `shop_system` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `shop_id` int(11) NOT NULL COMMENT '商城ID',
  `config_round` int(11) DEFAULT '0' COMMENT '配置轮次',
  `increase_round` int(11) DEFAULT '0' COMMENT '递增轮次',
  `next_reset` datetime DEFAULT NULL COMMENT '下次重置',
  PRIMARY KEY (`shop_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='商店系统表';

-- ----------------------------
-- Records of shop_system
-- ----------------------------
BEGIN;
INSERT INTO `shop_system` (`insert_time`, `update_time`, `shop_id`, `config_round`, `increase_round`, `next_reset`) VALUES ('2024-11-22 11:37:09', '2024-11-22 11:37:09', 10001, 1, 1, '2024-11-28 18:31:35');
INSERT INTO `shop_system` (`insert_time`, `update_time`, `shop_id`, `config_round`, `increase_round`, `next_reset`) VALUES ('2024-11-22 11:37:09', '2024-11-22 11:37:09', 10002, 1, 1, '2024-11-28 18:31:35');
INSERT INTO `shop_system` (`insert_time`, `update_time`, `shop_id`, `config_round`, `increase_round`, `next_reset`) VALUES ('2024-11-22 11:37:09', '2024-11-22 11:37:09', 10003, 1, 1, '2024-11-28 18:31:35');
INSERT INTO `shop_system` (`insert_time`, `update_time`, `shop_id`, `config_round`, `increase_round`, `next_reset`) VALUES ('2024-11-22 11:37:09', '2024-11-22 11:37:09', 10004, 1, 1, '2024-11-28 18:31:35');
INSERT INTO `shop_system` (`insert_time`, `update_time`, `shop_id`, `config_round`, `increase_round`, `next_reset`) VALUES ('2024-11-22 11:37:09', '2024-11-22 11:37:09', 10010, 1, 1, '2024-11-23 05:00:00');
COMMIT;

-- ----------------------------
-- Table structure for tower
-- ----------------------------
DROP TABLE IF EXISTS `tower`;
CREATE TABLE `tower` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `normal_layer` int(11) DEFAULT '0' COMMENT '普通塔已通关层数',
  `strength_layer` int(11) DEFAULT '0' COMMENT '力量塔已通关层数',
  `agility_layer` int(11) DEFAULT '0' COMMENT '敏捷塔已通关层数',
  `wisdom_layer` int(11) DEFAULT '0' COMMENT '智力塔已通关层数',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='试练塔数据表';

-- ----------------------------
-- Records of tower
-- ----------------------------
BEGIN;
INSERT INTO `tower` (`insert_time`, `update_time`, `pid`, `normal_layer`, `strength_layer`, `agility_layer`, `wisdom_layer`, `daily_time`) VALUES ('2024-11-22 11:03:03', '2024-11-22 11:03:03', 335879897874433, 0, 0, 0, 0, '2024-11-22 11:02:10');
INSERT INTO `tower` (`insert_time`, `update_time`, `pid`, `normal_layer`, `strength_layer`, `agility_layer`, `wisdom_layer`, `daily_time`) VALUES ('2024-11-22 11:37:56', '2024-11-22 11:37:56', 335879897874434, 0, 0, 0, 0, '2024-11-23 05:00:00');
COMMIT;

-- ----------------------------
-- Table structure for training_camp
-- ----------------------------
DROP TABLE IF EXISTS `training_camp`;
CREATE TABLE `training_camp` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `max_peoples` int(11) DEFAULT '0' COMMENT '高级训练解锁的上阵人数',
  `level` int(11) DEFAULT '0' COMMENT '普通训练等级',
  `expert_level` int(11) DEFAULT '0' COMMENT '高级训练等级',
  `daily_time` datetime DEFAULT NULL COMMENT '每日重置时间',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='训练营表';

-- ----------------------------
-- Records of training_camp
-- ----------------------------
BEGIN;
INSERT INTO `training_camp` (`insert_time`, `update_time`, `pid`, `max_peoples`, `level`, `expert_level`, `daily_time`) VALUES ('2024-11-22 11:02:43', '2024-11-22 11:02:43', 335879897874433, 0, 0, 0, '2024-11-23 05:00:00');
INSERT INTO `training_camp` (`insert_time`, `update_time`, `pid`, `max_peoples`, `level`, `expert_level`, `daily_time`) VALUES ('2024-11-22 11:37:54', '2024-11-22 11:37:54', 335879897874434, 0, 0, 0, '2024-11-23 05:00:00');
COMMIT;

-- ----------------------------
-- Table structure for treasure
-- ----------------------------
DROP TABLE IF EXISTS `treasure`;
CREATE TABLE `treasure` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pid` bigint(20) DEFAULT '0' COMMENT '玩家ID',
  `shop_id` int(11) DEFAULT '0' COMMENT '商城Id',
  `product_detail` varchar(500) DEFAULT '' COMMENT '商品详情',
  `limit_product_detail` varchar(500) DEFAULT '' COMMENT '终生限购商品详情',
  `period` int(11) DEFAULT '0' COMMENT '当前期数',
  `next_reset_time` datetime DEFAULT NULL COMMENT '下次重置时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `pid_shopid` (`pid`,`shop_id`) USING BTREE,
  KEY `pid` (`pid`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=100000005 DEFAULT CHARSET=utf8mb4 COMMENT='珍宝阁购买记录表';

-- ----------------------------
-- Records of treasure
-- ----------------------------
BEGIN;
INSERT INTO `treasure` (`insert_time`, `update_time`, `id`, `pid`, `shop_id`, `product_detail`, `limit_product_detail`, `period`, `next_reset_time`) VALUES ('2024-11-22 11:37:08', '2024-11-22 11:38:00', 100000001, 335879897874434, 10005, '{}', '{}', 1, '2032-08-01 00:00:00');
INSERT INTO `treasure` (`insert_time`, `update_time`, `id`, `pid`, `shop_id`, `product_detail`, `limit_product_detail`, `period`, `next_reset_time`) VALUES ('2024-11-22 11:37:08', '2024-11-22 11:38:00', 100000002, 335879897874434, 10007, '{}', '{}', 1, '2024-11-23 05:00:00');
INSERT INTO `treasure` (`insert_time`, `update_time`, `id`, `pid`, `shop_id`, `product_detail`, `limit_product_detail`, `period`, `next_reset_time`) VALUES ('2024-11-22 11:37:08', '2024-11-22 11:38:00', 100000003, 335879897874434, 10008, '{}', '{}', 1, '2024-11-23 05:00:00');
INSERT INTO `treasure` (`insert_time`, `update_time`, `id`, `pid`, `shop_id`, `product_detail`, `limit_product_detail`, `period`, `next_reset_time`) VALUES ('2024-11-22 11:37:08', '2024-11-22 11:38:00', 100000004, 335879897874434, 10009, '{}', '{}', 1, '2024-11-25 05:00:00');
COMMIT;

-- ----------------------------
-- Table structure for village
-- ----------------------------
DROP TABLE IF EXISTS `village`;
CREATE TABLE `village` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `level` int(11) DEFAULT '0' COMMENT '最大关卡',
  `challenge_times` int(11) DEFAULT '0' COMMENT '今日挑战次数',
  `round` int(11) DEFAULT '0' COMMENT '赛季标识',
  `point` bigint(20) DEFAULT '0' COMMENT '积分',
  `daily_time` datetime DEFAULT NULL COMMENT '日重置时间',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='村庄守卫';

-- ----------------------------
-- Records of village
-- ----------------------------
BEGIN;
INSERT INTO `village` (`insert_time`, `update_time`, `pid`, `level`, `challenge_times`, `round`, `point`, `daily_time`) VALUES ('2024-11-22 11:02:43', '2024-11-22 11:02:43', 335879897874433, 0, 0, 1, 0, '2024-11-22 11:02:10');
INSERT INTO `village` (`insert_time`, `update_time`, `pid`, `level`, `challenge_times`, `round`, `point`, `daily_time`) VALUES ('2024-11-22 11:37:52', '2024-11-22 11:37:52', 335879897874434, 0, 0, 1, 0, '2024-11-23 05:00:00');
COMMIT;

-- ----------------------------
-- Table structure for village_system
-- ----------------------------
DROP TABLE IF EXISTS `village_system`;
CREATE TABLE `village_system` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `server_id` int(11) NOT NULL COMMENT '服务器ID',
  `round` int(11) DEFAULT '0' COMMENT '赛季',
  `next_reset_time` datetime DEFAULT NULL COMMENT '下次重置时间',
  PRIMARY KEY (`server_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='村庄守卫赛季表';

-- ----------------------------
-- Records of village_system
-- ----------------------------
BEGIN;
INSERT INTO `village_system` (`insert_time`, `update_time`, `server_id`, `round`, `next_reset_time`) VALUES ('2024-11-22 11:37:08', '2024-11-22 11:37:08', 1, 1, '2024-11-25 05:00:00');
COMMIT;

-- ----------------------------
-- Table structure for weekly_task
-- ----------------------------
DROP TABLE IF EXISTS `weekly_task`;
CREATE TABLE `weekly_task` (
  `insert_time` datetime DEFAULT NULL COMMENT '插入时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `pid` bigint(20) NOT NULL COMMENT '玩家ID',
  `week_points` bigint(20) DEFAULT '0' COMMENT '周常积分',
  `week_point_reward` varchar(255) DEFAULT '' COMMENT '已领周常活跃奖励',
  `weekly_tasks` text COMMENT '周常任务列表',
  `weekly_time` datetime DEFAULT NULL COMMENT '周重置时间',
  PRIMARY KEY (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='周常任务表';

-- ----------------------------
-- Records of weekly_task
-- ----------------------------
BEGIN;
INSERT INTO `weekly_task` (`insert_time`, `update_time`, `pid`, `week_points`, `week_point_reward`, `weekly_tasks`, `weekly_time`) VALUES ('2024-11-22 11:02:53', '2024-11-22 11:02:53', 335879897874433, 0, '[]', '[{\"id\":20001,\"process\":1,\"status\":0},{\"id\":20002,\"process\":0,\"status\":0},{\"id\":20003,\"process\":0,\"status\":0},{\"id\":20004,\"process\":0,\"status\":0},{\"id\":20005,\"process\":0,\"status\":0},{\"id\":20006,\"process\":0,\"status\":0},{\"id\":20007,\"process\":0,\"status\":0}]', '2024-11-25 05:00:00');
INSERT INTO `weekly_task` (`insert_time`, `update_time`, `pid`, `week_points`, `week_point_reward`, `weekly_tasks`, `weekly_time`) VALUES ('2024-11-22 11:37:21', '2024-11-22 11:50:21', 335879897874434, 0, '[]', '[{\"id\":20001,\"process\":1,\"status\":0},{\"id\":20002,\"process\":0,\"status\":0},{\"id\":20003,\"process\":0,\"status\":0},{\"id\":20004,\"process\":0,\"status\":0},{\"id\":20005,\"process\":63,\"status\":0},{\"id\":20006,\"process\":0,\"status\":0},{\"id\":20007,\"process\":63,\"status\":0}]', '2024-11-25 05:00:00');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;