{"slug":"h5p","name":"Interactive Content – H5P","description":"Create and add rich content to your website for free. Some examples of what you get with H5P are Interactive Video, Quizzes, Collage and Timeline.","author":"icc0rz","active_installs":40000,"version":"1.17.8","wp_org_url":"https://wordpress.org/plugins/h5p/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"h5p_contents","full_table_name":"wp_h5p_contents","description":"Stores h5p contents data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"created_at","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"user_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"library_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"parameters","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"filtered","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(127)","nullable":false,"primary_key":false},{"name":"embed_type","type":"VARCHAR(127)","nullable":false,"primary_key":false},{"name":"disable","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"content_type","type":"VARCHAR(127)","nullable":true,"primary_key":false},{"name":"authors","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"source","type":"VARCHAR(2083)","nullable":true,"primary_key":false},{"name":"year_from","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"year_to","type":"INT UNSIGNED","nullable":true,"primary_key":false},{"name":"license","type":"VARCHAR(32)","nullable":true,"primary_key":false},{"name":"license_version","type":"VARCHAR(10)","nullable":true,"primary_key":false},{"name":"license_extras","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"author_comments","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"changes","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"default_language","type":"VARCHAR(32)","nullable":true,"primary_key":false},{"name":"a11y_title","type":"VARCHAR(255)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_contents ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, created_at TIMESTAMP NOT NULL DEFAULT 0, updated_at TIMESTAMP NOT NULL DEFAULT 0, user_id INT UNSIGNED NOT NULL, title VARCHAR(255) NOT NULL, library_id INT UNSIGNED NOT NULL, parameters LONGTEXT NOT NULL, filtered LONGTEXT NOT NULL, slug VARCHAR(127) NOT NULL, embed_type VARCHAR(127) NOT NULL, disable INT UNSIGNED NOT NULL DEFAULT 0, content_type VARCHAR(127) NULL, authors LONGTEXT NULL, source VARCHAR(2083) NULL, year_from INT UNSIGNED NULL, year_to INT UNSIGNED NULL, license VARCHAR(32) NULL, license_version VARCHAR(10) NULL, license_extras LONGTEXT NULL, author_comments LONGTEXT NULL, changes LONGTEXT NULL, default_language VARCHAR(32) NULL, a11y_title VARCHAR(255) NULL, PRIMARY KEY (id) ) {$charset};\");"},{"table_name":"h5p_contents_libraries","full_table_name":"wp_h5p_contents_libraries","description":"Stores h5p contents libraries data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"content_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"library_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"dependency_type","type":"VARCHAR(31)","nullable":false,"primary_key":false},{"name":"weight","type":"SMALLINT UNSIGNED","nullable":false,"primary_key":false},{"name":"drop_css","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_contents_libraries ( content_id INT UNSIGNED NOT NULL, library_id INT UNSIGNED NOT NULL, dependency_type VARCHAR(31) NOT NULL, weight SMALLINT UNSIGNED NOT NULL DEFAULT 0, drop_css TINYINT UNSIGNED NOT NULL, PRIMARY KEY (content_id,library_id,dependency_type) ) {$charset};\");"},{"table_name":"h5p_contents_tags","full_table_name":"wp_h5p_contents_tags","description":"Stores h5p contents tags data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"content_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"tag_id","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_contents_tags ( content_id INT UNSIGNED NOT NULL, tag_id INT UNSIGNED NOT NULL, PRIMARY KEY (content_id,tag_id) ) {$charset};\");"},{"table_name":"h5p_contents_user_data","full_table_name":"wp_h5p_contents_user_data","description":"Stores h5p contents user data data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"content_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"sub_content_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"data_id","type":"VARCHAR(127)","nullable":false,"primary_key":false},{"name":"data","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"preload","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"invalidate","type":"TINYINT UNSIGNED","nullable":false,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_contents_user_data ( content_id INT UNSIGNED NOT NULL, user_id INT UNSIGNED NOT NULL, sub_content_id INT UNSIGNED NOT NULL, data_id VARCHAR(127) NOT NULL, data LONGTEXT NOT NULL, preload TINYINT UNSIGNED NOT NULL DEFAULT 0, invalidate TINYINT UNSIGNED NOT NULL DEFAULT 0, updated_at TIMESTAMP NOT NULL DEFAULT 0, PRIMARY KEY (content_id,user_id,sub_content_id,data_id) ) {$charset};\");"},{"table_name":"h5p_counters","full_table_name":"wp_h5p_counters","description":"Stores h5p counters data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"type","type":"VARCHAR(63)","nullable":false,"primary_key":false},{"name":"library_name","type":"VARCHAR(127)","nullable":false,"primary_key":false},{"name":"library_version","type":"VARCHAR(31)","nullable":false,"primary_key":false},{"name":"num","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_counters ( type VARCHAR(63) NOT NULL, library_name VARCHAR(127) NOT NULL, library_version VARCHAR(31) NOT NULL, num INT UNSIGNED NOT NULL, PRIMARY KEY (type,library_name,library_version) ) {$charset};\");"},{"table_name":"h5p_events","full_table_name":"wp_h5p_events","description":"Stores h5p events data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"created_at","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(63)","nullable":false,"primary_key":false},{"name":"sub_type","type":"VARCHAR(63)","nullable":false,"primary_key":false},{"name":"content_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"content_title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"library_name","type":"VARCHAR(127)","nullable":false,"primary_key":false},{"name":"library_version","type":"VARCHAR(31)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_events ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, user_id INT UNSIGNED NOT NULL, created_at INT UNSIGNED NOT NULL, type VARCHAR(63) NOT NULL, sub_type VARCHAR(63) NOT NULL, content_id INT UNSIGNED NOT NULL, content_title VARCHAR(255) NOT NULL, library_name VARCHAR(127) NOT NULL, library_version VARCHAR(31) NOT NULL, PRIMARY KEY (id) ) {$charset};\");"},{"table_name":"h5p_libraries","full_table_name":"wp_h5p_libraries","description":"Stores h5p libraries data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"created_at","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"updated_at","type":"TIMESTAMP","nullable":false,"primary_key":false},{"name":"name","type":"VARCHAR(127)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"major_version","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"minor_version","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"patch_version","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"runnable","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"restricted","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"fullscreen","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"embed_types","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"preloaded_js","type":"TEXT","nullable":true,"primary_key":false},{"name":"preloaded_css","type":"TEXT","nullable":true,"primary_key":false},{"name":"drop_library_css","type":"TEXT","nullable":true,"primary_key":false},{"name":"semantics","type":"TEXT","nullable":false,"primary_key":false},{"name":"tutorial_url","type":"VARCHAR(1023)","nullable":false,"primary_key":false},{"name":"has_icon","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"metadata_settings","type":"TEXT","nullable":true,"primary_key":false},{"name":"add_to","type":"TEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_libraries ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, created_at TIMESTAMP NOT NULL, updated_at TIMESTAMP NOT NULL, name VARCHAR(127) NOT NULL, title VARCHAR(255) NOT NULL, major_version INT UNSIGNED NOT NULL, minor_version INT UNSIGNED NOT NULL, patch_version INT UNSIGNED NOT NULL, runnable INT UNSIGNED NOT NULL, restricted INT UNSIGNED NOT NULL DEFAULT 0, fullscreen INT UNSIGNED NOT NULL, embed_types VARCHAR(255) NOT NULL, preloaded_js TEXT NULL, preloaded_css TEXT NULL, drop_library_css TEXT NULL, semantics TEXT NOT NULL, tutorial_url VARCHAR(1023) NOT NULL, has_icon INT UNSIGNED NOT NULL DEFAULT 0, metadata_settings TEXT NULL, add_to TEXT DEFAULT NULL, PRIMARY KEY (id), KEY name_version (name,major_version,minor_version,patch_version), KEY runnable (runnable) ) {$charset};\");"},{"table_name":"h5p_libraries_cachedassets","full_table_name":"wp_h5p_libraries_cachedassets","description":"A cache table that stores temporary computed or fetched data.","detection_method":"static","confidence":"medium","columns":[{"name":"library_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"hash","type":"VARCHAR(64)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_libraries_cachedassets ( library_id INT UNSIGNED NOT NULL, hash VARCHAR(64) NOT NULL, PRIMARY KEY (library_id,hash) ) {$charset};\");"},{"table_name":"h5p_libraries_languages","full_table_name":"wp_h5p_libraries_languages","description":"Stores h5p libraries languages data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"library_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"language_code","type":"VARCHAR(31)","nullable":false,"primary_key":false},{"name":"translation","type":"TEXT","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_libraries_languages ( library_id INT UNSIGNED NOT NULL, language_code VARCHAR(31) NOT NULL, translation TEXT NOT NULL, PRIMARY KEY (library_id,language_code) ) {$charset};\");"},{"table_name":"h5p_libraries_libraries","full_table_name":"wp_h5p_libraries_libraries","description":"Stores h5p libraries libraries data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"library_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"required_library_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"dependency_type","type":"VARCHAR(31)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_libraries_libraries ( library_id INT UNSIGNED NOT NULL, required_library_id INT UNSIGNED NOT NULL, dependency_type VARCHAR(31) NOT NULL, PRIMARY KEY (library_id,required_library_id) ) {$charset};\");"},{"table_name":"h5p_results","full_table_name":"wp_h5p_results","description":"Stores h5p results data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"content_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"user_id","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"score","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"max_score","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"opened","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"finished","type":"INT UNSIGNED","nullable":false,"primary_key":false},{"name":"time","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_results ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, content_id INT UNSIGNED NOT NULL, user_id INT UNSIGNED NOT NULL, score INT UNSIGNED NOT NULL, max_score INT UNSIGNED NOT NULL, opened INT UNSIGNED NOT NULL, finished INT UNSIGNED NOT NULL, time INT UNSIGNED NOT NULL, PRIMARY KEY (id), KEY content_user (content_id,user_id) ) {$charset};\");"},{"table_name":"h5p_tags","full_table_name":"wp_h5p_tags","description":"Stores h5p tags data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(31)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_tags ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(31) NOT NULL, PRIMARY KEY (id) ) {$charset};\");"},{"table_name":"h5p_tmpfiles","full_table_name":"wp_h5p_tmpfiles","description":"Stores h5p tmpfiles data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"INT UNSIGNED","nullable":false,"primary_key":true},{"name":"path","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"created_at","type":"INT UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_h5p_tmpfiles ( id INT UNSIGNED NOT NULL AUTO_INCREMENT, path VARCHAR(255) NOT NULL, created_at INT UNSIGNED NOT NULL, PRIMARY KEY (id), KEY created_at (created_at) ) {$charset};\");"}],"table_count":13}