From 746ffe3be027275ab5d5ffbe128a949a9e982272 Mon Sep 17 00:00:00 2001 From: Stefan Date: Fri, 2 Sep 2016 09:46:33 +0200 Subject: [PATCH] Fix length for indexed varchar fields --- wcfsetup/setup/db/install.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 6dcba90bed..09b87943a2 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -785,7 +785,7 @@ CREATE TABLE wcf1_option_category ( DROP TABLE IF EXISTS wcf1_package; CREATE TABLE wcf1_package ( packageID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - package VARCHAR(255) NOT NULL DEFAULT '', + package VARCHAR(191) NOT NULL DEFAULT '', packageDir VARCHAR(255) NOT NULL DEFAULT '', packageName VARCHAR(255) NOT NULL DEFAULT '', packageDescription VARCHAR(255) NOT NULL DEFAULT '', @@ -1261,8 +1261,8 @@ CREATE TABLE wcf1_tracked_visit_type ( DROP TABLE IF EXISTS wcf1_user; CREATE TABLE wcf1_user ( userID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - username VARCHAR(255) NOT NULL DEFAULT '', - email VARCHAR(255) NOT NULL DEFAULT '', + username VARCHAR(191) NOT NULL DEFAULT '', + email VARCHAR(191) NOT NULL DEFAULT '', password VARCHAR(100) NOT NULL DEFAULT '', accessToken CHAR(40) NOT NULL DEFAULT '', languageID INT(10) NOT NULL DEFAULT 0, @@ -1298,7 +1298,7 @@ CREATE TABLE wcf1_user ( userOnlineGroupID INT(10), activityPoints INT(10) NOT NULL DEFAULT 0, notificationMailToken VARCHAR(20) NOT NULL DEFAULT '', - authData VARCHAR(255) NOT NULL DEFAULT '', + authData VARCHAR(191) NOT NULL DEFAULT '', likesReceived MEDIUMINT(7) NOT NULL DEFAULT 0, KEY username (username), -- 2.20.1