From 1974fc3e070280676da85c966f7c6755320eb408 Mon Sep 17 00:00:00 2001
From: =?utf8?q?Joshua=20R=C3=BCsweg?= <josh@bastelstu.be>
Date: Tue, 10 Apr 2018 12:39:14 +0200
Subject: [PATCH] Change reaction_type column type and iconType to tinyint See
 #2508

---
 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 8e2cfe3357..188ad69054 100644
--- a/wcfsetup/setup/db/install.sql
+++ b/wcfsetup/setup/db/install.sql
@@ -1159,9 +1159,9 @@ DROP TABLE IF EXISTS wcf1_reaction_type;
 CREATE TABLE wcf1_reaction_type(
 	reactionTypeID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, 
 	reactionTitle VARCHAR(255), 
-	type SMALLINT(1),
+	type TINYINT(1),
 	showOrder INT(10) NOT NULL DEFAULT 0,
-	iconType SMALLINT(1) DEFAULT 1,
+	iconType TINYINT(1) DEFAULT 1,
 	iconFile MEDIUMTEXT, 
 	iconName VARCHAR(255),
 	iconColor VARCHAR(255),
-- 
2.20.1