{"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","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 );","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}],"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/"}}