wp_cirm_competitors
StaticStores cirm competitors data created by this plugin.
Column Definitions
| Column | Type | Nullable |
|---|---|---|
| 🔑id | BIGINT UNSIGNED | NO |
| engine | VARCHAR(30) | NO |
| device | VARCHAR(20) | NO |
| domain | VARCHAR(255) | NO |
| title | TEXT | YES |
| url | TEXT | YES |
| position | INT | NO |
CREATE TABLE Statement
CREATE TABLE wp_cirm_competitors ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, keyword_id BIGINT UNSIGNED NOT NULL, engine VARCHAR(30) NOT NULL, device VARCHAR(20) NOT NULL DEFAULT 'desktop', domain VARCHAR(255) NOT NULL, title TEXT NULL, url TEXT NULL, position INT NOT NULL DEFAULT 0, checked_at DATETIME NOT NULL, PRIMARY KEY (id), KEY keyword_engine_date (keyword_id, engine, device, 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_competitors`;
Run this query using phpMyAdmin, Adminer, or your MySQL client. Back up first.
Other tables from LineSW Search Rank Monitor