Jacek Pyziak
b2aead1fbe
- Updated CRON documentation to include DataForSEO metrics synchronization. - Enhanced SettingsController to manage DataForSEO API credentials and settings. - Modified SiteController to handle DataForSEO domain input. - Updated Site model to accommodate DataForSEO data handling. - Added methods in SiteSeoMetric model for DataForSEO data retrieval and validation. - Implemented SiteSeoSyncService to synchronize SEO metrics from both SEMSTORM and DataForSEO. - Enhanced dashboard templates to display indexed pages data. - Updated settings and site creation/edit templates to include DataForSEO fields. - Created migration for adding DataForSEO related columns in the database. - Developed DataForSeoService to fetch indexed pages count from DataForSEO API.
8 lines
238 B
SQL
8 lines
238 B
SQL
-- BackPRO DataForSEO indexed pages integration
|
|
ALTER TABLE sites
|
|
ADD COLUMN dataforseo_domain VARCHAR(255) NULL AFTER semstorm_domain;
|
|
|
|
ALTER TABLE site_seo_metrics
|
|
ADD COLUMN indexed_pages INT NOT NULL DEFAULT 0 AFTER traffic;
|
|
|