From 45f8e6dbeddf653107f31f8aac84d4753574644a Mon Sep 17 00:00:00 2001 From: Cyperghost Date: Mon, 2 Dec 2024 10:07:45 +0100 Subject: [PATCH] Add foreign key for `wcf1_user.coverPhotoFileID` to `wcf1_file.fileID` --- wcfsetup/setup/db/install.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index f630d11162..956151aaad 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -2257,6 +2257,7 @@ ALTER TABLE wcf1_tracked_visit_type ADD FOREIGN KEY (userID) REFERENCES wcf1_use ALTER TABLE wcf1_unfurl_url ADD FOREIGN KEY (imageID) REFERENCES wcf1_unfurl_url_image (imageID) ON DELETE SET NULL; ALTER TABLE wcf1_user ADD FOREIGN KEY (avatarID) REFERENCES wcf1_user_avatar (avatarID) ON DELETE SET NULL; +ALTER TABLE wcf1_user ADD FOREIGN KEY (coverPhotoFileID) REFERENCES wcf1_file (fileID) ON DELETE SET NULL; ALTER TABLE wcf1_user ADD FOREIGN KEY (rankID) REFERENCES wcf1_user_rank (rankID) ON DELETE SET NULL; ALTER TABLE wcf1_user ADD FOREIGN KEY (userOnlineGroupID) REFERENCES wcf1_user_group (groupID) ON DELETE SET NULL; -- 2.20.1