{"slug":"gourl-bitcoin-payment-gateway-paid-downloads-membership","name":"GoUrl Bitcoin Payment Gateway & Paid Downloads & Membership","description":"GoUrl Official Bitcoin/Altcoin Payment Gateway for Wordpress. Accept Bitcoin, Bitcoin Cash, Litecoin, Dash, Dogecoin, etc. Payments Online","author":"gourl","active_installs":800,"version":"1.6.6","wp_org_url":"https://wordpress.org/plugins/gourl-bitcoin-payment-gateway-paid-downloads-membership/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"crypto_files","full_table_name":"wp_crypto_files","description":"Stores crypto files data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"fileID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"fileTitle","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"fileName","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"fileUrl","type":"varchar(255)","nullable":false,"primary_key":false},{"name":"fileSize","type":"double(15,0)","nullable":false,"primary_key":false},{"name":"fileText","type":"text","nullable":true,"primary_key":false},{"name":"priceUSD","type":"double(10,2)","nullable":false,"primary_key":false},{"name":"priceCoin","type":"double(17,5)","nullable":false,"primary_key":false},{"name":"priceLabel","type":"varchar(6)","nullable":false,"primary_key":false},{"name":"purchases","type":"mediumint(8)","nullable":false,"primary_key":false},{"name":"userFormat","type":"enum('MANUAL','COOKIE','SESSION','IPADDRESS')","nullable":false,"primary_key":false},{"name":"expiryPeriod","type":"varchar(15)","nullable":false,"primary_key":false},{"name":"lang","type":"varchar(2)","nullable":false,"primary_key":false},{"name":"defCoin","type":"varchar(5)","nullable":false,"primary_key":false},{"name":"defShow","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"image","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"imageWidth","type":"smallint(5)","nullable":false,"primary_key":false},{"name":"priceShow","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"paymentCnt","type":"smallint(5)","nullable":false,"primary_key":false},{"name":"paymentTime","type":"datetime","nullable":true,"primary_key":false},{"name":"updatetime","type":"datetime","nullable":true,"primary_key":false},{"name":"createtime","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"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`) ) ENGINE"},{"table_name":"crypto_membership","full_table_name":"wp_crypto_membership","description":"Stores crypto membership data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"membID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"userID","type":"bigint(20) unsigned","nullable":false,"primary_key":false},{"name":"paymentID","type":"int(11) unsigned","nullable":false,"primary_key":false},{"name":"startDate","type":"datetime","nullable":true,"primary_key":false},{"name":"endDate","type":"datetime","nullable":true,"primary_key":false},{"name":"disabled","type":"tinyint(1) unsigned","nullable":false,"primary_key":false},{"name":"recordCreated","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE `crypto_membership` ( `membID` int(11) unsigned NOT NULL AUTO_INCREMENT, `userID` bigint(20) unsigned NOT NULL DEFAULT '0', `paymentID` int(11) unsigned NOT NULL DEFAULT '0', `startDate` datetime DEFAULT NULL, `endDate` datetime DEFAULT NULL, `disabled` tinyint(1) unsigned NOT NULL DEFAULT '0', `recordCreated` datetime DEFAULT NULL, PRIMARY KEY (`membID`), KEY `userID` (`userID`), KEY `paymentID` (`paymentID`), KEY `startDate` (`startDate`), KEY `endDate` (`endDate`), KEY `disabled` (`disabled`), KEY `recordCreated` (`recordCreated`) ) ENGINE"},{"table_name":"crypto_payments","full_table_name":"wp_crypto_payments","description":"Stores crypto payments data created by this plugin.","detection_method":"static","confidence":"high","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}],"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"},{"table_name":"crypto_products","full_table_name":"wp_crypto_products","description":"Stores product records and related data.","detection_method":"static","confidence":"high","columns":[{"name":"productID","type":"int(11) unsigned","nullable":false,"primary_key":true},{"name":"productTitle","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"active","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"priceUSD","type":"double(10,2)","nullable":false,"primary_key":false},{"name":"priceCoin","type":"double(17,5)","nullable":false,"primary_key":false},{"name":"priceLabel","type":"varchar(6)","nullable":false,"primary_key":false},{"name":"purchases","type":"mediumint(8)","nullable":false,"primary_key":false},{"name":"expiryPeriod","type":"varchar(15)","nullable":false,"primary_key":false},{"name":"lang","type":"varchar(2)","nullable":false,"primary_key":false},{"name":"defCoin","type":"varchar(5)","nullable":false,"primary_key":false},{"name":"defShow","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"productText","type":"text","nullable":true,"primary_key":false},{"name":"finalText","type":"text","nullable":true,"primary_key":false},{"name":"emailUser","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"emailUserFrom","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"emailUserTitle","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"emailUserBody","type":"text","nullable":true,"primary_key":false},{"name":"emailAdmin","type":"tinyint(1)","nullable":false,"primary_key":false},{"name":"emailAdminFrom","type":"varchar(50)","nullable":false,"primary_key":false},{"name":"emailAdminTo","type":"text","nullable":true,"primary_key":false},{"name":"emailAdminTitle","type":"varchar(100)","nullable":false,"primary_key":false},{"name":"emailAdminBody","type":"text","nullable":true,"primary_key":false},{"name":"paymentCnt","type":"smallint(5)","nullable":false,"primary_key":false},{"name":"paymentTime","type":"datetime","nullable":true,"primary_key":false},{"name":"updatetime","type":"datetime","nullable":true,"primary_key":false},{"name":"createtime","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"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"}],"table_count":4}