[BUGFIX] Fix column "note" to be compatible with MySQL strict mode 34/49534/3
authorWouter Wolters <typo3@wouterwolters.nl>
Mon, 22 Aug 2016 07:48:03 +0000 (09:48 +0200)
committerMorton Jonuschat <m.jonuschat@mojocode.de>
Mon, 22 Aug 2016 07:58:17 +0000 (09:58 +0200)
Resolves: #77568
Releases: master,7.6
Change-Id: Ie056cd7fc1d12149b534c6669cb8fe33f83ce667
(cherry picked from commit a346467cd71bb40d7c4d96f2a1460dadbd03dd08)
Reviewed-on: https://review.typo3.org/49534
Reviewed-by: Morton Jonuschat <m.jonuschat@mojocode.de>
Tested-by: Morton Jonuschat <m.jonuschat@mojocode.de>
typo3/sysext/filemetadata/ext_tables.sql

index f8a8b98..25e3a76 100644 (file)
@@ -20,7 +20,7 @@ CREATE TABLE sys_file_metadata (
        ranking int(11) unsigned DEFAULT '0',
        content_creation_date int(11) unsigned DEFAULT '0',
        content_modification_date int(11) unsigned DEFAULT '0',
-       note text NOT NULL,
+       note text,
 
        # px,mm,cm,m,p, ...
        unit char(3) DEFAULT '',
@@ -41,4 +41,4 @@ CREATE TABLE sys_file_metadata (
 
        # FE permissions
        fe_groups tinytext
-);
+);
\ No newline at end of file