wp_cb_access
StaticStores cb access data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| customerId | BIGINT(20) | YES |
| productId | VARCHAR(255) | YES |
| receipt | VARCHAR(255) | YES |
| datePurchased | VARCHAR(255) | YES |
| access | TINYINT(1) | YES |
| recurring | TINYINT(1) | YES |
CREATE TABLE Statement
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
Safe to delete?
If you have uninstalled WP ClickBank Vendor, 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_cb_access`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from WP ClickBank Vendor