{"slug":"cryptopayment-gateway","name":"CryptoPayment Gateway","description":"CryptoPay enables virtual currency payments in WooCommerce via P2P, supporting Bitcoin, ETH, SOL, USDT, USDC, and more.","author":"granwill","active_installs":0,"version":"1.2.2","wp_org_url":"https://wordpress.org/plugins/cryptopayment-gateway/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"crpay_checkouts","full_table_name":"wp_crpay_checkouts","description":"Stores crpay checkouts data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"title","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"description","type":"TEXT","nullable":true,"primary_key":false},{"name":"price","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"type","type":"VARCHAR(1)","nullable":true,"primary_key":false},{"name":"redirect","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"hide_title","type":"TINYINT","nullable":true,"primary_key":false},{"name":"external_reference","type":"VARCHAR(1000)","nullable":false,"primary_key":false},{"name":"creation_time","type":"DATETIME","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(191)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS crpay_checkouts (id INT NOT NULL AUTO_INCREMENT, title VARCHAR(191), description TEXT, price VARCHAR(100) NOT NULL, currency VARCHAR(10) NOT NULL, type VARCHAR(1), redirect VARCHAR(191), hide_title TINYINT, external_reference VARCHAR(1000) NOT NULL DEFAULT \"\", creation_time DATETIME NOT NULL, slug VARCHAR(191), PRIMARY KEY (id)) ENGINE"},{"table_name":"crpay_customers","full_table_name":"wp_crpay_customers","description":"Stores crpay customers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"first_name","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"last_name","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"email","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"phone","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"country","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"country_code","type":"VARCHAR(3)","nullable":false,"primary_key":false},{"name":"creation_time","type":"DATETIME","nullable":false,"primary_key":false},{"name":"extra","type":"TINYTEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS crpay_customers (id INT NOT NULL AUTO_INCREMENT, first_name VARCHAR(191) NOT NULL DEFAULT \"\", last_name VARCHAR(191) NOT NULL DEFAULT \"\", email VARCHAR(191), phone VARCHAR(191) NOT NULL DEFAULT \"\", country VARCHAR(191) NOT NULL DEFAULT \"\", country_code VARCHAR(3) NOT NULL DEFAULT \"\", creation_time DATETIME NOT NULL, extra TINYTEXT, PRIMARY KEY (id), UNIQUE (email)) ENGINE"},{"table_name":"crpay_settings","full_table_name":"wp_crpay_settings","description":"Stores crpay settings data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"name","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"value","type":"LONGTEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS crpay_settings (name VARCHAR(191) NOT NULL, value LONGTEXT, PRIMARY KEY (name)) ENGINE"},{"table_name":"crpay_transactions","full_table_name":"wp_crpay_transactions","description":"Stores crpay transactions data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"INT","nullable":false,"primary_key":true},{"name":"from","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"to","type":"VARCHAR(191)","nullable":true,"primary_key":false},{"name":"hash","type":"VARCHAR(191)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"description","type":"VARCHAR(1000)","nullable":false,"primary_key":false},{"name":"amount","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"amount_fiat","type":"VARCHAR(100)","nullable":false,"primary_key":false},{"name":"cryptocurrency","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"currency","type":"VARCHAR(10)","nullable":false,"primary_key":false},{"name":"external_reference","type":"VARCHAR(1000)","nullable":false,"primary_key":false},{"name":"creation_time","type":"DATETIME","nullable":false,"primary_key":false},{"name":"status","type":"VARCHAR(1)","nullable":false,"primary_key":false},{"name":"webhook","type":"TINYINT","nullable":false,"primary_key":false},{"name":"billing","type":"TINYTEXT","nullable":true,"primary_key":false},{"name":"vat","type":"FLOAT","nullable":true,"primary_key":false},{"name":"vat_details","type":"TINYTEXT","nullable":true,"primary_key":false},{"name":"type","type":"TINYINT","nullable":true,"primary_key":false},{"name":"FOREIGN","type":"KEY","nullable":true,"primary_key":false}],"create_sql":"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"}],"table_count":4}