Database Migration Error: Specified key was too long

I run drone through Docker but failed.

    image: drone/drone
    container_name: drone-serer
      - DRONE_DATABASE_DATASOURCE=root:password@tcp(

The error message is Error 1071: Specified key was too long; max key length is 767 bytes.

Then I found sql of builds table has problem, the field Index is too long?

CREATE INDEX ix_build_author ON builds (build_author);

follow is my mysql situation


We should not update mysql configuration items, such as innodb_large_prefix,innodb_file_format etc. Sql statement should be updated to be correct.

Now I can not do anything except using sqlite.