{"table_name":"crlms_video_progress","full_table_name":"wp_crlms_video_progress","description":"Stores crlms video progress data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE `wp_crlms_video_progress` (\\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\\n  `user_id` bigint NOT NULL,\\n  `lesson_id` bigint NOT NULL,\\n  `course_id` bigint NOT NULL,\\n  `watched_duration` decimal(10,2) NOT NULL DEFAULT '0.00',\\n  `total_duration` decimal(10,2) NOT NULL DEFAULT '0.00',\\n  `watch_percentage` decimal(5,2) NOT NULL DEFAULT '0.00',\\n  `last_position` decimal(10,2) NOT NULL DEFAULT '0.00',\\n  `is_completed` tinyint(1) NOT NULL DEFAULT '0',\\n  `completed_date` datetime DEFAULT NULL,\\n  `last_updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,\\n  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,\\n  PRIMARY KEY (`id`),\\n  UNIQUE KEY `user_lesson` (`user_id`,`lesson_id`),\\n  KEY `user_id` (`user_id`),\\n  KEY `lesson_id` (`lesson_id`),\\n  KEY `course_id` (`course_id`)\\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_520_ci","columns":[],"plugin":{"slug":"creatorlms","name":"Creator LMS – WordPress LMS Plugin for Coaches & Course Creators","active_installs":100,"version":"1.2.11","wp_org_url":"https://wordpress.org/plugins/creatorlms/"}}