/* 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;