From 567fa8b844549c8441b572142d25a3252a75f53e Mon Sep 17 00:00:00 2001 From: Marcel Werk Date: Wed, 22 May 2013 22:38:34 +0200 Subject: [PATCH] Reduced size of the application column --- wcfsetup/setup/db/install.sql | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql index 5bbeb7d07d..8b8e208dca 100644 --- a/wcfsetup/setup/db/install.sql +++ b/wcfsetup/setup/db/install.sql @@ -107,7 +107,7 @@ CREATE TABLE wcf1_acp_template ( templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, packageID INT(10), templateName VARCHAR(255) NOT NULL, - application VARCHAR(255) NOT NULL, + application VARCHAR(20) NOT NULL, UNIQUE KEY applicationTemplate (application, templateName) ); @@ -551,7 +551,7 @@ DROP TABLE IF EXISTS wcf1_package_installation_file_log; CREATE TABLE wcf1_package_installation_file_log ( packageID INT(10), filename VARCHAR(255) NOT NULL, - application VARCHAR(255) NOT NULL, + application VARCHAR(20) NOT NULL, UNIQUE KEY applicationFile (application, filename) ); @@ -885,7 +885,7 @@ CREATE TABLE wcf1_template ( templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY, packageID INT(10) NOT NULL, templateName VARCHAR(255) NOT NULL, - application VARCHAR(255) NOT NULL, + application VARCHAR(20) NOT NULL, templateGroupID INT(10), lastModificationTime INT(10) NOT NULL DEFAULT 0, UNIQUE KEY applicationTemplate (application, templateGroupID, templateName), -- 2.20.1