{"slug":"lifterlms","name":"LifterLMS – WP LMS for eLearning, Online Courses, & Quizzes","description":"Complete e-learning platform to sell online courses, protect lessons, offer memberships, and quiz students. WP Learning Management System.","author":"LifterLMS","active_installs":10000,"version":"10.0.9","wp_org_url":"https://wordpress.org/plugins/lifterlms/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"actionscheduler_actions","full_table_name":"wp_actionscheduler_actions","description":"Stores actionscheduler actions data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"actionscheduler_logs","full_table_name":"wp_actionscheduler_logs","description":"A logging table that records activity, events, or audit history.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"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","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}],"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' );"},{"table_name":"lifterlms_events","full_table_name":"wp_lifterlms_events","description":"Stores lifterlms events data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"lifterlms_events_open_sessions","full_table_name":"wp_lifterlms_events_open_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"lifterlms_notifications","full_table_name":"wp_lifterlms_notifications","description":"Stores lifterlms notifications data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"lifterlms_product_to_voucher","full_table_name":"wp_lifterlms_product_to_voucher","description":"Stores product records and related data.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"lifterlms_quiz_attempts","full_table_name":"wp_lifterlms_quiz_attempts","description":"Stores lifterlms quiz attempts data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"lifterlms_sessions","full_table_name":"wp_lifterlms_sessions","description":"Stores session data for tracking user or visitor state.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"lifterlms_user_postmeta","full_table_name":"wp_lifterlms_user_postmeta","description":"Stores lifterlms user postmeta data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"meta_id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"post_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"longtext","nullable":true,"primary_key":false},{"name":"updated_date","type":"datetime","nullable":false,"primary_key":false},{"name":"student_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"quiz_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"lesson_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"start_date","type":"datetime","nullable":true,"primary_key":false},{"name":"update_date","type":"datetime","nullable":true,"primary_key":false},{"name":"end_date","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"varchar(15)","nullable":true,"primary_key":false},{"name":"attempt","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"grade","type":"float","nullable":true,"primary_key":false},{"name":"can_be_resumed","type":"tinyint(1)","nullable":true,"primary_key":false},{"name":"current_question_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"questions","type":"longtext","nullable":true,"primary_key":false},{"name":"voucher_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"code_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"redemption_date","type":"datetime","nullable":true,"primary_key":false},{"name":"voucher_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"code","type":"varchar(20)","nullable":false,"primary_key":false},{"name":"redemption_count","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"is_deleted","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created","type":"datetime","nullable":true,"primary_key":false},{"name":"updated","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"varchar(11)","nullable":true,"primary_key":false},{"name":"type","type":"varchar(75)","nullable":true,"primary_key":false},{"name":"subscriber","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"trigger_id","type":"varchar(75)","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"post_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"date","type":"datetime","nullable":true,"primary_key":false},{"name":"actor_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"object_type","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"object_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"event_type","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"event_action","type":"varchar(55)","nullable":true,"primary_key":false},{"name":"meta","type":"longtext","nullable":true,"primary_key":false},{"name":"event_id","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"session_key","type":"char(32)","nullable":false,"primary_key":false},{"name":"data","type":"longtext","nullable":false,"primary_key":false},{"name":"expires","type":"BIGINT unsigned","nullable":false,"primary_key":false}],"create_sql":"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 );"},{"table_name":"lifterlms_voucher_code_redemptions","full_table_name":"wp_lifterlms_voucher_code_redemptions","description":"Stores lifterlms voucher code redemptions data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"lifterlms_vouchers_codes","full_table_name":"wp_lifterlms_vouchers_codes","description":"Stores lifterlms vouchers codes data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null},{"table_name":"lifterlms_webhooks","full_table_name":"wp_lifterlms_webhooks","description":"Stores lifterlms webhooks data created by this plugin.","detection_method":"static","confidence":"medium","columns":[],"create_sql":null}],"table_count":13}