wp_tutor_earnings
StaticStores tutor earnings data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑earning_id | bigint(20) | NO |
| user_id | bigint(20) | YES |
| course_id | bigint(20) | YES |
| order_id | bigint(20) | YES |
| order_status | varchar(50) | YES |
| course_price_total | decimal(16,2) | YES |
| course_price_grand_total | decimal(16,2) | YES |
| instructor_amount | decimal(16,2) | YES |
| instructor_rate | decimal(16,2) | YES |
| admin_amount | decimal(16,2) | YES |
| admin_rate | decimal(16,2) | YES |
| commission_type | varchar(20) | YES |
| deduct_fees_amount | decimal(16,2) | YES |
| deduct_fees_name | varchar(250) | YES |
| deduct_fees_type | varchar(20) | YES |
| process_by | varchar(20) | YES |
| created_at | datetime | YES |
| user_id | bigint(20) | YES |
| amount | decimal(16,2) | YES |
| method_data | text | YES |
| status | varchar(50) | YES |
| updated_at | datetime | YES |
| created_at | datetime | YES |
CREATE TABLE Statement
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 );
Safe to delete?
If you have uninstalled Tutor LMS – eLearning and online course solution, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_tutor_earnings`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from Tutor LMS – eLearning and online course solution