wp_crypto_payments
StaticStores crypto payments data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑paymentID | int(11) unsigned | NO |
| boxID | int(11) unsigned | NO |
| boxType | enum('paymentbox','captchabox') | NO |
| orderID | varchar(50) | NO |
| userID | varchar(50) | NO |
| countryID | varchar(3) | NO |
| coinLabel | varchar(6) | NO |
| amount | double(20,8) | NO |
| amountUSD | double(20,8) | NO |
| unrecognised | tinyint(1) unsigned | NO |
| addr | varchar(34) | NO |
| txID | char(64) | NO |
| txDate | datetime | YES |
| txConfirmed | tinyint(1) unsigned | NO |
| txCheckDate | datetime | YES |
| processed | tinyint(1) unsigned | NO |
| processedDate | datetime | YES |
| recordCreated | datetime | YES |
CREATE TABLE Statement
CREATE TABLE `crypto_payments` ( `paymentID` int(11) unsigned NOT NULL AUTO_INCREMENT, `boxID` int(11) unsigned NOT NULL DEFAULT '0', `boxType` enum('paymentbox','captchabox') NOT NULL, `orderID` varchar(50) NOT NULL DEFAULT '', `userID` varchar(50) NOT NULL DEFAULT '', `countryID` varchar(3) NOT NULL DEFAULT '', `coinLabel` varchar(6) NOT NULL DEFAULT '', `amount` double(20,8) NOT NULL DEFAULT '0.00000000', `amountUSD` double(20,8) NOT NULL DEFAULT '0.00000000', `unrecognised` tinyint(1) unsigned NOT NULL DEFAULT '0', `addr` varchar(34) NOT NULL DEFAULT '', `txID` char(64) NOT NULL DEFAULT '', `txDate` datetime DEFAULT NULL, `txConfirmed` tinyint(1) unsigned NOT NULL DEFAULT '0', `txCheckDate` datetime DEFAULT NULL, `processed` tinyint(1) unsigned NOT NULL DEFAULT '0', `processedDate` datetime DEFAULT NULL, `recordCreated` datetime DEFAULT NULL, PRIMARY KEY (`paymentID`), KEY `boxID` (`boxID`), KEY `boxType` (`boxType`), KEY `userID` (`userID`), KEY `countryID` (`countryID`), KEY `orderID` (`orderID`), KEY `amount` (`amount`), KEY `amountUSD` (`amountUSD`), KEY `coinLabel` (`coinLabel`), KEY `unrecognised` (`unrecognised`), KEY `addr` (`addr`), KEY `txID` (`txID`), KEY `txDate` (`txDate`), KEY `txConfirmed` (`txConfirmed`), KEY `txCheckDate` (`txCheckDate`), KEY `processed` (`processed`), KEY `processedDate` (`processedDate`), KEY `recordCreated` (`recordCreated`), KEY `key1` (`boxID`,`orderID`), KEY `key2` (`boxID`,`orderID`,`userID`), KEY `key3` (`boxID`,`orderID`,`userID`,`txID`) ) ENGINESafe to delete?
If you have uninstalled GoUrl Bitcoin Payment Gateway & Paid Downloads & Membership, 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_crypto_payments`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from GoUrl Bitcoin Payment Gateway & Paid Downloads & Membership