From 9f8395fab13ca4b230a0f7d62636e209745c91d4 Mon Sep 17 00:00:00 2001 From: lrj <owen.stl@gmail.com> Date: 星期日, 28 九月 2025 14:16:18 +0800 Subject: [PATCH] feat: 完善注册流程的文件上传功能 --- db.sql | 74 ++++++++++++++++++++++++------------ 1 files changed, 49 insertions(+), 25 deletions(-) diff --git a/db.sql b/db.sql index bb5e6e1..b67c704 100644 --- a/db.sql +++ b/db.sql @@ -1,5 +1,5 @@ --- Database schema dump for ryc --- Generated at: Wed Sep 24 16:07:24 GMT+08:00 2025 +-- Database schema for ryc +-- Generated at: 2025/9/27 19:34:25 -- Table: t_activity CREATE TABLE `t_activity` ( @@ -40,7 +40,7 @@ `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=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_activity_player CREATE TABLE `t_activity_player` ( @@ -48,25 +48,29 @@ `activity_id` bigint NOT NULL, `stage_id` bigint NOT NULL COMMENT '姣旇禌闃舵锛岄�昏緫鍜宼_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=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_activity_player_rating CREATE TABLE `t_activity_player_rating` ( - `id` bigint NOT NULL, + `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, @@ -79,7 +83,7 @@ `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; +) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- Table: t_activity_player_rating_item CREATE TABLE `t_activity_player_rating_item` ( @@ -101,7 +105,7 @@ `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE -) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_carousel CREATE TABLE `t_carousel` ( @@ -116,14 +120,13 @@ `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 COMMENT='杞挱鍥�'; +) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='杞挱鍥�'; -- Table: 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, - `password` varchar(128) 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, @@ -135,7 +138,7 @@ `description` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `phone` (`phone`) USING BTREE -) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_employee_role CREATE TABLE `t_employee_role` ( @@ -171,7 +174,7 @@ `introduction` text COMMENT '涓汉浠嬬粛', PRIMARY KEY (`id`) USING BTREE, UNIQUE KEY `phone` (`phone`) USING BTREE -) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_judge_tag CREATE TABLE `t_judge_tag` ( @@ -186,7 +189,7 @@ `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=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_media CREATE TABLE `t_media` ( @@ -201,14 +204,14 @@ `file_size` int NOT NULL, `duration` int DEFAULT NULL COMMENT '瑙嗛鐨勯暱搴︾', `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, - `state` 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 -) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_notification_task CREATE TABLE `t_notification_task` ( @@ -258,7 +261,6 @@ `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, - `audit_state` int NOT NULL COMMENT '0绛夊緟瀹℃牳锛�1锛氬鏍搁�氳繃锛�2锛氫笉閫氳繃', `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, @@ -269,9 +271,8 @@ `version` bigint NOT NULL DEFAULT '0', `user_id` bigint NOT NULL, PRIMARY KEY (`id`) USING BTREE, - UNIQUE KEY `phone` (`phone`) USING BTREE, - KEY `idx_t_player_activity_status` (`audit_state`) USING BTREE -) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + UNIQUE KEY `phone` (`phone`) USING BTREE +) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_rating_item CREATE TABLE `t_rating_item` ( @@ -289,7 +290,7 @@ PRIMARY KEY (`id`) USING BTREE, KEY `idx_t_rating_item_scheme` (`scheme_id`) USING BTREE, CONSTRAINT `fk_t_rating_item_scheme` FOREIGN KEY (`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; +) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_rating_scheme CREATE TABLE `t_rating_scheme` ( @@ -303,7 +304,7 @@ `update_user_id` bigint DEFAULT NULL, `version` bigint NOT NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE -) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; -- Table: t_region CREATE TABLE `t_region` ( @@ -380,8 +381,8 @@ `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 NOT NULL, - `wx_unionid` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT 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, @@ -392,7 +393,30 @@ `version` bigint NOT NULL DEFAULT '0', `mobile` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, - KEY `uq_openid` (`wx_openid`) USING BTREE, - KEY `uq_unionid` (`wx_unionid`) USING BTREE -) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + UNIQUE KEY `uq_wx_open_id` (`wx_openid`) USING BTREE, + UNIQUE KEY `uq_phone` (`phone`) +) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + +-- Table: 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 '鍏宠仈鐨勭敤鎴稩D', + `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` tinyint(1) DEFAULT '1' COMMENT '鐘舵�侊細0-绂佺敤锛�1-鍚敤', + 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`) +) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='寰俊鐧诲綍璁板綍琛�'; -- Gitblit v1.8.0