Debug info: Specified key was too long; max key length is 767 bytes
CREATE TABLE mood_hvp (
id BIGINT(10) NOT NULL auto_increment,
course BIGINT(10) NOT NULL DEFAULT 0,
name VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
intro LONGTEXT COLLATE utf8mb4_unicode_ci,
introformat SMALLINT(4) NOT NULL DEFAULT 0,
json_content LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,
embed_type VARCHAR(127) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
disable BIGINT(10) NOT NULL DEFAULT 0,
main_library_id BIGINT(10) NOT NULL,
content_type VARCHAR(127) COLLATE utf8mb4_unicode_ci,
author VARCHAR(127) COLLATE utf8mb4_unicode_ci,
license VARCHAR(7) COLLATE utf8mb4_unicode_ci,
meta_keywords LONGTEXT COLLATE utf8mb4_unicode_ci,
meta_description LONGTEXT COLLATE utf8mb4_unicode_ci,
filtered LONGTEXT COLLATE utf8mb4_unicode_ci,
slug VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
timecreated BIGINT(10) NOT NULL DEFAULT 0,
timemodified BIGINT(10) NOT NULL DEFAULT 0,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Dynamic
COMMENT='Activity data'
;
CREATE TABLE mood_hvp_content_user_data (
id BIGINT(10) NOT NULL auto_increment,
user_id BIGINT(10) NOT NULL,
hvp_id BIGINT(10) NOT NULL,
sub_content_id BIGINT(10) NOT NULL,
data_id VARCHAR(127) COLLATE utf8mb4_unicode_ci,
data LONGTEXT COLLATE utf8mb4_unicode_ci,
preloaded TINYINT(1) NOT NULL,
delete_on_content_change TINYINT(1) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Dynamic
COMMENT='Stores user data about the content'
;
CREATE TABLE mood_hvp_libraries (
id BIGINT(10) NOT NULL auto_increment,
machine_name VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
title VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
major_version SMALLINT(4) NOT NULL,
minor_version SMALLINT(4) NOT NULL,
patch_version SMALLINT(4) NOT NULL,
runnable TINYINT(1) NOT NULL,
fullscreen TINYINT(1) NOT NULL DEFAULT 0,
embed_types VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
preloaded_js LONGTEXT COLLATE utf8mb4_unicode_ci,
preloaded_css LONGTEXT COLLATE utf8mb4_unicode_ci,
drop_library_css LONGTEXT COLLATE utf8mb4_unicode_ci,
semantics LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,
restricted TINYINT(1) NOT NULL DEFAULT 0,
tutorial_url VARCHAR(1000) COLLATE utf8mb4_unicode_ci,
CONSTRAINT PRIMARY KEY (id)
, KEY mood_hvplibr_macmajminpatru_ix (machine_name, major_version, minor_version, patch_version, runnable)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Dynamic
COMMENT='Stores information about libraries.'
;
CREATE TABLE mood_hvp_libraries_libraries (
id BIGINT(10) NOT NULL auto_increment,
library_id BIGINT(10) NOT NULL,
required_library_id BIGINT(10) NOT NULL,
dependency_type VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Dynamic
COMMENT='Library dependencies'
;
CREATE TABLE mood_hvp_libraries_languages (
id BIGINT(10) NOT NULL auto_increment,
library_id BIGINT(10) NOT NULL,
language_code VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
language_json LONGTEXT COLLATE utf8mb4_unicode_ci NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Dynamic
COMMENT='Translations for libraries'
;
CREATE TABLE mood_hvp_libraries_cachedassets (
id BIGINT(10) NOT NULL auto_increment,
library_id BIGINT(10) NOT NULL,
hash VARCHAR(64) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
, UNIQUE KEY mood_hvplibrcach_libhas_uix (library_id, hash)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Dynamic
COMMENT='Use to know which caches to clear when a library is updated'
;
CREATE TABLE mood_hvp_contents_libraries (
id BIGINT(10) NOT NULL auto_increment,
hvp_id BIGINT(10) NOT NULL,
library_id BIGINT(10) NOT NULL,
dependency_type VARCHAR(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
drop_css TINYINT(1) NOT NULL,
weight BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mood_hvpcontlibr_dro_ix (drop_css)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Dynamic
COMMENT='Store which library is used in which content.'
;
CREATE TABLE mood_hvp_events (
id BIGINT(10) NOT NULL auto_increment,
user_id BIGINT(10) NOT NULL,
created_at BIGINT(10) NOT NULL,
type VARCHAR(63) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
sub_type VARCHAR(63) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
content_id BIGINT(10) NOT NULL,
content_title VARCHAR(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
library_name VARCHAR(127) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
library_version VARCHAR(31) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Dynamic
COMMENT='Keep track of logged H5P events'
;
CREATE TABLE mood_hvp_tmpfiles (
id BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Dynamic
COMMENT='Keep track of files uploaded before content is saved'
;
CREATE TABLE mood_hvp_counters (
id BIGINT(10) NOT NULL auto_increment,
type VARCHAR(63) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
library_name VARCHAR(127) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
library_version VARCHAR(31) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
num BIGINT(10) NOT NULL,
CONSTRAINT PRIMARY KEY (id)
, KEY mood_hvpcoun_typliblib_ix (type, library_name, library_version)
)
ENGINE = InnoDB
DEFAULT COLLATE = utf8mb4_unicode_ci ROW_FORMAT=Dynamic
COMMENT='A set of global counters to keep track of H5P usage'
Error code: ddlexecuteerror 

Stack trace:

    line 485 of /lib/dml/moodle_database.php: ddl_change_structure_exception thrown
    line 1005 of /lib/dml/mysqli_native_moodle_database.php: call to moodle_database->query_end()
    line 77 of /lib/ddl/database_manager.php: call to mysqli_native_moodle_database->change_database_structure()
    line 425 of /lib/ddl/database_manager.php: call to database_manager->execute_sql_arr()
    line 370 of /lib/ddl/database_manager.php: call to database_manager->install_from_xmldb_structure()
    line 696 of /lib/upgradelib.php: call to database_manager->install_from_xmldb_file()
    line 438 of /lib/upgradelib.php: call to upgrade_plugins_modules()
    line 1748 of /lib/upgradelib.php: call to upgrade_plugins()
    line 693 of /admin/index.php: call to upgrade_noncore()