wp_crpay_transactions
StaticStores crpay transactions data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | INT | NO |
| from | VARCHAR(191) | NO |
| to | VARCHAR(191) | YES |
| hash | VARCHAR(191) | NO |
| title | VARCHAR(500) | NO |
| description | VARCHAR(1000) | NO |
| amount | VARCHAR(100) | NO |
| amount_fiat | VARCHAR(100) | NO |
| cryptocurrency | VARCHAR(10) | NO |
| currency | VARCHAR(10) | NO |
| external_reference | VARCHAR(1000) | NO |
| creation_time | DATETIME | NO |
| status | VARCHAR(1) | NO |
| webhook | TINYINT | NO |
| billing | TINYTEXT | YES |
| vat | FLOAT | YES |
| vat_details | TINYTEXT | YES |
| type | TINYINT | YES |
| FOREIGN | KEY | YES |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS crpay_transactions (id INT NOT NULL AUTO_INCREMENT, `from` VARCHAR(191) NOT NULL DEFAULT "", `to` VARCHAR(191), hash VARCHAR(191) NOT NULL DEFAULT "", `title` VARCHAR(500) NOT NULL DEFAULT "", description VARCHAR(1000) NOT NULL DEFAULT "", amount VARCHAR(100) NOT NULL, amount_fiat VARCHAR(100) NOT NULL, cryptocurrency VARCHAR(10) NOT NULL, currency VARCHAR(10) NOT NULL, external_reference VARCHAR(1000) NOT NULL DEFAULT "", creation_time DATETIME NOT NULL, status VARCHAR(1) NOT NULL, webhook TINYINT NOT NULL, billing TINYTEXT, vat FLOAT, vat_details TINYTEXT, checkout_id INT, type TINYINT, PRIMARY KEY (id), FOREIGN KEY (checkout_id) REFERENCES crpay_checkouts(id) ON DELETE CASCADE) ENGINE
Safe to delete?
If you have uninstalled CryptoPayment Gateway, 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_crpay_transactions`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from CryptoPayment Gateway