wp_crlms_sessions

Column Definitions

CREATE TABLE Statement

CREATE TABLE wp_crlms_sessions ( session_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, session_key char(32) NOT NULL, session_value longtext NOT NULL, session_expiry bigint(20) unsigned NOT NULL, PRIMARY KEY (session_id), UNIQUE KEY session_key (session_key) ) $charset_collate; CREATE TABLE wp_crlms_chapter_relationship ( id bigint(20) unsigned NOT NULL auto_increment, course_id INT(11) NOT NULL, chapter_id INT(11) NOT NULL, order_number INT(11) DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY unique_course_chapter (course_id, chapter_id), KEY chapter_id (chapter_id), KEY course_id (course_id) ) $charset_collate; CREATE TABLE wp_crlms_content_relationship ( id bigint(20) unsigned NOT NULL auto_increment, chapter_id INT(11) NOT NULL, content_id INT(11) NOT NULL, content_type VARCHAR(225) NOT NULL, order_number INT(11) DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY unique_chapter_content (chapter_id, content_id, content_type), KEY chapter_id (chapter_id), KEY content_id (content_id) ) $charset_collate; CREATE TABLE wp_crlms_certificate_relationship ( id bigint(20) unsigned NOT NULL auto_increment, course_id INT(11) NOT NULL, certificate_id INT(11) NOT NULL, PRIMARY KEY (id), UNIQUE KEY unique_course_certificate (course_id, certificate_id), KEY course_id (course_id), KEY certificate_id (certificate_id) ) $charset_collate; CREATE TABLE wp_crlms_user_enrollment ( id bigint(20) unsigned NOT NULL auto_increment, user_id bigint(20) NOT NULL, course_id bigint(20) NOT NULL, membership_id bigint(20) default NULL, order_id bigint(20) unsigned NOT NULL DEFAULT 0, status varchar(45) NOT NULL DEFAULT '', progress varchar(45) NOT NULL DEFAULT '', start_date datetime NOT NULL default '0000-00-00 00:00:00', end_date datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id), KEY user_id (user_id), KEY course_id (course_id), KEY order_id (order_id) ) $charset_collate; CREATE TABLE wp_crlms_earning ( id bigint(20) unsigned NOT NULL auto_increment, membership_id bigint(20) default NULL, course_id bigint(20) default NULL, order_id bigint(20) unsigned NOT NULL DEFAULT 0, status varchar(45) NOT NULL DEFAULT '', start_date datetime NOT NULL default '0000-00-00 00:00:00', end_date datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id), KEY order_id (order_id) ) $charset_collate; CREATE TABLE wp_crlms_user_progress ( id bigint(20) unsigned NOT NULL auto_increment, enrollment_id bigint(20) NOT NULL, content_id bigint(20) NOT NULL, content_type varchar(45) NOT NULL DEFAULT '', status varchar(45) NOT NULL DEFAULT '', start_date datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id), KEY enrollment_id (enrollment_id), KEY course_id (content_id) ) $charset_collate; CREATE TABLE wp_crlms_video_progress ( id bigint(20) unsigned NOT NULL auto_increment, user_id bigint(20) NOT NULL, lesson_id bigint(20) NOT NULL, course_id bigint(20) NOT NULL, watched_duration decimal(10,2) NOT NULL DEFAULT 0, total_duration decimal(10,2) NOT NULL DEFAULT 0, watch_percentage decimal(5,2) NOT NULL DEFAULT 0, last_position decimal(10,2) NOT NULL DEFAULT 0, is_completed tinyint(1) NOT NULL DEFAULT 0, completed_date datetime NULL, last_updated datetime NOT NULL default CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, created_date datetime NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY user_lesson (user_id, lesson_id), KEY user_id (user_id), KEY lesson_id (lesson_id), KEY course_id (course_id) ) $charset_collate; CREATE TABLE wp_crlms_quiz_questions_relationship ( id bigint(20) unsigned NOT NULL auto_increment, quiz_id INT(11) NOT NULL, question_id INT(11) NOT NULL, order_number INT(11) DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY id (id), KEY quiz_id (quiz_id), KEY question_id (question_id) ) $charset_collate; CREATE TABLE wp_crlms_quiz_attempts ( id bigint(20) unsigned NOT NULL auto_increment, course_id bigint(20) NOT NULL, quiz_id bigint(20) NOT NULL, student_id bigint(20) unsigned NOT NULL DEFAULT 0, total bigint(20) unsigned NOT NULL DEFAULT 0, status varchar(45) NOT NULL DEFAULT '', start_date datetime NOT NULL default '0000-00-00 00:00:00', end_date datetime NOT NULL default '0000-00-00 00:00:00', PRIMARY KEY (id), KEY course_id (course_id), KEY quiz_id (quiz_id), KEY student_id (student_id) ) $charset_collate; CREATE TABLE wp_crlms_quiz_attempts_answers ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, student_id bigint(20) unsigned NOT NULL DEFAULT 0, quiz_id bigint(20) NOT NULL, question_id bigint(20) NOT NULL, quiz_attempt_id bigint(20) NOT NULL, given_answer longtext NOT NULL, question_marks float DEFAULT 0, achive_mark float DEFAULT 0, minus_mark float DEFAULT 0, is_correct boolean NULL DEFAULT 0, is_manually_reviewed boolean NULL DEFAULT 0, PRIMARY KEY (id), KEY quiz_attempt_id (quiz_attempt_id), KEY quiz_id (quiz_id), KEY student_id (student_id) ) $charset_collate; CREATE TABLE wp_crlms_question_answers ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, question_id bigint(20) NOT NULL, answer longtext NOT NULL, order_number INT(11) DEFAULT 0, is_correct boolean NOT NULL DEFAULT 0, PRIMARY KEY (id), UNIQUE KEY id (id) ) $charset_collate; CREATE TABLE wp_crlms_question_answermeta ( id bigint(20) unsigned NOT NULL AUTO_INCREMENT, answer_id bigint(20) NOT NULL, meta_key char(32) NOT NULL, meta_value longtext NOT NULL, PRIMARY KEY (id), UNIQUE KEY id (id) ) $charset_collate; CREATE TABLE wp_crlms_order_items ( order_item_id bigint(20) unsigned NOT NULL AUTO_INCREMENT, order_item_name text NOT NULL, order_item_type varchar(200) NOT NULL DEFAULT '', order_id bigint(20) unsigned NOT NULL, PRIMARY KEY (order_item_id), KEY order_id (order_id) ) $charset_collate; CREATE TABLE wp_crlms_order_itemmeta ( meta_id bigint(20) unsigned NOT NULL auto_increment, order_item_id bigint(20) unsigned NOT NULL, meta_key varchar(255) default NULL, meta_value longtext NULL, PRIMARY KEY (meta_id), KEY order_item_id (order_item_id), KEY meta_key (meta_key(32)) ) $charset_collate; CREATE TABLE wp_crlms_notifications ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, student_id BIGINT(20) NOT NULL, course_id BIGINT(20) NOT NULL, email VARCHAR(255) NOT NULL, subject TEXT NOT NULL, message LONGTEXT NOT NULL, status VARCHAR(50) DEFAULT 'sent', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY student_id (student_id), KEY course_id (course_id) ) $charset_collate; CREATE TABLE wp_crlms_webhooks ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(255) NOT NULL, trigger_event VARCHAR(100) NOT NULL, webhook_url TEXT NOT NULL, http_method VARCHAR(10) NOT NULL DEFAULT 'POST', data_type VARCHAR(20) NOT NULL DEFAULT 'json', data_mapping LONGTEXT, status VARCHAR(20) NOT NULL DEFAULT 'active', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY trigger_event (trigger_event), KEY status (status) ) $charset_collate; "; return $tables; } /** * Create roles and capabilities. */ public static function create_roles() { $admin = get_role( 'administrator' );

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_crlms_sessions`;

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