Failed to create MySQL database: 1071, 'Specified key was too long; max key length is 3072 bytes'

[hudolejev]

Error:

sqlalchemy.exc.InternalError:
(pymysql.err.InternalError)
(1071, 'Specified key was too long; max key length is 3072 bytes')
[SQL:                                                                                                
CREATE TABLE item (                                                                                  
    id INTEGER NOT NULL AUTO_INCREMENT,                                                              
    value VARCHAR(999) NOT NULL,                                                                     
    state INTEGER,                                                                                   
    PRIMARY KEY (id),                                                                                
    UNIQUE (value)                                                                                   
)  

• OS: Ubuntu 20.04
• uWSGI version: 2.0.18-11ubuntu1
• AGAMA version: 0.1
• Flask version: 1.1.1-2
• Flask-SQLAlchemy version: 2.1-4
• SQLAlchemy version: 1.3.12+ds1-1ubuntu2
• Python version: 3.8.5
• MySQL version: 8.0.26-0ubuntu0.20.04.2