From 043b3fc719499640b71f5ac21460d836b64b25e3 Mon Sep 17 00:00:00 2001 From: Cyperghost Date: Mon, 2 Dec 2024 10:06:54 +0100 Subject: [PATCH] Add foreign key for `wcf1_user.avatarFileID` 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 62970fa2f4..b2b8d4ff2b 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 (avatarFileID) 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