wp_jetreader_user_preferences
StaticStores jetreader user preferences data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT(20) UNSIGNED | NO |
| user_id | BIGINT(20) UNSIGNED | NO |
| font_size | VARCHAR(20) | YES |
| line_height | VARCHAR(20) | YES |
| font_family | VARCHAR(50) | YES |
| theme_mode | VARCHAR(20) | YES |
| reading_mode | VARCHAR(20) | YES |
| sidebar_state | VARCHAR(20) | YES |
| last_item_id | BIGINT(20) UNSIGNED | YES |
| last_position | LONGTEXT | YES |
| updated_at | DATETIME | NO |
CREATE TABLE Statement
CREATE TABLE IF NOT EXISTS wp_jetreader_user_preferences ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, user_id BIGINT(20) UNSIGNED NOT NULL, font_size VARCHAR(20) DEFAULT 'medium', line_height VARCHAR(20) DEFAULT 'medium', font_family VARCHAR(50) DEFAULT 'auto', theme_mode VARCHAR(20) DEFAULT 'auto', reading_mode VARCHAR(20) DEFAULT 'paginated', sidebar_state VARCHAR(20) DEFAULT 'open', last_item_id BIGINT(20) UNSIGNED DEFAULT NULL, last_position LONGTEXT DEFAULT NULL, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY user_id (user_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_user_preferences`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from JetReader – Book Library, EPUB & PDF Reader (Lite)