{"table_name":"h5p_results","full_table_name":"wp_h5p_results","description":"Stores h5p results data created by this plugin.","detection_method":"static","confidence":"medium","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};\");","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}],"plugin":{"slug":"h5p","name":"Interactive Content – H5P","active_installs":40000,"version":"1.17.8","wp_org_url":"https://wordpress.org/plugins/h5p/"}}