 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)
 );
 

	templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	packageID INT(10),
	templateName VARCHAR(255) NOT NULL,
	application VARCHAR(255) NOT NULL,
	UNIQUE KEY applicationTemplate (application, templateName)
);


	templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	packageID INT(10) NOT NULL,
	templateName 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),
