From ec8265ed5f1a984e44d9087db89ce6fddf43afbe Mon Sep 17 00:00:00 2001 From: Marcel Werk Date: Sat, 15 Aug 2020 16:16:03 +0200 Subject: [PATCH] Added a unique key to `wcf1_user.username` Closes #3494 --- wcfsetup/setup/db/install.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 56a4a06e11..61c9352cab 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -1502,7 +1502,7 @@ CREATE TABLE wcf1_user ( articles INT(10) NOT NULL DEFAULT 0, blacklistMatches VARCHAR(255) NOT NULL DEFAULT '', - KEY username (username), + UNIQUE KEY username (username), KEY email (email), KEY registrationDate (registrationDate), KEY styleID (styleID), -- 2.20.1