{"slug":"jetreader","name":"JetReader – Book Library, EPUB & PDF Reader (Lite)","description":"JetReader turns WordPress into a digital library with a fullscreen React document reader and advanced document management.","author":"mehdituran","active_installs":0,"version":"1.1.0","wp_org_url":"https://wordpress.org/plugins/jetreader/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":false},"tables":[{"table_name":"jetreader_authors","full_table_name":"wp_jetreader_authors","description":"Stores jetreader authors data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"jetreader_bookmarks","full_table_name":"wp_jetreader_bookmarks","description":"Stores jetreader bookmarks data created by this plugin.","detection_method":"static","confidence":"medium","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":"item_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"chapter_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"position","type":"LONGTEXT","nullable":false,"primary_key":false},{"name":"label","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"color","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"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"},{"table_name":"jetreader_categories","full_table_name":"wp_jetreader_categories","description":"Stores jetreader categories data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"description","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"parent_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"item_count","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_jetreader_categories ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(200) NOT NULL, slug VARCHAR(200) NOT NULL, description LONGTEXT DEFAULT NULL, parent_id BIGINT(20) UNSIGNED DEFAULT 0, item_count BIGINT(20) UNSIGNED DEFAULT 0, type VARCHAR(20) NOT NULL DEFAULT 'book', created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY slug_type (slug, type), KEY parent_id (parent_id), KEY type (type), KEY name (name(191)) ) ENGINE"},{"table_name":"jetreader_item_categories","full_table_name":"wp_jetreader_item_categories","description":"Stores jetreader item categories data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"item_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"category_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_jetreader_item_categories ( item_id BIGINT(20) UNSIGNED NOT NULL, category_id BIGINT(20) UNSIGNED NOT NULL, PRIMARY KEY (item_id, category_id), KEY category_id (category_id) ) ENGINE"},{"table_name":"jetreader_item_tags","full_table_name":"wp_jetreader_item_tags","description":"Stores jetreader item tags data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"item_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"tag_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_jetreader_item_tags ( item_id BIGINT(20) UNSIGNED NOT NULL, tag_id BIGINT(20) UNSIGNED NOT NULL, PRIMARY KEY (item_id, tag_id), KEY tag_id (tag_id) ) ENGINE"},{"table_name":"jetreader_items","full_table_name":"wp_jetreader_items","description":"Stores jetreader items data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"title","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(500)","nullable":false,"primary_key":false},{"name":"description","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"cover_image","type":"VARCHAR(1000)","nullable":true,"primary_key":false},{"name":"file_path","type":"VARCHAR(1000)","nullable":false,"primary_key":false},{"name":"file_type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"file_size","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"language","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"author","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"translator","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"publisher","type":"VARCHAR(500)","nullable":true,"primary_key":false},{"name":"isbn","type":"VARCHAR(50)","nullable":true,"primary_key":false},{"name":"publication_year","type":"INT(4) UNSIGNED","nullable":true,"primary_key":false},{"name":"page_count","type":"INT(10) UNSIGNED","nullable":true,"primary_key":false},{"name":"reading_time","type":"INT(10) UNSIGNED","nullable":true,"primary_key":false},{"name":"visibility","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"featured","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"view_count","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"read_count","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"metadata","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"volumes","type":"TEXT","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"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"},{"table_name":"jetreader_notes","full_table_name":"wp_jetreader_notes","description":"Stores jetreader notes data created by this plugin.","detection_method":"static","confidence":"medium","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":"item_id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":false},{"name":"chapter_id","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"type","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"content","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"quote","type":"TEXT","nullable":true,"primary_key":false},{"name":"position","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"color","type":"VARCHAR(20)","nullable":true,"primary_key":false},{"name":"is_public","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false},{"name":"updated_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"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"},{"table_name":"jetreader_publishers","full_table_name":"wp_jetreader_publishers","description":"Stores jetreader publishers data created by this plugin.","detection_method":"static","confidence":"high","columns":[],"create_sql":null},{"table_name":"jetreader_tags","full_table_name":"wp_jetreader_tags","description":"Stores jetreader tags data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"id","type":"BIGINT(20) UNSIGNED","nullable":false,"primary_key":true},{"name":"name","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"slug","type":"VARCHAR(200)","nullable":false,"primary_key":false},{"name":"description","type":"LONGTEXT","nullable":true,"primary_key":false},{"name":"item_count","type":"BIGINT(20) UNSIGNED","nullable":true,"primary_key":false},{"name":"created_at","type":"DATETIME","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS wp_jetreader_tags ( id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, name VARCHAR(200) NOT NULL, slug VARCHAR(200) NOT NULL, description LONGTEXT DEFAULT NULL, item_count BIGINT(20) UNSIGNED DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY slug (slug) ) ENGINE"},{"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","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}],"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"}],"table_count":10}