-- 数据库结构导出 -- 生成时间: 2025-09-30T09:56:33.481Z CREATE DATABASE IF NOT EXISTS `ryc` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci; USE `ryc`; -- ---------------------------- -- Table structure for t_activity -- ---------------------------- DROP TABLE IF EXISTS `t_activity`; CREATE TABLE `t_activity` ( `id` bigint NOT NULL AUTO_INCREMENT, `pid` bigint NOT NULL DEFAULT '0', `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `sort_order` int DEFAULT NULL COMMENT '阶段的顺序', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `signup_deadline` datetime NOT NULL, `match_time` datetime DEFAULT NULL, `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `rating_scheme_id` bigint NOT NULL, `player_max` int DEFAULT NULL COMMENT '人数上限', `state` int NOT NULL DEFAULT '1' COMMENT '0:未发布， 1：发布：2：关闭', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, KEY `fk_t_activity_rating_scheme` (`rating_scheme_id`) USING BTREE, KEY `idx_t_activity_deadline` (`signup_deadline`) USING BTREE, CONSTRAINT `fk_t_activity_rating_scheme` FOREIGN KEY (`rating_scheme_id`) REFERENCES `t_rating_scheme` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_activity -- ---------------------------- INSERT INTO `t_activity` (`id`, `pid`, `path`, `sort_order`, `name`, `description`, `signup_deadline`, `match_time`, `address`, `rating_scheme_id`, `player_max`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, 0, '/', NULL, '2025', '13让人', 'Fri Oct 03 2025 00:00:00 GMT+0800 (GMT+08:00)', 'Sat Oct 04 2025 00:00:00 GMT+0800 (GMT+08:00)', '13243', 8, NULL, 1, 'Tue Sep 30 2025 12:22:09 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 12:22:09 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_activity` (`id`, `pid`, `path`, `sort_order`, `name`, `description`, `signup_deadline`, `match_time`, `address`, `rating_scheme_id`, `player_max`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (2, 1, '/1/', 1, '海选', '', 'Fri Oct 03 2025 00:00:00 GMT+0800 (GMT+08:00)', 'Sat Oct 04 2025 00:00:00 GMT+0800 (GMT+08:00)', '', 8, NULL, 1, 'Tue Sep 30 2025 12:22:09 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 12:22:09 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_activity` (`id`, `pid`, `path`, `sort_order`, `name`, `description`, `signup_deadline`, `match_time`, `address`, `rating_scheme_id`, `player_max`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (3, 1, '/1/', 2, '复赛', '44444', 'Fri Oct 03 2025 00:00:00 GMT+0800 (GMT+08:00)', 'Tue Oct 07 2025 00:00:00 GMT+0800 (GMT+08:00)', '4444', 8, NULL, 1, 'Tue Sep 30 2025 12:22:09 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 12:22:09 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_activity` (`id`, `pid`, `path`, `sort_order`, `name`, `description`, `signup_deadline`, `match_time`, `address`, `rating_scheme_id`, `player_max`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (4, 0, '/', NULL, '2026', '1111', 'Thu Oct 02 2025 00:00:00 GMT+0800 (GMT+08:00)', 'Sun Oct 05 2025 00:00:00 GMT+0800 (GMT+08:00)', '111', 8, NULL, 1, 'Tue Sep 30 2025 12:27:31 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 12:27:31 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_activity` (`id`, `pid`, `path`, `sort_order`, `name`, `description`, `signup_deadline`, `match_time`, `address`, `rating_scheme_id`, `player_max`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (5, 4, '/4/', 1, '海选', '', 'Thu Oct 02 2025 00:00:00 GMT+0800 (GMT+08:00)', NULL, '', 8, NULL, 1, 'Tue Sep 30 2025 12:27:31 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 12:27:31 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_activity` (`id`, `pid`, `path`, `sort_order`, `name`, `description`, `signup_deadline`, `match_time`, `address`, `rating_scheme_id`, `player_max`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (6, 0, '/', NULL, '2027', '333333', 'Fri Oct 03 2025 00:00:00 GMT+0800 (GMT+08:00)', 'Sat Oct 04 2025 00:00:00 GMT+0800 (GMT+08:00)', '123', 8, NULL, 1, 'Tue Sep 30 2025 12:32:22 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 12:32:22 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_activity` (`id`, `pid`, `path`, `sort_order`, `name`, `description`, `signup_deadline`, `match_time`, `address`, `rating_scheme_id`, `player_max`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (7, 6, '/6/', 1, '海选', '4444', 'Fri Oct 03 2025 00:00:00 GMT+0800 (GMT+08:00)', 'Fri Oct 03 2025 00:00:00 GMT+0800 (GMT+08:00)', '4444', 8, 1000, 1, 'Tue Sep 30 2025 12:32:22 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 13:57:13 GMT+0800 (GMT+08:00)', NULL, 1); INSERT INTO `t_activity` (`id`, `pid`, `path`, `sort_order`, `name`, `description`, `signup_deadline`, `match_time`, `address`, `rating_scheme_id`, `player_max`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (8, 6, '/6/', 2, '复赛', '333333', 'Fri Oct 03 2025 00:00:00 GMT+0800 (GMT+08:00)', 'Sat Oct 04 2025 00:00:00 GMT+0800 (GMT+08:00)', '3333', 8, 100, 1, 'Tue Sep 30 2025 14:04:22 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:04:22 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_activity_judge -- ---------------------------- DROP TABLE IF EXISTS `t_activity_judge`; CREATE TABLE `t_activity_judge` ( `id` bigint NOT NULL AUTO_INCREMENT, `activity_id` bigint NOT NULL, `stage_id` bigint NOT NULL, `judge_id` bigint NOT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int DEFAULT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uq_stage_judge` (`stage_id`,`judge_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_activity_judge -- ---------------------------- INSERT INTO `t_activity_judge` (`id`, `activity_id`, `stage_id`, `judge_id`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, 6, 7, 68, NULL, NULL, 'Tue Sep 30 2025 14:04:38 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:04:38 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_activity_player -- ---------------------------- DROP TABLE IF EXISTS `t_activity_player`; CREATE TABLE `t_activity_player` ( `id` bigint NOT NULL AUTO_INCREMENT, `activity_id` bigint NOT NULL, `stage_id` bigint NOT NULL COMMENT '比赛阶段，逻辑和t_activity_judge 保持一致。', `player_id` bigint NOT NULL, `region_id` bigint DEFAULT NULL COMMENT '区域id', `project_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '参赛项目标题', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `reject_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `judge_id` bigint DEFAULT NULL COMMENT '评委', `feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `total_score` decimal(19,4) DEFAULT NULL COMMENT '低分', `rank` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '名次', `state` int NOT NULL DEFAULT '0' COMMENT '0等待审核，1：审核通过，2：不通过', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_activity_player -- ---------------------------- INSERT INTO `t_activity_player` (`id`, `activity_id`, `stage_id`, `player_id`, `region_id`, `project_name`, `description`, `reject_reason`, `judge_id`, `feedback`, `total_score`, `rank`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, 6, 7, 1, 6, 'AI', 'AI code', NULL, NULL, 'OK', NULL, NULL, 1, 'Tue Sep 30 2025 14:21:08 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:26:18 GMT+0800 (GMT+08:00)', NULL, 1); INSERT INTO `t_activity_player` (`id`, `activity_id`, `stage_id`, `player_id`, `region_id`, `project_name`, `description`, `reject_reason`, `judge_id`, `feedback`, `total_score`, `rank`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (2, 6, 8, 1, 6, 'AI', 'AI code', NULL, NULL, NULL, NULL, NULL, 1, 'Tue Sep 30 2025 17:29:13 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 17:29:13 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_activity_player_rating -- ---------------------------- DROP TABLE IF EXISTS `t_activity_player_rating`; CREATE TABLE `t_activity_player_rating` ( `id` bigint NOT NULL AUTO_INCREMENT, `activity_id` bigint NOT NULL, `activity_player_id` bigint DEFAULT NULL, `rating_scheme_id` bigint DEFAULT NULL COMMENT '评分方案ID', `stage_id` bigint NOT NULL, `player_id` bigint NOT NULL COMMENT '冗余字段', `judge_id` bigint DEFAULT NULL, `total_score` decimal(19,2) DEFAULT NULL, `feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '评价内容', `state` int NOT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- ---------------------------- -- Records of t_activity_player_rating -- ---------------------------- INSERT INTO `t_activity_player_rating` (`id`, `activity_id`, `activity_player_id`, `rating_scheme_id`, `stage_id`, `player_id`, `judge_id`, `total_score`, `feedback`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, 6, 1, 8, 1, 1, 68, 27.00, '哦哦哦', 1, 'Tue Sep 30 2025 14:26:53 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:26:54 GMT+0800 (GMT+08:00)', NULL, 1); -- ---------------------------- -- Table structure for t_activity_player_rating_item -- ---------------------------- DROP TABLE IF EXISTS `t_activity_player_rating_item`; CREATE TABLE `t_activity_player_rating_item` ( `id` bigint NOT NULL AUTO_INCREMENT, `activity_id` bigint NOT NULL, `activity_player_id` bigint NOT NULL, `activity_player_rating_id` bigint NOT NULL, `stage_id` bigint NOT NULL, `player_id` bigint NOT NULL, `judge_id` bigint NOT NULL, `rating_scheme_id` bigint NOT NULL, `rating_item_id` bigint NOT NULL, `score` decimal(10,2) NOT NULL, `feedback` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `state` int NOT NULL DEFAULT '1', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_activity_player_rating_item -- ---------------------------- INSERT INTO `t_activity_player_rating_item` (`id`, `activity_id`, `activity_player_id`, `activity_player_rating_id`, `stage_id`, `player_id`, `judge_id`, `rating_scheme_id`, `rating_item_id`, `score`, `feedback`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, 6, 1, 1, 1, 1, 68, 8, 10, 7.00, NULL, 1, 'Tue Sep 30 2025 14:26:53 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:26:53 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_activity_player_rating_item` (`id`, `activity_id`, `activity_player_id`, `activity_player_rating_id`, `stage_id`, `player_id`, `judge_id`, `rating_scheme_id`, `rating_item_id`, `score`, `feedback`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (2, 6, 1, 1, 1, 1, 68, 8, 11, 12.00, NULL, 1, 'Tue Sep 30 2025 14:26:53 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:26:53 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_activity_player_rating_item` (`id`, `activity_id`, `activity_player_id`, `activity_player_rating_id`, `stage_id`, `player_id`, `judge_id`, `rating_scheme_id`, `rating_item_id`, `score`, `feedback`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (3, 6, 1, 1, 1, 1, 68, 8, 12, 5.00, NULL, 1, 'Tue Sep 30 2025 14:26:53 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:26:53 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_activity_player_rating_item` (`id`, `activity_id`, `activity_player_id`, `activity_player_rating_id`, `stage_id`, `player_id`, `judge_id`, `rating_scheme_id`, `rating_item_id`, `score`, `feedback`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (4, 6, 1, 1, 1, 1, 68, 8, 13, 3.00, NULL, 1, 'Tue Sep 30 2025 14:26:54 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:26:54 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_carousel -- ---------------------------- DROP TABLE IF EXISTS `t_carousel`; CREATE TABLE `t_carousel` ( `id` bigint NOT NULL AUTO_INCREMENT, `title` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `sort_order` int DEFAULT NULL, `state` int NOT NULL DEFAULT '1' COMMENT '0:关闭，1：使用', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='轮播图'; -- ---------------------------- -- Records of t_carousel -- ---------------------------- INSERT INTO `t_carousel` (`id`, `title`, `description`, `sort_order`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, '111', '232322', 1, 1, 'Tue Sep 23 2025 11:06:43 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 11:23:57 GMT+0800 (GMT+08:00)', NULL, 1); INSERT INTO `t_carousel` (`id`, `title`, `description`, `sort_order`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (2, '111123333', '44444', 2, 1, 'Tue Sep 23 2025 17:40:04 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 22:20:55 GMT+0800 (GMT+08:00)', NULL, 1); INSERT INTO `t_carousel` (`id`, `title`, `description`, `sort_order`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (3, '2026', '1111', 999, 1, 'Fri Sep 26 2025 22:11:08 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 26 2025 22:11:08 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_employee -- ---------------------------- DROP TABLE IF EXISTS `t_employee`; CREATE TABLE `t_employee` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `role_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `user_id` bigint NOT NULL, `state` int NOT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `phone` (`phone`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_employee -- ---------------------------- INSERT INTO `t_employee` (`id`, `name`, `phone`, `role_id`, `user_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `description`) VALUES (1, 'Admin', '13981970816', 'JUDGE_MANAGER', 2, 1, 'Wed Sep 24 2025 15:22:21 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:34:21 GMT+0800 (GMT+08:00)', NULL, 1, '111111000'); INSERT INTO `t_employee` (`id`, `name`, `phone`, `role_id`, `user_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `description`) VALUES (2, '多角色测试用户', '13800000003', 'MANAGER', 29, 1, 'Wed Sep 24 2025 21:08:16 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 21:08:16 GMT+0800 (GMT+08:00)', NULL, 0, '既是员工又是评委的测试账号'); INSERT INTO `t_employee` (`id`, `name`, `phone`, `role_id`, `user_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `description`) VALUES (4, '测试员工Service', '13900000003', 'EMPLOYEE', 32, 1, 'Wed Sep 24 2025 22:26:40 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:26:40 GMT+0800 (GMT+08:00)', NULL, 0, '直接测试EmployeeService'); INSERT INTO `t_employee` (`id`, `name`, `phone`, `role_id`, `user_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `description`) VALUES (5, '?????GraphQL', '13900000004', 'EMPLOYEE', 33, 1, 'Wed Sep 24 2025 22:26:50 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:26:50 GMT+0800 (GMT+08:00)', NULL, 0, '??GraphQL??????'); INSERT INTO `t_employee` (`id`, `name`, `phone`, `role_id`, `user_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `description`) VALUES (6, '?????GraphQL2', '13900000005', 'EMPLOYEE', 34, 1, 'Wed Sep 24 2025 22:27:01 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:27:01 GMT+0800 (GMT+08:00)', NULL, 0, '??GraphQL??????2'); INSERT INTO `t_employee` (`id`, `name`, `phone`, `role_id`, `user_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `description`) VALUES (7, 'uK', '13412341222', 'SUPER_ADMIN', 35, 1, 'Wed Sep 24 2025 22:29:32 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:29:32 GMT+0800 (GMT+08:00)', NULL, 0, '0000'); INSERT INTO `t_employee` (`id`, `name`, `phone`, `role_id`, `user_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `description`) VALUES (8, 'Test Employee Edit - Modified', '13900000010', 'EMPLOYEE', 36, 1, 'Wed Sep 24 2025 22:31:42 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:31:43 GMT+0800 (GMT+08:00)', NULL, 2, 'Modified password and description'); INSERT INTO `t_employee` (`id`, `name`, `phone`, `role_id`, `user_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `description`) VALUES (9, 'Test', '13900000011', 'EMPLOYEE', 37, 1, 'Wed Sep 24 2025 22:33:36 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:33:36 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_employee` (`id`, `name`, `phone`, `role_id`, `user_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `description`) VALUES (18, '测试员工', '13800000001', 'ADMIN', 120, 1, 'Mon Sep 29 2025 18:48:53 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:48:53 GMT+0800 (GMT+08:00)', NULL, 0, '系统测试员工账号'); -- ---------------------------- -- Table structure for t_employee_role -- ---------------------------- DROP TABLE IF EXISTS `t_employee_role`; CREATE TABLE `t_employee_role` ( `id` bigint NOT NULL AUTO_INCREMENT, `employee_id` bigint NOT NULL, `role_id` bigint NOT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, KEY `fk_t_user_role_role` (`role_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Table structure for t_judge -- ---------------------------- DROP TABLE IF EXISTS `t_judge`; CREATE TABLE `t_judge` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `user_id` bigint DEFAULT NULL, `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `gender` int DEFAULT NULL, `state` int NOT NULL DEFAULT '1', `role_id` bigint DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', `title` varchar(128) DEFAULT NULL COMMENT '职位/头衔', `company` varchar(128) DEFAULT NULL COMMENT '公司/机构', `introduction` text COMMENT '个人介绍', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `phone` (`phone`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_judge -- ---------------------------- INSERT INTO `t_judge` (`id`, `name`, `user_id`, `phone`, `gender`, `state`, `role_id`, `description`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `title`, `company`, `introduction`) VALUES (65, '张三', NULL, '13800138000', 1, 1, NULL, '拥有10年以上的技术开发经验，专注于云计算和大数据领域。', 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 0, NULL, NULL, NULL); INSERT INTO `t_judge` (`id`, `name`, `user_id`, `phone`, `gender`, `state`, `role_id`, `description`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `title`, `company`, `introduction`) VALUES (66, '王五', 123, '13940833', 1, 1, NULL, '高级技术专家，拥有丰富的行业经验', 'Mon Sep 29 2025 18:49:01 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:49:01 GMT+0800 (GMT+08:00)', NULL, 1, NULL, NULL, NULL); INSERT INTO `t_judge` (`id`, `name`, `user_id`, `phone`, `gender`, `state`, `role_id`, `description`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `title`, `company`, `introduction`) VALUES (68, 'UK2026', 2, '13981970816', 1, 1, NULL, '系统自动创建的评委', 'Tue Sep 30 2025 10:46:11 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 10:46:11 GMT+0800 (GMT+08:00)', NULL, 0, NULL, NULL, NULL); -- ---------------------------- -- Table structure for t_judge_tag -- ---------------------------- DROP TABLE IF EXISTS `t_judge_tag`; CREATE TABLE `t_judge_tag` ( `id` bigint NOT NULL AUTO_INCREMENT, `judge_id` bigint NOT NULL, `tag_id` bigint NOT NULL, `state` int NOT NULL DEFAULT '1', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, KEY `fk_t_judge_major_tag` (`tag_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=97 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_judge_tag -- ---------------------------- INSERT INTO `t_judge_tag` (`id`, `judge_id`, `tag_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (92, 65, 29, 1, 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_judge_tag` (`id`, `judge_id`, `tag_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (93, 65, 30, 1, 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_judge_tag` (`id`, `judge_id`, `tag_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (94, 65, 31, 1, 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_judge_tag` (`id`, `judge_id`, `tag_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (95, 66, 9, 1, 'Mon Sep 29 2025 18:49:00 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:49:00 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_judge_tag` (`id`, `judge_id`, `tag_id`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (96, 66, 8, 1, 'Mon Sep 29 2025 18:49:00 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:49:00 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_media -- ---------------------------- DROP TABLE IF EXISTS `t_media`; CREATE TABLE `t_media` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `target_type` int NOT NULL, `target_id` bigint NOT NULL, `media_type` int NOT NULL, `path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '腾讯云的存储桶地址', `thumb_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `file_ext` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `file_size` int NOT NULL, `duration` int DEFAULT NULL COMMENT '视频的长度秒', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL DEFAULT '1', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, KEY `uq_type_id` (`target_type`,`target_id`) ) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_media -- ---------------------------- INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (112, 'judge_avatar.jpg', 1, 65, 1, 'avatars/judge_avatar_1759142940287.jpg', NULL, 'jpg', 1024, NULL, NULL, 1, 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (113, 'logo.jpg', 1, 66, 1, '20250929/b5840d47-b046-4461-9d78-27881c917f03.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Mon Sep 29 2025 18:49:02 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:49:02 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (114, 'a1.png', 2, 73, 1, '20250929/bc8be85a-c0d9-4d75-885e-cb19d613e00f.png', NULL, 'png', 3628657, NULL, NULL, 1, 'Mon Sep 29 2025 19:16:11 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 19:16:11 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (115, 'bug1.png', 2, 73, 1, '20250929/23aee0a8-dc1e-4ec5-b4a6-2b80370940cb.png', NULL, 'png', 84959, NULL, NULL, 1, 'Mon Sep 29 2025 19:16:11 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 19:16:11 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (116, 'mg665p1c-h3pighsw-6rguef2u-byme.jpg', 7, 2, 1, 'avatars/20250930/mg665p1c-h3pighsw-6rguef2u-byme.jpg', NULL, 'jpg', 3624223, NULL, NULL, 1, 'Tue Sep 30 2025 09:08:55 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:21:09 GMT+0800 (GMT+08:00)', NULL, 1); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (117, 'mg5v06il-rei95zgu-f9okwt82-iruh.png', 5, 51, 1, 'attachments/20250930/mg5v06il-rei95zgu-f9okwt82-iruh.png', NULL, 'png', 93686, NULL, NULL, 1, 'Tue Sep 30 2025 09:08:55 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 09:08:55 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (118, 'test-avatar.jpg', 7, 1, 1, 'avatars/test-avatar.jpg', NULL, 'jpg', 50000, NULL, NULL, 1, 'Tue Sep 30 2025 09:32:13 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 09:32:13 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (119, 'avatar.jpg', 7, 54, 1, '116', NULL, 'jpg', 0, NULL, NULL, 1, 'Tue Sep 30 2025 10:02:21 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 10:02:21 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (120, 'bug2.png', 2, 6, 1, '20250930/21d5b84e-5d99-4b0f-9fca-c93c92c46652.png', NULL, 'png', 93686, NULL, NULL, 1, 'Tue Sep 30 2025 12:32:23 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 12:32:23 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (121, 'mg665q2v-a6tikk1u-llgcqsw4-j4ek.jpg', 5, 1, 1, 'attachments/20250930/mg665q2v-a6tikk1u-llgcqsw4-j4ek.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Tue Sep 30 2025 14:21:10 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:21:10 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (122, 'mg665q2v-a6tikk1u-llgcqsw4-j4ek.jpg', 5, 2, 1, 'attachments/20250930/mg665q2v-a6tikk1u-llgcqsw4-j4ek.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Tue Sep 30 2025 17:29:13 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 17:29:13 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (123, 'a2.png', 4, 1, 1, '20250930/3fbde670-1b38-4e8b-bd50-1f81718f7466.png', NULL, 'png', 5013816, NULL, NULL, 1, 'Tue Sep 30 2025 17:34:26 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 17:34:26 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (124, 'logo.jpg', 4, 2, 1, '20250930/78b0e032-197c-4f69-b531-968e12a0a0e1.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Tue Sep 30 2025 17:34:37 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 17:34:37 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_media_backup_avatar_migration -- ---------------------------- DROP TABLE IF EXISTS `t_media_backup_avatar_migration`; CREATE TABLE `t_media_backup_avatar_migration` ( `id` int NOT NULL DEFAULT '0', `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `target_type` int NOT NULL, `target_id` bigint NOT NULL, `media_type` int NOT NULL, `path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '腾讯云的存储桶地址', `thumb_path` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `file_ext` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `file_size` int NOT NULL, `duration` int DEFAULT NULL COMMENT '视频的长度秒', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL DEFAULT '1', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- ---------------------------- -- Records of t_media_backup_avatar_migration -- ---------------------------- INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (3, 'logo.jpg', 1, 0, 1, 'avatars/logo_test.jpg', NULL, 'jpg', 2048, NULL, NULL, 1, 'Sun Sep 21 2025 22:24:51 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 22:24:51 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (4, 'logo.jpg', 1, 0, 1, 'avatars/logo_test.jpg', NULL, 'jpg', 2048, NULL, NULL, 1, 'Sun Sep 21 2025 22:25:35 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 22:25:35 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (5, 'logo.jpg', 1, 0, 1, 'avatars/logo_test.jpg', NULL, 'jpg', 2048, NULL, NULL, 1, 'Sun Sep 21 2025 22:26:41 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 22:26:41 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (6, 'logo.jpg', 1, 0, 1, 'avatars/logo_test.jpg', NULL, 'jpg', 2048, NULL, NULL, 1, 'Sun Sep 21 2025 22:27:29 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 22:27:29 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (17, 'logo.jpg', 1, 0, 1, '20250922/221c144a-15da-41ae-9fe2-1721b740e3bd.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Mon Sep 22 2025 15:39:10 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 22 2025 15:39:10 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, 'judge_avatar.jpg', 1, 21, 1, 'avatars/judge_avatar_1758458288387.jpg', NULL, 'jpg', 1024, NULL, NULL, 1, 'Sun Sep 21 2025 20:38:06 GMT+0800 (GMT+08:00)', NULL, 'Sat Sep 27 2025 10:57:45 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (22, 'C1.jpg', 1, 21, 1, '20250923/5b3b8556-3096-4c5b-a391-d6ec0b7a1dca.jpg', NULL, 'jpg', 456547, NULL, NULL, 1, 'Tue Sep 23 2025 08:57:55 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 08:57:55 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (2, 'logo.jpg', 1, 22, 1, 'avatars/logo_1758464410213.jpg', NULL, 'jpg', 2048, NULL, NULL, 1, 'Sun Sep 21 2025 22:20:08 GMT+0800 (GMT+08:00)', NULL, 'Sat Sep 27 2025 10:57:46 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (7, 'logo.jpg', 1, 27, 1, 'avatars/judge_1758465900493_logo.jpg', NULL, 'jpg', 2048, NULL, NULL, 1, 'Sun Sep 21 2025 22:45:01 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 22:45:01 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (8, 'logo.jpg', 1, 28, 1, 'avatars/judge_1758465960096_logo.jpg', NULL, 'jpg', 2048, NULL, NULL, 1, 'Sun Sep 21 2025 22:46:00 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 22:46:00 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (9, 'logo.jpg', 1, 29, 1, 'avatars/judge_1758466031697_logo.jpg', NULL, 'jpg', 2048, NULL, NULL, 1, 'Sun Sep 21 2025 22:47:12 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 22:47:12 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (10, 'logo.jpg', 1, 30, 1, '20250921/6ab1ca46-eb4f-46c2-a065-495eb7aaf81b.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Sun Sep 21 2025 22:57:06 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 22:57:06 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (11, 'judge_avatar_36', 1, 36, 1, 'https://ryc-1256886520.cos.ap-chengdu.myqcloud.com/20250922/cff3c319-36d3-4969-ad66-7c9c02d6a642.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Mon Sep 22 2025 09:24:18 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 22 2025 09:24:18 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (12, 'a.png', 1, 37, 1, '20250922/f53c4de4-f286-47bd-9849-6fc610d2a3a3.png', NULL, 'png', 2041024, NULL, NULL, 1, 'Mon Sep 22 2025 09:34:22 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 22 2025 09:34:22 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (13, 'logo.jpg', 1, 38, 1, '20250922/d11d9137-88c0-40c8-b0ed-c75c19188129.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Mon Sep 22 2025 13:12:23 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 22 2025 13:12:23 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (14, 'logo.jpg', 1, 39, 1, '20250922/ac760a7a-4105-4b32-922e-39da3c7032a8.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Mon Sep 22 2025 13:16:44 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 22 2025 13:16:44 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (15, 'logo.jpg', 1, 40, 1, '20250922/2e4717e4-67fd-4caa-b281-17d86053a274.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Mon Sep 22 2025 13:47:20 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 22 2025 13:47:20 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (16, 'logo.jpg', 1, 41, 1, '20250922/59a406d7-4123-4ac3-b157-184c987e4368.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Mon Sep 22 2025 15:33:37 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 22 2025 15:33:37 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (37, 'avatar.jpg', 1, 41, 1, 'avatar_1759035802271', NULL, 'jpg', 0, NULL, NULL, 1, 'Sun Sep 28 2025 13:03:22 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 13:03:22 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (23, 'a2.png', 1, 42, 1, '20250923/bcadfa95-5a30-493b-b819-befd8695063b.png', NULL, 'png', 65846, NULL, NULL, 1, 'Tue Sep 23 2025 10:39:27 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 10:39:27 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (40, 'avatar.jpg', 1, 42, 1, 'test-avatar-media-id-1759035864664', NULL, 'jpg', 0, NULL, NULL, 1, 'Sun Sep 28 2025 13:04:25 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 13:04:25 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (27, 'a.png', 1, 43, 1, '20250923/d54f92f2-2dd8-475a-b766-b4d0ee473b99.png', NULL, 'png', 2041024, NULL, NULL, 1, 'Tue Sep 23 2025 17:45:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 17:45:32 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (28, '微信图片_20250831200430_16_48.png', 1, 44, 1, '20250924/11903ee1-d0ff-4299-996f-c1851c70f8e1.png', NULL, 'png', 162478, NULL, NULL, 1, 'Wed Sep 24 2025 10:10:44 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 10:10:44 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (29, 'logo.jpg', 1, 45, 1, '20250924/cca43df6-1f69-4ade-86d1-9021156fa1f6.jpg', NULL, 'jpg', 67671, NULL, NULL, 1, 'Wed Sep 24 2025 13:40:04 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 13:40:04 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (31, '微信图片_20250831200430_16_48.png', 1, 46, 1, '20250924/6706fc1d-c8e8-4eae-bbc7-be992cc59bd5.png', NULL, 'png', 162478, NULL, NULL, 1, 'Wed Sep 24 2025 18:49:44 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 18:49:44 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (32, '微信图片_20250831200430_16_48.png', 1, 47, 1, '20250924/b17c8097-ff10-43b2-b544-0b205e4f23d4.png', NULL, 'png', 162478, NULL, NULL, 1, 'Wed Sep 24 2025 18:59:31 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 18:59:31 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (33, '微信图片_20250831200430_16_48.png', 1, 48, 1, '20250924/b6378b03-29a4-4c0d-930f-cfbe072f4de6.png', NULL, 'png', 162478, NULL, NULL, 1, 'Wed Sep 24 2025 19:12:16 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 19:12:16 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_media_backup_avatar_migration` (`id`, `name`, `target_type`, `target_id`, `media_type`, `path`, `thumb_path`, `file_ext`, `file_size`, `duration`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (34, '微信图片_20250831200430_16_48.png', 1, 49, 1, '20250924/cceb4e5f-d022-43b6-9dbc-b5c81fd4dcdc.png', NULL, 'png', 162478, NULL, NULL, 1, 'Wed Sep 24 2025 19:36:52 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 19:36:52 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_msg -- ---------------------------- DROP TABLE IF EXISTS `t_msg`; CREATE TABLE `t_msg` ( `id` bigint NOT NULL AUTO_INCREMENT, `target_type` int NOT NULL, `target_id` bigint NOT NULL, `player_id` bigint NOT NULL, `user_id` bigint NOT NULL, `content` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `template_content` varchar(200) COLLATE utf8mb4_general_ci DEFAULT NULL, `wx_msg_success` bit(1) NOT NULL, `wx_msg_err_count` int NOT NULL DEFAULT '0', `wx_msg_last_err` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `state` int NOT NULL COMMENT '0:暂时不发布， 1：可以发布，2：已经发布', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- ---------------------------- -- Table structure for t_notification_task -- ---------------------------- DROP TABLE IF EXISTS `t_notification_task`; CREATE TABLE `t_notification_task` ( `id` bigint NOT NULL AUTO_INCREMENT, `type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `channel` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `target_type` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '1:学员，2：评委，3：工作人员', `target_id` bigint NOT NULL, `payload` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '消息内容', `error_message` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `retry_count` int NOT NULL, `next_retry_at` datetime DEFAULT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Table structure for t_permission -- ---------------------------- DROP TABLE IF EXISTS `t_permission`; CREATE TABLE `t_permission` ( `id` bigint NOT NULL AUTO_INCREMENT, `code` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `category` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` tinyint(1) NOT NULL DEFAULT '1', `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `code` (`code`) USING BTREE, KEY `idx_t_permission_code` (`code`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_permission -- ---------------------------- INSERT INTO `t_permission` (`id`, `code`, `name`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (9, 'SYSTEM_USER_MANAGE', 'User Management', 'SYSTEM', 'Manage platform users and roles', 1, 'Fri Sep 19 2025 16:51:12 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 19 2025 17:00:22 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_permission` (`id`, `code`, `name`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (10, 'PLAYER_AUDIT', 'Player Audit', 'PLAYER', 'Review player registrations', 1, 'Fri Sep 19 2025 16:51:12 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 19 2025 17:00:22 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_permission` (`id`, `code`, `name`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (11, 'JUDGE_MANAGE', 'Judge Management', 'JUDGE', 'Maintain judge information', 1, 'Fri Sep 19 2025 16:51:12 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 19 2025 17:00:22 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_permission` (`id`, `code`, `name`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (12, 'ACTIVITY_MANAGE', 'Activity Management', 'ACTIVITY', 'Maintain activities and stage configuration', 1, 'Fri Sep 19 2025 16:51:12 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 19 2025 17:00:22 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_player -- ---------------------------- DROP TABLE IF EXISTS `t_player`; CREATE TABLE `t_player` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `user_id` bigint NOT NULL, `phone` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `role_id` bigint NOT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `gender` int DEFAULT NULL COMMENT '0:女，1：男', `education` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `introduction` text CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci, `reject_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `final_score` decimal(10,2) DEFAULT NULL, `state` int NOT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `phone` (`phone`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_player -- ---------------------------- INSERT INTO `t_player` (`id`, `name`, `user_id`, `phone`, `role_id`, `description`, `gender`, `education`, `introduction`, `reject_reason`, `final_score`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, 'UK2025', 2, '13981970816', 1, NULL, 0, '本科', '', NULL, NULL, 1, 'Tue Sep 30 2025 14:21:08 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:21:08 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_rating_item -- ---------------------------- DROP TABLE IF EXISTS `t_rating_item`; CREATE TABLE `t_rating_item` ( `id` bigint NOT NULL AUTO_INCREMENT, `scheme_id` bigint NOT NULL, `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `max_score` int NOT NULL, `order_no` int NOT NULL, `state` int NOT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, KEY `idx_t_rating_item_scheme` (`scheme_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_rating_item -- ---------------------------- INSERT INTO `t_rating_item` (`id`, `scheme_id`, `name`, `max_score`, `order_no`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, 1, '代码质量', 30, 1, 1, 'Mon Sep 22 2025 10:30:56 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 16:58:48 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_rating_item` (`id`, `scheme_id`, `name`, `max_score`, `order_no`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (2, 1, '功能完整性', 25, 2, 1, 'Mon Sep 22 2025 10:30:56 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 16:58:48 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_rating_item` (`id`, `scheme_id`, `name`, `max_score`, `order_no`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (3, 1, '用户体验', 20, 3, 1, 'Mon Sep 22 2025 10:30:56 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 16:58:48 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_rating_item` (`id`, `scheme_id`, `name`, `max_score`, `order_no`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (4, 1, '创新性', 15, 4, 1, 'Tue Sep 23 2025 22:45:06 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 16:58:48 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_rating_item` (`id`, `scheme_id`, `name`, `max_score`, `order_no`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (5, 1, '项目展示', 10, 5, 1, 'Tue Sep 23 2025 22:45:06 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 16:58:48 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_rating_item` (`id`, `scheme_id`, `name`, `max_score`, `order_no`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (9, 6, '??', 100, 1, 1, 'Sat Sep 27 2025 10:05:44 GMT+0800 (GMT+08:00)', NULL, 'Sat Sep 27 2025 10:05:44 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_rating_item` (`id`, `scheme_id`, `name`, `max_score`, `order_no`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (10, 8, '创意', 15, 1, 1, 'Sun Sep 28 2025 21:03:14 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 21:03:14 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_rating_item` (`id`, `scheme_id`, `name`, `max_score`, `order_no`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (11, 8, '团队', 20, 1, 1, 'Sun Sep 28 2025 21:03:14 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 21:03:14 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_rating_item` (`id`, `scheme_id`, `name`, `max_score`, `order_no`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (12, 8, '资金', 10, 1, 1, 'Sun Sep 28 2025 21:03:14 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 21:03:14 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_rating_item` (`id`, `scheme_id`, `name`, `max_score`, `order_no`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (13, 8, '可行性', 15, 1, 1, 'Sun Sep 28 2025 21:03:14 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 21:03:14 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_rating_scheme -- ---------------------------- DROP TABLE IF EXISTS `t_rating_scheme`; CREATE TABLE `t_rating_scheme` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `description` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_rating_scheme -- ---------------------------- INSERT INTO `t_rating_scheme` (`id`, `name`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, '编程大赛评分标准', '用于编程比赛的综合评分标准，包含代码质量、功能完整性、用户体验、创新性和项目展示等维度', 1, 'Sat Sep 20 2025 20:11:58 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 16:57:37 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_rating_scheme` (`id`, `name`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (2, '技能比赛评分模板', '专门用于技能类比赛的评分模板', 0, 'Sat Sep 20 2025 20:11:58 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:37:19 GMT+0800 (GMT+08:00)', NULL, 1); INSERT INTO `t_rating_scheme` (`id`, `name`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (3, '2025', '顶顶顶顶', 0, 'Mon Sep 22 2025 10:30:56 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:37:17 GMT+0800 (GMT+08:00)', NULL, 1); INSERT INTO `t_rating_scheme` (`id`, `name`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (4, '2025-1', '4呃呃呃呃', 0, 'Tue Sep 23 2025 22:45:06 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:37:15 GMT+0800 (GMT+08:00)', NULL, 1); INSERT INTO `t_rating_scheme` (`id`, `name`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (5, '??????', '?????????', 0, 'Wed Sep 24 2025 12:59:43 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:37:10 GMT+0800 (GMT+08:00)', NULL, 1); INSERT INTO `t_rating_scheme` (`id`, `name`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (6, '??????', '???????', 0, 'Sat Sep 27 2025 10:05:44 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:37:07 GMT+0800 (GMT+08:00)', NULL, 1); INSERT INTO `t_rating_scheme` (`id`, `name`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (8, '2025创业比赛', '2025创业比赛', 1, 'Sun Sep 28 2025 21:03:14 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 21:03:14 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_region -- ---------------------------- DROP TABLE IF EXISTS `t_region`; CREATE TABLE `t_region` ( `id` bigint NOT NULL AUTO_INCREMENT, `pid` bigint NOT NULL COMMENT '自关联', `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `code` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `level` int NOT NULL, `leaf_flag` tinyint(1) NOT NULL DEFAULT '0', `full_path` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `code` (`code`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_region -- ---------------------------- INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, 0, '四川省', NULL, 1, 0, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (2, 0, '重庆市', NULL, 1, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:39:15 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (3, 1, '成都市', NULL, 2, 0, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (4, 1, '眉山市', NULL, 2, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:39:18 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (5, 1, '德阳市', NULL, 2, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:39:19 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (6, 3, '天府新区', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (7, 3, '东部新区', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (8, 3, '高新', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (9, 3, '锦江', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (10, 3, '青羊', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (11, 3, '金牛', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (12, 3, '武侯', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (13, 3, '成华', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (14, 3, '龙泉', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (15, 3, '青白江', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (16, 3, '新都', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (17, 3, '温江', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (18, 3, '双流', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (19, 3, '郫都', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (20, 3, '简阳', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (21, 3, '都江堰', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (22, 3, '彭州', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (23, 3, '邛崃', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (24, 3, '崇州', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (25, 3, '金堂', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (26, 3, '新津', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (27, 3, '大邑', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (28, 3, '蒲江', NULL, 3, 1, NULL, 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 11:38:28 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_region` (`id`, `pid`, `name`, `code`, `level`, `leaf_flag`, `full_path`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (29, 1, '资阳', NULL, 2, 1, NULL, 1, 'Tue Sep 23 2025 19:14:08 GMT+0800 (GMT+08:00)', 1, 'Tue Sep 23 2025 19:14:08 GMT+0800 (GMT+08:00)', 1, 0); -- ---------------------------- -- Table structure for t_role -- ---------------------------- DROP TABLE IF EXISTS `t_role`; CREATE TABLE `t_role` ( `id` bigint NOT NULL AUTO_INCREMENT, `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `code` (`code`) USING BTREE, KEY `idx_t_role_code` (`code`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_role -- ---------------------------- INSERT INTO `t_role` (`id`, `code`, `name`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (7, 'SUPER_ADMIN', '超级管理员', 'Full system privileges', 1, 'Fri Sep 19 2025 16:51:12 GMT+0800 (GMT+08:00)', 1, 'Wed Sep 24 2025 14:58:43 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_role` (`id`, `code`, `name`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (8, 'AUDITOR', '平台工作人员', 'Review player applications', 1, 'Fri Sep 19 2025 16:51:12 GMT+0800 (GMT+08:00)', 1, 'Wed Sep 24 2025 15:05:53 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_role` (`id`, `code`, `name`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (9, 'JUDGE_MANAGER', '评委', 'Manage judges and competition stages', 1, 'Fri Sep 19 2025 16:51:12 GMT+0800 (GMT+08:00)', 1, 'Wed Sep 24 2025 14:58:42 GMT+0800 (GMT+08:00)', 1, 0); INSERT INTO `t_role` (`id`, `code`, `name`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (19, 'PLAYER', '参赛人员', '参赛人员', 1, 'Wed Sep 24 2025 14:58:36 GMT+0800 (GMT+08:00)', 1, 'Wed Sep 24 2025 14:58:36 GMT+0800 (GMT+08:00)', 1, 1); -- ---------------------------- -- Table structure for t_role_permission -- ---------------------------- DROP TABLE IF EXISTS `t_role_permission`; CREATE TABLE `t_role_permission` ( `id` int NOT NULL AUTO_INCREMENT, `role_id` bigint NOT NULL, `permission_id` bigint NOT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, KEY `fk_t_role_permission_perm` (`permission_id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_role_permission -- ---------------------------- INSERT INTO `t_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, 7, 9, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (2, 7, 10, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (3, 7, 11, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (4, 7, 12, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (5, 8, 10, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (6, 9, 11, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_role_permission` (`id`, `role_id`, `permission_id`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (7, 9, 12, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 'Fri Sep 19 2025 20:32:43 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_tag -- ---------------------------- DROP TABLE IF EXISTS `t_tag`; CREATE TABLE `t_tag` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `code` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `category` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `code` (`code`) USING BTREE, KEY `idx_t_tag_category` (`category`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_tag -- ---------------------------- INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (1, '男', 'male', 'gender', '男性', 1, 'Sat Sep 20 2025 15:54:26 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 08:59:09 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (2, '女', 'female', 'gender', '女性', 1, 'Sat Sep 20 2025 15:54:27 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:07:55 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (3, '高中', 'high_school', 'education', '高中学历', 1, 'Sat Sep 20 2025 15:54:27 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:07:56 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (4, '大专', 'junior_college', 'education', '大专学历', 1, 'Sat Sep 20 2025 15:54:27 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:07:56 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (5, '本科', 'bachelor', 'education', '本科学历', 1, 'Sat Sep 20 2025 15:54:27 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:07:56 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (6, '硕士', 'master', 'education', '硕士学历', 1, 'Sat Sep 20 2025 15:54:28 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:07:56 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (7, '博士', 'doctorate', 'education', '博士学历', 1, 'Sat Sep 20 2025 15:54:28 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:07:56 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (8, '通讯', 'communication', 'major', NULL, 1, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (9, '零售', 'retail', 'major', NULL, 1, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (10, '餐饮', 'catering', 'major', NULL, 1, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (11, '建筑', 'architecture', 'major', NULL, 1, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (12, '服装', 'clothing', 'major', NULL, 1, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (13, '计算机', 'computer', 'major', NULL, 1, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 09:03:51 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (14, '设计', 'design', 'major', '设计类专业', 1, 'Sun Sep 21 2025 10:28:57 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 10:28:57 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (15, '编程', 'programming', 'major', '编程/软件开发', 1, 'Sun Sep 21 2025 10:28:57 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 10:28:57 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (16, '市场', 'marketing', 'major', '市场/品牌', 1, 'Sun Sep 21 2025 10:28:57 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 10:28:57 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (17, '金融', 'finance', 'major', '金融/财务', 1, 'Sun Sep 21 2025 10:28:58 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 10:28:58 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (18, '管理', 'management', 'major', '管理/运营', 1, 'Sun Sep 21 2025 10:28:58 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 10:28:58 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (27, 'Java开发', 'java', 'major', NULL, 1, 'Sun Sep 21 2025 20:17:23 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 20:17:23 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (28, '前端开发', 'frontend', 'major', NULL, 1, 'Sun Sep 21 2025 20:17:23 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 20:17:23 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (29, '云计算', '云计算', '技术', NULL, 1, 'Sun Sep 21 2025 20:38:06 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 20:38:06 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (30, '大数据', '大数据', '技术', NULL, 1, 'Sun Sep 21 2025 20:38:07 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 20:38:07 GMT+0800 (GMT+08:00)', NULL, 0); INSERT INTO `t_tag` (`id`, `name`, `code`, `category`, `description`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`) VALUES (31, '架构设计', '架构设计', '技术', NULL, 1, 'Sun Sep 21 2025 20:38:07 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 21 2025 20:38:07 GMT+0800 (GMT+08:00)', NULL, 0); -- ---------------------------- -- Table structure for t_user -- ---------------------------- DROP TABLE IF EXISTS `t_user`; CREATE TABLE `t_user` ( `id` bigint NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `gender` int DEFAULT NULL, `phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `birthday` date DEFAULT NULL, `wx_openid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `wx_unionid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `wx_oa_openid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `state` int NOT NULL, `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP, `create_user_id` bigint DEFAULT NULL, `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `uq_wx_open_id` (`wx_openid`) USING BTREE, UNIQUE KEY `uq_phone` (`phone`) ) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- ---------------------------- -- Records of t_user -- ---------------------------- INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (2, 'UK2025', NULL, '13981970816', 'Tue Sep 30 2025 00:00:00 GMT+0800 (GMT+08:00)', 'test_admin_openid_123456', 'test_admin_unionid_123456', NULL, '$2a$10$hqbLL9GW5hG/MCehHt3E4evtNLxMil8vyj46vNulVwVaXLsHQVFvK', 1, 'Sat Sep 20 2025 18:49:14 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 14:21:08 GMT+0800 (GMT+08:00)', NULL, 13, '13800138000'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (3, '批量用户1', NULL, NULL, NULL, 'wx_openid_batch_1', 'wx_unionid_batch_1', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010001'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (4, '批量用户2', NULL, NULL, NULL, 'wx_openid_batch_2', 'wx_unionid_batch_2', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010002'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (5, '批量用户3', NULL, NULL, NULL, 'wx_openid_batch_3', 'wx_unionid_batch_3', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010003'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (6, '批量用户4', NULL, NULL, NULL, 'wx_openid_batch_4', 'wx_unionid_batch_4', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010004'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (7, '批量用户5', NULL, NULL, NULL, 'wx_openid_batch_5', 'wx_unionid_batch_5', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010005'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (8, '批量用户6', NULL, NULL, NULL, 'wx_openid_batch_6', 'wx_unionid_batch_6', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010006'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (9, '批量用户7', NULL, NULL, NULL, 'wx_openid_batch_7', 'wx_unionid_batch_7', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010007'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (10, '批量用户8', NULL, NULL, NULL, 'wx_openid_batch_8', 'wx_unionid_batch_8', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010008'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (11, '批量用户9', NULL, NULL, NULL, 'wx_openid_batch_9', 'wx_unionid_batch_9', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010009'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (12, '批量用户10', NULL, NULL, NULL, 'wx_openid_batch_10', 'wx_unionid_batch_10', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010010'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (13, '批量用户11', NULL, NULL, NULL, 'wx_openid_batch_11', 'wx_unionid_batch_11', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010011'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (14, '批量用户12', NULL, NULL, NULL, 'wx_openid_batch_12', 'wx_unionid_batch_12', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010012'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (15, '批量用户13', NULL, NULL, NULL, 'wx_openid_batch_13', 'wx_unionid_batch_13', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010013'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (16, '批量用户14', NULL, NULL, NULL, 'wx_openid_batch_14', 'wx_unionid_batch_14', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010014'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (17, '批量用户15', NULL, NULL, NULL, 'wx_openid_batch_15', 'wx_unionid_batch_15', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010015'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (18, '批量用户16', NULL, NULL, NULL, 'wx_openid_batch_16', 'wx_unionid_batch_16', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010016'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (19, '批量用户17', NULL, NULL, NULL, 'wx_openid_batch_17', 'wx_unionid_batch_17', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010017'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (20, '批量用户18', NULL, NULL, NULL, 'wx_openid_batch_18', 'wx_unionid_batch_18', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010018'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (21, '批量用户19', NULL, NULL, NULL, 'wx_openid_batch_19', 'wx_unionid_batch_19', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010019'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (22, '批量用户20', NULL, NULL, NULL, 'wx_openid_batch_20', 'wx_unionid_batch_20', NULL, NULL, 1, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 23 2025 19:39:32 GMT+0800 (GMT+08:00)', NULL, 0, '13800010020'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (23, 'abc', NULL, '13412341234', NULL, NULL, NULL, NULL, NULL, 1, 'Wed Sep 24 2025 18:49:44 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 18:49:44 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (24, 'owen2', NULL, '13512351233', NULL, NULL, NULL, NULL, '$2a$10$8Kxiwl7Y6ZPBbcXvVnAcse5nKFiEv4PwfSjTcfvST73OeWlxOh1fO', 1, 'Wed Sep 24 2025 18:59:30 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 20:58:22 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (25, 'charon', NULL, '13312341231', NULL, NULL, NULL, NULL, '$2a$10$sCG7ZH8r7K1uuXVtILRAO.AHZ8ICf/RhaVLKYquL9zn59M8JOXJJ6', 1, 'Wed Sep 24 2025 19:12:15 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 19:12:15 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (26, '幅度达到', NULL, '13612341233', NULL, NULL, NULL, NULL, '$2a$10$Kni9VyfMaDfPPSKqBFsXSOx42xjHuYIl5m.TzCWc2.qSNGiZwTc4i', 1, 'Wed Sep 24 2025 19:36:52 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 19:36:52 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (29, '多角色测试用户', NULL, NULL, NULL, 'test_multi_role_openid', 'test_multi_role_unionid', NULL, '$2a$10$iYNVWrYeTv3zd921sWkuGO5iqlaO8W03U0.N5d/LQUTcbq2PGzGd.', 1, 'Wed Sep 24 2025 21:08:16 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 21:08:16 GMT+0800 (GMT+08:00)', NULL, 0, '13800000003'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (32, '测试员工Service', NULL, '13900000003', NULL, NULL, NULL, NULL, '$2a$10$HeGs60KbbI94jNjgx81BOeextvSPcIjSxfnGhk1aH9SwznJannnem', 1, 'Wed Sep 24 2025 22:26:40 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:26:40 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (33, '?????GraphQL', NULL, '13900000004', NULL, NULL, NULL, NULL, '$2a$10$gkpg6pLmJ1LqLao8JAToserhGcFY92jq07PKyTn8N.pSzhedOaj0G', 1, 'Wed Sep 24 2025 22:26:50 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:26:50 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (34, '?????GraphQL2', NULL, '13900000005', NULL, NULL, NULL, NULL, '$2a$10$lugKOumFCa32vFPYhFl2O.M0rdDPbJjUE0T0bOQEDZS5LyT88sacy', 1, 'Wed Sep 24 2025 22:27:01 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:27:01 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (35, 'uK', NULL, '13412341222', NULL, NULL, NULL, NULL, '$2a$10$pHtlOvXum0.wqzRkJ3gxte38JpAmUCuLQKw.HfWeUf9HfcZ0vzIpS', 1, 'Wed Sep 24 2025 22:29:32 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:29:32 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (36, 'Test Employee Edit - Modified', NULL, '13900000010', NULL, NULL, NULL, NULL, '$2a$10$mlnfm/AhpxypAjN8fknLmuBvNdA7mRZyzZ5fwKsd9uQh.0cydCEsm', 1, 'Wed Sep 24 2025 22:31:42 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:31:43 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (37, 'Test', NULL, '13900000011', NULL, NULL, NULL, NULL, '$2a$10$7Cw66wTO3WoW7LAFGHQV8OnYeqH4iPkueCasFQQ9ID9bFaxUcvFTu', 1, 'Wed Sep 24 2025 22:33:36 GMT+0800 (GMT+08:00)', NULL, 'Wed Sep 24 2025 22:33:36 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (53, '微信用户', NULL, NULL, NULL, 'test123', NULL, NULL, NULL, 1, 'Thu Sep 25 2025 22:27:11 GMT+0800 (GMT+08:00)', NULL, 'Thu Sep 25 2025 22:27:11 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (54, '微信用户', NULL, NULL, NULL, 'test_openid_123', NULL, NULL, NULL, 1, 'Thu Sep 25 2025 22:34:26 GMT+0800 (GMT+08:00)', NULL, 'Thu Sep 25 2025 22:34:26 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (55, '微信用户', NULL, NULL, NULL, 'test_openid_456', NULL, NULL, NULL, 1, 'Thu Sep 25 2025 22:38:13 GMT+0800 (GMT+08:00)', NULL, 'Thu Sep 25 2025 22:38:13 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (56, '微信用户', NULL, NULL, NULL, 'test_openid_789', NULL, NULL, NULL, 1, 'Thu Sep 25 2025 22:38:25 GMT+0800 (GMT+08:00)', NULL, 'Thu Sep 25 2025 22:38:25 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (57, '微信用户', NULL, NULL, NULL, 'test_openid_1758811212038', NULL, NULL, NULL, 1, 'Thu Sep 25 2025 22:40:12 GMT+0800 (GMT+08:00)', NULL, 'Thu Sep 25 2025 22:40:12 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (58, '微信用户', NULL, NULL, NULL, 'test_openid_1758811212020', NULL, NULL, NULL, 1, 'Thu Sep 25 2025 22:40:12 GMT+0800 (GMT+08:00)', NULL, 'Thu Sep 25 2025 22:40:12 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (59, '微信用户', NULL, NULL, NULL, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, NULL, NULL, 1, 'Sat Sep 27 2025 18:39:45 GMT+0800 (GMT+08:00)', NULL, 'Sat Sep 27 2025 18:39:45 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (60, '微信用户', NULL, NULL, NULL, 'test_openid_1758970258618', 'test_unionid_1758970258619', NULL, NULL, 1, 'Sat Sep 27 2025 18:50:59 GMT+0800 (GMT+08:00)', NULL, 'Sat Sep 27 2025 18:50:59 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (61, '微信用户', NULL, NULL, NULL, 'test_openid_1758970297509', 'test_unionid_1758970297509', NULL, NULL, 1, 'Sat Sep 27 2025 18:51:38 GMT+0800 (GMT+08:00)', NULL, 'Sat Sep 27 2025 18:51:38 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (62, '????', NULL, '13800138000', 'Mon Jan 01 1990 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$sZzYN1pAIGLq.tVet/Uc/OzC/BtALqXSZYvDtKpNKcPmqruJAb94S', 1, 'Sat Sep 27 2025 20:13:34 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 12:04:18 GMT+0800 (GMT+08:00)', NULL, 3, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (63, '李四', NULL, '13900139000', 'Thu Aug 20 1992 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$108TYjAB1.BQK.px681x3uWAxGkA/HyCkQdGBo42l4yXp0l2mIyiC', 1, 'Sat Sep 27 2025 20:14:52 GMT+0800 (GMT+08:00)', NULL, 'Sat Sep 27 2025 20:14:52 GMT+0800 (GMT+08:00)', NULL, 1, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (64, '测试用户', NULL, '13912345678', 'Sun Aug 20 1995 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$sAzK1YVEWuLEqYV/VLoFL.qAB42LHcZ0N76mqyUmCUm2TZLJSLZsK', 1, 'Sat Sep 27 2025 21:09:53 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 19:10:34 GMT+0800 (GMT+08:00)', NULL, 3, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (65, '微信用户', NULL, NULL, NULL, 'test_openid_1758984255561', 'test_unionid_1758984255561', NULL, NULL, 1, 'Sat Sep 27 2025 22:44:16 GMT+0800 (GMT+08:00)', NULL, 'Sat Sep 27 2025 22:44:16 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (66, '微信用户', NULL, NULL, NULL, 'test_openid_1758984267938', 'test_unionid_1758984267938', NULL, NULL, 1, 'Sat Sep 27 2025 22:44:28 GMT+0800 (GMT+08:00)', NULL, 'Sat Sep 27 2025 22:44:28 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (68, '?????', NULL, '13987654321', 'Wed May 15 1996 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$En4tLSMGb6ABLxoeM/p5wOMoX5mYF83sXYRvxJBO4vstkWbCbInVG', 1, 'Sat Sep 27 2025 22:51:50 GMT+0800 (GMT+08:00)', NULL, 'Sat Sep 27 2025 22:51:50 GMT+0800 (GMT+08:00)', NULL, 1, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (69, '微信用户', NULL, NULL, NULL, 'test_openid_1759021536834', 'test_unionid_1759021536834', NULL, NULL, 1, 'Sun Sep 28 2025 09:05:37 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 09:05:37 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (70, '微信用户', NULL, NULL, NULL, 'test_openid_1759021805903', 'test_unionid_1759021805903', NULL, NULL, 1, 'Sun Sep 28 2025 09:10:06 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 09:10:06 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (71, '微信用户', NULL, NULL, NULL, 'test_openid_1759021932665', 'test_unionid_1759021932665', NULL, NULL, 1, 'Sun Sep 28 2025 09:12:13 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 09:12:13 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (72, '微信用户', NULL, NULL, NULL, 'test_openid_1759022073544', 'test_unionid_1759022073544', NULL, NULL, 1, 'Sun Sep 28 2025 09:14:34 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 09:14:34 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (73, '微信用户', NULL, NULL, NULL, 'test_openid_1759022567421', 'test_unionid_1759022567421', NULL, NULL, 1, 'Sun Sep 28 2025 09:22:48 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 09:22:48 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (76, '测试用户1759035802271', NULL, '13800002271', 'Mon Jan 01 1990 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$QVupV.yQijdfO908O1h40.4vmn/UNoY.uQEXD.3.lCAUTYiokv1Te', 1, 'Sun Sep 28 2025 13:03:22 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 13:03:23 GMT+0800 (GMT+08:00)', NULL, 1, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (77, '媒体API测试用户', NULL, '13900139664', 'Mon Jan 01 1990 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$XU/4t7yhmbkyqar2alZGo.Tmns8YFDUr0xZPUtnuHbn3lud0vh.e.', 1, 'Sun Sep 28 2025 13:04:25 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 13:04:25 GMT+0800 (GMT+08:00)', NULL, 1, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (78, '测试用户_debug', NULL, '13900000001', 'Mon Jan 01 1990 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$a2hjbdq2pXvVVaRZmyT9H.GcZh3ZudqFt6T8SXbX4KhxSVl8gbHaa', 1, 'Sun Sep 28 2025 20:32:26 GMT+0800 (GMT+08:00)', NULL, 'Sun Sep 28 2025 20:32:26 GMT+0800 (GMT+08:00)', NULL, 1, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (79, '测试用户1759105017981', NULL, '13800002981', NULL, NULL, NULL, NULL, '$2a$10$DG4vQhQrWrl0Z/kZay0em.zdaImk/PExo5MJfC.sC0VD/.idgWDM.', 1, 'Mon Sep 29 2025 08:16:58 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 08:16:58 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (80, '测试用户1759105041943', NULL, '13800009830', NULL, NULL, NULL, NULL, '$2a$10$j5H0cenFHPxhlIinfSj1h.SjLx8svBkLB/RuGtokDHMJ6HN5jrFsK', 1, 'Mon Sep 29 2025 08:17:22 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 08:17:22 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (81, '测试用户1759106607579', NULL, '13800007579', 'Mon Jan 01 1990 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$BKmORxmhEa9Thqkp0fUxXegMICGZW1pNZfPDlAKn.A3PHvi9AjxiS', 1, 'Mon Sep 29 2025 08:43:28 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 08:43:28 GMT+0800 (GMT+08:00)', NULL, 1, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (82, '测试用户1759106643010', NULL, '13800003010', 'Mon Jan 01 1990 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$1TK8ysLXx4akCfkirhmR1.iZltlbC2X/BeoOTNVyNidopKP4zMteK', 1, 'Mon Sep 29 2025 08:44:03 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 08:44:03 GMT+0800 (GMT+08:00)', NULL, 1, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (83, '测试用户1759106697474', NULL, '13800007474', 'Mon Jan 01 1990 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$3b71dtTccI9J9iZZSAuZY.7KhG3Bj9fcRJuxQwQigsWI.wF6B4Oce', 1, 'Mon Sep 29 2025 08:44:58 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 08:44:58 GMT+0800 (GMT+08:00)', NULL, 1, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (84, '测试用户1759106720525', NULL, '13800000525', 'Mon Jan 01 1990 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$36IfGQhTUGir1L3.IV6ww.RKn.LN3mesEPonypw.H.XXIbdNvGLGe', 1, 'Mon Sep 29 2025 08:45:21 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 08:45:21 GMT+0800 (GMT+08:00)', NULL, 1, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (85, '测试用户1759106746467', NULL, '13800006467', 'Mon Jan 01 1990 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$QU.9OXlGvo5Ss6MSjZQh4OlrhlUf2z8nWWWrXgiGe3w5vk15.JkBW', 1, 'Mon Sep 29 2025 08:45:47 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 08:45:47 GMT+0800 (GMT+08:00)', NULL, 1, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (86, '测试用户1759107093870', NULL, '13800005495', NULL, NULL, NULL, NULL, '$2a$10$zWfTST3lbbUgubAaV7XUYO/OWvQ4e.aFApb01q8YNx0CYw7jMOS26', 1, 'Mon Sep 29 2025 08:51:34 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 08:51:34 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (87, '测试用户1759107344742', NULL, '13800001738', NULL, NULL, NULL, NULL, '$2a$10$lZNm.t0vN3TiCwAPxlYcGuAm9QO7bnu9KUgmiAsOiALwO6Mr1VFNK', 1, 'Mon Sep 29 2025 08:55:45 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 08:55:45 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (92, '王五', NULL, '13942841107', NULL, NULL, NULL, NULL, '$2a$10$lvyBNyfeAsNoE7Aiq7be8uWHagrcElwPx1ekSAvQL.b1XmNUd3W3u', 1, 'Mon Sep 29 2025 18:47:21 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:47:21 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (93, '王五', NULL, '13945217', NULL, NULL, NULL, NULL, '$2a$10$rhhZlmV6PP8jLx1YsRhJQuQFzzYyCp6CLbNM30WjtVyrVugJYjdlC', 1, 'Mon Sep 29 2025 18:47:25 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:47:25 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (107, '王五', NULL, '13942896875', NULL, NULL, NULL, NULL, '$2a$10$JCFNNlvuxlKkpi3w7U5L..bwSbtjvJM2RKM.hFncH4rdqXzdz1m3q', 1, 'Mon Sep 29 2025 18:48:17 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:48:17 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (108, '王五', NULL, '13998923', NULL, NULL, NULL, NULL, '$2a$10$aEKM/dOf8c.DsdovVuu7Uu05lMagSbnxFNti4dyOozU2/biudqVf2', 1, 'Mon Sep 29 2025 18:48:19 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:48:19 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (120, '测试员工', NULL, '13800000001', NULL, 'test_employee_openid', 'test_employee_unionid', NULL, '$2a$10$VBHNbQlhM1OnQ8QTLkEVSeXBfLAlD9AJqNjErsYC664SUzMZZxjp.', 1, 'Mon Sep 29 2025 18:48:53 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:48:53 GMT+0800 (GMT+08:00)', NULL, 0, '13800000001'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (121, '测试评委', NULL, '13800000002', NULL, 'test_judge_openid', 'test_judge_unionid', NULL, '$2a$10$VBHNbQlhM1OnQ8QTLkEVSeXBfLAlD9AJqNjErsYC664SUzMZZxjp.', 1, 'Mon Sep 29 2025 18:48:53 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:48:53 GMT+0800 (GMT+08:00)', NULL, 0, '13800000002'); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (122, '王五', NULL, '13942938847', NULL, NULL, NULL, NULL, '$2a$10$3.diloZPEZzq0wdP2jPbIOGL7C93Hs4mR2jhetYayM74txu5wjh5u', 1, 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:48:59 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (123, '王五', NULL, '13940833', NULL, NULL, NULL, NULL, '$2a$10$/lZwlcTM9HGFQc/R7e4n7OIH7hlDDwAAZpILuQqPZM/kMP7Uti.9S', 1, 'Mon Sep 29 2025 18:49:01 GMT+0800 (GMT+08:00)', NULL, 'Mon Sep 29 2025 18:49:01 GMT+0800 (GMT+08:00)', NULL, 0, NULL); INSERT INTO `t_user` (`id`, `name`, `gender`, `phone`, `birthday`, `wx_openid`, `wx_unionid`, `wx_oa_openid`, `password`, `state`, `create_time`, `create_user_id`, `update_time`, `update_user_id`, `version`, `mobile`) VALUES (133, '??????43', NULL, '13800000043', 'Mon Jan 01 1990 00:00:00 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, '$2a$10$ySx04kGprBjPthzie6GbIesKYPlwM.I.elzWU5GQhD8CujxfHZtoy', 1, 'Tue Sep 30 2025 10:02:21 GMT+0800 (GMT+08:00)', NULL, 'Tue Sep 30 2025 10:02:21 GMT+0800 (GMT+08:00)', NULL, 1, NULL); -- ---------------------------- -- Table structure for t_wx_login_record -- ---------------------------- DROP TABLE IF EXISTS `t_wx_login_record`; CREATE TABLE `t_wx_login_record` ( `id` bigint NOT NULL AUTO_INCREMENT COMMENT '主键ID', `wx_openid` varchar(64) COLLATE utf8mb4_general_ci NOT NULL COMMENT '微信openid', `wx_unionid` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信unionid', `user_id` bigint DEFAULT NULL COMMENT '关联的用户ID', `login_time` datetime NOT NULL COMMENT '登录时间', `login_ip` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '登录IP地址', `device_info` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '设备信息', `session_key` varchar(128) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '微信session_key', `phone_authorized` tinyint(1) DEFAULT '0' COMMENT '是否已授权手机号：0-未授权，1-已授权', `phone_auth_time` datetime DEFAULT NULL COMMENT '手机号授权时间', `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', `state` int DEFAULT '1' COMMENT '状态：0-禁用，1-启用', `create_user_id` bigint DEFAULT NULL COMMENT '创建用户ID', `update_user_id` bigint DEFAULT NULL COMMENT '更新用户ID', `version` bigint NOT NULL DEFAULT '0' COMMENT '版本号', PRIMARY KEY (`id`), KEY `idx_wx_openid` (`wx_openid`), KEY `idx_wx_unionid` (`wx_unionid`), KEY `idx_user_id` (`user_id`), KEY `idx_login_time` (`login_time`), KEY `idx_phone_authorized` (`phone_authorized`), KEY `idx_create_user_id` (`create_user_id`), KEY `idx_update_user_id` (`update_user_id`) ) ENGINE=InnoDB AUTO_INCREMENT=122 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='微信登录记录表'; -- ---------------------------- -- Records of t_wx_login_record -- ---------------------------- INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (1, 'test_openid_123', NULL, 54, 'Thu Sep 25 2025 22:36:54 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, 0, NULL, 'Thu Sep 25 2025 22:36:54 GMT+0800 (GMT+08:00)', 'Thu Sep 25 2025 22:36:54 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (2, 'test_openid_456', NULL, 55, 'Thu Sep 25 2025 22:38:13 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, 0, NULL, 'Thu Sep 25 2025 22:38:13 GMT+0800 (GMT+08:00)', 'Thu Sep 25 2025 22:38:13 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (3, 'test_openid_789', NULL, 56, 'Thu Sep 25 2025 22:38:26 GMT+0800 (GMT+08:00)', NULL, NULL, NULL, 0, NULL, 'Thu Sep 25 2025 22:38:26 GMT+0800 (GMT+08:00)', 'Thu Sep 25 2025 22:38:26 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (4, 'test_openid_1758811212038', NULL, 57, 'Thu Sep 25 2025 22:40:12 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', NULL, 0, NULL, 'Thu Sep 25 2025 22:40:12 GMT+0800 (GMT+08:00)', 'Thu Sep 25 2025 22:40:12 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (5, 'test_openid_1758811212020', NULL, 58, 'Thu Sep 25 2025 22:40:12 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', NULL, 0, NULL, 'Thu Sep 25 2025 22:40:12 GMT+0800 (GMT+08:00)', 'Thu Sep 25 2025 22:40:12 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (6, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sat Sep 27 2025 18:49:19 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'PPlR7x40sag8yfXcUeYzIw==', 0, NULL, 'Sat Sep 27 2025 18:49:19 GMT+0800 (GMT+08:00)', 'Sat Sep 27 2025 18:49:19 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (7, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sat Sep 27 2025 18:49:19 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'PPlR7x40sag8yfXcUeYzIw==', 0, NULL, 'Sat Sep 27 2025 18:49:19 GMT+0800 (GMT+08:00)', 'Sat Sep 27 2025 18:49:19 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (8, 'test_openid_1758970258618', 'test_unionid_1758970258619', 60, 'Sat Sep 27 2025 18:50:59 GMT+0800 (GMT+08:00)', '127.0.0.1', 'test_device', 'test_session_key_1758970258619', 0, NULL, 'Sat Sep 27 2025 18:50:59 GMT+0800 (GMT+08:00)', 'Sat Sep 27 2025 18:50:59 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (9, 'test_openid_1758970297509', 'test_unionid_1758970297509', 61, 'Sat Sep 27 2025 18:51:38 GMT+0800 (GMT+08:00)', '127.0.0.1', 'test_device', 'test_session_key_1758970297509', 0, NULL, 'Sat Sep 27 2025 18:51:38 GMT+0800 (GMT+08:00)', 'Sat Sep 27 2025 18:51:38 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (10, 'test_openid_1758984255561', 'test_unionid_1758984255561', 65, 'Sat Sep 27 2025 22:44:16 GMT+0800 (GMT+08:00)', '127.0.0.1', 'test_device', 'test_session_key_1758984255561', 0, NULL, 'Sat Sep 27 2025 22:44:16 GMT+0800 (GMT+08:00)', 'Sat Sep 27 2025 22:44:16 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (11, 'test_openid_1758984267938', 'test_unionid_1758984267938', 66, 'Sat Sep 27 2025 22:44:28 GMT+0800 (GMT+08:00)', '127.0.0.1', 'test_device', 'test_session_key_1758984267938', 0, NULL, 'Sat Sep 27 2025 22:44:28 GMT+0800 (GMT+08:00)', 'Sat Sep 27 2025 22:44:28 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (12, 'test_openid_1759021805903', 'test_unionid_1759021805903', 70, 'Sun Sep 28 2025 09:10:06 GMT+0800 (GMT+08:00)', '192.168.1.100', 'Test Device', 'test_session_key_1759021805903', 0, NULL, 'Sun Sep 28 2025 09:10:06 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 09:10:06 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (13, 'test_openid_1759021932665', 'test_unionid_1759021932665', 71, 'Sun Sep 28 2025 09:12:13 GMT+0800 (GMT+08:00)', '192.168.1.100', 'Test Device', 'test_session_key_1759021932665', 0, NULL, 'Sun Sep 28 2025 09:12:13 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 09:12:13 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (14, 'test_openid_1759022073544', 'test_unionid_1759022073544', 72, 'Sun Sep 28 2025 09:14:34 GMT+0800 (GMT+08:00)', '192.168.1.100', 'Test Device - sessionKey Fix Test', 'test_session_key_1759022073544', 0, NULL, 'Sun Sep 28 2025 09:14:34 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 09:14:34 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (15, 'test_openid_1759022567421', 'test_unionid_1759022567421', 73, 'Sun Sep 28 2025 09:22:48 GMT+0800 (GMT+08:00)', '127.0.0.1', 'test_device', 'test_session_key_1759022567421', 0, NULL, 'Sun Sep 28 2025 09:22:48 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 09:22:48 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (16, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 09:43:39 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 09:43:39 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 09:43:39 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (17, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 09:51:35 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 09:51:35 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 09:51:35 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (18, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 09:58:46 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 09:58:46 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 09:58:46 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (19, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 10:02:24 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 10:02:24 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 10:02:24 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (20, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 10:04:36 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 10:04:36 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 10:04:36 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (21, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 10:07:48 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 10:07:48 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 10:07:48 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (22, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 10:22:18 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 10:22:18 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 10:22:18 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (23, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 10:31:58 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 10:31:58 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 10:31:58 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (24, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 10:33:12 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 10:33:12 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 10:33:12 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (25, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 10:34:12 GMT+0800 (GMT+08:00)', '127.0.0.1', 'test_device', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 10:34:12 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 10:34:12 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (26, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 10:42:31 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 10:42:31 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 10:42:31 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (27, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 10:43:58 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 10:43:58 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 10:43:58 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (28, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 10:46:21 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 10:46:21 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 10:46:21 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (29, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 10:58:38 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 10:58:38 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 10:58:38 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (30, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:01:45 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:01:45 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:01:45 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (31, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:16:49 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:16:49 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:16:49 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (32, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:20:21 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:20:21 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:20:21 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (33, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:31:12 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:31:12 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:31:12 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (34, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:34:43 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:34:43 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:34:43 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (35, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:38:05 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:38:05 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:38:05 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (36, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:42:26 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:42:26 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:42:26 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (37, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:42:36 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:42:36 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:42:36 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (38, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:42:47 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:42:47 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:42:47 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (39, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:42:54 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:42:54 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:42:54 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (40, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:43:02 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:43:02 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:43:02 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (41, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:52:24 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:52:24 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:52:24 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (42, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 11:52:32 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 11:52:32 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 11:52:32 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (43, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 12:01:00 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 12:01:00 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 12:01:00 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (44, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:21:49 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:21:49 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:21:49 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (45, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:26:35 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:26:35 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:26:35 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (46, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:31:30 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:31:30 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:31:30 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (47, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:31:43 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:31:43 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:31:43 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (48, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:35:41 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:35:41 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:35:41 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (49, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:36:15 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:36:15 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:36:15 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (50, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:36:32 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:36:32 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:36:32 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (51, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:42:12 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:42:12 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:42:12 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (52, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:42:27 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:42:27 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:42:27 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (53, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:42:35 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:42:35 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:42:35 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (54, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:43:16 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:43:16 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:43:16 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (55, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:43:54 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:43:54 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:43:54 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (56, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:44:12 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:44:12 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:44:12 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (57, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:44:25 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:44:25 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:44:25 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (58, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:44:41 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:44:41 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:44:41 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (59, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:44:48 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:44:48 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:44:48 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (60, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:44:57 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:44:57 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:44:57 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (61, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:46:38 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:46:38 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:46:38 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (62, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:53:17 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:53:17 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:53:17 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (63, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:57:10 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:57:10 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:57:10 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (64, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:57:22 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:57:22 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:57:22 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (65, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:57:34 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:57:34 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:57:34 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (66, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:57:41 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:57:41 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:57:41 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (67, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:58:07 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:58:07 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:58:07 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (68, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:58:20 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:58:20 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:58:20 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (69, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:58:31 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:58:31 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:58:31 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (70, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:58:46 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:58:46 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:58:46 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (71, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:58:49 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:58:49 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:58:49 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (72, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:58:57 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:58:57 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:58:57 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (73, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:59:07 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:59:07 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:59:07 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (74, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:59:18 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:59:18 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:59:18 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (75, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 13:59:50 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 13:59:50 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 13:59:50 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (76, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 14:00:00 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 14:00:00 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 14:00:00 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (77, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 14:00:11 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 14:00:11 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 14:00:11 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (78, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 14:00:43 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 14:00:43 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 14:00:43 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (79, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 14:00:45 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 14:00:45 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 14:00:45 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (80, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 14:00:47 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 14:00:47 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 14:00:47 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (81, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 14:09:21 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 14:09:21 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 14:09:21 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (82, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 14:14:06 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 14:14:06 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 14:14:06 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (83, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 14:14:24 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NHJCRHrl/6BuYUoyr/Fx0Q==', 0, NULL, 'Sun Sep 28 2025 14:14:24 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 14:14:24 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (84, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 20:04:20 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 20:04:20 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 20:04:20 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (85, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 20:13:15 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 20:13:15 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 20:13:15 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (86, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 20:13:37 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 20:13:37 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 20:13:37 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (87, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 20:13:57 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 20:13:57 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 20:13:57 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (88, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 20:15:41 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 20:15:41 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 20:15:41 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (89, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 20:15:58 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 20:15:58 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 20:15:58 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (90, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 20:16:22 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 20:16:22 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 20:16:22 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (91, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 20:16:33 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 20:16:33 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 20:16:33 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (92, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 20:19:08 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 20:19:08 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 20:19:08 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (93, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 20:21:17 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 20:21:17 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 20:21:17 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (94, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 20:21:44 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 20:21:44 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 20:21:44 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (95, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 22:11:53 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 22:11:53 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 22:11:53 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (96, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 22:49:47 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 22:49:47 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 22:49:47 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (97, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Sun Sep 28 2025 22:58:58 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'kI6uhWBiK+Yhg0DIcghg0A==', 0, NULL, 'Sun Sep 28 2025 22:58:58 GMT+0800 (GMT+08:00)', 'Sun Sep 28 2025 22:58:58 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (98, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 08:22:12 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 08:22:12 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 08:22:12 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (99, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 08:31:24 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 08:31:24 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 08:31:24 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (100, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 08:32:51 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 08:32:51 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 08:32:51 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (101, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 08:33:25 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 08:33:25 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 08:33:25 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (102, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 08:38:37 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 08:38:37 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 08:38:37 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (103, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 08:46:37 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 08:46:37 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 08:46:37 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (104, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 08:48:57 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 08:48:57 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 08:48:57 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (105, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 09:03:20 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 09:03:20 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 09:03:20 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (106, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 09:22:06 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 09:22:06 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 09:22:06 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (107, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 09:40:37 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 09:40:37 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 09:40:37 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (108, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 09:58:33 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 09:58:33 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 09:58:33 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (109, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Mon Sep 29 2025 10:01:54 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'AayzoBmtjQhX3ubh2pWr2Q==', 0, NULL, 'Mon Sep 29 2025 10:01:54 GMT+0800 (GMT+08:00)', 'Mon Sep 29 2025 10:01:54 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (116, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Tue Sep 30 2025 09:07:52 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'Esfw6euQufW7cZop3dgoSg==', 0, NULL, 'Tue Sep 30 2025 09:07:52 GMT+0800 (GMT+08:00)', 'Tue Sep 30 2025 09:07:52 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (117, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Tue Sep 30 2025 09:07:59 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'Esfw6euQufW7cZop3dgoSg==', 0, NULL, 'Tue Sep 30 2025 09:07:59 GMT+0800 (GMT+08:00)', 'Tue Sep 30 2025 09:07:59 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (118, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Tue Sep 30 2025 10:39:12 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'Esfw6euQufW7cZop3dgoSg==', 0, NULL, 'Tue Sep 30 2025 10:39:12 GMT+0800 (GMT+08:00)', 'Tue Sep 30 2025 10:39:12 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (119, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Tue Sep 30 2025 14:05:00 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'Esfw6euQufW7cZop3dgoSg==', 0, NULL, 'Tue Sep 30 2025 14:05:00 GMT+0800 (GMT+08:00)', 'Tue Sep 30 2025 14:05:00 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (120, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Tue Sep 30 2025 14:20:13 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'Esfw6euQufW7cZop3dgoSg==', 0, NULL, 'Tue Sep 30 2025 14:20:13 GMT+0800 (GMT+08:00)', 'Tue Sep 30 2025 14:20:13 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0); INSERT INTO `t_wx_login_record` (`id`, `wx_openid`, `wx_unionid`, `user_id`, `login_time`, `login_ip`, `device_info`, `session_key`, `phone_authorized`, `phone_auth_time`, `create_time`, `update_time`, `state`, `create_user_id`, `update_user_id`, `version`) VALUES (121, 'ogxxA1-KrSVTdqI9T1uaB1BQwPGU', NULL, 59, 'Tue Sep 30 2025 17:39:16 GMT+0800 (GMT+08:00)', '127.0.0.1', 'devtools iPhone 12/13 (Pro) iOS 10.0.1', 'NZCjzJrxBJXrDugAmcxw9Q==', 0, NULL, 'Tue Sep 30 2025 17:39:16 GMT+0800 (GMT+08:00)', 'Tue Sep 30 2025 17:39:16 GMT+0800 (GMT+08:00)', 1, NULL, NULL, 0);