{"slug":"jetpack","name":"Jetpack – WP Security, Backup, Speed, & Growth","description":"Improve your WP security with powerful one-click tools like backup, WAF, and malware scan. Includes free tools like stats, CDN and social sharing.","author":"Automattic","active_installs":3000000,"version":"16.3.1","wp_org_url":"https://wordpress.org/plugins/jetpack/","is_closed":false,"cleanup":{"has_uninstall_hook":true,"drops_tables_on_uninstall":false,"deletes_options_on_uninstall":true},"tables":[{"table_name":"directory_entries","full_table_name":"wp_directory_entries","description":"Stores form submissions and user-entered data.","detection_method":"static","confidence":"high","columns":[{"name":"parent_path","type":"TEXT","nullable":true,"primary_key":false},{"name":"name","type":"TEXT","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS directory_entries ( parent_path TEXT, name TEXT, PRIMARY KEY (parent_path, name) );"},{"table_name":"files","full_table_name":"wp_files","description":"Stores files data created by this plugin.","detection_method":"static","confidence":"high","columns":[{"name":"path","type":"TEXT","nullable":true,"primary_key":true},{"name":"type","type":"TEXT","nullable":false,"primary_key":false},{"name":"contents","type":"BLOB","nullable":true,"primary_key":false}],"create_sql":"CREATE TABLE IF NOT EXISTS files ( path TEXT PRIMARY KEY, type TEXT NOT NULL, contents BLOB );"},{"table_name":"jetpack_waf_blocklog","full_table_name":"wp_jetpack_waf_blocklog","description":"Stores jetpack waf blocklog data created by this plugin.","detection_method":"static","confidence":"medium","columns":[{"name":"log_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"timestamp","type":"datetime","nullable":false,"primary_key":false},{"name":"rule_id","type":"BIGINT","nullable":false,"primary_key":false},{"name":"reason","type":"longtext","nullable":false,"primary_key":false}],"create_sql":"CREATE TABLE wp_jetpack_waf_blocklog ( log_id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, timestamp datetime NOT NULL, rule_id BIGINT NOT NULL, reason longtext NOT NULL, PRIMARY KEY (log_id), KEY timestamp (timestamp) ) \"; dbDelta( $sql );"},{"table_name":"woocommerce_order_items","full_table_name":"wp_woocommerce_order_items","description":"Stores order records and related transaction data.","detection_method":"static","confidence":"high","columns":[],"create_sql":null}],"table_count":4}