wp_dp_lms_courses
StaticStores dp lms courses data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) | NO |
| title | varchar(255) | NO |
| slug | varchar(255) | NO |
| category | bigint(20) | NO |
| teacher_id | bigint(20) | NO |
| course_description | text | YES |
| available_date | datetime | NO |
| enrollment_deadline | datetime | NO |
| duration_days | int(11) | NO |
| user_id | bigint(20) | NO |
| action | varchar(100) | NO |
| details | text | NO |
| recorded_at | datetime | NO |
| name | varchar(100) | NO |
| slug | varchar(200) | NO |
| parent_id | int(11) | YES |
| course_id | bigint(20) | NO |
| title | varchar(255) | NO |
| slug | varchar(200) | YES |
| type | varchar(50) | NO |
| url | text | YES |
| content | longtext | YES |
| sort_order | int(11) | YES |
| course_id | bigint(20) | NO |
| student_id | bigint(20) | NO |
| enrolled_at | datetime | NO |
| progress_percentage | int(11) | YES |
| cert_id | varchar(12) | YES |
| status | varchar(20) | NO |
| student_id | bigint(20) | NO |
| course_id | bigint(20) | NO |
| item_id | bigint(20) | NO |
| item_type | varchar(50) | NO |
| completed_at | datetime | NO |
| student_id | bigint(20) | NO |
| module_id | bigint(20) | NO |
| grade | int(11) | YES |
| graded_at | datetime | NO |
| module_id | bigint(20) | NO |
| question_text | text | NO |
| question_type | varchar(50) | NO |
| options | text | YES |
| correct_answer | varchar(255) | NO |
| student_id | bigint(20) | NO |
| module_id | bigint(20) | NO |
| responses | longtext | YES |
| status | varchar(50) | YES |
| submitted_at | datetime | NO |
CREATE TABLE Statement
CREATE TABLE wp_dp_lms_courses ( id bigint(20) NOT NULL AUTO_INCREMENT, title varchar(255) NOT NULL, slug varchar(255) NOT NULL, category bigint(20) NOT NULL, teacher_id bigint(20) NOT NULL, course_description text DEFAULT NULL, available_date datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, enrollment_deadline datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, duration_days int(11) DEFAULT 0 NOT NULL, PRIMARY KEY (id), UNIQUE KEY slug (slug) ) $charset_collate;", "CREATE TABLE wp_dp_lms_audit_log ( id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) NOT NULL, action varchar(100) NOT NULL, details text NOT NULL, recorded_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE wp_dp_lms_categories ( id int(11) NOT NULL AUTO_INCREMENT, name varchar(100) NOT NULL, slug varchar(200) NOT NULL, parent_id int(11) DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY slug (slug) ) $charset_collate;", "CREATE TABLE wp_dp_lms_modules ( id bigint(20) NOT NULL AUTO_INCREMENT, course_id bigint(20) NOT NULL, title varchar(255) NOT NULL, slug varchar(200) DEFAULT NULL, type varchar(50) NOT NULL DEFAULT 'document', url text DEFAULT NULL, content longtext DEFAULT NULL, sort_order int(11) DEFAULT 0, PRIMARY KEY (id), KEY course_id (course_id) ) $charset_collate;", "CREATE TABLE wp_dp_lms_enrollments ( id bigint(20) NOT NULL AUTO_INCREMENT, course_id bigint(20) NOT NULL, student_id bigint(20) NOT NULL, enrolled_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, progress_percentage int(11) DEFAULT 0, cert_id varchar(12) DEFAULT NULL, status varchar(20) DEFAULT 'active' NOT NULL, PRIMARY KEY (id), UNIQUE KEY course_student (course_id, student_id), KEY idx_status (status) ) $charset_collate;", "CREATE TABLE wp_dp_lms_progress_history ( id bigint(20) NOT NULL AUTO_INCREMENT, student_id bigint(20) NOT NULL, course_id bigint(20) NOT NULL, item_id bigint(20) NOT NULL, item_type varchar(50) NOT NULL DEFAULT 'module', completed_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), KEY idx_student_course (student_id, course_id) ) $charset_collate;", "CREATE TABLE wp_dp_lms_grades ( id bigint(20) NOT NULL AUTO_INCREMENT, student_id bigint(20) NOT NULL, module_id bigint(20) NOT NULL, grade int(11) DEFAULT 0, graded_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id), UNIQUE KEY student_module (student_id, module_id) ) $charset_collate;", "CREATE TABLE wp_dp_lms_questions ( id bigint(20) NOT NULL AUTO_INCREMENT, module_id bigint(20) NOT NULL, question_text text NOT NULL, question_type varchar(50) NOT NULL, options text DEFAULT NULL, correct_answer varchar(255) NOT NULL, PRIMARY KEY (id), KEY module_id (module_id) ) $charset_collate;", "CREATE TABLE wp_dp_lms_quiz_submissions ( id bigint(20) NOT NULL AUTO_INCREMENT, student_id bigint(20) NOT NULL, module_id bigint(20) NOT NULL, responses longtext DEFAULT NULL, status varchar(50) DEFAULT 'pending', submitted_at datetime DEFAULT '0000-00-00 00:00:00' NOT NULL, PRIMARY KEY (id) ) $charset_collate;", );
Safe to delete?
If you have uninstalled Voltora Academy for Divi, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_dp_lms_courses`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Voltora Academy for Divi