From fc127c6ba3f2dbc58c0a22407911d6cac2d98758 Mon Sep 17 00:00:00 2001 From: Matthias Schmidt Date: Sun, 23 Jul 2017 10:26:16 +0200 Subject: [PATCH] Add unique key for devtools project name column See #2331 --- wcfsetup/setup/db/install.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 7495929865..3c4ba7d74e 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -501,7 +501,9 @@ DROP TABLE IF EXISTS wcf1_devtools_project; CREATE TABLE wcf1_devtools_project ( projectID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(191) NOT NULL, - path TEXT + path TEXT, + + UNIQUE KEY name (name) ); DROP TABLE IF EXISTS wcf1_edit_history_entry; -- 2.20.1