wp_crlms_user_enrollment

Static

Stores crlms user enrollment data created by this plugin.

CREATE TABLE Statement

CREATE TABLE `wp_crlms_user_enrollment` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `user_id` bigint NOT NULL,\n  `course_id` bigint NOT NULL,\n  `membership_id` bigint DEFAULT NULL,\n  `order_id` bigint unsigned NOT NULL DEFAULT '0',\n  `status` varchar(45) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n  `progress` varchar(45) COLLATE utf8mb4_unicode_520_ci NOT NULL DEFAULT '',\n  `start_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  `end_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\n  PRIMARY KEY (`id`),\n  KEY `user_id` (`user_id`),\n  KEY `course_id` (`course_id`),\n  KEY `order_id` (`order_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_user_enrollment`;

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