wp_skrill_transaction_log
StaticA logging table that records activity, events, or audit history.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | int(20) unsigned | NO |
| order_id | bigint(20) unsigned | NO |
| transaction_id | varchar(100) | YES |
| mb_transaction_id | varchar(50) | NO |
| payment_method_id | varchar(30) | YES |
| payment_type | varchar(16) | NO |
| payment_status | varchar(30) | YES |
| amount | decimal(17,2) | NO |
| refunded_amount | decimal(17,2) | YES |
| currency | char(3) | NO |
| customer_id | int(11) unsigned | YES |
| date | datetime | NO |
| additional_information | LONGTEXT | YES |
| payment_response | LONGTEXT | YES |
| active | tinyint(1) unsigned | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_skrill_transaction_log ( `id` int(20) unsigned NOT NULL AUTO_INCREMENT, `order_id` bigint(20) unsigned NOT NULL, `transaction_id` varchar(100), `mb_transaction_id` varchar(50) NOT NULL, `payment_method_id` varchar(30), `payment_type` varchar(16) NOT NULL, `payment_status` varchar(30), `amount` decimal(17,2) NOT NULL, `refunded_amount` decimal(17,2) DEFAULT '0', `currency` char(3) NOT NULL, `customer_id` int(11) unsigned DEFAULT NULL, `date` datetime NOT NULL, `additional_information` LONGTEXT NULL, `payment_response` LONGTEXT NULL, `active` tinyint(1) unsigned NOT NULL DEFAULT '1', PRIMARY KEY (`id`) ) $charset_collate;"; dbDelta( $transaction_sql );
Safe to delete?
If you have uninstalled Skrill – 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_skrill_transaction_log`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.