In order to run the UpgradeV1-28ToV1-29 script, which optimizes Curator with Emoji Support, it is necessary to update some global MySQL settings, should MySQL server be 5.6 or earlier.

1) Set the following:

SET GLOBAL INNODB_LARGE_PREFIX = 'ON';
SET GLOBAL INNODB_FILE_FORMAT = 'Barracuda';

2) Rows 107 - 127 will not run by default, therefore instead run the following script:

--
-- Remove column level collations.
--
SET FOREIGN_KEY_CHECKS=0;
ALTER TABLE audio
CHANGE COLUMN name name VARCHAR(255) NOT NULL,
CHANGE COLUMN description description TEXT DEFAULT NULL,
CHANGE COLUMN source_filename source_filename VARCHAR(255) NOT NULL,
CHANGE COLUMN source_ext source_ext VARCHAR(255) NOT NULL,
CHANGE COLUMN source_filepath source_filepath TEXT DEFAULT NULL,
CHANGE COLUMN thumbnail_filename thumbnail_filename TEXT DEFAULT NULL;
ALTER TABLE clipmarks
CHANGE COLUMN name name VARCHAR(255) NOT NULL,
CHANGE COLUMN description description TEXT DEFAULT NULL,
CHANGE COLUMN thumbnail_fullpath thumbnail_fullpath TEXT DEFAULT NULL;
ALTER TABLE folders
CHANGE COLUMN name name VARCHAR(255) NOT NULL,
CHANGE COLUMN description description TEXT DEFAULT NULL,
CHANGE COLUMN full_path full_path TEXT DEFAULT NULL;
ALTER TABLE images
CHANGE COLUMN name name VARCHAR(255) NOT NULL,
CHANGE COLUMN thumbnail_filename thumbnail_filename TEXT DEFAULT NULL,
CHANGE COLUMN description description TEXT DEFAULT NULL,
CHANGE COLUMN source_name source_name VARCHAR(255) NOT NULL,
CHANGE COLUMN source_ext source_ext VARCHAR(255) NOT NULL,
CHANGE COLUMN source_filepath source_filepath TEXT DEFAULT NULL;
ALTER TABLE media
CHANGE COLUMN name name VARCHAR(255) NOT NULL,
CHANGE COLUMN source_name source_name VARCHAR(255) NOT NULL AFTER name,
CHANGE COLUMN description description TEXT DEFAULT NULL AFTER source_name,
CHANGE COLUMN source_ext source_ext VARCHAR(255) NOT NULL,
CHANGE COLUMN source_filepath source_filepath TEXT DEFAULT NULL,
CHANGE COLUMN thumbnail_filename thumbnail_filename TEXT DEFAULT NULL;
ALTER TABLE metadatablobvalues
CHANGE COLUMN comment comment VARCHAR(255) DEFAULT NULL,
CHANGE COLUMN file_name file_name VARCHAR(255) NOT NULL COMMENT 'Original name of file stored in blob_value';
ALTER TABLE metadataenumvalues
CHANGE COLUMN value value VARCHAR(80) NOT NULL,
CHANGE COLUMN display_name display_name VARCHAR(255) DEFAULT NULL;
ALTER TABLE metadatanameresources
CHANGE COLUMN resource_name resource_name VARCHAR(50) NOT NULL COMMENT 'The resource name.';
ALTER TABLE metadatanames
CHANGE COLUMN name name VARCHAR(80) NOT NULL,
CHANGE COLUMN display_name display_name TEXT DEFAULT NULL,
CHANGE COLUMN pattern pattern TEXT DEFAULT NULL;
ALTER TABLE metadataresources
CHANGE COLUMN name name VARCHAR(50) NOT NULL COMMENT 'The name of this metadata resource.',
CHANGE COLUMN type_name type_name VARCHAR(50) NOT NULL COMMENT 'The type name.',
CHANGE COLUMN settings settings TEXT DEFAULT NULL COMMENT 'The settings assiocated with this resource type.',
CHANGE COLUMN parameter_definition parameter_definition TEXT DEFAULT NULL COMMENT 'The optional JSON parameter definition.';
ALTER TABLE metadataresourcetypes
CHANGE COLUMN name name VARCHAR(50) NOT NULL COMMENT 'The name of this resource type.',
CHANGE COLUMN `schema` `schema` TEXT NOT NULL COMMENT 'The JSON schema for this resource type.';
ALTER TABLE metadatavalues
CHANGE COLUMN value value TEXT NOT NULL;

ALTER TABLE metadataviewcolumns
CHANGE COLUMN ui_schema ui_schema TEXT DEFAULT NULL;
ALTER TABLE metadataviewstaticcolumns
CHANGE COLUMN name name VARCHAR(50) NOT NULL,
CHANGE COLUMN display_name display_name VARCHAR(50) NOT NULL;
ALTER TABLE storageproxies
CHANGE COLUMN filename filename TEXT DEFAULT NULL;
ALTER TABLE users
CHANGE COLUMN login_name login_name VARCHAR(255) NOT NULL,
CHANGE COLUMN real_name real_name VARCHAR(255) NOT NULL;
ALTER TABLE workgroups
CHANGE COLUMN name name VARCHAR(255) NOT NULL,
CHANGE COLUMN description description TEXT DEFAULT NULL;
SET FOREIGN_KEY_CHECKS=1;

(See CS-605 for more details)