From 464ad59add17081fbc4c2341b00b75f3b912b978 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Joshua=20R=C3=BCsweg?= Date: Thu, 26 Sep 2019 17:08:43 +0200 Subject: [PATCH] Optimize wcf1_reaction_type table --- wcfsetup/setup/db/install.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 8e31d21f40..01faec8b91 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -1199,9 +1199,9 @@ CREATE TABLE wcf1_poll_option_vote ( DROP TABLE IF EXISTS wcf1_reaction_type; CREATE TABLE wcf1_reaction_type ( reactionTypeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, - title VARCHAR(255), + title VARCHAR(255) NOT NULL, showOrder INT(10) NOT NULL DEFAULT 0, - iconFile MEDIUMTEXT, + iconFile VARCHAR(255) NOT NULL DEFAULT '', isAssignable TINYINT(1) NOT NULL DEFAULT 1 ); -- 2.20.1