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()