wp_crlms_video_progress
StaticStores crlms video progress data created by this plugin.
CREATE TABLE Statement
CREATE TABLE `wp_crlms_video_progress` (\n `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n `user_id` bigint NOT NULL,\n `lesson_id` bigint NOT NULL,\n `course_id` bigint NOT NULL,\n `watched_duration` decimal(10,2) NOT NULL DEFAULT '0.00',\n `total_duration` decimal(10,2) NOT NULL DEFAULT '0.00',\n `watch_percentage` decimal(5,2) NOT NULL DEFAULT '0.00',\n `last_position` decimal(10,2) NOT NULL DEFAULT '0.00',\n `is_completed` tinyint(1) NOT NULL DEFAULT '0',\n `completed_date` datetime DEFAULT NULL,\n `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\n `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (`id`),\n UNIQUE KEY `user_lesson` (`user_id`,`lesson_id`),\n KEY `user_id` (`user_id`),\n KEY `lesson_id` (`lesson_id`),\n KEY `course_id` (`course_id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci
Safe to delete?
If you have uninstalled Creator LMS – WordPress LMS Plugin for Coaches & Course Creators, 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_crlms_video_progress`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Creator LMS – WordPress LMS Plugin for Coaches & Course Creators