{"table_name":"cirm_site_crawl","full_table_name":"wp_cirm_site_crawl","description":"Stores cirm site crawl data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_cirm_site_crawl ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, crawl_id VARCHAR(40) NOT NULL DEFAULT '', url TEXT NOT NULL, source VARCHAR(40) NOT NULL DEFAULT 'manual', http_status INT NULL, final_url TEXT NULL, redirect_count INT NOT NULL DEFAULT 0, title_text TEXT NULL, title_length INT NOT NULL DEFAULT 0, meta_description TEXT NULL, meta_description_length INT NOT NULL DEFAULT 0, h1_count INT NOT NULL DEFAULT 0, h1_text TEXT NULL, canonical_url TEXT NULL, noindex TINYINT(1) NOT NULL DEFAULT 0, word_count INT NOT NULL DEFAULT 0, image_count INT NOT NULL DEFAULT 0, image_missing_alt INT NOT NULL DEFAULT 0, internal_links INT NOT NULL DEFAULT 0, external_links INT NOT NULL DEFAULT 0, issue_count INT NOT NULL DEFAULT 0, issues LONGTEXT NULL, checked_at DATETIME NOT NULL, PRIMARY KEY (id), KEY crawl_id (crawl_id), KEY http_status (http_status), KEY issue_count (issue_count), KEY checked_at (checked_at) ) {$charset};\");","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"crawl_id","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"url","type":"TEXT","nullable":false,"primary_key":false},{"name":"source","type":"VARCHAR(40)","nullable":false,"primary_key":false},{"name":"http_status","type":"INT","nullable":true,"primary_key":false},{"name":"final_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"redirect_count","type":"INT","nullable":false,"primary_key":false},{"name":"title_text","type":"TEXT","nullable":true,"primary_key":false},{"name":"title_length","type":"INT","nullable":false,"primary_key":false},{"name":"meta_description","type":"TEXT","nullable":true,"primary_key":false},{"name":"meta_description_length","type":"INT","nullable":false,"primary_key":false},{"name":"h1_count","type":"INT","nullable":false,"primary_key":false},{"name":"h1_text","type":"TEXT","nullable":true,"primary_key":false},{"name":"canonical_url","type":"TEXT","nullable":true,"primary_key":false},{"name":"noindex","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"word_count","type":"INT","nullable":false,"primary_key":false},{"name":"image_count","type":"INT","nullable":false,"primary_key":false},{"name":"image_missing_alt","type":"INT","nullable":false,"primary_key":false},{"name":"internal_links","type":"INT","nullable":false,"primary_key":false},{"name":"external_links","type":"INT","nullable":false,"primary_key":false},{"name":"issue_count","type":"INT","nullable":false,"primary_key":false},{"name":"issues","type":"LONGTEXT","nullable":true,"primary_key":false}],"plugin":{"slug":"linesw-search-rank-monitor","name":"LineSW Search Rank Monitor","active_installs":0,"version":"0.22.10","wp_org_url":"https://wordpress.org/plugins/linesw-search-rank-monitor/"}}