wp_enkap_payments
StaticStores enkap payments data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int unsigned | NO |
| currency | varchar(5) | YES |
| country_code | varchar(3) | YES |
| customer_name | varchar(200) | YES |
| description | varchar(200) | YES |
| varchar(128) | YES | |
| client_ip | varbinary(64) | NO |
| user_id | int | NO |
| items | json | YES |
| merchant_reference_id | char(36) | NO |
| order_transaction_id | varchar(128) | YES |
| opt_ref_one | text | YES |
| opt_ref_two | text | YES |
| expiry_date | datetime | NO |
| order_date | datetime | NO |
| phone_number | int | NO |
| total_amount | decimal(32, 2) | YES |
| status | varchar(50) | YES |
| status_date | datetime | NO |
| created_at | timestamp | NO |
| updated_at | timestamp | NO |
CREATE TABLE Statement
CREATE TABLE `enkap_payments` ( id int unsigned NOT NULL AUTO_INCREMENT, currency varchar(5) default 'XAF', country_code varchar(3) default 'CM', customer_name varchar(200) DEFAULT NULL, description varchar(200) DEFAULT NULL, email varchar(128) DEFAULT NULL, client_ip varbinary(64) NOT NULL DEFAULT '0.0.0.0', user_id int NOT NULL DEFAULT '0', items json, merchant_reference_id char(36) NOT NULL DEFAULT '', order_transaction_id varchar(128) DEFAULT NULL, opt_ref_one text, opt_ref_two text, expiry_date datetime NOT NULL DEFAULT '2021-05-20 00:00:00', order_date datetime NOT NULL DEFAULT '2021-05-20 00:00:00', phone_number int NOT NULL DEFAULT '0', total_amount decimal(32, 2) DEFAULT '0.00', status varchar(50) DEFAULT NULL, status_date datetime NOT NULL DEFAULT '2021-05-20 00:00:00', created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY index_user_id (user_id), UNIQUE KEY index_merchant_reference_id (merchant_reference_id), UNIQUE KEY index_order_transaction_id (order_transaction_id) ) ENGINE
Safe to delete?
If you have uninstalled SmobilPay for e-commerce – Mobile Money Gateway for WooCommerce, 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_enkap_payments`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from SmobilPay for e-commerce – Mobile Money Gateway for WooCommerce