{"table_name":"courserelay_completions","full_table_name":"wp_courserelay_completions","description":"Stores courserelay completions data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_courserelay_completions ( id int(11) NOT NULL AUTO_INCREMENT, content_id int(11) NOT NULL, user_id int(11) NOT NULL, post_id int(11) NOT NULL DEFAULT 0, course_id int(11) NOT NULL DEFAULT 0, registration varchar(255) DEFAULT NULL, status varchar(16) DEFAULT NULL, score float DEFAULT NULL, time_spent int(11) DEFAULT NULL, completed_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_content (user_id, content_id), KEY user_post (user_id, post_id) ) $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":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"course_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"registration","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"status","type":"varchar(16)","nullable":true,"primary_key":false},{"name":"score","type":"float","nullable":true,"primary_key":false},{"name":"time_spent","type":"int(11)","nullable":true,"primary_key":false},{"name":"completed_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/"}}