wp_crypto_files
StaticStores crypto files data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑fileID | int(11) unsigned | NO |
| fileTitle | varchar(100) | NO |
| active | tinyint(1) | NO |
| fileName | varchar(100) | NO |
| fileUrl | varchar(255) | NO |
| fileSize | double(15,0) | NO |
| fileText | text | YES |
| priceUSD | double(10,2) | NO |
| priceCoin | double(17,5) | NO |
| priceLabel | varchar(6) | NO |
| purchases | mediumint(8) | NO |
| userFormat | enum('MANUAL','COOKIE','SESSION','IPADDRESS') | NO |
| expiryPeriod | varchar(15) | NO |
| lang | varchar(2) | NO |
| defCoin | varchar(5) | NO |
| defShow | tinyint(1) | NO |
| image | varchar(100) | NO |
| imageWidth | smallint(5) | NO |
| priceShow | tinyint(1) | NO |
| paymentCnt | smallint(5) | NO |
| paymentTime | datetime | YES |
| updatetime | datetime | YES |
| createtime | datetime | YES |
CREATE TABLE Statement
CREATE TABLE `crypto_files` ( `fileID` int(11) unsigned NOT NULL AUTO_INCREMENT, `fileTitle` varchar(100) NOT NULL DEFAULT '', `active` tinyint(1) NOT NULL DEFAULT '1', `fileName` varchar(100) NOT NULL DEFAULT '', `fileUrl` varchar(255) NOT NULL DEFAULT '', `fileSize` double(15,0) NOT NULL DEFAULT '0', `fileText` text, `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', `userFormat` enum('MANUAL','COOKIE','SESSION','IPADDRESS') NOT NULL, `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', `image` varchar(100) NOT NULL DEFAULT '', `imageWidth` smallint(5) NOT NULL DEFAULT '0', `priceShow` tinyint(1) NOT NULL DEFAULT '1', `paymentCnt` smallint(5) NOT NULL DEFAULT '0', `paymentTime` datetime DEFAULT NULL, `updatetime` datetime DEFAULT NULL, `createtime` datetime DEFAULT NULL, PRIMARY KEY (`fileID`), KEY `fileTitle` (`fileTitle`), KEY `active` (`active`), KEY `fileName` (`fileName`), KEY `fileUrl` (`fileUrl`), KEY `fileSize` (`fileSize`), KEY `priceUSD` (`priceUSD`), KEY `priceCoin` (`priceCoin`), KEY `priceLabel` (`priceLabel`), KEY `purchases` (`purchases`), KEY `userFormat` (`userFormat`), KEY `expiryPeriod` (`expiryPeriod`), KEY `lang` (`lang`), KEY `defCoin` (`defCoin`), KEY `defShow` (`defShow`), KEY `image` (`image`), KEY `imageWidth` (`imageWidth`), KEY `priceShow` (`priceShow`), KEY `paymentCnt` (`paymentCnt`), KEY `paymentTime` (`paymentTime`), KEY `updatetime` (`updatetime`), KEY `createtime` (`createtime`) ) 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_files`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from GoUrl Bitcoin Payment Gateway & Paid Downloads & Membership