From eefef4437844c092dfe5ec827323e41b7be8eafb Mon Sep 17 00:00:00 2001 From: Mikael Nordfeldth Date: Fri, 10 Apr 2015 22:16:44 +0200 Subject: [PATCH] filename is never used for indexing so let's make it text varchar is pretty limited so let's avoid it if we can --- classes/File_thumbnail.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/classes/File_thumbnail.php b/classes/File_thumbnail.php index 1250f70404..a2e633249f 100644 --- a/classes/File_thumbnail.php +++ b/classes/File_thumbnail.php @@ -28,7 +28,7 @@ class File_thumbnail extends Managed_DataObject public $__table = 'file_thumbnail'; // table name public $file_id; // int(4) primary_key not_null public $url; // text - public $filename; // varchar(191) not 255 because utf8mb4 takes more space + public $filename; // text public $width; // int(4) primary_key public $height; // int(4) primary_key public $modified; // timestamp() not_null default_CURRENT_TIMESTAMP @@ -39,7 +39,7 @@ class File_thumbnail extends Managed_DataObject 'fields' => array( 'file_id' => array('type' => 'int', 'not null' => true, 'description' => 'thumbnail for what URL/file'), 'url' => array('type' => 'text', 'not null' => false, 'description' => 'URL of thumbnail'), - 'filename' => array('type' => 'varchar', 'length' => 191, 'description' => 'if stored locally, filename is put here'), + 'filename' => array('type' => 'text', 'description' => 'if stored locally, filename is put here'), 'width' => array('type' => 'int', 'description' => 'width of thumbnail'), 'height' => array('type' => 'int', 'description' => 'height of thumbnail'), 'modified' => array('type' => 'timestamp', 'not null' => true, 'description' => 'date this record was modified'), -- 2.39.5