wp_foxlms_submissions
StaticStores form submissions and user-entered data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | INT(11) | NO |
| course_id | INT(11) UNSIGNED | NO |
| post_id | INT(11) UNSIGNED | NO |
| user_id | INT(11) UNSIGNED | NO |
| questions_ids | TEXT | NO |
| lessons_ids | TEXT | NO |
| questions_post_ids | TEXT | NO |
| user_ip | VARCHAR(256) | NO |
| user_name | TEXT | NO |
| user_email | TEXT | NO |
| start_date | DATETIME | NO |
| end_date | DATETIME | NO |
| submission_date | DATETIME | NO |
| country | VARCHAR(256) | NO |
| city | VARCHAR(256) | NO |
| duration | VARCHAR(256) | NO |
| questions_count | VARCHAR(256) | NO |
| lessons_count | VARCHAR(256) | NO |
| unique_code | VARCHAR(256) | NO |
| read | TINYINT(3) | NO |
| status | VARCHAR(256) | NO |
| password | VARCHAR(256) | NO |
| point | INT(11) | NO |
| changed | INT(11) UNSIGNED | NO |
| admin_note | TEXT | NO |
| options | TEXT | NO |
CREATE TABLE Statement
CREATE TABLE `wp_foxlms_submissions` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `course_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `post_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `user_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `questions_ids` TEXT NOT NULL, `lessons_ids` TEXT NOT NULL, `questions_post_ids` TEXT NOT NULL, `user_ip` VARCHAR(256) NOT NULL DEFAULT '', `user_name` TEXT NOT NULL, `user_email` TEXT NOT NULL, `start_date` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00', `end_date` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00', `submission_date` DATETIME NOT NULL DEFAULT '1000-01-01 00:00:00', `country` VARCHAR(256) NOT NULL DEFAULT '', `city` VARCHAR(256) NOT NULL DEFAULT '', `duration` VARCHAR(256) NOT NULL DEFAULT '0', `questions_count` VARCHAR(256) NOT NULL DEFAULT '0', `lessons_count` VARCHAR(256) NOT NULL DEFAULT '0', `unique_code` VARCHAR(256) NOT NULL DEFAULT '', `read` TINYINT(3) NOT NULL DEFAULT 0, `status` VARCHAR(256) NOT NULL DEFAULT 'published', `password` VARCHAR(256) NOT NULL DEFAULT '', `point` INT(11) NOT NULL DEFAULT '0', `changed` INT(11) UNSIGNED NOT NULL DEFAULT '0', `admin_note` TEXT NOT NULL, `options` TEXT NOT NULL, PRIMARY KEY (`id`) ) $charset_collate;"; $results = $wpdb->get_results(// phpcs:ignore $wpdb->prepare( "SELECT * FROM INFORMATION_SCHEMA.TABLES WHERE table_schema = %s AND table_name = 'wp_foxlms_submissions' ", DB_NAME ) );
Safe to delete?
If you have uninstalled Fox LMS – eLearning & Course Builder, 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_foxlms_submissions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Fox LMS – eLearning & Course Builder