wp_erp_acct_people_trn_details
StaticStores erp acct people trn details data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(11) | NO |
| people_id | varchar(255) | YES |
| voucher_no | int(11) | YES |
| trn_date | date | YES |
| particulars | varchar(255) | YES |
| debit | decimal(10,2) | YES |
| credit | decimal(10,2) | YES |
| created_at | date | YES |
| created_by | varchar(50) | YES |
| updated_at | date | YES |
| updated_by | varchar(50) | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS `wp_erp_acct_people_trn_details` ( `id` int(11) NOT NULL AUTO_INCREMENT, `people_id` varchar(255) DEFAULT NULL, `voucher_no` int(11) DEFAULT NULL, `trn_date` date DEFAULT NULL, `particulars` varchar(255) DEFAULT NULL, `debit` decimal(10,2) DEFAULT 0, `credit` decimal(10,2) DEFAULT 0, `created_at` date DEFAULT NULL, `created_by` varchar(50) DEFAULT NULL, `updated_at` date DEFAULT NULL, `updated_by` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`) ) $charset_collate;", ]; require_once ABSPATH . 'wp-admin/includes/upgrade.php'; dbDelta( $table );
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_people_trn_details`;
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