[BUGFIX] Reduced sys_file_processedfile.checksum to correct size 88/36388/2
authorMathias Schreiber <mathias.schreiber@wmdb.de>
Thu, 29 Jan 2015 21:24:45 +0000 (22:24 +0100)
committerMathias Schreiber <mathias.schreiber@wmdb.de>
Fri, 30 Jan 2015 14:30:17 +0000 (15:30 +0100)
Since only a shortMD5 (of 10 characters length) is used in this field
the size is changed to 10 characters and the field type has been set to
char instead of varchar.

Resolves: #54730
Releases: master, 6.2
Change-Id: I8e846786230b55d42464f6ea791202579e6d7873
Reviewed-on: http://review.typo3.org/36388
Reviewed-by: Ingo Schmitt <is@marketing-factory.de>
Tested-by: Ingo Schmitt <is@marketing-factory.de>
Reviewed-by: Cedric Ziel <cedric@cedric-ziel.com>
Reviewed-by: Frans Saris <franssaris@gmail.com>
Tested-by: Frans Saris <franssaris@gmail.com>
Reviewed-by: Michael Oehlhof <typo3@oehlhof.de>
Reviewed-by: Mathias Schreiber <mathias.schreiber@wmdb.de>
Tested-by: Mathias Schreiber <mathias.schreiber@wmdb.de>
typo3/sysext/core/ext_tables.sql

index 19a3cb5..89d02c6 100644 (file)
@@ -375,7 +375,7 @@ CREATE TABLE sys_file_processedfile (
        configurationsha1 char(40) DEFAULT '' NOT NULL,
        originalfilesha1 char(40) DEFAULT '' NOT NULL,
        task_type varchar(200) DEFAULT '' NOT NULL,
-       checksum varchar(255) DEFAULT '' NOT NULL,
+       checksum char(10) DEFAULT '' NOT NULL,
        width int(11) DEFAULT '0',
        height int(11) DEFAULT '0',