{"table_name":"lifterlms_api_keys","full_table_name":"wp_lifterlms_api_keys","description":"Stores lifterlms api keys data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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' );","columns":[{"name":"id","type":"bigint(20) unsigned","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"description","type":"varchar(200)","nullable":true,"primary_key":false},{"name":"permissions","type":"varchar(10)","nullable":false,"primary_key":false},{"name":"consumer_key","type":"char(64)","nullable":false,"primary_key":false},{"name":"consumer_secret","type":"char(43)","nullable":false,"primary_key":false},{"name":"truncated_key","type":"char(7)","nullable":false,"primary_key":false},{"name":"last_access","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"name","type":"text","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"delivery_url","type":"text","nullable":false,"primary_key":false},{"name":"secret","type":"text","nullable":false,"primary_key":false},{"name":"topic","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"created","type":"datetime","nullable":false,"primary_key":false},{"name":"updated","type":"datetime","nullable":false,"primary_key":false},{"name":"failure_count","type":"smallint(3) unsigned","nullable":false,"primary_key":false}],"plugin":{"slug":"lifterlms","name":"LifterLMS – WP LMS for eLearning, Online Courses, & Quizzes","active_installs":10000,"version":"10.0.9","wp_org_url":"https://wordpress.org/plugins/lifterlms/"}}