{"table_name":"awb_broken_links","full_table_name":"wp_awb_broken_links","description":"Stores awb broken links data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE IF NOT EXISTS wp_awb_broken_links ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT UNSIGNED NOT NULL, url VARCHAR(2048) NOT NULL, status_code SMALLINT NOT NULL DEFAULT 0, fix_status VARCHAR(20) NOT NULL DEFAULT 'not_fixed', last_checked DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (id), KEY post_id (post_id) ) {$charset};\" );","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":false},{"name":"url","type":"VARCHAR(2048)","nullable":false,"primary_key":false},{"name":"status_code","type":"SMALLINT","nullable":false,"primary_key":false},{"name":"fix_status","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"last_checked","type":"DATETIME","nullable":false,"primary_key":false}],"plugin":{"slug":"adworksbid-seo","name":"CitedSEO","active_installs":10,"version":"1.4.3","wp_org_url":"https://wordpress.org/plugins/adworksbid-seo/"}}