vulgar5201 | 2cebf7c | 2025-06-07 17:58:05 +0800 | [diff] [blame^] | 1 | /*
|
| 2 | Navicat Premium Dump SQL
|
| 3 |
|
| 4 | Source Server : first
|
| 5 | Source Server Type : MySQL
|
| 6 | Source Server Version : 80036 (8.0.36)
|
| 7 | Source Host : localhost:3306
|
| 8 | Source Schema : ppt
|
| 9 |
|
| 10 | Target Server Type : MySQL
|
| 11 | Target Server Version : 80036 (8.0.36)
|
| 12 | File Encoding : 65001
|
| 13 |
|
| 14 | Date: 04/06/2025 14:33:40
|
| 15 | */
|
| 16 |
|
| 17 | SET NAMES utf8mb4;
|
| 18 | SET FOREIGN_KEY_CHECKS = 0;
|
| 19 |
|
| 20 | -- ----------------------------
|
| 21 | -- Table structure for categories
|
| 22 | -- ----------------------------
|
| 23 | DROP TABLE IF EXISTS `categories`;
|
| 24 | CREATE TABLE `categories` (
|
| 25 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 26 | `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 27 | `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 28 | `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 29 | PRIMARY KEY (`id`) USING BTREE,
|
| 30 | UNIQUE INDEX `uk_categories_slug`(`slug` ASC) USING BTREE,
|
| 31 | UNIQUE INDEX `UKoul14ho7bctbefv8jywp5v3i2`(`slug` ASC) USING BTREE,
|
| 32 | INDEX `idx_categories_slug`(`slug` ASC) USING BTREE,
|
| 33 | INDEX `IDXoul14ho7bctbefv8jywp5v3i2`(`slug` ASC) USING BTREE
|
| 34 | ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 35 |
|
| 36 | -- ----------------------------
|
| 37 | -- Records of categories
|
| 38 | -- ----------------------------
|
| 39 | INSERT INTO `categories` VALUES (1, 'os', '操作系统', 'os-icon.png');
|
| 40 |
|
| 41 | -- ----------------------------
|
| 42 | -- Table structure for exam_plans
|
| 43 | -- ----------------------------
|
| 44 | DROP TABLE IF EXISTS `exam_plans`;
|
| 45 | CREATE TABLE `exam_plans` (
|
| 46 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 47 | `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 48 | `downloaded` bigint NOT NULL,
|
| 49 | `duration` bigint NOT NULL,
|
| 50 | `karma` double NOT NULL,
|
| 51 | `seeding_time` bigint NOT NULL,
|
| 52 | `seeds` bigint NOT NULL,
|
| 53 | `share_ratio` double NOT NULL,
|
| 54 | `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 55 | `uploaded` bigint NOT NULL,
|
| 56 | PRIMARY KEY (`id`) USING BTREE,
|
| 57 | UNIQUE INDEX `UK74jaepieaj2umswpqn16yy3x5`(`slug` ASC) USING BTREE,
|
| 58 | INDEX `IDX74jaepieaj2umswpqn16yy3x5`(`slug` ASC) USING BTREE
|
| 59 | ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 60 |
|
| 61 | -- ----------------------------
|
| 62 | -- Records of exam_plans
|
| 63 | -- ----------------------------
|
| 64 |
|
| 65 | -- ----------------------------
|
| 66 | -- Table structure for exams
|
| 67 | -- ----------------------------
|
| 68 | DROP TABLE IF EXISTS `exams`;
|
| 69 | CREATE TABLE `exams` (
|
| 70 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 71 | `end_at` datetime(6) NOT NULL,
|
| 72 | `exam_plan_id` bigint NULL DEFAULT NULL,
|
| 73 | `user_id` bigint NULL DEFAULT NULL,
|
| 74 | PRIMARY KEY (`id`) USING BTREE,
|
| 75 | UNIQUE INDEX `UK2wii0igd3vdfecy00op0un4qt`(`user_id` ASC) USING BTREE,
|
| 76 | INDEX `IDX2wii0igd3vdfecy00op0un4qt`(`user_id` ASC) USING BTREE,
|
| 77 | INDEX `FKl0cips1gany3cuppyfs7ntpai`(`exam_plan_id` ASC) USING BTREE,
|
| 78 | CONSTRAINT `FKi63cpl1xkgy32iq68ru4ypjn4` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
| 79 | CONSTRAINT `FKl0cips1gany3cuppyfs7ntpai` FOREIGN KEY (`exam_plan_id`) REFERENCES `exam_plans` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 80 | ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 81 |
|
| 82 | -- ----------------------------
|
| 83 | -- Records of exams
|
| 84 | -- ----------------------------
|
| 85 |
|
| 86 | -- ----------------------------
|
| 87 | -- Table structure for login_history
|
| 88 | -- ----------------------------
|
| 89 | DROP TABLE IF EXISTS `login_history`;
|
| 90 | CREATE TABLE `login_history` (
|
| 91 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 92 | `user_id` bigint NOT NULL,
|
| 93 | `time` timestamp NOT NULL,
|
| 94 | `type` enum('ACCOUNT','PASSKEY','PERSONAL_ACCESSTOKEN','PROGRAM_INTERNAL','TWO_STEP_VERIFICATION') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 95 | `ip_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 96 | `user_agent` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 97 | `location` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 98 | PRIMARY KEY (`id`) USING BTREE,
|
| 99 | INDEX `idx_login_time`(`time` ASC) USING BTREE,
|
| 100 | INDEX `fk_loginhistory_user`(`user_id` ASC) USING BTREE,
|
| 101 | INDEX `IDX3lft44makrxommxm63k7xj77d`(`time` ASC) USING BTREE,
|
| 102 | CONSTRAINT `fk_loginhistory_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
|
| 103 | ) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 104 |
|
| 105 | -- ----------------------------
|
| 106 | -- Records of login_history
|
| 107 | -- ----------------------------
|
| 108 | INSERT INTO `login_history` VALUES (1, 1, '2025-06-03 12:25:33', 'ACCOUNT', '0:0:0:0:0:0:0:1', 'PostmanRuntime/7.43.4', 'Unknown - GeoIP not initialized');
|
| 109 | INSERT INTO `login_history` VALUES (2, 1, '2025-06-03 12:51:42', 'ACCOUNT', '0:0:0:0:0:0:0:1', 'PostmanRuntime/7.43.4', 'Unknown - GeoIP not initialized');
|
| 110 | INSERT INTO `login_history` VALUES (3, 1, '2025-06-03 12:52:55', 'ACCOUNT', '0:0:0:0:0:0:0:1', 'PostmanRuntime/7.43.4', 'Unknown - GeoIP not initialized');
|
| 111 | INSERT INTO `login_history` VALUES (4, 1, '2025-06-03 14:20:55', 'ACCOUNT', '0:0:0:0:0:0:0:1', 'PostmanRuntime/7.43.4', 'Unknown - GeoIP not initialized');
|
| 112 | INSERT INTO `login_history` VALUES (5, 1, '2025-06-03 14:31:13', 'ACCOUNT', '0:0:0:0:0:0:0:1', 'PostmanRuntime/7.43.4', 'Unknown - GeoIP not initialized');
|
| 113 | INSERT INTO `login_history` VALUES (6, 1, '2025-06-04 03:40:10', 'ACCOUNT', '0:0:0:0:0:0:0:1', 'PostmanRuntime/7.44.0', 'Unknown - GeoIP not initialized');
|
| 114 | INSERT INTO `login_history` VALUES (7, 1, '2025-06-04 03:43:09', 'PASSKEY', '192.168.10.10', 'qBittorrent/5.1.0', 'Unknown - GeoIP not initialized');
|
| 115 | INSERT INTO `login_history` VALUES (8, 1, '2025-06-04 03:44:27', 'PASSKEY', '192.168.10.10', 'qBittorrent/5.1.0', 'Unknown - GeoIP not initialized');
|
| 116 | INSERT INTO `login_history` VALUES (9, 1, '2025-06-04 03:51:35', 'PASSKEY', '192.168.10.10', 'qBittorrent/5.1.0', 'Unknown - GeoIP not initialized');
|
| 117 | INSERT INTO `login_history` VALUES (10, 1, '2025-06-04 03:52:22', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 118 | INSERT INTO `login_history` VALUES (11, 1, '2025-06-04 03:52:53', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 119 | INSERT INTO `login_history` VALUES (12, 1, '2025-06-04 03:53:12', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 120 | INSERT INTO `login_history` VALUES (13, 1, '2025-06-04 03:54:46', 'PASSKEY', '192.168.10.10', 'qBittorrent/5.1.0', 'Unknown - GeoIP not initialized');
|
| 121 | INSERT INTO `login_history` VALUES (14, 1, '2025-06-04 03:58:14', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 122 | INSERT INTO `login_history` VALUES (15, 1, '2025-06-04 04:22:30', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 123 | INSERT INTO `login_history` VALUES (16, 1, '2025-06-04 04:43:29', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 124 | INSERT INTO `login_history` VALUES (17, 1, '2025-06-04 04:54:09', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 125 | INSERT INTO `login_history` VALUES (18, 1, '2025-06-04 04:59:13', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 126 | INSERT INTO `login_history` VALUES (19, 1, '2025-06-04 05:17:07', 'PASSKEY', '192.168.10.10', 'qBittorrent/5.1.0', 'Unknown - GeoIP not initialized');
|
| 127 | INSERT INTO `login_history` VALUES (20, 1, '2025-06-04 05:18:28', 'PASSKEY', '192.168.10.10', 'qBittorrent/5.1.0', 'Unknown - GeoIP not initialized');
|
| 128 | INSERT INTO `login_history` VALUES (21, 1, '2025-06-04 05:21:25', 'PASSKEY', '192.168.10.10', 'qBittorrent/5.1.0', 'Unknown - GeoIP not initialized');
|
| 129 | INSERT INTO `login_history` VALUES (22, 1, '2025-06-04 05:21:58', 'PASSKEY', '192.168.10.10', 'qBittorrent/5.1.0', 'Unknown - GeoIP not initialized');
|
| 130 | INSERT INTO `login_history` VALUES (23, 1, '2025-06-04 05:22:24', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 131 | INSERT INTO `login_history` VALUES (24, 1, '2025-06-04 05:22:30', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 132 | INSERT INTO `login_history` VALUES (25, 1, '2025-06-04 05:27:44', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 133 | INSERT INTO `login_history` VALUES (26, 1, '2025-06-04 05:27:50', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 134 | INSERT INTO `login_history` VALUES (27, 1, '2025-06-04 05:31:45', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 135 | INSERT INTO `login_history` VALUES (28, 1, '2025-06-04 05:33:00', 'PASSKEY', '192.168.10.10', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 136 | INSERT INTO `login_history` VALUES (29, 1, '2025-06-04 06:11:31', 'PASSKEY', '192.168.254.1', 'qBittorrent/5.1.0', 'Unknown - GeoIP not initialized');
|
| 137 | INSERT INTO `login_history` VALUES (30, 1, '2025-06-04 06:12:13', 'PASSKEY', '192.168.254.1', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 138 | INSERT INTO `login_history` VALUES (31, 1, '2025-06-04 06:12:27', 'PASSKEY', '192.168.254.1', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 139 | INSERT INTO `login_history` VALUES (32, 1, '2025-06-04 06:13:21', 'PASSKEY', '192.168.254.1', 'Transmission/4.0.6', 'Unknown - GeoIP not initialized');
|
| 140 |
|
| 141 | -- ----------------------------
|
| 142 | -- Table structure for peers
|
| 143 | -- ----------------------------
|
| 144 | DROP TABLE IF EXISTS `peers`;
|
| 145 | CREATE TABLE `peers` (
|
| 146 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 147 | `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 148 | `port` int NOT NULL,
|
| 149 | `info_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 150 | `peer_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 151 | `user_agent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 152 | `uploaded` bigint NOT NULL,
|
| 153 | `downloaded` bigint NOT NULL,
|
| 154 | `to_go` bigint NOT NULL,
|
| 155 | `seeder` tinyint(1) NOT NULL,
|
| 156 | `partial_seeder` tinyint(1) NOT NULL,
|
| 157 | `passkey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 158 | `update_at` timestamp NOT NULL,
|
| 159 | `seeding_time` bigint NOT NULL,
|
| 160 | `upload_speed` bigint NOT NULL,
|
| 161 | `download_speed` bigint NOT NULL,
|
| 162 | `user_id` bigint NULL DEFAULT NULL,
|
| 163 | PRIMARY KEY (`id`) USING BTREE,
|
| 164 | UNIQUE INDEX `uk_peers_ip_port_infohash`(`ip` ASC, `port` ASC, `info_hash` ASC) USING BTREE,
|
| 165 | UNIQUE INDEX `UKoa8l3xqdvxr898mosks3hq3cb`(`ip` ASC, `port` ASC, `info_hash` ASC) USING BTREE,
|
| 166 | INDEX `idx_peers_update_at`(`update_at` ASC) USING BTREE,
|
| 167 | INDEX `fk_peers_user`(`user_id` ASC) USING BTREE,
|
| 168 | INDEX `IDXmmvk33liy7j5u9e4qhxw2d7h5`(`update_at` ASC) USING BTREE,
|
| 169 | CONSTRAINT `fk_peers_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 170 | ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 171 |
|
| 172 |
|
| 173 | -- ----------------------------
|
| 174 | -- Table structure for permissions
|
| 175 | -- ----------------------------
|
| 176 | DROP TABLE IF EXISTS `permissions`;
|
| 177 | CREATE TABLE `permissions` (
|
| 178 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 179 | `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 180 | `def` tinyint(1) NOT NULL,
|
| 181 | `user_group_id` bigint NULL DEFAULT NULL,
|
| 182 | PRIMARY KEY (`id`) USING BTREE,
|
| 183 | UNIQUE INDEX `uk_permissions_slug`(`slug` ASC) USING BTREE,
|
| 184 | UNIQUE INDEX `UKdv6mwikptsu70hcrjq07sqsfy`(`slug` ASC) USING BTREE,
|
| 185 | INDEX `fk_permissions_user_group`(`user_group_id` ASC) USING BTREE,
|
| 186 | CONSTRAINT `fk_permissions_user_group` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 187 | ) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 188 |
|
| 189 | -- ----------------------------
|
| 190 | -- Records of permissions
|
| 191 | -- ----------------------------
|
| 192 | INSERT INTO `permissions` VALUES (1, 'torrent:upload', 1, 1);
|
| 193 | INSERT INTO `permissions` VALUES (2, 'torrent:download', 1, 1);
|
| 194 | INSERT INTO `permissions` VALUES (3, 'torrent:view', 1, 1);
|
| 195 | INSERT INTO `permissions` VALUES (4, 'torrent:search', 1, 1);
|
| 196 | INSERT INTO `permissions` VALUES (5, 'comment:create', 1, 1);
|
| 197 | INSERT INTO `permissions` VALUES (6, 'user:manage', 1, 1);
|
| 198 | INSERT INTO `permissions` VALUES (7, 'torrent:approve', 1, 1);
|
| 199 | INSERT INTO `permissions` VALUES (8, 'torrent:thanks', 1, 1);
|
| 200 | INSERT INTO `permissions` VALUES (9, 'promotion:list', 1, 1);
|
| 201 |
|
| 202 | -- ----------------------------
|
| 203 | -- Table structure for promotion_policies
|
| 204 | -- ----------------------------
|
| 205 | DROP TABLE IF EXISTS `promotion_policies`;
|
| 206 | CREATE TABLE `promotion_policies` (
|
| 207 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 208 | `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 209 | `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 210 | `upload_ratio` double NULL DEFAULT NULL,
|
| 211 | `download_ratio` double NULL DEFAULT NULL,
|
| 212 | PRIMARY KEY (`id`) USING BTREE,
|
| 213 | UNIQUE INDEX `uk_promotion_policies_slug`(`slug` ASC) USING BTREE,
|
| 214 | UNIQUE INDEX `UKcjqpe1g15outfc0u6ajvpwxoe`(`slug` ASC) USING BTREE
|
| 215 | ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 216 |
|
| 217 | -- ----------------------------
|
| 218 | -- Records of promotion_policies
|
| 219 | -- ----------------------------
|
| 220 | INSERT INTO `promotion_policies` VALUES (1, 'default', '默认策略', 1, 1);
|
| 221 | INSERT INTO `promotion_policies` VALUES (2, 'vip', '活跃用户策略', 1, 1.5);
|
| 222 |
|
| 223 | -- ----------------------------
|
| 224 | -- Table structure for qrtz_blob_triggers
|
| 225 | -- ----------------------------
|
| 226 | DROP TABLE IF EXISTS `qrtz_blob_triggers`;
|
| 227 | CREATE TABLE `qrtz_blob_triggers` (
|
| 228 | `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 229 | `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 230 | `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 231 | `BLOB_DATA` blob NULL,
|
| 232 | PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
|
| 233 | INDEX `SCHED_NAME`(`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC) USING BTREE,
|
| 234 | CONSTRAINT `qrtz_blob_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 235 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 236 |
|
| 237 | -- ----------------------------
|
| 238 | -- Records of qrtz_blob_triggers
|
| 239 | -- ----------------------------
|
| 240 |
|
| 241 | -- ----------------------------
|
| 242 | -- Table structure for qrtz_calendars
|
| 243 | -- ----------------------------
|
| 244 | DROP TABLE IF EXISTS `qrtz_calendars`;
|
| 245 | CREATE TABLE `qrtz_calendars` (
|
| 246 | `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 247 | `CALENDAR_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 248 | `CALENDAR` blob NOT NULL,
|
| 249 | PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`) USING BTREE
|
| 250 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 251 |
|
| 252 | -- ----------------------------
|
| 253 | -- Records of qrtz_calendars
|
| 254 | -- ----------------------------
|
| 255 |
|
| 256 | -- ----------------------------
|
| 257 | -- Table structure for qrtz_cron_triggers
|
| 258 | -- ----------------------------
|
| 259 | DROP TABLE IF EXISTS `qrtz_cron_triggers`;
|
| 260 | CREATE TABLE `qrtz_cron_triggers` (
|
| 261 | `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 262 | `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 263 | `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 264 | `CRON_EXPRESSION` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 265 | `TIME_ZONE_ID` varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 266 | PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
|
| 267 | CONSTRAINT `qrtz_cron_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 268 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 269 |
|
| 270 | -- ----------------------------
|
| 271 | -- Records of qrtz_cron_triggers
|
| 272 | -- ----------------------------
|
| 273 |
|
| 274 | -- ----------------------------
|
| 275 | -- Table structure for qrtz_fired_triggers
|
| 276 | -- ----------------------------
|
| 277 | DROP TABLE IF EXISTS `qrtz_fired_triggers`;
|
| 278 | CREATE TABLE `qrtz_fired_triggers` (
|
| 279 | `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 280 | `ENTRY_ID` varchar(95) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 281 | `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 282 | `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 283 | `INSTANCE_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 284 | `FIRED_TIME` bigint NOT NULL,
|
| 285 | `SCHED_TIME` bigint NOT NULL,
|
| 286 | `PRIORITY` int NOT NULL,
|
| 287 | `STATE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 288 | `JOB_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 289 | `JOB_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 290 | `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 291 | `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 292 | PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`) USING BTREE,
|
| 293 | INDEX `IDX_QRTZ_FT_TRIG_INST_NAME`(`SCHED_NAME` ASC, `INSTANCE_NAME` ASC) USING BTREE,
|
| 294 | INDEX `IDX_QRTZ_FT_INST_JOB_REQ_RCVRY`(`SCHED_NAME` ASC, `INSTANCE_NAME` ASC, `REQUESTS_RECOVERY` ASC) USING BTREE,
|
| 295 | INDEX `IDX_QRTZ_FT_J_G`(`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC) USING BTREE,
|
| 296 | INDEX `IDX_QRTZ_FT_JG`(`SCHED_NAME` ASC, `JOB_GROUP` ASC) USING BTREE,
|
| 297 | INDEX `IDX_QRTZ_FT_T_G`(`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC) USING BTREE,
|
| 298 | INDEX `IDX_QRTZ_FT_TG`(`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC) USING BTREE
|
| 299 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 300 |
|
| 301 | -- ----------------------------
|
| 302 | -- Records of qrtz_fired_triggers
|
| 303 | -- ----------------------------
|
| 304 |
|
| 305 | -- ----------------------------
|
| 306 | -- Table structure for qrtz_job_details
|
| 307 | -- ----------------------------
|
| 308 | DROP TABLE IF EXISTS `qrtz_job_details`;
|
| 309 | CREATE TABLE `qrtz_job_details` (
|
| 310 | `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 311 | `JOB_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 312 | `JOB_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 313 | `DESCRIPTION` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 314 | `JOB_CLASS_NAME` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 315 | `IS_DURABLE` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 316 | `IS_NONCONCURRENT` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 317 | `IS_UPDATE_DATA` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 318 | `REQUESTS_RECOVERY` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 319 | `JOB_DATA` blob NULL,
|
| 320 | PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) USING BTREE,
|
| 321 | INDEX `IDX_QRTZ_J_REQ_RECOVERY`(`SCHED_NAME` ASC, `REQUESTS_RECOVERY` ASC) USING BTREE,
|
| 322 | INDEX `IDX_QRTZ_J_GRP`(`SCHED_NAME` ASC, `JOB_GROUP` ASC) USING BTREE
|
| 323 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 324 |
|
| 325 | -- ----------------------------
|
| 326 | -- Records of qrtz_job_details
|
| 327 | -- ----------------------------
|
| 328 | INSERT INTO `qrtz_job_details` VALUES ('sapling_scheduler', 'peers_cleanup', 'DEFAULT', 'Peers Cleanup', 'com.github.example.pt.crontask.PeersCleanup', '1', '0', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787000737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F40000000000010770800000010000000007800);
|
| 329 |
|
| 330 | -- ----------------------------
|
| 331 | -- Table structure for qrtz_locks
|
| 332 | -- ----------------------------
|
| 333 | DROP TABLE IF EXISTS `qrtz_locks`;
|
| 334 | CREATE TABLE `qrtz_locks` (
|
| 335 | `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 336 | `LOCK_NAME` varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 337 | PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`) USING BTREE
|
| 338 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 339 |
|
| 340 | -- ----------------------------
|
| 341 | -- Records of qrtz_locks
|
| 342 | -- ----------------------------
|
| 343 | INSERT INTO `qrtz_locks` VALUES ('sapling_scheduler', 'STATE_ACCESS');
|
| 344 | INSERT INTO `qrtz_locks` VALUES ('sapling_scheduler', 'TRIGGER_ACCESS');
|
| 345 |
|
| 346 | -- ----------------------------
|
| 347 | -- Table structure for qrtz_paused_trigger_grps
|
| 348 | -- ----------------------------
|
| 349 | DROP TABLE IF EXISTS `qrtz_paused_trigger_grps`;
|
| 350 | CREATE TABLE `qrtz_paused_trigger_grps` (
|
| 351 | `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 352 | `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 353 | PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`) USING BTREE
|
| 354 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 355 |
|
| 356 | -- ----------------------------
|
| 357 | -- Records of qrtz_paused_trigger_grps
|
| 358 | -- ----------------------------
|
| 359 |
|
| 360 | -- ----------------------------
|
| 361 | -- Table structure for qrtz_scheduler_state
|
| 362 | -- ----------------------------
|
| 363 | DROP TABLE IF EXISTS `qrtz_scheduler_state`;
|
| 364 | CREATE TABLE `qrtz_scheduler_state` (
|
| 365 | `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 366 | `INSTANCE_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 367 | `LAST_CHECKIN_TIME` bigint NOT NULL,
|
| 368 | `CHECKIN_INTERVAL` bigint NOT NULL,
|
| 369 | PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`) USING BTREE
|
| 370 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 371 |
|
| 372 | -- ----------------------------
|
| 373 | -- Records of qrtz_scheduler_state
|
| 374 | -- ----------------------------
|
| 375 | INSERT INTO `qrtz_scheduler_state` VALUES ('sapling_scheduler', 'LAPTOP-V24K5A551749018489588', 1749018510182, 10000);
|
| 376 |
|
| 377 | -- ----------------------------
|
| 378 | -- Table structure for qrtz_simple_triggers
|
| 379 | -- ----------------------------
|
| 380 | DROP TABLE IF EXISTS `qrtz_simple_triggers`;
|
| 381 | CREATE TABLE `qrtz_simple_triggers` (
|
| 382 | `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 383 | `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 384 | `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 385 | `REPEAT_COUNT` bigint NOT NULL,
|
| 386 | `REPEAT_INTERVAL` bigint NOT NULL,
|
| 387 | `TIMES_TRIGGERED` bigint NOT NULL,
|
| 388 | PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
|
| 389 | CONSTRAINT `qrtz_simple_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 390 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 391 |
|
| 392 | -- ----------------------------
|
| 393 | -- Records of qrtz_simple_triggers
|
| 394 | -- ----------------------------
|
| 395 | INSERT INTO `qrtz_simple_triggers` VALUES ('sapling_scheduler', '6da64b5bd2ee-37ffa82a-a598-485c-9718-40ee90c26bc4', 'DEFAULT', -1, 1800000, 1);
|
| 396 |
|
| 397 | -- ----------------------------
|
| 398 | -- Table structure for qrtz_simprop_triggers
|
| 399 | -- ----------------------------
|
| 400 | DROP TABLE IF EXISTS `qrtz_simprop_triggers`;
|
| 401 | CREATE TABLE `qrtz_simprop_triggers` (
|
| 402 | `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 403 | `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 404 | `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 405 | `STR_PROP_1` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 406 | `STR_PROP_2` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 407 | `STR_PROP_3` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 408 | `INT_PROP_1` int NULL DEFAULT NULL,
|
| 409 | `INT_PROP_2` int NULL DEFAULT NULL,
|
| 410 | `LONG_PROP_1` bigint NULL DEFAULT NULL,
|
| 411 | `LONG_PROP_2` bigint NULL DEFAULT NULL,
|
| 412 | `DEC_PROP_1` decimal(13, 4) NULL DEFAULT NULL,
|
| 413 | `DEC_PROP_2` decimal(13, 4) NULL DEFAULT NULL,
|
| 414 | `BOOL_PROP_1` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 415 | `BOOL_PROP_2` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 416 | PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
|
| 417 | CONSTRAINT `qrtz_simprop_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) REFERENCES `qrtz_triggers` (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 418 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 419 |
|
| 420 | -- ----------------------------
|
| 421 | -- Records of qrtz_simprop_triggers
|
| 422 | -- ----------------------------
|
| 423 |
|
| 424 | -- ----------------------------
|
| 425 | -- Table structure for qrtz_triggers
|
| 426 | -- ----------------------------
|
| 427 | DROP TABLE IF EXISTS `qrtz_triggers`;
|
| 428 | CREATE TABLE `qrtz_triggers` (
|
| 429 | `SCHED_NAME` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 430 | `TRIGGER_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 431 | `TRIGGER_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 432 | `JOB_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 433 | `JOB_GROUP` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 434 | `DESCRIPTION` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 435 | `NEXT_FIRE_TIME` bigint NULL DEFAULT NULL,
|
| 436 | `PREV_FIRE_TIME` bigint NULL DEFAULT NULL,
|
| 437 | `PRIORITY` int NULL DEFAULT NULL,
|
| 438 | `TRIGGER_STATE` varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 439 | `TRIGGER_TYPE` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 440 | `START_TIME` bigint NOT NULL,
|
| 441 | `END_TIME` bigint NULL DEFAULT NULL,
|
| 442 | `CALENDAR_NAME` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
|
| 443 | `MISFIRE_INSTR` smallint NULL DEFAULT NULL,
|
| 444 | `JOB_DATA` blob NULL,
|
| 445 | PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`) USING BTREE,
|
| 446 | INDEX `IDX_QRTZ_T_J`(`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC) USING BTREE,
|
| 447 | INDEX `IDX_QRTZ_T_JG`(`SCHED_NAME` ASC, `JOB_GROUP` ASC) USING BTREE,
|
| 448 | INDEX `IDX_QRTZ_T_C`(`SCHED_NAME` ASC, `CALENDAR_NAME` ASC) USING BTREE,
|
| 449 | INDEX `IDX_QRTZ_T_G`(`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC) USING BTREE,
|
| 450 | INDEX `IDX_QRTZ_T_STATE`(`SCHED_NAME` ASC, `TRIGGER_STATE` ASC) USING BTREE,
|
| 451 | INDEX `IDX_QRTZ_T_N_STATE`(`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC) USING BTREE,
|
| 452 | INDEX `IDX_QRTZ_T_N_G_STATE`(`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC) USING BTREE,
|
| 453 | INDEX `IDX_QRTZ_T_NEXT_FIRE_TIME`(`SCHED_NAME` ASC, `NEXT_FIRE_TIME` ASC) USING BTREE,
|
| 454 | INDEX `IDX_QRTZ_T_NFT_ST`(`SCHED_NAME` ASC, `TRIGGER_STATE` ASC, `NEXT_FIRE_TIME` ASC) USING BTREE,
|
| 455 | INDEX `IDX_QRTZ_T_NFT_MISFIRE`(`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC) USING BTREE,
|
| 456 | INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE`(`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_STATE` ASC) USING BTREE,
|
| 457 | INDEX `IDX_QRTZ_T_NFT_ST_MISFIRE_GRP`(`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC) USING BTREE,
|
| 458 | CONSTRAINT `qrtz_triggers_ibfk_1` FOREIGN KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) REFERENCES `qrtz_job_details` (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 459 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 460 |
|
| 461 | -- ----------------------------
|
| 462 | -- Records of qrtz_triggers
|
| 463 | -- ----------------------------
|
| 464 | INSERT INTO `qrtz_triggers` VALUES ('sapling_scheduler', '6da64b5bd2ee-37ffa82a-a598-485c-9718-40ee90c26bc4', 'DEFAULT', 'peers_cleanup', 'DEFAULT', NULL, 1749020288505, 1749018488505, 5, 'WAITING', 'SIMPLE', 1749018488505, 0, NULL, 0, '');
|
| 465 |
|
| 466 | -- ----------------------------
|
| 467 | -- Table structure for seedbox
|
| 468 | -- ----------------------------
|
| 469 | DROP TABLE IF EXISTS `seedbox`;
|
| 470 | CREATE TABLE `seedbox` (
|
| 471 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 472 | `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 473 | `download_multiplier_id` bigint NULL DEFAULT NULL,
|
| 474 | `upload_multiplier_id` bigint NULL DEFAULT NULL,
|
| 475 | PRIMARY KEY (`id`) USING BTREE,
|
| 476 | UNIQUE INDEX `UKecbehjtg3bfr4rmyixt1gcvfq`(`address` ASC) USING BTREE,
|
| 477 | INDEX `FKq63tqhykgl96l4rkwy9widy5b`(`download_multiplier_id` ASC) USING BTREE,
|
| 478 | INDEX `FK9xl51na3dn8k7ou8cyv7s1wrf`(`upload_multiplier_id` ASC) USING BTREE,
|
| 479 | CONSTRAINT `FK9xl51na3dn8k7ou8cyv7s1wrf` FOREIGN KEY (`upload_multiplier_id`) REFERENCES `promotion_policies` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
| 480 | CONSTRAINT `FKq63tqhykgl96l4rkwy9widy5b` FOREIGN KEY (`download_multiplier_id`) REFERENCES `promotion_policies` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 481 | ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 482 |
|
| 483 | -- ----------------------------
|
| 484 | -- Records of seedbox
|
| 485 | -- ----------------------------
|
| 486 |
|
| 487 | -- ----------------------------
|
| 488 | -- Table structure for settings
|
| 489 | -- ----------------------------
|
| 490 | DROP TABLE IF EXISTS `settings`;
|
| 491 | CREATE TABLE `settings` (
|
| 492 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 493 | `setting_key` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 494 | `setting_value` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 495 | PRIMARY KEY (`id`) USING BTREE,
|
| 496 | UNIQUE INDEX `uk_settings_setting_key`(`setting_key` ASC) USING BTREE,
|
| 497 | UNIQUE INDEX `UKswd05dvj4ukvw5q135bpbbfae`(`setting_key` ASC) USING BTREE
|
| 498 | ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 499 |
|
| 500 | -- ----------------------------
|
| 501 | -- Table structure for tags
|
| 502 | -- ----------------------------
|
| 503 | DROP TABLE IF EXISTS `tags`;
|
| 504 | CREATE TABLE `tags` (
|
| 505 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 506 | `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 507 | PRIMARY KEY (`id`) USING BTREE,
|
| 508 | UNIQUE INDEX `uk_tags_name`(`name` ASC) USING BTREE,
|
| 509 | UNIQUE INDEX `UKt48xdq560gs3gap9g7jg36kgc`(`name` ASC) USING BTREE
|
| 510 | ) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 511 |
|
| 512 | -- ----------------------------
|
| 513 | -- Records of tags
|
| 514 | -- ----------------------------
|
| 515 | INSERT INTO `tags` VALUES (9, '[\"linux\"]');
|
| 516 | INSERT INTO `tags` VALUES (3, 'debian');
|
| 517 | INSERT INTO `tags` VALUES (1, 'linux');
|
| 518 | INSERT INTO `tags` VALUES (5, 'macos');
|
| 519 | INSERT INTO `tags` VALUES (2, 'ubuntu');
|
| 520 | INSERT INTO `tags` VALUES (4, 'windows');
|
| 521 |
|
| 522 | -- ----------------------------
|
| 523 | -- Table structure for thanks
|
| 524 | -- ----------------------------
|
| 525 | DROP TABLE IF EXISTS `thanks`;
|
| 526 | CREATE TABLE `thanks` (
|
| 527 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 528 | `torrent_id` bigint NULL DEFAULT NULL,
|
| 529 | `user_id` bigint NULL DEFAULT NULL,
|
| 530 | PRIMARY KEY (`id`) USING BTREE,
|
| 531 | UNIQUE INDEX `UKrt9lg0h53brgpf9iat5hcmf6g`(`user_id` ASC, `torrent_id` ASC) USING BTREE,
|
| 532 | INDEX `FKp3kgh25tko48vq7x6u2w3dvpp`(`torrent_id` ASC) USING BTREE,
|
| 533 | CONSTRAINT `FK2t90h21s5hyx6hynewsdlk46j` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
| 534 | CONSTRAINT `FKp3kgh25tko48vq7x6u2w3dvpp` FOREIGN KEY (`torrent_id`) REFERENCES `torrents` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 535 | ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 536 |
|
| 537 | -- ----------------------------
|
| 538 | -- Records of thanks
|
| 539 | -- ----------------------------
|
| 540 |
|
| 541 | -- ----------------------------
|
| 542 | -- Table structure for torrents
|
| 543 | -- ----------------------------
|
| 544 | DROP TABLE IF EXISTS `torrents`;
|
| 545 | CREATE TABLE `torrents` (
|
| 546 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 547 | `info_hash` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 548 | `user_id` bigint NULL DEFAULT NULL,
|
| 549 | `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 550 | `sub_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 551 | `size` bigint NOT NULL,
|
| 552 | `created_at` timestamp NOT NULL,
|
| 553 | `updated_at` timestamp NOT NULL,
|
| 554 | `under_review` tinyint(1) NOT NULL,
|
| 555 | `anonymous` tinyint(1) NOT NULL,
|
| 556 | `category_id` bigint NULL DEFAULT NULL,
|
| 557 | `promotion_policy_id` bigint NULL DEFAULT NULL,
|
| 558 | `description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 559 | PRIMARY KEY (`id`) USING BTREE,
|
| 560 | UNIQUE INDEX `uk_torrents_info_hash`(`info_hash` ASC) USING BTREE,
|
| 561 | UNIQUE INDEX `UKhag2ej1vo8snvirb1lv4b8r4x`(`info_hash` ASC) USING BTREE,
|
| 562 | INDEX `idx_torrents_title`(`title` ASC) USING BTREE,
|
| 563 | INDEX `idx_torrents_sub_title`(`sub_title` ASC) USING BTREE,
|
| 564 | INDEX `idx_torrents_promotion_policy_id`(`promotion_policy_id` ASC) USING BTREE,
|
| 565 | INDEX `fk_torrents_user`(`user_id` ASC) USING BTREE,
|
| 566 | INDEX `fk_torrents_category`(`category_id` ASC) USING BTREE,
|
| 567 | INDEX `IDXdplkaapqslelnscuunfpm9eb6`(`title` ASC) USING BTREE,
|
| 568 | INDEX `IDX6r5kh6i4awpdlytjmm06pk22k`(`sub_title` ASC) USING BTREE,
|
| 569 | INDEX `IDXd2j3h8td7682cctkv5o77b33y`(`promotion_policy_id` ASC) USING BTREE,
|
| 570 | CONSTRAINT `fk_torrents_category` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT,
|
| 571 | CONSTRAINT `fk_torrents_promotion_policy` FOREIGN KEY (`promotion_policy_id`) REFERENCES `promotion_policies` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT,
|
| 572 | CONSTRAINT `fk_torrents_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL ON UPDATE RESTRICT
|
| 573 | ) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 574 |
|
| 575 | -- ----------------------------
|
| 576 | -- Records of torrents
|
| 577 | -- ----------------------------
|
| 578 | INSERT INTO `torrents` VALUES (7, '499e9c69e90b976c5c84542cf9b88fad1e12ef1c', 1, 'example torrent title', 'subtitle here', 66194, '2025-06-04 03:41:27', '2025-06-04 03:41:27', 0, 0, 1, 1, '演示种子');
|
| 579 | INSERT INTO `torrents` VALUES (8, 'f45775564c88b5a2782a301d162e1d4811b0b6d5', 1, 'example torrent title', 'subtitle here', 231105, '2025-06-04 05:20:37', '2025-06-04 05:20:37', 0, 0, 1, 1, '演示种子');
|
| 580 | INSERT INTO `torrents` VALUES (9, '8e10c9daa1b5fb18dc5b0e73988808ba958391fa', 1, 'example torrent title', 'subtitle here', 426155, '2025-06-04 06:03:49', '2025-06-04 06:03:49', 0, 0, 1, 1, '演示种子');
|
| 581 | INSERT INTO `torrents` VALUES (10, '1e3275f54ec074af2d99828311d4a8488eb7a487', 1, 'example torrent title', 'subtitle here', 13861694, '2025-06-04 06:10:23', '2025-06-04 06:10:23', 0, 0, 1, 1, '演示种子');
|
| 582 |
|
| 583 | -- ----------------------------
|
| 584 | -- Table structure for torrents_tag
|
| 585 | -- ----------------------------
|
| 586 | DROP TABLE IF EXISTS `torrents_tag`;
|
| 587 | CREATE TABLE `torrents_tag` (
|
| 588 | `torrent_id` bigint NOT NULL,
|
| 589 | `tag_id` bigint NOT NULL,
|
| 590 | PRIMARY KEY (`torrent_id`, `tag_id`) USING BTREE,
|
| 591 | INDEX `fk_torrents_tag_tag`(`tag_id` ASC) USING BTREE,
|
| 592 | CONSTRAINT `fk_torrents_tag_tag` FOREIGN KEY (`tag_id`) REFERENCES `tags` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
|
| 593 | CONSTRAINT `fk_torrents_tag_torrent` FOREIGN KEY (`torrent_id`) REFERENCES `torrents` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
|
| 594 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 595 |
|
| 596 | -- ----------------------------
|
| 597 | -- Records of torrents_tag
|
| 598 | -- ----------------------------
|
| 599 | INSERT INTO `torrents_tag` VALUES (7, 9);
|
| 600 | INSERT INTO `torrents_tag` VALUES (8, 9);
|
| 601 | INSERT INTO `torrents_tag` VALUES (9, 9);
|
| 602 | INSERT INTO `torrents_tag` VALUES (10, 9);
|
| 603 |
|
| 604 | -- ----------------------------
|
| 605 | -- Table structure for transfer_history
|
| 606 | -- ----------------------------
|
| 607 | DROP TABLE IF EXISTS `transfer_history`;
|
| 608 | CREATE TABLE `transfer_history` (
|
| 609 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 610 | `user_id` bigint NOT NULL,
|
| 611 | `torrent_id` bigint NOT NULL,
|
| 612 | `to_go` bigint NOT NULL,
|
| 613 | `started_at` timestamp NOT NULL,
|
| 614 | `updated_at` timestamp NOT NULL,
|
| 615 | `uploaded` bigint NOT NULL,
|
| 616 | `downloaded` bigint NOT NULL,
|
| 617 | `actual_uploaded` bigint NOT NULL,
|
| 618 | `actual_downloaded` bigint NOT NULL,
|
| 619 | `upload_speed` bigint NOT NULL,
|
| 620 | `download_speed` bigint NOT NULL,
|
| 621 | `last_event` enum('started','completed','stopped','paused','unknown') CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 622 | `have_complete_history` tinyint(1) NOT NULL,
|
| 623 | PRIMARY KEY (`id`) USING BTREE,
|
| 624 | UNIQUE INDEX `uk_user_torrent`(`user_id` ASC, `torrent_id` ASC) USING BTREE,
|
| 625 | UNIQUE INDEX `UKrm5p4xv3rb2vm6psql5je94jh`(`user_id` ASC, `torrent_id` ASC) USING BTREE,
|
| 626 | INDEX `fk_transfer_torrent`(`torrent_id` ASC) USING BTREE,
|
| 627 | CONSTRAINT `fk_transfer_torrent` FOREIGN KEY (`torrent_id`) REFERENCES `torrents` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
|
| 628 | CONSTRAINT `fk_transfer_user` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 629 | ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 630 |
|
| 631 | -- ----------------------------
|
| 632 | -- Records of transfer_history
|
| 633 | -- ----------------------------
|
| 634 | INSERT INTO `transfer_history` VALUES (1, 1, 7, 66194, '2025-06-04 04:43:30', '2025-06-04 05:21:25', 0, 0, 0, 0, 0, 0, 'completed', 1);
|
| 635 | INSERT INTO `transfer_history` VALUES (2, 1, 10, 0, '2025-06-04 06:11:31', '2025-06-04 06:13:21', 27723388, 0, 0, 27723388, 0, 77874, 'started', 1);
|
| 636 |
|
| 637 | -- ----------------------------
|
| 638 | -- Table structure for user_groups
|
| 639 | -- ----------------------------
|
| 640 | DROP TABLE IF EXISTS `user_groups`;
|
| 641 | CREATE TABLE `user_groups` (
|
| 642 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 643 | `slug` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 644 | `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 645 | `promotion_policy_id` bigint NULL DEFAULT NULL,
|
| 646 | PRIMARY KEY (`id`) USING BTREE,
|
| 647 | UNIQUE INDEX `uk_user_groups_slug`(`slug` ASC) USING BTREE,
|
| 648 | UNIQUE INDEX `UKkkje1jbmrkam1k7jbd39homw0`(`slug` ASC) USING BTREE,
|
| 649 | INDEX `fk_user_groups_promotion_policy`(`promotion_policy_id` ASC) USING BTREE,
|
| 650 | CONSTRAINT `fk_user_groups_promotion_policy` FOREIGN KEY (`promotion_policy_id`) REFERENCES `promotion_policies` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 651 | ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 652 |
|
| 653 | -- ----------------------------
|
| 654 | -- Records of user_groups
|
| 655 | -- ----------------------------
|
| 656 | INSERT INTO `user_groups` VALUES (1, 'default', '默认用户组', 1);
|
| 657 | INSERT INTO `user_groups` VALUES (2, 'vip', '活跃用户组', 2);
|
| 658 |
|
| 659 | -- ----------------------------
|
| 660 | -- Table structure for user_groups_permission_entities
|
| 661 | -- ----------------------------
|
| 662 | DROP TABLE IF EXISTS `user_groups_permission_entities`;
|
| 663 | CREATE TABLE `user_groups_permission_entities` (
|
| 664 | `user_group_id` bigint NOT NULL,
|
| 665 | `permission_entities_id` bigint NOT NULL,
|
| 666 | PRIMARY KEY (`user_group_id`, `permission_entities_id`) USING BTREE,
|
| 667 | UNIQUE INDEX `UK_95j9uaq96bvd9ykn0sngywks6`(`permission_entities_id` ASC) USING BTREE,
|
| 668 | CONSTRAINT `fk_ugpe_permission` FOREIGN KEY (`permission_entities_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
|
| 669 | CONSTRAINT `fk_ugpe_user_group` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
|
| 670 | ) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 671 |
|
| 672 | -- ----------------------------
|
| 673 | -- Records of user_groups_permission_entities
|
| 674 | -- ----------------------------
|
| 675 | INSERT INTO `user_groups_permission_entities` VALUES (1, 1);
|
| 676 | INSERT INTO `user_groups_permission_entities` VALUES (1, 2);
|
| 677 | INSERT INTO `user_groups_permission_entities` VALUES (1, 3);
|
| 678 | INSERT INTO `user_groups_permission_entities` VALUES (1, 4);
|
| 679 | INSERT INTO `user_groups_permission_entities` VALUES (1, 5);
|
| 680 | INSERT INTO `user_groups_permission_entities` VALUES (1, 6);
|
| 681 | INSERT INTO `user_groups_permission_entities` VALUES (1, 7);
|
| 682 | INSERT INTO `user_groups_permission_entities` VALUES (1, 8);
|
| 683 | INSERT INTO `user_groups_permission_entities` VALUES (1, 9);
|
| 684 |
|
| 685 | -- ----------------------------
|
| 686 | -- Table structure for users
|
| 687 | -- ----------------------------
|
| 688 | DROP TABLE IF EXISTS `users`;
|
| 689 | CREATE TABLE `users` (
|
| 690 | `id` bigint NOT NULL AUTO_INCREMENT,
|
| 691 | `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 692 | `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 693 | `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 694 | `group_id` bigint NULL DEFAULT NULL,
|
| 695 | `passkey` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 696 | `create_at` timestamp NOT NULL,
|
| 697 | `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 698 | `custom_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 699 | `signature` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 700 | `language` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 701 | `download_bandwidth` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 702 | `upload_bandwidth` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 703 | `downloaded` bigint NOT NULL,
|
| 704 | `uploaded` bigint NOT NULL,
|
| 705 | `real_downloaded` bigint NOT NULL,
|
| 706 | `real_uploaded` bigint NOT NULL,
|
| 707 | `isp` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 708 | `karma` decimal(19, 2) NOT NULL,
|
| 709 | `invite_slot` int NOT NULL,
|
| 710 | `seeding_time` bigint NOT NULL,
|
| 711 | `personal_access_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 712 | `privacy_level` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
|
| 713 | PRIMARY KEY (`id`) USING BTREE,
|
| 714 | UNIQUE INDEX `uk_users_username`(`username` ASC) USING BTREE,
|
| 715 | UNIQUE INDEX `uk_users_email`(`email` ASC) USING BTREE,
|
| 716 | UNIQUE INDEX `uk_users_passkey`(`passkey` ASC) USING BTREE,
|
| 717 | UNIQUE INDEX `UKr43af9ap4edm43mmtq01oddj6`(`username` ASC) USING BTREE,
|
| 718 | UNIQUE INDEX `UK6dotkott2kjsp8vw4d0m25fb7`(`email` ASC) USING BTREE,
|
| 719 | UNIQUE INDEX `UK402sx6cqgk66uwt7eyf54tmij`(`passkey` ASC) USING BTREE,
|
| 720 | INDEX `fk_users_group`(`group_id` ASC) USING BTREE,
|
| 721 | CONSTRAINT `fk_users_group` FOREIGN KEY (`group_id`) REFERENCES `user_groups` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
|
| 722 | ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;
|
| 723 |
|
| 724 | -- ----------------------------
|
| 725 | -- Records of users
|
| 726 | -- ----------------------------
|
| 727 | INSERT INTO `users` VALUES (1, 'testuser@example.com', '$2a$06$JqvHpC94mnN23uwmZX0XHeuyFj3M22Ikw8VBZRopfrlWbPfA4KREu', 'testuser', 1, '47050e8f-f3fd-4a9c-a828-0e0de456691f', '2025-06-03 11:34:08', 'https://www.baidu.com/facivon.ico', '测试用户', '这个用户很懒,还没有个性签名', 'zh-CN', '100mbps', '100mbps', 0, 27723388, 27723388, 0, '未知', 0.00, 0, 30790068, '948c9146-ff5f-4ad6-8ba5-d32e1209cafd', '0');
|
| 728 |
|
| 729 | SET FOREIGN_KEY_CHECKS = 1;
|
| 730 |
|
| 731 | -- ----------------------------
|
| 732 | -- Records of chat_messages
|
| 733 | -- ----------------------------
|
| 734 | DROP TABLE IF EXISTS `chat_messages`;
|
| 735 | CREATE TABLE chat_messages (
|
| 736 | id BIGINT AUTO_INCREMENT PRIMARY KEY,
|
| 737 | room_id BIGINT NOT NULL,
|
| 738 | user_id BIGINT NOT NULL,
|
| 739 | content TEXT NOT NULL,
|
| 740 | created_at DATETIME NOT NULL
|
| 741 | );
|
| 742 |
|