{"table_name":"cirm_seo_audits","full_table_name":"wp_cirm_seo_audits","description":"Stores cirm seo audits data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"CREATE TABLE wp_cirm_seo_audits ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, post_id BIGINT UNSIGNED NULL, url TEXT NOT NULL, title_text TEXT NULL, meta_description TEXT NULL, h1_count INT NOT NULL DEFAULT 0, word_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, schema_found TINYINT(1) NOT NULL DEFAULT 0, score INT NOT NULL DEFAULT 0, findings LONGTEXT NULL, checked_at DATETIME NOT NULL, PRIMARY KEY (id), KEY post_id (post_id), KEY checked_at (checked_at) ) {$charset};\");","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"post_id","type":"BIGINT UNSIGNED","nullable":true,"primary_key":false},{"name":"url","type":"TEXT","nullable":false,"primary_key":false},{"name":"title_text","type":"TEXT","nullable":true,"primary_key":false},{"name":"meta_description","type":"TEXT","nullable":true,"primary_key":false},{"name":"h1_count","type":"INT","nullable":false,"primary_key":false},{"name":"word_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":"schema_found","type":"TINYINT(1)","nullable":false,"primary_key":false},{"name":"score","type":"INT","nullable":false,"primary_key":false},{"name":"findings","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/"}}