{"table_name":"jetreader_categories","full_table_name":"wp_jetreader_categories","description":"Stores jetreader categories data created by this plugin.","detection_method":"static","confidence":"high","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","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}],"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/"}}