wp_cirm_site_crawl
StaticStores cirm site crawl data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| crawl_id | VARCHAR(40) | NO |
| url | TEXT | NO |
| source | VARCHAR(40) | NO |
| http_status | INT | YES |
| final_url | TEXT | YES |
| redirect_count | INT | NO |
| title_text | TEXT | YES |
| title_length | INT | NO |
| meta_description | TEXT | YES |
| meta_description_length | INT | NO |
| h1_count | INT | NO |
| h1_text | TEXT | YES |
| canonical_url | TEXT | YES |
| noindex | TINYINT(1) | NO |
| word_count | INT | NO |
| image_count | INT | NO |
| image_missing_alt | INT | NO |
| internal_links | INT | NO |
| external_links | INT | NO |
| issue_count | INT | NO |
| issues | LONGTEXT | YES |
CREATE TABLE Statement
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};");Safe to delete?
If you have uninstalled LineSW Search Rank Monitor, this table is generally safe to remove. However, always back up your database first.
Note: Some plugins share tables or are dependencies of other plugins. Verify nothing else depends on this table before dropping it.
How to remove this table
DROP TABLE IF EXISTS `wp_cirm_site_crawl`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from LineSW Search Rank Monitor