wp_lifterlms_api_keys
StaticStores lifterlms api keys data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | bigint(20) unsigned | NO |
| user_id | bigint(20) unsigned | NO |
| description | varchar(200) | YES |
| permissions | varchar(10) | NO |
| consumer_key | char(64) | NO |
| consumer_secret | char(43) | NO |
| truncated_key | char(7) | NO |
| last_access | datetime | YES |
| status | varchar(20) | NO |
| name | text | NO |
| user_id | bigint(20) unsigned | NO |
| delivery_url | text | NO |
| secret | text | NO |
| topic | varchar(255) | NO |
| created | datetime | NO |
| updated | datetime | NO |
| failure_count | smallint(3) unsigned | NO |
CREATE TABLE Statement
CREATE TABLE `wp_lifterlms_api_keys` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `user_id` bigint(20) unsigned NOT NULL, `description` varchar(200) DEFAULT NULL, `permissions` varchar(10) NOT NULL, `consumer_key` char(64) NOT NULL, `consumer_secret` char(43) NOT NULL, `truncated_key` char(7) NOT NULL, `last_access` datetime DEFAULT NULL, PRIMARY KEY (`id`), KEY `consumer_key` (`consumer_key`), KEY `consumer_secret` (`consumer_secret`) ) $collate; CREATE TABLE `wp_lifterlms_webhooks` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `status` varchar(20) NOT NULL, `name` text NOT NULL, `user_id` bigint(20) unsigned NOT NULL, `delivery_url` text NOT NULL, `secret` text NOT NULL, `topic` varchar(255) NOT NULL, `created` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `updated` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `failure_count` smallint(3) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `user_id` (`user_id`) ) $collate; "; return $schema; } /** * Core install function * * @since 1.0.0-beta.1 * * @return void */ public static function install() { if ( ! is_blog_installed() ) { return; } do_action( 'llms_rest_before_install' );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_api_keys`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from LifterLMS – WP LMS for eLearning, Online Courses, & Quizzes