{"table_name":"cirm_competitors","full_table_name":"wp_cirm_competitors","description":"Stores cirm competitors data created by this plugin.","detection_method":"static","confidence":"high","create_sql":"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};\");","columns":[{"name":"id","type":"BIGINT UNSIGNED","nullable":false,"primary_key":true},{"name":"engine","type":"VARCHAR(30)","nullable":false,"primary_key":false},{"name":"device","type":"VARCHAR(20)","nullable":false,"primary_key":false},{"name":"domain","type":"VARCHAR(255)","nullable":false,"primary_key":false},{"name":"title","type":"TEXT","nullable":true,"primary_key":false},{"name":"url","type":"TEXT","nullable":true,"primary_key":false},{"name":"position","type":"INT","nullable":false,"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/"}}