commit 4fbe811bcc6c8c1f515b44213218d5ce87f0e46f
author Your Name <your.email@example.com> Tue May 20 23:24:17 2025 +0800
committer Your Name <your.email@example.com> Tue May 20 23:32:40 2025 +0800
tree 178f496ad2d24ba17ac67628cc6a97dba32e123d
parent 695f6a6e0f0df6656a3abf12d030401b237f4509

删除了邀请码部分

Change-Id: I6bb6a1b3ec092bebdc9c33364b9b385c6519f989
Signed-off-by: Your Name <your.email@example.com>

src/main/resources/schema.sql

diff --git a/src/main/resources/schema.sql b/src/main/resources/schema.sql
index 8bb0c85..823ecdf 100644
--- a/src/main/resources/schema.sql
+++ b/src/main/resources/schema.sql
@@ -13,15 +13,7 @@
                         INDEX `idx_user_id` (`user_id`)          -- 可选：主键通常自带索引
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
 
-CREATE TABLE invite_code (
-                             code VARCHAR(20) PRIMARY KEY,
-                             max_uses INT NOT NULL,
-                             remaining_uses INT NOT NULL,
-                             expiry_time DATETIME NOT NULL,
-                             created_by INT NOT NULL,
-                             created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
-                             FOREIGN KEY (created_by) REFERENCES user(user_id)
-);
+
 
 CREATE TABLE user_follow (
                              follower_id INT NOT NULL,
@@ -38,8 +30,3 @@
              'admin', 'admin@example.com', 'admin123', NOW(), 87654321, 'admin'
          );
 
-INSERT INTO invite_code (
-    code, max_uses, remaining_uses, expiry_time, created_by
-) VALUES
-      ('WELCOME2025', 5, 5, '2026-01-01 00:00:00', 1),
-      ('INVITEONLY', 3, 3, '2025-12-31 23:59:59', 1);
\ No newline at end of file