wp_jetreader_bookmarks
StaticStores jetreader bookmarks data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| user_id | BIGINT(20) UNSIGNED | NO |
| item_id | BIGINT(20) UNSIGNED | NO |
| chapter_id | BIGINT(20) UNSIGNED | YES |
| position | LONGTEXT | NO |
| label | VARCHAR(500) | YES |
| color | VARCHAR(20) | YES |
| created_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_jetreader_bookmarks ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, item_id BIGINT(20) UNSIGNED NOT NULL, chapter_id BIGINT(20) UNSIGNED DEFAULT NULL, position LONGTEXT NOT NULL, label VARCHAR(500) DEFAULT NULL, color VARCHAR(20) DEFAULT '#FFD700', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY item_id (item_id), KEY user_item (user_id, item_id) ) 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_bookmarks`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from JetReader – Book Library, EPUB & PDF Reader (Lite)