wp_jetreader_items
StaticStores jetreader items data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| type | VARCHAR(20) | NO |
| title | VARCHAR(500) | NO |
| slug | VARCHAR(500) | NO |
| description | LONGTEXT | YES |
| cover_image | VARCHAR(1000) | YES |
| file_path | VARCHAR(1000) | NO |
| file_type | VARCHAR(20) | NO |
| file_size | BIGINT(20) UNSIGNED | YES |
| language | VARCHAR(20) | YES |
| author | VARCHAR(500) | YES |
| translator | VARCHAR(500) | YES |
| publisher | VARCHAR(500) | YES |
| isbn | VARCHAR(50) | YES |
| publication_year | INT(4) UNSIGNED | YES |
| page_count | INT(10) UNSIGNED | YES |
| reading_time | INT(10) UNSIGNED | YES |
| visibility | VARCHAR(20) | NO |
| featured | TINYINT(1) | NO |
| view_count | BIGINT(20) UNSIGNED | YES |
| read_count | BIGINT(20) UNSIGNED | YES |
| metadata | LONGTEXT | YES |
| volumes | TEXT | YES |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_jetreader_items ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, type VARCHAR(20) NOT NULL DEFAULT 'book', title VARCHAR(500) NOT NULL, slug VARCHAR(500) NOT NULL, description LONGTEXT DEFAULT NULL, cover_image VARCHAR(1000) DEFAULT NULL, file_path VARCHAR(1000) NOT NULL, file_type VARCHAR(20) NOT NULL, file_size BIGINT(20) UNSIGNED DEFAULT 0, language VARCHAR(20) DEFAULT 'en', author VARCHAR(500) DEFAULT NULL, translator VARCHAR(500) DEFAULT NULL, publisher VARCHAR(500) DEFAULT NULL, isbn VARCHAR(50) DEFAULT NULL, publication_year INT(4) UNSIGNED DEFAULT NULL, page_count INT(10) UNSIGNED DEFAULT 0, reading_time INT(10) UNSIGNED DEFAULT 0, visibility VARCHAR(20) NOT NULL DEFAULT 'publish', featured TINYINT(1) NOT NULL DEFAULT 0, view_count BIGINT(20) UNSIGNED DEFAULT 0, read_count BIGINT(20) UNSIGNED DEFAULT 0, metadata LONGTEXT DEFAULT NULL, volumes TEXT DEFAULT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY slug (slug), KEY type (type), KEY author (author(191)), KEY language (language), KEY visibility (visibility), KEY featured (featured), KEY created_at (created_at), KEY visibility_type_created (visibility, type, created_at) ) ENGINE
Safe to delete?
If you have uninstalled JetReader – Book Library, EPUB & PDF Reader (Lite), 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_jetreader_items`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from JetReader – Book Library, EPUB & PDF Reader (Lite)