1. 获取所有分区 2. 根据分区获得作品列表
增加了分区以及作品的swagger接口描述，并调整到正确的项目结构中
Change-Id: I36850cd93eeb93992cad7d342f2688dd8e50e6bc
diff --git a/src/main/resources/schema.sql b/src/main/resources/schema.sql
index 823ecdf..beb0cc7 100644
--- a/src/main/resources/schema.sql
+++ b/src/main/resources/schema.sql
@@ -1,3 +1,4 @@
+-- 使用反引号包裹保留字表名
CREATE TABLE `user` (
`user_id` INT PRIMARY KEY AUTO_INCREMENT,
`username` VARCHAR(255) NOT NULL UNIQUE,
@@ -6,27 +7,25 @@
`address` VARCHAR(255),
`role` VARCHAR(50) NOT NULL DEFAULT 'user',
`profile_pic` VARCHAR(255),
- `registration_date` DATETIME NOT NULL, -- 推荐用时间类型（而非字符串）
- `identification_number` VARCHAR(18), -- 身份证号建议用 VARCHAR(18)
+ `registration_date` DATETIME NOT NULL,
+ `identification_number` VARCHAR(18),
`avatar` VARCHAR(255),
- `isfollowed` BOOLEAN NOT NULL DEFAULT FALSE,
- INDEX `idx_user_id` (`user_id`) -- 可选：主键通常自带索引
+ `isfollowed` BOOLEAN NOT NULL DEFAULT FALSE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
-
-
+-- 外键表同样使用反引号
CREATE TABLE user_follow (
- follower_id INT NOT NULL,
- followed_id INT NOT NULL,
- created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
- PRIMARY KEY (follower_id, followed_id),
- FOREIGN KEY (follower_id) REFERENCES user(user_id),
- FOREIGN KEY (followed_id) REFERENCES user(user_id)
+ `follower_id` INT NOT NULL,
+ `followed_id` INT NOT NULL,
+ `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
+ PRIMARY KEY (`follower_id`, `followed_id`),
+ FOREIGN KEY (`follower_id`) REFERENCES `user`(`user_id`),
+ FOREIGN KEY (`followed_id`) REFERENCES `user`(`user_id`)
);
+-- 插入语句使用反引号包裹表名和列名
INSERT INTO `user` (
- username, email, password, registration_date, identification_number, role
+ `username`, `email`, `password`, `registration_date`, `identification_number`, `role`
) VALUES (
- 'admin', 'admin@example.com', 'admin123', NOW(), 87654321, 'admin'
- );
-
+ 'admin', 'admin@example.com', 'admin123', NOW(), '87654321', 'admin'
+ );
\ No newline at end of file