wp_erp_acct_purchase_details_tax
StaticStores erp acct purchase details tax data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(20) UNSIGNED | NO |
| invoice_details_id | int(20) | NO |
| agency_id | int(20) | YES |
| tax_rate | decimal(20,2) | NO |
| created_at | datetime | YES |
| created_by | int(20) | YES |
| updated_at | datetime | YES |
| updated_by | int(20) | YES |
CREATE TABLE Statement
CREATE TABLE wp_erp_acct_purchase_details_tax ( id int(20) UNSIGNED NOT NULL AUTO_INCREMENT, invoice_details_id int(20) NOT NULL, agency_id int(20) DEFAULT NULL, tax_rate decimal(20,2) NOT NULL, created_at datetime DEFAULT NULL, created_by int(20) DEFAULT NULL, updated_at datetime DEFAULT NULL, updated_by int(20) DEFAULT NULL, PRIMARY KEY (id) ) $charset_collate"; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $sql );
Safe to delete?
If you have uninstalled ERP: Complete HR, Recruitment, Accounting & CRM Suite with WooCommerce CRM Support, 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_erp_acct_purchase_details_tax`;
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