{"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":"15.7.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":"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":2}