{"table_name":"fictbase_chapter_views","full_table_name":"wp_fictbase_chapter_views","description":"Stores fictbase chapter views data created by this plugin.","detection_method":"static","confidence":"medium","create_sql":"CREATE TABLE wp_fictbase_chapter_views ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, chapter_id BIGINT UNSIGNED NOT NULL, ip_hash VARCHAR(64) DEFAULT NULL, wp_user_id BIGINT UNSIGNED DEFAULT NULL, viewed_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY chapter_id (chapter_id) ) $charset;\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"chapter_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"ip_hash","type":"VARCHAR(64)","nullable":true,"primary_key":false},{"name":"wp_user_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"viewed_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/"}}