testdata.sql - G10-PT-TRM - Gitiles

 -- MySQL dump 10.13  Distrib 8.0.42, for Linux (x86_64)
 --
 -- Host: localhost    Database: pt_database_test
 -- ------------------------------------------------------
 -- Server version	8.0.42-0ubuntu0.24.04.1

 /*!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 `Announcement`
 --

 DROP TABLE IF EXISTS `Announcement`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Announcement` (
   `announce_id` varchar(64) NOT NULL,
   `content` text NOT NULL,
   `is_public` tinyint(1) NOT NULL DEFAULT '0',
   `tag` varchar(100) DEFAULT NULL,
   PRIMARY KEY (`announce_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `Announcement`
 --

 LOCK TABLES `Announcement` WRITE;
 /*!40000 ALTER TABLE `Announcement` DISABLE KEYS */;
 INSERT INTO `Announcement` VALUES ('a1b2c3d4-e5f6-4711-89ab-cdef01234567','系统升级将在今晚 23:00 开始，预计持续 2 小时，期间可能无法访问。',1,'系统通知'),('a7b8c9d0-e1f2-4d77-ef01-23456789abcd','新增帮助中心文章：如何重置密码以及常见问题解答。',1,'帮助文档'),('b2c3d4e5-f6a7-4822-9abc-def012345678','新版本发布：增加了用户头像上传功能和消息提醒。',1,'产品更新'),('b8c9d0e1-f2a3-4e88-f012-3456789abcde','安全提醒：请尽快启用双因素认证，保障账户安全。',1,'安全提醒'),('c3d4e5f6-a7b8-4933-abcd-ef0123456789','本周末例行数据库维护，可能会短暂影响服务稳定性。',0,'运维公告'),('c9d0e1f2-a3b4-4f99-0123-456789abcdef','服务器证书将于 6 月 15 日过期，请相关负责人及时更新。',0,'运维公告'),('d0e1f2a3-b4c5-4a10-1234-56789abcdef0','本月员工生日会定于 5 月 30 日举办，地点：公司大会议室。',1,'公司活动'),('d4e5f6a7-b8c9-4a44-bcde-f0123456789a','节假日放假通知：5 月 1 日—5 月 3 日放假，共 3 天。',1,'节假日'),('e5f6a7b8-c9d0-4b55-cdef-0123456789ab','用户调查问卷已上线，欢迎参与并反馈使用感受。',1,'用户调研'),('f6a7b8c9-d0e1-4c66-def0-123456789abc','API 接口将于下周三变更，旧版接口将在 6 月底下线。',0,'开发者公告');
 /*!40000 ALTER TABLE `Announcement` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `Appeal`
 --

 DROP TABLE IF EXISTS `Appeal`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Appeal` (
   `appeal_id` varchar(64) NOT NULL COMMENT '申诉ID',
   `user_id` varchar(36) NOT NULL COMMENT '申诉人（User.user_id）',
   `content` text NOT NULL COMMENT '申诉内容',
   `file_url` varchar(255) DEFAULT NULL COMMENT '申诉文件URL',
   `status` int NOT NULL DEFAULT '0' COMMENT '审核状态',
   PRIMARY KEY (`appeal_id`),
   KEY `fk_appeal_user` (`user_id`),
   CONSTRAINT `fk_appeal_user` FOREIGN KEY (`user_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='申诉表，记录用户的申诉信息';
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `Appeal`
 --

 LOCK TABLES `Appeal` WRITE;
 /*!40000 ALTER TABLE `Appeal` DISABLE KEYS */;
 INSERT INTO `Appeal` VALUES ('0307ad3c-09b5-40c0-8aa3-c5a8f0178f4c','550e8400-e29b-41d4-a716-446655440000','GetAppealList test content 9','http://example.com/file9',0),('202dd30a-3ee7-4d0f-a227-0a17325c9c68','550e8400-e29b-41d4-a716-446655440000','GetAppealList test content 8','http://example.com/file8',0),('212d0782-2ccb-4f25-876d-d4be990af7bc','550e8400-e29b-41d4-a716-446655440000','GetAppealList test content 6','http://example.com/file6',0),('4995a460-128e-4886-8682-e75bbb2dbce2','550e8400-e29b-41d4-a716-446655440000','GetAppealList test content 1','http://example.com/file1',0),('7b9c4044-39b6-41b5-8754-ff784788f116','550e8400-e29b-41d4-a716-446655440000','GetAppealList test content 2','http://example.com/file2',0),('a38fa86d-9bce-4342-852d-272566e46553','550e8400-e29b-41d4-a716-446655440000','GetAppealList test content 3','http://example.com/file3',0),('a6345f31-6938-4ff9-8c1e-0f5b3c9d6d56','550e8400-e29b-41d4-a716-446655440000','GetAppealList test content 5','http://example.com/file5',0),('b1c3fcdd-6c25-42d2-9782-cae4bd609368','550e8400-e29b-41d4-a716-446655440000','GetAppealList test content 0','http://example.com/file0',0),('bef4085a-1ec3-40ea-a43c-1964c9180e9d','550e8400-e29b-41d4-a716-446655440000','GetAppealList test content 7','http://example.com/file7',0),('ce843f31-eb01-4954-a234-d175d262bfdc','550e8400-e29b-41d4-a716-446655440000','GetAppealList test content 4','http://example.com/file4',0);
 /*!40000 ALTER TABLE `Appeal` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `BegSeed`
 --

 DROP TABLE IF EXISTS `BegSeed`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `BegSeed` (
   `beg_id` varchar(64) NOT NULL,
   `beg_count` int NOT NULL DEFAULT '0',
   `reward_magic` int NOT NULL DEFAULT '0',
   `deadline` datetime NOT NULL,
   `has_match` tinyint(1) NOT NULL DEFAULT '0',
   PRIMARY KEY (`beg_id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `BegSeed`
 --

 LOCK TABLES `BegSeed` WRITE;
 /*!40000 ALTER TABLE `BegSeed` DISABLE KEYS */;
 INSERT INTO `BegSeed` VALUES ('test_beg_settle_1749112257693',1,100,'2025-05-21 08:30:58',1),('test_beg_settle_1749113033612',1,100,'2025-05-21 08:43:54',1),('test_beg_settle_1749115170790',1,100,'2025-05-21 09:19:31',1);
 /*!40000 ALTER TABLE `BegSeed` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `Post`
 --

 DROP TABLE IF EXISTS `Post`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Post` (
   `post_id` varchar(64) NOT NULL,
   `title` varchar(255) NOT NULL,
   `content` text NOT NULL,
   `author_id` varchar(36) NOT NULL,
   `created_at` datetime NOT NULL,
   `reply_count` int NOT NULL DEFAULT '0',
   `view_count` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`post_id`),
   KEY `fk_post_user` (`author_id`),
   CONSTRAINT `fk_post_user` FOREIGN KEY (`author_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `Post`
 --

 LOCK TABLES `Post` WRITE;
 /*!40000 ALTER TABLE `Post` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Post` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `PostReply`
 --

 DROP TABLE IF EXISTS `PostReply`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `PostReply` (
   `reply_id` varchar(64) NOT NULL,
   `post_id` varchar(64) NOT NULL,
   `content` text NOT NULL,
   `author_id` varchar(36) NOT NULL,
   `created_at` datetime NOT NULL,
   PRIMARY KEY (`reply_id`),
   KEY `fk_pr_post` (`post_id`),
   KEY `fk_pr_user` (`author_id`),
   CONSTRAINT `fk_pr_post` FOREIGN KEY (`post_id`) REFERENCES `Post` (`post_id`) ON DELETE CASCADE,
   CONSTRAINT `fk_pr_user` FOREIGN KEY (`author_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `PostReply`
 --

 LOCK TABLES `PostReply` WRITE;
 /*!40000 ALTER TABLE `PostReply` DISABLE KEYS */;
 /*!40000 ALTER TABLE `PostReply` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `Seed`
 --

 DROP TABLE IF EXISTS `Seed`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Seed` (
   `seed_id` varchar(64) NOT NULL,
   `owner_user_id` varchar(36) NOT NULL,
   `fake_hits` int NOT NULL DEFAULT '0',
   `last_fake_check` datetime DEFAULT NULL,
   `external_url` varchar(255) DEFAULT NULL,
   `title` varchar(255) NOT NULL,
   `subtitle` varchar(255) DEFAULT NULL,
   `size` varchar(50) NOT NULL,
   `tags` varchar(255) DEFAULT NULL,
   `popularity` int NOT NULL DEFAULT '0',
   `URL` text COMMENT 'TTorrent 文件在服务器上存储的 URL',
   PRIMARY KEY (`seed_id`),
   KEY `fk_seed_user` (`owner_user_id`),
   CONSTRAINT `fk_seed_user` FOREIGN KEY (`owner_user_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `Seed`
 --

 LOCK TABLES `Seed` WRITE;
 /*!40000 ALTER TABLE `Seed` DISABLE KEYS */;
 INSERT INTO `Seed` VALUES ('exampleSeedId','550e8400-e29b-41d4-a716-446655440000',0,NULL,NULL,'test',NULL,'1GB','大陆',0,'torrents/exampleSeedId_exampleSeedId_test16436511100052430070.torrent'),('seed001','550e8400-e29b-41d4-a716-446655440000',10,'2025-05-19 10:00:00','http://example.com/seed001','Awesome Movie','Action Thriller','1.5GB','大陆',100,'torrents/seed001_seed001_test17718681796068962628.torrent'),('seed004','550e8400-e29b-41d4-a716-446655440003',8,'2025-05-19 11:00:00','http://example.com/seed004','Comedy Series','Season 1','700MB','大陆',75,'torrents/seed004_seed004_test2953554280018110244.torrent'),('seed009','550e8400-e29b-41d4-a716-446655440008',18,'2025-05-17 21:45:00','http://example.com/seed009','Sci-Fi Movie','Space Odyssey','2GB','港台',180,'torrents/seed009_seed009_test13451296490325930642.torrent'),('seed111','550e8400-e29b-41d4-a716-446655440003',0,NULL,NULL,'test2',NULL,'1',NULL,0,'torrents/seed111_seed111_test14021531522609506819.torrent'),('seed222','550e8400-e29b-41d4-a716-446655440003',0,NULL,NULL,'test3',NULL,'1','港剧',0,'torrents/seed222_seed222_test11259979984170882790.torrent'),('test_seed_settle_1749111508968','550e8400-e29b-41d4-a716-446655440000',0,NULL,NULL,'测试种子',NULL,'1',NULL,0,'torrents/test_seed_settle_1749111508968_test_seed_settle_1749111508968_test14644621044707116370.torrent'),('test_seed_settle_1749111581741','550e8400-e29b-41d4-a716-446655440000',0,NULL,NULL,'测试种子',NULL,'1',NULL,0,'torrents/test_seed_settle_1749111581741_test_seed_settle_1749111581741_test4953741892853909459.torrent'),('test_seed_settle_1749112208219','550e8400-e29b-41d4-a716-446655440000',0,NULL,NULL,'测试种子',NULL,'1',NULL,0,'torrents/test_seed_settle_1749112208219_test_seed_settle_1749112208219_test3659044688757063978.torrent'),('test_seed_settle_1749112257695','550e8400-e29b-41d4-a716-446655440000',0,NULL,NULL,'测试种子',NULL,'1',NULL,0,'torrents/test_seed_settle_1749112257695_test_seed_settle_1749112257695_test17979750181307660047.torrent'),('test_seed_settle_1749113033614','550e8400-e29b-41d4-a716-446655440000',0,NULL,NULL,'测试种子',NULL,'1',NULL,0,'torrents/test_seed_settle_1749113033614_test_seed_settle_1749113033614_test13945890241269543288.torrent'),('test_seed_settle_1749115170791','550e8400-e29b-41d4-a716-446655440000',0,NULL,NULL,'测试种子',NULL,'1',NULL,0,NULL);
 /*!40000 ALTER TABLE `Seed` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `SeedDownload`
 --

 DROP TABLE IF EXISTS `SeedDownload`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `SeedDownload` (
   `task_id` varchar(64) NOT NULL,
   `user_id` varchar(36) NOT NULL,
   `seed_id` varchar(64) NOT NULL,
   `download_start` datetime NOT NULL,
   `download_end` datetime DEFAULT NULL,
   `is_dedicated` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=普通,1=专线',
   `client_ip` varchar(45) DEFAULT NULL,
   PRIMARY KEY (`task_id`),
   KEY `fk_sd_user` (`user_id`),
   KEY `fk_sd_seed` (`seed_id`),
   CONSTRAINT `fk_sd_seed` FOREIGN KEY (`seed_id`) REFERENCES `Seed` (`seed_id`) ON DELETE CASCADE,
   CONSTRAINT `fk_sd_user` FOREIGN KEY (`user_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `SeedDownload`
 --

 LOCK TABLES `SeedDownload` WRITE;
 /*!40000 ALTER TABLE `SeedDownload` DISABLE KEYS */;
 INSERT INTO `SeedDownload` VALUES ('3717648a-3ac0-11f0-b2ca-bc2411405807','550e8400-e29b-41d4-a716-446655440000','seed001','2025-05-01 09:12:34','2025-05-01 09:15:02',1,NULL),('3717762c-3ac0-11f0-b2ca-bc2411405807','550e8400-e29b-41d4-a716-446655440003','seed004','2025-05-04 07:30:10','2025-05-04 07:35:55',1,NULL),('3717806c-3ac0-11f0-b2ca-bc2411405807','550e8400-e29b-41d4-a716-446655440008','seed009','2025-05-09 05:05:05',NULL,0,NULL);
 /*!40000 ALTER TABLE `SeedDownload` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `SubmitSeed`
 --

 DROP TABLE IF EXISTS `SubmitSeed`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `SubmitSeed` (
   `beg_id` varchar(64) NOT NULL,
   `seed_id` varchar(64) NOT NULL,
   `votes` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`beg_id`,`seed_id`),
   KEY `fk_ss_seed` (`seed_id`),
   CONSTRAINT `fk_ss_beg` FOREIGN KEY (`beg_id`) REFERENCES `BegSeed` (`beg_id`) ON DELETE CASCADE,
   CONSTRAINT `fk_ss_seed` FOREIGN KEY (`seed_id`) REFERENCES `Seed` (`seed_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `SubmitSeed`
 --

 LOCK TABLES `SubmitSeed` WRITE;
 /*!40000 ALTER TABLE `SubmitSeed` DISABLE KEYS */;
 INSERT INTO `SubmitSeed` VALUES ('test_beg_settle_1749112257693','test_seed_settle_1749112257695',1),('test_beg_settle_1749113033612','test_seed_settle_1749113033614',1),('test_beg_settle_1749115170790','test_seed_settle_1749115170791',1);
 /*!40000 ALTER TABLE `SubmitSeed` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `Transport`
 --

 DROP TABLE IF EXISTS `Transport`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `Transport` (
   `task_id` varchar(64) NOT NULL,
   `uploader_id` varchar(36) NOT NULL,
   `downloader_id` varchar(36) NOT NULL,
   `seed_id` varchar(64) NOT NULL,
   `uploaded` bigint NOT NULL DEFAULT '0',
   `downloaded` bigint NOT NULL DEFAULT '0',
   `upload_peak` bigint NOT NULL DEFAULT '0',
   `download_peak` bigint NOT NULL DEFAULT '0',
   PRIMARY KEY (`task_id`,`uploader_id`,`downloader_id`),
   KEY `fk_tr_user_up` (`uploader_id`),
   KEY `fk_tr_user_down` (`downloader_id`),
   KEY `fk_tr_seed` (`seed_id`),
   CONSTRAINT `fk_tr_seed` FOREIGN KEY (`seed_id`) REFERENCES `Seed` (`seed_id`) ON DELETE CASCADE,
   CONSTRAINT `fk_tr_user_down` FOREIGN KEY (`downloader_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE,
   CONSTRAINT `fk_tr_user_up` FOREIGN KEY (`uploader_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `Transport`
 --

 LOCK TABLES `Transport` WRITE;
 /*!40000 ALTER TABLE `Transport` DISABLE KEYS */;
 /*!40000 ALTER TABLE `Transport` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `User`
 --

 DROP TABLE IF EXISTS `User`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `User` (
   `user_id` varchar(36) NOT NULL,
   `email` varchar(255) NOT NULL,
   `username` varchar(100) NOT NULL,
   `password` varchar(255) NOT NULL,
   `gender` enum('m','f') NOT NULL,
   `school` varchar(255) DEFAULT NULL,
   `avatar_url` varchar(255) DEFAULT NULL,
   `bio` text,
   `account_status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=正常,1=被ban',
   `invite_left` int NOT NULL DEFAULT '0',
   `detectedCount` int NOT NULL DEFAULT '0',
   `lastDetectedTime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   `fake_detected_count` int NOT NULL DEFAULT '0',
   `fake_last_detected_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`user_id`,`email`),
   UNIQUE KEY `uniq_email` (`email`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `User`
 --

 LOCK TABLES `User` WRITE;
 /*!40000 ALTER TABLE `User` DISABLE KEYS */;
 INSERT INTO `User` VALUES ('550e8400-e29b-41d4-a716-446655440000','alice@example.com','alice','$2y$10$abcdefghijklmnopqrstuv','f','Stanford University','https://cdn.example.com/avatars/alice.jpg','Passionate swimmer and coder.',0,5,0,'2025-05-20 12:29:40',0,'2025-05-27 09:37:46'),('550e8400-e29b-41d4-a716-446655440003','dave@example.net','dave','$2y$10$mnopqrstuvwxyzABCDEF','m','University of Oxford','https://cdn.example.com/avatars/dave.jpg','Guitarist in a jazz band.',0,0,0,'2025-05-20 12:29:40',0,'2025-05-27 09:37:46'),('550e8400-e29b-41d4-a716-446655440008','irene@example.org','irene','$2y$10$34567890abcdefghijklmn','f','National University of Singapore','https://cdn.example.com/avatars/irene.jpg','Time-lapse photographer and traveler.',0,0,0,'2025-05-20 12:29:40',0,'2025-05-27 09:37:46');
 /*!40000 ALTER TABLE `User` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `UserFavorite`
 --

 DROP TABLE IF EXISTS `UserFavorite`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `UserFavorite` (
   `user_id` varchar(36) NOT NULL,
   `seed_id` varchar(64) NOT NULL,
   PRIMARY KEY (`user_id`,`seed_id`),
   UNIQUE KEY `UK_dqxat2yuess97ol62itck0bul` (`user_id`),
   UNIQUE KEY `UK_kf5p3eu6m26b6afhmmfcbdn8j` (`seed_id`),
   KEY `fk_uf_seed` (`seed_id`),
   CONSTRAINT `fk_uf_seed` FOREIGN KEY (`seed_id`) REFERENCES `Seed` (`seed_id`) ON DELETE CASCADE,
   CONSTRAINT `fk_uf_user` FOREIGN KEY (`user_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `UserFavorite`
 --

 LOCK TABLES `UserFavorite` WRITE;
 /*!40000 ALTER TABLE `UserFavorite` DISABLE KEYS */;
 INSERT INTO `UserFavorite` VALUES ('550e8400-e29b-41d4-a716-446655440000','seed004'),('550e8400-e29b-41d4-a716-446655440003','seed009'),('550e8400-e29b-41d4-a716-446655440008','seed001');
 /*!40000 ALTER TABLE `UserFavorite` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `UserInvite`
 --

 DROP TABLE IF EXISTS `UserInvite`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `UserInvite` (
   `user_id` varchar(36) NOT NULL,
   `inviter_email` varchar(255) NOT NULL,
   `inviter_registered` tinyint(1) NOT NULL DEFAULT '0',
   PRIMARY KEY (`user_id`,`inviter_email`),
   CONSTRAINT `fk_ui_user` FOREIGN KEY (`user_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `UserInvite`
 --

 LOCK TABLES `UserInvite` WRITE;
 /*!40000 ALTER TABLE `UserInvite` DISABLE KEYS */;
 INSERT INTO `UserInvite` VALUES ('550e8400-e29b-41d4-a716-446655440000','user009@example.com',1),('550e8400-e29b-41d4-a716-446655440003','user002@example.com',1),('550e8400-e29b-41d4-a716-446655440008','user007@example.com',1);
 /*!40000 ALTER TABLE `UserInvite` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `UserMigration`
 --

 DROP TABLE IF EXISTS `UserMigration`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `UserMigration` (
   `migration_id` varchar(64) NOT NULL,
   `user_id` varchar(36) NOT NULL,
   `application_url` varchar(255) NOT NULL,
   `approved` tinyint(1) NOT NULL DEFAULT '0',
   `pending_magic` int NOT NULL DEFAULT '0',
   `granted_magic` int NOT NULL DEFAULT '0',
   `pending_uploaded` bigint NOT NULL DEFAULT '0',
   `granted_uploaded` bigint NOT NULL DEFAULT '0',
   PRIMARY KEY (`migration_id`),
   KEY `fk_um_user` (`user_id`),
   CONSTRAINT `fk_um_user` FOREIGN KEY (`user_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `UserMigration`
 --

 LOCK TABLES `UserMigration` WRITE;
 /*!40000 ALTER TABLE `UserMigration` DISABLE KEYS */;
 /*!40000 ALTER TABLE `UserMigration` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `UserPT`
 --

 DROP TABLE IF EXISTS `UserPT`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `UserPT` (
   `user_id` varchar(36) NOT NULL,
   `magic` int NOT NULL DEFAULT '0',
   `uploaded` bigint NOT NULL DEFAULT '0',
   `downloaded` bigint NOT NULL DEFAULT '0',
   `ratio` decimal(5,2) NOT NULL DEFAULT '0.00',
   `default_seed_path` varchar(255) DEFAULT NULL,
   `vip_downloads` int NOT NULL DEFAULT '0',
   PRIMARY KEY (`user_id`),
   CONSTRAINT `fk_pt_user` FOREIGN KEY (`user_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `UserPT`
 --

 LOCK TABLES `UserPT` WRITE;
 /*!40000 ALTER TABLE `UserPT` DISABLE KEYS */;
 INSERT INTO `UserPT` VALUES ('550e8400-e29b-41d4-a716-446655440000',0,0,0,0.00,'/data/seeds/550e8400-e29b-41d4-a716-446655440000',0),('550e8400-e29b-41d4-a716-446655440003',4096,4194304,2097152,2.00,'/data/seeds/550e8400-e29b-41d4-a716-446655440003',5),('550e8400-e29b-41d4-a716-446655440008',65536,65536000,32768000,2.00,'/data/seeds/550e8400-e29b-41d4-a716-446655440008',6);
 /*!40000 ALTER TABLE `UserPT` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `UserVotes`
 --

 DROP TABLE IF EXISTS `UserVotes`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `UserVotes` (
   `user_id` varchar(36) NOT NULL,
   `beg_id` varchar(64) NOT NULL,
   `seed_id` varchar(64) NOT NULL,
   `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
   PRIMARY KEY (`user_id`,`beg_id`,`seed_id`),
   KEY `beg_id` (`beg_id`),
   KEY `seed_id` (`seed_id`),
   CONSTRAINT `UserVotes_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `User` (`user_id`) ON DELETE CASCADE,
   CONSTRAINT `UserVotes_ibfk_2` FOREIGN KEY (`beg_id`) REFERENCES `BegSeed` (`beg_id`) ON DELETE CASCADE,
   CONSTRAINT `UserVotes_ibfk_3` FOREIGN KEY (`seed_id`) REFERENCES `Seed` (`seed_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `UserVotes`
 --

 LOCK TABLES `UserVotes` WRITE;
 /*!40000 ALTER TABLE `UserVotes` DISABLE KEYS */;
 INSERT INTO `UserVotes` VALUES ('550e8400-e29b-41d4-a716-446655440000','test_beg_settle_1749112257693','test_seed_settle_1749112257695','2025-06-05 08:30:58'),('550e8400-e29b-41d4-a716-446655440000','test_beg_settle_1749113033612','test_seed_settle_1749113033614','2025-06-05 08:43:54'),('550e8400-e29b-41d4-a716-446655440000','test_beg_settle_1749115170790','test_seed_settle_1749115170791','2025-06-05 09:19:31');
 /*!40000 ALTER TABLE `UserVotes` ENABLE KEYS */;
 UNLOCK TABLES;

 --
 -- Table structure for table `VipSeed`
 --

 DROP TABLE IF EXISTS `VipSeed`;
 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 /*!50503 SET character_set_client = utf8mb4 */;
 CREATE TABLE `VipSeed` (
   `seed_id` varchar(64) NOT NULL,
   `seeder_count` int NOT NULL DEFAULT '0',
   `reward_magic` int NOT NULL DEFAULT '0',
   `stop_caching` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=继续缓存,1=不缓存',
   `bonus` int NOT NULL,
   `cache_status` bit(1) NOT NULL,
   `farmer_number` int NOT NULL,
   PRIMARY KEY (`seed_id`),
   CONSTRAINT `fk_vip_seed` FOREIGN KEY (`seed_id`) REFERENCES `Seed` (`seed_id`) ON DELETE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;

 --
 -- Dumping data for table `VipSeed`
 --

 LOCK TABLES `VipSeed` WRITE;
 /*!40000 ALTER TABLE `VipSeed` DISABLE KEYS */;
 INSERT INTO `VipSeed` VALUES ('seed001',5,50,0,10,_binary '',2),('seed004',8,80,0,15,_binary '',4),('seed009',30,300,0,60,_binary '\0',15);
 /*!40000 ALTER TABLE `VipSeed` ENABLE KEYS */;
 UNLOCK TABLES;
 /*!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-06-05  9:45:32