wp_cbt_learning_sessions
StaticStores session data for tracking user or visitor state.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| course_id | BIGINT UNSIGNED | NO |
| title | VARCHAR(255) | NO |
| description | LONGTEXT | YES |
| session_type | VARCHAR(50) | YES |
| module_file | VARCHAR(255) | YES |
| module_content | LONGTEXT | YES |
| youtube_url | TEXT | YES |
| live_class_url | TEXT | YES |
| live_class_datetime | DATETIME | YES |
| exam_id | BIGINT UNSIGNED | YES |
| passing_grade | INT | YES |
| sort_order | INT | YES |
| drip_days | INT | YES |
| status | VARCHAR(20) | YES |
| created_at | DATETIME | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_cbt_learning_sessions ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, course_id BIGINT UNSIGNED NOT NULL, title VARCHAR(255) NOT NULL, description LONGTEXT NULL, session_type VARCHAR(50) DEFAULT 'full', module_file VARCHAR(255) NULL, module_content LONGTEXT NULL, youtube_url TEXT NULL, live_class_url TEXT NULL, live_class_datetime DATETIME NULL, exam_id BIGINT UNSIGNED NULL, passing_grade INT DEFAULT 70, sort_order INT DEFAULT 0, drip_days INT DEFAULT 0, status VARCHAR(20) DEFAULT 'publish', created_at DATETIME DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id) ) $charset_collate;"; dbDelta($sessions);
Safe to delete?
If you have uninstalled Smitacs CBT Ujian, 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_cbt_learning_sessions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Smitacs CBT Ujian