wp_arcadrec_users
StaticStores arcadrec users data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| arcadrec_id | BIGINT UNSIGNED | NO |
| amazon_user_id | VARCHAR(255) | NO |
| amazon_display_name | VARCHAR(255) | NO |
| first_name | VARCHAR(100) | NO |
| last_name | VARCHAR(100) | NO |
| VARCHAR(255) | NO | |
| reviewer_url | VARCHAR(512) | NO |
| answers | JSON | YES |
| download_token | VARCHAR(64) | NO |
| download_count | INT UNSIGNED | NO |
| pdf_downloaded_at | DATETIME | YES |
| epub_downloaded_at | DATETIME | YES |
| banned | TINYINT(1) | NO |
| ban_reason | TEXT | YES |
| paused | TINYINT(1) | NO |
| flags | JSON | YES |
| review_confirmed | TINYINT(1) | NO |
| review_confirmed_at | DATETIME | YES |
| thankyou_sent | TINYINT(1) | NO |
| reminder_count | INT UNSIGNED | NO |
| reminder_token | VARCHAR(64) | NO |
| is_imported | TINYINT(1) | NO |
| street_team_categories | JSON | YES |
| wp_user_id | BIGINT UNSIGNED | YES |
| signed_up_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_arcadrec_users ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, arcadrec_id BIGINT UNSIGNED NOT NULL, amazon_user_id VARCHAR(255) NOT NULL DEFAULT '', amazon_display_name VARCHAR(255) NOT NULL DEFAULT '', first_name VARCHAR(100) NOT NULL DEFAULT '', last_name VARCHAR(100) NOT NULL DEFAULT '', email VARCHAR(255) NOT NULL DEFAULT '', reviewer_url VARCHAR(512) NOT NULL DEFAULT '', answers JSON DEFAULT NULL, download_token VARCHAR(64) NOT NULL DEFAULT '', download_count INT UNSIGNED NOT NULL DEFAULT 0, pdf_downloaded_at DATETIME DEFAULT NULL, epub_downloaded_at DATETIME DEFAULT NULL, banned TINYINT(1) NOT NULL DEFAULT 0, ban_reason TEXT DEFAULT NULL, paused TINYINT(1) NOT NULL DEFAULT 0, flags JSON DEFAULT NULL, review_confirmed TINYINT(1) NOT NULL DEFAULT 0, review_confirmed_at DATETIME DEFAULT NULL, thankyou_sent TINYINT(1) NOT NULL DEFAULT 0, reminder_count INT UNSIGNED NOT NULL DEFAULT 0, reminder_token VARCHAR(64) NOT NULL DEFAULT '', is_imported TINYINT(1) NOT NULL DEFAULT 0, street_team_categories JSON DEFAULT NULL, wp_user_id BIGINT UNSIGNED DEFAULT NULL, signed_up_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY token (download_token), KEY arcadrec_amazon (arcadrec_id, amazon_user_id) ) $c;" );
Safe to delete?
If you have uninstalled ARC — Advance Review Copy, 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_arcadrec_users`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ARC — Advance Review Copy