{"slug":"yasakani-cache","name":"Yasakani Cache","description":"Simple ! Easy !! Ultra-high-speed !!!. Definitive edition of the page cache. And Bot and Security Utility.","author":"enomoto celtislab","active_installs":10,"version":"3.9.8","wp_org_url":"https://wordpress.org/plugins/yasakani-cache/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":true,"deletes_options_on_uninstall":true},"tables":[{"table_name":"bot","full_table_name":"wp_bot","description":"Stores bot data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"bip","type":"text","nullable":false,"primary_key":false},{"name":"user_agent","type":"text","nullable":true,"primary_key":false},{"name":"count","type":"int","nullable":false,"primary_key":false},{"name":"count_404","type":"int","nullable":false,"primary_key":false},{"name":"count_restrict","type":"int","nullable":false,"primary_key":false},{"name":"count_login","type":"int","nullable":false,"primary_key":false},{"name":"date_404","type":"datetime","nullable":true,"primary_key":false},{"name":"date_restrict","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE bot ( bip text UNIQUE DEFAULT '' NOT NULL, user_agent text, count int DEFAULT 0 NOT NULL, count_404 int DEFAULT 0 NOT NULL, count_restrict int DEFAULT 0 NOT NULL, count_login int DEFAULT 0 NOT NULL, date_404 datetime, date_restrict datetime );"},{"table_name":"content","full_table_name":"wp_content","description":"Stores content data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"req_url","type":"text","nullable":false,"primary_key":false},{"name":"blogid","type":"int","nullable":false,"primary_key":false},{"name":"postid","type":"int","nullable":false,"primary_key":false},{"name":"title","type":"text","nullable":true,"primary_key":false},{"name":"mobile","type":"BLOB","nullable":true,"primary_key":false},{"name":"desktop","type":"BLOB","nullable":true,"primary_key":false},{"name":"m_header","type":"text","nullable":true,"primary_key":false},{"name":"d_header","type":"text","nullable":true,"primary_key":false},{"name":"m_modified","type":"text","nullable":true,"primary_key":false},{"name":"d_modified","type":"text","nullable":true,"primary_key":false},{"name":"m_expire","type":"datetime","nullable":true,"primary_key":false},{"name":"d_expire","type":"datetime","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE content ( key text UNIQUE NOT NULL, req_url text NOT NULL, blogid int NOT NULL, postid int NOT NULL, title text, mobile BLOB, desktop BLOB, m_header text, d_header text, m_modified text, d_modified text, m_expire datetime, d_expire datetime );"},{"table_name":"laststat","full_table_name":"wp_laststat","description":"Stores laststat data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"data","type":"text","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE laststat (data text DEFAULT '' NOT NULL);"},{"table_name":"log","full_table_name":"wp_log","description":"Stores log data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"date","type":"datetime","nullable":true,"primary_key":false},{"name":"response","type":"real","nullable":true,"primary_key":false},{"name":"type","type":"text","nullable":true,"primary_key":false},{"name":"req_url","type":"text","nullable":true,"primary_key":false},{"name":"method","type":"text","nullable":true,"primary_key":false},{"name":"req_data","type":"text","nullable":true,"primary_key":false},{"name":"blogid","type":"int","nullable":false,"primary_key":false},{"name":"postid","type":"int","nullable":false,"primary_key":false},{"name":"host","type":"text","nullable":true,"primary_key":false},{"name":"path","type":"text","nullable":true,"primary_key":false},{"name":"query","type":"text","nullable":true,"primary_key":false},{"name":"title","type":"text","nullable":true,"primary_key":false},{"name":"user_agent","type":"text","nullable":true,"primary_key":false},{"name":"referer","type":"text","nullable":true,"primary_key":false},{"name":"ip","type":"text","nullable":true,"primary_key":false},{"name":"error","type":"text","nullable":true,"primary_key":false},{"name":"login","type":"int","nullable":false,"primary_key":false},{"name":"bot","type":"int","nullable":false,"primary_key":false},{"name":"is_mobile","type":"int","nullable":false,"primary_key":false},{"name":"tag","type":"text","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE log ( date datetime, response real, type text, req_url text, method text, req_data text, blogid int NOT NULL, postid int NOT NULL, host text, path text, query text, title text, user_agent text, referer text, ip text, error text, login int NOT NULL, bot int NOT NULL, is_mobile int DEFAULT 0 NOT NULL, tag text DEFAULT '' NOT NULL );"},{"table_name":"logged_key","full_table_name":"wp_logged_key","description":"Stores logged key data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"sitekey","type":"text","nullable":false,"primary_key":false},{"name":"userkey","type":"text","nullable":false,"primary_key":false},{"name":"role","type":"text","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE logged_key ( sitekey text '' NOT NULL, userkey text '' NOT NULL, role text DEFAULT '' NOT NULL );"},{"table_name":"setting","full_table_name":"wp_setting","description":"Stores setting data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"format","type":"text","nullable":false,"primary_key":false},{"name":"maintenance","type":"datetime","nullable":true,"primary_key":false},{"name":"log_mode","type":"int","nullable":true,"primary_key":false},{"name":"timezone","type":"text","nullable":false,"primary_key":false},{"name":"log_backup","type":"date","nullable":false,"primary_key":false},{"name":"bot_key","type":"text","nullable":false,"primary_key":false},{"name":"loginblock","type":"int","nullable":true,"primary_key":false},{"name":"block_user","type":"text","nullable":false,"primary_key":false},{"name":"autoblock","type":"int","nullable":true,"primary_key":false},{"name":"autoblocklist","type":"text","nullable":false,"primary_key":false},{"name":"botblocklist","type":"text","nullable":false,"primary_key":false},{"name":"botwhitelist","type":"text","nullable":false,"primary_key":false},{"name":"sitekey","type":"text","nullable":false,"primary_key":false},{"name":"zerodayblock","type":"int","nullable":true,"primary_key":false},{"name":"trustedfile","type":"text","nullable":false,"primary_key":false},{"name":"siteurlprotect","type":"int","nullable":true,"primary_key":false},{"name":"protectlist","type":"text","nullable":false,"primary_key":false},{"name":"notice","type":"text","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE setting ( format text DEFAULT '0' NOT NULL, maintenance datetime, log_mode int DEFAULT 0 NULL, timezone text DEFAULT 'utc' NOT NULL, log_backup date DEFAULT '0000-00-00' NOT NULL, bot_key text DEFAULT '' NOT NULL, loginblock int DEFAULT 0 NULL, block_user text DEFAULT '' NOT NULL, autoblock int DEFAULT 0 NULL, autoblocklist text DEFAULT '' NOT NULL, botblocklist text DEFAULT '' NOT NULL, botwhitelist text DEFAULT '' NOT NULL, sitekey text DEFAULT '' NOT NULL, zerodayblock int DEFAULT 0 NULL, trustedfile text DEFAULT '' NOT NULL, siteurlprotect int DEFAULT 0 NULL, protectlist text DEFAULT '' NOT NULL, notice text DEFAULT '' NOT NULL );"}],"table_count":6}