{"slug":"quick-learn","name":"Quick Learn","description":"Quick Learn is the best Complete WordPress LMS plugin. It makes simple to create Instructors, Students, Courses, Categories, Tags, lessons, Assessment …","author":"Rajesh Thanoch","active_installs":0,"version":"1.0.1","wp_org_url":"https://wordpress.org/plugins/quick-learn/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"completed_course","full_table_name":"wp_completed_course","description":"Stores completed course data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"courseid","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"userid","type":"varchar(250)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_completed_course ( `id` int(11) NOT NULL AUTO_INCREMENT, `courseid` varchar(250) NULL, `userid` varchar(250) NULL,PRIMARY KEY (`id`) ) {$collate}\");"},{"table_name":"completed_lesson","full_table_name":"wp_completed_lesson","description":"Stores completed lesson data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"userid","type":"int(11)","nullable":true,"primary_key":false},{"name":"postid","type":"int(11)","nullable":true,"primary_key":false},{"name":"videoid","type":"int(11)","nullable":true,"primary_key":false},{"name":"course_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_completed_lesson ( `id` int(11) NOT NULL AUTO_INCREMENT, `userid` int(11) NULL, `postid` int(11) NULL, `videoid` int(11) NULL, `course_id` int(11) NULL,PRIMARY KEY (`id`) ) {$collate}\");"},{"table_name":"gsp_instructor_payment","full_table_name":"wp_gsp_instructor_payment","description":"Stores gsp instructor payment data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"payment_id","type":"bigint(20)","nullable":true,"primary_key":true},{"name":"amount","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"transaction_id","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"payment_method","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"instructor_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"payment_date","type":"timestamp","nullable":true,"primary_key":false},{"name":"from_user_id","type":"bigint(20)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gsp_instructor_payment ( `payment_id` bigint(20) AUTO_INCREMENT, `amount` varchar(250) NULL, `transaction_id` varchar(250) NULL, `payment_method` varchar(250) NULL, `instructor_id` int(11) NULL, `payment_date` timestamp, `from_user_id` bigint(20) NULL,PRIMARY KEY (`payment_id`) ) {$collate}\");"},{"table_name":"gsp_lms_setting_meta","full_table_name":"wp_gsp_lms_setting_meta","description":"Stores additional metadata (key-value pairs) for gsp lms setting records.","detection_method":"static","confidence":"high","columns":[{"name":"gsp_setting_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"meta_key","type":"varchar(255)","nullable":true,"primary_key":false},{"name":"meta_value","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gsp_lms_setting_meta ( `gsp_setting_id` int(11) NOT NULL AUTO_INCREMENT, `meta_key` varchar(255) NULL, `meta_value` text NULL,PRIMARY KEY (`gsp_setting_id`) ) {$collate}\");"},{"table_name":"gsp_lms_wishlist","full_table_name":"wp_gsp_lms_wishlist","description":"Stores gsp lms wishlist data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"wishlist_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"course_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"user_id","type":"int(11)","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gsp_lms_wishlist ( `wishlist_id` int(11) NOT NULL AUTO_INCREMENT, `course_id` int(11) NOT NULL, `user_id` int(11) NOT NULL,PRIMARY KEY (`wishlist_id`) ) {$collate}\");"},{"table_name":"gsp_user_itemmeta","full_table_name":"wp_gsp_user_itemmeta","description":"Stores gsp user itemmeta data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"meta_id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"gsp_user_item_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"meta_key","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"meta_value","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gsp_user_itemmeta ( `meta_id` bigint(20) NOT NULL AUTO_INCREMENT, `gsp_user_item_id` bigint(20) NULL, `meta_key` varchar(250) NULL, `meta_value` text NULL,PRIMARY KEY (`meta_id`) ) {$collate}\");"},{"table_name":"gsp_user_items","full_table_name":"wp_gsp_user_items","description":"Stores gsp user items data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"user_item_id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"item_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"start_time","type":"datetime","nullable":true,"primary_key":false},{"name":"end_time","type":"datetime","nullable":true,"primary_key":false},{"name":"status","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"ref_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"ref_type","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"parent_id","type":"bigint(20)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gsp_user_items ( `user_item_id` bigint(20) NOT NULL AUTO_INCREMENT, `user_id` bigint(20) NULL, `item_id` bigint(20) NULL, `start_time` datetime NULL, `end_time` datetime NULL, `status` varchar(45) NULL, `ref_id` bigint(20) NULL, `ref_type` varchar(45) NULL, `parent_id` bigint(20) NULL,PRIMARY KEY (`user_item_id`) ) {$collate}\");"},{"table_name":"gsp_user_retakemeta","full_table_name":"wp_gsp_user_retakemeta","description":"Stores gsp user retakemeta data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"meta_id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"gsp_user_item_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"meta_key","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"meta_value","type":"text","nullable":true,"primary_key":false},{"name":"extra_value","type":"longtext","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gsp_user_retakemeta ( `meta_id` bigint(20) NOT NULL AUTO_INCREMENT, `gsp_user_item_id` bigint(20) NULL, `meta_key` varchar(250) NULL, `meta_value` text NULL, `extra_value` longtext NULL,PRIMARY KEY (`meta_id`) ) {$collate}\");"},{"table_name":"gsplms_question_answers","full_table_name":"wp_gsplms_question_answers","description":"Stores gsplms question answers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"question_answer_id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"question_id","type":"bigint(20)","nullable":false,"primary_key":false},{"name":"answer_data","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gsplms_question_answers ( `question_answer_id` bigint(20) NOT NULL AUTO_INCREMENT, `question_id` bigint(20) NOT NULL, `answer_data` text NULL,PRIMARY KEY (`question_answer_id`) ) {$collate}\");"},{"table_name":"gsplms_quiz_questions","full_table_name":"wp_gsplms_quiz_questions","description":"Stores gsplms quiz questions data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"quiz_assesment_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"quiz_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"question_id","type":"int(11)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gsplms_quiz_questions ( `quiz_assesment_id` int(11) NOT NULL AUTO_INCREMENT, `quiz_id` int(11) NOT NULL, `question_id` int(11) NULL,PRIMARY KEY (`quiz_assesment_id`) ) {$collate}\");"},{"table_name":"gsplms_rating","full_table_name":"wp_gsplms_rating","description":"Stores gsplms rating data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"rating_id","type":"int(11)","nullable":true,"primary_key":true},{"name":"user_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"post_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"rating","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"comment","type":"longtext","nullable":true,"primary_key":false},{"name":"status","type":"int(11)","nullable":true,"primary_key":false},{"name":"created_on","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gsplms_rating ( `rating_id` int(11) AUTO_INCREMENT, `user_id` int(11) NULL, `post_id` int(11) NULL, `rating` varchar(25) NULL, `comment` longtext NULL, `status` int(11) DEFAULT 1, `created_on` datetime NULL,PRIMARY KEY (`rating_id`) ) {$collate}\");"},{"table_name":"gsplms_section_items","full_table_name":"wp_gsplms_section_items","description":"Stores gsplms section items data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"section_item_id","type":"int(11)","nullable":false,"primary_key":true},{"name":"section_id","type":"int(11)","nullable":false,"primary_key":false},{"name":"course_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"item_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"item_order","type":"int(11)","nullable":true,"primary_key":false},{"name":"item_type","type":"varchar(250)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gsplms_section_items ( `section_item_id` int(11) NOT NULL AUTO_INCREMENT, `section_id` int(11) NOT NULL, `course_id` int(11) NULL, `item_id` int(11) NULL, `item_order` int(11) NULL, `item_type` varchar(250) NULL, PRIMARY KEY (`section_item_id`) ) {$collate}\");"},{"table_name":"gsplms_sections","full_table_name":"wp_gsplms_sections","description":"Stores gsplms sections data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"gsplms_setting","full_table_name":"wp_gsplms_setting","description":"Stores gsplms setting data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"int(11)","nullable":false,"primary_key":true},{"name":"course_id","type":"int(11)","nullable":true,"primary_key":false},{"name":"meta_key","type":"text","nullable":true,"primary_key":false},{"name":"meta_value","type":"text","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_gsplms_setting ( `id` int(11) NOT NULL AUTO_INCREMENT, `course_id` int(11) NULL, `meta_key` text NULL, `meta_value` text NULL,PRIMARY KEY (`id`) ) {$collate}\");"},{"table_name":"user_payments","full_table_name":"wp_user_payments","description":"Stores user payments data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"order_id","type":"bigint(20)","nullable":true,"primary_key":true},{"name":"transaction_id","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"amount","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"transaction_type","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"subscribed_date","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"payment_status","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"payer_id","type":"varchar(25)","nullable":true,"primary_key":false},{"name":"course_id","type":"varchar(45)","nullable":true,"primary_key":false},{"name":"admin_commission","type":"varchar(20)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_user_payments ( `order_id` bigint(20) AUTO_INCREMENT, `transaction_id` varchar(250) NULL, `amount` varchar(250) NULL, `transaction_type` varchar(250) NULL, `subscribed_date` datetime NULL, `user_id` bigint(20) NULL, `payment_status` varchar(25) NULL, `payer_id` varchar(25) NULL, `course_id` varchar(45) NULL, `admin_commission` varchar(20) NULL,PRIMARY KEY (`order_id`) ) {$collate}\");"}],"table_count":15}