{"slug":"courserelay","name":"CourseRelay – SCORM Support for LearnDash LMS","description":"Complete SCORM player for LearnDash. Upload packages, embed them in lessons, and track completion. No external LRS required.","author":"JUSTADDWATER","active_installs":10,"version":"1.0.0","wp_org_url":"https://wordpress.org/plugins/courserelay/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"courserelay_completions","full_table_name":"wp_courserelay_completions","description":"Stores courserelay completions data created by this plugin.","detection_method":"static","confidence":"high","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}],"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 );"},{"table_name":"courserelay_packages","full_table_name":"wp_courserelay_packages","description":"Stores courserelay packages data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"post_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"version","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"src","type":"text","nullable":false,"primary_key":false},{"name":"content_url","type":"text","nullable":false,"primary_key":false},{"name":"content_path","type":"text","nullable":false,"primary_key":false},{"name":"launch_file","type":"text","nullable":false,"primary_key":false},{"name":"mastery_score","type":"float","nullable":false,"primary_key":false},{"name":"completion_tracking","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"completion_type","type":"varchar(32)","nullable":false,"primary_key":false},{"name":"width","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"height","type":"varchar(16)","nullable":false,"primary_key":false},{"name":"activity_id","type":"text","nullable":true,"primary_key":false},{"name":"created_at","type":"timestamp","nullable":false,"primary_key":false},{"name":"updated_at","type":"timestamp","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_courserelay_packages ( id int(11) NOT NULL AUTO_INCREMENT, post_id int(11) NOT NULL, version varchar(16) NOT NULL DEFAULT 'scorm12', src text NOT NULL, content_url text NOT NULL, content_path text NOT NULL, launch_file text NOT NULL, mastery_score float NOT NULL DEFAULT 80, completion_tracking tinyint(1) NOT NULL DEFAULT 1, completion_type varchar(32) NOT NULL DEFAULT 'auto', width varchar(16) NOT NULL DEFAULT '100%', height varchar(16) NOT NULL DEFAULT '600px', activity_id text NULL, created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY post_id (post_id) ) $charset\"; dbDelta( $sql );"},{"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","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}],"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 );"},{"table_name":"scormpleted_completions","full_table_name":"wp_scormpleted_completions","description":"Stores scormpleted completions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"scormpleted_packages","full_table_name":"wp_scormpleted_packages","description":"Stores scormpleted packages data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"scormpleted_scorm_data","full_table_name":"wp_scormpleted_scorm_data","description":"Stores scormpleted scorm data data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":6}