{"table_name":"courserelay_scorm_data","full_table_name":"wp_courserelay_scorm_data","description":"Stores courserelay scorm data data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_courserelay_scorm_data ( id int(11) NOT NULL AUTO_INCREMENT, content_id int(11) NOT NULL, user_id int(11) NOT NULL, registration_id varchar(255) NOT NULL, var_key varchar(255) NOT NULL, var_value text NOT NULL, updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_content_reg (content_id, user_id, registration_id(8)), KEY var_lookup (content_id, user_id, registration_id(8), var_key(32)) ) $charset\"; dbDelta( $sql );","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"content_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"registration_id","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"var_key","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"var_value","type":"text","nullable":false,"primary_key":false},{"name":"updated_at","type":"timestamp","nullable":false,"primary_key":false}],"plugin":{"slug":"courserelay","name":"CourseRelay – SCORM Support for LearnDash LMS","active_installs":10,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/courserelay/"}}