wp_lifterlms_user_postmeta
StaticStores lifterlms user postmeta data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑meta_id | bigint(20) | NO |
| user_id | bigint(20) | NO |
| post_id | bigint(20) | NO |
| meta_key | varchar(255) | YES |
| meta_value | longtext | YES |
| updated_date | datetime | NO |
| student_id | bigint(20) | YES |
| quiz_id | bigint(20) | YES |
| lesson_id | bigint(20) | YES |
| start_date | datetime | YES |
| update_date | datetime | YES |
| end_date | datetime | YES |
| status | varchar(15) | YES |
| attempt | bigint(20) | YES |
| grade | float | YES |
| can_be_resumed | tinyint(1) | YES |
| current_question_id | bigint(20) | YES |
| questions | longtext | YES |
| voucher_id | bigint(20) | NO |
| code_id | bigint(20) | NO |
| user_id | bigint(20) | NO |
| redemption_date | datetime | YES |
| voucher_id | bigint(20) | NO |
| code | varchar(20) | NO |
| redemption_count | bigint(20) | YES |
| is_deleted | tinyint(1) | NO |
| created_at | datetime | YES |
| updated_at | datetime | YES |
| created | datetime | YES |
| updated | datetime | YES |
| status | varchar(11) | YES |
| type | varchar(75) | YES |
| subscriber | varchar(255) | YES |
| trigger_id | varchar(75) | YES |
| user_id | bigint(20) | YES |
| post_id | bigint(20) | YES |
| date | datetime | YES |
| actor_id | bigint(20) | YES |
| object_type | varchar(55) | YES |
| object_id | bigint(20) | YES |
| event_type | varchar(55) | YES |
| event_action | varchar(55) | YES |
| meta | longtext | YES |
| event_id | bigint(20) unsigned | NO |
| session_key | char(32) | NO |
| data | longtext | NO |
| expires | BIGINT unsigned | NO |
CREATE TABLE Statement
CREATE TABLE `wp_lifterlms_user_postmeta` ( meta_id bigint(20) NOT NULL auto_increment, user_id bigint(20) NOT NULL, post_id bigint(20) NOT NULL, meta_key varchar(255) NULL, meta_value longtext NULL, updated_date datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`meta_id`), KEY user_id (`user_id`), KEY post_id (`post_id`) ) $collate; CREATE TABLE `wp_lifterlms_quiz_attempts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `student_id` bigint(20) DEFAULT NULL, `quiz_id` bigint(20) DEFAULT NULL, `lesson_id` bigint(20) DEFAULT NULL, `start_date` datetime DEFAULT NULL, `update_date` datetime DEFAULT NULL, `end_date` datetime DEFAULT NULL, `status` varchar(15) DEFAULT '', `attempt` bigint(20) DEFAULT NULL, `grade` float DEFAULT NULL, `can_be_resumed` tinyint(1) DEFAULT '0', `current_question_id` bigint(20) DEFAULT NULL, `questions` longtext, PRIMARY KEY (`id`), KEY `student_id` (`student_id`), KEY `quiz_id` (`quiz_id`) ) $collate; CREATE TABLE `wp_lifterlms_product_to_voucher` ( `product_id` bigint(20) NOT NULL, `voucher_id` bigint(20) NOT NULL, KEY `product_id` (`product_id`), KEY `voucher_id` (`voucher_id`) ) $collate; CREATE TABLE `wp_lifterlms_voucher_code_redemptions` ( `id` int(20) unsigned NOT NULL AUTO_INCREMENT, `code_id` bigint(20) NOT NULL, `user_id` bigint(20) NOT NULL, `redemption_date` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `code_id` (`code_id`), KEY `user_id` (`user_id`) ) $collate; CREATE TABLE `wp_lifterlms_vouchers_codes` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `voucher_id` bigint(20) NOT NULL, `code` varchar(20) NOT NULL DEFAULT '', `redemption_count` bigint(20) DEFAULT NULL, `is_deleted` tinyint(1) NOT NULL DEFAULT '0', `created_at` datetime DEFAULT NULL, `updated_at` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `code` (`code`), KEY `voucher_id` (`voucher_id`) ) $collate; CREATE TABLE `wp_lifterlms_notifications` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `created` datetime DEFAULT NULL, `updated` datetime DEFAULT NULL, `status` varchar(11) DEFAULT '0', `type` varchar(75) DEFAULT NULL, `subscriber` varchar(255) DEFAULT NULL, `trigger_id` varchar(75) DEFAULT NULL, `user_id` bigint(20) DEFAULT NULL, `post_id` bigint(20) DEFAULT NULL, PRIMARY KEY (`id`), KEY `status` (`status`), KEY `type` (`type`), KEY `subscriber` (`subscriber`(191)) ) $collate; CREATE TABLE `wp_lifterlms_events` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `date` datetime DEFAULT NULL, `actor_id` bigint(20) DEFAULT NULL, `object_type` varchar(55) DEFAULT NULL, `object_id` bigint(20) DEFAULT NULL, `event_type` varchar(55) DEFAULT NULL, `event_action` varchar(55) DEFAULT NULL, `meta` longtext DEFAULT NULL, PRIMARY KEY (`id`), KEY actor_id (`actor_id`), KEY object_id (`object_id`) ) $collate; CREATE TABLE `wp_lifterlms_events_open_sessions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `event_id` bigint(20) unsigned NOT NULL, PRIMARY KEY (`id`) ) $collate; CREATE TABLE `wp_lifterlms_sessions` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `session_key` char(32) NOT NULL, `data` longtext NOT NULL, `expires` BIGINT unsigned NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `session_key` (`session_key`) ) $collate; "; /** * Filter the database table schema. * * @since 3.34.0 * * @param string $tables A semi-colon (`;`) separated list of database table creating commands. * @param string $collate Database collation statement. */ return apply_filters( 'llms_install_get_schema', $tables, $collate );
Safe to delete?
If you have uninstalled LifterLMS – WP LMS for eLearning, Online Courses, & Quizzes, 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_lifterlms_user_postmeta`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from LifterLMS – WP LMS for eLearning, Online Courses, & Quizzes