[BUGFIX] Fix column "note" to be compatible with MySQL strict mode 33/49533/2
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:57:31 +0000 (09:57 +0200)
Resolves: #77568
Releases: master,7.6
Change-Id: Ie056cd7fc1d12149b534c6669cb8fe33f83ce667
Reviewed-on: https://review.typo3.org/49533
Tested-by: Bamboo TYPO3com <info@typo3.com>
Reviewed-by: Benni Mack <benni@typo3.org>
Tested-by: Benni Mack <benni@typo3.org>
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