wp_arcadrec_books
StaticStores arcadrec books data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| title | VARCHAR(255) | NO |
| description | LONGTEXT | NO |
| release_date | DATE | YES |
| page_id | BIGINT UNSIGNED | YES |
| pdf_path | VARCHAR(512) | NO |
| epub_path | VARCHAR(512) | NO |
| questions | JSON | YES |
| min_ratio | DECIMAL(4,3) | NO |
| from_name | VARCHAR(255) | NO |
| from_email | VARCHAR(255) | NO |
| published | TINYINT(1) | NO |
| release_sent | TINYINT(1) | NO |
| amazon_url | TEXT | NO |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_arcadrec_books ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, title VARCHAR(255) NOT NULL DEFAULT '', description LONGTEXT NOT NULL DEFAULT '', release_date DATE DEFAULT NULL, page_id BIGINT UNSIGNED DEFAULT NULL, pdf_path VARCHAR(512) NOT NULL DEFAULT '', epub_path VARCHAR(512) NOT NULL DEFAULT '', questions JSON DEFAULT NULL, min_ratio DECIMAL(4,3) NOT NULL DEFAULT 0, from_name VARCHAR(255) NOT NULL DEFAULT '', from_email VARCHAR(255) NOT NULL DEFAULT '', published TINYINT(1) NOT NULL DEFAULT 0, release_sent TINYINT(1) NOT NULL DEFAULT 0, amazon_url TEXT NOT NULL DEFAULT '', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (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_books`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from ARC — Advance Review Copy