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

	templateID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
	packageID INT(10) NOT NULL,
	templateName VARCHAR(255) NOT NULL,
	application VARCHAR(255) NOT NULL,
	templateGroupID INT(10),
	lastModificationTime INT(10) NOT NULL DEFAULT 0,
	UNIQUE KEY applicationTemplate (application, templateGroupID, templateName),

CREATE TABLE wcf1_package_installation_file_log (
	packageID INT(10),
	filename VARCHAR(255) NOT NULL,
	application VARCHAR(20) NOT NULL,
	UNIQUE KEY applicationFile (application, filename)
);

