{"table_name":"crypto_payments","full_table_name":"wp_crypto_payments","description":"Stores crypto payments data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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`) ) ENGINE","columns":[{"name":"paymentID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"boxID","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"boxType","type":"enum('paymentbox','captchabox')","nullable":false,"primary_key":false},{"name":"orderID","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"userID","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"countryID","type":"varchar(3)","nullable":false,"primary_key":false},{"name":"coinLabel","type":"varchar(6)","nullable":false,"primary_key":false},{"name":"amount","type":"double(20,8)","nullable":false,"primary_key":false},{"name":"amountUSD","type":"double(20,8)","nullable":false,"primary_key":false},{"name":"unrecognised","type":"tinyint(1) unsigned","nullable":false,"primary_key":false},{"name":"addr","type":"varchar(34)","nullable":false,"primary_key":false},{"name":"txID","type":"char(64)","nullable":false,"primary_key":false},{"name":"txDate","type":"datetime","nullable":true,"primary_key":false},{"name":"txConfirmed","type":"tinyint(1) unsigned","nullable":false,"primary_key":false},{"name":"txCheckDate","type":"datetime","nullable":true,"primary_key":false},{"name":"processed","type":"tinyint(1) unsigned","nullable":false,"primary_key":false},{"name":"processedDate","type":"datetime","nullable":true,"primary_key":false},{"name":"recordCreated","type":"datetime","nullable":true,"primary_key":false}],"plugin":{"slug":"gourl-bitcoin-payment-gateway-paid-downloads-membership","name":"GoUrl Bitcoin Payment Gateway & Paid Downloads & Membership","active_installs":800,"version":"1.6.6","wp_org_url":"https://wordpress.org/plugins/gourl-bitcoin-payment-gateway-paid-downloads-membership/"}}