I am trying to set up a new OTRS 3.0.3 schema in MySQL (to receive 3.0.3 data from MSSQL before I upgrade the server to 3.1).  The relevant(?) my.ini excerpts are below:<br><br><div style="margin-left:40px">[mysql]<br>default-character-set=utf8<br>
[mysqld]<br>character-set-server=utf8<br>default-storage-engine=INNODB<br>sql-mode=&quot;STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION&quot;<br></div><br>When I  run the otrs-schema.mysql script I get two warnings (below).   Are these harmless?   Can I make a change to the OTRS configuration to avoid them?<br>
<br><br># ---------------------------------------------------------- #  create table virtual_fs # ---------------------------------------------------------- <br>CREATE TABLE virtual_fs (     id BIGINT NOT NULL AUTO_INCREMENT,     filename TEXT NOT NULL,     backend VARCHAR (60) NOT NULL,     backend_key VARCHAR (160) NOT NULL,     create_time DATETIME NOT NULL,     PRIMARY KEY(id),     INDEX virtual_fs_backend (backend(60)),     INDEX virtual_fs_filename (filename(350)) )    <br>
0 row(s) affected, 1 warning(s): 1071 Specified key was too long; max key length is 767 bytes<br><br># ---------------------------------------------------------- #  create table virtual_fs_db # ---------------------------------------------------------- <br>
CREATE TABLE virtual_fs_db (     id BIGINT NOT NULL AUTO_INCREMENT,     filename TEXT NOT NULL,     content LONGBLOB NOT NULL,     create_time DATETIME NOT NULL,     PRIMARY KEY(id),     INDEX virtual_fs_db_filename (filename(350)) )    <br>
0 row(s) affected, 1 warning(s): 1071 Specified key was too long; max key length is 767 bytes<br><br>