wp_crypto_products
StaticStores product records and related data.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑productID | int(11) unsigned | NO |
| productTitle | varchar(100) | NO |
| active | tinyint(1) | NO |
| priceUSD | double(10,2) | NO |
| priceCoin | double(17,5) | NO |
| priceLabel | varchar(6) | NO |
| purchases | mediumint(8) | NO |
| expiryPeriod | varchar(15) | NO |
| lang | varchar(2) | NO |
| defCoin | varchar(5) | NO |
| defShow | tinyint(1) | NO |
| productText | text | YES |
| finalText | text | YES |
| emailUser | tinyint(1) | NO |
| emailUserFrom | varchar(50) | NO |
| emailUserTitle | varchar(100) | NO |
| emailUserBody | text | YES |
| emailAdmin | tinyint(1) | NO |
| emailAdminFrom | varchar(50) | NO |
| emailAdminTo | text | YES |
| emailAdminTitle | varchar(100) | NO |
| emailAdminBody | text | YES |
| paymentCnt | smallint(5) | NO |
| paymentTime | datetime | YES |
| updatetime | datetime | YES |
| createtime | datetime | YES |
CREATE TABLE Statement
CREATE TABLE `crypto_products` ( `productID` int(11) unsigned NOT NULL AUTO_INCREMENT, `productTitle` varchar(100) NOT NULL DEFAULT '', `active` tinyint(1) NOT NULL DEFAULT '1', `priceUSD` double(10,2) NOT NULL DEFAULT '0.00', `priceCoin` double(17,5) NOT NULL DEFAULT '0.00000', `priceLabel` varchar(6) NOT NULL DEFAULT '', `purchases` mediumint(8) NOT NULL DEFAULT '0', `expiryPeriod` varchar(15) NOT NULL DEFAULT '', `lang` varchar(2) NOT NULL DEFAULT '', `defCoin` varchar(5) NOT NULL DEFAULT '', `defShow` tinyint(1) NOT NULL DEFAULT '1', `productText` text, `finalText` text, `emailUser` tinyint(1) NOT NULL DEFAULT '1', `emailUserFrom` varchar(50) NOT NULL DEFAULT '', `emailUserTitle` varchar(100) NOT NULL DEFAULT '', `emailUserBody` text, `emailAdmin` tinyint(1) NOT NULL DEFAULT '1', `emailAdminFrom` varchar(50) NOT NULL DEFAULT '', `emailAdminTo` text, `emailAdminTitle` varchar(100) NOT NULL DEFAULT '', `emailAdminBody` text, `paymentCnt` smallint(5) NOT NULL DEFAULT '0', `paymentTime` datetime DEFAULT NULL, `updatetime` datetime DEFAULT NULL, `createtime` datetime DEFAULT NULL, PRIMARY KEY (`productID`), KEY `productTitle` (`productTitle`), KEY `active` (`active`), KEY `priceUSD` (`priceUSD`), KEY `priceCoin` (`priceCoin`), KEY `priceLabel` (`priceLabel`), KEY `purchases` (`purchases`), KEY `expiryPeriod` (`expiryPeriod`), KEY `lang` (`lang`), KEY `defCoin` (`defCoin`), KEY `defShow` (`defShow`), KEY `emailUser` (`emailUser`), KEY `emailAdmin` (`emailAdmin`), KEY `paymentCnt` (`paymentCnt`), KEY `paymentTime` (`paymentTime`), KEY `updatetime` (`updatetime`), KEY `createtime` (`createtime`) ) ENGINE
Safe 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_products`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from GoUrl Bitcoin Payment Gateway & Paid Downloads & Membership