openrat-cms

commit 4f02f481724d0aeb53fea0b9ceebc4a061c63309
parent 78b97ed1839f5fc70d70475b90fbfe8edc7bc124
Author: Jan Dankert <devnull@localhost>
Date:   Thu,  6 Sep 2018 00:38:25 +0200

Der Index mit VARCHAR(255) plus weiterer Spalte wird zu groß für MySQL <= 5.6 mit InnoDB. ("Specified key was too long; max key length is 767 bytes"). Dateinamen dürfen daher jetzt nur noch 150 Zeichen (auch UTF-8) lang sein. Das sollte trotzdem reichen.

Diffstat:
modules/database-update/update/DBVersion000001.class.php
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/modules/database-update/update/DBVersion000001.class.php b/modules/database-update/update/DBVersion000001.class.php
@@ -52,7 +52,7 @@ class DBVersion000001 extends DbVersion
 		$this->addTable('object');
 		$this->addColumn('object','parentid',OR_DB_COLUMN_TYPE_INT,null,null,$nullable);
 		$this->addColumn('object','projectid',OR_DB_COLUMN_TYPE_INT,0,0,$not_nullable);
-		$this->addColumn('object','filename',OR_DB_COLUMN_TYPE_VARCHAR,255,null,$not_nullable);
+		$this->addColumn('object','filename',OR_DB_COLUMN_TYPE_VARCHAR,150,null,$not_nullable);
 		$this->addColumn('object','orderid',OR_DB_COLUMN_TYPE_INT,0,null,$not_nullable);
 		$this->addColumn('object','create_date',OR_DB_COLUMN_TYPE_INT,0,null,$not_nullable);
 		$this->addColumn('object','create_userid',OR_DB_COLUMN_TYPE_INT,0,null,$nullable);