{"table_name":"tutor_earnings","full_table_name":"wp_tutor_earnings","description":"Stores tutor earnings data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_tutor_earnings ( earning_id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) DEFAULT NULL, course_id bigint(20) DEFAULT NULL, order_id bigint(20) DEFAULT NULL, order_status varchar(50) DEFAULT NULL, course_price_total decimal(16,2) DEFAULT NULL, course_price_grand_total decimal(16,2) DEFAULT NULL, instructor_amount decimal(16,2) DEFAULT NULL, instructor_rate decimal(16,2) DEFAULT NULL, admin_amount decimal(16,2) DEFAULT NULL, admin_rate decimal(16,2) DEFAULT NULL, commission_type varchar(20) DEFAULT NULL, deduct_fees_amount decimal(16,2) DEFAULT NULL, deduct_fees_name varchar(250) DEFAULT NULL, deduct_fees_type varchar(20) DEFAULT NULL, process_by varchar(20) DEFAULT NULL, created_at datetime DEFAULT NULL, PRIMARY KEY (earning_id) ) $charset_collate;\"; $withdraw_table = \"CREATE TABLE IF NOT EXISTS wp_tutor_withdraws ( withdraw_id bigint(20) NOT NULL AUTO_INCREMENT, user_id bigint(20) DEFAULT NULL, amount decimal(16,2) DEFAULT NULL, method_data text DEFAULT NULL, status varchar(50) DEFAULT NULL, updated_at datetime DEFAULT NULL, created_at datetime DEFAULT NULL, PRIMARY KEY (withdraw_id) ) $charset_collate;\"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $earning_table );","columns":[{"name":"earning_id","type":"bigint(20)","nullable":false,"primary_key":true},{"name":"user_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"course_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"order_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"order_status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"course_price_total","type":"decimal(16,2)","nullable":true,"primary_key":false},{"name":"course_price_grand_total","type":"decimal(16,2)","nullable":true,"primary_key":false},{"name":"instructor_amount","type":"decimal(16,2)","nullable":true,"primary_key":false},{"name":"instructor_rate","type":"decimal(16,2)","nullable":true,"primary_key":false},{"name":"admin_amount","type":"decimal(16,2)","nullable":true,"primary_key":false},{"name":"admin_rate","type":"decimal(16,2)","nullable":true,"primary_key":false},{"name":"commission_type","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"deduct_fees_amount","type":"decimal(16,2)","nullable":true,"primary_key":false},{"name":"deduct_fees_name","type":"varchar(250)","nullable":true,"primary_key":false},{"name":"deduct_fees_type","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"process_by","type":"varchar(20)","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false},{"name":"user_id","type":"bigint(20)","nullable":true,"primary_key":false},{"name":"amount","type":"decimal(16,2)","nullable":true,"primary_key":false},{"name":"method_data","type":"text","nullable":true,"primary_key":false},{"name":"status","type":"varchar(50)","nullable":true,"primary_key":false},{"name":"updated_at","type":"datetime","nullable":true,"primary_key":false},{"name":"created_at","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"tutor","name":"Tutor LMS – eLearning and online course solution","active_installs":100000,"version":"3.9.9","wp_org_url":"https://wordpress.org/plugins/tutor/"}}