-- MySQL dump 10.13 Distrib 8.0.41, for Win64 (x86_64) -- -- Host: gitnexus.cn Database: gitnexus -- ------------------------------------------------------ -- Server version 8.0.35 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `commit_summary_tasks` -- DROP TABLE IF EXISTS `commit_summary_tasks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `commit_summary_tasks` ( `id` int NOT NULL AUTO_INCREMENT, `create_user` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `create_time` bigint NOT NULL, `start_time` bigint DEFAULT NULL COMMENT '开始总结时间 毫秒时间戳', `end_time` bigint DEFAULT NULL COMMENT '总结完成时间 毫秒时间戳', `result` json DEFAULT NULL COMMENT '返回结果 文本 可不要求JSON', `repo_id` int NOT NULL COMMENT '仓库id', `repo_hash` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '该commit的hash', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='提交信息总结'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `file_summary_tasks` -- DROP TABLE IF EXISTS `file_summary_tasks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `file_summary_tasks` ( `id` int NOT NULL AUTO_INCREMENT, `create_user` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `create_time` bigint NOT NULL, `start_time` bigint DEFAULT NULL COMMENT '开始总结时间 毫秒时间戳', `end_time` bigint DEFAULT NULL COMMENT '总结完成时间 毫秒时间戳', `result` json DEFAULT NULL COMMENT '返回结果 文本 可不要求JSON', `repo_id` int NOT NULL COMMENT '仓库id', `repo_hash` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `filepath` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '文件在仓库中的路径', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='代码总结'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `messages` -- DROP TABLE IF EXISTS `messages`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `messages` ( `id` int NOT NULL AUTO_INCREMENT, `uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息内容', `time` bigint NOT NULL COMMENT '发送时间', `read` int NOT NULL DEFAULT '0' COMMENT '是否已读', `type` varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '消息类型 user/system/ai', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=119 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `repos` -- DROP TABLE IF EXISTS `repos`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `repos` ( `id` int NOT NULL AUTO_INCREMENT COMMENT '仓库id', `name` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '仓库名称 仅备注 无实际作用', `path` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '仓库在服务器中存放的路径', `url` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '远端url', `create_user` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL, `create_time` bigint NOT NULL, `state` int NOT NULL DEFAULT '0' COMMENT '仓库状态 0待克隆 1已克隆 2克隆失败', `logo` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'logo图片', `update_time` bigint DEFAULT NULL COMMENT '更新时间 毫秒级时间戳', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=69 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='仓库表'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `scan_tasks` -- DROP TABLE IF EXISTS `scan_tasks`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `scan_tasks` ( `id` int NOT NULL AUTO_INCREMENT, `repo_id` int NOT NULL COMMENT '对应仓库id', `state` int NOT NULL DEFAULT '0' COMMENT '任务状态 0待处理 1进行中 2已完成 3状态异常', `result` json DEFAULT NULL COMMENT '扫描结果 JSON格式', `create_time` bigint NOT NULL, `scan_start_time` bigint DEFAULT NULL COMMENT '开始扫描时间 毫秒时间戳', `scan_end_time` bigint DEFAULT NULL COMMENT '扫描完成时间', `create_user` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '发起用户', `repo_hash` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '提交hash 扫描时仓库所处状态的hash', `type` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '扫描类型', `source` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'hand手动发起 auto自动扫描', `name` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '扫描任务名称', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=89 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='代码扫描任务'; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `users` ( `id` int NOT NULL AUTO_INCREMENT, `uuid` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `username` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `session` varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL, `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `permission` json DEFAULT NULL, `git_info` json DEFAULT NULL, `avatar` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT 'https://p1-arco.byteimg.com/tos-cn-i-uwbnlip3yd/3ee5f13fb09879ecb5185e440cef6eb9.png~tplv-uwbnlip3yd-webp.webp', `email` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL, `registTime` bigint NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping routines for database 'gitnexus' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2025-04-26 22:50:14