wp_erp_hr_leaves_new

CREATE TABLE Statement

CREATE TABLE wp_erp_hr_leaves_new ( id smallint(6) NOT NULL AUTO_INCREMENT, name varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, description text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate;", "CREATE TABLE wp_erp_hr_leave_policies_new ( id int(10) UNSIGNED NOT NULL AUTO_INCREMENT, leave_id smallint(5) UNSIGNED NOT NULL, old_policy_id int(11) UNSIGNED DEFAULT NULL, description text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, days tinyint(3) UNSIGNED NOT NULL DEFAULT '0', color varchar(10) DEFAULT NULL, apply_limit tinyint(3) UNSIGNED NOT NULL DEFAULT '0', employee_type enum('-1','permanent','parttime','contract','temporary','trainee') NOT NULL DEFAULT 'permanent', department_id int(11) NOT NULL DEFAULT '-1', location_id int(11) NOT NULL DEFAULT '-1', designation_id int(11) NOT NULL DEFAULT '-1', gender enum('-1','male','female','other') NOT NULL DEFAULT '-1', marital enum('-1','single','married','widowed') NOT NULL DEFAULT '-1', f_year smallint(5) UNSIGNED DEFAULT NULL, apply_for_new_users tinyint(3) UNSIGNED NOT NULL DEFAULT '0', carryover_days tinyint(3) UNSIGNED NOT NULL DEFAULT '0', carryover_uses_limit tinyint(3) UNSIGNED NOT NULL DEFAULT '0', encashment_days tinyint(3) UNSIGNED NOT NULL DEFAULT '0', encashment_based_on enum('pay_rate','basic','gross') DEFAULT NULL, forward_default enum('encashment','carryover') NOT NULL DEFAULT 'encashment', applicable_from_days smallint(5) UNSIGNED NOT NULL DEFAULT '0', accrued_amount decimal(10,2) NOT NULL DEFAULT '0.00', accrued_max_days smallint(4) UNSIGNED NOT NULL DEFAULT '0', halfday_enable tinyint(3) UNSIGNED NOT NULL DEFAULT '0', created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_id (leave_id), KEY f_year (f_year) ) $charset_collate;", "CREATE TABLE wp_erp_hr_leave_policies_segregation_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_policy_id bigint(20) UNSIGNED NOT NULL, jan tinyint(3) UNSIGNED NOT NULL DEFAULT '0', feb tinyint(3) UNSIGNED NOT NULL DEFAULT '0', mar tinyint(3) UNSIGNED NOT NULL DEFAULT '0', apr tinyint(3) UNSIGNED NOT NULL DEFAULT '0', may tinyint(3) UNSIGNED NOT NULL DEFAULT '0', jun tinyint(3) UNSIGNED NOT NULL DEFAULT '0', jul tinyint(3) UNSIGNED NOT NULL DEFAULT '0', aug tinyint(3) UNSIGNED NOT NULL DEFAULT '0', sep tinyint(3) UNSIGNED NOT NULL DEFAULT '0', oct tinyint(3) UNSIGNED NOT NULL DEFAULT '0', nov tinyint(3) UNSIGNED NOT NULL DEFAULT '0', decem tinyint(3) UNSIGNED NOT NULL DEFAULT '0', created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_policy_id (leave_policy_id) ) $charset_collate;", "CREATE TABLE wp_erp_hr_leave_entitlements_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, created_by bigint(20) UNSIGNED DEFAULT NULL, trn_id bigint(20) UNSIGNED NOT NULL, trn_type enum('leave_policies','leave_approval_status','leave_encashment_requests','leave_entitlements','unpaid_leave','leave_encashment', 'leave_carryforward', 'manual_leave_policies', 'Accounts', 'others', 'leave_accrual', 'carry_forward_leave_expired') NOT NULL DEFAULT 'leave_policies', day_in decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', day_out decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', description text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, f_year smallint(6) NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY comp_key_1 (user_id,leave_id,f_year,trn_type), KEY trn_id (trn_id), KEY leave_id (leave_id) ) $charset_collate;", "CREATE TABLE wp_erp_hr_leave_requests_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, leave_entitlement_id bigint(20) UNSIGNED NOT NULL default '0', day_status_id smallint(5) UNSIGNED NOT NULL DEFAULT '1', days decimal(5,1) UNSIGNED NOT NULL DEFAULT '0.0', start_date int(11) NOT NULL, end_date int(11) NOT NULL, reason text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, last_status smallint(6) UNSIGNED NOT NULL DEFAULT '2', created_by bigint(20) UNSIGNED DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY user_leave (user_id,leave_id), KEY user_entitlement (user_id,leave_entitlement_id), KEY last_status (last_status), KEY leave_entitlement_id (leave_entitlement_id) ) $charset_collate;", "CREATE TABLE wp_erp_hr_leave_approval_status_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_request_id bigint(20) UNSIGNED NOT NULL, approval_status_id tinyint(3) UNSIGNED NOT NULL DEFAULT '0', approved_by bigint(20) UNSIGNED DEFAULT NULL, message text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_request_id (leave_request_id), KEY approval_status_id (approval_status_id) ) $charset_collate;", "CREATE TABLE wp_erp_hr_leave_request_details_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_request_id bigint(20) UNSIGNED NOT NULL, leave_approval_status_id bigint(20) UNSIGNED NOT NULL, workingday_status tinyint(3) UNSIGNED NOT NULL DEFAULT '1', user_id bigint(20) UNSIGNED NOT NULL, f_year smallint(6) NOT NULL, leave_date int(11) NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY leave_request_id (leave_request_id), KEY user_id (user_id), KEY user_fyear_leave (user_id,f_year,leave_date) ) $charset_collate;", "CREATE TABLE wp_erp_hr_leave_encashment_requests_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id bigint(20) UNSIGNED NOT NULL, leave_id smallint(6) UNSIGNED NOT NULL, approved_by bigint(20) UNSIGNED DEFAULT NULL, approval_status_id tinyint(3) UNSIGNED NOT NULL DEFAULT '1', encash_days decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', forward_days decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', amount decimal(20,2) NOT NULL DEFAULT '0.00', total decimal(20,2) NOT NULL DEFAULT '0.00', f_year smallint(5) UNSIGNED NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY leave_id (leave_id), KEY f_year (f_year) ) $charset_collate;", "CREATE TABLE wp_erp_hr_leaves_unpaid_new ( id bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, leave_id smallint(6) UNSIGNED NOT NULL, leave_request_id bigint(20) UNSIGNED NOT NULL, leave_approval_status_id bigint(20) UNSIGNED NOT NULL, user_id bigint(20) UNSIGNED NOT NULL, days decimal(4,1) UNSIGNED NOT NULL DEFAULT '0.0', amount decimal(20,2) NOT NULL DEFAULT '0.00', total decimal(20,2) NOT NULL DEFAULT '0.00', f_year smallint(5) UNSIGNED NOT NULL, created_at int(11) DEFAULT NULL, updated_at int(11) DEFAULT NULL, PRIMARY KEY (id), KEY user_id (user_id), KEY leave_id (leave_id), KEY f_year (f_year), KEY leave_request_id (leave_request_id), KEY leave_approval_status_id (leave_approval_status_id) ) $charset_collate;", "CREATE TABLE wp_erp_hr_financial_years_new ( id int(11) UNSIGNED NOT NULL AUTO_INCREMENT, fy_name varchar(255) COLLATE

Safe to delete?

How to remove this table

DROP TABLE IF EXISTS `wp_erp_hr_leaves_new`;

Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.

Other tables from ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support