{"table_name":"fictbase_bookmarks","full_table_name":"wp_fictbase_bookmarks","description":"Stores fictbase bookmarks data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_fictbase_bookmarks ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, wp_user_id BIGINT UNSIGNED NOT NULL, story_id BIGINT UNSIGNED NOT NULL, chapter_id BIGINT UNSIGNED NOT NULL, scroll_position TINYINT UNSIGNED NOT NULL DEFAULT 0, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY user_story (wp_user_id, story_id), KEY chapter_id (chapter_id) ) $charset;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"wp_user_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"story_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"chapter_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"scroll_position","type":"TINYINT UNSIGNED","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}],"plugin":{"slug":"fictbase","name":"FICTBASE","active_installs":0,"version":"2.2.13","wp_org_url":"https://wordpress.org/plugins/fictbase/"}}