wp_jetreader_notes
StaticStores jetreader notes 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 |
| type | VARCHAR(20) | NO |
| content | LONGTEXT | YES |
| quote | TEXT | YES |
| position | LONGTEXT | YES |
| color | VARCHAR(20) | YES |
| is_public | TINYINT(1) | NO |
| created_at | DATETIME | NO |
| updated_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_jetreader_notes ( 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, type VARCHAR(20) NOT NULL DEFAULT 'note', content LONGTEXT DEFAULT NULL, quote TEXT DEFAULT NULL, position LONGTEXT DEFAULT NULL, color VARCHAR(20) DEFAULT '#FFFF00', is_public TINYINT(1) NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY user_id (user_id), KEY item_id (item_id), KEY type (type), 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_notes`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from JetReader – Book Library, EPUB & PDF Reader (Lite)