{"table_name":"jetreader_user_preferences","full_table_name":"wp_jetreader_user_preferences","description":"Stores jetreader user preferences data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"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","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"user_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"font_size","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"line_height","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"font_family","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"theme_mode","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"reading_mode","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"sidebar_state","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"last_item_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"last_position","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"jetreader","name":"JetReader – Book Library, EPUB & PDF Reader (Lite)","active_installs":0,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/jetreader/"}}