{"slug":"wp-clickbank-vendor","name":"WP ClickBank Vendor","description":"Start selling your digital content, ebooks and software via ClickBank in minutes. WP ClickBank Vendor enables you to accept payments within minutes.","author":"Arevico","active_installs":10,"version":"0.9.1","wp_org_url":"https://wordpress.org/plugins/wp-clickbank-vendor/","is_closed":false,"cleanup":{"has_uninstall_hook":false,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":false},"tables":[{"table_name":"cb_access","full_table_name":"wp_cb_access","description":"Stores cb access data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"customerId","type":"BIGINT(20)","nullable":true,"primary_key":false},{"name":"productId","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"receipt","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"datePurchased","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"access","type":"TINYINT(1)","nullable":true,"primary_key":false},{"name":"recurring","type":"TINYINT(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `cb_access` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `customerId` BIGINT(20) NULL, `productId` VARCHAR(255) NULL, `receipt` VARCHAR(255) NULL, `datePurchased` VARCHAR(255) NULL, `access` TINYINT(1) NULL DEFAULT 1, `recurring` TINYINT(1) NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `arv_cb_access_uq` (`productId` ASC, `receipt` ASC)) ENGINE"},{"table_name":"cb_customers","full_table_name":"wp_cb_customers","description":"Stores cb customers data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"fullName","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"firstName","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"lastName","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"email","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"password","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"registered","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"isTest","type":"TINYINT(1)","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `cb_customers` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `fullName` VARCHAR(255) NULL, `firstName` VARCHAR(255) NULL, `lastName` VARCHAR(255) NULL, `email` VARCHAR(255) NULL, `password` VARCHAR(255) NULL, `registered` VARCHAR(20) NULL DEFAULT '', `isTest` TINYINT(1) NULL DEFAULT 0, PRIMARY KEY (`id`), UNIQUE KEY `arv_cb_customers_uq` (`email` ASC)) ENGINE"},{"table_name":"cb_transactions","full_table_name":"wp_cb_transactions","description":"Stores cb transactions data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"customerId","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"transactionTime","type":"TEXT","nullable":true,"primary_key":false},{"name":"receipt","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"transactionType","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"currency","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"totalOrderAmount","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"totalTaxAmount","type":"VARCHAR(255)","nullable":true,"primary_key":false},{"name":"transaction","type":"MEDIUMBLOB","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS `cb_transactions` ( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `customerId` BIGINT(20) UNSIGNED NOT NULL, `transactionTime` TEXT NULL, `receipt` VARCHAR(255) NULL , `transactionType` VARCHAR(255) NULL , `currency` VARCHAR(255) NULL, `totalOrderAmount` VARCHAR(255) NULL, `totalTaxAmount` VARCHAR(255) NULL, `transaction` MEDIUMBLOB NULL, PRIMARY KEY (`id`), UNIQUE KEY `arv_cb_customers_uq` (`customerId`, `receipt` ASC)) ENGINE"}],"table_count":3}